Math 221 Lab5 - P(Exactly 4) =B23 P(at least 4)...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Name:  Mahanaim Peterson Subject:  Week 5 Lab 5 Section:  Math221 Date: June 03, 2007 Part 1      Binomial Distribution Tables     Table  =BINOMDIST(A1,10,0.54,FALSE) P(Exactly 8)  =B9 P(at least 8)  = B9+B10+B11 P(less than 8)  = B1+B2+B3+B4+B5+B6+B7+B8 0 0.0004 1 0.0050 2 0.0263 3 0.0824 4 0.1692 5 0.2383 6 0.2331 7 0.1564 8 0.0688 9 0.0180 10 0.0021 P(exactly 8) 0.0688 1.0000 P(at least 8) 0.0889 P(less than 8) 0.9111
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P(Exactly x) 0.0000 0.0500 0.1000 0.1500 0.2000 0.2500 0.3000 0 1 2 3 4 5 6 7 8 9 10 x Table  =BINOMDIST(A17,12,0.1,FALSE) P(Exactly 4)  =B21 P(at least 4)  = B21+B22+B23+B24+B25+B26+B27+B28+B29 P(less than 4)  = B17+B18+B19+B20 0 0.2824 1 0.3766 2 0.2301 3 0.0852 4 0.0213 5 0.0038 6 0.0005 7 0.0000 8 0.0000 9 0.0000
Background image of page 2
10 0.0000 11 0.0000 12 0.0000 1.0000 P(exactly 4) 0.0213 P(at least 4) 0.0256 P(less than 4) 0.9744 Part 2      Poisson     P(Exactly x) 0.0000 0.0500 0.1000 0.1500 0.2000 0.2500 0.3000 0.3500 0.4000 0 1 2 3 4 5 6 7 8 9 10 11 12 x
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Table  =POISSON(A19,8,FALSE)
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: P(Exactly 4) =B23 P(at least 4) =1-(B19+B20+B21+B22) P(more than 4) =1-(SUM(B19:B23)) 0.0003 1 0.0027 2 0.0107 3 0.0286 4 0.0573 5 0.0916 6 0.1221 7 0.1396 8 0.1396 9 0.1241 10 0.0993 P(Exactly 4) 0.0573 11 0.0722 P(at least 4) 0.9576 12 0.0481 P(more than 4) 0.9004 13 0.0296 14 0.0169 15 0.0090 16 0.0045 P(Exactly x) 0.02 0.04 0.06 0.08 0.1 0.12 0.14 0.16 1 2 3 4 5 6 7 8 9 10 x Table =POISSON(A1,8.7,FALSE) P(Exactly 9) =B10 P(at most 9) =POISSON(9,8.7,TRUE) P(more than 9) =1-(SUM(B1:B10)) 0.0002 1 0.0014 2 0.0063 3 0.0183 4 0.0398 5 0.0692 6 0.1003 7 0.1247 8 0.1356 9 0.1311 10 0.1140 P(Exactly 9) 0.1311 11 0.0902 P(at most 9) 0.6269 12 0.0654 P(more than 9) 0.3731 13 0.0438 14 0.0272 15 0.0158 16 0.0086 P(Exactly x) 0.02 0.04 0.06 0.08 0.1 0.12 0.14 0.16 1 2 3 4 5 6 7 8 9 10 x...
View Full Document

Page1 / 6

Math 221 Lab5 - P(Exactly 4) =B23 P(at least 4)...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online