EDR-8202: Statistics II-Basic Statistical Concepts and SPSS Functions

EDR-8202: Statistics II
Week 1 Worksheet
SPSS Week 1: Basic Statistical Concepts and SPSS Functions
You will now have the opportunity to become re-acquainted with SPSS, review some of the basic statistics used
in Statistics I, and enhance APA format when presenting statistical results.
The following small data set is from a study conducted within a single middle school. Fundamentally, this
study is a comparison of the differences between male and female teachers in personal Confidence Scores, and was conducted to determine if a relationship exists between the number of Years of Experience and Confidence
Scores.
Gender
Male
Male
Female
Male
Female
Female
Male
Male
Male
Female
Female
Male
Female
Female
Male
Female
Male
Female
Male
Female Years of Experience
15
3
12
8
23
9
37
14
10
4
11
1
3
7
2
21
28
9
5
3 Confidence Scores
110
117
118
120
104
100
107
115
114
115
115
100
117
115
103
145
115
115
110
210 Using scholarly writing and proper APA format, complete, and then submit the following:
1. Enter these data into an SPSS data file. Ensure the variables are correctly labeled (nominal, ordinal, scale).
Determine what question might be asked related to the Confidence Score of the last person in the data set.
2. Use SPSS to conduct basic descriptive statistics on the variables (e.g., frequency distribution, mean, median,
mode, standard deviation, standard error). 5.3.2017 © 2017 Northcentral University
10000 E. University Drive, Prescott Valley, Arizona 86314 USA
www.ncu.edu · p: 928-541-7777 · f: 928-541-7817 EDR-8202: Statistics II (continued)
3. Use SPSS to conduct a t-test to determine if a significant difference exists. Calculate the Pearson’s
Correlation between Years of Experience and Confidence Scores.
4. Use SPSS to create a scatter plot of Years of Experience and Confidence Scores.
5. Use scholarly writing and proper APA format to briefly discuss in narrative form, the results of the t-test and
the correlation.
6. Use scholarly writing and proper APA format to present a table that clearly depicts several of the descriptive
statistics calculated earlier.
7. Use scholarly writing and proper APA format to present a figure that depicting the scatter plot you generated
earlier.
8. Include an appendix that contains all SPSS output (copied and pasted) for the items above. 5.3.2017 © 2017 Northcentral University Page 2 of 2