(a) Write an Excel formula to generate a random normal deviate from N(4000, 200) and copy the formula into 100 cells. (b) Find the mean and standard deviation of your sample of 100 random data values. Are you satisfied that the random data have the desired mean and standard deviation? (c) Make a histogram of your sample. Does it appear normal?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here