(the question should be done in Excel)

Q 3:

A national job placement company is interested in developing a model that might be used to explain the variation in starting salaries for college graduates based on the college GPA. The following data were collected through a random sample of the clients with which this company has been associated.

GPA	Starting Salary
3.20	$35,000
3.40	$29,500
2.90	$30,000
3.60	$36,400
2.80	$31,500
2.50	$29,000
3.00	$33,200
3.60	$37,600
2.90	$32,000
3.50	$36,000

Based on this sample information:

a) Calculate the correlation coefficient between these two variables.

b) Conduct a test of hypothesis to determine if there exists a correlation between the two variables in the population. Use a significance level of 0.05.

c) determine the least squares regression model. Also, develop a scatter plot of the data and locate the regression line on the scatter plot.