If a test statistic has a value of X and is assumed to be χ² distributed with df degrees of freedom, then the p-value for a right-tailed test found by using Excel's command ________. A) '=CHISQ.DIST.RT(X, Deg_freedom)' B) '=CHISQ.DIST.RT(Deg_freedom, X)' C) '=1-CHISQ.DIST.RT(X, Deg_freedom)' D) '=1-CHISQ.DIST.RT(Deg_freedom, X)'

Question

Quizplus · Accepted Answer

The correct Excel command to find the p-value for a right-tailed test when the test statistic is assumed to follow a chi-square distribution is '=CHISQ.DIST.RT(X, Deg_freedom)'. This command requires the value of the test statistic (X) and the degrees of freedom (Deg_freedom) as inputs.

If a Test Statistic Has a Value of X and Is