For a standard normal random variable z, find P(1.2

1. Name columns A and B of a spreadsheet as "20", and "P(z

2. Enter the location of first value of zo (cell A2) into the first box and the word TRUE into the second box. The resulting probability is marked as "Formula result =0.8849" at the bottom of the box, and when you click OK, the prob- ability P(z 1.2) will appear in cell B2. To obtain the other probability, simply place your cursor in cell B2, grab the square handle in the lower right corner of the cell and drag the handle down to copy the formula into the other cell and

Transcribed Image Text:

Function Arguments NORMS DIST 2 A2 Cumulative TRUL TRUE -0.86450033 Returns the standard cormal distribution has a mean of zero and a standard deviation of one). Cumulative e is a logical value for the function to rebum: the cumulative distribution function -TRUE; the probaty malty funcion-FALSE Formula result 0.0019 Canal