This tutorial will help you set up and interpret a permutational Multivariate Analysis of Variance or adonis based on Distance Matrices in Excel using the XLSTAT-R engine in Excel.
What is adonis?Adonis is a technique used in ecology to explain communities with environmental variables. Its goal is similar to Multivariate Analysis of Variance (MANOVA).
The adonis function developed in XLSTAT-R calls the adonis function from the vegan package in R (Martin Henry H. Stevens and Jari Oksanen).
Data set for launching an adonis analysis in XLSTAT-RAn Excel sheet with both the data and the results can be downloaded by clicking on the button below:
Download the data
The data was extracted from Vegetation and Environment in Dutch Dune Meadows [Jongman, R.H.G, ter Braak, C.J.F & van Tongeren, O.F.R. (1987). Data Analysis in Community and Landscape Ecology. Pudoc, Wageningen]. The data is available in the vegan package in R.
The first 30 columns correspond to abundances of 30 plant species measured on 20 sites. Two environmental variables measured on the sites were also included:
- A1: Thickness of the A1 soil horizon
- Management: BF (Biological farming), HF (Hobby farming), NM (Nature Conservation Management), and SF (Standard Farming).
Setting up an adonis analysis in XLSTAT-ROpen XLSTAT-R / vegan / Permutational MANOVA using Distance Matrices(adonis)
In the general tab, select the plant community in the dependent variables field.
Select A1 in the Quantitative explanatory variables field and Management in the Qualitative explanatory variables field.
In the Options tab, activate the interactions, set permutations at 999 and select Marginal effects. Marginal effects are equivalent to the type III sum of squares table.
Click OK to launch computations.
A dialog box appears allowing you to select the terms you want to include in your model. Select all the terms and click OK.