Below is a summary of the expectations for Phase 5 of the course project: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.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?Calculate the measures of center and measures of variation. Interpret your results in context of the selected topic. MeanMedianMode Midrange RangeVarianceStandard DeviationDiscuss 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?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. 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. 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.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?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.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 two-tailed, left-tailed, or right-tailed? Explain.Which test statistic will you use for your hypothesis test; z-test or t-test? Explain.What is the value of the test-statistic? What is the P-value?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 p-value and the critical value.State the final conclusion in non-technical terms.ConclusionRecap 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.

Complete Case Study -- "Low Nail Company" from our text. Provide a brief discussion of your results for each question. - Provide your answers in a well-formatted EXCEL file, using this template -- Low Nail Company.xlsx - Limit the width of the workbook to 1 page using Portrait layout (to allow for printing and grading in Blackboard). Multiple pages "tall" are OK.- Label each question with titles and all answers with proper units (e.g. $, cases per order, $ per year, etc.). - Effective spreadsheet design must be used. For example, all input data must be shown in separate cells and all answers must be formulas that reference the input cells. In this way, any input can be quickly changed for immediate recalculation of your answers! This happens all the time on-the-job.