ÐÏࡱá>þÿ ~þÿÿÿþÿÿÿ}ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ZOÍÉá°Áâ\pSusan Richardson B°aÀ=œ¯¼=ÿÿ€pÑ.8X@�"·Ú1Èÿ�-Arial1Èÿ�-Arial1Èÿ�-Arial1Èÿ�-Arial1Èÿ¼-Arial1Èÿ�-Arial1Èÿ�-Arial1ðÿ¼-Arial1Èÿ¼-Arial1ÿ¼-Arial1*h6�U Calibri Light1,6¼UCalibri16¼UCalibri1Ü6¼UCalibri1Ü�UCalibri1Ü�UCalibri1Ü<�UCalibri1Ü>�UCalibri1Ü?¼UCalibri1Ü4¼UCalibri1Ü4�UCalibri1Ü ¼UCalibri1Ü �UCalibri1Èÿ�UArial1Ü�UCalibri1ܼUCalibri1Ü �UCalibri1Ü�UCalibri"$"#,##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.0000000 ¥0.000000 ¦0.0000§"Yes";"Yes";"No"¨"True";"True";"False"©"On";"On";"Off"]ª,[$¬ -2]\ #,##0.00_);[Red]\([$¬ -2]\ #,##0.00\)àõÿ À àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ àõÿ ôÀ à À àõÿ ´Ÿ àõÿ ´¯ àõÿ ´‰ àõÿ ´š àõÿ ´› àõÿ ´ª àõÿ ´¬ àõÿ ´¯ àõÿ ´– àõÿ ´« àõÿ ´¬ àõÿ ´« àõÿ ´± àõÿ ´¯ àõÿ ´– àõÿ ´« àõÿ ´¬ àõÿ ´¹ àõÿ ´¾ àõÿ ´µ àõÿ ´· àõÿ ´³ àõÿ ´± àõÿ ´¹ àõÿ ´­ àõÿ ”— — – àõÿ ”ff¿¿· à+õÿ øÀ à)õÿ øÀ à,õÿ øÀ à*õÿ øÀ àõÿ ôÀ àõÿ ´ª à õÿ ÔPÀ à õÿ ÔPÀ àõÿ Ô €À àõÿ ôÀ àõÿ ”— — ¯ àõÿ Ô`À àõÿ ´« àõÿ œ  š àõÿ ”¿¿– à õÿ øÀ à õÿ ôÀ àõÿ Ôa>À àõÿ ôÀ à À à!X* à @* à"X* à&X* à H* à!X) à H) à @) à X) ठÀ ॠL) à!X à @ à H ঠD à @À à"Ð/ à(À à"Ð+ à!X* à!X) à!X àÀ à#À à"PÀ à)À à)À à"À àÀ à)À à!À à !À àÀ à À àÀ ||bS'èº}-}; 00_)}A}1 00_)[$¬ -}A}2 00_)ÿ?[$¬ -}A}3 00_)23[$¬ -}-}4 00_)}A}0 aÿ00_)ÆïÎÿ[$¬ -}A}( œÿ00_)ÿÇÎÿ[$¬ -}A}7 œWÿ00_)ÿëœÿ[$¬ -}‘}5 ??vÿ00_)ÿÌ™ÿ[$¬ -ÿ##0.ÿ ÿ ÿ}‘}9 ???ÿ00_)òòòÿ[$¬ -???ÿ##0.???ÿ ???ÿ ???ÿ}‘}) ú}ÿ00_)òòòÿ[$¬ -ÿ##0.ÿ ÿ ÿ}A}6 ú}ÿ00_)ÿ€ÿ[$¬ -}‘}* 00_)¥¥¥ÿ[$¬ -???ÿ##0.???ÿ ???ÿ ???ÿ}-}= ÿÿ00_)}x}8ÿÿÌÿ00_)²²²ÿ¥¥¥ÿ[$²²²ÿ???ÿ## ²²²ÿ???ÿ ²²²ÿ???ÿ}-}/ ÿ00_)}U}< 00_)[$## }A}" 00_)[$}A} 00_)ef[$}A} 00_)ÌL[$}A} 00_)23[$}A}# 00_)[$}A} 00_)ef[$}A} 00_)ÌL[$}A} 00_)23[$}A}$ 00_)[$}A} 00_)ef[$}A} 00_)ÌL[$}A} 00_)23[$}A}% 00_)[$}A} 00_)ef[$}A} 00_)ÌL[$}A} 00_)23[$}A}& 00_)[$}A} 00_)ef[$}A} 00_)ÌL[$}A}  00_)23[$}A}' 00_) [$}A} 00_)ef [$}A} 00_)ÌL [$}A}! 00_)23 [$“ 20% - Accent1’M’ÿ 20% - Accent1 efÙáòÿ ÿ%“ 20% - Accent2’M’"ÿ 20% - Accent2 efüäÖÿ ÿ%“ 20% - Accent3’M’&ÿ 20% - Accent3 efíííÿ ÿ%“ 20% - Accent4’M’*ÿ 20% - Accent4 efÿòÌÿ ÿ%“ 20% - Accent5’M’.ÿ 20% - Accent5 efÝë÷ÿ ÿ%“ 20% - Accent6’M’2ÿ 20% - Accent6  efâïÚÿ ÿ%“ 40% - Accent1’M’ÿ 40% - Accent1 ÌL´Æçÿ ÿ%“ 40% - Accent2’M’#ÿ 40% - Accent2 ÌLøË­ÿ ÿ%“ 40% - Accent3’M’'ÿ 40% - Accent3 ÌLÛÛÛÿ ÿ%“ 40% - Accent4’M’+ÿ 40% - Accent4 ÌLÿæ™ÿ ÿ%“ 40% - Accent5’M’/ÿ 40% - Accent5 ÌL½×îÿ ÿ%“ 40% - Accent6’M’3ÿ 40% - Accent6  ÌLÆà´ÿ ÿ%“ 60% - Accent1’M’ ÿ 60% - Accent1 23Ž©Ûÿ ÿ%“ 60% - Accent2’M’$ÿ 60% - Accent2 23ô°„ÿ ÿ%“ 60% - Accent3’M’(ÿ 60% - Accent3 23ÉÉÉÿ ÿ%“ 60% - Accent4’M’,ÿ 60% - Accent4 23ÿÙfÿ ÿ%“ 60% - Accent5’M’0ÿ 60% - Accent5 23›Âæÿ ÿ%“! 60% - Accent6’M’4ÿ 60% - Accent6  23©ÐŽÿ ÿ%“ "Accent1’A’ÿAccent1 DrÄÿ ÿÿÿÿ%“ #Accent2’A’!ÿAccent2 í}1ÿ ÿÿÿÿ%“ $Accent3’A’%ÿAccent3 ¥¥¥ÿ ÿÿÿÿ%“ %Accent4’A’)ÿAccent4 ÿÀÿ ÿÿÿÿ%“ &Accent5’A’-ÿAccent5 [›Õÿ ÿÿÿÿ%“ 'Accent6’A’1ÿAccent6  p­Gÿ ÿÿÿÿ%“(Bad’9’ÿBad ÿÿÇÎÿ ÿœÿ%“) Calculation’�’ÿ Calculation ÿòòòÿ ÿú}ÿ%ÿÿÿÿÿÿ ÿÿ“* Check Cell’’ÿ Check Cell ÿ¥¥¥ÿ ÿÿÿÿ%ÿ???ÿÿ???ÿÿ???ÿ ÿ???ÿ“+€ÿ’ ’ÿComma“,€ÿ’(’ÿ Comma [0]“-€ÿ’&’ÿCurrency“.€ÿ’.’ÿ Currency [0]“/Explanatory Text’G’5ÿExplanatory Text ÿÿ%“ 0Good’;’ÿGood ÿÆïÎÿ ÿaÿ%“1 Heading 1’G’ÿ Heading 1 DTjÿ%DrÄÿ“2 Heading 2’G’ÿ Heading 2 DTjÿ%ÿ?¢¸áÿ“3 Heading 3’G’ÿ Heading 3 DTjÿ%23Ž©Ûÿ“4 Heading 4’9’ÿ Heading 4 DTjÿ%“ 5Input’u’ÿInput ÿÿÌ™ÿ ÿ??vÿ%ÿÿÿÿÿÿ ÿÿ“6 Linked Cell’K’ÿ Linked Cell ÿú}ÿ%ÿÿ€ÿ“ 7Neutral’A’ÿNeutral ÿÿëœÿ ÿœWÿ%“€ÿ’"’ÿNormal“ 8Note’b’ ÿNote ÿÿÿÌÿÿ²²²ÿÿ²²²ÿÿ²²²ÿ ÿ²²²ÿ“ 9Output’w’ÿOutput ÿòòòÿ ÿ???ÿ%ÿ???ÿÿ???ÿÿ???ÿ ÿ???ÿ“:€ÿ’$’ÿPercent“ ;Title’1’ÿTitle DTjÿ%“ <Total’M’ÿTotal ÿ%DrÄÿDrÄÿ“= Warning Text’?’ ÿ Warning Text ÿÿÿ%ŽXŽ�TableStyleMedium2PivotStyleLight16`…BSheet1…jSheet2…¡kSheet3šš££ŒÁÁ5êfNfð8ð@ñÿÿÿ€€€÷ëZðRð3 ð¿�AÀ@@ñ  ÷ü,Compute z-test from 95% confidence intervalsStep 2: Input sectionStep 3: Percent Plus or minusOutput sectionp-value: Calculationspooled standard error Z-statistic•This spreadsheet computes the p-value for a test of the difference between two point estimates, given ther 95% confidence intervals and sample sizes.äNote: This spreadsheet implements a standard z-test for the difference in two means. (See Fisher, L.D. and van Belle, G. (1993). Biostatistics, a Methodology for the health Sciences, First Edition. NY: Wiley and Sons. Page 163.)Your local resultState (or comparison) result Local Result State Result6Is your local result different from the state result? eIf this p-value is less than 0.05, then your result is significantly different from the state result.Step 1: Step 4: 7Enter the percent you are comparing in orange cell B12.pEnter the margin of error (the number in parentheses with a ±, on the right of your percent) in yellow cell D12.7Enter the percent you are comparing in orange cell B11.pEnter the margin of error (the number in parentheses with a ±, on the right of your percent) in yellow cell D11.HHow to Determine if Your Local Result is Different from the State ResultxUse this test ONLY if there are 30 or more students for the local results and 30 or more students for the state results.‚Do NOT use this test if one of the percents is either 0% or 100%, as the z-test for proportions is not valid in that circumstance.ÿ"\/ ç/—Ý1�Š3:cc–W – ŒPK!éÞ¿ÿ[Content_Types].xml¬‘ËNÃ0E÷Hüƒå-Jœ²@%é‚ÇŽÇ¢|ÀÈ™$ÉØ²§Uû÷LÒTB¨ l,Ù3÷ž;ãr½µÃ˜œ§J¯òB+$ëG]¥ß7OÙ­V‰�~&}�"!ᇺ_ÐþÆÎ� ´=¢r�¬!×Ñs¹¹Àh²©÷äÁ Û´T*—*»™~  r×®¶+íJ¦OÐp'M¹Ø:«›ÍÒk€Ò¯Ý­jk«há ý[+œwËêcá5(Õ_ZÁw:M°¢…× _^Á—µFËÖ¯A)¾²‚¯v[¥ª¥_ƒBJâÉ ºP®l5§Í cF÷œðZ¹Ô©nΕç(ˆ†,ºÔcËu±¡cÆ;P@Š$‰=9Kð !Š›ˆ’'Þ> B¼ÅLÀra³Ð)lÁõ)éoÚ£h#CZñ&beIññÄ�“DÖý Õ7 oß¼9{þúìùog/^œ=ÿe¾·VeÉí¡80åÞÿøõßßáýõëï_~“n½Œ&þÝÏ_¾ûý�©‡ç¦xûí«w¯_½ýî«?zéоËÑÀ„÷I„…w€O½G,‚:øã¿œD?DÄ’@!èv¨nËÐÌuáØ6áYƼ7=¶¸öB>•ıóÃ0²€]Æhƒq§ª½ ÷§qàÞœOMÜ#„N\{7Ql9¸=M ½—Êfˆ-šGÅ8ÆÒS¿± ÆŽÓ=%IJk— 9l,½§Äk â4IŸ ¬@Ê…öH~™¹‚«-ÛtŸx F]§ná ·¢ò}L-3ÞCS‰"—Ê>Ѝið}$CÉÞŒM\[Hðt€)óÚ#,„Kæ�Ãy §?„ ãv{—Î"É%™¸tî#ÆLd‹Mš!жGâÐÄÞQä1é‚w™}‡¨kðŠ×ºû Á–»ÏO�!¹š”òQ¿L¹Ã—÷0³â·7£c„]Yf—GVvÝåÄ�i`…ö>Æ�¢ÆÞãû –X6ÏI?!«ìaW`=@v¬ªë h“T_³š"÷‰°B¶‡¶†Ow¶”xf(Ž_§ù¼nÚ¼ UΙJépb´/N£ Ða÷Z­G!²j—ºîx�q˹Çà¾<¶h\à¾|iHì¦ÌmÓGÔÚ ˜>‚ÕnAÄr.¢êª›:åÆöM›»#«ß‰H|nó³Ôö”ÿ�¶Çq7\OÃãVl¥¬K¶:ëRÊÞRƒ³÷lkZha¨$«9릫¹éjüÿ}W³î^¾éeÖu7½Œ=ÆM/3Ÿ¬\O/“·/ÐÙ¨iG:åÑ3ŸhíÈgL(íÉÅûBO}<ÑŒ:°¨äô¸g#À$„¯ªÌÁ.àHËxœÉω {!J`4Tô•’@ÌUÂK˜€‰‘^vêVx:�ºl”N:‹E5ÕL+«@2_/”³u˜RÉ]©æÓ»L½fè)ë‚€’½ c3›Ä–ƒDu±¨Œ¤gº`4 }²kaQs°¸­Ô/\µÂ¨e^�GnÔë~¹" Ã8hÏGÊO©«ÞÕμNO¯3¦Ðb/" ÷tMq]{9•f//Uncompressed-Data//Q§¬cTCKãbb``dðbðaHeÈeHbHdHfÈ`# 022*ÙØWäæ(”¥gæçÙ*ê()¤æ%ç§dæ¥Û*…†¸éZ(ÙÛñrÙWd¦)[å$‚¤RótCƒ•@2ú`);ÿÿÿÿTCOM5>>>>>>¡"dXXà?à?œ&œÝcýU} ¶ } ¶ } I} ¶ } ¶} ¶ } } ’ } ¶ } ’} $} ¶ à@Ã@@:@þ@þ@¤@†@X@ á@ ¤@ @  @ ÿ@†@,@ Ã@ x@ ; ÿ ÿ K@ I@ ÿ@ý ^¾^^^^^^^^^^ ¾ZZZZZZZZZZZ ý ]¾]]]]]]]]]] ý _ ¾__________ ý `¾``````````> ý `¾aaaaaaaaaa> ¾@??@@ý ] ¾]]]]]> ý R¾AABBý Uý [¾[[[[ ¾@@@@@ý Vý Y¾YYYY  @ý A Aý A¾ @ZZZZZZZZZ ý C~ O<@ A~ Q @ @ý ]¾ ]]]]] ý C~ O@ @ A~ Qø? @ý Uý [¾ [[[[ ¾ @@@@@ý Vý Y¾ YYYY ¾ ZZZZZZZZZZZ ý S¾DEEEFFý \¾ \\\ Fý GG*H`!­]™+? ýDÀAA&¾ EFIý X¾ XXX ¾FGGFEFIXXXX ¾ZZZZZZZZZZZ ý T¾JKKKKKZZZZ Ký K ¾ LLLFM »­´ÿ? þ0D À\�Âõ(\ÿ?D À\�Âõ(\ÿ?@A¾KZZZZN Ký K ¾ LLL(MÊ^ˆß¥ @ ÿD ÀD ÀDÀ¾KZZZZ ¾WWWWWWWWWWW ý X ¾XXXXXXXXXX ¾PPPPPPPPPPP ×4¬Ì, ,,..8NBN`lB B~ ,ˆh ,ìâðÚððÂð( ð ððŠB ðÀ ³ ðPï¿¿À@˽`Ñÿ?€Ã¿Line 1ð¢sô€ð]`>¶@‹‹  ™¶ å¢                   ï7ggÿÿÿÿ@ ZOÍÉ #k  dü©ñÒMbP?_*+‚€%ÿ�Áƒ„&è?'è?(ð?)ð?¡"ÿÿà?à? œ&œU>¶@‹‹ï7ggÿÿÿÿD ZOÍÉ ³l  dü©ñÒMbP?_*+‚€%ÿ�Áƒ„&è?'è?(ð?)ð?¡"ÿÿà?à?œ&œU>¶@‹‹ï7ggÿÿÿÿD þÿ à…ŸòùOh«‘+'³Ù0Tz X`œÔð   ,4ä4HYS Tool for Determining Statistical Significance0Healthy Youth Survey Planning Committee (HYSPC)Susan RichardsonMicrosoft Excel@€ÄÝe•É@?]Ïe•É@€ž‚“i�ÚGyÿÿÿÿ9 ƒ<Ó  Ø.'ÿÿ'ÿÿû¼"Systemüåv¨õH(0Ï6.u- ÿÿÿ. ú-üÿÿÿ-'ÿÿÿÿÿ ×-'ÿÿÿÿÿ ×-'ÿÿÿÿÿ ×-ü«««- «««ú«««-×ú- @ !ðÆü-üÿÿÿ-×-úÿÿÿ-üñññ- -$--ð üððð- -$--ð üîîî- -$--ð üííí- -$--ð üììì- -$--ð üêêê- -$--ð üééé- -$--ð üèèè- -$  --ð üæææ- -$     --ð üååå- -$     --ð üäää- -$     --ð üããã- -$     --ð üâââ- -$   --ð üááá- -$--ð üààà- -$--ð üßßß- -$--ð üÝÝÝ- -$--ð üÜÜÜ- -$--ð üÛÛÛ- -$--ð üÙÙÙ- -$--ð üØØØ- -$--ð ü×××- -$--ð üÕÕÕ- -$--ð -'ÿÿ'ÿÿ--×--üñññ- -$01100--ð üððð- -$01100--ð üîîî- -$01100--ð üííí- -$01100--ð üììì- -$01100--ð üêêê- -$01100--ð üééé- -$01100--ð üèèè- -$01 1 00--ð üæææ- -$ 0 1 1 0 0--ð üååå- -$ 0 1 1 0 0--ð üäää- -$ 0 1 1 0 0--ð üããã- -$ 0 1 1 0 0--ð üâââ- -$ 0 110 0--ð üááá- -$01100--ð üààà- -$01100--ð üßßß- -$01100--ð üÝÝÝ- -$01100--ð üÜÜÜ- -$01100--ð üÛÛÛ- -$01100--ð üÙÙÙ- -$01100--ð üØØØ- -$01100--ð ü×××- -$01100--ð üÕÕÕ- -$01100--ð -'ÿÿ'ÿÿ--×--üñññ- -$=>>==--ð üððð- -$=>>==--ð üîîî- -$=>>==--ð üííí- -$=>>==--ð üììì- -$=>>==--ð üêêê- -$=>>==--ð üééé- -$=>>==--ð üèèè- -$=> > ==--ð üæææ- -$ = > > = =--ð üååå- -$ = > > = =--ð üäää- -$ = > > = =--ð üããã- -$ = > > = =--ð üâââ- -$ = >>= =--ð üááá- -$=>>==--ð üààà- -$=>>==--ð üßßß- -$=>>==--ð üÝÝÝ- -$=>>==--ð üÜÜÜ- -$=>>==--ð üÛÛÛ- -$=>>==--ð üÙÙÙ- -$=>>==--ð üØØØ- -$=>>==--ð ü×××- -$=>>==--ð üÕÕÕ- -$=>>==--ð -'ÿÿ'ÿÿ--×--üñññ- -$OPPOO--ð üððð- -$OPPOO--ð üîîî- -$OPPOO--ð üííí- -$OPPOO--ð üììì- -$OPPOO--ð üêêê- -$OPPOO--ð üééé- -$OPPOO--ð üèèè- -$OP P OO--ð üæææ- -$ O P P O O--ð üååå- -$ O P P O O--ð üäää- -$ O P P O O--ð üããã- -$ O P P O O--ð üâââ- -$ O PPO O--ð üááá- -$OPPOO--ð üààà- -$OPPOO--ð üßßß- -$OPPOO--ð üÝÝÝ- -$OPPOO--ð üÜÜÜ- -$OPPOO--ð üÛÛÛ- -$OPPOO--ð üÙÙÙ- -$OPPOO--ð üØØØ- -$OPPOO--ð ü×××- -$OPPOO--ð üÕÕÕ- -$OPPOO--ð -'ÿÿ'ÿÿ--×--üñññ- -$uvvuu--ð üððð- -$uvvuu--ð üîîî- -$uvvuu--ð üííí- -$uvvuu--ð üììì- -$uvvuu--ð üêêê- -$uvvuu--ð üééé- -$uvvuu--ð üèèè- -$uv v uu--ð üæææ- -$ u v v u u--ð üååå- -$ u v v u u--ð üäää- -$ u v v u u--ð üããã- -$ u v v u u--ð üâââ- -$ u vvu u--ð üááá- -$uvvuu--ð üààà- -$uvvuu--ð üßßß- -$uvvuu--ð üÝÝÝ- -$uvvuu--ð üÜÜÜ- -$uvvuu--ð üÛÛÛ- -$uvvuu--ð üÙÙÙ- -$uvvuu--ð üØØØ- -$uvvuu--ð ü×××- -$uvvuu--ð üÕÕÕ- -$uvvuu--ð -'ÿÿ'ÿÿ--×--üñññ- -$—˜˜——--ð üððð- -$—˜˜——--ð üîîî- -$—˜˜——--ð üííí- -$—˜˜——--ð üììì- -$—˜˜——--ð üêêê- -$—˜˜——--ð üééé- -$—˜˜——--ð üèèè- -$—˜ ˜ ——--ð üæææ- -$ — ˜ ˜ — —--ð üååå- -$ — ˜ ˜ — —--ð üäää- -$ — ˜ ˜ — —--ð üããã- -$ — ˜ ˜ — —--ð üâââ- -$ — ˜˜— —--ð üááá- -$—˜˜——--ð üààà- -$—˜˜——--ð üßßß- -$—˜˜——--ð üÝÝÝ- -$—˜˜——--ð üÜÜÜ- -$—˜˜——--ð üÛÛÛ- -$—˜˜——--ð üÙÙÙ- -$—˜˜——--ð üØØØ- -$—˜˜——--ð ü×××- -$—˜˜——--ð üÕÕÕ- -$—˜˜——--ð -'ÿÿ'ÿÿ--×--üñññ- -$¹ºº¹¹--ð üððð- -$¹ºº¹¹--ð üîîî- -$¹ºº¹¹--ð üííí- -$¹ºº¹¹--ð üììì- -$¹ºº¹¹--ð üêêê- -$¹ºº¹¹--ð üééé- -$¹ºº¹¹--ð üèèè- -$¹º º ¹¹--ð üæææ- -$ ¹ º º ¹ ¹--ð üååå- -$ ¹ º º ¹ ¹--ð üäää- -$ ¹ º º ¹ ¹--ð üããã- -$ ¹ º º ¹ ¹--ð üâââ- -$ ¹ ºº¹ ¹--ð üááá- -$¹ºº¹¹--ð üààà- -$¹ºº¹¹--ð üßßß- -$¹ºº¹¹--ð üÝÝÝ- -$¹ºº¹¹--ð üÜÜÜ- -$¹ºº¹¹--ð üÛÛÛ- -$¹ºº¹¹--ð üÙÙÙ- -$¹ºº¹¹--ð üØØØ- -$¹ºº¹¹--ð ü×××- -$¹ºº¹¹--ð üÕÕÕ- -$¹ºº¹¹--ð -'ÿÿ'ÿÿ--×--üñññ- -$ÕÖÖÕÕ--ð üððð- -$ÕÖÖÕÕ--ð üîîî- -$ÕÖÖÕÕ--ð üííí- -$ÕÖÖÕÕ--ð üììì- -$ÕÖÖÕÕ--ð üêêê- -$ÕÖÖÕÕ--ð üééé- -$ÕÖÖÕÕ--ð üèèè- -$ÕÖ Ö ÕÕ--ð üæææ- -$ Õ Ö Ö Õ Õ--ð üååå- -$ Õ Ö Ö Õ Õ--ð üäää- -$ Õ Ö Ö Õ Õ--ð üããã- -$ Õ Ö Ö Õ Õ--ð üâââ- -$ Õ ÖÖÕ Õ--ð üááá- -$ÕÖÖÕÕ--ð üààà- -$ÕÖÖÕÕ--ð üßßß- -$ÕÖÖÕÕ--ð üÝÝÝ- -$ÕÖÖÕÕ--ð üÜÜÜ- -$ÕÖÖÕÕ--ð üÛÛÛ- -$ÕÖÖÕÕ--ð üÙÙÙ- -$ÕÖÖÕÕ--ð üØØØ- -$ÕÖÖÕÕ--ð ü×××- -$ÕÖÖÕÕ--ð üÕÕÕ- -$ÕÖÖÕÕ--ð -'ÿÿ'ÿÿ-ûóÿ� Arial-  DDDððð 2 1 2 . 2>2 2 @ 3 2 f 4 2 ˆ 5 2 ª 6 2 Æ 7-- «««ÿÿÿ--- @ !ð--×--üïïï- -$--ð üííí- -$--ð üììì- -$--ð üêêê- -$--ð üééé- -$--ð üççç- -$--ð üååå- -$--ð üããã- -$--ð üâââ- -$  --ð üààà- -$     --ð üÞÞÞ- -$     --ð üÜÜÜ- -$     --ð üÛÛÛ- -$     --ð üÙÙÙ- -$   --ð üØØØ- -$--ð üÖÖÖ- -$--ð üÔÔÔ- -$--ð -'ÿÿ'ÿÿ--×--üïïï- -$rrssr--ð üííí- -$rrssr--ð üììì- -$rrssr--ð üêêê- -$rrssr--ð üééé- -$rrssr--ð üççç- -$rrssr--ð üååå- -$rrssr--ð üããã- -$rrssr--ð üâââ- -$rr s sr--ð üààà- -$r r s s r --ð üÞÞÞ- -$r r s s r --ð üÜÜÜ- -$r r s s r --ð üÛÛÛ- -$r r s s r --ð üÙÙÙ- -$r rss r --ð üØØØ- -$rrssr--ð üÖÖÖ- -$rrssr--ð üÔÔÔ- -$rrssr--ð -'ÿÿ'ÿÿ--×--üïïï- -$ÄÄÅÅÄ--ð üííí- -$ÄÄÅÅÄ--ð üììì- -$ÄÄÅÅÄ--ð üêêê- -$ÄÄÅÅÄ--ð üééé- -$ÄÄÅÅÄ--ð üççç- -$ÄÄÅÅÄ--ð üååå- -$ÄÄÅÅÄ--ð üããã- -$ÄÄÅÅÄ--ð üâââ- -$ÄÄ Å ÅÄ--ð üààà- -$Ä Ä Å Å Ä --ð üÞÞÞ- -$Ä Ä Å Å Ä --ð üÜÜÜ- -$Ä Ä Å Å Ä --ð üÛÛÛ- -$Ä Ä Å Å Ä --ð üÙÙÙ- -$Ä ÄÅÅ Ä --ð üØØØ- -$ÄÄÅÅÄ--ð üÖÖÖ- -$ÄÄÅÅÄ--ð üÔÔÔ- -$ÄÄÅÅÄ--ð -'ÿÿ'ÿÿ--×--üïïï- -$ÍÍÎÎÍ--ð üííí- -$ÍÍÎÎÍ--ð üììì- -$ÍÍÎÎÍ--ð üêêê- -$ÍÍÎÎÍ--ð üééé- -$ÍÍÎÎÍ--ð üççç- -$ÍÍÎÎÍ--ð üååå- -$ÍÍÎÎÍ--ð üããã- -$ÍÍÎÎÍ--ð üâââ- -$ÍÍ Î ÎÍ--ð üààà- -$Í Í Î Î Í --ð üÞÞÞ- -$Í Í Î Î Í --ð üÜÜÜ- -$Í Í Î Î Í --ð üÛÛÛ- -$Í Í Î Î Í --ð üÙÙÙ- -$Í ÍÎÎ Í --ð üØØØ- -$ÍÍÎÎÍ--ð üÖÖÖ- -$ÍÍÎÎÍ--ð üÔÔÔ- -$ÍÍÎÎÍ--ð -'ÿÿ'ÿÿ--×--üïïï- -$  --ð üííí- -$  --ð üììì- -$  --ð üêêê- -$  --ð üééé- -$  --ð üççç- -$  --ð üååå- -$  --ð üããã- -$  --ð üâââ- -$  --ð üààà- -$     --ð üÞÞÞ- -$     --ð üÜÜÜ- -$     --ð üÛÛÛ- -$     --ð üÙÙÙ- -$     --ð üØØØ- -$  --ð üÖÖÖ- -$  --ð üÔÔÔ- -$  --ð -'ÿÿ'ÿÿ--×--üïïï- -$++,,+--ð üííí- -$++,,+--ð üììì- -$++,,+--ð üêêê- -$++,,+--ð üééé- -$++,,+--ð üççç- -$++,,+--ð üååå- -$++,,+--ð üããã- -$++,,+--ð üâââ- -$++ , ,+--ð üààà- -$+ + , , + --ð üÞÞÞ- -$+ + , , + --ð üÜÜÜ- -$+ + , , + --ð üÛÛÛ- -$+ + , , + --ð üÙÙÙ- -$+ +,, + --ð üØØØ- -$++,,+--ð üÖÖÖ- -$++,,+--ð üÔÔÔ- -$++,,+--ð -'ÿÿ'ÿÿ--   DDDððð 2 CA 2 ˜B 2 ÆÆÎC 2 óD 2 "E -üÿÿÿ-  ÿÿÿÿÿÿ @ !ðüððð-  ðððððð @ !ð-&&iA Ff  ( ÿÿÿßßß"""""""""""""""ÀB"""""""""""""""ÿ""""""""""""""""""""&&&--&&ü-  && & $& &&- $-&&&&&-&&&TNPP 'ÿÿ&&TNPP'ÿÿ'ÿÿ-   DDD-ð -'ÿÿððð DDD×-üÌÿÌ-  ÌÿÌ @ !ð7ºûíÿ¼ Arial-  ûóÿ¼ Arial-ûóÿ� Arial-ûóÿ¼ Arial------- üÿÿÿ--'ÿÿ- -  1-ÿÿÿs2 HHow to Determine if Your Local Result is Different from the State Result                 ---'ÿÿ-- ÿÿÿ P-?I2 @,Compute z-test from 95% confidence intervals    ---'ÿÿ-- ÿÿÿ v-QÓ2 RˆThis spreadsheet computes the p-value for a test of the difference between two point estimates, given ther 95% confidence intervals and      2 c sample sizes. -------------'ÿÿ-- ÿÿÿ ˜-w----"2 Use this test ONLY  ü- @ !ðr�- - 2 �f if there are 30 or more students for the local results and 30 or more students for the state results.  ----'ÿÿ-- ÿÿÿ >-22 .-----ð------'ÿÿ-- ÿÿÿ º-™----2 ¡Do NOT use this  ü- @ !ðh¯- -²2 ¡…rtest if one of the percents is either 0% or 100%, as the z-test for proportions is not valid in that circumstance.   ----'ÿÿ-- ÿÿÿ ×---'ÿÿ-- ÿÿÿ ×-üààà-ð  ààààààðúààà-º- @ !ð©-ss- @ !ðs-ÅÅ- @ !ðÅ-ÎÎ- @ !ðÎ-  - @ !ð -,,- @ !ð,-.- @ !ð-11.- @ !ð1->>.- @ !ð>-PP.- @ !ðP-vv.- @ !ðv-˜˜.- @ !ð˜-º-º.- @ !ðº--Ö-Ö.- @ !ðÖ---'ÿÿ-ààà ààà×-×--'ÿÿ-ààà ààà×-ü-  ÿÿÿðú--- @ !ð--×- @ !ð×-ð'ÿÿ#A †î×-(þÿ ÕÍÕœ.“—+,ù®0Ø PXd lt|„ Œ µä Sheet1Sheet2Sheet3  Worksheets  !"#$%&'()*+,-./0123456þÿÿÿ89:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstþÿÿÿvwxyz{|þÿÿÿýÿÿÿþÿÿÿÿÿÿÿRoot Entryÿÿÿÿÿÿÿÿ ÀFð¯8œ ÚþÿÿÿWorkbookÿÿÿÿÿÿÿÿÿÿÿÿ1mSummaryInformation(ÿÿÿÿ7„zDocumentSummaryInformation8ÿÿÿÿÿÿÿÿÿÿÿÿu