Question 1: An airline wants to select a computer software package for its reservation system. Four

Question 1: An airline wants to select a computer software package for its reservation system. Four software packages (1, 2, 3, and 4) are commercially available. The airline will choose the package that bumps as few passengers as possible during a month. An experiment is set up in which each package is used to make reservations for 5 randomly selected weeks. (A total of 20 weeks was included in the experiment.) The number of passengers bumped each week is obtained, which gives rise to the following Excel output:ANOVA Source of Variation SS df MS F P-value F critBetween Groups 212.4 3 8.304985 0.001474 3.238867 Within Groups 136.4 8.525 Total 348.8 a) What is the within groups degrees of freedom for this analysis? Explain how you obtain your answer.b) What is the total degrees of freedom? Explain how you obtain your answer.c) What is the among-group (between-group) mean squares? Explain how you obtain your answer.d) At a significance level of 1%, what conclusion can you infer? Explain how you obtain your answer.Question 2: A realtor wants to compare the average sales-to-appraisal ratios of residential properties sold in four neighborhoods (A, B, C, and D). Four properties are randomly selected from each neighborhood and the ratios recorded for each, as shown below.A: 1.2, 1.1, 0.9, 0.4 C: 1.0, 1.5, 1.1, 1.3B: 2.5, 2.1, 1.9, 1.6 D: 0.8, 1.3, 1.1, 0.7Interpret the results of the analysis summarized in the following table:Source df SS MS F PR > FNeighborhoods 3.1819 1.0606 10.76 0.001 Error 12 Total 4.3644a) What is the within group sum of squares for this analysis? Explain how you obtain your answer.b) What is the within group mean squares for this analysis? Explain how you obtain your answer.c) At the 0.05 level of significance, is there evidence of a difference in the mean ratios for the 4 neighborhoods? Explain how you obtain your answer.Question 3: (Continuing with the analysis in Question 2….)a) What is the null hypothesis for Levene’s test for homogeneity of variances?b) What are the numerator and denominator degrees of freedom for Levene’s test for homogeneity of variances at a 5% level of significance are, respectively? Explain how you obtain your answer.c) What is the value of the test statistic for Levene’s test for homogeneity of variances? Explain how you obtain your answer.d) What is the critical value of Levene’s test for homogeneity of variances at a 5% level of significance? Explain how you obtain your answer.e) What should be the decision for the Levene’s test for homogeneity of variances at a 5% level of significance? Explain how you obtain your answer.f) What should be the conclusion for the Levene’s test for homogeneity of variances at a 5% level of significance?A) There is not sufficient evidence that the variances are all the same.B) There is sufficient evidence that the variances are all the same.C) There is not sufficient evidence that the variances are not all the same.D) There is sufficient evidence that the variances are not all the same.