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 Bin range in ascending order.
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