An institutional research administrator believes that there is a direct relationship between a student's GPA and their score on a senior Aptitude Test. The following data show the results of 10 student's grade point averages (X) and their aptitude test score (Y).

GPA (X)	Aptitude Test Score (Y)
2.7	29
2.8	31
2.7	26.5
2.4	37
3.1	33
2.8	35
3.7	44
3.4	43
3.8	45

1. show scatter plot for the data. label axes.

1. Develop an estimated regression equation relating GPA and Aptitude Test score. Use the formulas and show notes.

1. If a student's GPA is 3.75, predict their Aptitude Test score.

1. Put the data above into an Excel spreadsheet. Run a regression analysis using the Data analysis tool package. Copy and paste the Output from Excel.

1. Use the output from your Excel Regression analysis. Interpret the coefficient of determination. Make sure you provide the numeric value and interpret the value in the context of this problem.

1. Use the output from your Excel Regression analysis. Interpret the correlation coefficient. Make sure to provide the numeric value and interpret the value in the context of this problem.

1. Use a t test to determine whether there is a relationship between GPA and the Aptitude test. Go to the PowerPoint notes and make sure you follow the same steps (ie define your hypotheses, the rejection rule etc). Thoroughly explain your findings.