Hi every one,
What is the right way to do a Hypothesis testing for Mean value in Alteryx.
Do you have a sample flow, previous post or a guide?
Thanks.
Hi @huynv96 ,
if you want to use Test of Means tool to check, if the Mean of group 1 shows a significant difference to the mean of group 2, you simply have to provide detail observation data to the Test of Means tool. You need the field to identify the group and a "measure" field (must be numeric). Welch's t-test is performed to test, if the groups have identical means. I've added a very simple sample workflow, configuration is really straightforward. Do this help in any way?
Best,
Roland
@huynv96 @You might want to look into the rest of means tool that’s a part of the predictive tools install.
Hi @RolandSchubert
Thank you for your respond.
I have issue about version so i can not open your workflow you attach.
I create a simple workflow and config as you guide, this is the result.
Can you explain more about T-test value? T-test for what exactly hypothesis in this case?
I see p_value very small, so can it means that we reject null hypothesis (Mean male = mean female) and conclusion is mean male and female is difference?
Thanks
in T-test, the null hypothesis is that the means of the two group are equal (alternative hypothesis for the test is that the difference of the means is not equal to zero).
If the t-value calculated by the T-test is negative, mean of group 1 is less than mean of group 2.
The p-value is the probability of wrongly rejecting the null hypothesis. If the p-value is lower than or equal to 0.05 (significance level 95%), we can reject the null hypothesis and accept the alternative hypothesis. In other words, we can conclude that the mean values of group 1 and 2 are significantly different. For your results, a very low p-value is calculated, so you can reject the null hypothesis (mean male = mean female) and conclude, that means for male and female employees are different.
I hope that clarifies things a bit.
