Back to Browse

Monte Carlo Forecasting Using Excel

4.1K views
Oct 24, 2024
36:35

In this video, I walk you through a Monte Carlo simulation using real grocery sales data from the US. You'll learn how to deseasonalize and detrend a dataset, extract the random components, and build a Monte Carlo simulation model in Excel to forecast potential outcomes. This step-by-step tutorial is perfect for anyone looking to apply simulation techniques to real-world data, using Excel as an analytics tool. The link for the Excel file: https://tinyurl.com/montecarloforecasting

Download

1 formats

Video Formats

360pmp474.2 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Monte Carlo Forecasting Using Excel | NatokHD