Use the dependent variable (labeled Y) andoneof 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 b=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 b, 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.

File Home Insert Draw Page Layout Formulas Data Review Verdana 10 a9 Wrap Te Paste BIU Merge 8 Clipboard Font Alignment A2 X V 48 A B C D E F 54 40 157 15.4 ONLINE 55 48 167 14.8 ONLINE 56 50 144 15.8 NONE 57 44 168 12.4 -NUNNWA GROUP 58 43 175 13.6 GROUP 59 33 150 14.9 GROUP 60 32 155 17.9 GROUP 61 46 163 16.6 ONLINE 62 48 162 14.5 WAN GROUP 63 56 189 15.0 ONLINE 64 44 153 15.3 ONLINE 65 34 158 14.2 66 ONLINE 43 160 10.9 67 ONLINE 33 173 17.5 68 ONLINE 49 178 18.3 69 GROUP 50 189 14 .3 70 52 ONLINE 184 11.4 71 HONAHNI 45 ONLINE 174 13.6 72 48 ONLINE 188 13.6 73 35 ONLINE 149 15.6 74 44 GROUP 159 14.6 75 44 GROUP 160 76 14.8 67 ONLINE 166 18.9 77 51 GROUP 178 78 16.5 41 178 ONLINE 79 13 .4 40 ONLINE 176 12.6 NEN 80 45 138 ONLINE 15. 3 NONE MATH533 Course Project Data SAL Course Project Part A solution Ready Type here to search OVerdana 10 ED Wrap EP Paste B E Merge Clipboard Font Alignment A2 X V f 48 A B C D E 28 44 192 16.7 GROUP 29 44 165 12.4 3 ONLINE 30 39 150 15.3 3 GROUP 31 43 174 12.7 2 ONLINE 32 42 168 16.4 ONLINE 33 49 178 15.1 ONLINE 34 41 164 17.8 GROUP 35 40 191 19.0 ONLINE 36 37 132 10.0 NONE 37 36 140 15.7 NONE 38 46 171 14.9 ONLINE 39 41 170 12.3 ONLINE 40 49 153 19.0 GROUP 41 42 154 14.3 42 37 GROUP 142 13.9 43 37 NONE 130 16.9 HE N N DA D P UP ON W N W OUT OMWWO 44 21 NONE 177 17.0 45 39 ONLINE 160 14.3 46 44 NONE 134 47 19.4 49 GROUP 131 14.6 48 35 130 GROUP 49 19.4 46 183 NONE 50 15.4 43 169 ONLINE 51 14.0 41 155 GROUP 52 48 16.0 182 ONLINE 53 13,0 39 140 12.4 ONLINE 40 157 15.4 NONE ONLINE MATH533 Course Project Data SAL Ready Course Project Part A solution Type here to search OVerdana 9 Wrap Paste B Merge Clipboard Font Alignment A2 X V f 48 A B C D E F Sales (Y) Calls (X1) Time (X2) Years (X3) Type 48 171 13.0 5 ONLINE 32 139 16.9 NONE 44 165 15.7 ONLINE INWWA 47 186 13.5 ONLINE 41 180 14.0 ONLINE 46 184 12.7 ONLINE 32 120 19.9 W NONE 9 46 172 14.7 GROUP 10 42 161 13.2 GROUP 11 33 143 15.4 3 NONE 12 42 181 11.5 ONLINE 13 50 148 16.0 NONE 14 42 140 17.5 GROUP 15 41 198 13.2 ONLINE 16 41 149 17.3 ONLINE 17 44 168 11.0 ONLINE 18 36 121 18.0 NONE 19 47 149 15.8 GROUP 20 38 135 18 .5 AWOUHHNHENUONNO GROUP 21 185 18.9 ONLINE 22 67 155 17.9 NONE 23 45 149 13.5 24 ONLINE 52 193 137 25 ONLINE 37 159 18. 1 26 NONE 33 152 15.0 31 GROUP 170 14. 3 GROUP MATH533 Course Project Data SAL Course Project Part A solution Ready Type here to search OFile Home Insert Draw Page Layout Formulas Data Review Verdana 10 ap Wrap Paste 3 U Merg Clipboard s Font Alignment A2 X V & 48 A B C D E F 80 45 138 15.3 NONE 81 41 159 18.8 ONLINE 82 40 145 14.7 HNNNN NONE 83 47 151 16.6 GROUP 84 48 186 14.2 ONLINE 85 42 194 13.6 ONLINE 86 41 152 14.5 GROUP 87 29 145 19.0 NONE 88 48 188 11.3 ONLINE 89 33 139 19.3 GROUP 90 48 201 12.5 ONLINE 91 45 156 13.2 GROUP 92 36 131 18.5 93 NONE 43 161 17.3 94 ONLINE 42 152 14.6 95 49 ONLINE 178 16.4 96 ONLINE 50 157 15.9 W U H O P W N H W NW 97 42 GROUP 154 15 .3 98 44 GROUP 156 20.0 99 45 170 ONLINE 14.2 100 48 ONLINE 170 101 17.4 39 ONLINE 144 17.7 102 NONE 103 104 105 106 MATH533 Course Project Data SAL Course Project Part A solution Ready Type here to search