Question

I need this answered using the SPSS Calculator. 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 12 13 14 15 16 17 18 19 20 21 22

% 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 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.3 93.7 95.6 93.6 94.6 94.6 95.7 92.3 94.3 91.8 95.3 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 need the answers using a SPSS Calculator.

Answer 1

yi 93.7 X, Yi Xi 55.6 65.L 3091-36 8179.69 5209.2 4230 ou582 69 2531.6y 107.56 91016 1409.% d892-49 363949 6432. 04 8379.69ヲ5:4.34 1056 2503100.5 2284 .84 0700.94 303 21 i01 3893.68733.565020 38.G u.3 93.7 95.4/ 93.6 95. У 35.2 4740 3443 9 36 62. 4 54 y9.L 65.9 70. 2.3 63.5 49-2 95.4 So 3 507c 41723.42 61287 94 96.2 93 2.5 94. 95. 5 2916 2410-8, y342.8 8649 4998.49 8556.25 G539-75 4035 2505562567 5285-296013.4 24206y 4698 645 IC 530. 0 8854.8 4733.23 3145 440779.695509.56 3214.966. 27 2510-0 i O&O6·24 4659:32 3306 25 8836 q544y q4-1 93. 93.I 919 42433.32 8.8 56.7 93. 2 92.9 525 8630, 41 S341.25 1I68.8 53:1272 Sum 94 3025.770

leam |上メ4656342-53. 127 204 14 25732 2 כב 0850__ excelshut tahl Null studeneliqibli Jo'r lunch and prce casrulationm 능x 10960, 21-4993. 964 14 25732 11200 S