Bb Assignments - F21 OPER1401-08 X Bb 7826077 X Homework Help - Q&A from Onl X + X > C A https://learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5b27d18c3e26e/7826077?X-Blackboard-Expiration=1633068000000&... O . . . E 7826077 79% + For this assignment you are to perform some research. Find time series data on something you want to forecast using either a Trend or Linear Regression model. The data you include in your forecasting model must be sourced and cited. You are to include 5 or 6 data sets in your model. All model calculations are to be completed using table provided below. Use your model to develop two forecasts using what ever independent variable ( x value ) you choose. If you use a trend model then your x values must represent future periods. Do Not modify/move/change the spreadsheet. Part1: 2 points Question Brief Answer Forecast model used [ ] Trend or [ ] Linear Regression Data set used (1) (2) (3) (4) (5) (6) Citing of source What are your forecasting Part 2: 6 points Forecasting Model NOTE: Enter the requested data in ALL shaded areas. Independent Dependant Variable Variable Year (X ( Y ) x2 XY 1.00 2.00 3.00 4.00 5.00 6.00 EX= Zy= TEX2= Exy X = y = Part 3: 9 points (slope) b= (y intercept) a = First Forecast Second Forecast X value X value Forecast Forecast Part 4: 3 points Analysis : describe what does your two forecasts are predicting