| | The following data show the results of an aptitude test (Y) and the GPA grade point average of 10 students who wants admission to a prestigious college. See next page for data. | Answer the questions with excel formula by using the following numbers "I need to see all formula when I click on the answers" |
| a. | Plot the scatter diagram and insert the trendline. |
| b. | Develop a least square estimated regression line. |
| c. | Compute the coefficient of determination and comment on the strength of the regression relationship. |
| d. | Compute the Correlation coefficient |
| e | Is the slope significant? Use a t test and let a = 0.05. |
| | | | Aptitude Test |
| | | | Score (Y) | GPA (X) |
| | | | 26 | 1.8 |
| | | | 31 | 2.3 |
| | | | 28 | 2.6 |
| | | | 30 | 2.4 |
| | | | 34 | 2.8 |
| | | | 38 | 3 |
| | | | 41 | 3.4 |
| | | | 44 | 3.2 |
| | | | 40 | 3.6 |
| | | | 43 | 3.8 |
kenyali333
Book1.xlsx
