Question

use excel to find the z-score for which the area to its right is 0.87. round the answer to two decimal places.
the z-score for the given area is 1.13.

Explanation:

Step1: Understand the problem

We need to find the z - score such that the area to its right is 0.87. The area to the left of the z - score will be \(1 - 0.87=0.13\).

Step2: Use Excel function

In Excel, we can use the NORM.S.INV function which returns the inverse of the standard normal cumulative distribution. The NORM.S.INV function takes the probability (area to the left) as an argument. So we use NORM.S.INV(0.13).

Calculating this in Excel (or using a standard normal distribution table - lookup for the area 0.13), we know that the z - score corresponding to an area of 0.13 to the left is approximately - 1.13 (because the area to the right of - 1.13 is \(1 - 0.13 = 0.87\)).

Answer:

• 1.13