Please help with number 3.4.5. Any help would be appreciated.

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 2011 2012 2013 2014 2015 2016 2017 Data Server Demand 91 101 85 99 147 180 137 3. Boston Data Servers received a call, confirming that Amazon is moving to Boston. They need to revise the new demand for 2017 to 300 units. Now, adjust the demand for 2017 in your Excel sheet. Observe the changes. 4. What is the new equation of the line: slope and intercept? In other words, what is the demand for the next period? 5. To evaluate the model, we compare the historical demand and the trend line. Please comment on your personal findings. X 1 (x-x) 1. Trendline equation is y = 12.786x + 68.857 estimated slope. B1 =SSxy/SSxx = 358.0 / 28.000 = 12.7857 9 (x-3)(y-) 87 38 35 4 91 101 85 199 147 intercept, BO = 7-81* x = 68.8571 1 (y-9) 841 361 1225 441 729 3600 289 0 0 27 1 4 120 180 137 51 2. using x=8 F-8 = y = 12.786x3 + 68.857 = 171.145