Does anyone have a Chi-square difference calculator in Excel? I would like to use it to test for significance of Chi-square differences when using the constrained phi method in determining discriminant validity.
Charles, may I be clarified, are you testing significance of independence or significance of difference?
In excel, you have to perform first calculations for a table of expected values on the basis of the contingency table of observed values before you can apply the CHITEST found in the Excel formulas (Click Formulas, More Functions, Statistical, Chitest). Enter the ranges of values for the observed values and expected values.