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

Godiepi

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

MarkSnodgrass

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).

See also: ANOVAP()

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).

See also: ANOVAF()

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

Godiepi

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

Godiepi

@GrantSmith / @jaeW_at_Onyx

Have you ever used any of these functions in Magic ?

Godiepi

Update: I figured it out.. looks like in magic , the function needs to be added within the Group by tile add formula providing at least 2 fields containing the samples to analyze

maxm

Hi @Godiepi, could you provide a small example on how to specify the samples inside the group by formula? Say I Group By groupand have the variable turnoverthat specifies the samples for group=1 and group=2. Then I take TTEST( x, y, 1, 2)- how do I chose x and y?