GROUPANOVA

Syntax

GROUPANOVA(<string|integer>, <integer|float > ;<float>)

Description

This function is for comparing the means of three or more samples to see if they are significantly different at a certain significance level (usually alpha=0.05).

A JSON object is returned with the calculated F-statistic, the degrees of freedom between the groups, the degrees of freedom with in the groups, the P-value, and a statement if the difference is significant or not.

This is an aggregate function

The function arguments are:

  • Sample ID column
  • Value column
  • Significance level constant (optional)

Example

Example input sheet:

ExperimentSample_IDValue
Ax12
Ax15
Ax9
Ay20
Ay19
Ay23
Az40
Az35
Az42

Using GROUPBY(#input!Experiment) and

GROUPANOVA(#input!Sample_ID;#input!value;0.05)

ExperimentGROUPANOVA returns
A{"f-statistic":64.95,"dfbg":2,"dfwg":6,"isSignificant":true}