DeVry MATH 534 Proportion Receiving Online Training Calculations Report Paper

Homework Help & Homework Answers

DeVry MATH 534 Proportion Receiving Online Training Calculations Report Paper

 

Part B: Hypothesis Testing and Confidence Intervals

 

 

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.

Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can be used in these analyses.

  • Mean sales per week exceed 42.5 per salesperson
  • Proportion receiving online training is less than 55%
  • 3  Mean calls made among those with no training is at least 145
  • 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 rubric below.

Format for report:

  1. Summary Report (about one paragraph on each of the four speculations)
  2. 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.

 

Calls (X1) Time (X2) Years (X3) Type
116 19.9 3 NONE
116 18.0 2 GROUP
118 19.4 4 ONLINE
125 16.9 2 ONLINE
129 18.5 2 GROUP
131 14.6 1 GROUP
131 10.0 0 GROUP
131 19.4 5 GROUP
132 18.5 1 GROUP
135 15.3 2 GROUP
136 16.9 4 ONLINE
136 19.3 3 ONLINE
137 15.7 1 GROUP
139 12.4 1 GROUP
140 17.5 2 GROUP
140 13.9 3 NONE
141 12.2 3 NONE
142 17.0 3 ONLINE
143 17.7 3 NONE
143 18.3 2 NONE
146 15.4 3 GROUP
146 15.8 1 GROUP
146 18.2 2 NONE
146 16.4 0 ONLINE
146 16.5 1 NONE
146 15.6 3 ONLINE
147 18.5 3 GROUP
147 13.2 3 GROUP
148 10.5 2 GROUP
149 14.2 4 ONLINE
149 13.2 3 GROUP
149 12.7 1 GROUP
150 19.4 0 GROUP
150 17.4 3 GROUP
150 20.7 2 GROUP
151 18.0 1 NONE
151 14.3 1 GROUP
151 15.2 2 GROUP
152 17.2 1 GROUP
152 16.0 2 ONLINE
153 13.2 3 GROUP
153 22.0 0 ONLINE
154 16.4 3 GROUP
154 14.5 4 NONE
154 15.3 1 ONLINE
155 11.2 3 ONLINE
156 18.6 2 GROUP
156 20.5 2 ONLINE
157 16.3 4 ONLINE
157 19.3 2 ONLINE
158 13.9 1 GROUP
158 11.8 3 ONLINE
159 13.6 4 GROUP
160 15.8 2 ONLINE
161 13.2 3 GROUP
162 15.7 3 NONE
162 16.4 3 ONLINE
163 11.7 1 GROUP
164 17.2 3 ONLINE
165 17.4 3 ONLINE
165 15.0 0 ONLINE
165 19.2 2 NONE
166 19.5 5 NONE
167 14.5 4 GROUP
167 10.1 0 ONLINE
167 14.8 1 ONLINE
167 15.8 0 ONLINE
168 12.3 5 ONLINE
168 15.9 5 ONLINE
169 14.8 3 GROUP
170 12.1 1 ONLINE
171 19.4 2 ONLINE
171 17.3 2 ONLINE
172 12.6 3 GROUP
173 13.3 1 ONLINE
174 18.3 0 ONLINE
175 18.3 2 GROUP
175 13.9 2 GROUP
175 15.1 3 ONLINE
175 12.0 2 ONLINE
175 14.2 1 ONLINE
177 15.3 3 ONLINE
178 12.6 4 ONLINE
179 12.8 3 ONLINE
180 15.1 4 NONE
181 12.4 2 ONLINE
181 11.4 4 GROUP
182 17.9 2 ONLINE
183 13.0 3 ONLINE
183 11.7 1 GROUP
185 15.2 2 ONLINE
185 16.4 0 ONLINE
186 14.1 3 GROUP
186 17.5 1 GROUP
188 11.0 2 ONLINE
189 20.0 1 GROUP
190 13.2 3 ONLINE
191 13.1 2 GROUP
195 15.2 2 ONLINE
198 13.0 1 ONLINE