Part B Hypothesis Testing & Confidence Intervals

profileRock$tarGirl
Week_5_Hypothesis_Test_Calculator_10032019.xlsx

Hypothesis Test Calculator

Hypothesis Testing for µ and for p Note: Enter values in the green cells only.
Hypothesis Test for µ Hypothesis Test for p
Information Provided by the Problem
Level of Significance (decimal)
Level of Significance (decimal) Proportion under H0 (decimal)
Mean under H0 n
n Number of Successes
Sample Mean NOTE: OR
StDev If sample standard deviation is known, use t. Sample Proportion
Use t or z? If population standard deviation is known, use z.
Test Statistic and p-values
Critical Values
Sample Proportion ERROR:#DIV/0!
Right-Tailed (>) N/A StDev ERROR:#DIV/0!
Left-Tailed (<) N/A SE ERROR:#DIV/0!
Two-Tailed (≠) N/A ERROR:#VALUE! z Test Statistic ERROR:#DIV/0!
One-Sided p-value ERROR:#DIV/0!
Two-Sided p-value ERROR:#DIV/0!
Test Statistic and p-values
SE ERROR:#DIV/0!
Test statistic ERROR:#DIV/0! Critical Values
Left-sided p-value ERROR:#DIV/0!
Right-sided p-value ERROR:#DIV/0! Right-Tailed (>) ERROR:#NUM!
Two-Sided p-value ERROR:#DIV/0! Left-Tailed (<) ERROR:#NUM!
Two-Tailed (≠) ERROR:#NUM! ERROR:#NUM!
t Do not
z change