Which of the following Excel functions is used to determine the left-tailed value given any probability?
A)CHISQ.INV (probability,n)
B)CHISQ.INV (probability,n-2)
C)CHISQ.INV (probability,deg_ freedom)
D)CHISQ.INV (probability,n/2)

Question

Which of the following Excel functions is used to determine the left-tailed  value given any probability?
A)CHISQ.INV (probability,n) 
B)CHISQ.INV (probability,n-2) 
C)CHISQ.INV (probability,deg_ freedom) 
D)CHISQ.INV (probability,n/2)

Quizplus · Accepted Answer

The CHISQ.INV function is used to determine the left-tailed value given a probability and degrees of freedom. Therefore, we need to use the syntax CHISQ.INV(probability, deg_freedom), which indicates that the correct answer is C. The other options have either incorrect parameters or do not solve the problem of determining a left-tailed value.

Which of the Following Excel Functions Is Used to Determine