ECON7300: Statistical Project Assignment (Part 1), Semester 2, 2022 Part A: Note: for questions in Part A assume that the three assumptions underlying ANOVA (i.e., randomness and independence, normality and homogeneity of variance) are met. Ifthe degrees of freedom for the denominator are not on the table, use the closest value the table has. (1) Using Datasetl test at a 5% level of significance ifthere is any evidence of a signicant difference in the average number of absences (absence) for professors in three groups defined by department (department). Follow all the necessary steps to perform the test and verify your results using ExcelfPHStat. Note: in your data, \"department\" is coded 1 for professors in the department of Engineering; 2 for professors in the department of Economics, and 3 for professors in the department of Medicine. (2) If your results in (1) indicate that it is appropriate, use the Tukey-Kramer procedure to determine which groups of department differ in average number of absences. Use a 5% level of significance. Follow all the necessary steps to perform the test and verify your results using Exceli'PHStat. (3) Using Datasetl test at a 5% level of significance ifthere is any evidence of a signicant difference in the average contributions (contribution) made to United Way by three groups of managers defined by the type (type) of food business they manage. Note: in your data, the variable \"type" is coded 1 if bakery, 2 if catering, and 3 if organic food shop. (4) If your results in (3) indicate that it is appropriate, use the Tukey-Kramer procedure to determine which groups of type differ in average contributions made to United Way. Use a 5% level of significance. Follow all the necessary steps to perform the test and verify your results using Excelr'PHStat