A newspaper wants to estimate the proportion of Americans who will vote for Candidate A. A random sample of 1000 voters is selec
ted. 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?
The correct answer to the following question will be "NORM.S.INV".
Explanation:
The NORM.IN.V function in Excel determines the opposite of the Cumulative Standard Distribution Function for just a value of x which is given, and the standard deviation and mean of the distribution provided. The probability of NORMINV(mean, probability, standard deviation).
In Excel 2010, the standard. S. Inv function is new and is therefore not easily accessible in Excel's earlier versions.
Tabs are rectangular boxes found on top of your we browser. At the right of each of those tabs, you see a symbol written in 'x' (as shown in the picture). This is the one you should click to close an existing tab.
