ࡱ> on g2ɀ\pUIS Ba==J/8X@"11Arial11Arial11Arial11Arial11Arial11Arial1@1Arial1@1Arial1@ 1Arial11Arial1@1Arial1@ 1Arial11Arial1@1Arial1 1Arial1 1Arial11Arial11Arial1 1Arial11Arial1 1Arial1 1Arial1$1Arial11Batang11Arial11Arial1(1Arial11Arial1 1Arial1 1Arial1 1Arial101Arial11Arial151Arial151Arial1 1Arial11Arial11Arial191Arial191Arial11Arial11Arial11Arial11Arial11Arial1 1Arial1@ 1Arial1@ 1Arial1 1Arial1 1Arial1 1Arial1 1Arial11Arial11Arial11Arial1Arial1 Arial1Arial14Arial1 Arial1Arial1Arial1,8Arial18Arial18Arial1>141<Arial1?Arial1h8Cambria1Arial1 Arial1 Arial1@ Arial"$"#,##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\);_(* "-"??_);_(@_) 0.0000.0 0.00000 0.00000000                8  8  8  8  8  8  8  8  8  8  8  8  9  9  9  9  9  9  9  9  9  9  9  9  :  ;   < ff + ) , * =  >  ? P @ P A  A  B   C ` D  7    E   F G a> H                                     a   *x *p  `  *t  *t           H                ! " # & ' (   ) * + - ! .a 1  $  2  3 4 5  5 H  H  @  H  H  @   H  L  H  @   L+ / L+ / H+ 0 L+   H+   L+  @+   H+ 6 H I  J  $ % ||<}<} 00\);_(*ef_)?_);_(}<} 00\);_(*ef_)?_);_(}<} 00\);_(*ef_)?_);_(}<} 00\);_(*ef_)?_);_(}<} 00\);_(*ef_)?_);_(}<} 00\);_(*ef _)?_);_(}<} 00\);_(*L_)?_);_(}<} 00\);_(*L_)?_);_(}<} 00\);_(*L_)?_);_(}<} 00\);_(*L_)?_);_(}<} 00\);_(*L_)?_);_(}<} 00\);_(*L _)?_);_(}<} 00\);_(*23_)?_);_(}<} 00\);_(*23_)?_);_(}<} 00\);_(*23_)?_);_(}<} 00\);_(*23_)?_);_(}<}  00\);_(*23_)?_);_(}<}! 00\);_(*23 _)?_);_(}<}" 00\);_(*_)?_);_(}<}# 00\);_(*_)?_);_(}<}$ 00\);_(*_)?_);_(}<}% 00\);_(*_)?_);_(}<}& 00\);_(*_)?_);_(}<}' 00\);_(* _)?_);_(}<}( 00\);_(*_)?_);_(}}) }00\);_(*_)?_);_(   }}* 00\);_(*_)?_);_(??? ??? ??? ???}(}/ 00\);_(*}<}1 a00\);_(*_)?_);_(}<}2 00\);_(*_)?_);_(}<}3 00\);_(*?_)?_);_(}<}4 00\);_(*23_)?_);_(}(}5 00\);_(*}}7 ??v00\);_(*̙_)?_);_(   }<}8 }00\);_(*_)?_);_(}<}9 e00\);_(*_)?_);_(}x}:00\);_(*_)?_);_(  }}; ???00\);_(*_)?_);_(??? ??? ??? ???}-}= 00\);_(*}P}> 00\);_(*_)?_);_( }(}? 00\);_(*}(} "00\);_(*}(} "00\);_(* 20% - Accent1H 20% - Accent1 ef  20% - Accent2H" 20% - Accent2 ef  20% - Accent3H& 20% - Accent3 ef  20% - Accent4H* 20% - Accent4 ef  20% - Accent5H. 20% - Accent5 ef  20% - Accent6H2 20% - Accent6  ef  40% - Accent1H 40% - Accent1 L  40% - Accent2H# 40% - Accent2 L渷  40% - Accent3H' 40% - Accent3 L  40% - Accent4H+ 40% - Accent4 L  40% - Accent5H/ 40% - Accent5 L  40% - Accent6H3 40% - Accent6  Lմ  60% - Accent1H 60% - Accent1 23  60% - Accent2H$ 60% - Accent2 23ږ  60% - Accent3H( 60% - Accent3 23כ  60% - Accent4H, 60% - Accent4 23  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23  "Accent1<Accent1 O  #Accent2<!Accent2 PM  $Accent3<%Accent3 Y  %Accent4<)Accent4 d  &Accent5<-Accent5 K  'Accent6<1Accent6  F (Bad4Bad  ) Calculation| Calculation  } * Check Cellz Check Cell  ????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextB5Explanatory Text 0 : Followed Hyperlink 1Good6Good  a2 Heading 1B Heading 1 I}O3 Heading 2B Heading 2 I}?4 Heading 3B Heading 3 I}235 Heading 44 Heading 4 I}6( Hyperlink 7InputpInput ̙ ??v 8 Linked CellF Linked Cell } 9Neutral<Neutral  e"Normal :Noteb Note   ;OutputrOutput  ???????????? ???<$Percent =Title1Title I}% >TotalHTotal OO? Warning Text: Warning Text XTableStyleMedium9PivotStyleLight16`VTHERAPYB mINDEX/ DIAGNOSISnTHERAPYA  ; 8  (f b^ ̫.o}UymUS,yPl U_' ̫}OtC 6EٛD Tb5)jKQ|MV<ː Ir\KԴɳٽ8ܳ9!ë¿{°wɳmR(۳ꁢpgfZ:^+:.$+qz%$IAڈrzBi$ZSxdޖtZV R}WK'(;x^q8Yx.*Yy"+a\X}*8\^R+bS$3u+ *{H;n[߄oUrwOeo2u&~\,NsO-_'V3~ovQ!$ݶ^T4Vybzl-So&+gT)fkF}ǎ}i, דFӸ9$^Rui2$7elWW!'UOqGp2_ᅁJ?̃7fXO wMl00yƾ?J v2x8;%Sk5̋}#ϻzR.Ix"$Wn5=T9qrxiKXNZ^' Dd6e@L'鮵UDt;V_ %k?CkZnkt6 w65C6 ݰ-1v:A:kӓ}FO 11RIENDB`3 A@@  True Condition(Gold Standard)TrialPositiveNegativeResultsPositivePredictiveValue Negative Predicitive ValueEnter your data in the 5 red boxes. Sensitivity Specificity Sensitivity=Tis portion of true condition positives that were identified as positive by the trial Specificity=Tis portion of true condition negatives that were identified as negative by the trialPositive Pred. Value=POf those identified by the trial as Positive, this is the portion that really isNegative Pred. Value=POf those identified by the trial as Negative, this is the portion that really isTest Accuracy in % =HThe trial Results were correct for this percentage of the total subjectsPositive Likelihood Ratio=QIf you have the condition, how much more likely are you to have a + trial result?Negative Likelihood Ratio=WIf you don't have the condition, how much more likely are you to have a - trial result? Enter PreTest Probability here->(In decimal format)!Positive Post-Test Probability% =PThe Probability that a SPECIFICITY trial result will RULE IN a condition( SP in) Negative Post-Test Probability%=WThe probability that a SENSITIVE negative trial result will RULE OUT a condition(SNout)EVENT Non-EVENT TREATMENTFill in the red numbered boxesCONTROL$Control Event rate = CER =Control Event/Total control =%Exper. Event rate = EER = Treatment Event/Total treatment= |EER - CER| = |ARR/CER| =1/ARR =IEER is the rate that an event occurs in the Experimental treatment group. Back to Index Totals^CER is the rate that an event occurs in the control group without the Experimental treatment.Mean of TreatmentA=Mean of TreatmentB= Standard Dev of A= Standard Dev of B= # of subjects in Treat A # of subjects in Treat B Physical Therapy School of Fill in the information inthe red boxes. The Back to Index, Statistics use in Evidence Based Practice Ken Bush, PhD, P.T. TOU95% CI for NNT is the range in which the NNT would expect to be found 95% of the time/Use with PROSPECTIVE STUDIES (Cohort or RCT's) 6Use with RETROSPECTIVE STUDIES or CASE CONTROL studies Effect SizePercentile StandingPercent of NonoverlapLARGEMEDIUMSMALLKEffect size is the number of standard deviations one score is above anotherFAnything over .8 is considered to be a large effect. See table below:'For Interpretation of this table, goto:Xhttp://web.uccs.edu/lbecker/Psy590/es.htm#1.%20Standardized%20difference%20between%20two'This table is from WEB.UCCS.edu/lbeckertClick here for Statistics on Therapy where data is score data: Effect Size, Mean difference, Confidence Intervals>http://www.cemcentre.org/ebeuk/research/effectsize/default.htmOr:Mean difference = Pooled sd =SD= Mean Difference = effect size and CI will ( <10)? )Q * Note: This effect size is calculated from the means and standard deviationsFof two independent means. Repeated measures effect size calculationsEor effect sizes based upon other data will require other calculators.#Other calculations may be found at:Lhttp://www.work-learning.com/white_papers/effect_sizes/Effect_Sizes_pdf5.pdfEffect Size(Between) =Effect size (Within) =If data is repeated measures,+Treatment A should be the before treatment.RR =EER/CER= Odds Ratio = (a/b)/(c/d)=WARR is the amount that risk decreases from the control group to the experimental group. Big ARR = Effective Rx aRelative Risk(RR) is a measure of the association between the presence or absence of an event and! presence or absence of exposure.TOdds ratio is how much more likely an event is in the treatment group as compared tothe non-treatment groupbRRR is the amount that the risk would decrease in the general population if all got the treatment.$if we continued to repeat the study.e OR>1 indicates increase in event, given treatment. OR<1 indicates decreased event given treatment.Click here for Statistics on THERAPY where data is categorical: ARR, RRR, NNT, Confidence Intervals, Odds Ratios or Relative RiskQNNT is the number that must be treated to have one additional successful outcome.qIf the likelihood of the event in the general population is less than 1%, the Odds ratio is approx = to the RR. mClick here for Statistics on DIAGNOSIS: Sensitivity, Specificity, +/-Predictive Values, Likelihood Ratios.Pos LR=Neg LR = ORK Enter Sensitivity, specificity and PreTest probability (IN RED) below: Sensitivity(in decimal) = Specificity (in decimal)= Avge sd=Mean 95%Confidence IntervalNNT or NNH(if -)=  ARR(or ARI if -) or ABI =  RRR(or RRI if -) or RBI =  1 (Use to compare findings of different studies) (Wald Method) 95% Confidence interval:LowerUpper Confidence Interval TO,to the left. Estimate tobe in blue or green PredictionA BCTEbFGHIJK GMU N O zQSTUccB g2ɀ '!_kil  dMbP?_*+%&?'?(?)?M\\WHITNEY\HPC-334_PT0 odX+L@''''j-XX<-XX<-XX<-(None)(None)(None)(None)> <+"dXX??&U} } m }  '   h h h h h h ; h h h h h                 !"yyyyyy H/ Hz~ {@| |7 |z  [ H0 Hz~ J@ 8 z  \ H1 Hz~ J@ R  zN H2 HzJfffff3@  z  N% zG@@ DDA H3z~ J"@ z  O[  F6@ EDDDDDD DD A H4 z~ {@ |||z t& fffff5@ DD y Du Q uzG@@ D  v; w_Y+#@ %D D DD A x<; wp<jL@ %D D DD A HY! K&J`?  D D , K@AV? D \(\?D  t, Ku/i@ D \(\?D  PS 2? =DD DD D D DD A H HZ K! Xm#;?  D D K G HH FHXX P9 R@ SA SBT JSS@S@UʡE? HSSg@S@U rh? ISSf@S@US㥛?  MSS@e@SW@UT㥛 ? LSSd@SW@U1Zd?SS?S9@U9v? TSSa@S@Un? USS@`@SV@UL7A`? VSS^@SV@UCl?SS?~ SU@U +?SS?SU@U|?5^? W  XSSV@ST@UPn? RCST@SS@UtV?SSQ@SS@UE@ S SN@S@R@ U r? !RD!S?S@Q@U@@"S"SD@SP@"UK7?D l^PF}p_B@@@@2@@@2<N26&2*#$%&#S#S>@SO@#U$C? $RE$S4@SM@$U7A`?%S%S$@SK@%UʡE?&S&SSI@V <262<          D >@  7^yK  Back to Index INDEX!A1ggD g2ɀ Yz|  dMbP?_*+%&?'?(?)?M \\whitney\HPC-355_PT CanonIR 3F  odXLetterCanon e Canon iR3570/iR4570 PCL6 ddd      d d d d d dd@@d  d  d dd d"edd     ddd     d!!d      !"#$ddA     A d     H8o @*/ o @*/ AXXd2 Arial\SRGBCO~1.ICM\SRGBCO~1.ICM\SRGBCO~1.ICM CONFIDENTIALCONFIDENTIALHArialDefault Settings@"dXX??&U  h h h  h h h hhh; Q J6 J5 J M; @: HHHHHHHHHHHHH sm sssssssssHHH HHHHHHHHHHHHH sjssssssssssss HHHHHHHHHHHHH sK&ssssssssssssssssDDDDDDDDDD ^ $0$0$8(    |A??PaciLogo03Picture 6PaciLogo03 ]&`>@7 yK nClick here for Statistics on DIAGNOSIS: Sensitivity, Specificity, +/-Predictive Values, Likelihood Ratios. DIAGNOSIS!A1J yK Click here for Statistics on THERAPY where data is categorical: ARR, RRR, NNT, Confidence Intervals, Odds Ratios or Relative Risk THERAPYA!A1*yK uClick here for Statistics on Therapy where data is score data: Effect Size, Mean difference, Confidence Intervals THERAPYB!A1ggD g2ɀ   dMbP?_*+%&?'?(?)?M \\whitney\HPC-355_PT CanonIR 3F  odXLetterCanon e Canon iR3570/iR4570 PCL6 ddd      d d d d d dd@@d  d  d dd d"edd     ddd     d!!d      !"#$ddA     A d     H8o @*/ o @*/ AXXd2 Arial\SRGBCO~1.ICM\SRGBCO~1.ICM\SRGBCO~1.ICM CONFIDENTIALCONFIDENTIALHArialDefault Settings@"dX??&U} }  } }  } m } $ } I      hh+; AA B BB YL A AA Y LC؆@Cp@#AH@ % D DEL LCS@Cp@#A@ %0 D DE ZL#AH@ %D#A@ %#A&@ %DE O ZL A A A O  H~ZLAAA  H|  H} Y L((g*?DDD D DDbbDDDD B ;zC?,D\(\?DDDAB Tɐ? ,D\(\?DDDAD Y L(F 'u_?DDD DDDbbDDDD A d*$9? +D\(\?DDD@AA d ? +D\(\?DDD@AD Y L( F,^^?DDD D DcDDDDDDDDD Y L( Fu8~k? DDD D DDDDDDDDDDD Y L? G*phU@ )DDDDDDd D DDDDDDDDDDD Y L& ۩@DD D DDDDDDDDDDD Y L= N P ?'DDDDDD D DDDDDDDDDDD LL [L~ ? H LL YYJ֪cU@ 4DDDDDDd I YL?n$@ )D DD DDd I} p ~} \q ~} \r~ 6@~ n&;@ DD} \sX9v?~ o&*RJ)?DD \~ T@  }}JflWX@4DDDDDDd ~ }\? R@)DDDDDd ~  P,<W *>04<<T0        PH 0(  >@7VyK Back to Index INDEX!A1ggD g2ɀ v¹  dMbP?_*+%&?'?(?)?M \\cook\PT-Copier7  odXLetterCanon   9Canon iR3235/iR3245 PCL5euddd      d d d d d dd@@d  d  d dd d"edd !',  )ddd      !"#$%&'()*-./089:1234567>?@ABd!!d     d !"#$%&'()*+,-/dA     Ad      d@8 o @*/ o @*/ AXXd2 Arial\SRGBCO~1.ICM\SRGBCO~1.ICM\SRGBCO~1.ICM CONFIDENTIALCONFIDENTIALHArialDefault Settings @ "dXX??&U} } $ } } } $ } m}  } } hhhhh h h h h hhh h h h h h h h h A B B B!C @C7@#L?@ %D " B#C@C;@#L>@ %D  H-$L&@$$B#L;@ %#LN@  %D H L{ H$H M%(? DDD^fr__ H&H L'(B!?DDDi____ HwH M(O"g;TCu;Ŀ DDhbg^!ֿ LD@\(\?DDDDDDA  h<b g8)g? LD@\(\?DDDDDDA _W HxH M)O"jI)RJ DDkqA D   q< q\LI? D  _ HvH M*OKTr ^N D `Sbl6 (@@LD\(\?DDDDDDA  m<b lwd*" LD\(\?DDDDDDA  az H] H M^ O! fRJ)@  DD ^f f)y-? PD A\(\?DDDDDDDDAA e<f fӠ!@PD A\(\?DDDDDDDDAA _ ] H_ H M`/ n,d! @ DDDD o] n^_j?GD A\(\?DDDDAA pZ ntd*@ DD A\(\?DDDDAA _ H. H+ ] ] Ha b Hg  y Hk H= HhHHH Hc HHH Hd HHH H> HeHHHHHK Hf HH H? HH Hi P, l6 &YYffNIU:",,80  l K \  DPH0 0(   >@  7VyK Back to Index INDEX!A1ggD Oh+'0HP\h TICUISMicrosoft Excel@,1M@*ܳ@§՜.+,D՜.+,t0 PXt | 91ѡ  THERAPYBINDEX DIAGNOSIS THERAPYATHERAPYA!Print_Area  Worksheets Named Ranges  8@ _PID_HLINKSA$ INDEX!A1(i THERAPYB!A1(j THERAPYA!A1  DIAGNOSIS!A1 INDEX!A1 INDEX!A1  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]_`abcdeghijklmRoot Entry FaWorkbookDSummaryInformation(^DocumentSummaryInformation8f