Essay Available:
Pages:
7 pages/≈1925 words
Sources:
-1
Style:
APA
Subject:
Accounting, Finance, SPSS
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 39.59
Topic:
Statistical Analysis on SPSS Data Set Accounting, Finance, SPSS Essay
Essay Instructions:
Some commonly employed statistical tests are the independent-samples t-test, paired-samples t-test, and One-Way ANOVA. In this assignment, you will practice conducting independent-samples t-tests, paired-samples t-tests, and One-Way ANOVAs from an SPSS data set.
General Requirements:
Use the following information to ensure successful completion of the assignment:
Review "SPSS Access Instructions" for information on how to access SPSS for this assignment.
Access the document, "Introduction to Statistical Analysis Using IBM SPSS Statistics, Student Guide" to complete the assignment.
Download the file "Census.sav" and open it with SPSS. Use the data to complete the assignment.
Download the file "SPSS_CUST.sav" and open it with SPSS. Use the data to complete the assignment.
Directions:
Locate the data set "Census.sav" and open it with SPSS. Follow the steps in section 7.14 Learning Activity as written. Answer questions 1-3 in the activity based on your observations of the SPSS output.Type your answers into a Word document. Copy and paste the full SPSS output including any supporting graphs and tables directly from SPSS into the Word document for submission to the instructor. The SPSS output must be submitted with the problem set answers in order to receive full credit for the assignment.
Locate the data set "SPSS_CUST.sav" and open it with SPSS. Follow the steps in section 8.10 Learning Activity as written. Answer all of the questions in the activity based on your observations of the SPSS output. Type your answers into a Word document. Copy and paste the full SPSS output including any supporting graphs and tables directly from SPSS into the Word document for submission to the instructor. The SPSS output must be submitted with the problem set answers in order to receive full credit for the assignment.
Locate the data set "Census.sav" and open it with SPSS. Follow the steps in section 9.20 Learning Activity as written. Answer questions 1-3 in the activity based on your observations of the SPSS output. Type your answers into a Word document. Copy and paste the full SPSS output including any supporting graphs and tables directly from SPSS into the Word document for submission to the instructor. The SPSS output must be submitted with the problem set answers in order to receive full credit for the assignment.
Essay Sample Content Preview:
Statistical Analysis on SPSS Data Set
Student's Name:
Institution:
Professor:
Unit Name & Number:
Date of Submission:
Statistical Analysis on SPSS Data Set
Activity 7.14
Question one
Boxplot of Respondent Socioeconomic index by Gender
Looking at the Boxplot outcome, we can aver that there is a similarity in the distributions between the male and female with respect to the socio-economic index. The median for males is 42.20, while that for females is 38.90.
Boxplot of Age of Respondent by Gender
There is a similarity between the age of the respondent when related to gender. The median for males and females is the same. The Boxplot shows the similarity between the distributions by gender.
Question two
T-Test for socio-economic by gender
RESPONDENTS SEX
N
Mean
Std. Deviation
Std. Error Mean
RESPONDENT SOCIO-ECONOMIC INDEX
MALE
887
49.109
19.4399
.6527
FEMALE
1024
48.458
19.5677
.6115
LINK Excel.Sheet.12 "Book1" "Sheet5!R9C4:R13C14" \a \f 4 \h \* MERGEFORMAT
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
RESPONDENT SOCIO-ECONOMIC INDEX
Equal variances assumed
.256
.613
.728
1909
.467
.6515
.8948
-1.1034
2.4065
Equal variances not assumed
.728
1873.685
.466
.6515
.8944
-1.1026
2.4057
The Levene's Test for Equality of Variances is 0.256, and the P-value is 0.467 for the T-test. Therefore, we don't reject the null hypothesis and thus conclude that there is no significant difference in the mean of a respondent socio-economic index between male and female.
T-Test for Age of the respondent by gender
RESPONDENTS SEX
N
Mean
Std. Deviation
Std. Error Mean
AGE OF RESPONDENT
MALE
926
47.45
16.548
.544
FEMALE
1087
47.93
18.011
.546
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
AGE OF RESPONDENT
Equal variances assumed
9.970
.002
-.626
2011
.531
-.486
.776
-2.008
1.036
Equal variances not assumed
-.630
1999.518
.529
-.486
.771
-1.998
1.026
The P-value is 0.531 which is greater than 0.05 thus we don't reject the null hypothesis and thus conclude that is no significant difference in mean of age of respondent between males and females.
Question three
Error Bar Chart of Mean Respondent Socioeconomic index by Respondents Sex
The figure above shows that the mean socio-economic index is the same as that of females, indicating no difference between the socio-economic index for the gender.
Error Bar Chart of Mean Age of Respondent by Respondents Sex
The figure above shows that respondents' mean age is the same as that of females, indicating that there is no difference between the age of respondent for the gender.
Question four
Boxplot of Respondent Socioeconomic index by race
The figure shows a difference between the mean of the socio-economic index by the race of the respondents.
Boxplot of Age of Respondent index by Race
The figure shows a difference between the mean of age respondents by the race of the household.
Question five
T-Test for Respondent socio-economic index by the race of household
Group Statistics
RACE OF HOUSEHOLD
N
Mean
Std. Deviation
Std. Error Mean
RESPONDENT SOCIO-ECONOMIC INDEX
WHITE
1502
49.794
19.4507
.5019
BLACK
254
43.258
18.5886
1.1664
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
RESPONDENT SOCIO-ECONOMIC INDEX
Equal variances assumed
5.558
.019
4.984
1754
.000
6.5355
1.3113
3.9635
9.1074
Equal variances not assumed
5.147
353.322
.000
6.5355
1.2698
4.0383
9.0327
Based on the table above, the p-value is 0.000, which is less than 0.05. Therefore, we reject the null hypothesis and conclude that there is a difference in means of the socio-economic index by the race of the respondent, i.e., between the blacks and whites.
T-Test for Age of Respondent by Race of household
Group Statistics
RACE OF HOUSEHOLD
N
Mean
Std. Deviation
Std. Error Mean
AGE OF RESPONDENT
WHITE
1582
49.19
17.409
.438
BLACK
271
44.09
16.795
1.020
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
AGE OF RESPONDENT
Equal variances assumed
.319
.572
4.484
1851
.000
5.106
1.139
2.873
7.339
Equal variances not assumed
4.600
376.367
.000
5.106
1.110
2.923
7.289
Based on the above table, the P-value is 0.000, which is less than 0.05 at a 5 percent significance level; thus, we conclude that there is a difference in respondents' mean age by the race of the household.
Question six
Error Bar Chart of Mean Respondent Socioeconomic index by Race of Household
The mean of black is greater than the mean of white; thus, there is a mean difference between the black and the white.
Error Bar Chart of Mean Age of Respondent by Respondents Sex
The above figure shows a greater mean for blacks than whites; this shows much difference between blacks and whites in terms of ages.
Question seven
To display the error bar chart with only the two white and black categories, the author excluded the other categories and only set black and white under the parameter's icon on the SPSS software.
Activity 8.10
Question one
Paired Samples Correlations
N
Correlation
Sig.
Pair 1
SPSS prods are a gd val & SPSS offers hi-quality prods
890
.451
.000
The table above shows that the correlation between SPSS products is good value and that SPSS offers high-quality products at 0.451 and is positive and statistically significant. This shows a difference between the means.
Paired Sample Test Table
Paired Differences
t
df
Sig. (2-tailed)
Mean
Std. Deviation
Std. Error Mean
95% Confidence Interval of the Difference
Lower
Upper
Pair 1
SPSS prods are a gd val - SPSS offers hi-quality prods
.579
.993
.033
.513
.644
17.381
889
.000
The above table's P-value is 0.000, which is less than 0.05; thus, we reject the null hypothesis and conclude that the means are different.
Question two
Paired Samples Correlations
N
Correlation
Sig.
Pair 1
SPSS prods are easy to learn & SPSS prods are easy to use
900
.811
.000
Based on the above table, the correlation value is 0.811 and is positive and statistically significant at a 5 percent significance level since the p-value is 0.000. The correlation between the two variables is very strong.
Paired Sample Test Table
Paired Differences
t
df
Sig. (2-tailed)
Mean
Std. Deviation
Std. Error Mean
95% Confidence Interval of the Difference
Lower
Upper
Pair 1
SPSS prods are easy to learn - SPSS prods are easy to use
-.006
.646
.022
-.048
.037
-.258
899
.796
From the above table, the P-value is 0.796, which is greater than 0.05 at a 5 percent significance level. We don't reject the null hypothesis and conclude there is no difference between the means.
Question three
Paired Samples Correlations
N
Correlation
Sig.
Pair 1
How long have you used SPSS products? & How frequently do you use SPSS
800
.210
.000
From the above table, the correlation is 0.210, which is positive and statistically significant, thus showing there isn't a strong relationship between the two variables.
Paired Sample Test Table
Paired Differences
t
df
Sig. (2-tailed)
Mean
Std. Deviation
Std. Error Mean
95% Confidence Interval of the Difference
Lower
Upper
Pair 1
How long have you used SPSS products? - How frequently do you use SPSS
-1.344
2.090
.074
-1.489
-1.199
-18.184
799
.000
Based on the above table, the P-value is 0.000, which is less than 0.05 at a 5 percent significance level. We reject the null hypothesis and conclude that there is a difference between the means.
Activity 9.20
Descriptive statistics
N
Mean
Std. Deviation
Std. Error
95% Confidence Interval for Mean
Minimum
Maximum
Lower Bound
Upper Bound
Less than primary/high school
297
5.73
4.691
.272
5.19
6.26
0
55
Primary/High School
1002
3.76
2.950
.093
3.58
3.94
0
37
Post Primary/High School
173
3.38
2.720
.207
2.97
3.79
0
17
BACHELOR
354
2.47
1.928
.102
2.26
2.67
0
14
GRADUATE
194
2.40
1.755
.126
2.15
2.65
0
8
Total
2020
3.66
3.187
.071
3.52
3.80
0
55
Question 2
Test of Homogeneity of Variances
NUMBER OF BROTHERS AND SISTERS
Levene Statistic
df1
df2
Sig.
31.134
4
2015
.000
Based on the above table, the null hypothesis is rejected since the sig. 0.000 is less than 0.05 at a 5 percent significance level. We conclude that there is homogeneity. We perform the Robust Tests of Equality of Means as shown below.
Robust Tests of Equality of Means
NUMBER OF BROTHERS AND SISTERS
Statistica
df1
df2
Sig.
Welch
53.271
4
610.320
.000
Brown-Forsythe
58.888
4
829.709
.000
a. Asymptotically F distributed.
From the above table, we reject the null hypothesis at a 5 percent significance level since the sig.0.000 is less than 0.05 and conclude that there is a difference between the number of brothers and sisters.
ANOVA
NUMBER OF BR...
Student's Name:
Institution:
Professor:
Unit Name & Number:
Date of Submission:
Statistical Analysis on SPSS Data Set
Activity 7.14
Question one
Boxplot of Respondent Socioeconomic index by Gender
Looking at the Boxplot outcome, we can aver that there is a similarity in the distributions between the male and female with respect to the socio-economic index. The median for males is 42.20, while that for females is 38.90.
Boxplot of Age of Respondent by Gender
There is a similarity between the age of the respondent when related to gender. The median for males and females is the same. The Boxplot shows the similarity between the distributions by gender.
Question two
T-Test for socio-economic by gender
RESPONDENTS SEX
N
Mean
Std. Deviation
Std. Error Mean
RESPONDENT SOCIO-ECONOMIC INDEX
MALE
887
49.109
19.4399
.6527
FEMALE
1024
48.458
19.5677
.6115
LINK Excel.Sheet.12 "Book1" "Sheet5!R9C4:R13C14" \a \f 4 \h \* MERGEFORMAT
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
RESPONDENT SOCIO-ECONOMIC INDEX
Equal variances assumed
.256
.613
.728
1909
.467
.6515
.8948
-1.1034
2.4065
Equal variances not assumed
.728
1873.685
.466
.6515
.8944
-1.1026
2.4057
The Levene's Test for Equality of Variances is 0.256, and the P-value is 0.467 for the T-test. Therefore, we don't reject the null hypothesis and thus conclude that there is no significant difference in the mean of a respondent socio-economic index between male and female.
T-Test for Age of the respondent by gender
RESPONDENTS SEX
N
Mean
Std. Deviation
Std. Error Mean
AGE OF RESPONDENT
MALE
926
47.45
16.548
.544
FEMALE
1087
47.93
18.011
.546
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
AGE OF RESPONDENT
Equal variances assumed
9.970
.002
-.626
2011
.531
-.486
.776
-2.008
1.036
Equal variances not assumed
-.630
1999.518
.529
-.486
.771
-1.998
1.026
The P-value is 0.531 which is greater than 0.05 thus we don't reject the null hypothesis and thus conclude that is no significant difference in mean of age of respondent between males and females.
Question three
Error Bar Chart of Mean Respondent Socioeconomic index by Respondents Sex
The figure above shows that the mean socio-economic index is the same as that of females, indicating no difference between the socio-economic index for the gender.
Error Bar Chart of Mean Age of Respondent by Respondents Sex
The figure above shows that respondents' mean age is the same as that of females, indicating that there is no difference between the age of respondent for the gender.
Question four
Boxplot of Respondent Socioeconomic index by race
The figure shows a difference between the mean of the socio-economic index by the race of the respondents.
Boxplot of Age of Respondent index by Race
The figure shows a difference between the mean of age respondents by the race of the household.
Question five
T-Test for Respondent socio-economic index by the race of household
Group Statistics
RACE OF HOUSEHOLD
N
Mean
Std. Deviation
Std. Error Mean
RESPONDENT SOCIO-ECONOMIC INDEX
WHITE
1502
49.794
19.4507
.5019
BLACK
254
43.258
18.5886
1.1664
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
RESPONDENT SOCIO-ECONOMIC INDEX
Equal variances assumed
5.558
.019
4.984
1754
.000
6.5355
1.3113
3.9635
9.1074
Equal variances not assumed
5.147
353.322
.000
6.5355
1.2698
4.0383
9.0327
Based on the table above, the p-value is 0.000, which is less than 0.05. Therefore, we reject the null hypothesis and conclude that there is a difference in means of the socio-economic index by the race of the respondent, i.e., between the blacks and whites.
T-Test for Age of Respondent by Race of household
Group Statistics
RACE OF HOUSEHOLD
N
Mean
Std. Deviation
Std. Error Mean
AGE OF RESPONDENT
WHITE
1582
49.19
17.409
.438
BLACK
271
44.09
16.795
1.020
Levene's Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
AGE OF RESPONDENT
Equal variances assumed
.319
.572
4.484
1851
.000
5.106
1.139
2.873
7.339
Equal variances not assumed
4.600
376.367
.000
5.106
1.110
2.923
7.289
Based on the above table, the P-value is 0.000, which is less than 0.05 at a 5 percent significance level; thus, we conclude that there is a difference in respondents' mean age by the race of the household.
Question six
Error Bar Chart of Mean Respondent Socioeconomic index by Race of Household
The mean of black is greater than the mean of white; thus, there is a mean difference between the black and the white.
Error Bar Chart of Mean Age of Respondent by Respondents Sex
The above figure shows a greater mean for blacks than whites; this shows much difference between blacks and whites in terms of ages.
Question seven
To display the error bar chart with only the two white and black categories, the author excluded the other categories and only set black and white under the parameter's icon on the SPSS software.
Activity 8.10
Question one
Paired Samples Correlations
N
Correlation
Sig.
Pair 1
SPSS prods are a gd val & SPSS offers hi-quality prods
890
.451
.000
The table above shows that the correlation between SPSS products is good value and that SPSS offers high-quality products at 0.451 and is positive and statistically significant. This shows a difference between the means.
Paired Sample Test Table
Paired Differences
t
df
Sig. (2-tailed)
Mean
Std. Deviation
Std. Error Mean
95% Confidence Interval of the Difference
Lower
Upper
Pair 1
SPSS prods are a gd val - SPSS offers hi-quality prods
.579
.993
.033
.513
.644
17.381
889
.000
The above table's P-value is 0.000, which is less than 0.05; thus, we reject the null hypothesis and conclude that the means are different.
Question two
Paired Samples Correlations
N
Correlation
Sig.
Pair 1
SPSS prods are easy to learn & SPSS prods are easy to use
900
.811
.000
Based on the above table, the correlation value is 0.811 and is positive and statistically significant at a 5 percent significance level since the p-value is 0.000. The correlation between the two variables is very strong.
Paired Sample Test Table
Paired Differences
t
df
Sig. (2-tailed)
Mean
Std. Deviation
Std. Error Mean
95% Confidence Interval of the Difference
Lower
Upper
Pair 1
SPSS prods are easy to learn - SPSS prods are easy to use
-.006
.646
.022
-.048
.037
-.258
899
.796
From the above table, the P-value is 0.796, which is greater than 0.05 at a 5 percent significance level. We don't reject the null hypothesis and conclude there is no difference between the means.
Question three
Paired Samples Correlations
N
Correlation
Sig.
Pair 1
How long have you used SPSS products? & How frequently do you use SPSS
800
.210
.000
From the above table, the correlation is 0.210, which is positive and statistically significant, thus showing there isn't a strong relationship between the two variables.
Paired Sample Test Table
Paired Differences
t
df
Sig. (2-tailed)
Mean
Std. Deviation
Std. Error Mean
95% Confidence Interval of the Difference
Lower
Upper
Pair 1
How long have you used SPSS products? - How frequently do you use SPSS
-1.344
2.090
.074
-1.489
-1.199
-18.184
799
.000
Based on the above table, the P-value is 0.000, which is less than 0.05 at a 5 percent significance level. We reject the null hypothesis and conclude that there is a difference between the means.
Activity 9.20
Descriptive statistics
N
Mean
Std. Deviation
Std. Error
95% Confidence Interval for Mean
Minimum
Maximum
Lower Bound
Upper Bound
Less than primary/high school
297
5.73
4.691
.272
5.19
6.26
0
55
Primary/High School
1002
3.76
2.950
.093
3.58
3.94
0
37
Post Primary/High School
173
3.38
2.720
.207
2.97
3.79
0
17
BACHELOR
354
2.47
1.928
.102
2.26
2.67
0
14
GRADUATE
194
2.40
1.755
.126
2.15
2.65
0
8
Total
2020
3.66
3.187
.071
3.52
3.80
0
55
Question 2
Test of Homogeneity of Variances
NUMBER OF BROTHERS AND SISTERS
Levene Statistic
df1
df2
Sig.
31.134
4
2015
.000
Based on the above table, the null hypothesis is rejected since the sig. 0.000 is less than 0.05 at a 5 percent significance level. We conclude that there is homogeneity. We perform the Robust Tests of Equality of Means as shown below.
Robust Tests of Equality of Means
NUMBER OF BROTHERS AND SISTERS
Statistica
df1
df2
Sig.
Welch
53.271
4
610.320
.000
Brown-Forsythe
58.888
4
829.709
.000
a. Asymptotically F distributed.
From the above table, we reject the null hypothesis at a 5 percent significance level since the sig.0.000 is less than 0.05 and conclude that there is a difference between the number of brothers and sisters.
ANOVA
NUMBER OF BR...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now: