Research Proposal
SPSS Analysis – DON’T FORGET TO WRITE THE MANAGERIAL RECOMMENDATIONS.
Introduction:
Dell has been commissioned to analyse the relationship of its computers in relation to the factors like income, education level, age and many other aspects. In addition to this there is also a need to understand how price sensitivity, usage for computer, hours spend on the internet/week and various other mentioned variables in the data set, where variables are also recoded as per the requirement of the data set to be transformed to perform the correct test on the correct variables. The report is structured to answer the question in data brief where Crosstabs, Independent Sample T-Tests, Paired Samples T-Tests and Regression analysis is performed to understand and interpret situations based on Hypothesis being developed for each of the eight questions.
Answer 1 2 – because the data Is categorical
Answer-1 Crosstabs
H 0- There is no significant relationship between recoded Question- Q4, Q5 and Q6 and the Recoded Demographics (Graduation, Income and Age)
H1- There is a significant relationship between recoded Question- Q4, Q5 and Q6 and the Recoded Demographics (Graduation, Income and Age)
This is a Two-Tailed Test
Level of Significance – 5% i.e. P < 0.05.
Final Answer
|
|
TEST NAME |
Income Q13 |
Education Q11 |
Age Q12 |
|
Q4 |
Chi-Sq |
|
|
|
|
Q5 |
Chi-Sq |
|
|
|
|
Q6 |
Chi-Sq |
|
|
|
— We cannot reject the H 0 as there is NO significant relationship between the mentioned test variables, where the level of Significance is more than 0.05 as can be seen above in each of the nine cases.
Answer-2 -- Develop Hypothesis Separately. – Crosstabs
H 0- There is no significant relationship between recoded Price Sensitivity (Q9_5% and Q9_10%) and the Recoded Demographics (Graduation, Income and Age)
H 1- There is a significant relationship between recoded Price Sensitivity (Q9_5% and Q9_10%) and the Recoded Demographics (Graduation, Income and Age)
Final Answer
|
|
Test Name |
Income Q13 |
Education Q11 |
Age Q12 |
|
Q9_5% |
Chi-Sq |
0.020 |
0.454 |
0.717 |
|
Q9_10% |
Chi-Sq |
0.511 |
0.511 |
0.629 |
This is a Two-Tailed Test
Level of Significance – 5% i.e. P < 0.05.
As seen above there is a significant relationship between the Income level and Price Sensitivity @ 5% higher price of the computer. So we can accept that. Also Write about Cramer’s V
And rest other we can cannot reject the null as there is NO Significant Relation between the variables.
Answer 3 - Independent Samples T-test- Mean difference is to found between the two samples.
Answer-3 - Equal to and NOT Equal to for the Hypothesis Development.
H 0 – There is NO significant different between means of Satisfied and unsatisfied customers (paired variables have equal means)
H 1 -- There is a significant different between means of Satisfied and dissatisfied customers (paired variables have unequal means)
Independent as we are comparing two different groups (independent variables) determining the Q8_1 to Q8_13. These are the evaluative Questions.
Focus on Mean Difference, Level of Sig and refer from week nine.
|
Variable |
Group |
Equality of Variance |
Mean Difference |
Sig. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Answer-4 - Independent as we are comparing two different groups (independent variables) determining the Q8_1 to Q8_13. These are the evaluative Questions. Equal To and Not Equal To- for the Hypothesis Development.
H 0 - There is no significant difference between means of satisfied and unsatisfied cus
Means of satisfied customer groups is not equal to means of unsatisfied customers.
Focus on Mean Difference, Level of Sig and refer from week nine.
|
Variable |
Group |
Equality of Variance |
Mean Difference |
Sig. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Focus on Mean Difference, Level of Sig and refer from week nine.
Answer -5
Answer5- Paired Sample. – 2 variables and one group , so finding the difference between the two variables.
H 0: – There is NO difference between Q8_1 and Q8_2.
H 1: There is a difference between Q8_1 and Q8_2.
Mean Q8_1: 7.745
Mean Q8_2: 7.582
Level of Significance- P—0.061 which is more than P value of 0.05 So, We cannot reject the null hypothesis.
|
Variable |
Mean |
Mean Difference |
Sig. |
|
Q8_1 |
|
0.159 |
|
|
|
|
|
|
Answer -6 Paired Sample
H 0: there is NO significant difference between the group Q8_6 and Q8_7
H 1: there is a significant difference between the group Q8_6 and Q8_7
- Mean Q8
_6: 7.504
Mean Q8_7: 7.648
Level of Significance- P—0.222— We cannot reject the null hypothesis. As the level of significance level is higher than 0.05.
|
Variable |
Mean |
Mean Difference |
Sig. |
|
|
|
-0.144 |
|
|
|
|
|
|
Answer 7:
H 0: There is NO Linear relationship between (Q8_1 to Q8_13) and Overall Satisfaction(Q4) of Dell
H 1: There is a Linear relationship between (Q8_1 to Q8_13) and Overall satisfaction(Q4) of Dell
|
Variables |
Modell: Overall Satisfaction --Standardised Beta Coefficients. |
|
Q8_1 |
-0.012 |
|
Q8_2 |
-0.093 |
|
Q8_3 |
-0.079 |
|
Q8_4 |
-0.226 |
|
Q8_5 |
-0.046 |
|
Q8_6 |
-0.118 |
|
Q8_7 |
0.017 |
|
Q8_8 |
-0.222 |
|
Q8_9 |
0.038 |
|
Q8_10 |
0.054 |
|
Q8_11 |
-0.015 |
|
Q8_12 |
-0.021 |
|
Q8_13 |
-0.055 |
|
R2 |
0.364 |
|
Adjusted R2 |
0.338 |
|
F- Value. |
13.898 |
|
|
|
|
|
|
Answer 8:
H 0: There is NO Linear relationship between (Q8_1 to Q8_13) and likelihood of Choosing Dell(Q6) of Dell
H 1: There is a Linear relationship between (Q8_1 to Q8_13) and likelihood of choosing Dell(Q6) of Dell
|
Variables |
Model: Likelihood of Choosing Dell -- Standardised Beta Coefficients. |
|
Q8_1 |
-0.152 |
|
Q8_2 |
0.022 |
|
Q8_3 |
-0.115 |
|
Q8_4 |
-0.135 |
|
Q8_5 |
0.038 |
|
Q8_6 |
-0.084 |
|
Q8_7 |
0.064 |
|
Q8_8 |
-0.120 |
|
Q8_9 |
0.101 |
|
Q8_10 |
-0.017 |
|
Q8_11 |
-0.013 |
|
Q8_12 |
-0.016 |
|
Q8_13 |
-0.112 |
|
R2 |
0.205 |
|
Adjusted R2 |
0.172 |
|
F- Value. |
6.257 |
APPENDIX:
RECODING OF THE OUTPUT
GET
FILE='C:\Users\paryu\Downloads\Case 1.1 Dell Data (1).sav'.
DATASET NAME DataSet1 WINDOW=FRONT.
DATASET CLOSE DataSet1.
RECODE q4 (1=1) (2 thru 4=2) INTO OverallQ4re.
VARIABLE LABELS OverallQ4re 'SatisfactionRecoded'.
EXECUTE.
RECODE q5 (1=1) (2 thru 5=2) INTO OverallQ5re.
VARIABLE LABELS OverallQ5re 'RecodedQ5'.
EXECUTE.
RECODE q6 (1=1) (2 thru 5=2) INTO overallQ6re.
VARIABLE LABELS overallQ6re 'recodedQ6'.
EXECUTE.
RECODE q9_5per (3=2) (1 thru 2=1) (4 thru 5=3) INTO Q9_5recoded.
VARIABLE LABELS Q9_5recoded 'Q9@5%recoded'.
EXECUTE.
RECODE q9_10per (4=2) (5=3) (1 thru 3=1) INTO Q9_10Recoded.
VARIABLE LABELS Q9_10Recoded 'Q9 10perc recoded'.
EXECUTE.
RECODE q11 (3=2) (4=3) (1 thru 2=1) INTO Q11_recoded.
VARIABLE LABELS Q11_recoded 'RecodedQ11'.
EXECUTE.
RECODE q12 (1 thru 3=1) (4 thru 5=2) (6 thru 7=3) (8 thru 14=4) INTO Q12_recoded.
VARIABLE LABELS Q12_recoded 'AgeRecoded'.
EXECUTE.
RECODE q13 (3=2) (4=3) (5=4) (6=5) (1 thru 2=1) INTO Q13_recoded.
VARIABLE LABELS Q13_recoded 'IncomeQ13Recoded'.
EXECUTE.
DATASET ACTIVATE DataSet2.
SAVE OUTFILE='C:\Users\paryu\Downloads\Case 1.1 Dell Data (2).sav'
/COMPRESSED.
SAVE OUTFILE='C:\Users\paryu\Downloads\Case 1.1 Dell Data (1).sav'
/COMPRESSED.
CROSSTABS
/TABLES=Q11_recoded Q12_recoded Q13_recoded BY OverallQ4re OverallQ5re overallQ6re
/FORMAT=AVALUE TABLES
/STATISTICS=CHISQ PHI
/CELLS=COUNT COLUMN
/COUNT ROUND CELL.
SPSS Analysis
–
DON’T FORGET TO WRITE THE MANAGERIAL RECOMMENDATIONS.
Introduction:
Dell has been commissioned to analyse the relationship of
its computers in relation to the factors
like income, education level, age and many other aspects. In addition to
this
there is also a need to
understand how price sensitivity, usage for computer, hours spend on the internet
/week
and various
other mentione
d variables in the data set
, where variables are also recoded as per the requirement
of the data set to be transformed to perform the correct test on the correct variables. The report is
structured to answer the question i
n
data brief where Crosstabs, Inde
pendent Sample T
-
Tests,
Paired Samples T
-
Tests and Regression analysis is performed to understand and interpret situations
based on Hypothesis being developed for each of
the
eight questions.
SPSS Analysis – DON’T FORGET TO WRITE THE MANAGERIAL RECOMMENDATIONS.
Introduction:
Dell has been commissioned to analyse the relationship of its computers in relation to the factors
like income, education level, age and many other aspects. In addition to this there is also a need to
understand how price sensitivity, usage for computer, hours spend on the internet/week and various
other mentioned variables in the data set, where variables are also recoded as per the requirement
of the data set to be transformed to perform the correct test on the correct variables. The report is
structured to answer the question in data brief where Crosstabs, Independent Sample T-Tests,
Paired Samples T-Tests and Regression analysis is performed to understand and interpret situations
based on Hypothesis being developed for each of the eight questions.