The Excel function CHISQ.DIST.RT will return the p-value. It is necessary to know the chi-square value and the degrees of freedom to use this function. Enter the values into the dialogue box as follows:

Function Arguments CHISQ DIST.RT x 2.20 Deg freedom 2.2 0.531948371 x Returns the right-tailed probability of the chi-squared distribution. Deg_freedom is the number of degrees of freedom, a number between 1 and 10~10, excluding 10 10. Formula result 0.531948371 Help on this function OK Cancel