Your data analysis solution

Dynamic histograms tutorial in Excel

2017-03-02

This tutorial will show you the two possible ways to create a dynamic histogram in Excel using the XLSTAT software.
To create a classical histogram with XLSTAT, you can find a tutorial here. Two cases will be presented.

Data to create a dynamic histogram

An Excel sheet with both the data and the results can be downloaded by clicking here.

Case 1

Setting up the dialog box to create a dynamic histogram (case 1)

In this case, we imagine we have used two techniques to make a measurement. The data have been recorded in two different columns, and the two samples are independent because measures were not taken simultaneously.

After opening XLSTAT, select the XLSTAT / Describing data / Histograms command, or click on the corresponding button of the Describing data toolbar (see below).

men histograms

Once you've clicked on the button, the dialog box appears. Select the data on the Excel sheet.

The Data are in the A and B columns.

Dialog box dynamic histogram 

In the Options tab we set the number of intervals for the histogram to 5. We want to compare the samples so we activate the “Compare the subsamples” option.

 Dialog box dynamic histogram options

As we think the data should follow a normal distribution, we choose to display a normal distribution curve fitted to the data.

 Dialog box dynamic histogram charts

The computations begin once you have clicked the OK button. The results will then be displayed.

Interpreting a dynamic histogram (case 1)

The first chart is a dynamic histogram. The list box at the top left of the chart allows you to choose which subsample is displayed in the front.

 dynamic histogram chart

 The second chart allows to see the two samples and the corresponding fitted normal distributions.

 dynamic histogram normal distribution chart

Case 2

Setting up the dialog box to create a dynamic histogram (case 2)

In this case, we imagine we have used a technique to make a measurement on a series of products. The measures have been recorded by two different operators (0 / 1). In an exploratory phase, we want to visually investigate whether they are different or not.

After opening XLSTAT, select the XLSTAT / Describing data / Histograms command, or click on the corresponding button of the Describing data toolbar (see below).

men histograms 

Once you've clicked on the button, the dialog box appears. Select the data on the Excel sheet.

The Data are in column A. The information telling which operator made the measurement is recorded in column C.

XLSTAT histogram dialog box general tab

In the Options tab we set the number of intervals for the histogram to 5. We want to compare the samples so we activate the “Compare the subsamples” option. We also activate the “Compare to the total sample option” to see the distribution of the data taken all together.

 Dialog box dynamic histogram case 2 options

As we think the data should follow a normal distribution, we choose to display a normal distribution curve fitted to the data.

Dialog box dynamic histogram case 2 charts 

The computations begin once you have clicked the OK button. The results will then be displayed.

Interpreting a dynamic histogram (case 2) 

The first chart is a dynamic histogram. The list box at the top left of the chart allows you to choose which subsample is displayed in the front. X1 corresponds to the merged data. In the image above, it is in the background, hidden by the two subsamples.

 dynamic histogram case 2 chart

The second chart allows to see the two sub-samples corresponding to each operator and the normal distribution fitted to the total sample (it would be displayed for each sub-sample if the Compare to the total option had not been activated).

dynamic histogram case 2 normal distribution chart

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283