I'm trying to make a chi square test on this table :
I want to compare MX and FE.
I tried that :
but it's not working...
Someone can help please?
May be you need AGGR() to sum the score for table suggests
Chi2Test_p( Groupe, Name, AGGR(Sum([Test Score]), Groupe, Name))
Seems, Working for me
Striaght table - Dim as Groupe
Even, this is also working for your case
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.