USE: MS EXCEL
Please specify your answers, and provide the screen shot how you got the answers.
Q1: Regression of college GPA on ACT test for 12 students
Data Set is as following:
ACT |
GPA |
24 |
2.66 |
20 |
2.25 |
23 |
2.82 |
27 |
2.91 |
31 |
3.45 |
29 |
3.47 |
24 |
3.75 |
26 |
3.33 |
31 |
4 |
26 |
3.49 |
20 |
2.61 |
18 |
1.8 |
How to use ACT test score to predict GPA? Please provide the formula.
What is the correlation between these two factors? What does it mean?
What is the Coefficient of Determination (R Square) of the regression result? What does it mean?
Get Answers For Free
Most questions answered within 1 hours.