Syntax of ANOVAF(), ANOVAP() and TTEST()
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
**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

Not sure if you have already seen this here: https://domohelp.domo.com/hc/enus/articles/360044289573SupportedFunctionsintheNewMagicETL
Function Name
Description
Example
ANOVAF
Returns the Fvalue of a oneway Analysis of Variance of the samples. At least two samples must be provided, and each sample must have at least two nonnull values. Note that a oneway ANOVA on two samples is equivalent to the Student's ttest (see the TTEST function).
See also: ANOVAP()
ANOVAF(sample1,sample2[,sample3[,...,sampleN]])
ANOVAP
Returns the pvalue of a oneway Analysis of Variance of the samples. At least two samples must be provided, and each sample must have at least two nonnull values. Note that a oneway ANOVA on two samples is equivalent to the Student's ttest (see the TTEST function).
See also: ANOVAF()
ANOVAP(sample1,sample2[,sample3[,...,sampleN]])
TTEST
Returns the pvalue result of a Student's ttest. Arguments sample1 and sample2 are two numeric columns with at least 2 nonnull values each. The tails argument is either 1 or 2, indicating a one or twotailed 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 nonnull 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
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 
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'0 
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'0 
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'2 
Hi @Godiepi, could you provide a small example on how to specify the samples inside the group by formula? Say I Group By
group
and have the variableturnover
that specifies the samples forgroup=1
andgroup=2
. Then I takeTTEST( x, y, 1, 2)
 how do I chose x and y?0
Categories
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 283 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 565 Datasets
 2K Magic ETL
 3.4K Visualize
 2.3K Charting
 593 Beast Mode
 13 App Studio
 28 Variables
 588 Automate
 143 Apps
 417 APIs & Domo Developer
 27 Workflows
 1 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 361 Distribute
 99 Domo Everywhere
 260 Scheduled Reports
 2 Software Integrations
 96 Manage
 93 Governance & Security
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive