Part 1. ANOVA Sorting Data Filter data to only include students who enrolled at the university. HINT: See \"Data Management 1\" video on the Unit 2 Project Assignment in Canvas for demonstrations of filtering data in Excel along with notes on stacked data. Part 1a. Perform a one-way ANOVA. 1a-1. Perform a one-way ANOVA to determine if there are differences in college grade point average across the three different colleges in the university. Report the F-statistic and the p-value of your one-way ANOVA. 1a-2. At the 5% significance level, what is the conclusion to your analysis? (Your response should be in complete sentences.) Part 1b. Create confidence intervals for the differences of means. 1b-1. Use Tukey's HSD method to determine which means differ. Provide the 95% confidence intervals in the provided table. Lower Bound of CI Upper Bound of CI Business & Economics Arts & Letters Math & Science - Arts & Letters ] Math & Science Business & Economics 0] 1b-2. At the 5% significance level, what can you conclude? Which colleges differ in average college grade point average? (Your response should be in complete sentences.) Part 1c. Perform a two-way ANOVA without interaction. 1c-1. Perform a two-way ANOVA with no interaction to determine if there are differences in college grade point average across College and Gender. Provide the F-statistics and p-values for both variables. College | | | 1c-2. At the 5% significance level, what can you conclude about the differences in college GPA by gender and by college? (Your response should be in complete sentences.) Part 1d. Perform a two-way ANOVA with interaction. 1d-1. Perform a two-way ANOVA with interaction to determine if there is interaction between gender and college. Provide the F-statistic and the p-value for the interaction. 1d-2. At the 5% significance level, can you conclude that an interaction between gender and college exists? (Your response should be in complete sentences.)