This posting presents how to do forecasting with moving average method using excel modeling with criterion of Mean Square error and varying smoothing constant.
Data covering the most recent 30 days are given in the following table for the price per gallon of regular gasoline at a local station. __________________________________________ Day Price Day Price 1 2.53 16 2.46 2 2.35 17 2.60 3 1.91 18
