Use Excel $($or an equivalent spreadsheet$)$ to answer the following question.

Reminder: you must do the computation on the "Computations" worksheet found in the workbook you downloaded from this assignment.

You have been told that the value of a "less than" ie lower tail probability is $0\mathrm{.}9788.$ What is the mystery $z-$value, $z,$ that satisfies the expression $P(Zz)=0\mathrm{.}9788?$

What should you have entered into the cell?

Use Excel to compute the z$-$value, rounded to $4$ decimal places.

Cell: "NORM.S$.$INV$(0\mathrm{.}9788)"$

z$-$value: a word displayed

Cell: $"=$ NORM.S$.$INV$(0\mathrm{.}9788)"$

$z-$value $=2\mathrm{.}03$

Cell: $"=$NORM.S$.$INV$(0\mathrm{.}9788)"$

$z-$value $=+1\mathrm{.}81191$

Cell: $"=$ NORM.S$.$INV$(0\mathrm{.}9788)"$

$z-$value $=2\mathrm{.}0296$

Question $4$

$1$ pts

$1$ in$.$ of snow The