Need it done in exel
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.) |
| t | Units Sold |
| 11 | 144 |
| 12 | 146 |
| 13 | 152 |
| 14 | 142 |
| 15 | 152 |
| 16 | 149 |
| 17 | 152 |
| 18 | 154 |
| 19 | 157 |
| 20 | 164 |
| MAD (Naive) | provides forecasts with less average error and less average squared error. |
12 years ago
3
Answer(1)![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- asma.xlsx
Bids(0)
other Questions(10)
- Look at the Friar in the prologue and his tale and contrast him with the Pardoner.
- strategic predispositions/International management
- Jerry Englebrecht has operated a successful dog grooming service for ten years. Each year his number of customers has grown....
- Stat 1 Assignement
- Help with Math Homework
- do i use ser/estar for this:1.Elena y yo / preocupado
- How do i write a song analysis in the song one love by Bob Marley with the main idea, figurative...
- serfsef
- Club IT Paper
- solve for the variable indicated: 1/5xy-10y=5 for y