Dell Case Analysis
Dell Case Analysis
Dell Case Analysis
ANOVA
Are the three price-sensitive groups based on q9_5per as derived in Chapter 14 different in terms of each of the evaluations
of Dell (q8_1 to q8_13)? Interpret the results.
(The three price sensitive groups are: Would have purchased, Might or might not have purchased and Would not have
purchased)
As the three price-sensitive groups based on q9_10per as derived in Chapter 14 different in terms of each of the evaluations
of Dell (q8_1 to q8_13)? Interpret the results.
Do the demographic groups as recoded in chapter 14 (recoded q11, q12, q13) and q14 differ in terms of overall satisfaction
with Dell computers (q4)? Interpret the results.
(The demographic groups as recoded in Chapter 14 are: Education: High School Graduate or less, College or technical School,
College graduate or higher. Age: 18-29, 30-39, 40-49 and 50 & older. Income: Under 30,000, 30000-49,999, 50,000-74,999,
75000-99,999 and 100000 & over. Gender: Male and Female)
Do the demographic groups as recoded in Chapter 14 (recoded q11, q12, q13) and q14 differ in terms of likelihood of
choosing Dell computers (q6)? Interpret the results.
(The demographic groups as recoded in Chapter 14 are: Education: High School Graduate or less, College or technical School,
College graduate or higher. Age: 18-29, 30-39, 40-49 and 50 & older. Income: Under 30,000, 30000-49,999, 50,000-74,999,
75000-99,999 and 100000 & over. Gender: Male and Female)
OUTPUT
Are the three price-sensitive groups based on q9_5per as derived in Chapter 14 different in terms of each of the evaluations of Dell
(q8_1 to q8_13)? Interpret the results. dell output\Dell 16 ANOVA 1.spv
(The three price sensitive groups are: Would have purchased, Might or might not have purchased and Would not have purchased)
As the three price-sensitive groups based on q9_10per as derived in Chapter 14 different in terms of each of the evaluations of Dell
(q8_1 to q8_13)? Interpret the results. dell output\Dell 16 ANOVA 2.spv
Do the demographic groups as recoded in chapter 14 (recoded q11, q12, q13) and q14 differ in terms of overall satisfaction with Dell
computers (q4)? Interpret the results. dell output\Dell 16 ANOVA 3.spv
(The demographic groups as recoded in Chapter 14 are: Education: High School Graduate or less, College or technical School, College
graduate or higher. Age: 18-29, 30-39, 40-49 and 50 & older. Income: Under 30,000, 30000-49,999, 50,000-74,999, 75000-99,999 and
100000 & over. Gender: Male and Female)
Do the demographic groups as recoded in Chapter 14 (recoded q11, q12, q13) and q14 differ in terms of likelihood of choosing Dell
computers (q6)? Interpret the results. dell output\Dell 16 ANOVA 4.spv
(The demographic groups as recoded in Chapter 14 are: Education: High School Graduate or less, College or technical School, College
graduate or higher. Age: 18-29, 30-39, 40-49 and 50 & older. Income: Under 30,000, 30000-49,999, 50,000-74,999, 75000-99,999 and
100000 & over. Gender: Male and Female)
RESULTS
For answering the above questions we look into the ANOVA Table provided and look into the F-Test
Univariate statistics for determining the amount of variability and its respective significance value.
Only q8_1, q8_3, q8_4, and q8_12 are different for the three groups based on q9_5per. In general, those who
would have purchased exhibit the highest ratings and those who would not have purchased exhibit the
lowest ratings.
Only q8_1, q8_2, q8_3, and q8_4 are different for the three groups based on q9_10per. In general, those who
would have purchased exhibit the highest ratings.
None of the demographic variables differ in terms of overall satisfaction with Dell.
REGRESSION
Can the overall satisfaction (q4) be explained in terms of all 13 evaluations of Dell (q8_1 to q8_13)?
Interpret the results.
Can the likelihood of choosing Dell (q6) be explained in terms of all 13 evaluations of Dell (q8_1 to
q8_13)? Interpret the results.
Can price sensitivity ratings of q9_5per be explained in terms of all 13 evaluations of Dell (q8_1 to
q8_13) when the independent variables are considered simultaneously? Interpret the results.
Can price sensitivity ratings of q9_10per be explained in terms of all 13 evaluations of Dell (q8_1 to
q8_13) when the independent variables are considered simultaneously? Interpret the results.
Analyse>Regression>Linear
Click Okay
OUTPUT
Can the overall satisfaction (q4) be explained in terms of all 13 evaluations of Dell (q8_1 to q8_13)?
Interpret the results. dell output\Dell 17 Regression 1f.spv
Can the likelihood of choosing Dell (q6) be explained in terms of all 13 evaluations of Dell (q8_1 to
q8_13)? Interpret the results. dell output\Dell 17 Regression 2f.spv
Can price sensitivity ratings of q9_5per be explained in terms of all 13 evaluations of Dell (q8_1 to
q8_13) when the independent variables are considered simultaneously? Interpret the results. dell
output\Dell 17 Regression 3f.spv
Can price sensitivity ratings of q9_10per be explained in terms of all 13 evaluations of Dell (q8_1 to
q8_13) when the independent variables are considered simultaneously? Interpret the results. dell
output\Dell 17 Regression 4f.spv
RESULTS
For answering the above questions we look into the table showing the standardized and unstandardized regression
coefficients and its respective significance value.
The regression is significant with an R square of 0.324 and an adjusted R square of 0.299. The coefficients for q8_4 and q8_8
are significant and negative. Thus, higher evaluations on these factors lead to greater satisfaction with Dell. Note that
satisfaction is measured so that lower numbers denote higher satisfaction whereas higher numbers denote more favorable
evaluations on q8_1 to q8_13. Hence, the negative sign of the coefficients.
The regression is significant with an R square of 0.191 and an adjusted R square of 0.161. The coefficients for q8_1, q8_4 and
q8_13 are significant and negative. The p value for the coefficient for q8_13 is 0.052. Thus, higher evaluations on these factors
lead to greater likelihood choosing Dell. Note that likelihood of choosing Dell is measured so that lower numbers denote higher
likelihood whereas higher numbers denote more favorable evaluations on q8_1 to q8_13. Hence, the negative sign of the
coefficients.
The regression of q9_5per on q8_1 to q8_13 is not significant. Thus, none of the evaluations of Dell explain the variation in
q9_5per. Note that the coefficient for q8_4 is significant but this does not mean much as the overall regression is not
significant.
The regression of q9_10per on q8_1 to q8_13 is not significant. Thus, none of the evaluations of Dell explain the variation in
q9_10per.
DISCRIMINANT ANALYSIS
Do the two group discriminant analysis with the two overall satisfaction groups derived based on the
recoding of q4 (as specified in chapter 14) as the dependent variable be explained in terms of all 13
evaluations of Dell (q8_1 to q8_13) as the independent variable? Interpret the results.
(The two overall satisfaction groups derived are: very satisfied as one group and rest as second group)
Analyse>Classify>Discriminant Analysis
Click Okay
OUTPUT
Do the two group discriminant analysis with the two overall satisfaction groups derived based on the
recoding of q4 (as specified in chapter 14) as the dependent variable be explained in terms of all 13
evaluations of Dell (q8_1 to q8_13) as the independent variable? Interpret the results. dell output\Dell
18 Discriminant 1.spv
RESULTS
For answering the above questions we look into the table showing the Canonical Discriminant Functions
and Standardized Canonical Discriminant Function Coefficients.
Given two groups, one discriminant function is extracted, which is significant. 73.6% of original grouped cases
and 71.1% of cross-validated grouped cases are correctly classified. The standardized canonical discriminant
function coefficients for q8_4, q8_6, and q8_8 are larger than those for the other variables indicating the
influence of these variables.
FACTOR ANALYSIS
Can evaluations of Dell (q8_1 to q8_13) be represented by a reduced set of factors? If so, what would
be the interpretation of these factors? (Hint: Do a principal components analysis with varimax
rotation)? Interpret the results.
Can the Market Maven, Innovativeness and opinion leadership items (variables q10_1 through q10_13)
be represented by a reduced set of factors? If so what would be the interpretation of these factors?
(Hint Do a principal components analysis with varimax rotation).
Click Okay
OUTPUT
Can evaluations of Dell (q8_1 to q8_13) be represented by a reduced set of factors? If so, what would
be the interpretation of these factors? (Hint: Do a principal components analysis with varimax
rotation)? Interpret the results. dell output\Dell 19 Factor Analysis 1.spv
Can the Market Maven, Innovativeness and opinion leadership items (variables q10_1 through q10_13)
be represented by a reduced set of factors? If so what would be the interpretation of these factors?
(Hint Do a principal components analysis with varimax rotation). dell output\Dell 19 Factor Analysis
2.spv
RESULTS
For answering the above questions we look into the table showing eigen value. Cumulative variance.
KMO test and Barletts test. We look into rotated factor matrix and then based on the loading of factors
we determine the dimensions and label the dimensions for easy interpretation.
The KMO and Bartletts test indicate that factor analysis is appropriate. Three factors are extracted. Based on the rotated
components matrix, factor 1 can be interpreted as an overall product, service, and value factor, factor 2 can be interpreted as
bundling and assembly, and factor 3 as ease of ordering and ease of accessing technical support.
The KMO and Bartletts test indicate that factor analysis is appropriate. Four factors are extracted. Based on the rotated
components matrix, factor 1 can be interpreted as information provider, factor 2 can be interpreted as innovator and early
adopter, factor 3 as opinion leader, and factor 4 as negative attitude toward innovation and experimentation.
CLUSTER ANALYSIS
How would you cluster the respondents based on the evaluations of Dell (q8_1 to q8_13)? Interpret the
results.
How would you cluster the respondents based on Market Maven, Innovativeness and opinion
leadership items (variables q10_1 through q10_13)? Interpret the resulting clusters.
In the cluster box check cases (default option). In the display box
check statistics and plots (default option).
Click Okay
OUTPUT
How would you cluster the respondents based on the evaluations of Dell (q8_1 to q8_13)? Interpret the
results. dell output\Dell 20 Clustering 1.spv, dell output\Dell 20 Cluster K-Means 1.spv
How would you cluster the respondents based on Market Maven, Innovativeness and opinion
leadership items (variables q10_1 through q10_13)? Interpret the resulting clusters. dell output\Dell 20
Clustering 2.spv, dell output\Dell 20 Cluster K-Means 2.spv
RESULTS
For answering the above questions we look into the table showing cluster distances. Cluster centers and
dendorogram then determine the profile of the clusters.
Hierarchical clustering using Wards procedure indicates that a four cluster solution is appropriate. This is followed by K-Means
clustering, selecting a four cluster solution. The resulting clusters contain 48, 83, 45, and 153 respondents.
Hierarchical clustering using Wards procedure indicates that a four cluster solution is appropriate. This is followed by K-Means
clustering, selecting a four cluster solution. The resulting clusters contain 119, 95, 64, and 72 respondents.
MULTI-DIMENTIONAL SCALING
MULTIDIMENSIONAL SCALING
(MDS)
Multidimensional scaling (MDS) is a class of procedures for
representing perceptions and preferences of respondents
spatially by means of a visual display.
CONDUCTING MULTIDIMENSIONAL
SCALING
Fig. 21.1
Formulate the Problem
CONDUCTING MULTIDIMENSIONAL
SCALING
FORMULATE THE PROBLEM
Specify the purpose for which the MDS results would be used.
Select the brands or other stimuli to be included in the analysis. The number of
brands or stimuli selected normally varies between 8 and 25.
The choice of the number and specific brands or stimuli to be included should be
based on the statement of the marketing research problem, theory, and the
judgment of the researcher.
Perceptions
Direct (Similarity
Judgments)
Preferences
Derived (Attribute
Ratings)
CONDUCTING MULTIDIMENSIONAL
SCALING:
OBTAIN INPUT DATA
Perception Data: Direct Approaches. In direct approaches to gathering perception data, the respondents are asked to judge how
similar or dissimilar the various brands or stimuli are, using their own criteria. These data are referred to as similarity judgments.
Very
Very
Dissimilar
Similar
1 2
.
.
.
Colgate vs. Aqua-Fresh 1
Aqua-Fresh
Crest
Colgate
Aim
Gleem
Plus White
Ultra Brite
Close-Up
Pepsodent
Sensodyne
Aqua-Fresh
Crest
Colgate
Aim
Gleem
Plus White
Ultra Brite
Close-Up
5
6
4
2
3
2
2
2
1
7
6
3
3
2
2
2
2
6
4
4
2
2
2
4
5
4
3
2
2
2
5
5
6
6
4
5
5
6
3
6
7
3
6
4
Pepsodent Sensodyne
CONDUCTING MULTIDIMENSIONAL
SCALING:
OBTAIN INPUT DATA
data are attribute-based approaches requiring the respondents to rate the brands or stimuli
on the identified attributes using semantic differential or Likert scales.
Whitens
Does not
teeth
___ ___ ___ ___ ___ ___ ___ ___ ___ ___
Prevents tooth
decay
whiten teeth
___ ___ ___ ___ ___ ___ ___ ___ ___ ___
tooth decay
.
.
.
.
Pleasant
tasting
Unpleasant
___ ___ ___ ___ ___ ___ ___ ___ ___ ___
tasting
If attribute ratings are obtained, a similarity measure (such as Euclidean distance) is derived
for each pair of brands.
CONDUCTING MULTIDIMENSIONAL
SCALING: OBTAIN INPUT DATA DIRECT
VS. DERIVED APPROACHES
The direct approach has the following advantages and disadvantages:
The researcher does not have to identify a set of salient attributes.
The disadvantages are that the criteria are influenced by the brands or stimuli
being evaluated.
Furthermore, it may be difficult to label the dimensions of the spatial map.
CONDUCTING MULTIDIMENSIONAL
SCALING: OBTAIN INPUT DATA DIRECT
VS. DERIVED APPROACHES
The attribute-based approach has the following advantages and disadvantages:
It is easy to identify respondents with homogeneous perceptions.
The respondents can be clustered based on the attribute ratings.
CONDUCTING MULTIDIMENSIONAL
SCALING:
PREFERENCE DATA
Preference data order the brands or stimuli in terms of respondents'
preference for some property.
A common way in which such data are obtained is through preference
rankings.
Alternatively, respondents may be required to make paired comparisons
and indicate which brand in a pair they prefer.
Another method is to obtain preference ratings for the various brands.
The configuration derived from preference data may differ greatly from
that obtained from similarity data. Two brands may be perceived as
different in a similarity map yet similar in a preference map, and vice
versa.
CONDUCTING MULTIDIMENSIONAL
SCALING:
SELECT AN MDS PROCEDURE
Selection of a specific MDS procedure depends upon:
Whether perception or preference data are being scaled, or whether the
analysis requires both kinds of data.
The nature of the input data is also a determining factor.
Non-metric MDS procedures assume that the input data are ordinal, but
they result in metric output.
Metric MDS methods assume that input data are metric. Since the
output is also metric, a stronger relationship between the output and
input data is maintained, and the metric (interval or ratio) qualities of the
input data are preserved.
CONDUCTING MULTIDIMENSIONAL
SCALING:
DECIDE ON THE NUMBER OF
DIMENSIONS
A priori knowledge - Theory or past research may suggest a particular
number of dimensions.
0.3
Stress
0.2
0.1
0.0
0
1
2
3
Number of Dimensions
CONDUCTING MULTIDIMENSIONAL
SCALING:
LABEL THE DIMENSIONS AND INTERPRET THE CONFIGURATION
1.5
1.0
0.5
0.0
-0.5
Plus White
Ultra Brite
Aim
Gleem
Crest
Pepsodent
Colgate
Close Up
Aqua-Fresh
-1.0
-1.5
Sensodyne
-2.0
-2.0 -1.5 -1.0 -0.5
0.0
0.5 1.0
1.5
2.0
Plus White
Ultra Brite
Gleem
-1.5
Crest
Fights
Cavities
Pepsodent
Close Up
-0.5
-1.0
Aim
Whitens Teeth
Colgate
Aqua-Fresh
Sensodyne
Sensitivity Protection
-2.0
-2.0 -1.5 -1.0 -0.5 0.0 0.5 1.0
1.5
2.0
CONDUCTING MULTIDIMENSIONAL
SCALING:
ASSESS RELIABILITY AND VALIDITY
The index of fit, or R-square is a squared correlation index that indicates the
proportion of variance of the optimally scaled data that can be accounted for
by the MDS procedure. Values of 0.60 or better are considered acceptable.
Stress values are also indicative of the quality of MDS solutions. While Rsquare is a measure of goodness-of-fit, stress measures badness-of-fit, or
the proportion of variance of the optimally scaled data that is not accounted
for by the MDS model. Stress values of less than 10% are considered
acceptable.
If an aggregate-level analysis has been done, the original data should be split
into two or more parts. MDS analysis should be conducted separately on
each part and the results compared.
CONDUCTING MULTIDIMENSIONAL
SCALING:
ASSESS RELIABILITY AND VALIDITY
Stimuli can be selectively eliminated from the input data and the solutions
determined for the remaining stimuli.
A random error term could be added to the input data. The resulting data
are subjected to MDS analysis and the solutions compared.
The input data could be collected at two different points in time and the
test-retest reliability determined.
ASSESSMENT OF
STABILITY BY
DELETING ONE BRAND
Fig. 21.6
2.0
1.5
Aqua-Fresh
1.0
Plus White
0.5
0.0
-0.5
-1.0
Close Up
Pepsodent
Colgate
Crest
Ultra Brite
Gleem
Aim
-1.5
-2.0
-2.0 -1.5 -1.0 -0.5
1.5
2.0
EXTERNAL ANALYSIS OF
PREFERENCE DATA
Fig. 21.7
2.0
1.5
1.0
Plus White
Ultra Brite
0.5
Gleem
Pepsodent
0.0
-0.5
-1.0
-1.5
Close Up
Aim
Crest Ideal Point
Colgate
Aqua-Fresh
Sensodyne
-2.0
-2.0 -1.5 -1.0 -0.5
1.5
2.0
CONJOINT ANALYSIS
CONJOINT
ANALYSIS
Conjoint analysis attempts to determine the relative importance consumers
attach to salient attributes and the utilities they attach to the levels of
attributes.
The respondents are presented with stimuli that consist of combinations of
attribute levels and asked to evaluate these stimuli in terms of their desirability.
Conjoint procedures attempt to assign values to the levels of each attribute, so
that the resulting values or utilities attached to the stimuli match, as closely as
possible, the input evaluations provided by the respondents.
CONDUCTING CONJOINT
ANALYSIS
Fig. 21.8
CONDUCTING CONJOINT
ANALYSIS: FORMULATE THE
PROBLEM
CONDUCTING CONJOINT
ANALYSIS: CONSTRUCT THE
STIMULI
In the pairwise approach, also called two-factor evaluations, the respondents evaluate
two attributes at a time until all the possible pairs of attributes have been evaluated.
Level
Attribute
Number
Sole
3
2
1
Rubber
Polyurethane
Plastic
Upper
3
2
1
Leather
Canvas
Nylon
Price
3
2
1
$30.00
$60.00
$90.00
Description
FULL-PROFILE APPROACH TO
COLLECTING CONJOINT DATA
Table 21.3
Made of rubber
Upper
Made of nylon
Price
$30.00
Fig. 21.9
Rubber
U
p
p
e
r
Sole
Polyurethane
Rubber
Plastic
P
r
i
c
e
Leather
Canvas
$30.00
$60.00
$90.00
Nylon
Price
$ 30.00
U
p
p
e
r
Leather
Canvas
Nylon
$60.00
$90.00
Polyurethane
Plastic
CONDUCTING CONJOINT
ANALYSIS: CONSTRUCT THE
STIMULI
A special class of fractional designs, called orthogonal arrays, allow for the
efficient estimation of all main effects. Orthogonal arrays permit the
measurement of all main effects of interest on an uncorrelated basis. These
designs assume that all interactions are negligible.
Generally, two sets of data are obtained. One, the estimation set, is used to
calculate the part-worth functions for the attribute levels. The other, the
holdout set, is used to assess reliability and validity.
Attribute Levels
Profile No.
1
2
3
4
5
6
7
8
9
a
Sole
1
1
1
2
2
2
3
3
3
Upper Price
1
1
2
2
3
3
1
2
2
3
3
1
1
3
2
1
3
2
Preference
Rating
9
7
5
6
5
6
5
7
6
U(X ) =
i =1
ki
a x
j =1
ij
ij
Where:
U(X) = overall utility of an alternative
a
ij
xij
ki
= number of attributes
the part-worths,
I
I
i
i =1
So that
W i = 1
i =1
The simplest estimation procedure, and one which is gaining in popularity, is dummy variable
regression (see Chapter 17). If an attribute has ki levels, it is coded in terms of ki - 1 dummy
variables (see Chapter 14).
Other procedures that are appropriate for non-metric data include LINMAP, MONANOVA, and
the LOGIT model.
ANALYSIS:
ESTIMATING THE CONJOINT
MODEL
The model estimated may be represented as:
X3, X4
X5, X6
X1
X2
Level 1
Level 2
Level 3
Preference
Attributes
Ratings
Sole
Upper
Price
Y
X1
X2
X3
X4 X5 X6
9
7
5
6
5
6
5
7
6
1
1
1
0
0
0
0
0
0
0
0
0
1
1
1
0
0
0
1
0
0
1
0
0
1
0
0
0
1
0
0
1
0
0
1
0
1
0
0
0
0
1
0
1
0
0
1
0
1
0
0
0
0
1
= 4.222
b1
= 1.000
b2
= -0.333
b3
= 1.000
b4
= 0.667
b5
= 2.333
b6
= 1.333
Given the dummy variable coding, in which level 3 is the base level, the
coefficients may be related to the part-worths:
a11 - a13 = b1
a12 - a13 = b2
CONDUCTING CONJOINT
ANALYSIS:
CALCULATION OF PART-WORTHS
To solve for the part-worths, an additional constraint is necessary.
a11
a12
a13
= 0.778
= -0.556
= -0.222
CONDUCTING CONJOINT
ANALYSIS: CALCULATION OF PARTWORTHS
The part-worths for other attributes reported in Table
21.6 can be estimated similarly.
For Upper, we have:
a 21 - a 23 = b3
a 22 - a 23 = b4
a 31 - a 33 = b5
a 32 - a 33 = b6
of part-worths
+ (1.111-(-1.222))
= 4.668
= 1.334/4.668 = 0.286
= 1.001/4.668 = 0.214
= 2.333/4.668 = 0.500
RESULTS OF CONJOINT
ANALYSIS
Table 21.6
Level
Attribute No. Description
Sole
2
1
Utility
3 Rubber
0.778
Polyurethane -0.556
Plastic
-0.222
0.286
Upper 3 Leather
0.445
2 Canvas
0.111
1 Nylon
-0.556
0.214
Price
2
1
0.500
3 $30.00
1.111
$60.00
0.111
$90.00
-1.222
Importance
CONDUCTING CONJOINT
ANALYSIS: INTERPRET THE
RESULTS
The utility values have only interval scale properties, and their origin is
arbitrary.
The relative importance of attributes should be considered.
ANALYSIS:
ASSESSING RELIABILITY AND
VALIDITY
The goodness of fit of the estimated model should be evaluated. For
example, if dummy variable regression is used, the value of R2 will indicate
the extent to which the model fits the data.
Test-retest reliability can be assessed by obtaining a few replicated
judgments later in data collection.
The evaluations for the holdout or validation stimuli can be predicted by the
estimated part-worth functions. The predicted evaluations can then be
correlated with those obtained from the respondents to determine internal
validity.
If an aggregate-level analysis has been conducted, the estimation sample can
be split in several ways and conjoint analysis conducted on each subsample.
The results can be compared across subsamples to assess the stability of
conjoint analysis solutions.
PART-WORTH FUNCTIONS
Fig. 21.10
0.0
0.0
Utility
-1.0
-1.5
-0.4
-0.8
-1.2
Leather
-2.0
Rubber Polyureth. Plastic
Canvas
Sole
Nylon
0.0
-0.5
Sole
-1.0
Utility
Utility
-0.5
-1.5
-2.0
-2.5
-3.0
$30
$60
Price
$90
SPSS WINDOWS
The multidimensional scaling program allows individual differences as
well as aggregate analysis using ALSCAL. The level of measurement can
be ordinal, interval or ratio. Both the direct and the derived approaches
can be accommodated.
4.
5.
6.
7.
Click OK.