ࡱ>  _ Worksheet&Tools&WindowChart&Tools&WindowVisual Basic Module&Tools&Window\pTony CRUTTENDEN B=.8@"1Geneva1Geneva1Geneva1Geneva1Geneva1Geneva1 Bookman Old Style1%Bookman Old Style Bold1Geneva1 Bookman Old Style1Palatino1Geneva1 Bookman Old Style1 Geneva1$Geneva1@ Geneva1Geneva1 Impact""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00!""#,##0.00;[Red]\-""#,##0.003*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-*)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-;,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-2+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)52_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)41_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00000 0.00000.0000.0??/??"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"                        @, "X, "X,   H,  *x, AI@  "x, AI@  (x AI@  " AI@  "X, &P,  H,  H, "X, "P,  "X,   H, "x, A"x, A@"x, "x, @ H,  "X,  *x0 AI@  "x0 AI@ &X, Followed Hyperlink  Hyperlink8dq:F ``iݜ*o?H6A^BbzbO/(fvEE>j(9jJ2BBB Empirical vs. Theoretical _  (@XcBg  MbP?_*+%,&APage &PMmathP e'bs-0Xbo0 4, ttghjil  d,"dXX??:# RANDBETWEENU} DB} DB} DB} $DB} $DB}  $DB}  DB} DB} $%DB} %DB} m%DB}  DB  X @ @ k@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ ?@ :/2Compare Experimental and Theoretical Probabilities ! "#  "# Results Sum-Experimental FrequencyTheoretical Frequency & 'Die1  (Die2  (Sum~ @#."@cal %g 2AZ&9)? #901DB9 *@ #901DB *@  # LL~ @#.&@ %g 3AZ&9)@ #901DB9 *@ #901DB *@  ~ @#.@ %g 4AZ&9)@ #901DB9 *? #901DB *@  ~ @#.&@ %g 5AZ&9)@ #901DB9 *@ #901DB *&@  ~ @#.*@ %g 6AZ&9)@ #901DB9 *? #901DB *@  ~ @# .$@ %g 7AZ &9 )@ #901DB9 *@ #901DB *&@  ~  @# .,@  %g 8AZ &9 )? #901DB9 *@ #901DB *@  ~ "@# ."@  %g 9AZ &9 )@ #901DB9 *@ #901DB *"@  ~ $@$ . @ %g 10AZ &9 )@ #901DB9 *@ #901DB * @  ~ &@$ ."@ %g 11AZ &9 )@ #901DB9 *@ #901DB *(@  ~ (@$.? %g 12AZ&9)@ #901DB9 *@ #901DB *@   Created by:++&,,9)@ #901DB9 *@ #901DB *@  Hollylynne Stohl Drier++&,,9)? #901DB9 *@ #901DB *@  1)Center for Technology & Teacher Education++&,,9)@ #901DB9 *@ #901DB *&@  University of Virginia++&,,9)@ #901DB9 *? #901DB *@  &,,9)@ #901DB9 *@ #901DB * @  &,,9)@ #901DB9 *@ #901DB *@  &,,9)? #901DB9 *? #901DB *@  &,,9)@ #901DB9 *@ #901DB *"@  &,,9)@ #901DB9 *@ #901DB *$@  &,,9)@ #901DB9 *@ #901DB *@  &,,9)@ #901DB9 *@ #901DB *@  &,,9)@ #901DB9 *@ #901DB * @  &,,9)@ #901DB9 *@ #901DB *$@  &,,9)? #901DB9 *? #901DB *@  &,,9)@ #901DB9 *@ #901DB * @  &,,9)? #901DB9 *? #901DB *@  &,,9)? #901DB9 *@ #901DB *@  DClb!  ?@! ?@" ?@# ?@$ ?@% ?@& ?@' ?@( ?@) ?@* ?@+ ?@, ?@- ?@. ?@/ ?@0 ?@1 ?@2 ?@3 ?@4 ?@5 ?@6 ?@7 ?@8 ?@9 ?@: ?@; ?@< ?@= ?@> ?@? ?@ &,,9 )? #901DB9 *? #901DB *@ ! !&,,9!)@! #901DB9! *?! #901DB! *@ " "&,,9")@" #901DB9" *?" #901DB" *@ # #&,,9#)@# #901DB9# *@# #901DB# *"@ $ $&,,9$)@$ #901DB9$ *@$ #901DB$ *@ %$ $C LL %&,,9%)@% #901DB9% *@% #901DB% *@ &$ &&,,9&)@& #901DB9& *?& #901DB& *@ '$ '&,,9')@' #901DB9' *?' #901DB' *@ ($ (&,,9()@( #901DB9( *@( #901DB( *@ )$ )&,,9))?) #901DB9) *?) #901DB) *@ *$ *&,,9*)?* #901DB9* *@* #901DB* *@ +$ +&,,9+)@+ #901DB9+ *@+ #901DB+ *$@ ,$ ,&,,9,)@, #901DB9, *@, #901DB, *"@ -$ -&,,9-)@- #901DB9- *@- #901DB- *$@ .$ .&,,9.)@. #901DB9. *@. #901DB. *@ /$ /&,,9/)?/ #901DB9/ *@/ #901DB/ *@ 0$ 0&,,90)@0 #901DB90 *@0 #901DB0 * @ 1$ 1&,,91)@1 #901DB91 *@1 #901DB1 *@ 2$ 2&,,92)@2 #901DB92 *@2 #901DB2 *"@ 3$ 3&,,93)@3 #901DB93 *@3 #901DB3 *$@ 4$ 4&,,94)@4 #901DB94 *@4 #901DB4 *&@ 5$ 5&,,95)@5 #901DB95 *@5 #901DB5 *@ 6$ 6&,,96)?6 #901DB96 *@6 #901DB6 *@ 7$ 7&,,97)@7 #901DB97 *@7 #901DB7 *&@ 8$ 8&,,98)@8 #901DB98 *@8 #901DB8 *@ 9$ 9&,,99)?9 #901DB99 *@9 #901DB9 *@ :$ :&,,9:)@: #901DB9: *@: #901DB: *$@ ;$ ;&,,9;)@; #901DB9; *@; #901DB; *@ <$ <&,,9<)@< #901DB9< *@< #901DB< * @ =$ =&,,9=)@= #901DB9= *@= #901DB= *@ >$ >&,,9>)@> #901DB9> *@> #901DB> * @ ?$ ?&,,9?)@? #901DB9? *@? #901DB? *"@ @$ Dl@ ?@A ?@B ?@C ?@D ?@E ?@F ?@G ?@H ?@I ?@J ?@K ?@L ?@M ?@N ?@O ?@P ?@Q ?@R ?@S ?@T ?@U ?@V ?@W ?@X ?@Y ?@Z ?@[ ?@\ ?@] ?@^ ?@_ ?@ @&,,9@)@@ #901DB9@ *@@ #901DB@ *@ A$ A&,,9A)?A #901DB9A *?A #901DBA *@ B$ B&,,9B)@B #901DB9B *@B #901DBB *&@ C$ C&,,9C)@C #901DB9C *@C #901DBC *$@ D$ D&,,9D)?D #901DB9D *?D #901DBD *@ ED Dg $ LL E&,,9E)@E #901DB9E *@E #901DBE * @ FD F&,,9F)@F #901DB9F *@F #901DBF *"@ GD G&,,9G)?G #901DB9G *@G #901DBG *@ HD H&,,9H)@H #901DB9H *@H #901DBH *"@ ID I&,,9I)?I #901DB9I *@I #901DBI *@ JD J&,,9J)?J #901DB9J *@J #901DBJ *@ KD K&,,9K)@K #901DB9K *@K #901DBK *&@ LD L&,,9L)?L #901DB9L *@L #901DBL *@ MD M&,,9M)@M #901DB9M *?M #901DBM *@ ND N&,,9N)?N #901DB9N *@N #901DBN *@ OD O&,,9O)@O #901DB9O *@O #901DBO *&@ PD P&,,9P)@P #901DB9P *@P #901DBP *&@ QD Q&,,9Q)@Q #901DB9Q *@Q #901DBQ *@ RD R&,,9R)@R #901DB9R *@R #901DBR *$@ SD S&,,9S)?S #901DB9S *@S #901DBS *@ TD T&,,9T)?T #901DB9T *@T #901DBT *@ UD U&,,9U)@U #901DB9U *@U #901DBU * @ VD V&,,9V)@V #901DB9V *?V #901DBV *@ WD W&,,9W)@W #901DB9W *@W #901DBW *@ XD X&,,9X)@X #901DB9X *@X #901DBX *@ YD Y&,,9Y)?Y #901DB9Y *@Y #901DBY *@ ZD Z&,,9Z)?Z #901DB9Z *@Z #901DBZ *@ [D [&,,9[)@[ #901DB9[ *@[ #901DB[ *@ \D \&,,9\)?\ #901DB9\ *@\ #901DB\ *@ ]D ]&,,9])?] #901DB9] *@] #901DB] *@ ^D ^&,,9^)@^ #901DB9^ *?^ #901DB^ *@ _D _&,,9_)@_ #901DB9_ *@_ #901DB_ * @ `D Dl` ?@a ?@b ?@c ?@d ?@e ?@f ?@g ?@h ;i ;j ;k ;l ;m ;n ;o ;p ;q ;r ;s ;t ;u ;v ;w ;x ;y ;z ;{ ;| ;} ;~ ; ; `&,,9`)@` #901DB9` *@` #901DB` *"@ aD a&,,9a)?a #901DB9a *?a #901DBa *@ bD b&,,9b)@b #901DB9b *@b #901DBb * @ cD c&,,9c)@c #901DB9c *@c #901DBc * @ dD d&,,9d)?d #901DB9d *?d #901DBd *@ eD e&,,9e)@e #901DB9e *@e #901DBe * @ fD f&,,9f)@f #901DB9f *?f #901DBf *@ gD g&,,9g)@g #901DB9g *@g #901DBg * @ D h&,, h i&,, i j&,, j k&,, k l&,, l m&,, m n&,, n o&,, o p&,, p q&,, q r&,, r s&,, s t&,, t u&,, u v&,, v w&,, w x&,, x y&,, y z&,, z {&,, { |&,, | }&,, } ~&,, ~ &,,  D l  ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  &,,  $@, ]* Xf  @$~Text 3Calculate the theoretical frequency for each sum occurring in 100 rolls and enter your answers in cells C5 - C15 The calculation will be rounded to the nearest tenth. Observe the changes in the graph. d]>D$ @\~L  _&APage &P"Pag??3323   4  3Q: Experimental FrequencyQ;Q;3      4E4  3Q: Theoretical FrequencyQ;Q;3      4E4D FAs 3O'3 & 43*D@@N#& ! 4%e%;3O&Q Sums'4%z3O+&Q  Frequency'4523  43" Y~H3OTp!%3O&Q423  44$%3O&Q4444  "@ &@ @&@*@$@,@"@ @"@? =.8>   "  Oh+'0HPx Educational Technology CenterrTony CRUTTENDEN@ŏs@^{@GΣ75# Q&" WMFC RrXT75# EMFr !" !" !" !U &% % 6[MlTZ!??9% 69Ml999!??V% 6VMlVVV!??t% 6tMlttt!??% 6Ml!??% 6Ml!??% 6Ml!??% 6Ml!??% 6Ml!??% 6Ml!??% 6Ml!??0% 60Ml000!??E% 6EMlEEE!??Z% 6ZMlZ!??% 6Ml!??W% 6WMlWWW!??% 6Ml!??S% 6SMlSSS!??[% 6[Ml[[[!??% 6Ml!??% 6Ml!??% 6Ml!?? % Ml!?? % ( &% % 6Ml!??% 6Ml!?? % ( &% % 6Ml!??% 6Ml!??   % RL"Genevall^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^% TT %4AUuA %LP1   % ( &% 6Ml!??   TT APAUuA ALP2   :% 6:Ml:::!??   TT _nAUuA _LP3^   W% 6WMlWWW!??   TT AUuA LP4^   u% 6uMluuu!??   TT AUuA LP5^   % 6Ml!??   TT AUuA LP6   % 6Ml!??   TT AUuA LP7   % 6Ml!??   TT AUuA LP8^   % 6Ml!??   TT AUuA LP9^   % 6Ml!??   TX AUuA LP10   % 6Ml!??   TX.AUuALP11   % 6Ml&" WMFC 2r!??   TX4CAUuA4LP12   1% 61Ml111!??   TXITAUuAILP13   F% 6FMlFFF!??   TT5=AUuA5LPA    % 6Ml!??   TTAUuALPB^    X% 6XMlXXX!??   TTAUuALPC    % 6Ml!??   TTU]AUuAULU[PD^    T% 6TMlTTT!??   TTltAUuAlLPE    \% 6\Ml\\\!??   TTAUuALPF   % 6Ml!??   TTAUuALPG^    % 6Ml!??% % % " ! U  '0% Mltd!??MltWTt>!??'*o0% (  *o% MlWtTWt!??'0% (  % MltSTtx!??'0% (  % MlStTSt]!??   RL Impact^^^^^^^^^^^^^^^^^^^^^^^^% Txs8AUuAs2LCompare Experimental and Theoretical Probabilities         % % " !u % RLBookman Old StylekAUuA4LP2g TTAUuALP9g TT4>AUuA4LP3g TXAUuALP11 TT4>AUuA4LP4c TTAUuALP5c TT4>AUuA4LP5c TXAUuALP11 TT4>AUuA4LP6c TXAUuALP13 TT4>AUuA4LP7c TXAUuALP10 TT4>/AUuA4LP8g TX/AUuALP14 TT42>DAUuA42LP9g TT2DAUuA2LP9g TX/GCTAUuA/GLP10 TTGTAUuAGLP8g % % " !U% (   ( % Ml!??MlW!??Ml!??MlS!??Ml[!??Ml&" WMFC r!??Ml!??Ml!??  t&% % 6TtMltStt9!??% 6TMlS9!??% 6TMlS9!??% 6TMlS9!??% 6TMlS9!??% 6TMlS9!??% 6TMlS9!??% 6TMlS9!??0% 6T0Ml0S009!??E% 6TEMlESEE9!??Z% 6TZMlZ9!??t% 6\MltTt!??Wu% 6W\MlWuWTWu!??u% 6\MluTu!??Su% 6S\MlSuSTSu!??% % % " !UU0  % % % !% % % " !% % % " !% % % " !]) &% '0% +W$% % % " ! ])'0% ( &% (  % % V0T6WW66&% ( % % % " !  6W OL  6% % 6W66W66W66W6g6Wg6K6WK6/6W/66W% % % " ! ]) OL&% (  6% % 6W6W6666% % % " ! ])% % % " ! X$% % % " ! 6X% % % " ! 6Y&% ( '0% (  % % V05T;CC;;V0*TU]]UUV0LTpxxppV0*TV0TV00TV0V0V0   V0'//''V0BJJBB% % % " ! 6X% % % " ! ])&% (  6% % 661661661661661661g66g1K66K1/66/16666W666P6Pk6k666666"6"=6=W6W% % % " ! ])% % % " ! ])   % RL"Geneva2345679:;<=>?@ABCDEFGIJKLMNO% TTAUuA LP0 TTsC{TAUuA LP5 TXj'{9AUuALP10 TXj {AUuALP15 TXj{AUuA{LP20 TXj{AUuA^LP25 TXj{AUuABLP30 TXj{AUuA&LP35 TXj~{AUuA LP40 % % % " ! ])% % % " ! ]) % % TTAUuA?LP2 TTAUuAYLP3 TTAUuAtLP4 TTAUuALP5 TTx &WMFCrAUuALP6 TTAUuALP7 TTAUuALP8 TTAUuALP9 TXAUuA LP10 TXAUuA'LP11 TXAUuAALP12 % % % " ! ])% % % " !  $ % RL"Genevagcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcggcgcgcgcgcgcgcgcgcgccgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcc% TdAUuALTSums  % % % " ! ])% % % " ! ` % RL "Genevacgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgccgcgcgcgcgcgcgcgcgcgcgcgcgccgg% T[nAUuA L`Frequencyg% ( % % % " ! ])% (   % % + NL% % % " !  !NK% % % " !  !NK&% (   % '0% +'.  RL "Genevacgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcgccgcgcgcgcgcgcgcgcgcgcgcgcgcgcgcc% TAUuA#LxExperimental Frequency % % % " !!NK% % % " !!NK& % ( '0% (  % % +<C  % TAUuA8LxTheoretical Frequencyg% % % " !!NK% % % " !])% % % " !])&% ( ' 0% (  % % +W$% ( % ( % % % " ! ])" U! " ! " K@0 UU % % " ! U % % 6Ml!??% 6UMlTU!??% % "   U''',U --[ @ !Z9-9 @ !9V-V @ !Vt-t @ !t- @ !- @ !- @ !- @ !- @ !- @ !- @ !0-0 @ !0E-E @ !EZ-Z @ !Z- @ !W-W @ !W- @ !S-S @ !S[-[ @ ![- @ !- @ !- @ ! - @ ! --- @ !- @ ! --- @ !- @ ! - "Geneva?????????????????????- 2 % 1 -- @ !  2 A 2 :-: @ !:  2 _ 3 W-W @ !W  2 4 u-u @ !u  2 5 - @ !  2 6 - @ !  2 7 - @ !  2 8 - @ !  2 9 - @ !  2 10 - @ !  2 11 - @ !  2 412 1-1 @ !1  2 I13 F-F @ !F  2 5A  - @ !  2 B  X-X @ !X  2 C  - @ !  2 UU[D  T-T @ !T  2 lE  \-\ @ !\  2 F - @ !  2 G  - @ !--"System6NRXbp~-' ,U 0- @ !d @ !>t*o0- *o- @ !tW0- - @ !xt0- - @ !]tS   Impact????????????????????????-R2 s2Compare Experimental and Theoretical Probabilities         --',u-Bookman Old Style?????????????- 2 &Sum --',uX-- 2 ub Experimental   2 n Frequency  --',Su-- 2 u Theoretical   2 Frequency  --',U-- 2 42 2 9 2 43 2 11 2 44 2 5 2 45 2 11 2 46 2 13 2 47 2 10 2 48 2 14 2 249 2 29 2 G/10 2 G8 --',U- - @ ! @ !W @ ! @ !S @ ![ @ ! @ ! @ ! t--tT @ !9t-T @ !9-T @ !9-T @ !9-T @ !9-T @ !9-T @ !9-T @ !90-0T @ !90E-ET @ !9EZ-ZT @ !9Zt-\ @ !tuW-\W @ !uWu-\ @ !uuS-\S @ !uS---',U,U- -- ---'---'---',n - 0- yX---' ,n0-  -  - - $hh-  ---' ,l,l L- - L00---' ,n,n -  - - hh---' ,n---' ,n---' ,h---' ,h-  0-   - - $55hh5$**hh*$LLhhL$**hh*$hh$00hh0$,44h,h,$F5N5NhFhF5$`;h;hh`h`;$z55hzhz5$bbhhb---' ,h---' ,n-  - - hhhLL00hhmcmcmcmcmcm c m'c'mAcAm[c[mucumcmc---' ,n---' ,n - "Geneva_?????- 2 _s0 2 Cs5 2 'j10 2 j15 2 j20 2 j25 2 j30 2 j35 2 ~j40 ---',n---',n- - 2 w2 2 w3 2 w4 2 w5 2 w6 2 w7 2 w08 2 wJ9 2 w_10 2 wz11 2 w12 ---',n---',--  "Geneva????????????????????????- 2 Sums  ---',n---',on-  "Geneva????????????????????????-2 [ Frequency----',n-  - - ---' ,---' ,-   - 0-   "Geneva????????????????????????-(2 Experimental Frequency ---',---',- 0-   --  -'2 Theoretical Frequency---',---',n---',n- 0-  - -yX-- ---' ,n' ' ',U --' ,U -- @ !-U @ !U--' ՜.+,00 8@ H n Empirical vs. Theoretical  Worksheets  !"#$%&'()*+,-./012345678:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntryFBook pSummaryInformation(9ĤDocumentSummaryInformation8