How to Calculate the Cumulative Probability in Excel – 4 Steps

Introduction to the Cumulative Probability

The cumulative probability is the likelihood that the value of a random variable is within a specific range.

x is a random variable and m and n are the limits of a specific range.

The dataset showcases 60 samples and their weight in grams. Calculate the cumulative probability:

Step 1 – Sort Data in Ascending Order

• Select C8:C67.
• Go to the Data tab.
• Select smallest to largest.

• Excel will sort the dataset.

Step 2 – Calculate the Mean of the Dataset Using the AVERAGE Function

Use the AVERAGE function.

• Go to D4 and enter the following formula

• Press ENTER to see the output.

Step 3 – Measure the Standard Deviation

Use the STDEV.P function.

• Go to D5 and enter the following formula

• Press ENTER to see the output.

Read More: How to Calculate Probability of Exceedance in Excel

Step 4 – Using the NORM.DIST Function to Calculate the Cumulative Probability

Use the NORM.DIST function.

• Go to D8 and use the following formula

• Press ENTER to see the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

• To plot a chart of the cumulative distribution,  select C7:D67.
• Go to the Insert tab and choose Scatter.
• Select a type.

• A chart is displayed.

Things to Remember

• Use the absolute reference to lock cells.
• The STDEV.P function is for the population. The STDEV.S function is for the sample.

Download Practice Workbook

Download the workbook and practice.

<< Go Back to Excel Probability | Excel for Statistics | Learn Excel