Calculates the one-tailed P-value of a z-test.
Z.TEST(array, x, sigma)
array is required, and is the array or range of data containing the sample values, that you want to test against x.
x is required, and is the hypothesized population mean.
sigma is optional, and is the known population standard deviation.
Example:
If array, found in A1:A10, contains numbers 5, 8, 2, 7, 1, 10, 3, 9, 4, 5, x, found in B1, contains 8 and sigma, found in B2, contains 2:
Z.TEST(A1:A10, B1, B2)
returns 0.999980299
A | B | C | ||
|---|---|---|---|---|
1 | 5 | 8 | 0.999980299 | |
2 | 8 | 2 | ||
3 | 2 | |||
4 | 7 | |||
5 | 1 | |||
6 | 10 | |||
7 | 3 | |||
8 | 9 | |||
9 | 4 | |||
10 | 5 |
Manufacturing of Lightbulbs
A lightbulb manufacturer claims that their bulbs have an average lifespan of 1,000 hours. From extensive historical data and quality control measures, the company knows that the population standard deviation for the lifespan of their lightbulbs is 80 hours. A new batch of bulbs is produced, and the company wants to verify if the new manufacturing process is still meeting the claimed average lifespan.
To do this, a random sample of 30 lightbulbs is selected from the new batch, and their lifespans are recorded.
Bulb # | Lifespan (hours) | ||
|---|---|---|---|
A | B | ||
1 | 1 | 985 | |
2 | 2 | 1050 | |
3 | 3 | 975 | |
4 | 4 | 1015 | |
5 | 5 | 1000 | |
6 | 6 | 990 | |
7 | 7 | 1020 | |
8 | 8 | 985 | |
9 | 9 | 1030 | |
10 | 10 | 1010 | |
11 | 11 | 1025 | |
12 | 12 | 990 | |
13 | 13 | 1005 | |
14 | 14 | 1030 | |
15 | 15 | 995 | |
16 | 16 | 1015 | |
17 | 17 | 1020 | |
18 | 18 | 970 | |
19 | 19 | 1045 | |
20 | 20 | 1015 | |
21 | 21 | 1010 | |
22 | 22 | 980 | |
23 | 23 | 1000 | |
24 | 24 | 1020 | |
25 | 25 | 995 | |
26 | 26 | 1010 | |
27 | 27 | 1035 | |
28 | 28 | 980 | |
29 | 29 | 1005 | |
30 | 30 | 1020 |
The Z.TEST function returns the one-tailed P-value. For a z-score of 0.457, the one-tailed P-value is 0.303804338.
In this case, 0.607608676>0.05. Therefore, we fail to reject the null hypothesis.
Final Summary Table:
Parameter | Value | ||
|---|---|---|---|
A | B | ||
1 | Population Mean (μ0) | 1,000 hours | |
2 | Population Standard Deviation (σ) | 80 hours | |
3 | Sample Size (n) | 30 | |
4 | Sample Mean () | 1006.67 hours | |
5 | Z-score | 0.457 | |
6 | One-tailed P-value (from Z.TEST) | 0.303804338 | |
7 | Two-tailed P-value | 0.607608676 | |
8 | Significance Level (α) | 0.05 | |
9 | Conclusion | Fail to reject the null hypothesis |
Based on this analysis, the manufacturer concludes that there is not enough statistical evidence to say that the new batch of lightbulbs has a lifespan different from the claimed average of 1,000 hours. The small difference observed in the sample is not statistically significant.
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof