Question: Instructions: In one Excel file create one sheet and label it Problem 1. You should clearly label each part of the problems with (a), (b),

Instructions:

In one Excel file create one sheet and label it "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 my 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

(4 points) Calculate the value of the z test statistic.

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

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

(5 points) If 2.054 z2.326,then between what two numbers does the P-value lie?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!