How to generate box plots with XLSTAT?

An Excel sheet with both the data and the results can be downloaded by clicking here. The data correspond to a sample of 150 irises for which 4 variables were measured. The flowers belong to 3 different species. Fisher used this dataset, now famous, when he developed his discriminant analysis theory. In this particular example, we decided to analyze the variable Sepal length of the flowers and check if there are "visually" significant differences between the three species.

Once XLSTAT is open, select the XLSTAT/Describing data/Descriptive Statistics command, or click on the corresponding button of the "Describing data" toolbar (see below).

Once you have clicked on the button, the Descriptive Statistics dialog box appears. The data corresponding to the variable "Sepal length" were selected on the Excel sheet. Note that for a box plot, the data must be numerical data. As the name of the variable was included in the selection, the Labels included option was also selected. The Species data were selected as sub-sample descriptor to enable the comparison between the species. The Sheet option was selected because we wanted the results displayed on a new sheet of the workbook.

In the "Options" tab, the following options have been activated.

The "Normalize" or "Rescale" options can be used when you want to compare several variables spread over different scales - there is no need to use these in this case as we are dealing with only one variable.

In the "Charts" tab the box plots option is checked. The "Group plots" option has been chosen so that the box plots are displayed on the same chart, and not separately. The Minimum/Maximum and Outliers option has been checked so that the corresponding values are displayed on the box plots.

Screen Shot

Interpreting a box plot

The results are displayed on the new sheet named "Desc". They include a full set of descriptive statistics.

Output

Then, the box plots are displayed.

Output

It appears clearly that the Sepal length variable is different from for the three species. The blue rhombuses correspond to the minimum and maximum values.

Watch this video to see how to generate this boxplot.

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