week 12
Fyafee
bonus_assignment_2.xlsHours Studies & Scores
| Hours studied and scores by students on XYZ exam | ||
| Hours | Score | |
| 5 | 98 | |
| 1 | 72 | |
| 4 | 92 | |
| 3 | 84 | |
| 4 | 89 | |
| 3 | 86 | |
| 3 | 84 | |
| 3 | 81 | |
| 2 | 74 | |
| 2 | 71 | |
| 3 | 86 | |
| 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 number of hours students studied for this test?
2. How many hours did most of the students study?
3. What was the range of test scores?
4. What were the test scores for 95% of the students?
5. What was the average test score?
Question 6 is worth 1 extra bonus point. You must have watched the correlation video to answer this question.
6. Describe the relationship between hours studied and test scores.
Question 7 is worth 1 extra bonus point. (you have to figure this out by yourself or ask your team members).
7a. Make a graph showing the number of hours studied. Make sure it has a title and a legend.
7b. Make another type of graph showing the the hours studied.
