The second way to select the data is in tabular form, with each column representing a modality of the explanatory variable. The first is in the form of columns, one column for the dependent variable, another for the explanatory variable. In XLSTAT, it is possible to select the data in two different ways for the ANOVA. In this example we want to display the results on the same sheet where the data are stored, so we chose the Range option and selected the cell that corresponds to the top left corner of the results report to be displayed. Make sure to check the option Variable labels. To the Dependent variable corresponds here "Whiteness" which variability we want to explain by the effect of the "Toothpaste" formula, the latter being the Qualitative explanatory variable.
Once you have clicked on the button, the ANOVA dialog box appears. Select the XLSTAT / Modeling data / ANOVA command. The case is a one-way balanced ANOVA because there is only one factor - the formula - and the number of repetitions is the same for each formula. Using the ANOVA function of XLSTAT we want to find out if the results differ according to the formula used and, if so, which formula is the most effective. All patients had previously used the same toothpaste. The data correspond to an experiment where 4 new toothpaste formulas were each tested on 6 different patients in order to measure their effect on the whiteness of teeth.
#RUNNING ANOVA XLSTAT HOW TO#
This tutorial shows how to set up and interpret a one-way Analysis of Variance (ANOVA) followed by Tukey & Dunnett multiple comparisons in Excel using the XLSTAT software.
0 kommentar(er)
