course Project Phase #5 and past corrects from feedback

I’m trying to learn for my Excel class and I’m stuck. Can you help?

In this module you will submit Phase 5, the final phase, of your course project. For Phase 5 of your course project, you will want to review your instructor’s feedback from your Phase 4 submission and make any necessary corrections. Remember if you have questions about the feedback to ask your instructor for assistance.

Once you have made your corrections, you will make your final submission for the course project. Below is a summary of the expectations for Phase 5 of the course project:

1.Introduce your scenario and data set.

oProvide a brief overview of the scenario you are given above and the data set that you will be analyzing.

oClassify the variables in your data set.

oWhich variables are quantitative/qualitative?

oWhich variables are discrete/continuous?

oDescribe the level of measurement for each variable included in your data set.

1.Discuss the importance of the Measures of Center and the Measures of Variation.

oWhat are the measures of center and why are they important?

oWhat are the measures of variation and why are they important?

2.Calculate the measures of center and measures of variation. Interpret your results in context of the selected topic.

oMean

oMedian

oMode

oMidrange

oRange

oVariance

oStandard Deviation

3.Discuss the importance of constructing confidence intervals for the population mean.

oWhat are confidence intervals?

oWhat is a point estimate?

oWhat is the best point estimate for the population mean? Explain.

oWhy do we need confidence intervals?

4.Based on your selected topic, evaluate the following:

oFind the best point estimate of the population mean.

oConstruct a 95% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.

oPlease show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.

oWrite a statement that correctly interprets the confidence interval in context of your selected topic.

5.Based on your selected topic, evaluate the following:

oFind the best point estimate of the population mean.

oConstruct a 99% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.

oPlease show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.

oWrite a statement that correctly interprets the confidence interval in context of your selected topic.

6.Compare and contrast your findings for the 95% and 99% confidence interval.

oDid you notice any changes in your interval estimate? Explain.

oWhat conclusion(s) can be drawn about your interval estimates when the confidence level is increased? Explain.

7.Discuss the process for hypothesis testing.

oDiscuss the 8 steps of hypothesis testing?

oWhen performing the 8 steps for hypothesis testing, which method do you prefer; P-Value method or Critical Value method? Why?

8.Perform the hypothesis test.

oOriginal Claim: The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.

oTest the claim using alpha = 0.05 and assume your data is normally distributed and the population standard deviation is unknown.

oBased on your selected topic, answer the following:

1.

1.

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?

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

7.

7.

7.State the final conclusion in non-technical terms.

10. Conclusion

1.Recap your ideas by summarizing the information presented in context of your chosen scenario.

Please be sure to show all of your work and use the Equation Editor to format your equations.

This assignment should be formatted using APA guidelines and a minimum of 2 pages in length.

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount