Embedded Files
COMPUTATION OF P VALUE USING Z TEST
z testA z-test is a statistical test used to determine whether two population means are different when the variances are known and the sample size is large. Z-tests are closely related to t-tests, but t-tests are best performed when an experiment has a small sample size. Z-tests assume the standard deviation is known, while t-tests assume it is unknown.Steps to Calculate the Z Test :
- To select the z-test tool, click the Data tab’s Data Analysis command button.
- When Excel displays the Data Analysis dialog box, select the z-Test: Two Sample for Means tool and then click OK.
- Excel then displays the z-Test: Two Sample for Means dialog box.
- In the Variable 1 Range and Variable 2 Range text boxes, identify the sample values by telling Excel in what worksheet
- Use the Hypothesized Mean Difference text box to indicate whether you hypothesize that the means are equal. Enter 0 (zero) into this text box or leave the text box empty.
- Use the Variable 1 Variance (Known) and Variable 2 Variance (Known) text boxes to provide the population variance for the first and second samples.
- In the Alpha text box, state the confidence level for your z-test calculation.
- The confidence level is between 0 and 1. By default, the confidence level equals 0.05 (equivalent to a 5-percent confidence level).
- In the Output Options section, indicate where the z-test tool results should be stored.
- To place the z-test results into a range in the existing worksheet, select the Output Range radio button and then identify the range address in the Output Range text box. If you want to place the z-test results someplace else, use one of the other options.
- Click OK.
Page updated
Report abuse