There are five parts to this problem. Use Excel or the visualization software of your or your instructor's choice to perform the following: 3 4 5 6 7 8 a. Scan the percentage of each year's total revenue for 2001, 2009, and 2018. What trends do you see? b. C. d. In the yellow shaded cells in the data table, input formulas to calculate the percentage change from 2001 to 2009, 2009 to 2018, and 2001 to 2018 [Percent change = (Later date value - Earlier date value) + Earlier date value]. Use the IFERROR function to calculate to avoid a division by zero error. (Formula inserted for Colorado that can be copied down for each column. Delete formula for Kansas 2009-2018 change.) Apply conditional formatting to all cells containing percentages to highlight the top three percentage changes in each column in orange shading, and the bottom three percentage changes in each column in blue shading (other than 0%). (Click Conditional Formatting and watch the "Tell me how" video. Apply formatting to each column separately.) Generate a column chart that graphs the percentage changes from 2001 to 2009 and 2009 to 2018 for all states except Kansas, and any states which display a zero percentage change through 2018. Include a descriptive chart title, axes labels, and a legend. (Under chart design, use select data to eliminate items not needed) e. Why do you think it is best to exclude Kansas from the chart in part d? Identify which states hold the highest potential and lowest potential for further expansion of gaming revenue. Explain.