Part B: Hypothesis Testing and Confidence Intervals Test each of the following two hypotheses using = 0.05
No answer yet for this question.
Ask a Tutor
Question:
Part B: Hypothesis Testing and Confidence Intervals
Test each of the following two hypotheses using = 0.05. Week 1,4, and 5 spreadsheets can be used.
1. Mean sales per week exceed 42.5 per salesperson
2. Mean time per call is 14.7 minutes
- The data file is available under "Files". "Files" is located in the left main menu.Perform a hypothesis test for each hypothesis in order to see if there is evidence to support it. You can use either the p-value approach or the critical-values approach to draw conclusions. You need to explain your conclusion and interpret that to the claim in simple terms
- Compute a 99% confidence interval for the mean of each variable used in the above hypotheses and interpret the intervals.
- 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.
- The report is due by the end of Week 6.
- Part B project is worth 100 total points. See grading rubric below.
Report Format:
- All results. Include Excel screenshots of all results ORall formulas used.
- Summary (about one paragraph on each of the two hypothesis tests)
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.
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 |
Posted Date: