Excel's ____ function is used to perform a goodness of fit test.
A) ZTEST
B) TTEST
C) CHISQ.DIST.RT
D) NORM.S.DIST

Question

Quizplus · Accepted Answer

The CHISQ.DIST.RT function in Excel is used to perform a goodness of fit test by calculating the right-tailed probability of the chi-square distribution. It requires the observed values, expected values, and degrees of freedom as input arguments. The function returns the probability of obtaining a chi-square statistic as large as or larger than the observed value, given the null hypothesis that the observed and expected values come from the same distribution.

Excel's ____ Function Is Used to Perform a Goodness of Fit