Need it done in exel

profileAsma

  

 Problem 3-20

An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is Ft = 124 + 2.1t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your answers to 2 decimal places.)

      
tUnits Sold
11144
12146
13152
14142
15152
16149
17152
18154
19157
20164

       
   
  MAD (Naive) provides forecasts with less average error and less average squared error.

 

 

    • 12 years ago
    • 3
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      asma.xlsx
    Bids(0)