The bakery we have been considering in class has an additional product, Danish buns. The product has only been available for the last seven days, and daily sales each day , have been, , respectively, 7, 9, 8, 10, 14, 13, 16. The bakery would like you to a) determine the best forecast for the next day using the most nave and textbook nave forecasting methods and b) identify which method is more accurate, in terms of a the lower MAD.

In excel