Ch. 5 Discrete Probability Distributions problems 13 and 17

profilejams_r1
2_Sample20of20Ch320HW20Submission281291.xlsx
Home>Mathematics homework help>Probability homework help>Ch. 5 Discrete Probability Distributions problems 13 and 17

Q10

Q5
Manual Work Excel Stats Functional Work [No credit will be given. You need to put your Excel Stats Functional Work after finishing "all" your Manual work; DO NOT put your work in the sequence (a) manual work (a) Excel Function (b) manual work (b) Excel Function (c ) manual work (c ) Excel Function, etc..]
arrange the data in ascending order
1 3850 3710 (a) 4082 =PERCENTILE.EXC(B5:B16, 0.8)
2 3950 3755 (b) 3857.5 =PERCENTILE.EXC(B5:B16,0.25)
3 4050 3850 ( c )
4 3880 3880 (d)
5 3755 3880
6 3710 3890
7 3890 3920
8 4130 3940
9 3940 3950
10 4325 4050
11 3920 4130
12 3880 4325
(a) For the 80th percentile, i=(80/100)*(12+1)= 10.4
the 80th percentile=4050+(0.4)*(4130-4050)= 4082
(b) For the 25th percentile, i=(25/100)*(12+1)= 3.25
the 25th percentile=3850+(0.25)*(3880-3850)= 3857.5
(c )
(d)
Excel Stats Functional Work [Put your Excel Stats Functional Work HERE after finishing "all" your Manual work; DO NOT put your work in the sequence (a) manual work (a) Excel Function (b) manual work (b) Excel Function (c ) manual work (c ) Excel Function, etc..]
[Wrong Excel Stats Functional work since answers in Cell B30 to B33 were typed in text]
(a) 4082 =PERCENTILE.EXC(B5:B16, 0.8)
(b) 3857.5 =PERCENTILE.EXC(B5:B16,0.25)
( c )
(d)
[Correct work since when I click on Cell B30 to B33 were typed in text]
(a) 4082
(b) 3857.5 When I click those highlighted cells, the formula will be shown on the top!
( c )
(d)
[Better work since by keeping the text of the formula there will help your future study]
(a) 4082 =PERCENTILE.EXC(B5:B16, 0.8)
(b) 3857.5 =PERCENTILE.EXC(B5:B16,0.25)
( c )
(d)

Q25

Manual Work
x xbar x-xbar (x-xbar)^2
1 46 44 2 4 DO NOT type in 2, 10, -2, 2, -12 cell by cell, then type in the squares 4, 100, 4, 4, and 144 cell by cell as we usually do under pencil and paper calculation!
2 54 44 10 100 Please type in =b4-c4 and =d4^2 (or d4*d4) in Cell D4 and E4, respectively.
3 42 44 -2 4 Then hightlight Cells D4 and E4. Find ghe "+" sign in the right bottom of the highlight, then drag the highlight all the way to Cells D8 and E8.
4 46 44 2 4 If you still don't know how to do it. Plesae watch the video I post there in Ch. 3 DB. Thanks.
5 32 44 -12 144
Sum 220 256
Ave 44
(a) sample variance=256/(5-1)=64/4=64
(b) sample s.d.=sqrt(variance)=sqrt(64)=8
Stats Functional Work
(a) 64 =VAR.S(B4:B8)
(b) 8 =STDEV.S($B$4:$B$8)

Q37

Manual Work
xi wi xi*wi
3.2 6 19.2
2 3 6
2.5 2 5
5 8 40
Sum 12.7 19 70.2
(a) 3.6947368421 You can leave as they are because when I click on Cell B9 and Cell B10, I will see your formula there. For a better job, you can also show the text formula as in cells U9 and U10 =D7/C7
(b) 3.175 =B7/4
Excel Stats Functional Work
(a) N/A
(b) 3.175
You can leave as it is because when I click on Cell B14, I will see its formula on window above. For a better job, you can also show the text formula as in cells U15. =AVERAGE(B3:B6)

Q38

Q41