Can you show me how to do this question using excel ?
In a recent article published by Scientific American found that only 75% of Millennials are certain the world is round. That seems low to you, you believe that more than 75% of Millennials believe the world is round. You randomly sample 79 Millennials and find that 66 of them believe the earth is round. The others didn't necessarily believe it is flat they might just be unsure of the earth's shape. a. Select the correct answer for null and alternative hypotheses for this test. HO:P = 0.75 HO:p = 0.75 HO:M = 0.75 Hap > 0.75 Ha:p 0.75 Ha:u + 0.75 Ha:p + 0.75 b. Match each statement with the name of the conclusion for this hypothesis test. - When, in reality, the population proportion is greater than 0.75 we conclude that it is greater than 0.75. This is a -When, in reality, the population proportion is 0.75, we conclude the proportion is greater. This is a -When, in reality, the population proportion is greater than 0.75, we conclude that no evidence it is not 0.75. This is a a. Type | error b. Correct Decision C. Type II error c. What conditions must be met for you to conduct a Z test for one proportion? (select ALL the correct answers) The claim is about a single mean. You are counting the total number of successes in a fixed number of trials. The population can reasonably be assumed to be normal because sample has approximately a normal distribution. The sample is random. The sample is not known to be random. The claim is about a single proportion. The sample size is large enough. d. The p-value is (rounded to 4 decimal places) e. At 0.08 significance level, we conclude that There is enough evidence to claim the proportion of Millennials is truly 75%. There is no enough evidence to support the claim that more than 75% of the population of Millennials believe the world is round. (That is, 75% is a plausible value for the population proportion of Millennials who believe the world is round ) There is statistically significant evidence that more than 75% of the population of Millennials believe the world is round