ࡱ> )|CompObj#AaVBFrame.DWForm D0ğ- -fx 345 ClientWidth = 3990 StartUpPosition = 1 'CenterOwner TypeInfoVer = 138 End *R(H  @}R KQDBTimes New Roman , 10H, ,1Tahoma/<FN1Show Matrix Results?1Tahoma(OK3OqTahoma\(JClick on the button below to input the cell range containing \p pete mikeBarreto Ba=  ThisWorkbook=hL,<X@"1AArial1AArial1AArial1AArial1$AArial1 AArial1.ATimes New Roman1.ATimes New Roman1. ATimes New Roman1.ATimes New Roman1ASymbol1.ATimes New Roman1ASymbol1 ASymbol1. ATimes New Roman1 AArial1AArial1AArial1AArial1AArial1ACalibri1 ACalibri1ACalibri14ACalibri1 ACalibri1ACalibri1ACalibri1,8ACalibri18ACalibri18ACalibri1>ACalibri14ACalibri1<ACalibri1?ACalibri1h8ACambria1ACalibri1 ACalibri1AArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"C"#,##0_);\("C"#,##0\)!"C"#,##0_);[Red]\("C"#,##0\)""C"#,##0.00_);\("C"#,##0.00\)'""C"#,##0.00_);[Red]\("C"#,##0.00\)72_("C"* #,##0_);_("C"* \(#,##0\);_("C"* "-"_);_(@_)?:_("C"* #,##0.00_);_("C"* \(#,##0.00\);_("C"* "-"??_);_(@_) 0.00000 0.0000 0.0000.000000000000 0.00000000000 0.0000000000 0.000000000 0.00000000 0.0000000 0.0000000.0 0.0% 0.000E+00 0.0E+00 0E+00A<_("$"* #,##0.000_);_("$"* \(#,##0.000\);_("$"* "-"??_);_(@_)C>_("$"* #,##0.0000_);_("$"* \(#,##0.0000\);_("$"* "-"??_);_(@_)=8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)E@_("$"* #,##0.00000_);_("$"* \(#,##0.00000\);_("$"* "-"??_);_(@_)0.00000000000000.000000000000000.0000000000000000.00000000000000000.000000000000000000.0000000000000000000.00000000000000000000.00000000000000000000 #,##0.0 #,##0.000 #,##0.0000 #,##0.00000 #,##0.000000 #,##0.0000000#,##0.00000000 0.000%                                                                      ff + ) , *      P  P         ` !      "   # $ a> %  ( "8 #8@ "8  #8@  "8  #8 @  "< #8 @ "8 (8  ,         ,  "8   ( #8@    "<  "<     "8@@ "8  @  20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4 60% - Accent5! 60% - Accent6 "Accent1 #Accent2 $Accent3 %Accent4 &Accent5 'Accent6(Bad) Calculation* Check Cell+,-./Explanatory Text0  1Good2 Heading 13 Heading 24 Heading 35 Heading 46 7Input8 Linked Cell 9Neutral :Note ;Output< =Title >Total? Warning Text`Hnormal t 37F ۺchi =Doc":2x 3  @@  ^M1P Value stat valuex Normdist pdfSENormal Distributionobserved valuehypothesized valuez stattails for testResultsGivendegrees of freedomt stat t dist pdftnorm cdfnorm pdf1-tt(0)-t(-0.1)/0.1norm(0)-norm(-0.1)/0.1approximation errorStudent's t DistributionF DistributionF stat DF numeratorDF denominator f dist pdfDegrees of freedomc2 (Chi-squared) Distribution c2 stat chi dist pdfeThe work above shows how the pdf of the t (and any other DIST function in Excel) can be approximated.?This strategy was employed in the t, F, and chi-squared sheets.Humberto BarretoImproved DW algorithm Thanks to: Frank HowlandPeter ThompsoncAdded picture option in every case with a warning if the observed value is off the scale (cell D5).+Added "< 0.01%" display for small P-values.Fixed t statistic mistakeFixed df problem in t statBarretoSAdded better code for foreign language support that doesn't cause a crash on a Mac.Foreign language for uninstallAssumes alt. hypo. > 0NExcel 2007 screen refresh issue workaround for copying and pasting the pictureExcel 2007 screen refresh solution requires pasting, then pasting as picture. Trouble formatting led me to just add a sheet and paste so user has access to values and formulas.:T w\<]ccn||Zɮ}A}  \(#,##0ef-"??_);_}A}  \(#,##0ef-"??_);_}A}  \(#,##0ef-"??_);_}A}  \(#,##0ef-"??_);_}A}  \(#,##0ef-"??_);_}A}  \(#,##0ef -"??_);_}A}  \(#,##0L-"??_);_}A}  \(#,##0L-"??_);_}A}  \(#,##0L-"??_);_}A}  \(#,##0L-"??_);_}A}  \(#,##0L-"??_);_}A}  \(#,##0L -"??_);_}A}  \(#,##023-"??_);_}A}  \(#,##023-"??_);_}A}  \(#,##023-"??_);_}A}  \(#,##023-"??_);_}A}   \(#,##023-"??_);_}A}!  \(#,##023 -"??_);_}A}"  \(#,##0-"??_);_}A}#  \(#,##0-"??_);_}A}$  \(#,##0-"??_);_}A}%  \(#,##0-"??_);_}A}&  \(#,##0-"??_);_}A}'  \(#,##0 -"??_);_}A}(  \(#,##0-"??_);_}}) } \(#,##0-"??_);_   }}*  \(#,##0-"??_);_??? ??? ??? ???}-}/  \(#,##0}A}1 a \(#,##0-"??_);_}A}2  \(#,##0-"??_);_}A}3  \(#,##0?-"??_);_}A}4  \(#,##023-"??_);_}-}5  \(#,##0}}7 ??v \(#,##0̙-"??_);_   }A}8 } \(#,##0-"??_);_}A}9 e \(#,##0-"??_);_}x}: \(#,##0-"?  }}; ??? \(#,##0-"???? ???  ??? ???}-}=  \(#,##0}U}>  \(#,##0-"? }-}?  \(#,##0M 20% - Accent1 ef %M" 20% - Accent2 ef %M& 20% - Accent3 ef %M* 20% - Accent4 ef %M. 20% - Accent5 ef %M2 20% - Accent6  ef %M 40% - Accent1 L %M# 40% - Accent2 L湸 %M' 40% - Accent3 L %M+ 40% - Accent4 L %M/ 40% - Accent5 L %M3 40% - Accent6  Lմ %M 60% - Accent1 23 %M$ 60% - Accent2 23ٗ %M( 60% - Accent3 23֚ %M, 60% - Accent4 23 %M0 60% - Accent5 23 %M4 60% - Accent6  23 %AAccent1 O %A!Accent2 PM %A%Accent3 Y %A)Accent4 d %A-Accent5 K %A1Accent6  F %9Bad  % Calculation  }%  Check Cell  %????????? ??? Comma( Comma [0]&Currency. Currency [0]G5Explanatory Text %: Followed Hyperlink;Good  a%G Heading 1 I}%OG Heading 2 I}%?G Heading 3 I}%239 Heading 4 I}%( HyperlinkuInput ̙ ??v% K Linked Cell }%ANeutral  e%"Normalb Note  wOutput  ???%????????? ???$Percent1Title I}%MTotal %OO? Warning Text %XTableStyleMedium9PivotStyleLight16 PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!ÄA theme/theme/theme1.xmlYOoE#F{oc'NjGuرhF[xw;23NjHH q　Jĥ|@_73xM6{o~(fIyWk"޽aJCR$'Mnlu"^T$}*OIB.bQn̖kC 0>ACMȉ<&J &M5BNe tY>?#!mfKx=[Ԃu}ˆ ~umoLz^W/}ةLo;9iwk/_tV[,ac߬56YvYp1ϡAz 9ۮ7ެe ."Zk1~EȰ RӔ/x$( :7vʗsSj{"bF^x^xz?>~,ɸ7Gg_zy5^|?}V I򋧿>O~I|SQ>19D{<Ÿ8ߊaG@tOE*\ʻ/ yToN:"1Q(v; y4<$jbRa|PŻǴI Y3wJG݈8b2(<& QHT^w/B(`Z!94[Mc˴j`jG7;Q]o YC5*CocU 9 IQ/ RV+`%*;æWѼ9/#~7qZ$*cߓrUngN>%OOi Dh[BvoLJƌB6>p&>w O]>_x.eywQ,5,^<ؾt&9 ԔEЇIIqhJ#f6kAS&2D)p3ӕ5teO`jvzEOG)9cshger-# ~fu-ԙՍh&9܊- 6 AлY3hX"M$#Fz6#b.w*lyhĭɾ̮]nR3+=,)'Kak.zi X 8Ka6!_ 5[ M܆< kW Ds/Z/j@&8?&5- C⫲K3Zw1K|D!`~J0A?Uֶy&,Xg1K#[y$[BTV)bBRvVt=낕@[\׶Dž8d4~_@`rx \kp*O69mY&ԧ HE]HKN!Vj%2BƣJԊ=" u\ӵC&Y0>g4&oN)j rihr"VTU,koy#ŬjQJpRk3܎Ws;ɢ!JT~u "֠ۀW_ Nq֙4)ڬuZˋw֒TvќXHegvtm,{2Da*20V=CoOQ2'@C8D.IrG[Ȥiࠆ)d͛|?&f9>b|w##(ɇ"C *_p=ce΂aenv*Wm瓗{varAˇ$IDpKs6* ʢG0egAnlCYt֏$Ysă)2|FS` uz'Xr*󠍒F`Bi m/Ҷj9Xrmox86tFo˜ b`>ASDbƟPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!ÄA theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] Ę7ɹq1  T N]Xpy  dMbP?_*+%&A Page &PMBaxter laser printer?dLetter.HP LaserJet 4100 PCL 62xejA_UID1FQl$A;3CYAq!ҝ9cw/.ƅ 4^|ѵ; N_sT.tF@d zoC),xVV*xN+#iLBji6vu@/ri^6%:rSnr } %^d?jEq%B!gFx/ w_$cXcdz1V(do(}+eCO5.2ad]ŌvƳ\pw|"ϷQTAfDɦ/?Wˏ})V*$KDA #Observed value off the scale B~ @`x @>so *?F  " LA% H ~ I? @.~ @w @"3?  ~ @ w @=k^;?  ~ @v @\c D?  ~ @  @GїL?  ~ @@u @AM0T?  ~ @t @P8\?  ~ @t @dˇc?  ~ @`s @9D j?  ~ @ @v?!'r?  ~ @ r @T$ax?  ~ @q @t5?  @ / L~ @p @1W?,  @~ @@p @I!Ecы?  ~  @ @  -0 #LD  , B@~ @ @VRU?  ~  @ @h @333333~ @n @ |?  ~  @ @  @ffffff@ffffff @D\R?  ~  @ @  @@ @:й)?  ~  @ @  @~ @@j @J×?  ~  @ @  @~ @ @:6?  ~  @ @  @ffffff~ @g @2̰?  ~  @ @  @~ @f @Ȗ6?  ~  @ @  @333333~ @@e @}?  ~  @ @  @~ @d @EdNe?  ~  @ @  @~ @ @V?  ~  @ @  @ffffff~ @a @jE*?  ~  @ @  @~ @@` @=4g?  ~  @ @  @333333 ~ @^ @?  ~  @ @  Dolr!W----------_yy}}yyyyyyyyy ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  @! @ @nۃ?!  ~ @ @  !@"~ !@! @73?"  ~ ! @! @  "@#~ "@V" @Fאm?#  ~ " @" @!  #@$~ #@T# @oBpN?$ # #B LA%~ # @# @"  $JK $JJ$@ffffff%~ $@Q$ @?% # ~ $ @$ @#  %@333333&~ %@N% @$HS?& # ~ % @% @$  &@'~ &@& @ =?' # ~ & @& @%  'K'@ٿ(~ '@D' @,켑?( # ~ ' @' @&  (@333333ӿ)~ (@>( @ph?) # ~ ( @( @'  )@ɿ*~ )@4) @g}?* # ~ ) @) @(  *@+~ *@$* @ݑ^g?1 # ~ * @* @)  +@,~ +@+ @P63E? # ~ + @+ @*  ,@?-~ ,@$@, @ݑ^g?- # ~ , @, @+  -@?.~ -@4@- @g}?. # ~ - @- @,  .@333333?/~ .@>@. @ph?/ # ~ . @. @-  /@?0~ /@D@/ @,켑?G # ~ / @/ @.  0@?100O L~ 0@?0 @ =?S # ~ 0 @0 @/  1@333333?20~ 1@N@1 @$HS?2 # ~ 1 @1 @0 1 -1F #LD  , B2@ffffff?30~ 2@Q@2 @?3 # ~ 2 @2 @1 1 3@?40~ 3@T@3 @oBpN?4 # ~ 3 @3 @2 1 4@?50~ 4@V@4 @Fאm?5 # ~ 4 @4 @3 1 5@?60~ 5@?5 @73?6 # ~ 5 @5 @4 1 6@?706@?6 @nۃ?7 # ~ 6 @6 @nۃ?5 1 7@333333?80~ 7@^@7 @?8 # ~ 7 @7 @?6 1 8@?90~ 8@@`@8 @=4g?9 # ~ 8 @8 @=4g?7 1 9@ffffff?:0~ 9@a@9 @jE*?: # ~ 9 @9 @jE*?8 1 :@?;0~ :@?: @V?; # ~ : @: @V?9 1 ;@?<0~ ;@d@; @EdNe?< # ~ ; @; @EdNe?: 1 <@333333?=0~ <@@e@< @}?= # ~ < @< @}?; 1 =JJ=@?>0~ =@f@= @Ȗ6?> # ~ = @= @Ȗ6?< 1 >@ffffff??0~ >@g@> @2̰?? # ~ > @> @2̰?= 1 ?@@@0~ ?@@? @:6?@ # ~ ? @? @:6?> 1 D?l}yyyyyyyyyyyyyyyy}yyyyyyy@ A B C D E F G H I J K L M N O P Q R S @@@A0~ @@@j@@ @J×?A # ~ @ @@ @J×?? 1 A@@B0A@@A @:й)?B # ~ A @A @:й)?@ 1 B@ffffff@C0B@ffffff@B @D\R?C # ~ B @B @D\R?A 1 C@333333@D0~ C@n@C @ |?D C CS LA%~ C @C @ |?B 1 D@@E0~ D@@D @VRU?E C ~ D @D @VRU?C 1 E@@F0~ E@@p@E @I!Ecы?F C ~ E @E @I!Ecы?D 1 F@@G0~ F@p@F @1W?C ~ F @F @1W?E 1 G@ffffff@H0~ G@q@G @t5?H C G LL H@333333@I0~ H@ r@H @T$ax?I C H LL I@@J0~ I@@I @v?!'r?J C I LL J@@K0~ J@`s@J @9D j?K C J LL K@ @L0~ K@t@K @dˇc?L C K LL L@ffffff @M0~ L@t@L @P8\?M C L LL M@333333 @N0~ M@@u@M @AM0T?N C N@ @O0~ N@ @N @GїL?O C O@ @P0~ O@v@O @\c D?P C P@ @QDP~ P@ w@P @=k^;?Q C Q@ffffff@RDQ~ Q@w@Q @"3?R C R@333333@SDR~ R@`x@R @>so *? C S@@DS~ S@@S @☊!?+ C ,6 |y}}yyyZZZZZZLLLLLL$    *  ( 3t p  c 6NChart 13]@B  PP PZaajk"d,,??3PH h0(  hP@3d23   M4 QQ3QQ ;S Q ;SQ3_  NM   dR R R R R R "#S S4ES S 4 3QQ ;EE Q ;EEQ73_  NM   dR R R R "#S S4ES S 4 3QQ ;DD Q ;DDQ63_  NM  dR R R R "#S S4ES S 4 3QQ ;CC Q ;CCQ53_  NM  ffdR R R R "#S S4ES S 4 3QQ ;BB Q ;BBQ43_  NM  dR R R R "#S S4ES S 4 3QQ ;AA Q ;AAQ33_  NM  ffffdR R R R "#S S4ES S 4 3QQ ;@@ Q ;@@Q23_  NM  dR R R R "#S S4ES S 4 3QQ ;?? Q ;??Q13_  NM  dR R R R "#S S4ES S 4 3QQ ;>> Q ;>>Q03_  NM  3f3fdR R R R "#3S S4ES S 4 3QQ ;== Q ;==Q /3_  NM  dR R R R  "#S S4ES S 4 3QQ ;<< Q ;<<Q .3_  NM  dR R R R  "#S S4ES S 4 3QQ ;;; Q ;;;Q -3_  NM  dR R R R  "#S S4ES S 4 3QQ ;:: Q ;::Q ,3_  NM  dR R R R  "#S S4ES S 4 3QQ ;99 Q ;99Q +3_  NM  dR R R R  "#S S4ES S 4 3QQ ;88 Q ;88Q*3_  NM  dR R R R "#S S4ES S 4 3QQ ;77 Q ;77Q)3_  NM  dR R R R "#3S S4ES S 4 3QQ ;66 Q ;66Q(3_  NM  dR R R R "#S S4ES S 4 3QQ ;55 Q ;55Q'3_  NM  dR R R R "#S S4ES S 4 3QQ ;44 Q ;44Q&3_  NM  dR R R R "#S S4ES S 4 3QQ ;33 Q ;33Q%3_  NM  dR R R R "#S S4ES S 4 3QQ ;22 Q ;22Q$3_  NM   dR R R R "#S S4ES S 4 3QQ ;11 Q ;11Q#3_  NM   dR R R R "#S S4ES S 4 3QQ ;00 Q ;00Q"3_  NM   dR R R R "#S S4ES S 4 3QQ ;// Q ;//Q!3_  NM   dR R R R "#S S4ES S 4 3QQ ;.. Q ;..Q 3_  NM   dR R R R "#S S4ES S 4 3QQ ;-- Q ;--Q3_  NM  dR R R R "#3S S4ES S 4 3QQ ;,, Q ;,,Q3_  NM  3333>>dR R R R "#3S S4ES S 4 3QQ ;++ Q ;++Q3_  NM  3f3f==dR R R R "#3S S4ES S 4 3QQ ;** Q ;**Q3_  NM  33<<dR R R R "#3S S4ES S 4 3QQ ;)) Q ;))Q3_  NM  3333;;dR R R R "#3S S4ES S 4 3QQ ;(( Q ;((Q3_  NM  33::dR R R R "#3S S4ES S 4 3QQ ;'' Q ;''Q3_  NM  3f3f99dR R R R "#3S S4ES S 4 3QQ ;&& Q ;&&Q 3_  NM  3f3f88dR R R R  "#3S S4ES S 4 3QQ ;%% Q ;%%Q!3_  NM  77dR R !R R! "#3S S4ES S 4 3QQ ;$$ Q ;$$Q"3_  NM  ffff66dR R "R R" "#3S S4ES S 4 3QQ ;## Q ;##Q#3_  NM  ff55dR R #R R# "#S S4ES S 4 3QQ ;"" Q ;""Q$3_  NM  44dR R $R R$ "#S S4ES S 4 3QQ ;!! Q ;!!Q%3_  NM  33dR R %R R% "#S S4ES S 4 3QQ ; Q ; Q&3_  NM  22dR R &R R& "# S S4ES S 4 3QQ ; Q ;Q'3_  NM  3311dR R 'R R' "#S S4ES S 4 3QQ ; Q ;Q(3_  NM  3f3f00dR R (R R( "# S S4ES S 4 3QQ ; Q ;Q)3_  NM  ̙̙//dR R )R R) "#S S4ES S 4 3QQ ; Q ;Q*3_  NM  ̙̙..dR R *R R* "# S S4ES S 4 3QQ ; Q ;Q+ 3_  NM  --dR R +R R+ "#S S4ES S 4 3QQ ; Q ;Q, 3_  NM  ,,dR R ,R R, "# S S4ES S 4 3QQ ; Q ;Q- 3_  NM  ++dR R -R R- "#S S4ES S 4 3QQ ; Q ;Q. 3_  NM  **dR R .R R. "# S S4ES S 4 3QQ ; Q ;Q/ 3_  NM  ))dR R /R R/ "#S S4ES S 4 3QQ ; Q ;Q03_  NM  ((dR R 0R R0 "# S S4ES S 4 3QQ ; Q ;Q13_  NM  ''dR R 1R R1 "#S S4ES S 4 3QQ ; Q ;Q23_  NM  &&dR R 2R R2 "# S S4ES S 4 3QQ ; Q ;Q33_  NM  %%dR R 3R R3 "#S S4ES S 4 3QQ ; Q ;Q43_  NM  $$dR R 4R R4 "# S S4ES S 4 3QQ ; Q ;Q53_  NM  ##dR R 5R R5 "#S S4ES S 4 3QQ ; Q ;Q63_  NM  !!dR R 6R R6 "# S S4ES S 4D$% 0P3O&Q4$% MP3O&Q4FA 3O3*@?&! 43*??N &! 4% (x 3OV&&Q  standard units'R RR R<&I?&d2?S S43d" 4S S4D[иm?I$D"?0B?p8? [ S S 4Q7eee& >@m 7 Sheet5ggD&j  T"JU  doCEPCompObjFaVBFrame.UserForm2I --MbP?_*+%&A Page &PMBaxter laser printer?dLetter.HP LaserJet 4100 PCL 62xejA_UID1FQl$A;3CYAq!ҝ9cw/.ƅ 4^|ѵ; N_sT.tF@d zoC),xVV*xN+#iLBji6vu@/ri^6%:rSnr } %^d?jEq%B!gFx/ w_$cXcdz1V(do(}+eCO5.2ad]ŌvƳ\pw|"ϷQTAfDɦ/?Wˏ})V*$K ?  @! @ @a3%?!  ~ @ @  !@"~ !@! @DE4?"  ~ ! @! @  "@#~ "@V" @0W!?#  ~ " @" @!  #@$~ #@T# @BLh?$  ~ # @# @"  $JK $JJ$@ffffff%~ $@Q$ @ a3?%  ~ $ @$ @#  %@333333&~ %@N% @2rG?&  ~ % @% @$  &@'~ &@& @GP?'  ~ & @& @%  'K'@ٿ(~ '@D' @3<6?(  ~ ' @' @&  (@333333ӿ)~ (@>( @Xh?)  ~ ( @( @'  )@ɿ*~ )@4) @E|l?*  ~ ) @) @(  *@+~ *@$* @5?,  ~ * @* @)  +@,~ +@+ @X23?  ~ + @+ @*  ,@?-~ ,@$@, @X23?-  ~ , @, @+  -@?.~ -@4@- @5?.  ~ - @- @,  .@333333?/~ .@>@. @E|l?/  ~ . @. @-  /@?0~ /@D@/ @Xh?0  ~ / @/ @.  0@?100O L~ 0@?0 @3<6?1  ~ 0 @0 @/  1@333333?20~ 1@N@1 @GP?2  ~ 1 @1 @0 1 -1F #LD  , B2@ffffff?30~ 2@Q@2 @2rG?3  ~ 2 @2 @1 1 3@?40~ 3@T@3 @ a3?4  ~ 3 @3 @2 1 4@?50~ 4@V@4 @BLh?5  ~ 4 @4 @3 1 5@?60~ 5@?5 @0W!?6  ~ 5 @5 @4 1 6@?706@?6 @DE4?7  ~ 6 @6 @DE4?5 1 7@333333?80~ 7@^@7 @a3%?8  ~ 7 @7 @a3%?6 1 8@?90~ 8@@`@8 @pn?9  ~ 8 @8 @pn?7 1 9@ffffff?:0~ 9@a@9 @!+9?:  ~ 9 @9 @!+9?8 1 :@?;0~ :@?: @(~?;  ~ : @: @(~?9 1 ;@?<0~ ;@d@; @ ?<  ~ ; @; @ ?: 1 <@333333?=0~ <@@e@< @[V1i?=  ~ < @< @[V1i?; 1 =JJ=@?>0~ =@f@= @uU?>  ~ = @= @uU?< 1 >@ffffff??0~ >@g@> @X)??  ~ > @> @X)?= 1 ?@@@0~ ?@@? @׏(?@  ~ ? @? @׏(?> 1 D l}yyyyyyyyyyyyyyyyy}yyyyyyy@ A B C D E F G H I J K L M N O P Q R S @@@A0~ @@@j@@ @Ãf?A  ~ @ @@ @Ãf?? 1 A@@B0A@@A @oi?B  ~ A @A @oi?@ 1 B@ffffff@C0B@ffffff@B @ʮ?C  ~ B @B @ʮ?A 1 C@333333@D0~ C@n@C @s]Ȟ?D  ~ C @C @s]Ȟ?B 1 D@@E0~ D@@D @6pfn> Q ;>>Q03_  NM  3f3fdR R R R "#S S4ES S 4 3QQ ;== Q ;==Q /3_  NM  dR R R R  "#S S4ES S 4 3QQ ;<< Q ;<<Q .3_  NM  dR R R R  "#S S4ES S 4 3QQ ;;; Q ;;;Q -3_  NM  dR R R R  "#S S4ES S 4 3QQ ;:: Q ;::Q ,3_  NM  dR R R R  "#S S4ES S 4 3QQ ;99 Q ;99Q +3_  NM  dR R R R  "#S S4ES S 4 3QQ ;88 Q ;88Q*3_  NM  dR R R R "#S S4ES S 4 3QQ ;77 Q ;77Q)3_  NM  dR R R R "#S S4ES S 4 3QQ ;66 Q ;66Q(3_  NM  dR R R R "#S S4ES S 4 3QQ ;55 Q ;55Q'3_  NM  dR R R R "#S S4ES S 4 3QQ ;44 Q ;44Q&3_  NM  dR R R R "#S S4ES S 4 3QQ ;33 Q ;33Q%3_  NM  dR R R R "#S S4ES S 4 3QQ ;22 Q ;22Q$3_  NM   dR R R R "#S S4ES S 4 3QQ ;11 Q ;11Q#3_  NM   dR R R R "#S S4ES S 4 3QQ ;00 Q ;00Q"3_  NM   dR R R R "#S S4ES S 4 3QQ ;// Q ;//Q!3_  NM   dR R R R "#S S4ES S 4 3QQ ;.. Q ;..Q 3_  NM   dR R R R "#S S4ES S 4 3QQ ;-- Q ;--Q3_  NM  dR R R R "#;S S4ES S 4 3QQ ;,, Q ;,,Q3_  NM  3333>>dR R R R "# S S4ES S 4 3QQ ;++ Q ;++Q3_  NM  3f3f==dR R R R "# S S4ES S 4 3QQ ;** Q ;**Q3_  NM  33<<dR R R R "# S S4ES S 4 3QQ ;)) Q ;))Q3_  NM  3333;;dR R R R "#S S4ES S 4 3QQ ;(( Q ;((Q3_  NM  33::dR R R R "# S S4ES S 4 3QQ ;'' Q ;''Q3_  NM  3f3f99dR R R R "#S S4ES S 4 3QQ ;&& Q ;&&Q 3_  NM  3f3f88dR R R R  "# S S4ES S 4 3QQ ;%% Q ;%%Q!3_  NM  77dR R !R R! "#S S4ES S 4 3QQ ;$$ Q ;$$Q"3_  NM  ffff66dR R "R R" "#S S4ES S 4 3QQ ;## Q ;##Q#3_  NM  ff55dR R #R R# "# S S4ES S 4 3QQ ;"" Q ;""Q$3_  NM  44dR R $R R$ "#S S4ES S 4 3QQ ;!! Q ;!!Q%3_  NM  33dR R %R R% "# S S4ES S 4 3QQ ; Q ; Q&3_  NM  22dR R &R R& "#S S4ES S 4 3QQ ; Q ;Q'3_  NM  3311dR R 'R R' "#S S4ES S 4 3QQ ; Q ;Q(3_  NM  3f3f00dR R (R R( "#S S4ES S 4 3QQ ; Q ;Q)3_  NM  ̙̙//dR R )R R) "#S S4ES S 4 3QQ ; Q ;Q*3_  NM  ̙̙..dR R *R R* "#S S4ES S 4 3QQ ; Q ;Q+ 3_  NM  --dR R +R R+ "#3S S4ES S 4 3QQ ; Q ;Q, 3_  NM  ,,dR R ,R R, "#S S4ES S 4 3QQ ; Q ;Q- 3_  NM  ++dR R -R R- "#S S4ES S 4 3QQ ; Q ;Q. 3_  NM  **dR R .R R. "#S S4ES S 4 3QQ ; Q ;Q/ 3_  NM  ))dR R /R R/ "#S S4ES S 4 3QQ ; Q ;Q03_  NM  ((dR R 0R R0 "# S S4ES S 4 3QQ ; Q ;Q13_  NM  ''dR R 1R R1 "# S S4ES S 4 3QQ ; Q ;Q23_  NM  &&dR R 2R R2 "# S S4ES S 4 3QQ ; Q ;Q33_  NM  %%dR R 3R R3 "#S S4ES S 4 3QQ ; Q ;Q43_  NM  $$dR R 4R R4 "#S S4ES S 4 3QQ ; Q ;Q53_  NM  ##dR R 5R R5 "#S S4ES S 4 3QQ ; Q ;Q63_  NM  !!dR R 6R R6 "#3S S4ES S 4D$% 0P3O&Q4$% MP3O&Q4FAl 3O3*@?&! 43*??N &! 4%   3OV&&Q  standard units'R RR R<w|e@$?@>aZ?S S43d" 4S S4D;Cݶ?l]\?K}ڸ?Y&? [S S 4Q7eee& >@m 7 Sheet51ggD&j  F<Obhf  dMbP?_*+%&A Page &PMBaxter laser printer?dLetter.HP LaserJet 4100 PCL 62xejA_UID1FQl$A;3CYAq!ҝ9cw/.ƅ 4^|ѵ; N_sT.tF@d zoC),xVV*xN+#iLBji6vu@/ri^6%:rSnr } %^d?jEq%B!gFx/ w_$cXcdz1V(do(}+eCO5.2ad]ŌvƳ\pw|"ϷQTAfDɦ/?Wˏ})V*$K@ @=?  ~  @ @}>?  @ffffff?~ @g@ @ I2]?  ~  @ @ I2]?  @@~ @@ @1u?  ~  @ @1u?  @@~ @@j@ @\j?  ~  @ @\j?  @@@@ @B/?  ~  @ @B/?  @ffffff@@ffffff@ @hzƷ?  ~  @ @hzƷ?  @333333@~ @n@ @&A}?  ~  @ @&A}?  @@~ @@ @`yQQ?  ~  @ @`yQQ?  @@~ @@p@ @@]=?  ~  @ @@]=?  @@~ @p@ @@?  ~  @ @@?  @ffffff@~ @q@ @c_$W?  ~  @ @c_$W?  @333333@ ~ @ r@ @ܞx?  ~  @ @ܞx?  Dlexyyyyyyy}yyyyyyyyyy}}yyyyy ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  @@!~ @@ @`?!  ~ @ @`?!  !@@"~ !@`s@! @Р!?"  ~ ! @! @Р!?"  "@ @#""A L~ "@t@" @[|?#  ~ " @" @[|?#  #@ffffff @$"~ #@t@# @3b?$  ~ # @# @3b?$ # 3#8 )LADA  , B $JK $JJ$@333333 @%"~ $@@u@$ @ 5?%  ~ $ @$ @ 5?% # %@ @&"~ %@ @% @ZpT&?&  ~ % @% @ZpT&?& # &@ @'"~ &@v@& @`^ ?'  ~ & @& @`^ ?' # 'K'@ @("~ '@ w@' @?(  ~ ' @' @?( # (@ffffff@)"~ (@w@( @0S6?)  ~ ( @( @0S6?) # )@333333@*"~ )@`x@) @)\?*  ~ ) @) @)\?* # *@@+"~ *@@* @`?+  ~ * @* @`?+ # +@ffffff@,"+@ffffff@+ @`ڳ˥?,  ~ + @+ @`ڳ˥?, # ,@@-"~ ,@@z@, @`?-  ~ , @, @`?- # -@333333@."~ -@z@- @0/e?.  ~ - @- @0/e?. # .@@/".@@. @B ?/  ~ . @. @B ?/ # /@@0"~ /@@/ @IB$?0  ~ / @/ @IB$?0 # 0@ffffff@1"0@ffffff@0 @06?1  ~ 0 @0 @06?1 # 1@@2"~ 1@`}@1 @0'l?2  ~ 1 @1 @0'l?2 # 2@333333@3"~ 2@~@2 @)|?3  ~ 2 @2 @)|?3 # 3@@4"3@@3 @1?4  ~ 3 @3 @1?4 # 4@@5"~ 4@@4 @US2?5  ~ 4 @4 @US2?5 # 5@ffffff@6"5@ffffff@5 @ B ?6  ~ 5 @5 @ B ?6 # 6@@7"~ 6@@@6 @h==?7  ~ 6 @6 @h==?7 # 7@333333@8"~ 7@@7 @@Ѐh?8  ~ 7 @7 @@Ѐh?8 # 8@@9"~ 8@@8 @zt?  ~ 8 @8 @zt?# 9@@:"~ 9@@9 @zbڜ?9  ~ 9 @9 @zbڜ?: 9 39E )LADA  , B:@ffffff@;"~ :@@: @ Wp ?:  ~ : @: @ Wp ?; 9 ;@@<"~ ;@Ё@; @@[nm?;  ~ ; @; @@[nm?< 9 <@333333@="~ <@ @< @#mAš?<  ~ < @< @#mAš?= 9 =JJ=@@>"~ =@p@= @?=  ~ = @= @?> 9 >@@?"~ >@@> @aЈ?>  ~ > @> @aЈ?? 9 ?@ffffff@@"~ ?@@? @`݈??  ~ ? @? @`݈?@ 9 Dilyyyyyyy}yy}y}yy}y}yyyyyyy@ A B C D E @@@A"~ @@`@@ @q]WU?@  ~ @ @@ @q]WU?A 9 A@333333@B"~ A@@A @ȗ?A  ~ A @A @ȗ?B 9 B@@CDB~ B@@B @D(A?B  ~ B @B @D(A?C 9 C@@DDC~ C@@C @?C  ~ C @C @?D 9 D@ffffff@EDD~ D@@D @@?D  ~ D @D @@?E 9 E@@DE~ E@@FE @@|AfǕ? 0DDDDADEDDA?~ E @E @@|AfǕ? 9 ydyyyyy @|1E  P(  n  c 4NChart 1]@pL  PP PZaajk"pL??3PH`p0(  pP3d23   M4 CC3QQ ;E Q ;EQ3_  NM   dR R R R R R "#S S4ES S 4 3QQ ;EE Q ;EEQD3_  NM  --dR R R R "#S S4ES S 4 3QQ ;DD Q ;DDQC3_  NM  ,,dR R R R "#S S4ES S 4 3QQ ;CC Q ;CCQB3_  NM  ++dR R R R "#3S S4ES S 4 3QQ ;BB Q ;BBQA3_  NM  **dR R R R "# S S4ES S 4 3QQ ;AA Q ;AAQ@3_  NM  ))dR R R R "#3S S4ES S 4 3QQ ;@@ Q ;@@Q?3_  NM  ((dR R R R "#3S S4ES S 4 3QQ ;?? Q ;??Q>3_  NM  ''dR R R R "#S S4ES S 4 3QQ ;>> Q ;>>Q=3_  NM  &&dR R R R "#S S4ES S 4 3QQ ;== Q ;==Q <3_  NM  %%dR R R R  "# S S4ES S 4 3QQ ;<< Q ;<<Q ;3_  NM  $$dR R R R  "#S S4ES S 4 3QQ ;;; Q ;;;Q :3_  NM  ##dR R R R  "#S S4ES S 4 3QQ ;:: Q ;::Q 93_  NM  ""dR R R R  "#S S4ES S 4 3QQ ;99 Q ;99Q 83_  NM  !!dR R R R  "#S S4ES S 4 3QQ ;88 Q ;88Q3_  NM  ""dR R R R "#S S4ES S 4 3QQ ;77 Q ;77Q73_  NM   dR R R R "#S S4ES S 4 3QQ ;66 Q ;66Q63_  NM  dR R R R "#S S4ES S 4 3QQ ;55 Q ;55Q53_  NM  ffdR R R R "# S S4ES S 4 3QQ ;44 Q ;44Q43_  NM  dR R R R "#3S S4ES S 4 3QQ ;33 Q ;33Q33_  NM  ffffdR R R R "#S S4ES S 4 3QQ ;22 Q ;22Q23_  NM  dR R R R "#S S4ES S 4 3QQ ;11 Q ;11Q13_  NM  dR R R R "#S S4ES S 4 3QQ ;00 Q ;00Q03_  NM  3f3fdR R R R "#S S4ES S 4 3QQ ;// Q ;//Q/3_  NM  dR R R R "#S S4ES S 4 3QQ ;.. Q ;..Q.3_  NM  dR R R R "#3S S4ES S 4 3QQ ;-- Q ;--Q-3_  NM  dR R R R "#3S S4ES S 4 3QQ ;,, Q ;,,Q,3_  NM  dR R R R "#S S4ES S 4 3QQ ;++ Q ;++Q+3_  NM  dR R R R "#S S4ES S 4 3QQ ;** Q ;**Q*3_  NM  dR R R R "#S S4ES S 4 3QQ ;)) Q ;))Q)3_  NM  dR R R R "#S S4ES S 4 3QQ ;(( Q ;((Q(3_  NM  dR R R R "#S S4ES S 4 3QQ ;'' Q ;''Q'3_  NM  dR R R R "#S S4ES S 4 3QQ ;&& Q ;&&Q &3_  NM  dR R R R  "#S S4ES S 4 3QQ ;%% Q ;%%Q!%3_  NM  dR R !R R! "#3S S4ES S 4 3QQ ;$$ Q ;$$Q"$3_  NM   dR R "R R" "#S S4ES S 4 3QQ ;## Q ;##Q##3_  NM   dR R #R R# "#3S S4ES S 4 3QQ ;"" Q ;""Q$"3_  NM   dR R $R R$ "#S S4ES S 4 3QQ ;!! Q ;!!Q%!3_  NM   dR R %R R% "#S S4ES S 4 3QQ ; Q ; Q& 3_  NM   dR R &R R& "# S S4ES S 4 3QQ ; Q ;Q'3_  NM  dR R 'R R' "# S S4ES S 4 3QQ ; Q ;Q(3_  NM  3333>>dR R (R R( "#S S4ES S 4 3QQ ; Q ;Q)3_  NM  3f3f==dR R )R R) "#S S4ES S 4 3QQ ; Q ;Q*3_  NM  33<<dR R *R R* "#S S4ES S 4 3QQ ; Q ;Q+3_  NM  3333;;dR R +R R+ "#S S4ES S 4 3QQ ; Q ;Q,3_  NM  33::dR R ,R R, "#S S4ES S 4 3QQ ; Q ;Q-3_  NM  3f3f99dR R -R R- "#S S4ES S 4 3QQ ; Q ;Q.3_  NM  3f3f88dR R .R R. "#S S4ES S 4 3QQ ; Q ;Q/3_  NM  77dR R /R R/ "#S S4ES S 4 3QQ ; Q ;Q03_  NM  ffff66dR R 0R R0 "#S S4ES S 4 3QQ ; Q ;Q13_  NM  ff55dR R 1R R1 "#S S4ES S 4 3QQ ; Q ;Q23_  NM  44dR R 2R R2 "#S S4ES S 4 3QQ ; Q ;Q33_  NM  33dR R 3R R3 "#S S4ES S 4 3QQ ; Q ;Q43_  NM  22dR R 4R R4 "#S S4ES S 4 3QQ ; Q ;Q53_  NM  3311dR R 5R R5 "#S S4ES S 4 3QQ ; Q ;Q63_  NM  3f3f00dR R 6R R6 "#S S4ES S 4 3QQ ; Q ;Q73_  NM  ̙̙//dR R 7R R7 "#S S4ES S 4 3QQ ; Q ;Q83_  NM  ̙̙..dR R 8R R8 "#S S4ES S 4 3QQ ; Q ; Q9 3_  NM  --dR R 9R R9 "# S S4ES S 4 3QQ ; Q ; Q: 3_  NM  ,,dR R :R R: "#S S4ES S 4 3QQ ; Q ; Q; 3_  NM  ++dR R ;R R; "#S S4ES S 4 3QQ ; Q ; Q< 3_  NM  **dR R <R R< "#S S4ES S 4 3QQ ; Q ; Q= 3_  NM  ))dR R =R R= "#S S4ES S 4 3QQ ; Q ;Q>3_  NM  ((dR R >R R> "#S S4ES S 4 3QQ ; Q ;Q?3_  NM  ''dR R ?R R? "#S S4ES S 4 3QQ ; Q ;Q@3_  NM  &&dR R @R R@ "#S S4ES S 4 3QQ ; Q ;QA3_  NM  %%dR R AR RA "# S S4ES S 4 3QQ ; Q ;QB3_  NM  $$dR R BR RB "#S S4ES S 4 3QQ ; Q ;QC3_  NM  ##dR R CR RC "#S S4ES S 4 3QQ ; Q ;QD3_  NM  !!dR R DR RD "#3S S4ES S 4D$% 0P3O&Q4$% MP3O&Q4FAl 3O3*&! 43*N &! 43d" 44D;Cݶ?l]\?.^&?Y&? [3S S 4CEeee& >@m 7 Sheet511ggD&  FHBY  dMbP?_*+%&A Page &PMBaxter laser printer?dLetter.HP LaserJet 4100 PCL 62xejA_UIDED334€"(D3q8g5EܸP| %oSyTu x)>:K Ɯru+(tЫ!>~ 9@ςauM߮g12 9޺q$qUa?ه\>1xސc0B|@{ÔbiNErݐkOxG=(:&I+*ysC/Ŀ'aWĿIc41;!]s9*> DDA-C6? < 0.01%DDAB@?" L~ @?0 @@s9k ?DADDA~  @ @  3" )LADA  , B@@~ @@6 @@]3r? DDADDA~  @ @@]3r?  @@~ @@ @#~?  *D @ LDALDA~  @ @#~?  Q@@~ @@ @(ʃh?  ~  @ @(ʃh?  @"@~ @"@ @(J3?  ~  @ @(J3?  @&@ ~ @&@ @Z4cQݶ?  ~  @ @Z4cQݶ?   @*@ ~ @*@ @*1?  ~ @ @*1?   @.@ ~ @.@ @"?  ~  @ @!>"?  @B@~ @B@ @ *J`?  ~  @ @ *J`?  @C@~ @C@ @,R?  ~  @ @,R?  @D@~ @D@ @6V}F>  ~  @ @6V}F>  @E@~ @E@ @u>  ~  @ @u>  @F@~ @F@ @XL!3>  ~  @ @XL!3>  @G@~ @G@ @_K˩>  ~  @ @_K˩>  @H@~ @H@ @wq4>  ~  @ @wq4>  @I@~ @I@ @ߑ>  ~  @ @ߑ>  @J@~ @J@ @]e>  ~  @ @]e>  @K@~ @K@ @I$ck>  ~  @ @I$ck>  @L@ ~ @L@ @f[VW>  ~  @ @f[VW>  DleZyyyyyyyyyyyyyyyyyyyyyyyy ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  @M@!~ @M@ @ OwD>!  ~ @ @ OwD>!  !@N@"~ !@N@! @ߋ1>"  ~ ! @! @ߋ1>"  "@O@#~ "@O@" @i[>#  ~ " @" @i[>#  #JK#@@P@$##B L~ #@@P@# @Īzj >$  ~ # @# @Īzj >$ # 3#E #)LADA  , B $JJ$@P@%#~ $@P@$ @S|=%  ~ $ @$ @S|=% # %@@Q@&#~ %@@Q@% @aXb==&  ~ % @% @aXb==& # &K&@Q@'#~ &@Q@& @3nT='  ~ & @& @3nT=' # '@@R@(#~ '@@R@' @{]V=(  ~ ' @' @{]V=( # (@R@)#~ (@R@( @<]t)=)  ~ ( @( @<]t)=) # )@@S@*#~ )@@S@) @}䀑=*  ~ ) @) @}䀑=* # *@S@+#~ *@S@* @WR|=+  ~ * @* @WR|=+ # +@@T@,#~ +@@T@+ @2Acݫg=,  ~ + @+ @2Acݫg=, # ,@T@-#~ ,@T@, @-S=-  ~ , @, @-S=- # -@@U@.#~ -@@U@- @&r^@=.  ~ - @- @&r^@=. # .@U@/#~ .@U@. @ R[[*=/  ~ . @. @ R[[*=/ # /@@V@0#~ /@@V@/ @Z=0  ~ / @/ @Z=0 # 0@V@1#~ 0@V@0 @{b=1  ~ 0 @0 @{b=1 # 1@@W@2#~ 1@@W@1 @&ztt<2  ~ 1 @1 @&ztt<2 # 2@W@3#~ 2@W@2 @7V(<3  ~ 2 @2 @7V(<3 # 3@@X@4#~ 3@@X@3 @aA<4  ~ 3 @3 @aA<4 # 4@X@5#~ 4@X@4 @;o"<5  ~ 4 @4 @;o"<5 # 5@@Y@6#~ 5@@Y@5 @A(I<6  ~ 5 @5 @A(I<6 # 6@Y@7#~ 6@Y@6 @h,?<7  ~ 6 @6 @h,?<7 # 7@@Z@8#~ 7@@Z@7 @,z`o<8  ~ 7 @7 @,z`o<8 # 8@Z@9#~ 8@Z@8 @'Y<9  ~ 8 @8 @'Y<# 9@@[@:#~ 9@@[@9 @Ry"D<:  ~ 9 @9 @Ry"D<: # :@[@;#~ :@[@: @!et^0<;  ~ : @: @!et^0<; # ;@@\@<#~ ;@@\@; @r<<  ~ ; @; @r<< # <@\@=#~ <@\@< @~Y4v<=  ~ < @< @~Y4v<= # =JJ=@@]@>#~ =@@]@= @DFH;>  ~ = @= @DFH;> # >@]@?#~ >@]@> @zm;?  ~ > @> @zm;? # ?@@^@@#~ ?@@^@? @1M;@  ~ ? @? @1M;@ # Dlyyyyyyyyyyyyyyyyyyyyyyyyyyy@ A B C D E @@^@A#~ @@^@@ @G;A  ~ @ @@ @G;A # A@@_@B#~ A@@_@A @]{Ǚ;B  ~ A @A @]{Ǚ;B # B@_@C#~ B@_@B @b;C  ~ B @B @b;C # C@ `@DDC~ C@ `@C @nfp;D  ~ C @C @nfp;D # D@``@EDD~ D@``@D @癦AehY;E  ~ D @D @癦AehY;E # E@`@DE~ E@`@6E @vÇoD; DDDADEDA~ E @E @vÇoD; # idyyyyy vE  p (   n  c 4NChart 1]@DQ  PP PZaajk"DQ??3PHt0(  tP3d23   M4 CC3QQ ;E Q ;EQ3_  NM   dR R R R R R "#3S S4ES S 4 3QQ ;EE Q ;EEQD3_  NM  --dR R R R "#3S S4ES S 4 3QQ ;DD Q ;DDQC3_  NM  ,,dR R R R "# S S4ES S 4 3QQ ;CC Q ;CCQB3_  NM  ++dR R R R "#3S S4ES S 4 3QQ ;BB Q ;BBQA3_  NM  **dR R R R "#3S S4ES S 4 3QQ ;AA Q ;AAQ@3_  NM  ))dR R R R "#S S4ES S 4 3QQ ;@@ Q ;@@Q?3_  NM  ((dR R R R "#S S4ES S 4 3QQ ;?? Q ;??Q>3_  NM  ''dR R R R "# S S4ES S 4 3QQ ;>> Q ;>>Q=3_  NM  &&dR R R R "#S S4ES S 4 3QQ ;== Q ;==Q <3_  NM  %%dR R R R  "#S S4ES S 4 3QQ ;<< Q ;<<Q ;3_  NM  $$dR R R R  "#S S4ES S 4 3QQ ;;; Q ;;;Q :3_  NM  ##dR R R R  "#3S S4ES S 4 3QQ ;:: Q ;::Q 93_  NM  ""dR R R R  "#3S S4ES S 4 3QQ ;99 Q ;99Q 83_  NM  !!dR R R R  "#S S4ES S 4 3QQ ;88 Q ;88Q3_  NM  ""dR R R R "#S S4ES S 4 3QQ ;77 Q ;77Q73_  NM   dR R R R "#S S4ES S 4 3QQ ;66 Q ;66Q63_  NM  dR R R R "#S S4ES S 4 3QQ ;55 Q ;55Q53_  NM  ffdR R R R "# S S4ES S 4 3QQ ;44 Q ;44Q43_  NM  dR R R R "#3S S4ES S 4 3QQ ;33 Q ;33Q33_  NM  ffffdR R R R "#S S4ES S 4 3QQ ;22 Q ;22Q23_  NM  dR R R R "#S S4ES S 4 3QQ ;11 Q ;11Q13_  NM  dR R R R "#S S4ES S 4 3QQ ;00 Q ;00Q03_  NM  3f3fdR R R R "#S S4ES S 4 3QQ ;// Q ;//Q/3_  NM  dR R R R "# S S4ES S 4 3QQ ;.. Q ;..Q.3_  NM  dR R R R "#S S4ES S 4 3QQ ;-- Q ;--Q-3_  NM  dR R R R "#3S S4ES S 4 3QQ ;,, Q ;,,Q,3_  NM  dR R R R "#S S4ES S 4 3QQ ;++ Q ;++Q+3_  NM  dR R R R "#S S4ES S 4 3QQ ;** Q ;**Q*3_  NM  dR R R R "#3S S4ES S 4 3QQ ;)) Q ;))Q)3_  NM  dR R R R "#3S S4ES S 4 3QQ ;(( Q ;((Q(3_  NM  dR R R R "#3S S4ES S 4 3QQ ;'' Q ;''Q'3_  NM  dR R R R "#S S4ES S 4 3QQ ;&& Q ;&&Q &3_  NM  dR R R R  "#S S4ES S 4 3QQ ;%% Q ;%%Q!%3_  NM  dR R !R R! "#S S4ES S 4 3QQ ;$$ Q ;$$Q"$3_  NM   dR R "R R" "#S S4ES S 4 3QQ ;## Q ;##Q##3_  NM   dR R #R R# "#S S4ES S 4 3QQ ;"" Q ;""Q$"3_  NM   dR R $R R$ "#S S4ES S 4 3QQ ;!! Q ;!!Q%!3_  NM   dR R %R R% "#S S4ES S 4 3QQ ; Q ; Q& 3_  NM   dR R &R R& "#S S4ES S 4 3QQ ; Q ;Q'3_  NM  dR R 'R R' "#S S4ES S 4 3QQ ; Q ;Q(3_  NM  3333>>dR R (R R( "#S S4ES S 4 3QQ ; Q ;Q)3_  NM  3f3f==dR R )R R) "#S S4ES S 4 3QQ ; Q ;Q*3_  NM  33<<dR R *R R* "#S S4ES S 4 3QQ ; Q ;Q+3_  NM  3333;;dR R +R R+ "#S S4ES S 4 3QQ ; Q ;Q,3_  NM  33::dR R ,R R, "#S S4ES S 4 3QQ ; Q ;Q-3_  NM  3f3f99dR R -R R- "#S S4ES S 4 3QQ ; Q ;Q.3_  NM  3f3f88dR R .R R. "#S S4ES S 4 3QQ ; Q ;Q/3_  NM  77dR R /R R/ "#S S4ES S 4 3QQ ; Q ;Q03_  NM  ffff66dR R 0R R0 "#S S4ES S 4 3QQ ; Q ;Q13_  NM  ff55dR R 1R R1 "# S S4ES S 4 3QQ ; Q ;Q23_  NM  44dR R 2R R2 "#S S4ES S 4 3QQ ; Q ;Q33_  NM  33dR R 3R R3 "#S S4ES S 4 3QQ ; Q ;Q43_  NM  22dR R 4R R4 "#3S S4ES S 4 3QQ ; Q ;Q53_  NM  3311dR R 5R R5 "#S S4ES S 4 3QQ ; Q ;Q63_  NM  3f3f00dR R 6R R6 "#S S4ES S 4 3QQ ; Q ;Q73_  NM  ̙̙//dR R 7R R7 "#S S4ES S 4 3QQ ; Q ;Q83_  NM  ̙̙..dR R 8R R8 "#S S4ES S 4 3QQ ; Q ; Q9 3_  NM  --dR R 9R R9 "#S S4ES S 4 3QQ ; Q ; Q: 3_  NM  ,,dR R :R R: "#S S4ES S 4 3QQ ; Q ; Q; 3_  NM  ++dR R ;R R; "#S S4ES S 4 3QQ ; Q ; Q< 3_  NM  **dR R <R R< "# S S4ES S 4 3QQ ; Q ; Q= 3_  NM  ))dR R =R R= "#S S4ES S 4 3QQ ; Q ;Q>3_  NM  ((dR R >R R> "#3S S4ES S 4 3QQ ; Q ;Q?3_  NM  ''dR R ?R R? "#S S4ES S 4 3QQ ; Q ;Q@3_  NM  &&dR R @R R@ "#S S4ES S 4 3QQ ; Q ;QA3_  NM  %%dR R AR RA "#S S4ES S 4 3QQ ; Q ;QB3_  NM  $$dR R BR RB "#S S4ES S 4 3QQ ; Q ;QC3_  NM  ##dR R CR RC "#S S4ES S 4 3QQ ; Q ;QD3_  NM  !!dR R DR RD "#S S4ES S 4D$% 0P3O&Q4$% MP3O&Q4FAl 3O3*&! 43*N &! 43d" 44Di˓$?l]\?%K?Y&? [3S S 4CEeee& >@m 7 Sheet5111ggD&  ->bDE  dMbP?_*+%"d,,??U} $ } }  } $ -    ~ $~       'Mu?DAdA-'M/[us?DA%'Mݑ^g?DA%'M?DAdA-'M?DA%'MP63E? DA%  NsE? DN? D V$   V%,$&l?DD?,(pd}?DD? V& V ! NBE DD  ! "~ S@ # ' (~ S @ " )~ S<@ " *~ S@ +6}TF*n%!"%&()+,~ !W @ ",~ %W@ &-~ (WL@ )/~ +WQ@ ,0 0 >@---7 Sheet2ggD& Sheet5ThisWorkbook  __SRP_4 D__SRP_5L  !"#$%&'()*+,-./0123456789:;<=>?@ABCEFGHIJKMNPQRSTUVWXYZ[\]^`abcdefghijklmnopqrstuvwxyz|}~'#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0'AxAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD28 #<`1@F<>j7Nм9Fx<>j7Nм9F`1@MEPSLSS6" <<<N0{00020819-0000-0000-C000-000000000046} @`8|kT ` X` UY%@ %0 %  "!@@\T'A$*\Rffff*1G49969d10$*\Rffff*1F49969d104" "0 8 " @ 2H   D`$h F Put the PValue menu item inA@o@@+ Delete the new menu command from the Tools menu.lvcheck languageTo] "!$$Wn Thanks to John Talyorol ( "%&Tools' =it's not English, try to get the word for Tools from the userdThe language of this installation of Excel does not appear to be EnglishUS. Please enter the word that Excel is using for Tools on the main menu across the top of the screen. For example, in Spanish, it is Herramientas.Get the word for TOOLS Herramientas "%*' khd`Tools' RkH &P Values... Worksheet Menu Bar "%,%.%.B@0o5Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Sub _AddinInstall() ' Put the PValue menu i@tem inqd*d M I End *D .Uni/ ' Dele3new1comma$from@Tools C.0'check languagDim myA As S@ng If Left(Application.Oper@ngSyBs., 1)W " The@7'Thanks to John Ta0lyorInternal(xlNonEnglishFuncAs) <> [?D1)6'it's not A, trygeCaword for 8Guse&E K*put`Box("8L ofXis@t}B2Excel doe$appearA#be(US. PleeAe )tha1BAusing.oBnB main{a0crosZ@top$e scre@en. F("&P ks8...@airU  1 Y #4  `` IW<   $ 0 @  44PrU @$`U$A`Y n'?#UserForm1 9?Sheet511OMainModule^Z__SRP_2 _a picture %sthis solution gives the user access to the cells and the chart, but chart will be lost PValue add-in is unavailable HB@J LB@NA:A$PB@Rk A@ro0 2!@(F! control appearance of Input page 2!@!V!X!Z!F Degrees of freedom not needed 2!@!\!^(` 2!@!V!X!b!FeR* Denominator degrees of freedom not needed 2!@!\!^!d(` 2!@!\!^!f(` 2!@!V!X!h!Fe null not needed 2!@!\!j(` 2!@!\!l(` SE not needed 2!@!\!n(` 2!@!\!p(` Tails not needed 2!@!\!r(`* Denominator degrees of freedom not needed 2!@!\!^!d(`e 2!@!\!^!f(`B@ 2!@!V!X!t!Felu null not neededsh 2!@!\!j(` 2!@!\!l(` SE not needed 2!@!\!n(`@ 2!@!\!p(` Tails not needed 2!@!\!r(`' Numerator degrees of freedom label fix DF numerator 2!@!\!^!v(x 2!@!V!X!z!Fe$ put away the P Value form A@r!F show the DW form |B@~F6 put in other distributions here with ElseIf statementk get user location info !'4 L!'6page! hide page1 so user can't go back 2!@!V(`to theop& check to make sure all info available it  normalon 2!@!V!X!Z!F 2!@!\!!F it kAn observed value was not entered. Please type a number in the observed value box or click Cancel to exit.A@|k 2!@!\!j!FA hypothesized (null) value was not entered. Please type a number in the hypothesized (null) value box or click Cancel to exit.A@pT|@k8 2!@!\!n!F8_An SE value was not entered. Please L'1xME(SPSSS0{A40815F3-B386-4732-A71B-DE0D4C3471EE}{6D52FD8B-0A2F-4479-9862-5266193C43A6}((he Ph6 8p : < >0 Tp44   `X0%` %j4j6p0p000`'A  " ( "0 8H "P Xh "p "x Z z     " (8 $X 0( H`x   08Xx   (@ .X(     <( h p   (  " , 0@`v(jX ` h p x  v 0 8 @ `    j    x 8 @ H P `  v    ( xH      v  `h p(08  @ P p   ( ( @` 2 *@ 4p * 4 (@ X p (>@ 4$$$ 8@ `p  (  V  x2 * 40 *8 4h  V p> 4$$0$X$   4$8$`   4$$8$`  &   6$ 4H ,   (   8X h "p *x , "  (8] ] 0 A@roPp A@ro0 A@ro provide picture if desired 2!@!B!D!FTinsane Excel 2007 workaround -- it would not show the chart when pasted as type a number in the SE value box or click Cancel to exit.A@ЌS|kk t 2!@!V!X!b!FT 2!@!\!!FЌSkAn observed value was not entered. Please type a number in the observed value box or click Cancel to exit.A@&|k 2!@!\!j!FA hypothesized (null) value was not entered. Please type a number in the hypothesized (null) value box or click Cancel to exit.A@T|k 2!@!\!n!F_An SE value was not entered. Please type a number in the SE value box or click Cancel to exit.A@|hk` 2!@!\!^!!FnA degrees of dreedom value was not entered. Please type a number in the DF value box or click Cancel to exit.A@|kk chi 2!@!V!X!h!F 2!@!\!!FkAn observed value was not entered. Please type a number in the observed value box or click Cancel to exit.A@R|k 2!@!\!^!!FnA degrees of freedom value was not entered. Please type a number in the DF value box or click Cancel to exit.A@|8k0k( F 2!@!V!X!t!F 2!@!\!!FkAn observed value was not entered. Please type a number in the observed value box or click Cancel to exit.A@|`kX 2!@!\!^!!FA degrees of freedom for the numerator value was not entered. Please type a number in the DF numerator value box or click Cancel to exit.A@|k 2!@!\!^!d!FA degrees of freedom for the denominator value was not entered. Please type a number in the DF denominator value box or click Cancel to exit.A@|kk "( get the distribution normal 2!@!V!X!Z!F B@normal$HB@" put the appropriate formulas down 2!@!\!r!!Fb6$(F P value formula two quotes "" = " in textz=if(IF(E3<0,NORMDIST(E3,0,1,1),(1-NORMDIST(E3,0,1,1)))<.0001,"< 0.01%",IF(E3<0,NORMDIST(E3,0,1,1),(1-NORMDIST(E3,0,1,1))))e4$( Chart formulas 2!@!\!!F 2!@!\!j!F Assumes alt. hypo. > 0c6$(F=IF(RC[-3]>R2C9,RC[-2],0)L18:L71$(dP Assumes alt. hypo. < 0c6$(F=IF(RC[-3]ABS(R2C9),RC[-2],0)L18:L71$(kx - put down the values on the appropriate sheet 2!@!\!!Fb3$(F 2!@!\!j!Fb4$(F 2!@!\!n!Fb5$(F t 2!@!V!X!b!Fe B@t$HB@" put the appropriate formulas down 2!@!\!r!!Fb6$(F P value formula two quotes "" = " in textA=IF(TDIST(ABS(E3),B7,B6)<0.0001, "< 0.01%", TDIST(ABS(E3),B7,B6))e4$( Chart formulas 2!@!\!!F 2!@!\!j!F Assumes alt. hypo. > 0c6$(F=IF(RC[-3]>R2C9,RC[-2],0)L18:L71$(dAssumes alt. hypo. < 0c6$(F=IF(RC[-3]ABS(R2C9),RC[-2],0)L18:L71$(k0- put down the values on the appropriate sheet 2!@!\!!Fb3$(F 2!@!\!j!Fb4$(F 2!@!\!n!Fb5$(F 2!@!\!!Fb7$(F chi 2!@!V!X!h!Fe B@chi$HB@- put down the values on the appropriate sheet 2!@!\!!Fb3$(F 2!@!\!!Fb4$(F F 2!@!V!X!t!Fe B@F$HB@- put down the values on the appropriate sheet 2!@!\!!Fb3$(F 2!@!\!!Fb4$(F 2!@!\!d!Fb5$(FPQ put in other distributions herekH calculate the sheet LB@/ read the results into the Results page objectse3$!F 2!@!B!(Fe4$!F0.00%$ 2!@!B!(F% copy the picture in case it's neededA1:E21$B@ 4$B@ 6$HB@ "(! hide page2 so user can't go back 2!@!\(` go to the Results page 2!@(Fo$ makes it work if click on Input tab 2!@!FGA@Tj& makes it work if click on Results tab 2!@!FGA@jooAttribute VB_Name = "UserForm1" " Bas0{A40815F3-B386-4732-A71B-DE0D4C3471EE}{6D52FD8B-0A2F-4479-9862-5266193C43A6} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizDPu@blic uBook As S!ng  Shxeet 59 Sub btncancel_C&k() Unl oad MdEnd inputresultsfinish ' provide picture if desid HIf .MiPage1.p@3.D cbx.Valuyp Th en 'insane Ex@H 2007 workarou@F -- ituld not show the char pastuas aE(this solution g ss accesoellgF, ill be lost P2add-in unapvailCBs.AddActB.P+C&mns("A:A").AutoFit IfxnexɇE~i1E/19control appearS` of IL@)g@RY:1.frmdLis*.nal\6< Degr(ees fdorm9ne@{$$vH2.Fr2.VitsiʄE_Itn nator7[?1-p^&df2txt^xlbl =/4chinu[k2hypovy2.Labelð9"' SE?C2.se?432' TysS21 DeJ`geJO%XO%Qh4llt\O%f/%7] /% wb2./% Of/%sa/%Pv/%Z_V/%n/%r/% Numer_JP$pU@hel fix? ! 6.CapBrPDF$0oVK~9!dw!! aHwayrwP ifPd$ 6DW gDW.S@ut xo{[!h_s he@wiHth stmenvvqgҁlocainfo 1= |W0b .}o~hS1  P't go back~ecE$ nA'eck to make sa_ 'OrmalAuǨz?obsee `""XMsgBox "An er wpkPd. PlBetypenumber!Bb0or cq CBexit./'EU Li QOQP siz(1S) _ `_ Z ulR$m1swR n| aFc  ' =og?K#_$ +dw++bAG/l to exi@t." EX Sub End If If UserForm1.MultiPage1.p2.hypovaluetxt.V = "" ThenMsgBox "A Vthesized (null) ; was not entered. Please type a number in ?Gbhor click@ Cance>sln SEdP\Frame2.dfdegree@s of ddom3DF 3 ' chi۝1.frmdistribution. btnFTruFeĠۯobsn erv1 ?|4|f>6q>9>F==f=`0=b=:=V=w箨{=fAeratZ? ]Z _KF2? xdenominΠO_ P App`aBSBc qnUpdngFalse ' getBinalggThQThisWorkbook.ActivatSheetsd("3")3' pu apprPopri @'mul~dowāO.Ʌ1.onet8ail]Q Range("b6 U1' Pi4two quotoЋrextGe4P a=if(IF(E3<0,NORMDIST,0,1,1),(1-_))<.0001,""< 0.@01%"",O3cO)))' Chartw PJP-x> 01c"Assum alt.. X L18:L71@RC[-3]>R2C9,2],0E35 !%=<E>{ 4 *2& ,q' ,A,L(",,2*+,2*-`.--p12O-O-AABS(")>")"JQIBVB1wLsOE3P*GvҾ6[4_2DY5oo2.8eN!*BBu/tdhEddt e#cc/ Mc= $$c66c 6 DTc1*E3),B7,B6)<0aa@0Ia 6/`/`_Yobsvalue txt.V - UserForm1.MultiPage1.p@2.hypo > 0 Then  Range@("c6")= "Assumes alt. . z"9L180:L71>ula @=IF(RC[-3]>R2C9, 2],0B)CElse3< 0E+{)N{EHW' put dow@:DheFs oCappropriate sheeB`3Aþ=پ3_ER`OЋ5##sKG7dfF ' chi$ aTIf 1.frmdistribution.btnF|TrueThisWorkbook.Activ@0S0s hi k99~e_9f(F(o(f?(9(F'{aba''2>.'Dži`df:2X Xother IUs  å^alcEbQeS.CAdread Ares@stoR obje ctVG3.st\atf`U$e/ J p= a i@s visi7 Command@Bars("hs,heuR ").Vo-check languag6Ymy0\Sng If Left(Appation.OperngSys, 1),"W" Theg'Thanks to John Talyo% # rn)al(xlNonEnglishFunc4s) <> D> )@B+'it's not , try|ANword forPfrom @{[ K*put`Box("8L ofbinstallB2Exc elB$appe$arA#be(US. Pse e@w)tha1Busing.one mÁ`acrosZt op$@cree n. FXFH8  8:d]3t6H8%;H d"%t$ t Hc]@t5H C\ RH ( xME<(L6 LLLLLL<P @`  `k33`zsire`x !D` \8 X% (` 8 h` = ` Dh@(%X0,"(@t @Xd "@` @X @(H Acti@@8 estD@( estD@p alDx@ @ ^@ Init@ Resi@ yClo@ @h B@@@ ageIXtch @ ageI@@ench @ ageI@ @ zili@ @ gari@ msoL@| B@@(l ageI@\ x@ guageITp`msoL%X& B@@D ageI@4 B@@$ ageI@ h'A$*\Rffff*1F49969d10*\R4*#50*\R1*#2ac*\R1*#e8*\R4*#8c*\R4*#4d*\R4*#4e*\R1*#d7*\R0*#f*\R1*#6c*\R4*#4f*\R4*#50*\R4*#30*\R0*#1*\R0*#14G" & 0@ "H Phpx *"2 K ;8P D`$R ,S 20<jh J8 <  2 (8>v@       0  "   "   (@ " H P`p so user doesn't get Save alert (o8@ define variables]]'$ Make sure the Tools menu is visiblel fWorksheet Menu Bar$,(`nd check languageol] "!$$W?@Thanks to John Talyor ( "%&Tools' =it's not English, try to get the word for Tools from the userWJOdPThe language of this installation of Excel does not appear to be EnglishUS. Please enter the word that Excel is using for Tools on the main menu across the top of the screen. For example, in Spanish, it is Herramientas.Get the word for TOOLS Herramientas "%*' t k dTools' k Worksheet Menu Bar$,%.(` , Check to see if there is a PValue menu itemu  Worksheet Menu Bar$,%.!.!`.  Worksheet Menu Bar$,%.%.!x &P Values...  Worksheet Menu Bar$,%.%.!x P Values...CMeans the PValue menu item is already there, make PValueIsHere True(%'%'%'%'%: %:d % t$ t H`1\t5H/ C\Sl\F%`:d%t$ dt H`  ,  )t`jzl\F%`:d%t$ dt H`  , WHA8U)t`6H8cz@l\F%`:d%t$ dt H`  , HA8:]/(z@l\F%:%$ d H  , A|:]/l\)t`6H8|px zd kxv%l\F%`:d%t$ dt H`  , W8(X)t`68( lXT T  T cT H  ( '$'4:NDD@:dH8(:|l\Fl:\^i6H8(|l\D4$qAh$4TX\XXt`H8(|l\D4$0  0 (  0 h  WrU $`$`$`$`$!`n'q#__SRP_3{Sheet51 Sheet2DWFormvxME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0'AxAttribute VB_Name = "Sheet51" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2'#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0'AxAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU~| DWPVALUEs __SRP_6__SRP_7'Sheet5111 X >p 8 @ :( >h  8  < :P :   > *0 ` Dh  > B X >x 8 8 4( ` :p :  : >@  : D < X >h B < *0 ` p  8    ( @ (H >p     $ 8 X x @ "   J 2h 8 " " $ 20  h x < ,Do not include labels when selecting ranges.'1TahomaSelXRangeidu,XresultsCheckBox,0CommandButton1x1S(2xLabel1{, 10SelResRangeo,8CommandButton2x( 2Label2 , <CommandButton3x0 tInterceptChe_pxME(06 < < @`  `ll)ocee%) (in%`st``: t`on, `ue f` U`8 I`e us`ssio`, x2` umXV`  ``e PpeLeHe8`԰e eнeȽe e`eXe  0 X &(eee `*  0( ed.more on t }xMEPSPSSS<<<<0{D979AE0C-3165-4A60-B352-598DA7D5F72E}{80DB3197-E36C-41F4-A336-5A3516E1DE33} %8%   0(%X0 %**8`@(@`0'A4  " F 4` $   " " :8 x :  (  0 H X "` &h :   (   0 @] `] @@ The user has inputted the cell ranges via the DWForm dialog box. Pass this information to the MatrixWork macrosire  A@D Close the Durbin-Watson form |A@r% 2A@rgo Get the user's X data inputn give3 Hide DWForm so user can see the cells on the sheetll be |B@e add-3 Get the range of cells as a Range object -- that'sA:A what the Type:=8 isA@ruInput the range of cells that contain the X data either by selecting them with the mouse or typing in the cell range. $ $1You may move this dialog box if it is in the way.l "%*.! Show the user the selected range ! |!(F Sub CommandButton1_C+k() ' The user has XinpTt c ell r:s 0via dialog boBx!Pass@if|ationH toB MaxWork mac0ro H5:=9, 4DE0' Cl@]Durbin-WatsA Unload *U91 EndFYUJ2IJGetAK's X d@LC%HideD soCUcan seeTs F@Wsheet =).E^ o,f C gaC~ object --!at's`wha'Type:=h8 iS,Ɏ=0 App@~g.IzBox( _  promppt:="BB, !tAcontaiw1@ei`Cr by@l`ingm w mo& or typ a ." & Chr(13)!*"You Gy 8mov(LO ipf it0 way.",%!\a$Show8|se]B1R.0Valu(.Addres+D78isi#DW~ O !>`QP3P`idu@ wH?Qll Ts a combp >ncluudge, et @ Imhthe dist BXa, v 4@` Dt/ Astics) `J1 A`Lode `Nted PXowin77 progr@ R3 a appl.stx`X`Zl sy jidia 2 lP, no finds l8X `p`v153 d ` )R (6  i app`z `|lgor`~le f`es e`et (`.sta`An S`pany`ncles`# j`ED S` A  rto 1 W   ng P P    Fmia val  0 `ri.u`: 01 f ` iN h CoiX e, Iih il: `not `361-`(765`` fin`y th` f`hing` D`er 1`DE -`OW T`UE C`, R`y ex`` up ` the` nec`ick `an i H !@atson an0 P `oces  ` ??) inf%@ and@ cs E`DW A Bhe obsePp Dkes formatio `J mul`L1 i `` )nval%`ne fu  P-vA@ ` `  Ge@ ` `""`se t` 56 o ` `nayed hx consplaying`  `  ` `Zrksh  ` `v @   % h'A*\R1*#1c8$*\Rffff*1H49969e46T  B *` @ @ @ P < 8 <P ," D (0 &8` p   ( <8@*P  0 < ( 8Xx & & ( 8 HPp       J(x & , 0 @ P`  >h   (  <@ 0  2  X h x  >    (@Hh     d  ^@ 4> @Xp 2    >8 *X    @X p" "      0 HX`  ( 0 P h        8  P  h          !  ! 8!@!X!p! !  !!! ,!4! ("&H" p" " """ """" # " #H#P# D`# P# L# LH$ $$$ & L& &'  ' 8' P' h'  @x' 2' ,'8 (>X(j(8) *@) 8p)  8)))) ") * *P* p* * .* * * **" +  H+ HX+  + P+8, 8, >@, L, ,, --0- H- @X- 2- ,-8.>8.jx.8. * / 8P/// N/ @/(000H0P0h000000 01 1 1 @1 .X1<1 1&1 22JH2 2&2 2  3333 3 3 :4B @4 0H4,x44444  4555 5 (5 "05X5`5x5 :5 85 26 @6X6h6666 6 6 6 F7 P7 p77  77 777 78 8@8H8 "`8 8 "8 8 (8 8 9  9 09 (H9 p9 9  9 9 9 9 :  : @: X: p: : : D: $; (; 8; H;`; p;  ; ;; 4; ;<(<@< X< `<(x< < <2< = = =@=X=p= = = == ===>>  >0> H> h> x>>>>>&>> 0? 0? H? P? p? ? ?? ? 8?@6 @X@`@h@@ @ @ @ @A (A8A HA hAxAAAAA A A A A A B0B PB pB B B B B B B C $C 4@C xC CC.C.C D 0D @DXDpD "D D ,D DEE(E8E PE pE xE EEEE EE F (F HF  `F pFF 0F FF FB G 2GJ@GG *G FG (H 8H FXH HHHHHH II I I 48IpIIII I ,I 4J 8JXJ `JpJxJJJJJ  J J J @J (K8KPKXK N`K "KKKK  L   L0L@LPL"XLL LLL LLLLLL LLMM M0M8M@M`MxMMM M :M ,N N8N JN RN L0O *O DOOP $P8P PP *`P P P P P P P (Q 0QPQ`Q xQ LQ"Q R  R 8RHRXR"pR RR R R R R S S (S 8S XS hSxS SSSS S 0S $S ~T JT LT H0U HxU (U $U (V N8V V <V FV *(W :XW  W WW :X PX (Y :HYYY Y Y B YY &YY Z Z(Z0ZPZhZ Z ZZZZZZ [  [ 8[ P[ `[h[ [ [ [ [[[[[\  \ 8\ X\ h\  x\\\\\ \  \ ]](]@] P]  `] x] ] B ]]]]]]  ] ]  ^ ^,@^p^ ^ ^^ ^ ^ ^ ,_ 40_ h_ "_ ____ *_"_2` .H`Bx`P` BaXa`a 8haa a .a aDa@b Hb `bxbb b b Tb"ccc c8cPchcpc(xc cc "ccc hexe ee e "eeee e ef DOCUMENTATION; This Visual Basic macro does a Durbin-Watson analysis of a box# first-order autoregressive processD*L9 It proceeds by forming the X and MAM matrices (including9 the e'Ae/e'e (DW stat) quadratic form), then it accesses: the EigenValue function, and finally the PValue function. User Inpute shee8 It is assumed that the user has a run a regression of yge1 on x1, x2, . . . xK (called NumXVar in the code): with N observations (called NObs in the code) and has the4 residuals (by using, for example, LINEST to get thee cell8 predicted values and then calculating residual = actualox Y - Predicted Y).1 It is assumed that the data are in columns on an Excel worksheet.5 The user clicks on the Durbin-Watson Analysis buttonB@~4 and an informational message is displayed, followedput3 by a dialog box where the X data and residuals areP entered. Sources:8 See Judge, et al. 2nd ed. p. 384-401 for more on matrix$ manipulation and A, e'Ae, MAM forms> The code itself is a combination of several sources including Judge, et. al. 2nd ed.7 J. P. Imhoff, "Computing the distribution of quadratic< forms in normal variables," Biometrika, vol. 48 No. 3 and 4 (1961), pp. 419-4268 http://lib.stat.cmu.edu/apstat/ AS (applied statistics)2 library with its on-line collection of algorithms1 A large part of the code itself has been adapted. from the following three Fortran 77 programs: 1)3 algorithm as 60.1 appl.statist. (1973) vol.22 no.24 reduces real symmetric matrix to tridiagonal form 2)4 algorithm as 60.2 appl.statist. (1973) vol.22, no.27 finds latent roots and vectors of tridiagonal matrix 3)3 algorithm AS 153 (AS R52), VOL. 33, 363-366, 1984.> ORIGINALLY FROM STATLIB. REVISED 5/3/1996 BY CLINT CUMMINS!j6 finds the p-value of quadratic form appropriate forred. DW stat8 The algorithms are downloadable from a variety of sites e< on the Internet (including http://lib.stat.cmu.edu/apstat/)_An S5 and the accompanying explanatory articles are in theue b# journal titled: APPLIED STATISTICS AUTHOR Humberto Barreto1 Written during 1998/99 Visiting Professor at UCR Profesor Visitanteease t Facultad de Economia val Universidad de Costa Rica San Jose, CR" email: hbarreto@cariari.ucr.ac.cr7 phone: 011-506-283-5978 (when calling internationally)hy Dept.of Economics Wabash College Crawfordsville, IN 47933 E -mail: barretoh@wabash.edunot  phone: (765) 361-6315er i FAX: (765) 361-6277k Canc9 This work was financially supported by the Wabash Center for Theology and Teaching. not e DATE a n October 10, 1998COLD CODE -- NO LONGER NEEDED NOW THAT MERGED WITH PVALUE CALCULATOR2!@, Run the DW Analysis by executing this macro2 It will bring up a form which enables the user to input necessary informationclick  Show an informational message!@The Durbin-Watson analysis in this macro assumes a first-order autoregressive process. Both the DW d statistic and its P-value are reported. $ $MFor more information, please see Barreto and Howland, Econometrics Explained.DW Analysis Assumptions $'e obse  ox o |B@~ncel tkpoh5 This macro takes user inputted information on X datas of6 and residuals and does various matrix multiplicationspe a1 including getting MAM matrix. It then calls the6 EigenValue function to get MAM's eigenvalues and then& PValue function to get the DW P-value@A@]0H`x @]]]]  Get number of observations, NObs@ !!' Max NObs message  @The transpose of the X matrix exceeds 256 columns (because there are more than 256 observations) and, thus, certain matrix results (such as X Transpose) cannot be displayed. The analysis will continue without displaying the matrix results. Too Many Obs to Display MatrixA@k@"Get number of X variables, NumXVar !P!'6 Insert new worksheet where matrices will be worked on]X !J. L!Results H! '  ()Create and fill X and XTranspose matrices]p]5Put in the column of 1s if there is an intercept term |! !F  'N    (   + +     $!F  +   $!F  +  d   P  x      $!F  +  $!F  +  k DPut down a description of the X' matrix if user wants it and it fits |!"!F  "( X' Matrix $H,$      $   $H,$$ @00  "(k 7 Keep track of last row used for placing other matrices  'd8  'k X'X work Get X'X]  &@S$$$('&5Put down a description of the matrix if user wants it |!"!F "( X'X Matrix   $H%$(F Put down X'X      $&    $H,$   "(kp7 Keep track of last row used for placing other matrices    'L (X'X)-1 work :R Get (X'X)-1] & "!,%.'*]  0P  @@    $*  +0  ]XTransposeXInverseD = VariantToDouble(XTransposeXInverse) 'This works also with () in Variant WPut down a description of the matrix if user wants it with "-1" formatted as superscipt |!"!F "((X'X)-1 Matrix   $H%$(F46   $H%$%2!8(: Put down X'X0      $*    $H,$ $  "(Dk7 Keep track of last row used for placing other matrices    '$ Form the M matrix -- I - X(X'X)-1X'  Get X(X'X)-1l ]X$$0$('<Get X(X'X)-1X'` ] < $('>t  Get I - X(X'X)-1X']  @          $>  +@dP  $>  +@8k    DW work Find DW d statistic@ Numerator is e'Ae Find A](  B     the diagonal       +B d  +Bk the -1 off the diagonal   eH   +Bh" the zeroesdh  +BkH ee ee Find e'A] D   $'F   F  $B'H $D H +D   Find e'Ae]   $ $D'H J H 'J  Denominator is e'e]   $'H L H 'L  DW d statistic] J L'N%Put down a description of the DW statDW d statistic   $H%$(F Put down DW d statistic N   $H%$(F Find MAM Form MAstarttime = Timer]($@$B$('P Form MAM]`$P$@$('R V'TMsgBox endtime - starttime Get the DF for distribution]   'X>There is an issue to handle when DF is large. The FarebrotherJalgorithm may fail, then you use the normal approx to compute the P value.FWe'll give the user a chance to just use the normal approx to save theFtime required to attempt to get the exact DW P Value using Farebrother Xd ] You have  and  X degrees of freedom. In this case, the algorithm used to compute the exact DW P value will take some time to compute and it may fail. It is recommended that you use the normal approximation instead. Do you wish to use the normal approximation? (Click No to attempt to compute the exact DW P Value. If it fails, the normal approximation will automatically be used. Please be patient.) \NObs High, Use Normal Approx?$'Z ZEWe need to compute the mean and variance for the normal approximation Form MASquared$P$P$('    $P  '  $  ' :so, we have the mean and variance then we can use Normdist+to compute the P Value for the DWStat value&Use the normal sheet of this workbook! Nb3normal PValue.xla$%H%(F  Xb4normal PValue.xla$%H%(F X    X $^b5normal PValue.xla$%H%(Fb6normal PValue.xla$%H%(Fnormal PValue.xla$%HB@e4normal PValue.xla$%H%!F' 1skip the Eigenvalue and PValue calculations below`Fkk Get the eigenvalues of MAM$ See below for more on this function RR $d'btestingFor I = 1 To NObs( Cells(I, 50).Value = myEigenValue(I)Next Get the DW PValue$ See below for more on this function NN XX bh$f'  BThe P Value algorithm failed. The user has already been notified. ZJthe computation has already been done -- just read it off the Normal sheete4normal PValue.xla$%H%!F' d7do the computation to get the P Value via normal approxEWe need to compute the mean and variance for the normal approximation Form MASquared$P$P$('    $P  '  $  ' :so, we have the mean and variance then we can use Normdist+to compute the P Value for the DWStat value&Use the normal sheet of this workbook! Nb3normal PValue.xla$%H%(F  Xb4normal PValue.xla$%H%(F X    X $^b5normal PValue.xla$%H%(Fb6normal PValue.xla$%H%(Fnormal PValue.xla$%HB@e4normal PValue.xla$%H%!F' kpkh`Dskipped the eignevalue and P Value calculations because user said to9Compute the r(Res,LagRes) and report as the estimated rho]  j]   lp n  n$ n+j n $ n+l@]x j l "!,%r'pFormat results N$t'N]  Scientific$'v p$t'p(Put down a description of the DW P-valueDW d statistic P-value   $H%$(F Put down DW d statistic    $H%$(F+Put down a description of the estimated rho$Estimated rho (using r(Res, LagRes))   $H%$(F Put down estimated rho p   $H%$(FThe DW statistic is N and the DW P Value is  vW. Estimated rho (computed via the correlation of the residuals and lagged residuals is  p.  DW ResultsA@ "(x |!"!F $HB@0k  "(xo 4 Get the eigenvalues of a real symmetric matrix, MAM) Get the machine-dependent constants down]H`x='|" '~+=' | ~'z]  8 P ' 'n]h R']  D is the eigenvalue vector]  (  H 3 NOTE: This code is essentially the same as that in1 AS algorithms documented above. Please see these, algorithms for more detailed documentation.   n ' n n $''  Gj    n $ ' F   '@ if g is too small for orthogonality to be guaranteed, the transformation Is skipped  ~ Gj n+ n+PF  ' $^' G 'j  n+   '  n n +'   n $   n+' form element of a * u     $ n $ '   Gj  '      $ n $ '  form element of pF   +   n$ '  form k   ' form reduced a   n $' $   '  +    $ $  n $  + MsgBox "z(J,K) is " & z(J, K)  90 CONTINUE  n+F n 'n ++. accumulation of transformation matrices n  n ' n$ Gj  '    n $  $ '     $   n$  +  F n n$ n+ n n+ Gj   n +  n+  n''?'@'+='  ' n  n$ n + n  + ' '  '  $ $ '   G 'j* look for small sub-diagonal element    '@ @$ Gj  @ Gj  Gzj  ' form shift1Mar-2001 fix from BootstrapR2.xls Eigenvalue code]P  $ $   $']h ?    $^' G'j   '   G   'j $ $  ' n   n$  n+ n  ' ql transformation @$' ' ' @ ' @'n    n' n 'n  n$'  '  n$Gj  n$'    $^'  n$  +  '  'h=F n$ '    $^'    +  '  '  n$   '      n$  + form vector    $'   n$    +   n$    n+     +   + $  GjF $ + % order latent roots and vectors n  n' n$' n '    $ Gj ' $'F   nGj n$ +  n+ MsgBox D(I)    n$'  $  n+   +  MsgBox D(I)F n* Assigns the eigenvalues to the D() vector$'di9 Get the P-value ] 8 P h     ]   ( @ X p      ] #N is NOT the number of observations@N is the number summations that are used to compute the integral!See Farebrother (1980) p. 224-225N=200 is taken to be exact@N=24 is the highest value in the table, but accuracy improves as N gets bigger''?'?'@' For DW C=0'] Xh -Fill A eigenvalue vector with DW stat as A(0) N+$' n X n$h n+ n% SET NU = INDEX OF 1ST A(I) >= X.. ALLOW FOR THE A'S BEING IN REVERSE ORDER.$ X$  X'''nd5'' X'nk`5   n  $  Gj 9 IF ALL A'S ARE -VE AND C >= 0, THEN PROBABILITY = 1.    'f Nov 02 Fixz4k4G SIMILARLY IF ALL THE A'S ARE +VE AND C <= 0, THEN PROBABILITY = 0.F     'f Nov 02 Fixz4k4 G  'j X  '     'd3 $ X$ 'kx3  ' ' '''''d 3'  ' X ' X ' X ' X'k2  $ '   ' '  '    ' FIRST INTEGRALS4In the original Fortran code, the VB translation was& For L1 = h - h / 2 * 2 To 0 Step -1HThis was puzzling since there doesn't seem to be any reason for the loopDThe key is if h is even or odd. The code is looking for the elementKin the list of sorted eigenvalues for which the DWStat value is higher thanEIf the element is even, all is well and you go through the loop once.#If it is odd, you go through twice.=This is incorporated in the code by DIMming H1 as an Integer.]p '         $'$ FIX BY CLINT CUMMINS 5/3/96 PROD = A(J2) $'    '    ' ' n  "MsgBox "I is " & I & "N2 is " & N2   n $ '   '  $'  FMsgBox "Num is " & NUM & "C is " & C & "Y is " & Y & "A(K) is " & A(K)    $ 'If K = 750 Then MsgBox "hi"End If    X    $ '   $^ ' n '    '   '   '   '  SECOND INTEGRAL.   'd,  'kh,'' )When DF is large this algorithm may fail:The Imtest Package says this:wThe p value is computed using a Fortran version of the Applied Statistics Algorithm AS 153 by Farebrother (1980, 1984).CThis algorithm is called "pan" or "gradsol". For large sample sizesFthe algorithm might fail tocompute the p value; in that case a warningAis printed and an approximate p value will be given; this p valueBis computed using a normal approximation with mean and variance of!the Durbin-Watson test statistic.We will adopt this procedure.!The algorithm "fails" if sum > 1.HYou can see what's going if you put a break in the line that says Break:and run the code.5View the Locals Window and watch what happens to Prod@When DF is high, the cumulation of many terms makes Prod explode#This does not happen when DF is low3Nov 02: I do not know what controls Prod to explode  Report warning to userThe Durbin-Watson P Value calculation cannot be completed. This occurs when n is high. A normal approximation for the P Value will be computed and reported. Can't Compute Exact DW P ValueA@4Source is original Durbin Watson article (I), p. 420JMean is trace MA which is back in the MatrixMult macro so we'll go back up there to compute it.3I'll make the sum=2 and then check it in MatrixMult'kh& 'fiX& ]   Get number of observations, NObs !!' Numerator is e'Ae Find A]8  B     the diagonal       +Bd %  +Bk% the -1 off the diagonal   e  +B the zeroesd$  +Bkx$   Find e'A] D   $'F   F  $B'H $D H +D   Find e'Ae]   $ $D'H J H 'J  Denominator is e'e]   $'H L H 'L  DW d statistic J L'ip" ]]]]]( !! X !! x n !! n $!F n+ n$!F n$  n+  n$ '  n n !!  n$!F '  n  'i!% ***********************************8. This macro adds a menu item so the DW P Value macro can be run define variables]]'$ Make sure the Tools menu is visibleWorksheet Menu Bar$,(`ToolsWorksheet Menu Bar$,%.(`( Check to see if there is a DW menu item ToolsWorksheet Menu Bar$,%.!.! ToolsWorksheet Menu Bar$,%.%.!xDW Analysis...;Means the DW menu item is already there, make DWIsHere True'd2Means the DW menu item is not there, so do nothingkX ( Add the DW menu item if it is not there  lToolsWorksheet Menu Bar$,%.!.%J.  ShowDWForm9DW Analysis...9xqkxoptest DWPValue macroNeigenvalues are in a hidden sheet in LutenizingAnswers.xls in AutoCorr chapter]0]H0b n0 n2$$ n+b]Zwg?N.X bh$f'  A@oH] You have  and  XA degrees of freedom. In this case, the algorithm used to compute the exact DW P value will take some time to compute and it may fail. It is recommended that you use the normal approximation instead. Do you wish to use the normal approximation? (Click No to attempt to compute the exact DW P Value. Please be patient. \NObs High, Use Normal Approx?$'Z ZA@hiA@ho`]P@'   Scientific$'v vA@oAttribute VB_Name = "DWPVALUE" ' DOCUMENTATION@This Visual Basic macro does a Durbin-Watson analys`of azfirst-order autoregressive proc %It eds by forming the XSd MAMv1 (includ!;$e'Ae/e'e (DW stat) quadrat M),Ln itH ac:esEigenValue functiHon,9fifl*yBP . UslInputc}assuHmedatuIharu 7yx1, x2, .xK (call$NumXVar in'code)with N( ob/vuonsObs iBLaidu \usS,A^ example, LINEST to ge2 predict@%vL4"nA:en +cul!@nact@Y - PY)AQ Ldat a are0colum6HanExcel worksheetTYclicks AATtoa/an.fPmags displayedGlloXwed Laalog box whe+AX .X@2A ent d,ASour:ee Judg]Zal. 2ed. p. 384-401Bgm7ma@xmanip^<3A, ,B́5A HG`self aU comx" Qsever@ s/hm&. HA J. P. Imhoff, "Com@b@JV`(`.`ka fs!VOLA3, 363-366, 1984b ORIGINALLY @FROM SLIB. REVISED 5/3/1996 BY$ C T MINSC%a8p-A:k! ropUXЁmDd`ownlo @\ E?a^ety s\it yaInG <[&``ݑqany!Kexna`y.06B ce j@?titpg: APPLIISTICqAUTHOR@Humber bBarreto0aW1t.dur!8/99aitProf0Vo@t UC3 itaFa@etad de E@conomiUBn0rsidCBoP< RicS3Jose, qemail: $hbs @caFri.ucr.ac.crAphone: 011-506-283-59p78 (]np@g߰JP\Lyy`Dept.TT cQW WabashD C=egeaCraw"dsviD, IN 47933E - h@w"KA$ (765)/1 -6315FAX: h277`gr wB-anci suppF0Pl# ju p,opnP#`%Tpeach 6DhATEqO< d10898"O@LD CODp - NO LONGER NEED%NOW THAT MERGWITH Ө CALCULAT&R 5W|yecu"%tq`wd b'up mpzich enfWB+@k nec`iG Sub ShowDWYm(r6h#܃ my0RespMs gBox(mpt:="BB9ozö#  . BopdmBsmP$Mre ." & Chr(1c" R , ase sj?Howl ],:{cs EG td.", TWEA!psButЙs:= vbOKC*elIf )o1.EP+If q@B)c0takb iy 3q%khGrAous3x@ multic"!@6+6x`i*3Fsq)Ӹ's e|w( P#-MErW(ByP SelXRanAs , ,#pCal ZatqMDim0>ǠLong,tI 5JIlastRowd'3myp_owG4ciendr'k 1 my12ih`ceMAaDou;`|jS MAY()G}n2t, N=g.@s.Count,Max3CT P2R> 2561Ms]gBox "The transpose of tX matrix exceeds 256 columns (b0ecauRre$ amothanPobservations) and,us, certainresultPsuch as X T) cannot be display ed. analysis willntinue thoutq.ingl.", vbInf,orP,oo Many Obs to D7 " End If 'Get numberX variablenNum@XVar  = SelXRa`nge.Cunt$& In(ew workshe/whe9cered on Dim sPsAs "S S NeDwS$= W*s@.Add = Active .Name & "RCe"s,p + 16DC = !4CreatLfgX XTBc@50X() .DouP }^Pw@â`1xs iLintercept m If HDWF{.IECheck.Vazl@=V pE?ReaX(1 To N@, C)J 4E  @) /I X(@ ), J 2+E e ` JfW - 1)&'<JNextaJ IJElse. . .'7C 'tJ't'/.&'gdown a despcrip!hiX'i`r wa2n@itxfitscidiAqb <=£kaA pplic.ScreenUpd= Fa=aC(Ȗ).CelPls(1a"`M Aa[:(ab:7"b]`KEl6A E]#TrudaҀ Keepack:las@t row 9d co >r=X>|RowUsPg=_w8'R2r' X'XRm!/%/%V5S'D ToC ) 'Thȡ ko Ъ(xyxFCxwith "-1"\@t Ysupc|3 HHHx0Cs>>>He0yCharacs(Start:=6, Length:=2).Font.Sc1gTO ))r$1O O B Oo#/+/+)+/d/QUP'ρtܶ row used for placing other matrices la@stRowU= 4+ 2 + NumXVar1 ' Form Mx -- I - X(X'X)-(1X'P ' HGet Dim XXTransposeXInverse() As Doub le($ = LMMult(X(), ED())| {I>$CH iPKMM ?ReM(1 To NObs, * intIF HJSAIf@J T8henM(,A J)|=G Elsy 04nd IfNext. IDW worki@@d statisticeratis e'A70 ACkAMxUsFktbIS'diagonal= 1 Or'KOC ,E3@W2Pl<-1 o-!u# QjDFbdvribu F LongF2h-tp[re pyanPsto handle w large. !l Farebr@algorithmPy fail,q#n yo6uQB$n`Oap prP computeP v".We'll Xgiv@rP)cco justOEsasrequirpattempt gexact4P *us n> 1007{@N \ponseInteLge$= ("Y@ha " &B`"  &degrees8fdom Incase ʐ Y  witake som/81itFs rePfdqhatil siсCi@nsteadDowish`  T? (Click No_ B4. ` ?q'aLauto1 cally be$` Ple0p`@u.)", vbYesNo, "r3High,  rm,rA,?";@"?= 6#1A'We ne( meapWvarianP.1o cJFSqu͠8dSQMA$nFF ox}trapceMA QII)jD1Gn1'sPwePIdAOn cQ&9Q1>$rb2Ŷ 'Use the normal sheet ofis workbook!$ W8s("PValue.xla").Sh( Range0("b3P = DWStat44HtraceM@A / DF4N5NSqr((2&(DF ^ 2) ) * (2Squared - @)))A6A2 "Calc ulatemyDWʀ-eW!AC'skipE igenvA| a(nd c ions below GoTo S: E If` ' G@eEFsAMAMASee for more on funct@ \my$Ŗ(@:=, NObs:=Ah@tesPting@FIyI1 *Cells(I, 050).(I'Nex^2|DWDE0lCT(i:=,Fd, HJ:= $B6If J2 TheFn" P 2algorithm failed. A user has alreHady@/entxifi NResp=e'6 A9compu{3 done -- just iAae ?:X֍X Nls1c'do"X to gDP#via%@approx'W=e`mean`variaxnceT Di,maCU Nm )949E(I)(& :GDC L10@4:clEAISqr (HHa$F >= 0# -g&RH{R{A:J:8z(JFA! J) / H @5C7/ ele!^ of a;u/JHJh G`G*%IWgH2 b9JA'lEI97 JdJG0\jY'K, `0 eN+# Mp7@ tE(` =@&l(1F}g@%.L$ kI*Ha@F@3(H!Kreduc >=c=b- * c _E,JI= ;c<=&- XE(?-@$R.'MsgBox "$" &E)3C3`'90CCONTINUEy[ xÔawA'b>IŁcOMɤ/acula,rice $pNC^ Or Acu.2 J,^a1d@b2 a15~ 6Q! ISa 1W,' !XNmyAELa 31 B>JD=h J :cEI& MI TS@xZERO# ONE1TW12&# NPN`$ .1 `K0-g?1} R@E(N! %B F2BH/J!NT* (Abs(D(l))NEuBHTap=g9look#sub-diak1 Q Ml̖ M M!$c M <= Bimy)r ađqJm9myv1BQ"Exit Funcqp9+ p 7jshift0Mar-2001 fix from BootsJpR2.xls EwSvp)p 1F)&/ (+*%rOn Err`Res[0C rAprpP 0P06pPR1`{ p!(d-~ h!'  %uPRa!q3_!$Hb@s311az*8ql cY)D(Mx/CC6 *a,M0 8+1 #B .-$( h7rCB ?q2p)A33I)@3Th6p"C "SD `x Q``jCMumy!6O!  Ef -^  a$C &!  D(J) = H + S *( (C g`D(@I)) 'form vect0or For K1 To, N 6NH6z(K, J g" I)HK =   - .Next KBI1E(l끂@p D 4 If (Abs() > B) Then Go|my40 90:o+ F " ?l order latent roots ands^I]IUpׇI1 I{&J A6‚<= pI5115lJG CAv@ >: +3D(K_K0A+d'MsgBox  E55&z(J, I BKsB# = X.  ALLOW FOR THE A'S BEING REVERSE OpRDEREA(1A( a A-BElseK(31HIf} HI Stepv NU X_2_RSNU3NRJLLARE -VND$0,N >BA@BILITY1C > (sR*'Nov 0 2 Fix Exit uUeESIMILARLY I T ^+ t 0 2cDA0_C 0ُ  ` A@A 2s@- T cS @= DF -.O%:? H'(--2?-7` Y  i= 2W $ Ҩ-JO('lJ30!3yJ41k Pq= -U+UQbB ?@8 qq= T* Atn(,) /Qn WK1`PAt[f3rr= / Uz= NN0 /?IRNINTEGPRALSIcoriginalAtran@ldohVB s0 wd QDp= hUPhP 22E0cEM'Thu0 puzzling` sincq sdoesn't seemsnany reason c`rmlooe ke ms if3PevPr0odxd. r Ar0k5elemrlis~sortp{ 1whicNhDvs wra'.A1 , anepAyou grouga o0EqK , wiceQ@ orpordcode by DIMmH1 tx`0z1/19`2}-D(2p6P1P4dDDg8 =BJ4 ,!(X BY CLP( CUMMINS 5/3/96aDA(J^2/1PcsL{Uo2"+"V=-? !KY ?5A "IA " & I0"wN AAUU3V`3Cos(IpA q @\M YX % PROD = Exp(-C / NUM) DFor Kp1 To J1@'MsgBox "Num is " &"C*C Y Y A(K) X*V/ (Y - 23'If750 ThenG,]hi"'End If Break:Next KJ3DF+-k60SUM1+ Sqr(Abs(-.) GBII#myhSgn-IsIr= A+ C *6 J+ tDD3?44 B$L2  'USECOND INTEGRAL.a (DA2)Nu$= - ȧEl 1#` You n se hat's go>y` A @$b&e li~nM(H@ A&rua+e codView`e Lo ;s Window AwatcHh w` h #enRo Prod+` [h9,bcumul`MCPmany terms]kesB expNl`@bKdonLotD enfowNov 02: I do  kncontHrol tog  A('Report I@Ogper pK:P, VBn#ccaNnKHle@Q. @ @Loccurs#nt#AKfgH VS5ed.", v8bIn@]S, "Can't C@act DW "`'Sour Varigin@\e# VarPA:(I), p. 42PM'M1/@0EMA i bIU&MatrixMultcro @so we'7gdo up0!r(o 'bK it/bImak*Bum=2R' n cpheckw r != `w_PiQFunct D(By SelResRanVAs pDim NOHbs,tIRJ Integ"0 Get numbSVobservb/P Q0a8.Rows.Cpounteratp e'A#h3e' F`8 AK AS()S?lTkRe◱ \$~!SIP oVQmJ5o'*diago`$6`J6uuG1 Or e) m| /! $'ϓ%%yB-10_u A p`J  -1zerQ_(A⊡ d()&E@PrimeA(Doub(&&'' residuI=Y9( 81$ o*b5elementP"F*/~J8e + Tct"-S:Eq< ?9P E *  I dE XqIDenombI c W O LntO O WG ^q]@ w E Jo od AVC+~E0bDW( )aI`Lagged1Differe0Squ0dSumGa@g"a S`6 hJQ5ReDim ResidualDifferenceSquared(1 Toxs.Rows.Count - 1) For I = R Laggeds(I)f +O.Value 6(7)3a) ^ 2 SumNu merat= +ܑ5 Ne0xt Is4Denomin5 6ρ\Q3DW Q/X#FEnd FunctionA ' *8This macro adds a menu item so the !P b' can be ruPublic@&b AddDWMI@(' define variables AJ As IntegerCDWIsHBoolea= FalsA-Make sutre(T 1-s visi CommandBars("Worksheet ': " XTrA_ Control'Check to sepe if)*ZaSXJq# If (J).Cap I "?Analysis..."p The2 a'zM4s0GGalready,F@69-<E=cE not Vdo hing!cIfdwJc'T!14it  /)P SJne~w!^ &/H8g(Type:=msoButton@ie!With c%.OnA€!7@ShowDW m";& #( Sub)]test@)PBムeigenv!_n`hidden qin Luteniz5Answers.xls Autrr ch@Q! ! pb aቦI(()V!nt!!myEaC48,J4GajCelIp, 50AmyDWD!Do@= (DWStat:=0.93523, DF:=46, @ MsgBox 1$box%#UseNormalponse*%= C("You have " & NObs`" 0UDFdegrees of fdom. ]64case,6algor+m usedQ0compexdacA$ PpbP @will tb^om`^iAo 51:may faifl;re`Hd!hat y BnR appr oxima"NinLstpJDow8ish _W? (C ok N0rstnp`H sX cR&@Ple spent.", vbYesNo, "BHigh,N q A ?"^ GoBlv20 d""hi?C::;"W"G%ACa0 d"StrTE2.1224555 mod#( Sciific d v  >rU $`8`0`9Ik0` ay ,!`,I`=$q`$`$`$ `n']#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0'AxAttribute VB_Name = "Sheet5111" " Bas0{00020820v-C$0046} |GlobalSpacAFalse dCreatablPredeclaIdTru B@ExposeTemplateD0eriv$Bus`tomizD2$+xMEDocumentation Module19__SRP_8__SRP_9xp'A**   0 0H x , B $ ( 8 >P : 2   8 P `      "   *( X p  .   "   B8  DocumentationChanges History 14 Apr 2003)Fixed Formatting bug in reporting P Value 22 Nov 02:%Added code to allow more than 256 obs<Added normal approx in case algorithm fails (when n is high)Added reporting Estimated Rho Author: Humberto Barreto7 Considerable assistance, as always, from Frank Howlandus3 Thanks especially for MatrixRoutines module!, All rights reserved by Barreto and Howland. Barreto: barretoh@wabash.edupe 765-361-6315e Howland: howlandf@wabash.edu 765-361-6317 Both: Department of Economics Wabash College P.O. Box 352 Crawfordsville, IN 47933# Description of Modules and Forms:0  MainModule Menu bar code DWPVALUE' Computes DW stat and P value DWForm  User input for DW UserForm1< First form user sees, chooses distribution to usex޲Attribute VB_Name = "Documentation" ' D 'Changes HistoryL14 Apr 2003Fixed Formatting bug in repor P ValueM22 Nov 02::Add:code to allow mor s 256 obs'nbl approxacase5gorithm fails (when n is high)>aGEstiV=R hoJL AuthorK HumberIBarret' Considerabl :ssance, asBways, from Frank Howland? Tiks especiuy for MaxRoumodule!All r `tsservрWby H -1. _ b[h@wabash.edu 765-361-6315A) h- f 7 Both Depart of Economicm=WNlleg@'@P.O. Bp352 CraBwCdsvi , IN 4793ADescripMI@]nÝsD"Sin#enuAE c@DWPVALUE Comps DW s[P vC' Uj@xDW  1K Firs"t m useechoos~dɀrU~|   9rU 0`kk$`x'A$*\Rffff*1I49969e46 $ ( 0 H h  0 Z D0 Rx J V  Px B  R  (x * H B    L8 N  " , @HPX`hpx(08@FH  n( (H(p $ `h ckBox&( 20 Label31( 2X Label4   Microsoft Forms 2.0 FormEmbedded Object9q:Y`?@VERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} DWForm Caption = "Durbin-Watson Analysis" ClientHeight = 4005 ClientLeft = 45 ClientTop = 330 ClientWidth = 3735 StartUpPosition = 1 4b cxME(6 << <  `@ )"x `)$01lons: 2 No `n(`hen `&`Mult`(> `*ease idedL h as l sent as`, (`.`0`2 `4st k`6 out` two`@J `ment`is s` and`assi`8as m`:lle,`<K `>be m`@ X()`Boubl`DDIM `Fant`Htrix`Jd P `L `N`P RHd5XlX0 P x  `T`V`X`Z`\`^`b p  f8`## h0  jh zX P`l`n4X  `n``p r`%% hzX j`l`nght  @ `n P`" (`p re t`t The v ` )x@  PP 6 ( `on t`Ptipl`n.`dime z wit   |@ ` x er de may be` `~J `' `n ` row 8 s: mple cas  h `--  X 0       L( Bx N : >P 2 .  H @ `LBNX < D J0J   ( 60 h D <0 p          $8 `     0 @$X      @ P `  D@X ` p        ( "0 <8x    : $Px  B 28 Lp @, H "P <X  D0 P :` $  8@ BH 2 L0 @H,  B  n(x  ( 8HP "X` h Dx  8 8 @ X p   F 4 !(!@! "H!P!X! `! x!!!!!! !"" "("@"X"`" h""""" " "##0#H# <`# # # # $# # B $ $ H $ Hh$ $ $ D$ (% H%h%%%%$%&   &n@&(&(&(' $(' P'`''' ( B ( h( (( (((($) 0)8) @)P)$X) )) )) ))) )* 0* @*P*6h*$* ** ** *+(+ @+X+ x+ +  +++ +\, p, , , , ,, , ",,, , -- -(-0-P- p--- ----- -. .8.@. H.`.$. . "... . ..///0/ P/h/ p////// / <0H0 `0 "h0p0 x0 00 "000 0001FROM MATRIXMULTIPLICATION.XLSP Documentation Author: Frank Howland Date: May 2001 Revised: 10 August 2001lo) Suggestions: 2 Nov 2001 Humberto BarretoS Variant Puzzle explanation in Documentation sheet applied to MatrixMult function A> UBound idea to decrease amount of user-provided informationlwayL Vector limitation removed, as long as matrix is sent as (1 to 10, 1 to 1)C and you pull the element as (1), (2) instead of (1,1), (2,1) O User must keep track of whether output matrix is one or two dimensional.shJ Function idea implemented so output matrix is simply the MatrixMult and< can be assigned within any Sub as matrix = MatrixMultville, TO USE:K 1) DIM matrices to be multiplied as DOUBLE: X() As Double, Y() As Double ! 2) DIM outputmatrix as Variant$ 3) outputmatrix = MatrixMult(X,Y)and P B Two examples are given following the Matrix Mult function below Inputs are F Mleft (NumI by NumK) but dimensions are determined by this function$G Mright (NumK by NumJ) but dimensions are determined by this function Output is MatrixMult (NumI by NumJ)% This routine uses MMULT if possible.H]]]]] ]8]P]]]]]] ]8]P]h]]]]]]](@"]Xp]]]]]8 Partitions, then uses MMULT, then adds; must be Variant Determine dimensions$$"$"  'J3? Handles remote chance the matrix starts at zero instead of one$"$"  'L$$$$  'N$$$$  'Pcheck dimension compatibility L N*The number of left matrix columns doesn't equal the number of right matrix rows. Therefore these matrics cannot be multiplied.A@ zk J PRple f" (1)Test if matrices are too large& There are 3 possible violations'6 Limit is actually 5461 J L 6 L P 6  J P 6 ? First partition the matrices then multiply, then add together. Get relevant dimensions Start with Mleft J 6  J'@ @G'@jVector possibilityd 6'@k J @'6 This is integer division, so there may be a remainder  @ J G  'j' adjust N for remainder J  @ @ ' + This is number of rows in last set of rows: 2 In the simple case, Mleft has N*m rows and g= m8 In the harder case Mleft has (N-1)* m + g rows and g Just multiply it by definition -- see Winograd for faster code n J  P n +R  L n $"  $$ n $R n +R    n2 R' `FkH T  T   @'Zd 'Zk ]X T  @'< V & : V & G '\cG '\jH4 Z \ Load A matrix V  '> n Z < n 'B  \ >  'D B D$" n +`5  n : X : 2 X : G '^cG 8'^j@6 \ ^ X  '@ Load B matrix  \ >  'F  ^ @  'H F H$$  +      "!,%d'b  n Z  ^& Acols Z  n <  @ $R n $b n <  @ +R d n <  @ $R $b n <  @ +Rk  n X9 V T R' d@  matrix is small enough " $ "!,%d' k`'Z junk linei5 Matrices to be multiplied must be declared as DOUBLE]]8]p Set dimensions'l'n l nh; n lj ]3 Output matrix VARIABLE must be declared as Variant Note that the () are NOT used2]  n l  n n +h   n+j; Simply set output matrix equal to MatrixMult function with+ two matrices to be multiplied as arguments F The parentheses on the two matrices to be multiplied are not required>$j$h$ 'p: To pull an element, indicate via the usual index notation$p $pA@ o85 Matrices to be multiplied must be declared as DOUBLE @]x]]> Set dimensions; set either dimension to 1 to make it a vector6'l'n l nh8  n lj`]h3 Output matrix VARIABLE must be declared as VariantA Note that the () are NOT used]] n l  n  n +h   n+j ; Simply set output matrix equal to MatrixMult function withC+ two matrices to be multiplied as arguments F The parentheses on the two matrices to be multiplied are not required $j$h$ 'p h j$ 't: To pull an element, indicate via the usual index notation$pA@$t $tA@Eo0 Determine dimensionsHF]H ]` $x$x  'Q? Handles remote chance the matrix starts at zero instead of one$x$x  'P]x  ]   Pz F n   P  n $x n +z  nH z'vi ]H ]  > Set dimensions; set either dimension to 1 to make it a vectorI6'~' ~  I]  2 Output matrix VARIABLE must be declared as Double] n ~   n +ph@ Simply set output matrix equal to VariantToDouble function with. the input Variant matrix as the only argument $v'$A@o@ ] ] ]    Set dimensions2'~ '' ~ X    ]   ] ] n ~   n + n    n +H@$$ "!,%d' ~ R` n ~   n +R   n $  $ n $R n +R   n $ $R A@oh Inputs areB A (NumI by NumK) but dimensions are determined by this functionB B (NumK by NumJ) but dimensions are determined by this function Output is C (NumI by NumJ)= This routine chops the A and B matrics into pieces for MMULT All matrices are Doubles](@Xp]]0]H`x]]the result from MMULT]Pthe final result Determine dimensions$$  'J+? Handles remote chance the matrix starts at zero instead of one$$  'L$$  'N$$  'Pcheck dimension compatibility L NThe number of left matrix columns doesn't equal the number of right matrix rows. Therefore these matrices cannot be multiplied.A@zk J P<Make a 73x73 square (or as much as possible) out of A matrixdo the same for B matrix"multiply A by successive B squares"put in C (moving down, then right) n JI  LI J n JI n   J'd nH 'k L  LI    L'dp H 'kXload up the APiece n     n  &    &$  &+ &   PI '(must be to assure correct dimensionality P  PI    P'd( H 'kload up the BPiece            $  +  multiply A and B   "!,%d'   n       $ n      $ n      +     n '(i0]@]x] Set dimensions '~ '' ~   @]H`x]] n ~   n + n    n +$$$('R$$ "!,%d'$R$A@oP]@]x] Set dimensionsK'~/'K' ~   @]H`x] n ~   n $$ n + n $$  n+$$$('R6CMMult = Application.WorksheetFunction.MMult(A(), B())$RA@o]>I "!,%' A@oP ]` n  nA@o&Attribute VB_Name = "Module1" 'FROM MATRIXMULTIPLICATION.XLS Option Explicitd Documenta2 Author: Frank HowlandRate: May 2001Revised: 10 AugustSuggesSs: 2 Nov Humberto Ba rretoF Variant Puzzle ean in sheet a"paed $MaxMult funcc UBound ideadecrea se am t of user-0provnformKector limi removed, as longrix is s(17P10, )r  you p@ull thule), (2)ysteadPp(1,1 "U - m[keep@ trackA wher output G&one @2two diEsal.CFcDMCJimp$@Wsosy.H^Ĉ8 can bAYssignwithqany Sub:D&=o"TO USE:%1) DIM1XcesTmyi~`DOUBLE: X() As@uble, YCUACFD3);'(X,YqT@QexaIs are given followiuF E@P)ic F^GR(MLeft3MRigh"In<"Ml  (NumI by K) G>determi!3@3s gMr " K$ J? @B``IprOPisuJThr3rs Ma if poI:U !LDim I=L@peGJOKKpOncolsrow-AK%BresASfM%imaxjA; a3 sizeO NOMOlOgO*HOpOqOMmoistarth, kjG?a[#a@"bjbhbf.+!hjK1PC {Lar geCD@ ' Pi,anh^adds;GM4DU<= =oDph) - LpJ+j' H[lVmchanr1 ThenSMsgBox ("  nvB7bP%umns doesn't eq|ua~SU@)s. Are`cs!tnotQto."RCExi"tc E@If ReQw' o I TWq#' (1)TV qmtoo| l+A4 o3Y viol^G= 5400 /Lqqacttly6QI * >'xKOrJTv' Fir@>p67-5ltyG7gbf ' Grelev1$S2KA "x < qM`,Intp/,/c0!n 1 'Vèp4+ElseQ/Y"qNM)BxpxintegerE, Ue yQ)aainder'pM <IC N @aMZ Z050\cQc\?Iјf/, rJO mO O (JyY!r\H2C4BOC\mq Y' P enough**|`2pscU 6uK'junk lin/I1Subb wExaBys('C ѐkAĄi0mpd`eclarDOUBLE sA1()Dou bl`3Tran`spose%R, A1Cols' Set1 men1P6A1= 540Г q1㷃Vc 5W !;3 Ia8 ' OutputAVARIA _s F' No:t!a0 NOT useda1t5a1| jJ#CZ 6 U1J, IaD`/ S1 Si`!y 0equa8$ faU wit.w^o#"`4utp쪶e parentheses on H two m atricto be multiplied not required a1transposea1 = M vxMd(A1T4(), A1()) ' To pull an elem, indica@te viausualexsation M@sgBox v(1, 1) & " & 2wEnd Sub Example^ByVector(V'!mustde cls DOUBLE Dimx A oubB4J '!cres fro1 Then MsgBox (" numbeBroleftcolumns doesn't e0qualrighrows. 2refor sccannot b ultiplied.")HExit Functd E nd If ReDim C(`oeI TJMake a 73x73 sT?(or a@s muchpossible) out;AD:do6same ). Bm*y A by suca2sivesp@in C (movingMwn,n H@)F#Iw1 St|ep,C9KmsI <= I OrBB <@}Ix ALastRowIElsA I@72 Gc F= KD"KEE"KY"ColC"K^" K\"'loupoAPiecgH5Í(I!Fe,H 3 44b55Kf k%UKK)A(IckNext KH"I5 k!eCJoCB< 'musmto`su`bcorrectgaCa;JALJ;CLJ;wB;JGOLHJ;;B;(0" q\, Ja2 ;K1K*K1B-a-_k%e @J;B( 9J#`6b ZBGAcHpc on.Work sheet.MM@(cO, \IE-`"ˡeߦ!b*@71GCl+ I!@<^JFb_#"`J&+ጰ 'ccobigL! CsQe7f Sub TestLargeMUs \Spg As Doud !x+)CAsaLo ng, AP1sB;B1%c Se8d3= 10 = 3MSqRdqW SBT P I JKCCQVariant2a() Q$o 3&M (R4%a@Q{Ǧ " B C"p!"  A_6_6's$(10) & U(''(@Hockey(ng(()RQ(s 3r%(+= 84347(%( (Px(aD 3 ('!'r?a`42{ "Cells$J, IKj+)$lt$'$?[Cr$I7$#KtKJCeq@ng(KIntegerp,9c830 /~+ $-A:+{a`pC:10P$YcYb$`(`o$!`$I`0q`1Akk$`$`$ `$ `n~s$UserForm2E4ModuleLanguageSetting, __SRP_a#b__SRP_b%'CenterOwner TypeInfoVer = 22 End $  }R KQDBTahoma,4CommandButton1x(OK3OuTahoma(CancelOuTahoma`5Tahoma,8CommandButton2x; $4ListBox1BelgianFrench B@msoLanguageIDBengali B@ msoLanguageIDBrazilianPortuguese B@msoLanguageIDBulgarian B@msoLanguageIDBurmese B@msoLanguageIDByelorussian B@msoLanguageIDCatalan B@msoLanguageIDCherokee B@msoLanguageIDChineseHongKong B@msoLanguageIDChineseMacao B@msoLanguageIDChineseSingapore B@msoLanguageIDCroatian B@msoLanguageIDCzech B@msoLanguageIDDanish B@msoLanguageIDDutch B@msoLanguageIDEnglishAUS B@msoLanguageIDEnglishBelize B@msoLanguageIDEnglishCanadian B@msoLanguageIDEnglishCaribbean B@msoLanguageIDEnglishIreland B@msoLanguageIDEnglishJamaica B@msoLanguageIDEnglishNewZealand B@msoLanguageIDEnglishPhilippines B@t msoLanguageIDEnglishSouthAfrica B@msoLanguageIDEnglishTrinidad B@msoLanguageIDEnglishUK B@msoLanguageIDEnglishUS B@ ThemsoLanguageIDEnglishZimbabwe B@ msoLanguageIDEstonian B@msoLanguageIDFaeroese B@ msoLanguageIDFarsi B@msoLanguageIDFinnish B@.msoLanguageIDFrench B@ msoLanguageIDFrenchCameroon B@msoLanguageIDFrenchCanadian B@msoLanguageIDFrenchCotedIvoire B@msoLanguageIDFrenchLuxembourg B@y bemsoLanguageIDFrenchMali B@msoLanguageIDFrenchMonaco B@msoLanguageIDFrenchReunion B@msoLanguageIDFrenchSenegal B@msoLanguageIDFrenchWestIndies B@h msoLanguageIDFrenchZaire B@msoLanguageIDFrisianNetherlands B@msoLanguageIDGaelicIreland B@msoLanguageIDGaelicScotland B@~msoLanguageIDGalician B@'msoLanguageIDGeorgian B@msoLanguageIDGerman B@msoLanguageIDGermanAustria B@ msoLanguageIDGermanLiechtenstein B@msoLanguageIDGermanLuxembourg B@msoLanguageIDGreek B@msoLanguageIDGujarati B@ msoLanguageIDHebrew B@@ msoLanguageIDHindi B@msoLanguageIDHungarian B@msoLanguageIDIcelandic B@msoLanguageIDIndonesian B@msoLanguageIDInuktitut B@msoLanguageIDItalian B@msoLanguageIDJapanese B@msoLanguageIDKannada B@ msoLanguageIDKashmiri B@msoLanguageIDKazakh B@JmsoLanguageIDKhmer B@msoLanguageIDKirghiz B@PmsoLanguageIDKonkani B@ :msoLanguageIDKorean B@msoLanguageIDLao B@msoLanguageIDLatvian B@msoLanguageIDLithuanian B@msoLanguageIDMacedonian B@s msoLanguageIDMalayalam B@"msoLanguageIDMalayBruneiDarussalam B@msoLanguageIDMalaysian B@)msoLanguageIDMaltese B@ matrimsoLanguageIDManipuri B@msoLanguageIDMarathi B@@msoLanguageIDMexicanSpanish B@Z ^msoLanguageIDMixed B@msoLanguageIDMongolian B@>JumsoLanguageIDNepali B@e WinomsoLanguageIDNone B@msoLanguageIDNoProofing B@msoLanguageIDNorwegianBokmol B@ msoLanguageIDNorwegianNynorsk B@L+xME(SPSSS0{BD339AE1-3856-4A2D-A483-8394CB0A7291}{CE197621-CF7C-4955-85BB-A612A017FD75}@ @  % %@ 'A" " ( "0 8 H $`$""(((&P&x(((&(@&h&&($&0$X$(&"( (H"p.$"("@$h*(,$ @"` &(*,(*X*,..*H$x$*$$  H "h " * * , ,H &x ( ( ( , &H .p ( * $ $ "H (p . ,  $ "@  h $ $ & $"($P"x$" ""8"`"&&$ 0H$x"$"* H$h" &*,0 ` "&"($@*h"*&$*@(p",""$@"h",*(*@,p4*,,8*h,,(* &P,x*, "("P*x&&(  @ `" "*, .P""""$  H(h& &   @ ` p !A@PLo`@oP ( 180 languages HowmsoLanguageIDAfrikaans B@xmsoLanguageIDAlbanian B@msoLanguageIDAmharic B@msoLanguageIDArabic B@msoLanguageIDArabicAlgeria B@msoLanguageIDArabicBahrain B@msoLanguageIDArabicEgypt B@msoLanguageIDArabicIraq B@ lmsoLanguageIDArabicJordan B@msoLanguageIDArabicKuwait B@msoLanguageIDArabicLebanon B@msoLanguageIDArabicLibya B@msoLanguageIDArabicMorocco B@msoLanguageIDArabicOman B@msoLanguageIDArabicQatar B@msoLanguageIDArabicSyria B@simsoLanguageIDArabicTunisia B@msoLanguageIDArabicUAE B@msoLanguageIDArabicYemen B@()msoLanguageIDArmenian B@msoLanguageIDAssamese B@msoLanguageIDAzeriCyrillic B@msoLanguageIDAzeriLatin B@msoLanguageIDBasque B@msoLanguageIDBelgianDutch B@msoLanguageID msoLanguageIDOriya B@msoLanguageIDOromo B@msoLanguageIDPolish B@ msoLanguageIDPortuguese B@msoLanguageIDPunjabi B@ @msoLanguageIDRhaetoRomanic B@msoLanguageIDRomanian B@ ZmsoLanguageIDRomanianMoldova B@ixmsoLanguageIDRussian B@ ZmsoLanguageIDRussianMoldova B@msoLanguageIDSamiLappish B@+msoLanguageIDSanskrit B@:msoLanguageIDSerbianCyrillic B@'^cmsoLanguageIDSerbianLatin B@msoLanguageIDSesotho B@ LmsoLanguageIDSimplifiedChinese B@ msoLanguageIDSindhi B@@ msoLanguageIDSlovak B@msoLanguageIDSlovenian B@ msoLanguageIDSorbian B@ ZmsoLanguageIDSpanish B@colsmsoLanguageIDSpanishArgentina B@n msoLanguageIDSpanishBolivia B@ msoLanguageIDSpanishChile B@msoLanguageIDSpanishColombia B@ msoLanguageIDSpanishCostaRica B@%msoLanguageIDSpanishDominicanRepublic B@ll emsoLanguageIDSpanishEcuador B@msoLanguageIDSpanishElSalvador B@msoLanguageIDSpanishGuatemala B@laremsoLanguageIDSpanishHonduras B@msoLanguageIDSpanishModernSort B@ lmsoLanguageIDSpanishNicaragua B@msoLanguageIDSpanishPanama B@msoLanguageIDSpanishParaguay B@msoLanguageIDSpanishPeru B@msoLanguageIDSpanishPuertoRico B@ nmsoLanguageIDSpanishUruguay B@n+jmsoLanguageIDSpanishVenezuela B@tputmsoLanguageIDSutu B@msoLanguageIDSwahili B@s to bmsoLanguageIDSwedish B@F TmsoLanguageIDSwedishFinland B@ultiplmsoLanguageIDSwissFrench B@ msoLanguageIDSwissGerman B@icmsoLanguageIDSwissItalian B@msoLanguageIDTajik B@msoLanguageIDTamil B@msoLanguageIDTatar B@msoLanguageIDTelugu B@msoLanguageIDThai B@msoLanguageIDTibetan B@o makemsoLanguageIDTigrignaEritrea B@ nmsoLanguageIDTigrignaEthiopic B@msoLanguageIDTraditionalChinese B@mumsoLanguageIDTsonga B@ NmsoLanguageIDTswana B@msoLanguageIDTurkish B@ msoLanguageIDTurkmen B@ msoLanguageIDUkrainian B@msoLanguageIDUrdu B@msoLanguageIDUzbekCyrillic B@msoLanguageIDUzbekLatin B@s msoLanguageIDVenda B@msoLanguageIDVietnamese B@plmsoLanguageIDWelsh B@msoLanguageIDXhosa B@msoLanguageIDZulu B@oڴAttribute VB_Name = "UserForm2" " Bas0{BD339AE1-3856-4A2D-A483-8394CB0A7291}{CE197621-CF7C-4955-85BB-A612A017FD75} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCustomizDP Sub CommandButton1_Click() MsgBox List1.Index End $2$_Initialize< ;ColumnCount@I1 '180 lang`uages AddItem "msoLDIDAfrikaansr lbanian` mharic rab AlgsaBahrai+B!Egypt!Iraq Jo rdbM!KuwaRi!Le`2oDA Liby'Morocco]c OecQrßSyriTunis_"UAEYem^e-de ss@seAz^:C lLat_IDqu_ DBelgDutch?Frenengali BrazilPortugue' ulg_pArm `7Bye`lorus@MBDC]Cheroke1DChin HongK0^Maca/=naSipors ro'O/gCzeO!oDfs&/)nEnglishAUS?P,@wCanad)Лbe? Irep$dJam8aicSNNe0wZea/ID$Ph9pp(o o b South tTrinida UK?!odZimbabw1oIDFaP?oGߚ1rsio m FinPp3> Z_g3sCjro߆1otedI8voiF/#Luxembourg_^hMfDpMonaReSenePo  QtWestiesaPu HondurasModern%: S NraAOOBPanamO%P zyeruuerZicA  Ur0caVenezuO N ut wahilhwed?ZO,DSFinA ~ wissFr8enc_GerqIa1TajiTTjooataEt thiopt/TraditionalobbTs <swp?_ ^ urk?+?+DTmeem "msoLanguageIDUkrainian" ListBox1.AddIterdu zbekCyrillic$\Lati VendaRVietnamese+Welsh!Xhos stJoEe h^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\22.tlb#OLE Automation0MSFs>!SFs3ED452EE1-E08F-101A-8-02608C@4D0BB4EFM20.DLL#Microsoft : @/ Object Library/;_VBA_PROJECTg&dir)k__SRP_0~__SRP_1?MSFormsCOfficeu Sheet5 _Evaluate ThisWorkbook|Workbook_AddinInstall(AddPValueMenuItem+Workbook_AddinUninstallmyTools=' Application*OperatingSystem[ InternationalxlNonEnglishFunctionsInputBox  CommandBars ControlsKDeletex UserForm1)userBooke userSheetbtncancel_Clickebtncancelinput_ClickQbtncancelresults_ClickŹbtnfinish_Click| MultiPage14?page3s picturecbxValueKSheets Addr ActiveSheet%NPasteColumnsp9AutoFit&  btnnext_Click~page1qfrmdistributionl normalbtnpage2rFrame2VisibletbtnHdf2txtGdf2lblchibtn϶ hypovaluetxt{Label2,setxt8Label3,Frame1fbtnLabel6,Captionxdwbtn  DWFormdShowActiveWorkbookbtnnextinput_ClickK7 obsvaluetxtMsgBoxRdftxt ScreenUpdating! Activate|onetailY Range FormulaqY Calculatestattxt pvaluetxtSCopyƿ WorkbooksBMultiPage1_ChangeJUserForm_Click Sheet5113 MainModule  (auto_closewSaveddJa PValueIsHere?Count0vnewItemICommandBarControlPmsoControlButtonnOnActionresponseChrK~ vbInformationn (ShowPValuem (GetLanguagesLanguageSettings LanguageIDmsoLanguageIDUI5msoLanguageIDEnglishUSu(ShowLanguageForm: UserForm2* Sheet51P Sheet2 mySelXRange`: mySelResRange6CommandButton1_Click (MatrixWork\ SelXRangeW SelResRange%CommandButton2_ClickHide9zpromptmAddressCommandButton3_ClickFA DWPVALUE$ (ShowDWFormxI myResponsephTitle~Buttons] vbOKCancelx?vbOK%NObs<intI\intJ\intIIintJJ lastRowUsedOVNumXVarR mystartrowՊ mystartcolumn_myendrow myendcolumn6 myDWPValuetraceMALtraceMASquared MASquaredD RowsU sheetstring۟NewSheet  WorksheetsXo XTransposekHInterceptCheckBox<\resultsCheckBox.Cells XTransposeX'( LMMultXTransposeXInverse:WorksheetFunction&minverseXTransposeXInverseDI CharactersrgStartLengthYFontU SuperscriptXXTransposeXInverse{XXTransposeXInverseXTransposeKMdAMatrixyEPrimeAresidualSelement[EPrimeAE{EPrimeEDWStatvMA7^MAMendtime7TimerXDF\UseNormalResponsevbYesNoSqr(Skip myEigenValue (EigenValuei(PValue eigenvalues> Residuals2toNResiduals2toNLaggedI` EstimatedRho[CorrelRoundmyDWPValueFormattedW DisplayAlertsETAeps&tol1precis}g^H_NeI1]lczqE\(D[30dZKb40Z100o70ZJ1]HH]140 myNextElementϔMITSXZEROLONEHay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{AA9352D3-EAFB-4BF5-8201-FCBFCE5BFA7C}#2.0#0#C:\DOCUME~1\user\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M &*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\Program Files\Common Files\Microsoft Shared\office11\mso.dll#Microsoft Office 8.0 Object Library  NFinds P Values for normal, t, F, and DW'A    Sheet51849969d10 Sheet5-ThisWorkbook1G49969d10ThisWorkbook` UserForm11:49969d103UserForm10-1Sheet5111;49969d10Sheet511?H-MainModule1F49969d10MainModule`Sheet511=49969d10Sheet51qx- Sheet21>49969d10 Sheet2- DWForm1?49969d10} DWForm} DWPVALUE1H49969e46DWPVALUEpSheet51111A49969d10Sheet5111]-Documentation1B49969d10DocumentationModule11I49969e46Module1cUserForm21D49969d10UserForm2 +*ModuleLanguageSetting1J49969e46*ModuleLanguageSettings8X`08 Hx-A-BIʑ!0G`Bw4%X:Fﻇ]i~@n=(0cYi=nCB#&Om~sc@f2Z)Q#2D #;}/WK5eN?NV9 \ytmuErj Ha1sn^!t2% Lg_Yx1UNgAǔNPFjz"O67$qtl[ BQF Excel+ VBAWin16~Win32MacVBA6# PValueCalculatorHstdole`TWO7N1L^JJ]M1'^my30090B[my40UpgriErroPR^CZSj60Zmy70Ĕ110130DD\J2]J3]J4]L1^L2^NUp^N2M^NUMPINDbleIDbleNPROD^mySgnsumSUM19UlVmYlHALFPAX20?ZAtnQuH1n]CosOExpKBreak(DW\ ResidualsLaggedResidualsResidualDifferenceSquared SumNumeratorySumDenominator (AddDWMenuItem#DWIsHere9(testpvalueLutenizing(testboxFxline20[(test4 Sheet51115 Documentation( Module1b ( MatrixMultֈMLeftMRighteKK]ncolsVnrowsoresulturimaxTjmax}rowsleft|colsleftHmaxsizeSqhMmC^istartkstart*jstartJarow2Dacol0brow bcolιNumI]NumK]NumK11NumJ] CMatLargencountkcountrmcountNdim0KdimVMdim<skiprestMZ smallresultU`MMult( MatrixMultExampleMatrixByMatrixA1k\ A1TransposeA1RowsKA1Cols a1transposea1,( MatrixMultExampleMatrixByVector a1a1transposeT( VariantToDoubleAInputMatrixAsVariantTempR( TestVariantToDoubleExampleHARowsAColsADoublezJ ( TestSlowMult^ AColsBRowsMBColsCMMultD K1]II]K1K1KALastRowuALastCol%BLastRowvBLastCol]&APiece&BPiece<ABPiecey( TestLargeMatrixMultUsingMMult,#( TestHockeyLargeMatrixMultUsingMMultT( testingCeilingjsCeilingn( teststepListBox1 ListIndexQUserForm_Initialize5c ColumnCount$AddItem  ModuleLanguageSetting ( GetLocaleInfoͰLocaleLCTypelpLCDataȒcchDataցkernel32_( LOCALE_SLANGUAGED ( StLangOfLcidlcidqst(_cch} vbNullCharY ( FindLanguagebmsoLanguageIDInstallmsoLanguageIDHelpWorkbookk AddinInstallAddinUninstallItemz _B_var_LeftQ _B_var_Chr\;_B_var_response  Worksheet'3&     } (  @P@  "~1@:@@00}#0@# ў50 AAA9352D3-EAFB-4BF5-8201-FCBFCE5BFA7C6DOCUME~1\user\LOCALS@Temp\VBE\S.exd ; .E .`M OffDicOf@iDc 02DF8D04C-A+AgB-BHDE5IAA420Program Files\CommongShared\o 11\mso0.dll4& 8\.0Lp@%DBS@heet5GBS]et5U2B H1"k-",b ""+ThisWorkbookG Ti`~W\kbok t2o ofl@U G_1GUen1@2"f"$(@ e#vc11A11i2°m02?2 `MainModuleG\ M1dlB+26 -!! g d G£-2 q׫!ǂ 2`2?`2  DWM EMn  @d*};KDWPVALU EGbG! PVALUE`%5%=?6p{3d-16+?56f36oG]; pDoc@umentawGo[umU-n`a0i/n. /' y?/s7`?ouQ"913/E91?(cUO`/_OmYO2Q_0@M}[)pLanguageSettingXG*GLInTgHaPepeutBg2/sZrU~~{ a AddDWMenuItemtestpvalueLutenizingtestboxMatrixMultExampleMatrixByMatrixMatrixMultExampleMatrixByVectorVariantToDoubleTestVariantToDoubleExample TestSlowMultLMMultTestLargeMatrixMultUsingMMult #TestHockeyLargeMatrixMultUsingMMulttestingCeilingteststep GetLocaleInfo kernel32 GetLocaleInfoA Qyx StLangOfLcid FindLanguage    'Finds P Values for normal, t, F, and DW    SelXRange SelResRangeMAMNObsDWStatDF eigenvalues ResidualsMLeftMRightInputMatrixAsVariantABLocaleLCTypelpLCDatacchDatalcid&9YfoHJCompObjKaVBFrame9 Microsoft Forms 2.0 FormEmbedded Object9ql  VERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UserForm2 Caption = "Choose Your Language" ClientHeight = 3420 ClientLeft = 45 ClientTop = 330 ClientWidth = 3630 StartUpPosition = 1 'Centrar en propietario TypeInfoVer = 7 End CUME~1\Sheet5Sheet5ThisWorkbookThisWorkbookUserUserForm1LG"p-0ğ-fHo!@i08%pFz?ap-p-     !"#$%&'()*+,-./0123456789:Y`z?@ABCDNFGHIJKLM>OPQRSTUVWXZ[\]^_u{bcdefohijklmnapqrstvx}PROJECTwmMPROJECTSummaryInformation(OhDocumentSummaryInformation8K*y    rU~~~~~~~~~~~~~~~~~J b/L `   a 9   9 Ya   ! Q q y    H 9Yq !  `  Q)AIa !9YyYPValueCalculatorSheet5 ThisWorkbook UserForm1Sheet511 MainModuleSheet51Sheet2DWFormDWPVALUE Sheet5111 DocumentationModule1 UserForm2ModuleLanguageSettingF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  I0F F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel  @0FC:\WINDOWS\system32\stdole2.tlbstdole aP.E .`M C:\WINDOWS\system32\FM20.DLLMSForms A`RK[| .C:\DOCUME~1\user\LOCALS~1\Temp\VBE\MSForms.exd ApL-[DR ?C:\Program Files\Common Files\Microsoft Shared\office11\mso.dllOffice   auto_closeAddPValueMenuItem ShowPValue GetLanguageShowLanguageForm F`1@F<>j7Nм9FDFWorkbookWorkbook_AddinInstallWorkbook_AddinUninstall @ $Worksheet Menu BarFF FF W Tools Herramientas F FControls CountCaption &P Values... P Values...TypeAdd *MainModule.ShowPValue bYou have successfully loaded the P Values add-in.test MatrixMultp The language of this installation of Excel does not appear to be EnglishUS. Please enter the word that Excel is using for Tools on the main menu across the top of the screen. For example, in Spanish, it is Herramientas. ,Get the word for TOOLS JYou may access P Values by executing  : P Values... P Values Add-In VBE6.DLL ai a`  aS ( ShowDWForm MatrixWorkFF EigenValuePValueDDWp<; =w(      !"#$%&'4[+,-./0123Uj678C:;<=>?@AB5DEFGHIJKLMNOPQRSTV]XYZ\g_`abcdefWhikolmnqtuwxyz{|}~rb  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acydefghijklmnopqrstuvwxyz{|}~fPo$'Mi10*4i*WJOp-p-i11&(/i*WJOp-p-i22),i*WJOp-p-CompObjKsxJ<f]      !"$&'(*+,-./0123456789:;<=>@ABCDEFGILNOQRSUWXYZ[\^_`abceghijkmnopqrsuwyz{}Root Entry F˜s@[uwx*}WorkbookPF_VBA_PROJECT_CUR"NBw),3-VBA+,p-(H  H@}R KQDBTimes New Roman03( #9Mult  WS\s pFz?aMicrosoft Forms 2.0 FormEmbedded ObjectForms.MultiPage.19qC:\WINDOWS\sy1(    DistributionInputibuResultsuTab3Tab4Tab50o+-VCompObjTnflo.1fHi50; n``p-p-i58028 n``p-p-CompObjdnfxo35vLi336> n``p-p-CompObjtnf(H  Hw} ¯NCh0 $ #Page1ils5,$ !Page2ils5.$!Page3ils5.  i*WJOMicrosoft Forms 2.0 FormEmbedded Object Forms.Form.19qH,D{0$(statistic valueN=g {0(P valueg {0H,D{04F +0Show picture0(FinishEOp(CancelEOp`(OPicture pasted on sheet may be moved and copied and pasted elsewhere as needed.S#0$H D}8?h$)$stattxt{(*24Label4t {(+2(Label5t ( ,$pvaluetxttio( -Dpicturecbxio , .7(btnfinishxio,0(btncancelresults(B2pLabel8t i*WJOMicrosoft Forms 2.0 FormEmbedded Object Forms.Form.19q(SE3g {0 (observed valueg {0$(null hypothesisN=g {o79CompObjpfo:<~CompObj|pf(o=?LCompObjp0H,{0@H,{00H,{0(NextEOp(CancelEOp$H @'}8? (2$Label3 D(20Label1 (24Label2 ( $obsvaluetxt.( ,hypovaluetxt$$setxt2D, '7$btnnextinput,(( btncancelinputme$2#Frame2 $:#Frame1   i*WJOMicrosoft Forms 2.0 FormEmbedded Object Forms.Form.19q(CancelEOp(NextEOp$H H0}8A,!#frmdistributionn( #(btncancelbut(&7$btnnext  n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19qH,{0( DF valueee{0H,{0 (DF denominatormeq{0<H @}DDegrees Freedome$=$dftxtxt(>2,Label6t$?$df2txtt"(@20df2lblt"  n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q0F{11 tailt00F{02 tails04H <} DTailslT$;@onetail$<@twotails"  n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q0F0O1Normal04F 0O0t (Student)u0,F0O0F08F0O0Durbin-Watson dn04F 0O0Chi-squaredo0DH H }Select a Distribution( "@normalbtntio CDtbtn" F<fbtn $GHdwbtn $HDchibtn iPage1  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UserForm1 Caption = "Hypothesis Testing" ClientHeight = 3990 ClientLeft = 45 ClientTop =Form1UserForm1MainModuleMainModuleSheet51Sheet51Sheet2Sheet2Sheet511Sheet511DWFormDWFormDWPVALUEDWPVALUESheet5111Sheet5111DocumentationDocumentationModule1Module1UserForm2UserForm2ModuleLanguageSettingModuleLanguageSettingID="{D00CFD9A-C69D-4AFE-8A62-00170EFBC70D}" Document=Sheet5/&H00000000 Document=ThisWorkbook/&H00000000 Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=UserForm1 Module=MainModule Document=Sheet51/&H00000000 Document=Sheet2/&H00000000 Document=Sheet511/&H00000000 BaseClass=DWForm Module=DWPVALUE Document=Sheet5111/&H00000000 Module=Documentation Module=Module1 BaseClass=UserForm2 Module=ModuleLanguageSetting HelpFile="Macintosh HD:Applications:Microsoft Office 98" Name="PValueCalculator" HelpContextID="0" Description="Finds P Values for normal, t, F, and DW" VersionCompatible32="393222000" CMG="3133105014501450145014" DPB="626043B075B175B175" GC="9391B283E284E2841D" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Sheet5=0, 0, 0, 0, C ThisWorkbook=132, 174, 922, 794, C UserForm1=88, 116, 877, 736, C, 220, 290, 1010, 910, C MainModule=110, 145, 909, 629, C Sheet51=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet511=0, 0, 0, 0, C DWForm=0, 0, 0, 0, C, 0, 0, 790, 620, C DWPVALUE=0, 0, 0, 0, C Sheet5111=0, 0, 0, 0, C Documentation=0, 0, 0, 0, C Module1=0, 0, 0, 0, C UserForm2=0, 0, 0, 0, C, 22, 29, 812, 649, C ModuleLanguageSetting=0, 0, 0, 0, C Oh+'08 PXt  $0P Value Calculator$Humberto Barreto and Frank Howland<Finds P Values of Normal, t, F, chi, and DW 29 Apr 2008Humberto BarretoMicrosoft Excel@Rȿ@ʀ-՜.+,0 PXd lt|  normaltFchiDoc  Worksheets F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89qCompObjm