Math 221 Lab5

# Math 221 Lab5 - P(Exactly 4 =B23 P(at least 4 =1(B19 B20...

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

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

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

View Full Document
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
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

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

View Full Document
Table  =POISSON(A19,8,FALSE)

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

View Full Document
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

## This lab report was uploaded on 02/19/2008 for the course MATH 221 taught by Professor Forgot:s during the Spring '07 term at DeVry Houston.

### Page1 / 6

Math 221 Lab5 - P(Exactly 4 =B23 P(at least 4 =1(B19 B20...

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

View Full Document
Ask a homework question - tutors are online