Build an Excel model to estimate travel duration based on a given probability.
- Theres a historic set for different cars and routes
- each route consist of 3 stages (e.g A to B 4 min, B to C 40 min and B to D 7 min)
- Duration = A to B + B to C + C to D (4+40+7)
- i want to calculate the mean, SD and number of trials.
- i want to enter a percentile and get the duration and the number of trials at that percentile
- i want to enter max number of trials instead of a percentile to get the duration ( just the opposite of the previous point)