Creating dynamic histograms with XLSTAT

Goal of this tutorial

This tutorial will show you the two possible ways to create a dynamic histogram with XLSTAT. 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 D.

 Dialog box dynamic histogram case 2

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

Click here for other tutorials.

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414