Question

find the area under the standard normal curve. use excel. round the answers to at least four decimal places.
part: 0 / 4
part 1 of 4
(a) find the area under the standard normal curve that lies between z = -2.48 and z = -1.33.
the area between z = -2.48 and z = -1.33 is

Explanation:

Step1: Recall Excel function for normal distribution

To find the area under the standard normal curve between two z - scores \( z_1=- 2.48\) and \( z_2 = - 1.33\), we use the NORM.S.DIST function in Excel. The area between two z - scores \( z_1\) and \( z_2\) (where \( z_1

Step2: Calculate \( \text{NORM.S.DIST}(-1.33, \text{TRUE})\)

In Excel, we input =NORM.S.DIST(-1.33, TRUE). The NORM.S.DIST function with the second argument set to TRUE returns the cumulative distribution function (CDF) for the standard normal distribution. Calculating this, we get approximately \( 0.0918\)

Step3: Calculate \( \text{NORM.S.DIST}(-2.48, \text{TRUE})\)

In Excel, we input =NORM.S.DIST(-2.48, TRUE). Calculating this, we get approximately \( 0.0066\)

Step4: Find the difference

Subtract the two CDF values: \( 0.0918 - 0.0066=0.0852\)

Answer:

\( 0.0852\)