Test of Means Tool

The Test of Means tool performs a Welch's two sample t-test of the difference in mean values for a numeric response field between a control group and one or more treatment groups where group membership is indicated by a grouping field that can either be a character or integer field that indicates to which group each record belongs. The tests are carried out between the designated control (comparison) group and the other groups indicated in the group field.

This tool uses the R tool. Go to Options > Download Predictive Tools and sign in to the Alteryx Downloads and Licenses portal to install R and the packages used by the R Tool. See Download and Use Predictive Tools.

Connect an input

An Alteryx data streams with at least one numeric and at least one character or integer field.

Configure the tool

• Select the response field: A numeric field that will be used to calculate the group specific means for comparison.
• Select the field with the group identifier: A character or integer field that indicates the group to which each record belongs.
• The label for the control group (optional if there are only two groups): All tests are done with respect to one group (the comparison or control group). This option determines which group acts as the comparison (control) group. When there are only two groups, this distinction is not needed, so indicating the control group is optional.

View the output

Connect a Browse tool to each output anchor to view results.

• D anchor: The D output consists of a table that gives the two group labels for each test along with the test statistic, degrees of freedom, and p-value of the tests which can potentially be used in downstream processing.
• R anchor: The R output provides a set of report snippets of the test results.