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). 7.22.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. 7.22.2017 2017 Northcentral University Page 2 of 2