Question: An instructor hypothesizes that as total hours spent studying for her class increase, the score on her final exam increases. Use Excel to create a
An instructor hypothesizes that as total hours spent studying for her class increase, the score on her final exam increases. Use Excel to create a scatterplot of the data below. Add a tile and label the axes clearly.
Save your Excel file. Then link your Excel file below. PLEASE INCLUDE THE EXCEL FILE FOR BETTER CLARIFICATION.
Based on the scatter plot you created in Excel, state if what the instructor thinks appears to be true.
Student ID | Hours spent on course | Final Exam Score |
1 | 10.9 | 94 |
2 | 8.1 | 81 |
3 | 1.6 | 45 |
4 | 13.5 | 89 |
5 | 6.0 | 85 |
6 | 8.7 | 87 |
7 | 11.3 | 96 |
8 | 18.4 | 97 |
9 | 9.0 | 89 |
10 | 2.4 | 53 |
11 | 11.9 | 83 |
12 | 5.4 | 60 |
13 | 6.7 | 71 |
14 | 6.3 | 67 |
15 | 8.3 | 82 |
16 | 11.4 | 93 |
17 | 3.5 | 56 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
