Z.TEST


Calculates the one-tailed P-value of a z-test.

Syntax:

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
 
 

Application:

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.


  • Hypothesis: The company wants to test if the mean lifespan of the new batch is still 1,000 hours.
    • Null Hypothesis (H0​): The true mean lifespan is 1,000 hours.
    • Alternative Hypothesis (Ha​): The true mean lifespan is not 1,000 hours.
  • Given Values:
    • Population Mean (μ0​): 1,000 hours (The value we are testing against).
    • Population Standard Deviation (σ): 80 hours (Known from historical data).
    • Sample Size (n): 30
    • Significance Level (α): 0.05 (This is a common value, representing a 5% risk of incorrectly rejecting the null hypothesis).
  • Sample Data: The quality control team collects the following lifespan data from the 30 bulbs:

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

  • Calculations: First, we calculate the sample mean () from the collected data.

    Sum = 985 + 1050 + 975 + ... + 1020 = 30200
    =​=1006.67 hours
  • Using the Z.TEST Function: The Z.TEST function in a spreadsheet program would be used with the following syntax: Z.TEST(data_range, population_mean, [population_std_dev]) =Z.TEST({985, 1050, ..., 1020}, 1000, 80)
  • Results: The Z.TEST function calculates the one-tailed P-value. Let's calculate the z-score manually to show the result. The formula for the z-score is:

    Plugging in the values:



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.


  • Conclusion: Since our alternative hypothesis is "not equal to" (a two-tailed test), we need to double the one-tailed P-value returned by Z.TEST. Two-tailed P-value = 2×0.303804338=0.607608676.
  • Decision Rule: We compare the P-value to the significance level (α).
  • If P-value ≤α, we reject the null hypothesis.
  • If P-value >α, we fail to reject the null hypothesis.


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.




This page is protected by Google reCAPTCHA. Privacy - Terms.
 
Built using Zapof