In this Task, you will be creating a Trend component in Column L. To calculate the "Trend Component" ( Tt ) you will need to Create a regression analysis using the "Deseasonalized Data" as the Y-variable (in Column K) and "t" (time period in Column C) as our X-variable. Make sure you pick up only the rows with data, not the 2019 Forecast rows (17 - 20). Use Data -> Data Analysis -> Regression. Follow the instructions on the Video (Part 3 of 3) to complete this part of the analysis. When asked where to insert the regression Analysis use B71. The constants you receive from the regression analysis will be used in Task 2