In: Statistics and Probability
Assignment #6: Testing Correlations Directions: Use the Bivatiate Correlation function and the Options submenu to answer each of the questions based on the above scenario. The superintendent has continued the examination of data by examining the relationship between attendance rate and percent of students eligible for free or reduced priced lunch. The district data used for the analysis are contained below.
School 1 2 3 4 5 6 7 8 9 10 11 % Free or Reduced 70.4 49.4 58.9 65.1 50.5 58.9 32.7 55.8 59.7 65.4 53.8 Attendance Rate 93.3 93.7 95.6 93.6 94.6 94.6 95.7 92.3 94.3 91.8 95.3
School 12 13 14 15 16 17 18 19 20 21 22 % Free or Reduced 60.0 50.8 50.8 74.9 60.7 55.5 52.8 52.4 57.9 71.7 58.0 Attendance Rate 93.6 94.5 94.9 91.4 93.2 93.5 94.0 94.8 94.5 93.0 95.8
1. What is the mean percent of students receiving free or reduced lunch? What is the mean attendance rate? 2. What are the standard deviations for the percent of students receiving free or reduced lunch and attendance rate? 3. State an appropriate null hypothesis for this analysis. 4. What is the value of the correlation coefficient? 5. Based on the value of the correlation coefficient, how would you classify the strength of this relationship? 6. Based on the information from the scenario, what is the appropriate value for the degrees of freedom? 7. What is the reported level of significance? 8. Present the results as they might appear in an article.
I also need to know how to input the information into a SPSS Calculator