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. Sales (Y) Calls (X1) Time (X2) Years (X3) Type 48 171 13.0 5 ONLINE 32 139 16.9 4 NONE 44 165 15.7 3 ONLINE 47 186 13.5 3 ONLINE 41 180 14.0 2 ONLINE 46 184 12.7 5 ONLINE 32 120 19.9 3 NONE 46 172 14.7 3 GROUP 42 161 13.2 1 GROUP 33 143 15.4 3 NONE 42 181 11.5 4 ONLINE 50 148 16.0 0 NONE 42 140 17.5 2 GROUP 41 198 13.2 2 ONLINE 41 149 17.3 0 ONLINE 44 168 11.0 5 ONLINE 36 121 18.0 2 NONE 47 149 15.8 1 GROUP 38 135 18.5 1 GROUP 21 185 18.9 2 ONLINE 67 155 17.9 1 NONE 45 149 13.5 1 ONLINE 52 193 13.7 5 ONLINE 37 159 18.1 0 NONE 33 152 15.0 3 GROUP 31 170 14.3 4 GROUP 44 192 16.7 1 GROUP 44 165 12.4 3 ONLINE 39 150 15.3 3 GROUP 43 174 12.7 2 ONLINE 42 168 16.4 0 ONLINE 49 178 15.1 3 ONLINE 41 164 17.8 3 GROUP 40 191 19.0 5 ONLINE 37 132 10.0 0 NONE 36 140 15.7 1 NONE 46 171 14.9 5 ONLINE 41 170 12.3 0 ONLINE 49 153 19.0 3 GROUP 42 154 14.3 2 GROUP 37 142 13.9 3 NONE 37 130 16.9 2 NONE 21 177 17.0 0 ONLINE 39 160 14.3 4 NONE 44 134 19.4 5 GROUP 49 131 14.6 1 GROUP 35 130 19.4 4 NONE 46 183 15.4 4 ONLINE 43 169 14.0 5 GROUP 41 155 16.0 2 ONLINE 48 182 13.0 2 ONLINE 39 140 12.4 1 NONE 40 157 15.4 1 ONLINE 48 167 14.8 3 ONLINE 50 144 15.8 2 NONE 44 168 12.4 2 GROUP 43 175 13.6 5 GROUP 33 150 14.9 2 GROUP 32 155 17.9 1 GROUP 46 163 16.6 2 ONLINE 48 162 14.5 4 GROUP 56 189 15.0 3 ONLINE 44 153 15.3 2 ONLINE 34 158 14.2 3 ONLINE 43 160 10.9 4 ONLINE 33 173 17.5 1 ONLINE 49 178 18.3 2 GROUP 50 189 14.3 1 ONLINE 52 184 11.4 4 ONLINE 45 174 13.6 2 ONLINE 48 188 13.6 0 ONLINE 35 149 15.6 1 GROUP 44 159 14.6 2 GROUP 44 160 14.8 2 ONLINE 67 166 18.9 1 GROUP 51 178 16.5 1 ONLINE 41 178 13.4 2 ONLINE 40 176 12.6 1 ONLINE 45 138 15.3 2 NONE 41 159 18.8 2 ONLINE 40 145 14.7 2 NONE 47 151 16.6 2 GROUP 48 186 14.2 1 ONLINE 42 194 13.6 2 ONLINE 41 152 14.5 4 GROUP 29 145 19.0 2 NONE 48 188 11.3 2 ONLINE 33 139 19.3 3 GROUP 48 201 12.5 1 ONLINE 45 156 13.2 3 GROUP 36 131 18.5 2 NONE 43 161 17.3 3 ONLINE 42 152 14.6 1 ONLINE 49 178 16.4 2 ONLINE 50 157 15.9 3 GROUP 42 154 15.3 1 GROUP 44 156 20.0 0 ONLINE 45 170 14.2 1 ONLINE 48 170 17.4 5 ONLINE 39 144 17.7 3 NONE
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.
Sales (Y) | Calls (X1) | Time (X2) | Years (X3) | Type |
48 | 171 | 13.0 | 5 | ONLINE |
32 | 139 | 16.9 | 4 | NONE |
44 | 165 | 15.7 | 3 | ONLINE |
47 | 186 | 13.5 | 3 | ONLINE |
41 | 180 | 14.0 | 2 | ONLINE |
46 | 184 | 12.7 | 5 | ONLINE |
32 | 120 | 19.9 | 3 | NONE |
46 | 172 | 14.7 | 3 | GROUP |
42 | 161 | 13.2 | 1 | GROUP |
33 | 143 | 15.4 | 3 | NONE |
42 | 181 | 11.5 | 4 | ONLINE |
50 | 148 | 16.0 | 0 | NONE |
42 | 140 | 17.5 | 2 | GROUP |
41 | 198 | 13.2 | 2 | ONLINE |
41 | 149 | 17.3 | 0 | ONLINE |
44 | 168 | 11.0 | 5 | ONLINE |
36 | 121 | 18.0 | 2 | NONE |
47 | 149 | 15.8 | 1 | GROUP |
38 | 135 | 18.5 | 1 | GROUP |
21 | 185 | 18.9 | 2 | ONLINE |
67 | 155 | 17.9 | 1 | NONE |
45 | 149 | 13.5 | 1 | ONLINE |
52 | 193 | 13.7 | 5 | ONLINE |
37 | 159 | 18.1 | 0 | NONE |
33 | 152 | 15.0 | 3 | GROUP |
31 | 170 | 14.3 | 4 | GROUP |
44 | 192 | 16.7 | 1 | GROUP |
44 | 165 | 12.4 | 3 | ONLINE |
39 | 150 | 15.3 | 3 | GROUP |
43 | 174 | 12.7 | 2 | ONLINE |
42 | 168 | 16.4 | 0 | ONLINE |
49 | 178 | 15.1 | 3 | ONLINE |
41 | 164 | 17.8 | 3 | GROUP |
40 | 191 | 19.0 | 5 | ONLINE |
37 | 132 | 10.0 | 0 | NONE |
36 | 140 | 15.7 | 1 | NONE |
46 | 171 | 14.9 | 5 | ONLINE |
41 | 170 | 12.3 | 0 | ONLINE |
49 | 153 | 19.0 | 3 | GROUP |
42 | 154 | 14.3 | 2 | GROUP |
37 | 142 | 13.9 | 3 | NONE |
37 | 130 | 16.9 | 2 | NONE |
21 | 177 | 17.0 | 0 | ONLINE |
39 | 160 | 14.3 | 4 | NONE |
44 | 134 | 19.4 | 5 | GROUP |
49 | 131 | 14.6 | 1 | GROUP |
35 | 130 | 19.4 | 4 | NONE |
46 | 183 | 15.4 | 4 | ONLINE |
43 | 169 | 14.0 | 5 | GROUP |
41 | 155 | 16.0 | 2 | ONLINE |
48 | 182 | 13.0 | 2 | ONLINE |
39 | 140 | 12.4 | 1 | NONE |
40 | 157 | 15.4 | 1 | ONLINE |
48 | 167 | 14.8 | 3 | ONLINE |
50 | 144 | 15.8 | 2 | NONE |
44 | 168 | 12.4 | 2 | GROUP |
43 | 175 | 13.6 | 5 | GROUP |
33 | 150 | 14.9 | 2 | GROUP |
32 | 155 | 17.9 | 1 | GROUP |
46 | 163 | 16.6 | 2 | ONLINE |
48 | 162 | 14.5 | 4 | GROUP |
56 | 189 | 15.0 | 3 | ONLINE |
44 | 153 | 15.3 | 2 | ONLINE |
34 | 158 | 14.2 | 3 | ONLINE |
43 | 160 | 10.9 | 4 | ONLINE |
33 | 173 | 17.5 | 1 | ONLINE |
49 | 178 | 18.3 | 2 | GROUP |
50 | 189 | 14.3 | 1 | ONLINE |
52 | 184 | 11.4 | 4 | ONLINE |
45 | 174 | 13.6 | 2 | ONLINE |
48 | 188 | 13.6 | 0 | ONLINE |
35 | 149 | 15.6 | 1 | GROUP |
44 | 159 | 14.6 | 2 | GROUP |
44 | 160 | 14.8 | 2 | ONLINE |
67 | 166 | 18.9 | 1 | GROUP |
51 | 178 | 16.5 | 1 | ONLINE |
41 | 178 | 13.4 | 2 | ONLINE |
40 | 176 | 12.6 | 1 | ONLINE |
45 | 138 | 15.3 | 2 | NONE |
41 | 159 | 18.8 | 2 | ONLINE |
40 | 145 | 14.7 | 2 | NONE |
47 | 151 | 16.6 | 2 | GROUP |
48 | 186 | 14.2 | 1 | ONLINE |
42 | 194 | 13.6 | 2 | ONLINE |
41 | 152 | 14.5 | 4 | GROUP |
29 | 145 | 19.0 | 2 | NONE |
48 | 188 | 11.3 | 2 | ONLINE |
33 | 139 | 19.3 | 3 | GROUP |
48 | 201 | 12.5 | 1 | ONLINE |
45 | 156 | 13.2 | 3 | GROUP |
36 | 131 | 18.5 | 2 | NONE |
43 | 161 | 17.3 | 3 | ONLINE |
42 | 152 | 14.6 | 1 | ONLINE |
49 | 178 | 16.4 | 2 | ONLINE |
50 | 157 | 15.9 | 3 | GROUP |
42 | 154 | 15.3 | 1 | GROUP |
44 | 156 | 20.0 | 0 | ONLINE |
45 | 170 | 14.2 | 1 | ONLINE |
48 | 170 | 17.4 | 5 | ONLINE |
39 | 144 | 17.7 | 3 | NONE |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps