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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!