Question

1 Approved Answer

Posted on Sep 15, 2024

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

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.

The graph below is the data!

image text in transcribed

12 19.3 1 130 1 Sales (Y) Calls (X1) Time (X2) Years (X3) 41 125 0 34 125 3 38 127 12.2 3 39 127 15.5 1 37 127 15.6 39 127 20.6 34 127 18.5 4 40 127 15.2 3 41 19.8 1 44 133 16.1 1 40 135 13.3 3 44 136 18.1 2 41 137 17.7 1 43 137 18.9 41 138 15.2 1 38 139 12.2 1 40 139 15.7 2 38 142 17.9 3 48 142 14.8 0 44 144 15.3 0 38 145 15.6 3 44 145 15.8 1 40 146 18.2 2 39 147 13.6 3 41 147 16.8 2 39 148 14.4 4 40 148 15.2 3 41 148 14.8 1 42 148 13.7 2 45 148 16.3 0 46 148 15.5 1 35 149 19.3 2 43 150 15.3 2 45 151 13.6 1 45 152 17.1 3 45 152 21.8 0 49 152 19.9 2 42 153 14.9 3 43 153 17.3 1 45 153 13.4 1 42 154 13.6 3 41 155 14.8 2 45 155 11.6 3 36 158 17.5 1 40 158 15.6 2 41 158 13.8 4 34 160 13.1 1 42 160 16.5 3 44 160 14.1 4 46 160 12.9 1 46 161 16.6 3 36 162 18.4 2 50 162 15.6 2 37 163 14.4 2 38 10.8 4 48 163 15.5 3 33 164 15.9 3 43 164 13.1 3 43 164 15.2 0 48 164 14.7 3 44 165 14.2 5 45 165 16.4 1 47 166 13.8 3 47 167 12.9 5 47 167 16.1 5 49 169 14.8 0 46 170 14.2 2 37 171 11.7 2 55 172 11.1 1 36 173 14.3 4 41 173 15.4 1 43 173 12.8 0 47 173 14.6 2 49 173 17.4 0 44 174 18.5 2 46 174 16.6 2 47 174 2 67 174 15.1 1 30 175 14.3 3 66 175 12.3 1 39 181 14.7 3 49 181 11.6 2 66 181 11.8 2 46 182 13.2 3 49 182 14.1 4 42 183 14.4 2 62 183 11.4 2 67 183 11.4 4 34 184 12.5 4 50 187 14.3 2 64 187 2 35 DS 188 18.2 2 37 S7 189 12.7 1 42 191 14.2 0 48 191 13.6 1 37 192 13.7 3 40 192 12.7 1 63 193 12.1 2 40 201 13.1 2 36 204 12.1 1 Type NONE GROUP NONE NONE GROUP GROUP NONE GROUP NONE NONE ONLINE ONLINE GROUP NONE NONE GROUP NONE NONE NONE GROUP NONE NONE GROUP GROUP GROUP GROUP GROUP GROUP NONE ONLINE GROUP NONE GROUP GROUP GROUP ONLINE ONLINE GROUP NONE GROUP ONLINE GROUP GROUP GROUP ONLINE GROUP ONLINE GROUP NONE GROUP ONLINE ONLINE ONLINE ONLINE GROUP GROUP ONLINE ONLINE ONLINE NONE GROUP GROUP ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE GROUP ONLINE ONLINE ONLINE ONLINE GROUP GROUP GROUP ONLINE GROUP NONE ONLINE NONE ONLINE ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE ONLINE 163 13.8 12.5 12 19.3 1 130 1 Sales (Y) Calls (X1) Time (X2) Years (X3) 41 125 0 34 125 3 38 127 12.2 3 39 127 15.5 1 37 127 15.6 39 127 20.6 34 127 18.5 4 40 127 15.2 3 41 19.8 1 44 133 16.1 1 40 135 13.3 3 44 136 18.1 2 41 137 17.7 1 43 137 18.9 41 138 15.2 1 38 139 12.2 1 40 139 15.7 2 38 142 17.9 3 48 142 14.8 0 44 144 15.3 0 38 145 15.6 3 44 145 15.8 1 40 146 18.2 2 39 147 13.6 3 41 147 16.8 2 39 148 14.4 4 40 148 15.2 3 41 148 14.8 1 42 148 13.7 2 45 148 16.3 0 46 148 15.5 1 35 149 19.3 2 43 150 15.3 2 45 151 13.6 1 45 152 17.1 3 45 152 21.8 0 49 152 19.9 2 42 153 14.9 3 43 153 17.3 1 45 153 13.4 1 42 154 13.6 3 41 155 14.8 2 45 155 11.6 3 36 158 17.5 1 40 158 15.6 2 41 158 13.8 4 34 160 13.1 1 42 160 16.5 3 44 160 14.1 4 46 160 12.9 1 46 161 16.6 3 36 162 18.4 2 50 162 15.6 2 37 163 14.4 2 38 10.8 4 48 163 15.5 3 33 164 15.9 3 43 164 13.1 3 43 164 15.2 0 48 164 14.7 3 44 165 14.2 5 45 165 16.4 1 47 166 13.8 3 47 167 12.9 5 47 167 16.1 5 49 169 14.8 0 46 170 14.2 2 37 171 11.7 2 55 172 11.1 1 36 173 14.3 4 41 173 15.4 1 43 173 12.8 0 47 173 14.6 2 49 173 17.4 0 44 174 18.5 2 46 174 16.6 2 47 174 2 67 174 15.1 1 30 175 14.3 3 66 175 12.3 1 39 181 14.7 3 49 181 11.6 2 66 181 11.8 2 46 182 13.2 3 49 182 14.1 4 42 183 14.4 2 62 183 11.4 2 67 183 11.4 4 34 184 12.5 4 50 187 14.3 2 64 187 2 35 DS 188 18.2 2 37 S7 189 12.7 1 42 191 14.2 0 48 191 13.6 1 37 192 13.7 3 40 192 12.7 1 63 193 12.1 2 40 201 13.1 2 36 204 12.1 1 Type NONE GROUP NONE NONE GROUP GROUP NONE GROUP NONE NONE ONLINE ONLINE GROUP NONE NONE GROUP NONE NONE NONE GROUP NONE NONE GROUP GROUP GROUP GROUP GROUP GROUP NONE ONLINE GROUP NONE GROUP GROUP GROUP ONLINE ONLINE GROUP NONE GROUP ONLINE GROUP GROUP GROUP ONLINE GROUP ONLINE GROUP NONE GROUP ONLINE ONLINE ONLINE ONLINE GROUP GROUP ONLINE ONLINE ONLINE NONE GROUP GROUP ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE GROUP ONLINE ONLINE ONLINE ONLINE GROUP GROUP GROUP ONLINE GROUP NONE ONLINE NONE ONLINE ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE ONLINE 163 13.8 12.5