STAT 2305 HCCS Regression Analysis Starting Salary Case Project

STAT 2305 Project 2 — Regression AnalysisStarting Salary Case
Instructions: Use Excel to complete the following questions. Attach copies of the Excel pages
or embed the Excel work in your write-up.
Marketing Graduate
GPA (x)
1
2
3
4
5
6
7
3.26
2.60
3.35
2.86
3.82
2.21
3.47
Starting Salary (y in
thousands of dollars)
33.8
29.8
33.5
30.4
36.4
27.6
35.3
The marketing department at a large state university undertook a study to relate starting salary
(y) after graduation for marketing majors to grade point average (GPA) in major courses. To do
this, records of seven recent marketing graduates were randomly selected, and the data shown
above were obtained.
For this project, do the following:
1. Input the data into Excel
2. Create a scatter plot of the data points
3. Perform a linear regression analysis to determine the regression equation and the
coefficient of determination.
4. Plot the line of the regression equation on your scatter plot.
Respond in writing to the following:
1. Report the linear regression equation produced from Excel. (Display the scatterplot with
the regression line included)
2. What is the value of Pearson’s correlation coefficient r?
3. Is Pearson’s correlation coefficient r positive or negative? What does this imply about the
relationship between the factors in this study?
4. What is the implication of any correlation found between the variables in this analysis?
5. Does this correlation imply a causal relationship? Explain.
For this Project, you will submit a spreadsheet with Excel output and a written report.