Which of the following Excel functions is used to calculate the exact probability for a left-tailed is distribution?
A) CHISQ.DIST(x,Deg_freedom,Cumulative)
B) CHISQ.DIST(x,n−2)
C) CHISQ.DIST(x,n/2)
D) CHISQ.DIST(x/2,Deg_freedom,Cumulative)

Question

Which of the following Excel functions is used to calculate the exact probability for a left-tailed  is distribution?
A) CHISQ.DIST(x,Deg_freedom,Cumulative) 
B) CHISQ.DIST(x,n−2) 
C) CHISQ.DIST(x,n/2) 
D) CHISQ.DIST(x/2,Deg_freedom,Cumulative)

Quizplus · Accepted Answer

The CHISQ.DIST function in Excel is used to calculate the probability of a value occurring in a chi-squared distribution. The first parameter (x) is the value for which the probability is being calculated. The second parameter (Deg_freedom) is the degrees of freedom for the distribution. The third parameter (Cumulative) is a binary value (either TRUE or FALSE) that specifies whether to calculate the cumulative probability up to x (TRUE) or the exact probability at x (FALSE). In this case, we want the exact probability for a left-tailed distribution, so we would use CHISQ.DIST(x,Deg_freedom,FALSE).

Which of the Following Excel Functions Is Used to Calculate