#RUNNING ANOVA XLSTAT HOW TO#

But I don't have any statistics or mathematics background and when I try to do it in excel, I'm confused about which are the right columns and lines to be specified to carry out the ANOVA or student test properly. The aim is see if there is a significant difference in gene expression between mutant and double mutant compared with the control.įor this purpose, I should to do some statistics tests and look at the p-value. It contains values of genes expression in 3 conditions (control, mutant and double mutant mices) and each condition is repeated 5 times (5 arrays). XLSTATs features include data visualization, statistical modeling (regression, ANOVA, mixed models, PLS.), data mining (PCA, MCA, DA.), stat tests. In addition to that, Ive enjoyed using modeling methods (ANOVA. I have a data set which looks like the attached file below. That it is an add-on for Microsoft Excel - helps its users to have everything under one page.

I'm confusing which columns and/or lines to be chosen to make the ANOVA analysis.

#RUNNING ANOVA XLSTAT HOW TO#

I don't know how to do an ANOVA test using excel 2007. 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. I'm new in this forum and in statistics analysis too, hoping that somebody could help me and I'll really be grateful. Select the XLSTAT / Modeling data / ANOVA command.

Running anova xlstat