Basic Excel Business Analytics #68: Monte Carlo Simulation Histogram for Construction Project Length

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn how to create 4 Random Variables for a Simulation based on 4 relative Frequency Distributions in order to determine the average time to complete a sequential project. Learn how to use LOOKUP and RAND function to create simulation formula and the Data Table feature to run a simulation. Also see how to create a Histogram based on 10,000 simulated values. 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.