Research Proposal

profilepjain
SPSSAnalysisFinalForSubmission.docx

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.