Use all of the data, weeks 1 - 24, to calculate the regression equation for this data. Use the weeks (1-24) as the independent variable (x) and number of calls as the dependent variable (y). Once you have the equation, forecast weeks 4 through 24 (enter 4, 5, 6, etc. as the x value in the equation). Calculate the MAD for this forecasting model. Comment on the goodness of fit (R2) and significance of the model (F significance) to determine if this forecast model should be included in the consideration of the different approaches. (If the model is not significant, it cannot be considered, however, you must still make the forecasts and calculate the MAD).In excel please. Week | # of Calls15035325440456357208.3035102011151240135514351525165517551840193520602175225023402465

Given information:- Week Number of calls 1 50 2 35 3 25 4 40 5 45 6 35 7 20 8 30…

Answered: Use all of the data, weeks 1 - 24, to…

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

Related questions

Question

Use all of the data, weeks 1 - 24, to calculate the regression equation for this data. Use the weeks (1-24) as the independent variable (x) and number of calls as the dependent variable (y). Once you have the equation, forecast weeks 4 through 24 (enter 4, 5, 6, etc. as the x value in the equation). Calculate the MAD for this forecasting model. Comment on the goodness of fit (R²) and significance of the model (F significance) to determine if this forecast model should be included in the consideration of the different approaches. (If the model is not significant, it cannot be considered, however, you must still make the forecasts and calculate the MAD).

In excel please.