# module 3 assignment excel and paper

I’m studying and need help with a Excel question to help me learn.

In this module you will begin working on Phase 3 of your course project. Using the same data set and variables the following analysis:

1. 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; P-Value method or Critical Value method? Why?
2. 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.
1. Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim.
2. Is the test two-tailed, left-tailed, or right-tailed? Explain.
3. Which test statistic will you use for your hypothesis test; z-test or t-test? Explain.
4. What is the value of the test-statistic? What is the P-value?
5. What is the critical value?
6. What is your decision; reject the null or do not reject the null?
7. Explain why you made your decision including the results for your p-value method or the critical value method.
8. State the final conclusion in non-technical terms.

Please show your work for the construction of the test-statistic and explain your process for finding the p-value 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.