Applied Managerial Statistics
3
NOTE: This is a template to help you format Project Part B. I have put some explanations in red. Please delete these before submitting the assignment. All text in your submission should be black.
Project Part B: Hypothesis Testing
By
Put your name here
MATH534 – Applied Managerial Statistics
Prof. Bhupinder Sran
Keller Graduate School of Management
Put date of submission here
1. Introduction
Provide the purpose of this report and an overview of its content.
NOTE FOR SECTIONS 2, 3, 4:
· In these three sections, you will test three hypotheses.
· The row labeled “Hypothesis statement” shows the claim being made.
· Reviewing the Worksheet problems in Week 5 lecture notes (in FILES SECTION) and viewing the recordings (under DEVRY WEBEX) should help you in filling out the items for hypothesis tests in the table. Use of these resources is STRONGLY recommended.
· Using the Excel calculators for weeks 4 and 5 will help you come up with the numbers you need.
2. Hypothesis Test 1: Mean Sales per Week
|
Hypothesis statement |
Mean sales per week exceeds 42.5 per salesperson |
|
Null and alternate hypotheses |
Ho: Write the null hypothesis here Ha: Write the alternate hypothesis here |
|
Use z or t? |
Select z or t and explain your selection. |
|
Test statistic |
Give value of the test statistic |
|
p-value |
Give value of the p-value |
|
Hypothesis test result using p-value and alpha |
Result of test: Reject Ho or Don’t Reject Ho – pick one of these.
Explanation: Explain your reason for the result above. Example of what the answer should look like: “Since p-value (.0327) is less than alpha (.05), we can reject Ho.”
NOTE: For all hypothesis tests, use alpha=0.05
|
|
Do the results support the claim being made? |
Will we support the claim or not support the claim? Yes or No
Explanation. Starting with the result of the hypothesis test, show how you came up with the conclusion to support or not support the claim. Please see my lecture notes for ideas on how to word this. Example of what the answer should look like: “Since we are rejecting Ho, we have support for Ha, which is the martian’s claim. Therefore, we can support the martian’s claim their average height is more than 24 inches”. |
|
99% Confidence Interval for the mean |
Give the 99% confidence interval for the mean of the variable being tested above. |
Screenshot of the Week 5 Calculator
(put a screen shot of the Week 5 calculator showing the input and results for this problem)
Screenshot of the Week 4 Calculator
(put a screen shot of the Week 4 calculator showing the input and results for this problem)
3. Hypothesis Test 2: Proportion of Online Training
|
Hypothesis statement |
Proportion receiving online training is less than 55% |
|
Null and alternate hypotheses |
Ho: Write the null hypothesis here Ha: Write the alternate hypothesis here |
|
Use z or t? |
Select z or t and explain your selection. |
|
Test statistic |
Give value of the test statistic |
|
p-value |
Give value of the p-value |
|
Hypothesis test result using p-value and alpha |
Result of test: Reject Ho or Don’t Reject Ho – pick one of these.
Explanation: Explain your reason for the result above. Example of what the answer should look like: “Since p-value (.0327) is less than alpha (.05), we can reject Ho.”
NOTE: For all hypothesis tests, use alpha=0.05
|
|
Do the results support the claim being made? |
Will we support the claim or not support the claim? Yes or No
Explanation. Starting with the result of the hypothesis test, show how you came up with the conclusion to support or not support the claim. Please see my lecture notes for ideas on how to word this. Example of what the answer should look like: “Since we are rejecting Ho, we have support for Ha, which is the martian’s claim. Therefore, we can support the martian’s claim the percentage of martians that are orange is more than 33%.”. |
|
99% Confidence Interval for the proportion |
Give the 99% confidence interval for proportion receiving online training. |
Screenshot of the Week 5 Calculator
(put a screen shot of the Week 5 calculator showing the input and results for this problem)
Screenshot of the Week 4 Calculator
(put a screen shot of the Week 4 calculator showing the input and results for this problem)
4. Hypothesis Test 3: Mean Calls
|
Hypothesis statement |
Mean calls made among those with no training is at least 145. (NOTE: In this case we are only looking at salespeople who had no training.) |
|
Null and alternate hypotheses |
Ho: Write the null hypothesis here Ha: Write the alternate hypothesis here |
|
Use z or t? |
Select z or t and explain your selection. |
|
Test statistic |
Give value of the test statistic |
|
p-value |
Give value of the p-value |
|
Hypothesis test result using p-value and alpha |
Result of test: Reject Ho or Don’t Reject Ho – pick one of these.
Explanation: Explain your reason for the result above. Example of what the answer should look like: “Since p-value (.0327) is less than alpha (.05), we can reject Ho.”
NOTE: For all hypothesis tests, use alpha=0.05
|
|
Do the results support the claim being made? |
Will we support the claim or not support the claim? Yes or No
Explanation. Starting with the result of the hypothesis test, show how you came up with the conclusion to support or not support the claim. Please see my lecture notes for ideas on how to word this. Example of what the answer should look like: “Since we are rejecting Ho, we have support for Ha, which is the martian’s claim. Therefore, we can support the martian’s claim their average height is more than 24 inches”. |
|
99% Confidence Interval for the mean |
Give the 99% confidence interval for proportion receiving online training. |
Screenshot of the Week 5 Calculator
(put a screen shot of the Week 5 calculator showing the input and results for this problem)
Screenshot of the Week 4 Calculator
(put a screen shot of the Week 4 calculator showing the input and results for this problem)
5. Summary
1-2 paragraph summary of your findings. Don’t just restate technical details. State what we found out (i.e. end results) and what implications it has for the management.
3