XLSTAT: Back-to-Back Histogram in Excel

 

Dataset For Example

The (attached) data comes from the Howell1 dataset, it is demographic data of the people of the Kalahari !Kung San collected by Nancy Howell. In this dataset, we have the weight and height measurements, age and sex of 544 people living in the Kalahari. 
Using this example, we are going to focus on the age of the people interviewed by creating a population pyramid which will make it very easy to represent the distribution by age and sex of this population and thus have clues on the birth rate and mortality of this population.

 

Setting Up

• Open XLSTAT.

• Click on the Visualizing data menu and select the Back to Back Histograms feature:

In the General tab:

• Select Histograms in the Format field.

• Select the  Age column in the Data field.

• Select the Sex column in the Groups field.

• Click on the OK button to launch the computations.

• The results are displayed on a new Excel sheet.

 

Interpreting the Results

First, descriptive statistics on the entered variables are displayed.
Next, the back-to-back histogram is displayed.

 

The graph is symmetrical, indicating a balanced gender distribution. It has a pyramidal shape with many people under 20, decreasing with age, suggesting high birth rates and mortality.

The dataset also includes height and weight for further analysis.