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
160 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
March
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
23
24
25
26
27
28
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30