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…

13th Edition

ISBN:9781133382119

Author:Swokowski

Publisher:Swokowski

Chapter1: Fundamental Concepts Of Algebra

Section1.4: Fractional Expressions

Problem 66E

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.