Using Z-Test in Excel

Condition: The population conforms to the normal distribution. Samples with a random capacity of N are randomly sampled and the samples subject to normal distribution.

The aim of our experiment was to test whether there were significant differences in pork prices in two regions.

Hypothesis: There is no significant difference in pork prices in two regions

Steps:

1. Use the random number generator in Excel to generate two of the total to be tested.

Pork Price 1:

Pork Price 2:

Get the experimental data to be tested:

2. use descriptive statistics to obtain a perceptual knowledge of the data.

3. Determine the level of significance of 0.05, using the Z-Test tool.

4. Analysis Results

A P-value of 0.002095<<0.05 does not support the original hypothesis.

5. Conclusion: There are significant differences in pork prices in two regions.

Using Z-Test in Excel