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

Download file from “Highline BI 348 Class” section: 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 lin