Histogram Rendering with SigmaXL

What is Histogram Rendering with SigmaXL?

Histogram rendering with SigmXL provides a graphical tool to present the distribution of the data. These plots are used to better understand how values occur in a given set of data. The X axis represents the possible values of the variable and the Y axis represents the frequency of the value occurring. This graphical tool consists of adjacent rectangles erected over intervals with heights equal to the frequency density of the interval. The total area of all the rectangles in a histogram is the number of data values.

A histogram can also be normalized. In the case of normalization, the X axis still represents the possible values of the variable, but the Y axis represents the percentage of observations that fall into each interval on the X axis. The total area of all the rectangles in a normalized histogram is 1. When using this type of graph, we have a better understanding of the shape, location, and spread of the data.

Your Guide to Histogram Rendering with SigmaXL

Data File: “Histogram” tab in “Sample Data.xlsx”

Steps to render a histogram in SigmaXL:

1. Select the entire range of data
2. Click SigmaXL -> Graphical Tools -> Histograms & Descriptive Statistics
3. A new window named “Histograms & Descriptive” pops up with the selected range appearing in the box under “Please select your data”
   
4. Click “Next>>”
5. A new window named “Histograms & Descriptive Statistics” appears
6. Select “HtBk” as the “Numeric Data Variables (Y)”
   
7. Click “OK”
8. The normality test results appear in the newly generated tab “Hist Descript (1)”
   

Model summary: The output from the previous steps has generated a graphical summary report of the data set HtBk. Among the information provided is a histogram. The image shows the frequency of the data for the numerical categories ranging from 5.7 to 7. You can see the shape of the data roughly follows the bell curve.