Sales (Y) Calls (X1) Time (X2) Years (X3) 51 167 14.9 5 34 133 17.9 4 49 161 19 3 45 185 15.7 1 47 176 16.6 2 47 183 15.1 2 38 122 22.8 3 44 171 16 3 47 157 16.9 1 37 148 18.5 3 51 177 13.5 4 40 144 20.5 0 48 136 15.7 2 52 197 16.5 2 46 145 19.8 0 42 167 20.9 3 37 120 14.2 2 42 148 19.9 1 43 131 21.8 1 49 184 19.7 2 44 150 21.7 1 43 148 18.8 1 55 189 14.2 1 37 152 23.4 0 44 148 15.9 3 43 169 15.7 4 49 188 24.1 1 45 164 19.7 3 45 146 14.2 3 43 173 23.4 2 47 164 18.1 0 48 177 16.4 3 49 160 16 3 51 190 13.3 1 42 135 19 0 37 137 21.4 1 51 167 19.1 1 44 169 10.5 0 46 149 21 3 42 153 18.3 2 45 140 13 3 37 133 23.4 2 52 173 21.9 0 39 156 15.7 4 45 130 24.3 3 37 130 18.4 1 40 125 14.4 4 44 182 18.3 4 48 165 23.4 5 42 154 17.5 2 53 178 15.6 2 37 142 21.8 1 46 153 16.6 1 43 166 20.8 3 45 138 22.3 2 42 167 21.2 2 48 171 15.3 2 39 149 22.2 1 Type ONLINE GROUP NONE ONLINE ONLINE ONLINE GROUP GROUP GROUP GROUP NONE NONE ONLINE ONLINE ONLINE ONLINE NONE NONE NONE ONLINE NONE ONLINE ONLINE GROUP ONLINE NONE ONLINE NONE GROUP ONLINE ONLINE ONLINE GROUP ONLINE NONE ONLINE ONLINE ONLINE NONE ONLINE GROUP ONLINE ONLINE NONE GROUP ONLINE NONE NONE ONLINE ONLINE ONLINE NONE ONLINE ONLINE NONE NONE ONLINE GROUP The following is a SUMMARY of the requi See Course home > Course project for detai 5 variables SALES represents the number sales made th CALLS represents the number of sales calls m TIME represents the average time per call th YEARS represents years of experience in the TYPE represents the type of training the emp Week2/PartA paper - Descriptive statistic Analyze/interpret 3 individual variables usi Report your findings for 3 pairs of variables 1 pair must include a qualitative variable Week6/PartB paper - Confidence interval 4 speculations (use alpha = .05) a. Mean sales per week is less than 47 b. Proportion receiving online training is c. Mean calls made among those with no d. Mean time per call is less than 19 min Report your conclusions on each of the 4 s AND the p-value to explain your findings i Compute then explain/interpret confidenc Week7/PartC paper - Regression analysis Calculate then explain/interpret the following and the independent variables (labeled X1) 1. Generate a scatterplot for Y vs X1, including 2. Determine the equation of the "best fit" line 3. Determine the coefficient of correlation. Int 4. Determine the coefficient of determination. 5. Test the utility of this regression model. Inte 6. Based on items 1-5, analyze the ability of X 7. Compute a 95% CI for 1 (the population sl 8. Estimate the average for the dependent va 9. Predict the value of the dependent variable 10. What can be said about the value of the d range of the sample values? Explain. Sheet2 contains the Minitab regression o independent variables/ X1, X2, and X3 11. Explain the equation for this multiple regre 12. Perform the Global Test for Utility (F-Test). 13. Perform the t-test on each independent va recommendation on which independent v 14. Is this multiple regression model better tha The has been a SUMMARY of the requirem See Course home > Course project for detai NOTE: For the Week6/PartB paper use the NOTE: For the Week7/PartC paper use the 46 46 45 44 49 41 48 46 48 47 54 45 58 42 50 49 51 57 59 53 49 46 48 45 58 52 48 43 55 44 59 46 41 42 46 45 43 41 49 44 49 37 151 162 158 188 149 157 156 172 174 188 180 173 174 138 145 149 152 167 164 165 129 148 135 140 172 183 138 135 174 128 187 145 118 150 138 167 143 143 152 169 166 145 18.9 19.1 16.4 15.2 24.9 13.6 17.8 14.8 21.9 19.2 13.9 20.8 17.9 19.1 22.3 21.4 14.3 17.1 12.7 16.2 17.9 22.8 21.9 12.7 12.4 15.9 17.1 20.2 18.4 20.9 13.9 16 18.3 12.5 15.5 16.8 17.9 17.3 26.3 16 19.1 21.2 1 2 1 3 2 3 4 1 2 1 4 2 1 2 3 3 2 2 3 2 3 3 3 2 2 3 5 3 3 4 2 4 2 3 1 2 3 1 0 1 0 3 GROUP ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE GROUP GROUP ONLINE GROUP ONLINE GROUP ONLINE GROUP ONLINE GROUP GROUP ONLINE ONLINE ONLINE GROUP ONLINE GROUP ONLINE GROUP GROUP GROUP GROUP GROUP GROUP GROUP ONLINE ONLINE ONLINE NONE e requirements for each project for detailed requirements that apply to each paper made this week. es calls made this week. er call this week. ce in the call center. the employee received. statistics and graphs ables using graphical and numerical analysis variables using graphical and numerical analysis e variable and 1 pair must NOT include a qualitative variable ntervals and hypothesis testing han 47 per salesperson ning is greater than 44% with no training is greater than 143 n 19 minutes f the 4 speculations. Use the seven elements of a hypothesis test ndings in simple terms nfidence intervals for each of the 4 variables listed above analysis llowing tasks/tests using the dependent variable (labeled Y) led X1) including the graph of the "best fit" line. Interpret. t fit" line tion. Interpret. mination. Interpret. odel. Interpret results, including the p-value. ility of X1 to predict Y lation slope). Interpret this interval. dent variable when X1 = 170 using an interval. Interpret. variable when X1=170 using an interval. Interpret. of the dependent variable for values of X1 outside the plain. ession output to predict the dependent variable/Y using all of the and X3 Use this information to answer the next 4 questions ple regression model in simple terms. (F-Test). Explain the conclusion. ndent variable. Explain the conclusions including your endent variables should be kept and which should be discarded. etter than the linear model generated in parts 1-10? Explain. equirements for each project for detailed requirements that apply to each paper use the 4 speculations provided above use the Minitab regression output provided in Sheet2 General Regression Analysis: Sales (Y) versus Calls (X1), Time (X2), Years (X3) Regression Equation Sales (Y) = 25.1157 + 0.152573 Calls (X1) - 0.203546 Time (X2) + 0.215612 Years (X3) Coefficients Term Coef SE Coef T P 95% CI Constant 25.1157 5.38089 4.66756 0.000 (14.4347, 35.7967) Calls (X1) 0.1526 0.02475 6.16333 0.000 ( 0.1034, 0.2017) Time (X2) -0.2035 0.13856 -1.46896 0.145 (-0.4786, 0.0715) Years (X3) 0.2156 0.36209 0.59547 0.553 (-0.5031, 0.9343) Summary of Model S = 4.37311 R-Sq = 33.71% R-Sq(adj) = 31.64% PRESS = 1989.24 R-Sq(pred) = 28.17% Analysis of Variance Source DF Seq SS Adj SS Regression 3 933.53 933.53 Calls (X1) 1 877.74 726.46 Time (X2) 1 49.01 41.27 Years (X3) 1 6.78 6.78 Error 96 1835.91 1835.91 Total 99 2769.44 Adj MS 311.176 726.459 41.267 6.781 19.124 F P 16.2714 0.000000 37.9866 0.000000 2.1578 0.145112 0.3546 0.552929