Stats hw 4 - 8 0.064278 28 8.7398E-016 48 9.92250E-046 9...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Christian Yimgnia Excel Assignment 4 1) n r p q 100 40 0.25 Probability of getting 40 or less 99.968% 2) r 40 n 100 p 0.25 Probability of getting over 40 right 0.0324% 3) r 60 n 100 p 0.5 probability of getting 60 or less 98.240% 4) probability of getting over 60 right 1.760% 5) r P r P r P 0 0.005154 20 0.00000002 40 3.58172E-031 1 0.028632 21 3.1712E-009 41 9.70656E-033 2 0.077943 22 4.6447E-010 42 2.31109E-034 3 0.138565 23 6.2827E-011 43 4.77744E-036 4 0.180905 24 7.8534E-012 44 8.44497E-038 5 0.184925 25 9.0750E-013 45 1.25111E-039 6 0.154104 26 9.6955E-014 46 1.51100E-041 7 0.107628 27 9.5758E-015 47 1.42884E-043
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 8 0.064278 28 8.7398E-016 48 9.92250E-046 9 0.033329 29 7.3669E-017 49 4.50000E-048 10 0.015183 30 5.7298E-018 50 1E-050 11 0.006135 31 4.1074E-019 12 0.002215 32 2.7097E-020 13 0.000719 33 1.6423E-021 14 0.000211 34 9.1237E-023 15 5.63E-005 35 4.6343E-024 16 1.37E-005 36 2.1455E-025 17 3.04E-006 37 9.0201E-027 18 6.20E-007 38 3.4287E-028 19 1.16E-007 39 1.1722E-029 6) Probability between 3 and 7 0.76612616 7) Probability between 2 and 8 0.908346935...
View Full Document

This note was uploaded on 03/05/2012 for the course STAT 100 taught by Professor Brent during the Spring '11 term at University of Minnesota Duluth.

Ask a homework question - tutors are online