Statistics For Decision Making W5 *Excel*
LUUP777
OneSampleCalculator.xlsxZ Test
| "Z" Test for the Mean | ||||||
| Null Hypothesis µ = | 100 | Enter estimated population mean (hypothesized value) in cell C3 | ||||
| Level of Significance | 0.05 | Enter level of significance in cell C4 | ||||
| Population Standard Deviation | 62 | Enter population standard deviation in cell C5 | ||||
| Sample Size | 100 | Enter sample size in cell C6 | ||||
| Sample Mean | 112 | Enter sample mean in cell C7 | ||||
| Standard Error of the Mean | 6.2000 | |||||
| Z Test Statisitic | 1.935483871 | Use Descriptive Statistics to calculate the values for input into | ||||
| cells C3:C7 | ||||||
| Two Tailed Test | ||||||
| Lower Critical Value | -1.9599639845 | |||||
| Upper Critical Value | 1.9599639845 | |||||
| p Value | 0.052930946 | |||||
| Do not reject the null hypothesis | ||||||
| Lower Tail Test | ||||||
| Lower Critical Value | -1.644853627 | |||||
| p Value | 0.973534527 | |||||
| Do not reject the null hypothesis | ||||||
| Upper Tail Test | ||||||
| Upper Critical Value | 1.644853627 | |||||
| p Value | 0.026465473 | |||||
| Reject the null hypothesis |
t Test
| t-Test for the Mean | ||||||
| Null Hypothesis µ = | 60 | Enter estimated population mean / hypothesized value in cell C3 | ||||
| Level of Significance | 0.01 | Enter level of significance in cell C4 | ||||
| Sample Size | 26 | Enter sample size in cell C5 | ||||
| Sample Mean | 56.42 | Enter sample mean in cell C6 | ||||
| Sample Standard Deviation | 10.04 | Enter sample standard deviation in cell C7 | ||||
| Standard Error of the Mean | 1.9690059968 | |||||
| Degrees of Freedom | 25 | Use Descriptive Statistics to calculate the values for input into | ||||
| t Test Statisitic | -1.8181762807 | cells C3:C7 | ||||
| Two Tailed Test | ||||||
| Lower Critical Value | -2.7874358137 | |||||
| Upper Critical Value | 2.7874358137 | |||||
| p Value | 0.0810399126 | |||||
| Do not reject the null hypothesis | ||||||
| Calculations Area | ||||||
| Lower Tail Test | For One Tailed Tests | |||||
| Lower Critical Value | -2.4851071754 | TDIST Value | 0.0405199563 | |||
| p Value | 0.0405199563 | 1-TDST Value | 0.9594800437 | |||
| Do not reject the null hypothesis | ||||||
| Upper Tail Test | ||||||
| Upper Critical Value | 2.4851071754 | |||||
| p Value | 0.9594800437 | |||||
| Do not reject the null hypothesis |
Z Test for Proportion
| "Z" Test for the Proportion | |||||
| Null Hypothesis ƿ = | 0.8 | Enter estimated population proportion / hypothesized value in cell C3 | |||
| Level of Significance | 0.01 | Enter level of significance in cell C4 | |||
| Number of Successes | 1550 | Enter number of successes (X value) in cell C5 | |||
| Sample Size | 2000 | Enter sample size (n) in cell C6 | |||
| Sample Proportion | 0.775 | ||||
| Standard Error | 0.0089 | ||||
| Z Test Statisitic | -2.7950849719 | ||||
| Two Tailed Test | |||||
| Lower Critical Value | -2.5758293035 | ||||
| Upper Critical Value | 2.5758293035 | ||||
| p Value | 0.0051886076 | ||||
| Reject the null hypothesis | |||||
| Lower Tail Test | |||||
| Lower Critical Value | -2.326347874 | ||||
| p Value | 0.0025943038 | ||||
| Reject the null hypothesis | |||||
| Upper Tail Test | |||||
| Upper Critical Value | 2.326347874 | ||||
| p Value | 0.9974056962 | ||||
| Do not reject the null hypothesis |
