Use Excel to Calculate MAD, MSE, RMSE & MAPE

To optimize your forecast, whether moving average, exponential smoothing or another form of a forecast, you need to calculate and evaluate MAD, MSE, RMSE, and MAPE. With Excel 2016 or later, this is easy to do. The Mean Absolute Deviation (MAD) is the sum of absolute differences between the actual value and the forecast divided […]

What’s so difficult about confidence intervals

  Interpretation of Confidence Interval I admit that it is almost common usage to say that a parameter of interest lies in the confidence interval we construct around a sample statistic, so I won’t count off for that answer. But the most accurate meaning of the confidence interval is that