ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FpTG;AWorkbook+_VBA_PROJECT_CUR"LTG;pTG;VBAlTG; TG; ZO\p Claire Brown Ba= ThisWorkbook=Z 8X@"1Arial1Arial1Arial1Arial1Arial1Arial1( Arial Narrow1Arial1Arial1Arial1 Arial1Arial1 Arial1( Arial Narrow1 Arial1Symbol1 Arial1 Symbol1 Arial1 Arial1Symbol1 Arial1Arial1Arial1&  Arial Black1Arial1Arial1 Arial1Arial1@ Arial1@Arial1Arial1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Arial1Calibri1,8Calibri18Calibri18Calibri1 Arial1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial""#,##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_-;_-* "-"??_-;_-@_- 0.000 0.0000 0.0%;;;"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                #  #  #  #  #  #  #  #  #  #  #  #  $  $  $  $  $  $  $  $  $  $  $  $  %  &   ' ff + ) , * ( ) *  + P , P -  - . /   0 ` 1      2   3 4 a> 5  h@ @ +  H*   X X* X* x@@  x @  x@     H* X* "X* X*  H*      (  "   ,   ,    ,@    ,!   , @   ,@ @   ,!@     ,!    ,!@    ,!!           h@ @ , "8@ @   (@ @ "8@ @  "8   l@ @ +   ,@ @  |  |@ @ ( X   l@ @ ,  X "x@ @   "x@ @    h@ @ +   , X X x  H  H  X  8@ @  8@@  8@  8 @  |@ @ ) |@ @ * |@ @ + | @  \+ \+ |+ |+ |+  |+  |+ |+ ||pR}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}(}0  00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}(}6  00_)}}7 ??v00_)̙[$ -##0.  }A}8 }00_)[$ -}A}9 e00_)[$ -}x}:00_)[$##  }}; ???00_)[$???## ???  ??? ???}-}= 00_)}U}> 00_)[$## }-}? 00_)D     !%D     !%D     !%D     !%D     !%D     !%-  !%-  !%    20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 F Followed Hyperlink   1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%64 Hyperlink   7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`0P Chi-Sq Test3~% points Chi-Sq pdf  User's Notes, Hide_data#Show_chi_square_calc Show_expected Show_test Show_totals5fvf`@@ \ 3  @@  >4Contributions to X2X2 =2Chi-Square Goodness of fit for a Contingency TableTotalsCritical valueDegrees of freedom =Significance level =then result isConclusion: Since H0 Observed frequencies:Expected frequencies:DegreesoffreedomnPercentage points p%xf(x) Kn SignificancelevelCriticalvalueyH1: Association H0: No associationin right-hand tailHYPOTHESIS TESTRESET+Resets the whole sheet, except for the data9Works out the marginal totals for the observed frquenciesExpected<Works out the expected frequencies with same marginal totalsCalcsTestAChi-Square Goodness of fit for a Contingency Table : User's NotesEWorks out the contributory values and the chi-squared test-statisticsNCarries out the test, with given significance level, with stuitable conclusion+ " Up to a 5 by 4 table can be accommodated  R " Use the 'View - Zoom' facility to fit the 'Chi-sq Test' sheet onto your screen   1 " Use the slide bar to set the significance level  I " Use the buttons to 'step' through the calculations and hypothesis test: 1 " Enter your own data or copy a set from a table  ABCA or SASRRWRExample: Pebbles on a beach:e; 5<<P==?1Aucc6 PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vނβ5qx\P s6*+FC]\dzS\1 f˜!(B: Q}qCZ2 %u?E+zo^ͫɛW/_/hyB'~oӯ>O~ߌWu?/f fJ__ꏿ?iߗ0ç,OȱHQ7k_r:o7cf@Ht_o ogG'$ 8?NRx(hdžWE73:ഉ2ϵEU JÄzbq44o>d̳! Pbɇ 5df^ &=d)e٤3ڳ32Iz#1!7?3XhHHN!u?4 9Yʰ))dQUPDnx ۍ*{ڒю!pUf;w a6B][ۊfǭR٘j8XY;Zy5wtuH%GFuXYS/Z[א}nWqR]g{2W^Bjӑg9݀9n14cаE^ jRc0`R}ڈ{-JXh*'ItFf|!oB[ kO~q.~(fqnx@QnM U2طx[VWŦ5R3UzG;@ɔ~ NV <B> 8.)@ D  Q ;D D  significantnot significantB significant  L $6D significant  RejectAcceptB Reject  ~ y$@20HT,|U4q0|T   $  si   ct  ept   B((  X  S @o ]B` bm (   $xx  6TzCC@RZ],@m9 $<Totals<0xx  6EzCC@ 8 `x],@o9 $< Expected<Ixx  6LzCC@  ],@rf9 $<Calcs<+xx  6@FzCC@ b b],@2g9 $<Test<"xx  6FzCC@ d ~],@"r9 $<RESET<7>@ 7   ;Accept ;@Reject?ectect9CC  significant?ectect9CCnot significant{+{ {+{ {+{{+{ Sheet1ggD ZO }  dMbP?_*+%,&?'?(?)?M0EPSON Stylus COLOR 760Z 4hh DLLName16=EPIGUE4G.dllDLLName32=EPID2E4G.dllEPSON Stylus COLOR 760dhh hh q*** q***24 " d??&U} U P} UP} Q}  P}  P  8 8  8 8 8 , , , , , , , , , , ,,,,,,8 `a$R$@R@R@R?R?! P@ Z d ^ R? LST4i@PL@dLAU~N@U_u@U!U"@VxՋ@  P@ Z ^ R@SWUk@Xs{B@X r2;ӂ@XUk"@YSz1%@ ^R@SWul@XhHB@X,=a"@X>_&@Y)")@ _R@SW`%@X̞"@X|:\I&@X5x**@Y"s-@R@SW|y"@X=1F$&@Xrm=)@XJ$+,.@YEn0@R@SWUWJ%@X8.)@Xv",@X&F0@Y z.2@ R@SWz;(@X=O;`",@XD0@XUy2@YuG4@  R @ S W`QW2*@  XHo/@  X%J ؈1@  Xp[4@  Y&w5@  R"@  S W^;^-@  XB0@  XWF3@  XRɚ~5@  Y^_[ߖ7@  R$@  S W fo/@  Xq N2@  Xǂ{4@  X[{57@  Y7dS,09@  R&@  S WLfF1@  Xլ3@ X.Y5@  X׮8@  Y@:@  R(@  S W:z2@ X5@  XO/V7@  XY+7:@  Yb9CL<@ R*@ SW\3@X^])\6@X P8@Xe` 1;@Y=@R,@SW Qk5@X{N7@X[ as:@X&(($=@Yf Q?@R.@SWT N6@XQC8@X`P};@XDz.>Ǭf0L7K:h<@Xh5?@Y +3"A@R1@SW\8@L@dLAXV~L;@XAJ0>G@\Ʈ۴2Դ9<@Xʼ?@Xv BgA@YB@R3@SW)!;4;@X%V2$>@XP m@@XNfnB@YaJC@R4@S[-@wi<@\-{ i?@\nҭA@\4azB@]֚C@0M)  ֚                        DL>@ 7;       L;       L;       L ;       L ;       L ;       D {+{{+{{+{{+{{+{{+{ Sheet4ggD ZO Dߛűj%5EUee  dMbP?_*+%,&?'?(?)?",??&U} P} P}  P} P} P}   P} P}  P} P}  P  t , , , 8 , , , , 8 , , , , , , , , , , , , , , 8 , , , , , , , P n o fff  e  c P ;p %D  ? Bup_D  ?DD% BfDDDAB QQQ~  d?+ dVE? n! @A Pp? ?p'k?GA?=D% BfLDLA QQQ d@ D  d?  Zp? !L?pi? QQQ d@    L+ dVE? n! @A~ b@p?pb7׊? QQQ d@  " d? p@pHz? QQQ d@  / d9~? n! @Ap@p!!?  QQQ d@  & d?  Pp@pP.?  QQQ d@  3 d–M   p@ptLQ? QQQ d.@  C d77> -   n! @Ap@p|lO? QQQ d0@  : d> $  p @p7~)? QQQ d1@  G dfj> 1   n! @Ap!@pV/?Qq? D Q d2@  > dj> (  p"@pu:? QQQ d3@  K dH> 5   n! @Ap#@p=׋Ʌ? QQQ d4@ B d4V'> ,  p$@pl_h? QQQ  QQ p%@p {?p&@pSY &v?p'@pgqq? c cp(@p-[}l?hhHB@ D~ dp)@p4Gk>Nf?hhHB@DSd2{[?=D% BfDDDAp*@p 6a?~ P$@p+@pH' \?p,@p*MV?p-@ p.{kQ?  p.@ pÀL?!D.lV\>>>>>!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?,@,!p/@"!p5;+F?""p0@!""R1L?"pg _A?##p0@$"#p~Sv;?%$p1@#"$p'E5?&%p1@$"%pgT1?'&p2@%"&pOr`+?('p2@&"'pt 2ȝ%?)(p3@'"(p!?))p3@(")pH#U?**p4@+"*pxS;?++p4@*"+p>?,,p5@-",pazd ?--p5@,"-pWo?..p6@/".pwb?0/p6@."/p.^>10p7@/"0p5FR>11p7@0"1p, zQ>22p8@3"2pJ;N.>43p8@2"3p>54p9@3"4p?->65p9@4"5pݽ>76p:@5"6p{jI>87p:@6"7pRVS>98p;@7"8p4z: >99;8"9ܼ>::<@;":p̊'8s>;;<@:";p#><<p=@="<pO9->===<"=p}^؎>>>p>@?">pFam>@?p>@>"?pȜ>A@p?@?"@p\-7>AD] l>[>>>>>>>>>>>>>>>>>>>>>>>>>>>>>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,[,\,],^,_,`,Ap?@@"Apƒ.^>BBp@@C"Bppq >DBGBR=D% BfLDLACp@@@B"Cp >EBDp@@C"Dpطl>FBEp@@D"Ep!*sy>GBFpA@E"Fpy>HBGp@A@F"GpïGt>IBHpA@G"Hp .o>A"ѵƳ>"Ҳc>"?7ĵ"-6>B"$XR>䰪"Җ喲>䰪"c)2>İ䰪"9w.>尪"ʱ!<>RBRpD@R"RpPQ,V6>RB SQQ TQQ UQQ VQQ WQQ XQQ YQQ ZQQ [QQ \QQ ]QQ ^QQ _QQ `QQDl>>>>>>>>>>>>>>>>>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,{,|,},~,,, aQQ bQQ cQQ dQQ eQQ fQQ gQQ hQQ iQQ jQQ kQQ lQQ mQQ nQQ oQQ pQQ qQQ rQQ sQQ tQQ uQQ vQQ wQQ xQQ yQQ zQQ {QQ |QQ }QQ ~QQ QQ QQD@l,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQD@l,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQD@l,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQD@l,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQD@l,,,,,,,, , , , , ,,,,,,,,,,,,,,,,,,, , QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQD@l!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?,@, !QQ "QQ #QQ $QQ %QQ &QQ 'QQ (QQ )QQ *QQ +QQ ,QQ -QQ .QQ /QQ 0QQ 1QQ 2QQ 3QQ 4QQ 5QQ 6QQ 7QQ 8QQ 9QQ :QQ ;QQ <QQ =QQ >QQ ?QQ @QQD@lA,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,[,\,],^,_,`, AQQ BQQ CQQ DQQ EQQ FQQ GQQ HQQ IQQ JQQ KQQ LQQ MQQ NQQ OQQ PQQ QQQ RQQ SQQ TQQ UQQ VQQ WQQ XQQ YQQ ZQQ [QQ \QQ ]QQ ^QQ _QQ `QQD@la,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,{,|,},~,,, aQQ bQQ cQQ dQQ eQQ fQQ gQQ hQQ iQQ jQQ kQQ lQQ mQQ nQQ oQQ pQQ qQQ rQQ sQQ tQQ uQQ vQQ wQQ xQQ yQQ zQQ {QQ |QQ }QQ ~QQ QQ QQD@l,,,,,,,,,,,,,,,,,,,,,,,,,,,, QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ< Q  L     A   A  A  B      f N(  L  3 @ ]B` ~ $vn  c 4NChart 2Q]@  ZOPPPZaajk&?'?(?)?"??3&PHP\0(  \53d23  M4 QQ3Q:  f(x)Q ;RQ ;RQ3_ MM ]  dR R R R R R "#S S4ES S 4 3Q  C. V. lineQ ;Q ;Q3_ MM ]  PR R R R "+S S4ES S 4D$% 03O&!Q4$% 3O&!Q4FA` a 3O! 3*D@$@@&"! ! 43*&"! ! 4%  ` 3OuP$&6Q x'R RR R<$<th?d? /S S4% t Z3O$&&6Q  f(x)'R R<Xy?cdK? /S S4523  M f 6M @FzFE-Qڛb>"JFIFKKMSO Palette C   ")$+*($''-2@7-0=0''8L9=CEHIH+6OUNFT@GHEC !!E.'.EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE"!!1AQqa!1 ?F3]'IƓe5,J$3?O 5LXyYL4tO%fxM\DXL`: a2HS=rtd+f\UtV5m7L?cf7 `Zx5\kٳ"B  @`43d" 3_  M MM ] MMd44S S4D! f8?7o0{k?5e?ċ'?%  D ` 3OT$&6Q L$Chi squared probability distribution'R R<p?a*?K7 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx /S S4 [S S 4Qeee*ven-US TL  3 @  ]B` B (  $>@ 7 Sheet5ggD ZO  @  dMbP?_*+%&?'?(?)?MvEpson Stylus COLOR 760 ESC/P 2C 4dhhA40DINU"4d?]& dOSPEAA" dhh??&U} J}  J}  J  @ @ @ @ @ @ @ @ @ @ @ x$ ~( ~' ~+ ~) ~* z {||||||||} z {||||||||} z {!||||||||} z" {% ||||||||} z# {& ||||||||} H8888PH@0(  >@   7 Sheet3ggD dirfSheet1 Sheet3Sheet4 *  !"#$%&'()+,-./0123456789;<=>?@ABCDEFGHIKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxy{|}~b0* pHd VBAProject4@j = r PE J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE16\MSO.0DLL#M 1@6.0 Ob LibraryKE1bThisWorkbookGTisWrkbUo 2 QHB1Bx3-B,!we*"B+BB|Sheet1GS@#e@Xt1H2N}3J333E <9Modu4le8Wdu82OFMUp!NU4M94I94M9R4d9}ô*5 55 5 5 Fi b-1b}#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 00f%@xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2-1bE<#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 00f%@xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2-1b}#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 00f%@xAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2-1bi#xME(Sheet5:Module1 J __SRP_0zX__SRP_1 SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0Pa%@xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Z 1bpxME(6 <<< .X`  6`   8`  :``  <` `X,%`PE$*\Rffff*07622666810" 8Ph" 8"@H`x"" (@Phx0@Xh B12:F12$0B@HGeneral 2(4F7:F11$0B@HGeneral 2(4I12:M12$0B@HGeneral 2(4M7:M11$0B@HGeneral 2(4A22$0B@HoXI7:L11$0B@HGeneral 2(4A22$0B@HoB16:E20$0B@HGeneral 2(4H16:H16$0B@HGeneral 2(4A22$0B@Ho8G20:M22$0B@HGeneral 2(4A22$0B@Ho`B12:F12$0B@H;;; 2(4F7:F11$0B@H;;; 2(4I12:M12$0B@H;;; 2(4M11:M11$0B@H;;; 2(4I7:L11$0B@H;;; 2(4B16:E20$0B@H;;; 2(4H16:H16$0B@H;;; 2(4G20:M22$0B@H;;; 2(4A22$0B@Hoxp)Attribute VB_Name = "Module1" Sub Show_totals() Range("B12:F12").Select8ion.NumberF ormatGe`neralF7C1;CIM= M7:M1