**Excel - Create a Frequency distribution graph in Excel**

A frequency distribution is often used in market surveys. Perhaps you conducted a survey in which you asked the recipients to rate a service on a scale from 1 to 4. It would be useful to count how many ones, twos, threes or fours were selected by the target market. You can do so with a frequency distribution graph.

In the example below from a list of data from nine people, one person selected one, two people selected two and three, and four people selected four. One can quickly analyse the data. This Excel feature is very useful if you have a very long list to analyse.

To create a frequency distribution graph you need to activate the **Data Analysis**
software.

To activate the **Data Analysis** software, on the menu bar select the **Tools**
pull-down menu, click on **Add-Ins.**

Select **Analysis Toolpak. **Click** OK.**

When you want to create a frequency distribution graph make sure you have the ** Input
range**, the numerical data, already typed in, and the

When you are ready to do a frequency distribution graph, on the **Tools**
pull-down menu click on **Data Analysis**.

Select **Histogram**. Click **OK**. You are ready to do
the frequency distribution graph.

Get going. Let's get going. Click let's get going. Then look at an example of Making a Frequency distribution graph of costs of web software.

*This work may be freely copied for non-commercial use only. Copyright © Pam Miller*