Monte Carlo Analysis for Traffic Crash Reconstruction with Microsoft Excel

Approved for 16 ACTAR CEUs

TWO-DAY CLASS (Live)

Class Description

This two-day class will instruct students how to program Monte Carlo Analyses with Microsoft Excel. No experience with Excel is required. The instructors will teach the required Excel skills contemporaneously with the Monte Carlo skills. Periods of instruction, in which students follow along with the instructors, will be followed by class projects, in which students will learn by doing their own Monte Carlo analyses (MCA). Class projects will include EDR analysis.

Course Topics

• Mathematics needed for MCA
  • Normal and uniform distributions
  • How to select the correct distribution for your analysis
  • Mean, median and standard deviation
  • Percentiles
  • The Empirical Rule
• Basic MCA using Excel's built-in random number generator and histogram tool
• Sources for quantifying the uncertainty in crash reconstruction measurements and assumptions
• Advanced MCA
  • Programming your own random numbers
  • Filtering inputs and results to eliminate impossible results
  • Creating your own histograms and cumulative probability charts
  • How to handle results that are not normally distributed
• How to write a report that includes an MCA
• Projects include various EDR analyses and time-distance

Prerequisite

All students must have successfully completed a course in Traffic Crash Reconstruction, or have an engineering degree with at least 1 year of crash reconstruction experience.

Computer & Software Requirements

All students must have a laptop computer running the Office 365 Excel version with Excel installed on the laptop. The online Excel version does not have all the tools needed for this course. Earlier versions of Excel cannot be supported by the instructors. A 30-day trial version of Office 365 is available for FREE on Microsoft’s website (https://www.microsoft.com/en-us/microsoft-365/try).

Download course flyer here

Cancelation Policy: You may cancel your registration outside of 30 days of the first day of class for a 100% refund. Between 30 days and 8 days of the first day of class, a 25% administrative fee will be charged. No refunds within 8 days of the first day of class. Any student who cancels within 8 days of the first day of class may, at the discretion of Rich Consulting LLC, apply the forfeited tuition toward a future Rich Consulting class.

Tuition will be refunded 100% for classes canceled at any time before the first day of class due to Covid-19 or other government-imposed restrictions. If a class is canceled after the first day of class, the refund will be prorated. Rich Consulting will not be responsible for students' non-refundable travel reservations that are canceled due to Covid-19 or other government-imposed restrictions. 

Scheduled Classes:
    
Ipswich, MA: May 14 and 15, 2025. Hosted by the Ipswich Police Department at the Ipswich Town Hall, 25 Green Street, Ipswich, MA  01938. Tuition is $599 before April 1, 2025 and $699 after April 1, 2025.

      

       
 

Contact us about hosting your own Monte Carlo class and receiving free tuition!