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:

Experiment	Sample_ID	Value
A	x	12
A	x	15
A	x	9
A	y	20
A	y	19
A	y	23
A	z	40
A	z	35
A	z	42

Using GROUPBY(#input!Experiment) and

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

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

Browser not supported