week 12
Fyafee
bonus_assignment_1.xlsTest Scores & TV
| Test scores on XYZ exam and weekly hours watching TV | ||
| Test Score | TV hrs/wk | |
| 82 | 20 | |
| 80 | 40 | |
| 94 | 9 | |
| 90 | 8 | |
| 87 | 15 | |
| 98 | 5 | |
| 90 | 21 | |
| 93 | 13 | |
| 70 | 20 | |
| 90 | 6 | |
| Count | ||
| Mean | ||
| Median | ||
| Mode | ||
| Minimum | ||
| Maximum | ||
| SD | ||
| Calculate correlation (r and r2) only if you are answering question #6 | ||
| r = | ||
| r2 = |
Answer these questions 1-5 for a total of 1 bonus point:
1. What is the average test score for the group?
2. What is the average number of TV hours watched per week?
3. What was the most common test score?
4. What is the range of hours students watched TV per week?
5. What test scores did 68% of the people achieve?
Question 6 is worth 1 extra bonus point. You must have watched the correlation video to answer this question.
6. Describe the relationship between test scores and hours of TV watched per week.
