# Syntax of ANOVAF(), ANOVAP() and TTEST()

π£
edited May 6

These functions are supported in the Fx Tile in Magic.

Does anyone have some syntax examples ? The function requires an aggregation context suggesting a group by action

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.

• Portland, Oregon π₯·

Not sure if you have already seen this here: https://domohelp.domo.com/hc/en-us/articles/360044289573-Supported-Functions-in-the-New-Magic-ETL

Function Name

Description

Example

ANOVAF

Returns the F-value of a one-way Analysis of Variance of the samples. At least two samples must be provided, and each sample must have at least two non-null values. Note that a one-way ANOVA on two samples is equivalent to the Student's t-test (see the TTEST function).

ANOVAF(sample1,sample2[,sample3[,...,sampleN]])

ANOVAP

Returns the p-value of a one-way Analysis of Variance of the samples. At least two samples must be provided, and each sample must have at least two non-null values. Note that a one-way ANOVA on two samples is equivalent to the Student's t-test (see the TTEST function).

ANOVAP(sample1,sample2[,sample3[,...,sampleN]])

TTEST

Returns the p-value result of a Student's t-test. Arguments sample1 and sample2 are two numeric columns with at least 2 non-null values each. The tails argument is either 1 or 2, indicating a one- or two-tailed test. The type argument is a number 1 through 3. Type 1 is a paired sample test; for this type of test, values in both sample1 and sample2 must be non-null or be ignored. Type 2 is for two samples with the assumption of equal variance. Type 3 is for two samples without the assumption of equal variance.

TTEST(sample1,sample2,tails,type)

These were under Statistical Functions

**Make sure to any users posts that helped you.
• π£

Thanks Mark, I saw the article but I am looking more for an example

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
• π£

Have you ever used any of these functions in Magic ?

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.