Business Statistics

320 Business Statistics

10.6.3 Using MS Excel for Hypothesis Testing with the z Statistic

MS Excel can be used for testing a hypothesis about the population mean in terms of using the p-value

approach for hypothesis testing. Click Insert on the MS Excel tool bar. The Insert Function dialog

box will appear on the screen. Select Statistical from Or select a category and select ZTEST from

Select a function and click OK (Figure 10.12).

The Function Arguments dialog box will appear on the screen (Figure 10.13). Type the location

of the data in Array. Type the hypothesized value of the mean in text box X. If population standard

deviation is known, ...