Chpt 4 | ||||||
Using Excel, create a scatter diagram of the data shown below | ||||||
including the linear equation of the relationship & the | ||||||
r2coefficient. Make it look professional & colorful. | ||||||
Explain what the chart shows. | ||||||
Hours of Study/ week | gpa | |||||
2 | 1.6 | |||||
1 | 1.1 | |||||
5 | 1.8 | |||||
6 | 2 | |||||
7 | 2.1 | |||||
21 | 3.9 | |||||
14 | 3 | |||||
16 | 3.1 |
Explanation about the data:
the data is given about the hours of study per week as one variable and resulting GPA as depending variable
from the chart it can be shown that there is highly positive correlation between the two variable means hours of study has high effect on the resulting gpa.
so there is a high degree of relationship between hours of study and resulting gpa.
Get Answers For Free
Most questions answered within 1 hours.