solution12xlsp1

# solution12xlsp1 - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16...

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 A B C D E F G H I J K L M N O P Q R S HW 12, p. 1 Note: u values must be copied to X and Y, then sorted. Compute average: Enter: Calculation set to "MANUAL" (F9) Integral of (1-F(y)) = 0.4503 We expected <Y> = 1/2.5 = 0.4000 λ X = 5.00 - λ Y = 2.50 Poor estimate compared to actual vaactual value of 0.3997 because of numerical inaccuracy. Simpson;s formula is more accurate: 0.3971 u (1-10,000) (10,001-20,000) sorted X sorted Y BINS F(x) F(y) 1-F(y) Simpson's formula 0.9175128 0.3949791 0.0000015 0.0000118 0 0.00 0.00 1.00 1 1.0000 0.0930362 0.0019123 0.0000172 0.0000362 SUM X= 0.1 0.40 0.23 0.77 4 3.0968 0.0523193 0.6945439 0.0000179 0.0000477 1960.51 0.2 0.64 0.40 0.60 2 1.2078 1.1132757 0.7114590 0.0000204 0.0000767 0.3 0.79 0.53 0.47 4 1.8792 0.0183998 0.0083220 0.0000217 0.0000977 SUM Y= 0.4 0.87 0.63 0.37 2 0.7418 0.5878050 0.1734352 0.0000266 0.0001398 3996.71 0.5 0.92 0.71 0.29 4 1.1524 0.0344057 0.5042066 0.0000308 0.0001950 0.6 0.95 0.78 0.22 2 0.4478 0.3939964 0.2471083 0.0000473 0.0002429 0.7 0.97 0.82 0.18 4 0.7016 0.1008010 0.0506025 0.0000656 0.0003455 0.8 0.98 0.86 0.14 2 0.2758
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online