A newspaper wants to estimate the proportion of Americans who will vote for Candidate A. A random sample of 1000 voters is selected. Of the 1000 respondents, 526 say that they will vote for Candidate A. Which Excel function would be used to construct a confidence interval estimate?
A) NORM.S.INV
B) NORM.INV
C) T.INV
D) INT

Question

Quizplus · Accepted Answer

The NORM.INV function is used to calculate the inverse of the cumulative normal distribution. This function can be used to construct a confidence interval estimate for the proportion of Americans who will vote for Candidate A.

A Newspaper Wants to Estimate the Proportion of Americans Who