(a) Use Excel to make a scatter plot of the following exam score data, placing Midterm on the X-axis and Final on the Y-axis, Add titles and modify the default colors, fonts. etc., as you judge appropriate to make the scatter plot effective. (b) Describe the relationship (if any) between X and Y. Weak? Strong? Negative? Positive? Linear? Nonlinear?
Exam Scores for 18 Statistics Students | |||||
Name | Midterm Score | Final Score | Name | Midterm | Final |
Score | Score | ||||
Aaron | 50 | 30 | Joe | 68 | 83 |
Angela | 95 | 83 | Lisa | 75 | 58 |
Brandon | 75 | 90 | Liz | 70 | 83 |
Buck | 60 | 83 | Michele | 60 | 73 |
Carole | 60 | 75 | Nancy | 88 | 78 |
Cecilia | 63 | 45 | Ryan | 93 | 100 |
Charles | 90 | 100 | Tania | 73 | 83 |
Dmitri | 88 | 90 | Ursula | 33 | 53 |
Ellie | 75 | 68 | Xiaodong | 60 | 70 |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.