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 .

Explanation:

Step1: Understand the problem

We need to find the z - score such that the area to its right is 0.87. In the standard normal distribution, the total area under the curve is 1. So 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 to find the z - score corresponding to a given cumulative probability (area to the left). The NORM.S.INV function takes the cumulative probability as an argument. So we use NORM.S.INV(0.13) to find the z - score.

When we calculate NORM.S.INV(0.13) in Excel, we get approximately - 1.13 (rounded to two decimal places).

Answer:

• 1.13