Question: Lab: 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
Lab: 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.
Given the following data, create a Trend Projection with Least Squares Analysis. Compute the slop and intercept of the line. Use the Slope and Intercept data to project demand for 2018. Hint: You need to change the Data to reflect the more recent years:
Boston Data Servers Inc.: Demand Forecast
| Forecast Year | Data Server Demand |
| 2011 | 91 |
| 2012 | 101 |
| 2013 | 85 |
| 2014 | 99 |
| 2015 | 147 |
| 2016 | 180 |
| 2017 | 137 |
5. To evaluate the model, we compare the historical demand and the trend line. Please comment on your personal findings.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
