Quantitative Methods

Charts with Excel

Creating Line Charts in Excel This 12=-minute video shows how to use Excel to create a line chart of five data sets including how to change the axis parameters, set line style and colors. https://www.youtube.com/watch?v=mTnsxNfTFKo&index=23&list=PLdlFfrVsmlvAz0kKV3EdHJtPdg8PqQYwU Creating Column Charts in Excel This 13-minute video shows how to make a clustered column chart. He uses the 3D …

Charts with Excel Read More »

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 …

Use Excel to Calculate MAD, MSE, RMSE & MAPE Read More »

Scroll to Top