Need help with excel homework

In one Excel file label one sheet "Problem 1." You should clearly

label each part of the problems with (a), (b), etc., and every computation should be labeled. For

example, in the cell next to the mean of the data, you should have typed the word mean or average.

Please make sure to do computations using Excel. Do not do computations using Tables A

and C or on a calculator and then type the answers into Excel.

A random number generator is supposed to produce random numbers that are uniformly distributed

on the interval from 0 to 1. If this is true, the numbers generated come from a population with

= 0.5 and = 0.2887 . A command to generate 100 random numbers gives outcomes with mean

x= 0.4365 . Assume that the population remains fixed. We want to test

H0: = 0.5 and Ha: 0.5

a)

Calculate the value of the z test statistic.

b)

Is z statistically significant at the 5% level (= 0.05), show your work?

c)

Is z statistically significant at the 1% level (= 0.01), show your work?

d)

If 2.054 Z 2.326, then between what two numbers does the P-value lie?