course project 4 all work must be shown in excel as well as the paper

In this module, you will begin working on Phase 4 of your course project. For Phase 4 of your course project, you will want to review your instructor’s feedback from your Phase 1, Phase 2, and Phase 3 submissions to 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 compile your information from Phase 1, Phase 2, Phase 3 and your final conclusion into one submission and submit this as your rough draft for Phase 4 of the course project. Below is a summary of the expectations for Phase 4 of the course project:

  1. Introduce your scenario and data set.
    • Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.
    • Classify the variables in your data set.
      • Which variables are quantitative/qualitative?
      • Which variables are discrete/continuous?
      • Describe the level of measurement for each variable included in your data set.
  2. Discuss the importance of the Measures of Center and the Measures of Variation.
    • What are the measures of center and why are they important?
    • What are the measures of variation and why are they important?
  3. Calculate the measures of center and measures of variation. Interpret your results in context of the selected topic.
    • Mean
    • Median
    • Mode
    • Midrange
    • Range
    • Variance
    • Standard Deviation
  4. Discuss the importance of constructing confidence intervals for the population mean.
    • What are confidence intervals?
    • What is a point estimate?
    • What is the best point estimate for the population mean? Explain.
    • Why do we need confidence intervals?
  5. Based on your selected topic, evaluate the following:
    • Find the best point estimate of the population mean.
    • Construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.
      • Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.
    • Write a statement that correctly interprets the confidence interval in context of your selected topic.
  6. Based on your selected topic, evaluate the following:
    • Find the best point estimate of the population mean.
    • Construct a 99% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.
      • Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.
    • Write a statement that correctly interprets the confidence interval in context of your selected topic.
  7. Compare and contrast your findings for the 95% and 99% confidence interval.
    • Did you notice any changes in your interval estimate? Explain.
    • What conclusion(s) can be drawn about your interval estimates when the confidence level is increased? Explain.
  8. 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?
  9. 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 alpha = 0.05 and assume your data is normally distributed and the population standard deviation is unknown.
    • Based on your selected topic, answer the following:
      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?
      1. Explain why you made your decision including the results for your p-value and the critical value.
      1. State the final conclusion in non-technical terms.

10. Conclusion

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

Submit your completed assignment to the drop box below, include both the Word document for your report and the Excel workbook with the data set and all work shown. Please check the Course Calendar for specific due dates.

Save your assignment as a Microsoft Word document. (Mac users, please remember to append the “.docx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Jstudent_exampleproblem_101504