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
