. Darcy Sears is a manager of a high-speed rail service between two major metro areas. Darcy is analyzing three years (36 months) of data on the number of passengers who ride the high-speed train and has created the following chart. LO 8 Passenger Traffic on High-Speed Train Passengers (1000s) 35 30 25 20 15 10 5 0 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month Based on her experience with the rail service, Darcy believes there is a seasonal pattern in amount of passenger traffic on the high-speed train. However, Darcy is disappointed that her chart does not clearly display seasonality. How should Darcy better visualize a seasonal pattern in the data? i. Create a different data series for each year consisting of 12 monthly observations and plot these three separate lines on a new chart with the month labels January through December on the horizontal axis. ii. Aggregate the monthly observations into yearly observations and plot the data on a new chart with Year on the horizontal axis. iii. Add a linear trendline to the chart above. iv. Add a moving average with a period equal to the length of the seasonal pattern. The file TaxData contains information from federal tax returns filed in 2007 for all counties in the United States (3,142 counties in total). Create an Excel Table based on these data. Using Excel Table functionality, answer the following questions. a. Which county had the largest total adjusted gross income in the state of Texas? b. Which county had the largest average adjusted gross income in the state of Texas?