Course project C
Math 533 Week 7 Keller Graduate
School of Mgmt.
Prof. Nitin Dvivedi
, 1
Course Project Part
Part C: Regression and Correlation Analysis
Use the dependent variable (labeled Y) and one of the independent
variables (labeled X1, X2, and X3) in the data file. Select and use one
independent variable throughout this analysis. Use Excel to perform the
regression and correlation analysis to answer the following.
1. Generate a scatterplot for the specified dependent variable (Y) and
the selected independent variable (X), including the graph of the "best fit"
line. Interpret.
80
70
60
50
f(x) = 0.12x + 22.52 R² = 0.1
40
30
20
10
0
110 120 130 140 150 160 170 180 190 200 210
(Explained by Appendix I below)
2. Determine the equation of the "best fit" line, which describes the
relationship between the dependent variable and the selected
independent variable.
Using the data for calls and sales, the line of best fit, or linear regression equation, is
Math 533 Week 7 Keller Graduate
School of Mgmt.
Prof. Nitin Dvivedi
, 1
Course Project Part
Part C: Regression and Correlation Analysis
Use the dependent variable (labeled Y) and one of the independent
variables (labeled X1, X2, and X3) in the data file. Select and use one
independent variable throughout this analysis. Use Excel to perform the
regression and correlation analysis to answer the following.
1. Generate a scatterplot for the specified dependent variable (Y) and
the selected independent variable (X), including the graph of the "best fit"
line. Interpret.
80
70
60
50
f(x) = 0.12x + 22.52 R² = 0.1
40
30
20
10
0
110 120 130 140 150 160 170 180 190 200 210
(Explained by Appendix I below)
2. Determine the equation of the "best fit" line, which describes the
relationship between the dependent variable and the selected
independent variable.
Using the data for calls and sales, the line of best fit, or linear regression equation, is
