· Excel Functions A–Z · 1 min read

CHITEST Function in Excel: Chi-Square Test (Older Name)

CHITEST returns the p-value comparing observed and expected counts. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends CHISQ.TEST for new work. Both give the same result.

Read article →

· Excel Functions A–Z · 1 min read

FTEST Function in Excel: F-Test (Older Name)

FTEST returns the p-value comparing two variances. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends F.TEST for new work. Both give the same result.

Read article →