ࡱ> dc \p Sean Wallis Ba==^8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-                + ) , *   @@  @   @  @     @      (@  (  (  @ @  @  @  (@@  @ @  @@      `@ @  `@   `@    (  H  @  H `Classroom results SimulationyBinomial,jb(3  @@  Heads Frequency Coin tossesResultsTotal ProbabilitynCrQTo run the simulation again, you need to force Excel to recalculate the worksheet3(Tip: to do this, you can copy a cell over itself.)3(C) Sean Wallis, Survey of English Usage, UCL, 2013]This worksheet calculates the Binomial distribution from first principles for ten coin tossesQYou can change the P value (highlighted) to see what happens with a weighted coin:Note that not everything in life has a probability of 0.5!&= number of students who threw H HeadsProbability of headVThis simulation generates 25 samples of ten coin tosses and counts the number of heads  /y vow/DLZLZu4uLZ0uu 0vv Н0ip000h~0T0t00mwnwHzm00 E000߿00t0p0Percent0]"0d  0X?`0{T0T00~AP?e0P?~Aբ0~AP?HA??@  ;]l  dMbP?_*+%MJHP LaserJet 4050 Series PSlS 4dXXA4PRIV0''''HPP4(΍HSMTJ8HP LaserJet 4050 Series PSHPOrientRotate180FalsePostScriptCustomPageSizeFalseDuplexNoneInputSlotAutoHPDuplicateJobNameOverrideSWFWPageSizeLETTERPageRegionLeadingEdgeMediaTypeAutoCollateTrueOutputBinAutoStapleLocationNoneHPCoversOther_PagesTextAsBlackFalseJCLResolution600dpiHPConsumerCustomPaperTruePrintQualityGroupPQGroup_1JRHDInstalledJRHDOffHPDocPropResourceDataHPCabFileNameJRConstraintsJRCHDFullHPColorModeCOLOR_MODEHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPXMLFileUsedhpmcpdps.xmlPSAlignmentFileHPZLSLHNHPSmartHubInet_SID_263_BID_514_HID_265HPColorAsGrayFalsePIUPHdA4 4 [none] [none]4P d?SEAN44dEXCEL.EXED:\Program Files\Microsoft Office\Office\EXCEL.EXE" dXX??U}  } I } hT0  0   u ' (( ' & % %~ ?@ D@ L@  @  @  @   @  "@$@&@(@*@,@.@0@1@ D2@ L3@4@5@6@7@8@9@~ '"%@@DAZ!" DD@9#A?D  B9?#A?D  B? - #A?D  B?        ?   ?        ? ? ? ?   ? - M#A?D  B?     ? ?  L"   -@@LAZ"   LL@ - #A?D  B ?      ?      ?     ?   ?  ? ?   ? ?  ? ? ? ? @" "   ? ?  ?   ?           ?    ?    ? ?  ?    ? @"@ "? ? ?  ?              ?  ? ?    ? ?      ?   ? @"@ "Q? ? ?       ?   ?      ?    ? ?   ? ? ? ?   ?   ? @ "@ "?  ?  ?        ?       ?   ? ? ? ?   ? ?   @  "@  "Q?  ?      ?      ?          ?  ?  ?        ?  ?  ?    ?         @  "@  "{Gz?  ?  ?    ?      ?  ?  ?      ?    ?  ?  ?          ?  ?  ?        @  "@  "Q?  ?  ?      ?      ?  ?  ?  ?    ?    ?  ?    ?  ?  ?    ?      ?   "@  "  "    ?  ?    ?    ?    ?  ?  ?      ?      ?        ?        ?   $@ "  "    ?  ?       ?   ?         ?    ?  ?  ?  ?    ?  ?  ?      ?    ?  ?   $#%9@ % #%? % #@ % # @ % @  -@   @   @   @   @   @ @ @ @ @ @ @ @ @  -@  @ @ @ @ @ @  @ -     ~ 0?.,0* ` nnnnnnnnn 8  ( @A@A p  6NMM? @KP]`X  "X??3` `` `` ;. ` )\3d23 M NM4  3QQ ; Q ; Q3_ M 3f  MM<4E4D $% M 3O&Q4$% M 3O&Q4FA T 3OX 3 b#M43*$@#M! 74% IM3O1&Q Heads'4% >MZ3OO& Q  Frequency'43 " 444 ee@@@ @@? ? e xp  6NMM? @P:]`  "??3` ` ` ` ` ;.` )??d3d23 M NM4  3QQ ; Q ; Q3_ O   MM<4E4D $% M 3O& Q4$% M 3O& Q4FA f 3OV 3 b#M43*#M! 74% QM3O1&Q Heads'4% >MZ3OO&Q  Probability'43 " 444 eeQ?{Gz?{Gz?{Gz?{Gz?{Gz? {Gz? e >@  "d  dMbP?_*+%M\\print.ad.ucl.ac.uk\print-UCLS 4dXXA4 (210 x 297 mm)PRIV''''DP4(4HSMTJXerox GPD PS V3.2.303.16.0LeadingEdgePageSizeA4PageRegionDuplexDuplexNoTumbleResolution600x600dpiD1NRX xx  @MSCF ,90R?//Uncompressed-Data//c{ ?CK[{pTg?{7<›F{d^Jhn6/PɃh#$NAh@ЇX|P j+ZfV][G)A@U[GU2S)QЎ3wݽa/ss=9658nSY-{G3$N#ا`W/s_f?w 4*yTHDfyL?l{Hw%_z\`8m{Rfk'[%ƑN=eNGY>!0D^ #E17EW,WI K |J@mDBS[I<EI9%,"7U!f{lߐ[evEOg0bp+"Ҟ2O9^K5~鴚zh6 gnԂ>uհ582R˴щv%6>Mݦ)gyBKW !(ڈꭂi1k-RTE{Dhiq/!QhDW"iӚ2)9w'4%AqҠ݀L,D^`l=+}ω<<"!9ִ"Obt?WEnb5[X +0,gMCɈ!%!,_do`8Z|VZw/:.FD–jA xU`#(5`Bty_K_Wz1\&.¸b5Agl9)j' !O"fZQsb'9u׏q|c☬Kebq܎\j|͆s{M"?x}8vӾD 6\k6E#4DĢĭeLh;f*\ch+1RW+PlK=VI<{(/chEScgp݄g :eX*o&ѽV6\#WgKSiP9l:1k]5;Fly?6v?xp5ĞV̏m'bͳq.c\le= "*!üO\!}EAoa~$v^uD8j(p 6.(t7}x\rx'fD,^F49?7af9Fs.*WrUX)=0=+"+h*8Lqs]H3ͨ3:4>7LT:ӄ:SV7-413đ'j-'Of '\V'qjVUf⪞<]@׃qLܲ\ܬQAru9ƵP;Uz,3z;zZr3rq[+'˭ɨ:mu9x<^ωs QxJ= TQωg1xz\ϙQa\@ڧE`Ea939qU٦P9(P5CGGQgTΉ+{碇߻iRTtԱ5}v`o\ؠP7Q'`zFN J\RˆCXNzA'E:'"]Nы斎HNzOEܨ%"G3af]E˳aVUݜaTwT^3 ;9YpXIi4hXIA ;9nu!^raTXMwBLS [quO/Fv  Hi+uX.W%@Et!K!{R!˵vf_y!5Vf]o[vZ jY ۿ#zGԜe炳.޶N׶'nZT0NgXb:i!gڄÆpyʍ!%A4]O7&vK4ռ?ސӦx!l*#ja<2h[t`9z/q4O^ӏt)kzBwZk=4k])kk ގi/3k~NrDw=Z^ mtLw^o'~5}Wwݗ]'׺=}ikګ/xM{t$闺״_wUݗgt)5ݗ@ 5JX?^UOf!FUP%BL^?COM5excel.exeSean 8.0.1.5618128.40.34.12g" dXX??UhT0  0    ' ./  ! ~ !!P? DD#? D @DA:P?$DD @DDD?  L"?  LL$@  L @LAP?.  $DL @LDL@"?F@P?@"?^@P?@"???j@P?@ "?o@ P? @  "?? ?j@  P? @  "?  ^@  P?   @  "?  F@  P?  "@  "?  $@  P?  $@  #P?  ?  P?  &##? %     ~ 0?**h*|||||||||50 (   p  6NMM?  "]`d   "d ??3` `` `` 6.` ( п3d23 M NM4  3QQ ; Q ; Q3_ O   MM<4E4D $% M 3O&Q4$% M 3O&Q4FA \ 3OHo83 b#M43*#M! 74% BM3O7&Q Heads'4% @MZ3Od&Q  Probability'43 " 444 eee >@ Oh+'08@Th  Sean Wallis Sean WallisMicrosoft Excel@&,՜.+,D՜.+,0 PXd lt| UCL1 Classroom results Simulation Binomial  Worksheets 6> _PID_GUIDAN{B03110E3-B4C1-4A87-AA71-86A0A5FB1282}  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRTUVWXYZ\]^_`abRoot Entry FWorkbookSummaryInformation(SDocumentSummaryInformation8[