Locate the results of a recent survey that shows at least two variables in a newspaper, magazine, or internet article. Outline the survey data so that your peers can understand the variables and results, and then identify at least one key formula from this module that you could use to evaluate the data. Provide a brief explanation of why you selected the formula you did and why it matters.See attached module formulas info for your reference.2-3 substantial paragraphs

InstructionsYou are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients.You do some research and put together a spreadsheet of the data that contains the following information:Client numberInfection disease statusAge of the patientYou are to put together a PowerPoint presentation that explains the analysis of your findings which you will submit to your manager. The presentation should contain all components of your findings. For review, the components of the report should include:Brief overview of the scenario and variables in the data setDiscussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and varianceDiscussion, construction, and interpretation of the 95% confidence intervalExplanation of the full hypothesis testConclusionThe calculations should be performed in your spreadsheet that you will also submit to your manager. You can find additional information on what to add to your PowerPoint presentation in this Word document . Use the questions in the worksheet as your guide for the contents of your presentation.For your final deliverable, submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document.

Option #1: Critical Thinking: Quality at A1 HotelsA1 Hotels operates luxury hotels throughout the world. Recently, motivated by some incidents that appeared in the news, they have been concerned about the quality of service. The company has been giving the following survey to its clients after their stay:How would you rate the quality of your room? Select one.Good(G), Poor(P)How would you rate the quality of your food? Select one.Good(G), Poor(P)How would you rate the quality of your service? Select one.Good (G), Poor(P)Any customer who answered "Poor" to at least one of the three questions above is considered to be "dissatisfied." Traditionally, 40% of customers have been dissatisfied.A1 Hotels would like to see if the recent level of customer satisfaction has changed. Therefore, 200 survey responses were recently chosen at random for analysis. The complete data set is in the file named Hotels.Managerial ReportPrepare a report (see below) for A1 Hotels that summarizes your assessment of customer satisfaction. Be sure to include the following seven items in your report.To summarize the data, compute the proportion of all clients thatAnswered "Poor" to room quality.Answered "Poor" to food quality.Answered "Poor" to service quality.What do these three proportions tell you about customer satisfaction at A1 hotels? What graphical displays of data would you use to understand or explain the results of the survey?What is the point estimate of the proportion of all recent clients who were "dissatisfied?" Develop the 92% confidence interval for the proportion of all recent clients who were "dissatisfied." Interpret what the confidence interval tells you about the proportion of all recent clients who were "dissatisfied." What is the corresponding margin of error? How can the margin of error be decreased?Develop the 92% confidence interval for the proportion of all recent clients who answered "Poor" to room quality. Interpret what the confidence interval tells you about the proportion of all recent clients who answered "Poor" to room quality. What is the corresponding margin of error? How can the margin of error be decreased?Develop the 92% confidence interval for the proportion of all recent clients who answered "Poor" to food quality. Interpret what the confidence interval tells you about the proportion of all recent clients who answered "Poor" to food quality. What is the corresponding margin of error? How can the margin of error be decreased?Develop the 92% confidence interval for the proportion of all recent clients who answered "Poor" to service quality. Interpret what the confidence interval tells you about the proportion of all recent clients who answered "Poor" to service quality. What is the corresponding margin of error? How can the margin of error be decreased?Conduct a hypothesis test, using both the p-Value Approach and the Critical Value Approach, to determine if the proportion of all recent clients is more dissatisfied than the traditional level of dissatisfaction. Use α = 0.08 level of significance. Do not forget to include the correctly worded hypothesis and show all of the steps required to conduct the hypothesis test.What would be possible effects of a lower and then of a higher level of significance?What other hypothesis tests would you use to better understand hotel customer satisfaction?What advice would you give A1 Hotels based upon your analysis of the data?What is the magnitude of the improvement (if any)?How can this study be improved?Write a report that adheres to the formatting and APA expectations outlined on the CSU Global Writing Center (Links to an external site.). As with all written assignments at CSU Global, you should have in-text citations and a reference page.Submit your Excel file in addition to your report.Requirements:Paper must be written in third person.Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library (Links to an external site.) is a great place to find resources.Include a title page, introduction, body, conclusion, and a reference page.The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.Document formatting, citations, and style should conform to the CSU Global Writing Center (Links to an external site.). A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper (Links to an external site.). In addition, information in the CSU Global Library (Links to an external site.) has many helpful areas (Writing Center, Writing Tips, Template Examples/Papers Essays, and others).