Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast of the demand in the next 3 years? [20 marks] c. Does the forecast follow seasonality? [5 marks] 2. Create a forecast using the excel built-in feature for the sales in the 12 months of 2017 for the data set provided similar to question 1. Take confidence as 95%. Choose seasonality as 12 months. Add a trendline that best fits the data with the least error using the R2 method. [Total - 15 marks]