Could someone provide with every step and the solution to perform the

question.docx

Home >Mathematics homework help >Numerical analysis homework help >Could someone provide with every step and the solution to perform the

Could someone provide with every step and the solution to perform the hypothesis test for the questions asked below using the data attached in the Excel spreadsheet.

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 σ 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?

-Explain why you made your decision including the results for your p-value and the critical value.

7. 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.