Use the following dataset: (sat.xls Download sat.xls) Information about this dataset can be found at: https://onlinestatbook.com/2/case_studies/sat.htmlLinks to an external site.

Submit an RScript file that includes your name in the file name (i.e. Kemper_HW9.R) and a word file with the results of each test you run and any resulting graphs.

Testing assumptions: Just test, don't bother with transformations.

High School GPA and University GPA

Calculate the correlation coefficient. Express the results properly in words. (5 pts)

Create a scatter plot comparing the two. (5 pts)

Do a simple linear regression. Include an assessment of assumptions and express your results in words and mathematically. (5 pts for assessing each assumption, 5 pts for the regression analysis and 5 pts for the correct reporting of the results)

Math SAT and Computer Science GPA

Calculate the correlation coefficient. Express the results properly in words.(5 pts)

Create a scatter plot comparing the two. (5 pts)

Do a simple linear regression. Include an assessment of assumptions and express your results in words and mathematically. (5 pts for assessing each assumption, 5 pts for the regression analysis and 5 pts for the correct reporting of the results)