(a) Write an Excel formula to generate a random normal deviate from N(0,1) and copy the formula into 10 cells. (b) Find the mean and standard deviation of your sample of 10 random data values. Are you satisfied that the random data have the desired mean and standard deviation? (c) Press F9 to generate 10 more data values and repeat question (b).
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here