a. Compute the MAD of forecast errors. (Round your answers to 2 declmal places.) Week MAD 1 2 3 4 7 8

The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: F Year 4 Disk Drives 142 164 196 204 216 B a) Using simple linear regression, the forecast for the number of disk drives to be made next year-isk drives (round your response to one decimal place)

Pls solve this question correctly instantly in 5 min i will give u 3 like for sure

(4) Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 15(000). (Round your intermediate forecast values and final answer to 2 decimal places.) Forecast thousands (5) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.) Yt thousands

Calculate MSE for the 4 periods for which the actual and forecasted number of customers given in the table below: Forecasted Actual Number Period Number of Error of Customers Customers 1 1,975 2,000 2 2,050 2,025 3 1,925 1,975 4 2,075 2,025 390.63 37.5 6,250 True1,562.5

please answer in excel    Jean’s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that she can schedule the personnel. The manager uses α = 0.3 for exponential smoothing, and the forecast for the first week was 24 calls. The manager also uses 3 weekly moving averages technique. a) Using 3 period moving averages, forecast the number of calls for week 7. b) Using exponential smoothing, forecast the number of calls for week 7. c) Compare these two forecasting techniques using Mean Squared Errors (MSE) measure. Which one is better?

8.  Calculate​ (a) MAD and​ (b) MSE for the following forecast versus actual sales​ figures:                                                                     Forecast 100 110 120 130 Actual 95 108 123 130 Part 2 ​a) MAD= __________ ​(round your response to one decimal​ place).

Week 1 2 4 Forecast Method 1 0.90 1.05 0.97 1.22 Actual Demand 0.72 1.05 1.00 0.97 Week 1 2 3 4 Forecast Method 2 0.82 1.19 0.90 1.17 Actual Demand 0.72 1.05 1.00 0.97 0 The MAD for Method 1 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 1 = thousand gallons (round your response to three decimal places). The MAD for Method 2 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 2 = thousand gallons (round your response to three decimal places).

Show your solution. Please write down your answer. No excel please. Thank you.

Assume today's date is 12/31/2023. Actual sales and forecast for 2023 are given below. Actual Forecast 2023 72.4 66.9 59.5 61.2 260 2023 69 67 Q3 61 Q4 59 Total 256 Obtain the MAD Q1 Q2 7.2 1.8 -1