hw3_sol

hw3_sol - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...

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

View Full Document Right Arrow Icon
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 A B C D E F G H I J K a = 117 x =MOD($B$1*B10+$B$2,$B$3) c = 19 r =B11/$B$3 m = 3364 UP? =IF(C11>C10,1,0) Runs =IF(E11=E10,F10,F10+1) I x r UP? Runs # Runs 70 =F108 0 268 mean R 66.33333 =(2*100-1)/3 1 1099 0.3267 var R 17.45556 =(16*100-29)/90 2 770 0.2289 0 1 3 2645 0.7863 1 2 Zobs 0.877616 =(I7-I8)/SQRT(I9) 4 3360 0.9988 1 2 5 2915 0.8665 0 3 since -1.96 < Zobs < 1.96, fail to reject Ho 6 1310 0.3894 0 3 values do appear to be independent 7 1909 0.5675 1 4 8 1348 0.4007 0 5 9 2991 0.8891 1 6 10 110 0.0327 0 7 11 2797 0.8315 1 8 12 960 0.2854 0 9 13 1327 0.3945 1 10 14 534 0.1587 0 11 15 1945 0.5782 1 12 16 2196 0.6528 1 12 17 1287 0.3826 0 13 18 2582 0.7675 1 14 19 2717 0.8077 1 14 20 1692 0.5030 0 15 21 2871 0.8534 1 16 22 2890 0.8591 1 16 23 1749 0.5199 0 17 24 2812 0.8359 1 18 25 2715 0.8071 0 19 26 1458 0.4334 0 19 27 2405 0.7149 1 20 28 2192 0.6516 0 21 29 819 0.2435 0 21 30 1650 0.4905 1 22 31 1321 0.3927 0 23 32 3196 0.9501 1 24 33 547 0.1626 0 25 34 102 0.0303 0 25 35 1861 0.5532 1 26 36 2460 0.7313 1 26 37 1899 0.5645 0 27 38 178 0.0529 0 27 39 661 0.1965 1 28 40 3348 0.9952 1 28 41 1511 0.4492 0 29 42 1878 0.5583 1 30 43 1085 0.3225 0 31 44 2496 0.7420 1 32 45 2747 0.8166 1 32
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 A B C D E F G H I seed Expo =-10*LN(1-A7) 17635 Normal =20+4*NORMSINV(B7) inv cdf r1 r2 Expo Normal 0.75866 0.785974 14.215 23.170 0.408155 0.342021 5.245 18.372 0.306375 0.591845 3.658 20.929 0.182562 0.578875 2.016 20.796 0.679434 0.868831 11.377 24.484 0.456099 0.113193 6.090 15.161 0.343394 0.895962 4.207 25.036 0.465529 0.302774 6.265 17.934 0.555223 0.627338 8.102 21.299 0.910855 0.28431 24.175 17.720 0.115513 0.337931 1.227 18.328 0.009888 0.445753
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/26/2008 for the course ISE 435 taught by Professor Adumitroaie during the Fall '07 term at USC.

Page1 / 5

hw3_sol - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...

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

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