In Example 23.4, we showed that the Excel command NORMSDIST(z) gives the area below the standardized score z. Use Excel or an appropriate calculator, software, website, or table to find the p-value for each of the following examples and case studies, taking into account whether the test is one-sided or two-sided:
a. Example 23.3, pages 501–502, z = 2.17, two-sided test (using z, not t)
b. Example 22.1, pages 473–475, z = 2.00, one-sided test
c. Case Study 22.1 pages 486– 489, z = 4.09, one-sided test