Trend Projection is a time-series forecasting models that examines historical data. The quantitative goal is to fit the data trend line to a series of historical data points. The qualitative goal is to use the data as a means to project medium to long-term forecast plans. In Industry, this is the method to reduce the SSE, Sum of Squares Errors.

Assignment: Given the following data, create a Trend Projection with Least Squares Analysis. Compute the slope and intercept of the line. Use the Slope and Intercept data to project demand for 2020. Hint: You need to change the Data to reflect the more recent years:

Background: Trend Projection is a time-series forecasting models that examines historical data. The quantitative goal is to fit the data trend line to a series of historical data points. The qualitative goal is to use the data as a means to project medium to long-term forecast plans. In Industry, this is the method to reduce the SSE, Sum of Squares Errors. Assignment: Given the following data, create a Trend Projection with Least Squares Analysis. Compute the slope and intercept of the line. Use the slope and Intercept data to project demand for 2020. Hint: You need to change the Data to reflect the more recent years: Boston Data Servers Inc.: Demand Forecast Data Server Demand 91 101 Forecast Year 2013 2014 2015 2016 2017 2018 2019 137 1. What is the equation of the line: Slope and Intercept? 2. Project the demand for 2020, using x=8 (since we are forecasting for the next period, period 8) 3. Boston Data Servers received a call, confirming that Amazon is moving to Boston. They need to revise the new demand for 2019 to 300 units. 4. What is the new equation of the line: slope and intercept? 5. Project the Demand with the revised projection, using x=8 6. To evaluate the model, we compare the historical demand and the trend line. Please comment on your personal findings