Please answer with Excel functions. Thanks Suppose that you want to run a hypothesis test on the population proportion. You have a sample of 300 observations and the sample proportion is 0.63. Provide the following: Setup a two-tailed hypothesis test to test whether the population proportion is equal to 0.70. Use a level of significance of 0.05. Provide the following: a. State your null and alternative hypotheses. Use a two tailed test. b. Determine the test statistic c. Determine the p-value d. Determine the critical values for the hypothesis test. e. Determine the 95% confidence interval for the population proportion. f. Clearly explain whether one should reject or not reject the null hypothesis at a 5% level of significance. Explain your reasoning.
Please answer with Excel
Suppose that you want to run a hypothesis test on the population proportion.
You have a sample of 300 observations and the sample proportion is 0.63.
Provide the following:
Setup a two-tailed hypothesis test to test whether the population proportion is equal
to 0.70. Use a level of significance of 0.05. Provide the following:
a. State your null and alternative hypotheses. Use a two tailed test.
b. Determine the test statistic
c. Determine the p-value
d. Determine the critical values for the hypothesis test.
e. Determine the 95% confidence interval for the population proportion.
f. Clearly explain whether one should reject or not reject the null
hypothesis at a 5% level of significance. Explain your reasoning.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 6 images
