In Excel, which of the following functions is used to construct a confidence interval for a population variance?
A) CHISQ.DIST
B) F-Test
C) CHI.INV
D) None of the answers is correct.

Question

Quizplus · Accepted Answer

The CHI.INV function is used to find the critical value of the chi-square distribution for constructing a confidence interval for a population variance. The CHISQ.DIST and F-Test functions are used for hypothesis testing related to population variances. Therefore, the correct answer is C.

In Excel, Which of the Following Functions Is Used to Construct