You should clearly label each part of the problems with (a), (b), etc., and ever

Question

You should clearly label each part of the problems with (a), (b), etc., and every computation should be labeled. For example, in the cell next to the mean of the data, you should have typed the word mean or average. Be sure to do your computations using Excel. Do not do computations using Tables A or C or on a calculator and then type the answers into Excel. I WANT THE ANSWER TO BE IN EXCEL FORMAT. (WHAT FORMULAS AND WHAT NUMBERS SHOULD I PUT IN EXCEL). <<<<< FOCUS HERE<<<<<<<<

1. (6 points) A random digit dialing telephone survey of 880 drivers asked, “Recalling the last ten traffic lights you drove through, how many of them were red when you entered the intersections?” Of the 880 respondents, 171 admitted that at least one light had been red. Give a 95% confidence interval for the proportion of all drivers who ran one or more of the last ten red lights they met. State explicitly whether you are using a large-sample or plus four confidence interval and why.

Explanation / Answer

Solution:

Given n = 880, 95% confidence interval
Population proportion p = 171/880
= 0.19432
= 0.05
Z/2 = Z0.025 = 1.96
Confidence interval CI = p ± Z/2 * sqrt[p * (1 - p)/n]
= 0.194 ± 1.96 * sqrt[ 0.194 * (1 - 0.194)/10]
= [0.0, 0.439]

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.