module 3 assignment excel and paper.
I’m studying and need help with a Excel question to help me learn.
/0x4*
In this module you will begin working on Phase 3 of your course project. Using the same data set and variables the following analysis:
 Discuss the process for hypothesis testing.
 Discuss the 8 steps of hypothesis testing?
 When performing the 8 steps for hypothesis testing, which method do you prefer; PValue method or Critical Value method? Why?
 Perform the hypothesis test.
 Original Claim: The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.
 Test the claim using α = 0.05 and assume your data is normally distributed and σ, the population standard deviation, is unknown.
 Based on your selected topic, answer the following:


 Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim.
 Is the test twotailed, lefttailed, or righttailed? Explain.
 Which test statistic will you use for your hypothesis test; ztest or ttest? Explain.
 What is the value of the teststatistic? What is the Pvalue?
 What is the critical value?
 What is your decision; reject the null or do not reject the null?
 Explain why you made your decision including the results for your pvalue method or the critical value method.
 State the final conclusion in nontechnical terms.

Please show your work for the construction of the teststatistic and explain your process for finding the pvalue and critical value. Be sure to use the Equation Editor to format your equations.
This assignment should be formatted using APA guidelines and a minimum of 2 pages in length. 