Frequency Distribution Table
Create excel frequency distribution table in seconds with help of our free DataXL automation add-in! It is not a new thing that we want to give you better and smarter tools day by day. This is why we have created the website.
The free Data Explorer add-in has again expanded with a great function!
How can we make statistical analysis even simpler?
Read on, we are offering a very interesting Excel tutorial now!
What is the Excel frequency distribution table?
And how does it work? It’s not our goal to make things too complicated. Imagine a set of numbers that contains values between 0 and 100. The number of elements in the set can be arbitrary.
The point of the procedure is that we divide the elements of the set into equal sections (for example 0-10, 11-20 …). In this example we have chosen the interval to be 10. Of course we can set this according to the task.
After this we see how often the values fall into each interval. Statistics call this frequency distribution.
Why is it worth to make an Excel histogram?
Here are some examples from the weekdays. One of them is frequent questions that we can’t always answer immediately.
Have we sold more of the cheaper or from the more expensive product?
We can draw useful conclusions from the results of several thousand products.
Is does not seem as an easy task.
Fortunately the Data Explorer add-in is at our disposal. The whole procedure will only take a few seconds.
On the picture we can see the modified graphical user interface (GUI).
How to create excel frequency distribution table?
We have complemented the add-in with a frequency distribution table function. On the ribbon the Histogram icon appeared, we have marked this on the picture.
To “generate” the numbers use the RANDBETWEEN () formula. The RANDBETWEEN () (0,100) will generate random numbers between 0 and 100, as many as you like!
By clicking on the Histogram icon a user form or dialogue box will appear with the most important information.
The settings on the next picture are as follows.
In the data range field we highlight those ranges that we will rank in 10 categories.
In the next field we set the number of classes that we rank the values into. There’s nothing left to do than to name the chart.
After pressing the “OK” the end result will appear immediately. And among many other things, this is why we love the Excel add-in solutions!
The only thing we have to do is to follow the instructions on the screen. The Excel add-in and the VBA program will do the “dirty work” for us.
This is what the automatization of Excel task means!
It seems that we have done the given task in a much shorter time than with using the traditional method.
On the picture below a frequency distribution table can be seen.
Let’s analyze the results! According to the previous settings we have divided the values into 10 categories. We can see it in seconds that the most numbers have fallen into the interval between 20 and 30.
Following the same logic we can see that the least numbers have fallen into the interval between 60 and 70.
The histogram or by other name the frequency distribution table is a great tool to display data. On the internet there are many articles about this subject, usually they are long and less understandable.
Of course this was a very subjective opinion.
Our version is far the most simple and on top of this: it’s free! The visual basic program that provides all of this for you is just the icing on the cake. The development of Data Explorer add-in will not stop in the next months. Follow our website, it is rewarding! You can see it for yourselves! Download and install our newest development add-in.