Create an Excel frequency distribution table in seconds with the 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 the more expensive products? We can draw useful conclusions from the results of several thousand products. It does not seem like an easy task. Fortunately, the Data Explorer add-in is at our disposal. The whole procedure will only take a few seconds. In the picture, we can see the modified graphical user interface (GUI).
How to create an 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!
A user form or dialogue box will appear with the most important information by clicking on the Histogram icon. The settings on the next picture are as follows. In the data range field, we highlight those ranges we will rank in 10 categories. In the next field, we set the number of classes into which we rank the values. There’s nothing left to do than to name the chart.
After pressing the “OK” the 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 tasks means!
It seems that we have done the given task in a much shorter time than by using the traditional method.
In the picture below, a frequency distribution table can be seen.
Let’s analyze the results! We have divided the values into 10 categories according to the previous settings. We can see in seconds that most numbers have fallen into the interval between 20 and 30.
Following the same logic, we can see that the lowest numbers have fallen into the interval between 60 and 70.
Additional resources: