Introduction
Your instructor will provide you with a data file that includes data on five variables:
SALES represents the number of sales made this week.
CALLS represents the number of sales calls made this week.
TIME represents the average time per call this week.
YEARS represents years of experience in the call center.
TYPE represents the type of training the employee received.
Part B: Hypothesis Testing and Confidence Intervals
Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can be used in these analyses.
· 1. Mean sales per week exceed 42.5 per salesperson
· 2. Proportion receiving online training is less than 55%
· 3 Mean calls made among those with no training is at least 145
· 4. Mean time per call is 14.7 minutes
· Using the same data set from part A, perform the hypothesis test for each speculation in order to see if there is evidence to support the manager's belief. Use the Eight Steps of a Test of Hypothesis from Section 9.1 of your text book as a guide. You can use either the p-value or the critical values to draw conclusions. Be sure to explain your conclusion and interpret that to the claim in simple terms
· Compute 99% confidence intervals for the variables used in each hypothesis test, and interpret these intervals.
· Write a report about the results, distilling down the results in a way that would be understandable to someone who does not know statistics. Clear explanations and interpretations are critical.
· All DeVry University policies are in effect, including the plagiarism policy.
· Project Part B report is due by the end of Week 6.
· Project Part B is worth 100 total points. See grading ru
ic below.
Format for report:
A. Summary Report (about one paragraph on each of the four speculations)
B. Appendix with the calculations of the Eight Elements of a Test of Hypothesis, the p-values, and the confidence intervals. Include the Excel formulas or spreadsheet screen shots used in the calculations.
Part C: Final Project: Regression and Co
elation 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 co
elation 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 co
elation 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. All DeVry University policies are in effect, including the plagiarism policy.
13. Final Project report is due by the end of Week 7.
14. Final Project is worth 130 total points. See grading ru
ic below.
Summarize your results from Steps 1-11 in a 3-page report. 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:
C. Summary Report
D. Steps 1-11 addressed with appropriate output, graphs and interpretations. Be sure to number each step 1-11.
Project Data
Sales (Y) Calls (X1) Time (X2) Years (X3) Type
37 131 16.9 2 GROUP
44 134 19.4 3 GROUP
33 139 19.3 3 GROUP
40 145 14.7 2 GROUP
35 149 15.6 1 GROUP
47 149 15.8 1 GROUP
26 150 14.9 2 GROUP
39 150 15.3 3 GROUP
47 151 16.6 2 GROUP
25 152 15.0 3 GROUP
41 152 14.5 4 GROUP
49 153 19.0 3 GROUP
42 154 14.3 2 GROUP
42 154 15.3 1 GROUP
25 155 17.9 1 GROUP
45 156 13.2 3 GROUP
50 157 15.9 3 GROUP
44 159 14.6 2 GROUP
42 161 13.2 1 GROUP
48 162 14.5 4 GROUP
41 164 17.8 3 GROUP
67 166 18.9 1 GROUP
44 168 12.4 2 GROUP
43 169 14.0 5 GROUP
22 170 14.3 4 GROUP
46 172 14.7 3 GROUP
43 175 13.6 5 GROUP
49 178 18.3 2 GROUP
44 192 16.7 1 GROUP 29
25 130 12.8 2 NONE
36 131 11.7 3 NONE
35 131 21.6 1 NONE
36 131 18.5 0 NONE
49 131 14.6 1 NONE
37 132 10.0 3 NONE
38 135 18.5 3 NONE
22 139 16.9 4 NONE
39 140 12.4 0 NONE
42 140 17.5 3 NONE
37 142 13.9 2 NONE
25 143 15.4 1 NONE
50 144 15.8 2 NONE
22 145 19.0 2 NONE
50 148 16.0 0 NONE
67 155 17.9 1 NONE
37 159 18.1 0 NONE
39 160 14.3 4 NONE 18
45 138 15.3 2 ONLINE
36 140 15.7 1 ONLINE
39 144 17.7 1 ONLINE
41 149 17.3 0 ONLINE
45 149 13.5 1 ONLINE
42 152 14.6 1 ONLINE
44 153 15.3 2 ONLINE
41 155 16.0 2 ONLINE
44 156 20.0 0 ONLINE
40 157 15.4 1 ONLINE
34 158 14.2 3 ONLINE
41 159 18.8 2 ONLINE
43 160 10.9 4 ONLINE
44 160 14.8 2 ONLINE
43 161 17.3 3 ONLINE
46 163 16.6 2 ONLINE
44 165 15.7 3 ONLINE
44 165 12.4 3 ONLINE
48 167 14.8 3 ONLINE
42 168 16.4 0 ONLINE
44 168 11.0 5 ONLINE
41 170 12.3 0 ONLINE
45 170 14.2 1 ONLINE
48 170 17.4 5 ONLINE
46 171 14.9 5 ONLINE
48 171 13.0 5 ONLINE
30 173 17.5 1 ONLINE
43 174 12.7 2 ONLINE
45 174 13.6 2 ONLINE
40 176 12.6 1 ONLINE
21 177 17.0 0 ONLINE
41 178 13.4 2 ONLINE
49 178 15.1 3 ONLINE
49 178 16.4 2 ONLINE
51 178 16.5 1 ONLINE
41 180 14.0 2 ONLINE
42 181 11.5 4 ONLINE
48 182 13.0 2 ONLINE
46 183 15.4 4 ONLINE
46 184 12.7 5 ONLINE
52 184 11.4 4 ONLINE
21 185 18.9 2 ONLINE
47 186 13.5 3 ONLINE
48 186 14.2 1 ONLINE
48 188 13.6 0 ONLINE
48 188 11.3 2 ONLINE
50 189 14.3 1 ONLINE
56 189 15.0 3 ONLINE
40 191 19.0 5 ONLINE
52 193 13.7 5 ONLINE
42 194 13.6 2 ONLINE
41 198 13.2 2 ONLINE
48 201 12.5 1 ONLINE 53
4189 16210 1522.6 223 100
Sales Calls Time Years
Mean 41.89 Mean 162.1 Mean 15.226 Mean 2.23
Median 43 Median 160.5 Median 14.95 Median 2
Mode 44 Mode 131 and 178 Mode 15.3, 14.3, and 13.6 Mode 2
Standard E
or XXXXXXXXXX Standard E
or XXXXXXXXXX Standard E
or XXXXXXXXXX Standard E
or XXXXXXXXXX
Standard Deviation XXXXXXXXXX Standard Deviation XXXXXXXXXX Standard Deviation XXXXXXXXXX Standard Deviation XXXXXXXXXX
Sample Variance 70.321 Sample Variance 323.808 Sample Variance 5.423 Sample Variance 1.977
Min 21 Min 130 Min 10 Min 0
Max 67 Max 201 Max 21.6 Max 5
Sum 4189 Sum 16210 Sum 1522.6 Sum 223
Range 46 Range 71 Range 11.6 Range 5
Summary Summary Summary Summary
Sales per week
37 44 33 40 35 47 26 39 47 25 41 49 42 42 25 45 50 44 42 48 41 67 44 43 22 46 43 49 44 25 36 35 36 49 37 38 22 39 42 37 25 50 22 50 67 37 39 45 36 39 41 45 42 44 41 44 40 34 41 43 44 43 46 44 44 48 42 44 41 45 48 46 48 30 43 45 40 21 41 49 49 51 41 42 48 46 46 52 21 47 48 48 48 50 56 40 52 42 41 48
Calls per week
131 134 139 145 149 149 150 150 151 152 152 153 154 154 155 156 157 159 161 162 164 166 168 169 170 172 175 178 192 130 131 131 131 131 132 135 139 140 140 142 143 144 145 148 155 159 160 138 140 144 149 149 152 153 155 156 157 158 159 160 160 161 163 165 165 167 168 168 170 170 170 171 171 173 174 174 176 177 178 178 178 178 180 181 182 183 184 184 185 186 186 188 188 189 189 191 193 194 198 201
Time per call this week
XXXXXXXXXX XXXXXXXXXX 19.3 14.7 15.6 15.8 14.9 15.3 XXXXXXXXXX 15 14.5 19 14.3 15.3 XXXXXXXXXX 13.2 15.9 14.6 13.2 14.5 17.8 XXXXXXXXXX 12.4 14 14.3 14.7 13.6 18.3 16.7 12.8 11.7 21.6 18.5 14.6 10 18.5 XXXXXXXXXX 12.4 17.5 13.9 15.4 15.8 19 16 XXXXXXXXXX XXXXXXXXXX 14.3 15.3 15.7 17.7 17.3 13.5 14.6 15.3 16 20 15.4 14.2 18.8 10.9 14.8 17.3 XXXXXXXXXX 15.7 12.4 14.8 XXXXXXXXXX 11 12.3 14.2 XXXXXXXXXX 14.9 13 17.5 12.7 13.6 12.6 17 13.4 15.1 XXXXXXXXXX 16.5 14 11.5 13 15.4 12.7 11.4 XXXXXXXXXX 13.5 14.2 13.6 11.3 14.3 15 19 13.7 13.6 13.2 12.5
Group
None
Online
29 18 53