# Quantitative Methods

## Excel Tutorial Videos

For those who are not familiar with Excel, the first video of the Excel 2013 Statistical Analysis for Business & Economics Playlist at Excelsfun is very good. Start with Excel 2013 Statistical Analysis #00: Excel Workbooks For This Class (2:07 minutes). This short video gives an explanation of how to quickly navigate within the longish …

## 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 …

## 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 …

## Using Excel 2016’s Solver to Optimize Exponential Smoothing Forecasts

An easy way to minimize MAPE: [embedyt] http://www.youtube.com/watch?v=GGse591r4zo[/embedyt]

Scroll to Top