Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm trying to make a chi square test on this table :
I want to compare MX and FE.
I tried that :
Chi2Test_p(Groupe,Name,[Test Score])
but it's not working...
Someone can help please?
Thanks!
May be you need AGGR() to sum the score for table suggests
Chi2Test_p( Groupe, Name, AGGR(Sum([Test Score]), Groupe, Name))
Not working neither...
Seems, Working for me
Striaght table - Dim as Groupe
Chi2Test_p(Groupe,Name,Sales)
Or
Sum(Aggr(Chi2Test_p(Groupe,Name,Sales),Groupe))
Even, this is also working for your case
Aggr(Chi2Test_p(Groupe,Name,Sales), Groupe)
Note: The P-value is the probability that a chi-square statistic having 2 degrees of freedom is more extreme than 19.58. We use the Chi-Square Distribution Calculator to find P(Χ2 > 19.58) = 0.0001. Interpret results. Since the P-value (0.0001) is less than the significance level (0.05), we cannot accept the null hypothesis.
Thank you for your answer! It's working. My problem came from my model.
Excellent question!
with the same data above my application got results:
MX = 0.986, which is different from MX = 0.7055 in the example shown... why? Thank.