Hi, I have 4 questions in the style of the attachement that need to be submitted in Excel files.

1 answer below »
Hi,
I have 4 questions in the style of the attachement that need to be submitted in Excel files.
Answered Same DayJul 25, 2021

Answer To: Hi, I have 4 questions in the style of the attachement that need to be submitted in Excel files.

Pooja answered on Jul 26 2021
158 Votes
Sheet1
    p=    41%
    n=    1008
    CI = p +- z(a/2)*sqrt(p*(1-p)/n)
    C    z*    lower limit    lower limit    upper li
mit    upper limit
    70%    1.04     =41%-1.04*SQRT(41%*(1-41%)/1008)    0.394     =41%+1.04*SQRT(41%*(1-41%)/1008)    0.426
    80%    1.28     =41%-1.28*SQRT(41%*(1-41%)/1008)    0.390     =41%+1.28*SQRT(41%*(1-41%)/1008)    0.430
    90%    1.64     =41%-1.64*SQRT(41%*(1-41%)/1008)    0.385     =41%+1.64*SQRT(41%*(1-41%)/1008)    0.435
    99%    1.96     =41%-1.96*SQRT(41%*(1-41%)/1008)    0.380    ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here