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

Godiepi
Godiepi 🟣
edited May 6 in Dataflows

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.
**Please mark the post that solves your problem as 'Accepted Solution'

Answers

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

    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

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Godiepi
    Godiepi 🟣

    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.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • Godiepi
    Godiepi 🟣

    @GrantSmith / @jaeW_at_Onyx

    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.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • Godiepi
    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

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'