Exercise 261. Plot the frequency distribution for “Age at Enrollment” by hand or by using SPSS. 2. How would you characterize the skewness of the distribution in Question 1—positively skewed, negatively skewed, or approximately normal? Provide a rationale for your answer. 3. Compare the original skewness statistic and Shapiro-Wilk statistic with those of the smaller dataset ( n = 15) for the variable “Age at First Arrest.” How did the statistics change, and how would you explain these differences? 4. Plot the frequency distribution for “Years of Education” by hand or by using SPSS. 5. How would you characterize the kurtosis of the distribution in Question 4—leptokurtic, mesokur-tic, or platykurtic? Provide a rationale for your answer. 6. What is the skewness statistic for “Age at Enrollment”? How would you characterize the magnitude of the skewness statistic for “Age at Enrollment”? 7. What is the kurtosis statistic for “Years of Education”? How would you characterize the magnitude of the kurtosis statistic for “Years of Education”? 8. Using SPSS, compute the Shapiro-Wilk statistic for “Number of Times Fired from Job.” What would you conclude from the results? 9. In the SPSS output table titled “Tests of Normality,” the Shapiro-Wilk statistic is reported along with the Kolmogorov-Smirnov statistic. Why is the Kolmogorov-Smirnov statistic inappropriate to report for these example data? 10. How would you explain the skewness statistic for a particular frequency distribution being low and the Shapiro-Wilk statistic still being significant at p < 0.05?

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.