How do I run a Discriminant analysis with XLSTAT?
An Excel sheet containing both the data and the results for use in this tutorial can be downloaded by clicking here. The data are from [Fisher M. (1936). The Use of Multiple Measurements in Taxonomic Problems. Annals of Eugenics, 7, pp 179 -188] and correspond to 150 Iris flower, described by four variables (sepal length, sepal width, petal length, petal width) and their specie. Three difference species have been included in this study: setosa, versicolor and virginica. Our goal is to test if the four variables allow to discriminate the species, and to visualize the observations on a 2-dimensional map which shows as well as possible how separated the groups are. Iris setosa, versicolor and virginica. After opening XLSTAT, select the XLSTAT/Analyzing data/Discriminant analysis command, or click on the corresponding button of the “Analyzing data” toolbar (see below). Once you’ve clicked on the button, the Discriminant analysis dialog box appears. The qualitative dependent variable corres