Use Excel to Calculate MAD, MSE, RMSE & MAPE

To optimize your forecast, whether moving average, exponential smoothing or other form, you need to calculate and evaluate MAD, MSE, RMSE, and MAPE. With Excel 2016, this is easy to do. [embedyt] http://www.youtube.com/watch?v=H_N5_vxs8Tg[/embedyt] Open the Excel...

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...