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 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 Citing & APA Resources page (Links to an external site.) in the CSU-Global Writing Center. 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.