Hi,
I am trying to test the difference in means for several experiments in the same Alteryx flow. Each experiment has a test and control group indicated by a dummy variable. If Population and Value are summed to the experiment and testing group level, the data look something like:
| Experiment | Group | Population | Mean_Value |
| 1 | Test | 15 | 100 |
| 1 | Control | 17 | 199 |
| 2 | Test | 75 | 164 |
| 2 | Control | 36 | 356 |
| 3 | Test | 52 | 853 |
| 3 | Control | 46 | 235 |
The 'Test of Means" tool will give the t-score, etc for a the test vs control, but it doesn't have any way to group on experiment. I need to know the p-value for if the test value is significantly different than the control value for each experiment.
The only way I have figured out to do this would be to separate the data be experiment, use the Test Means tool to give the p-value, and rejoin the data. That is really cumbersome and not dynamic as I add new experiments to the bottom of the data.
Any help would be greatly appreciated! If only the Test of Mean tool had a "groupby" function.
Thanks,
Trey