This Excel calculator should help students quickly solve hypothesis tests for a single proportion. Note that the calculator automatically checks to see if the normal approximation can be used and alerts you to not proceed if it should not be used.
1. Use the scroll bars on the right side and bottom to access the entire worksheet.
2. Enter your summary data in the blue cells. Enter proportions as a decimal (0.36) and not a percentage (36%)
3. To start, read the problem carefully and find the key wording about the claim to decide what its math operator is. Then use the operator drop-down menu found by left-clicking on the orange cell B10.
4. For some problems, you will be given the number of successes (Yesses) found in a survey instead of the survey proportion, p-hat. Use the table in Part 1b and enter the number of success in the blue cell E11. Then, copy the value for p-hat and enter it in blue cell B5.
5. After you have entered your data and selected the claim math operator, the yellow answer cells will update accordingly. You should be able to find the final conclusion as well as most intermediate values you might need.
Hope this helps.
Dr. Dawn

V1.03 8/21-17