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:

Using GROUPBY(#input!Experiment) and

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