Creating a Histogram with Excel

In this video, we'll demonstrate how to create a histogram with the help of a simple user interface of the newly released version 1.58 (BAJA) of NumXL.

Welcome to the NumXL tutorial. In this video, we'll demonstrate how to create a histogram with the help of a simple user interface available starting in version 1.58 BAJA.

DESC STAT = Descriptive Statistics

Note that Table otput range is set to the selected empty cell in your worksheet.

Using the Bins. No Rules or algorithm, you can determine the proper number of Bins for your data. Note that as we change the rule, the No of bins is recalculated.

 

Have more questions? Submit a request

0 Comments