Question

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.

Answer 1

There exists a function in Excel called NORMSINV(x) which returns the inverse of the standard 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

Answer 2