Final Project: 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. The week 6 spreadsheet can be helpful in this work.

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.
2. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable.
3. Determine the correlation coefficient. Interpret.
4. Determine the coefficient of determination. Interpret.
5. Test the utility of this regression model by completing a hypothesis test of =0 using =0.10. Interpret results, including the p-value.
6. Based on the findings in steps 1-5, analyze the ability of the independent variable to predict the dependent variable.
7. Compute the confidence interval for , using a 95% confidence level. Interpret this interval.
8. Compute the 99% confidence interval for the dependent variable, for a selected value of the independent variable. Each student can choose a value to use for the independent variable (use same value in the next step). Interpret this interval.
9. Using the same chosen value for part (8), estimate the 99% prediction interval for the dependent variable. Interpret this interval.
10. What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.
11. Describe a business decision that could be made based on the results of this analysis. In other words, how might the business operations change based on these statistical results.
12. Final Project report is due by the end of Week 7.
13. Final Project is worth 130 total points. See grading rubric below.

Summarize your results from Steps 1-11. The report should explain and interpret the results in ways that are understandable to someone who does not know statistics.

Submission: The Word document, summary report should be submitted for questions 1-11. The Excel output can be included as an appendix, if needed.

Format for report:

1. Summary Report
2. Steps 1-11 addressed with appropriate output, graphs and interpretations. Be sure to number each step 1-11.

Sales (Y) Calls (X1) Time (X2) Years (X3) Type 37 117 14.8 0 GROUP 38 117 15.3 3 NONE 40 117 15.6 1 NONE 41 117 15.8 2 GROUP 37 120 18.2 2 GROUP 45 120 13.6 1 GROUP 43 131 16.8 4 GROUP 34 133 14.4 1 GROUP 37 133 15.2 2 GROUP 42 135 14.8 3 NONE 48 136 13.7 3 ONLINE 37 137 16.3 2 GROUP 39 138 15.5 1 NONE 45 138 19.3 4 GROUP 44 139 15.3 2 GROUP 45 140 13.6 1 GROUP 37 142 17.1 2 NONE 40 144 17.4 0 NONE 37 145 18 3 NONE 38 145 17.1 2 NONE 43 145 18.6 2 NONE 46 145 16.8 0 ONLINE 45 146 12 3 GROUP 37 148 15.7 3 GROUP 37 148 16.2 1 GROUP 42 148 16.9 1 NONE 43 148 15.9 1 ONLINE 43 148 14.5 4 ONLINE 44 148 13.5 3 GROUP 46 148 13.1 1 GROUP 39 149 18.8 1 GROUP 46 149 17.8 3 NONE 49 149 21.1 2 GROUP 40 150 10.8 1 GROUP 44 150 18.4 1 NONE 46 151 16 1 GROUP 37 152 19.8 0 GROUP 49 152 22.3 0 ONLINE 41 153 14.7 1 GROUP 42 153 15.5 2 GROUP 43 153 15.2 3 GROUP 46 153 14.1 1 ONLINE 42 154 14.8 2 ONLINE 41 155 13.6 3 GROUP 45 155 18.9 2 GROUP 39 156 13.3 4 NONE 48 156 15.1 4 ONLINE 41 157 11.5 3 ONLINE 47 157 14.3 1 GROUP 41 158 19.3 2 ONLINE 45 158 13.9 1 ONLINE 44 159 18.1 2 ONLINE 42 160 10.6 3 NONE 49 160 13.6 3 GROUP 49 161 16.1 3 NONE 46 162 16.2 2 ONLINE 46 162 12.1 1 GROUP 45 164 16.7 3 NONE 47 164 15.3 0 ONLINE 48 165 19.8 5 ONLINE 43 166 17.6 3 ONLINE 49 166 16.2 0 ONLINE 42 167 17.7 3 ONLINE 42 167 18 2 NONE 50 167 12.6 5 ONLINE 50 167 16.2 1 ONLINE 43 169 13.3 4 NONE 44 169 8.9 0 ONLINE 44 169 13.6 1 ONLINE 44 171 13.6 3 GROUP 48 171 13 2 GROUP 46 172 12.5 1 ONLINE 43 173 19.8 2 ONLINE 45 173 17.6 2 ONLINE 51 173 18.6 0 ONLINE 48 174 18.6 2 GROUP 57 174 10.8 2 NONE 48 175 13.7 1 ONLINE 47 176 14.1 2 ONLINE 45 177 14.2 2 GROUP 48 177 13.9 3 ONLINE 50 177 11.4 4 NONE 52 177 14.5 1 ONLINE 53 178 13.2 2 ONLINE 54 180 11.8 4 GROUP 44 182 15.5 4 NONE 53 182 10.5 1 ONLINE 47 183 12.8 2 ONLINE 49 184 16.7 2 ONLINE 50 184 15.6 2 ONLINE 53 184 15.2 0 ONLINE 45 185 13.3 1 ONLINE 44 188 12.9 3 GROUP 47 120 16.3 1 NONE 49 188 20.4 1 NONE 58 189 12 1 ONLINE 50 190 11.3 1 ONLINE 47 193 13.5 2 ONLINE 50 197 14 2 ONLINE 58 197 11.8 1 ONLINE SALES represents the number of sales made in one week. CALLS represents the number of calls made in that week. TIME represents the average time per call in that week. YEARS represents years of experience the employee had in the call center. TYPE represents the type of training the employee received.