X ... Comments Conditional Formatting v Styles v Format As Table ~ Insert * = Delete ~ Format > > Ov Ery Ov Shey ToolPak M N O P Q R S T U V XLMiner Analysis ToolPak X Anova: Single Factor Anova: Two-Factor With Replication Anova: Two-Factor Without Replication Correlation Covariance Descriptive Statistics Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram Linear Regression Logistic Regression Moving Average Random Number GenerationExcel template - Saved v Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Comments Arial 10 A" A ab Wrap Text General O LG Paste BIUDabYAv Merge & Center $ ~ % 9 08 .00 Conditional Format As Styles Insert Delete Format Editing Formatting Table v Undo Clipboard Font Alignment Number Styles Cells A X V fx v A B C D E F G H I J K L M N Revenue ($ Year Year millions) Formula Part a Use the area below to draw a time series plot. 8. 16 #N/A 10.72 #N/A 13.20 #N/A 14.07 #N/A 16.10 #N/A SESDOVOUAWNH 17.38 #N/A 17.94 #N/A 18.46 #N/A 18.18 #N/A 18.61 #N/A 13 14 15 16 17Part b After reading these instructions delete all text in this shaded area. Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis. After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H19). Your Linear Regression analysis output should fit into this shaded area.\fa. Choose the correct time series plot for the data. 20 Revenue (Smillions) 18 16 -14 -12 -10 A. -6 -4 -2 2 4 6 7 9 10 Year20 Revenue (Smillions) -18 -16 -14 -12 B. .10 . 6 -4 6 00 9 10 YearThe correct time series plot is Comment on the appropriateness of a linear trend. b. Develop a quadratic trend equation that can be used to forecast revenue (to 4 decimals). It = bo+ bit+ but? bo b1 : by : c. Using the trend equation developed in part (b), forecast revenue in year 11 (to 2 decimals).Video Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Giovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive marketing strategy they have been able to increase their annual revenue by approximately $10 million over the past 10 years. But increased competition has slowed their growth rate in the past few years. The annual revenue, in millions of dollars, for the previous 10 years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. X Open spreadsheet