Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm
Learn how to build a Monte Carlo Simulation for Marketing Analysis with a Binomial Variable.
1) (00:12) Intro to problem
2) (02:12) Create Randomize Formula for Binomial Variable. Use BINOM.INV and RAND functions.
3) (03:53) Build Profit formula for Marketing Plan.
4) (04:33) Create Simulation using the Data Table Feature and an Empty Cell in the Column Input.
5) (06:09) Perform Analysis: including the AGGREGATE function and FREQUENCY Array Function.
6) (10:25) Change Static Variables in Simulation Model and Whole Model updates!!!
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.