MTH410 Colorado State University Managerial Report Paper

PAPER & EXCELL T BE TURNED IN: ALL ORIGINAL & EXCELL NEEDS TO SHOW PROOF OF WORK
Quality at A1 Hotels
A1 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 up above is considered to be “dissatisfied.” Traditionally, 40% of customers have been dissatisfied.
A1 Hotels would like to study customer satisfaction. Therefore, 200 survey responses were recently chosen at random for analysis. The complete data set is in the file named Hotels.
Managerial Report
Prepare a report (see Module folder) 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 that
Answered “Poor” to room quality.
Answered “Poor” to food quality.
Answered “Poor” to service quality.
Develop the 92% confidence interval for the proportion of all recent clients that were “dissatisfied.” What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.
Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to room quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.
Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to food quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.
Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to service quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.
Conduct a hypothesis test (using either the p-Value Approach or 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. Do not forget to include the correctly worded hypotheses and show all the steps required to conduct the hypothesis test.
What advice would you give to A1 Hotels based upon your analysis of the data? What is the magnitude of the issue? How can this study be improved?
Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements (Links to an external site.)Links to an external site.. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics. (link provided in the Modules tab)
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.)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 Virtual Library CSU-Global Guide to Writing and APA: Introduction (Links to an external site.)Links to an external site.. A short summary co