Stats hw 4 - 47 1.42884E-043 9 0.033329 28 8.7398E-016 48...

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) Guess: 20% 2) # of sucesses 40 Trials 100 Probability_s 0.25 Probability of getting over 40 right 0.036% 3) # of sucesses 60 Trials 100 Probability_s 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 1 0.028632 20 0.00000002 40 3.58172E-031 2 0.077943 21 3.1712E-009 41 9.70656E-033 3 0.138565 22 4.6447E-010 42 2.31109E-034 4 0.180905 23 6.2827E-011 43 4.77744E-036 5 0.184925 24 7.8534E-012 44 8.44497E-038 6 0.154104 25 9.0750E-013 45 1.25111E-039 7 0.107628 26 9.6955E-014 46 1.51100E-041 8 0.064278 27 9.5758E-015
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 47 1.42884E-043 9 0.033329 28 8.7398E-016 48 9.92250E-046 10 0.015183 29 7.3669E-017 49 4.50000E-048 11 0.006135 30 5.7298E-018 50 1E-050 12 0.002215 31 4.1074E-019 13 0.000719 32 2.7097E-020 14 0.000211 33 1.6423E-021 15 5.63E-005 34 9.1237E-023 16 1.37E-005 35 4.6343E-024 17 3.04E-006 36 2.1455E-025 18 6.20E-007 37 9.0201E-027 19 1.16E-007 38 3.4287E-028 20 2.00E-008 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 02/11/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