AutoSave OFF AH ? CG9 ... w 3650 Lab 1 - Statistical Analysis Worksheet_F22 Home Insert Draw Design Layout References Mailings Review View Table Design Layout . Tell me Share Comments Calibri (Bo... 11 AA Aa Ap AaBbCcDdEe AaBbCcDdEe Aa BbCcD AaBbCcDdE AaBbCcDdEe Paste BI Uva X X|A LA Norma No Spacing Heading 1 Heading 2 Heading 3 Styles Dictate Sensitivity Editor Pane 9. Use correlation to analyze Scenario B and complete Table B. Scenario B: The teacher examined the grades of students in her own class. She questioned whether there was a significant correlation between students' PE scores and their grades in her class. The data was as follows: Student PE Score Overall grade 15 85 8 70 16 93 21 97 1 00 VOUTAWNY 10 74 17 75 15 81 13 73 15 79 10 19 88 +Table B Specify the calculated r for this scenario (hint: r equals the square-root of R-squared) Interpret the meaning of the r value (hint: direction and strength of the relationship) What is the answer to the teacher's second question? Answer relative to the question as if you are reporting to someone that does not know or understand statistics List steps taken to calculate r-value in Excel and how determined answer to above question Page 3 of 3 1066 words English (United States Focus E + 160%