. Advertisement .

..3..

. Advertisement .

..4..

4) Given that z is a standard normal random variable, find z for

each situation (using excel):

The area to the left of z is .9750.

The area between 0 and z is .4750.

The area to the left of z is .7291.

The area to the right of z is .1314.

The area to the left of z is .6700.

The area to the right of z is .3300.

Excel has a function called NORMSINV (x), which returns the inverse distribution of the normal cumulative distribution.

1.

=NORMSINV(0.9750)

1.959964

2.

=NORMSINV(0.475+0.5)

1.959964

3.

=NORMSINV(0.7291)

0.610093

4.

=NORMSINV(1-0.1314)

1.119798

5.

=NORMSINV(0.6700)

0.439913

6.

=NORMSINV(1-0.3300)

0.439913