Results

After a simulation run completes, the results panel appears below the spreadsheet. This page explains how to interpret the distribution charts, summary statistics, and percentile tables for each output cell.

Core concepts

In a Monte Carlo simulation, each output cell produces many sampled values — one per replication. The histogram displays the frequency distribution of these values, showing which outcomes are more or less likely.

• Histogram shape: A narrow, tall peak means low uncertainty (most iterations produced similar values). A wide, flat shape means high uncertainty (values varied widely).
• Distribution center: The median (P50) and mean tell you the central tendency of the output. If they differ significantly, the distribution is skewed.
• Spread: Standard deviation and the range between P5 and P95 quantify how much the output can vary.
• Pr(x < X): The probability that the output falls below a threshold you define — useful for answering questions like "What is the chance we lose money?"

Per-output results

For each output, you see:

• Histogram — distribution of sampled values across all iterations
• Summary statistics — mean, median, standard deviation, min, max, and selected percentiles (P5, P25, P75, P95)
• Pr(x < X) line — a draggable vertical line on the histogram showing the probability that the output is less than a given value

Reading the Pr(x < X) line

1. Locate the histogram for the output you want to analyze.
2. Drag the vertical line left or right to your threshold value. As you drag, the label updates in real time.
3. Read the probability from the label: Pr(output < X) = Y%. For example, "there is a 30% chance profit is below $0."
4. Adjust the threshold by dragging further until the probability matches your risk tolerance or decision criterion.

tip

The Pr(x < X) line is fully interactive — you can drag it continuously to explore any threshold. Use it to answer "what-if" questions like "What is the chance revenue stays above $1M?"

Output types

Output type	Result display
Single cell	Histogram of scalar values across all reps
Cell range	One histogram per cell in the range

Percentile table

Below the histogram, a table shows key percentiles:

Percentile	Meaning
P5	5% of iterations produced a value below this
P25	Lower quartile
P50	Median
P75	Upper quartile
P95	95% of iterations produced a value below this

Saving results

warning

Results are not automatically saved between sessions. To preserve them, note the key statistics or take a screenshot before closing the tab.