The X / Explanatory variables field should contain the explanatory variables – the Species column in our case.Īs we selected the column title for the variables, we left the option Variables labels activated. The Y / dependant variables table field should contain the Dependent variables (or variables to model), which are the four morphological variables in our situation. Select the data on the Excel sheet in the General tab. Once you have clicked on the button, the MANOVA dialog box appears. Setting up a one-way MANOVA in XLSTATĪfter opening XLSTAT, select the XLSTAT / Modeling data / MANOVA function. The goal of this MANOVA is to see if three iris species differ with respect to their flower morphology represented by a combination of 4 dependent variables (sepal length, sepal width, petal length, petal width). Three different species have been included in this study: setosa, versicolor and virginica. The data are from and correspond to 150 Iris flowers, described by four variables (sepal length, sepal width, petal length, petal width) and their species. Dataset for running a one-way MANOVA in XLSTAT
It is not uncommon to see multidimensional data tables with over 20 scenarios and 100 sensitized items.This tutorial shows how to set up and interpret a Multivariate Analysis of Variance (MANOVA) in Excel using the XLSTAT software.Ī MANOVA is a method to determine the significant effects of qualitative variables considered in interaction or not on a set of dependent quantitative variables. Given the “wall of numbers” quality of these tables, particularly as they grow in size, it is important to use formatting to make it easier to understand. In order to complete the analysis, you must press F9 to recalculate. However, you may notice that the values are consistent across each column. The previously blank table will now be populated with values. In the resulting dialog box, select the Scenario Switch as the “Row input cell” and leave the “Column input cell” field blank. Preferably, you would use the shortcut Alt + A + W + T or Alt + D + T in Excel 2003.
Then, in the ribbon, select Data Table (this can be accessed via Data -> Data Tools -> What-If Analysis -> Data Table). We do this by linking back to the original analysis.Īfter establishing the structure of the data table, it can be activated.įirst, select the table – the top row must be the scenario numbers and the left-most column must be the links to the analysis. We need to provide the data table with items to sensitize.
The data table should be structured with the items to be sensitized in rows and the scenario numbers as column headings. We can then use a data table to sensitize the analysis. This is done by linking each row in the “Live” column to its corresponding input in the analysis.ĭoing this will allow the scenario changes to roll through the rest of the analysis. Once the data input section has been built, it must be integrated into the analysis.
Under the Live scenario number, enter “2” (or your preferred scenario number).This space will house the “Live” scenario.
Be sure to leave an empty column between your key driver labels and the first scenario. Populate the scenario numbers across the top of the table.Each driver will be one row in the table.