Instructions for drawing probability distribution charts in Excel

The following article details how to use Histogram to plot probability distribution charts in Excel.

In order to use the Histogram Office, the Analysis Toolpak must be installed.

1. Install Analysis Toolpak

Step 1: Click on File -> Option -> Dialog appears -> at Add-Ins tab -> select Analysis Toolpak -> Go .

Instructions for drawing probability distribution charts in Excel Picture 1

Step 2: The Add-Ins dialog box appears -> select the Analysis Toolpak -> OK .

Instructions for drawing probability distribution charts in Excel Picture 2

So you have installed Analysis Toolpak for Excel.

2. Draw a histogram of probability distribution using Histogram

Example: For a data table, draw a histogram of probability distribution using Histogram.

Instructions for drawing probability distribution charts in Excel Picture 3

Step 1: Select Data -> Data Analysis -> The Data Analysis dialog box appears -> Histogram -> OK .

Instructions for drawing probability distribution charts in Excel Picture 4

Step 2: Histogram dialog appears -> Select the data you want to draw in Input Range -> Select the data area containing the value of the layers in Bin Range -> Select the position of the chart in Output Range -> Check all 3 items: Pareto , Cumulative , Chart Output -> OK .

Instructions for drawing probability distribution charts in Excel Picture 5

Results have drawn the chart:

Instructions for drawing probability distribution charts in Excel Picture 6

Working on the chart

1. Change the Style and Color for the chart

Click the icon Instructions for drawing probability distribution charts in Excel Picture 7

Instructions for drawing probability distribution charts in Excel Picture 8

2. Add the elements of the chart

For example: Add GridLines -> click the icon Instructions for drawing probability distribution charts in Excel Picture 9

Instructions for drawing probability distribution charts in Excel Picture 10

3. Select the values ​​of the chart

Click the icon Instructions for drawing probability distribution charts in Excel Picture 11

Instructions for drawing probability distribution charts in Excel Picture 12

Good luck!