ࡱ> &(%q` bjbjqPqP .8:: XXXXXXXl$ll0psuuuuuu$h~XXX@@@XXs@s@@kXX$ P𶶊:T0,FXT@6 lllDllllllXXXXXX REGRESSION ANALYSIS ASSIGNMENT DUE March 27 Your Assignment: Using Excel or another program with plotting functions, construct two XY(scatter) graphs, one for  EMBED Equation.3 , one for ln( EMBED Equation.3 ). There will be two curves/lines on each graph, one for each group. Before printing and saving the graphs, remove the gray fill in the plot area. Your data table will have five rows and four columns for each group. For instance, [the background has been subtracted.] x EMBED Equation.3 Sln( EMBED Equation.3 )0.1690356.540.2488456.190.3340345.830.4230255.440.5169205.13 Graph the average counts per minute,  EMBED Equation.3 , vs. x, the thickness of material. Add error bars to the data points. Heres how in Excel: Select the data series on the graph Select the format menu Select format selected data series Select the y error bars tab, then select custom Select the standard deviation column for both the + & - error bars Graph the ln( EMBED Equation.3 ) vs. x. Perform the linear regression according to the instructions on pages 14-18 in the ring binder. The slope is the x variable 1. The p-value is the significance F. Finally, add a trend line to the graph. Heres how to do that in Excel: Select the chart menu. Select add trend line Select the type tabchoose linear Select the options tabcheck display equation on chart & check display R2 value on chart. SAVE the Excel file before or after printing out the charts on separate pages. Print also the linear regression out put. Youll need the file for the Presentation, as well as the Written Report. Continued on the back of this page. . . Fill in the regression tables (on the following page) and hand in one copy of the graphs and statistical output, that is the Excel file if you used Excel, and the regression tables.. The absorption coefficient for each material and radiation combination is the negative of the slope. In the example graphs below, the absorption coefficients for gamma radiation are: materialabsorption coefficientAluminum3.57 cm-1Lead7.30 cm-1 Here are some example graphs:   HYPOTHESIS TESTING USING STATISTICAL ANALYSIS Regression Analysis #1 (Group A, Variable 1 vs. Variable 2) Regression Equation: R-squared value: F statistic: P-value: Conclusion: Is there is statistically significant linear relationship between the two variables YES or NO (circle one) Regression Analysis #2 (Group B, Variable 1 vs. Variable 2) Regression Equation: R-squared value: F statistic: P-value: Conclusion: Is there is statistically significant linear relationship between the two variables YES or NO (circle one) $,-.?i  ! " q ˾˜کꘐo)hpshps56CJOJQJ\^JaJhh5hh+x4h+x4>*h+x4jhpsh|3EHU)hpsh|356CJOJQJ\^JaJjhpsh|3EHUjH h|3CJUVaJjh|3Uh+x4h|3>*h|3hps h>H5\ hps5\( -.?@r s   $ $$Ifa$ ^` & F$a$      ! " $ % 5 6 F G W X h i y z E K Q X s t  ­wh0'h0'6h0' hps6]hpshps6j. hpshpsEHUhpsCJOJQJ^JaJhpsCJaJjhpshpsEHU)hpshps56CJOJQJ\^JaJjhpshpsEHUjH hpsCJUVaJhpsjhpsU.$ % ) - 0 5 $$Ifa$mkd$$If\B 2 "''''64aB 5 6 : > A F $$Ifa$mkd$$If\B 2 "####64aB F G K O R W $$Ifa$mkd" $$If\B 2 "####64aB W X \ ` c h $$Ifa$mkd $$If\B 2 "####64aB h i m q t y $$Ifa$mkd( $$If\B 2 "####64aB y z {   : Q t u v { b@^b`@^ & Fmkd $$If\B 2 "####64aB    z    & 4 @ D P V b i t w8TU[q/@BPRTUZbpqst˻޳ާޣҋh+x4h+x45h+x4h|35hhH*hh5hhJhAXhps6hAXhAX6hps6H*]hpshps] hps6]h|3hhps5hpshpshps6jhpsUj5 hpshpsEHU3    5 W wVW/ $Ifgdh^hgd & Fgd & F^ b@^b`@/09C{{ $Ifgdzkd<$$Ifl0 xP t0644 laD CDIS{{ $Ifgdzkd$$Ifl0 xP t0644 laD STUstvwyzwoj__ $a$ed3gdJgd$a$gdl9$a$gd+x4gd|3zkd$$Ifl0 xP t0644 laD tuvwxyz{&'(3()*5opʺҺʺҺҺʺ hl9hJ hJhJhA hJ5hJhJ5hJhh|3jhl9hl9Uh+x4 h+x4h+x4jhh+x4h+x4U/&'((ed3gdJ $a$ed3gdJ()*gded3gdJ,1h/ =!"#$% Dd @b  c $A? ?3"`?2Q!Ɇ(y]E7-D`!%!Ɇ(y]E7fH x=OjA}3^IqI Pʼnp\gOHe& i Dd @b  c $A? ?3"`?2Q!Ɇ(y]E7-K`!%!Ɇ(y]E7fH x=OjA}3^IqI Pʼnp\gOHe& i Dd @b  c $A? ?3"`?2Q!Ɇ(y]E7-R`!%!Ɇ(y]E7fH x=OjA}3^IqI Pʼnp\gOHe& i Dd @b  c $A? ?3"`?2Q!Ɇ(y]E7-Y`!%!Ɇ(y]E7fH x=OjA}3^IqI Pʼnp\gOHe& i $$IfB !vh5555#v:V 6,59/ 4 aB $$IfB !vh5555#v:V 6,59/ 4 aB $$IfB !vh5555#v:V 6,59/ 4 aB $$IfB !vh5555#v:V 6,59/ 4 aB $$IfB !vh5555#v:V 6,59/ 4 aB $$IfB !vh5555#v:V 6,59/ 4 aB Dd @b  c $A? ?3"`?2Q!Ɇ(y]E7-r `!%!Ɇ(y]E7fH x=OjA}3^IqI Pʼnp\gOHe& i Dd @b  c $A? ?3"`?2Q!Ɇ(y]E7-y `!%!Ɇ(y]E7fH x=OjA}3^IqI Pʼnp\gOHe& i b$$IfD !vh55 #v#v :Vl t655 aD b$$IfD !vh55 #v#v :Vl t655 a  !"#$+'*9J,-./012345678:<=>?@ABCDEFGHIRoot Entry  F )Data *WordDocument .8ObjectPool P𶶊 _1222843629FP𶶊P𶶊Ole CompObjfObjInfo  FMicrosoft Equation 3.0 DS Equation Equation.39qi 2NOh+'0 , L X d p|Equation Native -1Table;SummaryInformation( DocumentSummaryInformation8 8D b$$IfD !vh55 #v#v :Vl t655 aD e Dd 0  # A" ,lqǤc^ @= ,lqǤc^@!܁G) x[ lUgs{K xFc5kȖPV%aQWS(+B\6jLmAnF,*dҖlLfƈKϹ^zē|{;K08\0bPO}i  ໭ip< wa:}}}C\wXnHAPit,'< A*=:ӹnooNNκ^e̋zTٜ cR̋4Z:#;^8F ~R[7=媞X9w0p*aS)i E0d< nqleL//Mi*St̟>OczxJFؿ3Ҫ`R 5ǚV f-m.q<89ћڤdU"y+ٓo ٿi&S=7E`D\T>ֹkoCicOѓWoYM4)٫^D=K݀\5~U2mtu /~;9P^=ff ݔ2PhO$Wo]o!*W">?U^|dן8!XC~=ޢ@ic]]ՌN]QʔTx]ViWWK痬3WS J[rQ*_RV^R,,{S_ uzf+§-#&MuǨM,[:o=RW=ԛX׏5.8FK8܅hgchMmFr}S^~Gq)7CKo4hfVh4څρ#F>%?I[hEӉMXF[ v8Gzag[]vtW~{A}T%ɨq^7 j759 W_hW]Gi;9]S~mAWr7WoU U UȯNȯNȯ.@~{ !!CB~|=^ 95 ͢]7'Dž> }O}KIϓB'=0G.w `My]B;.w\x$$t""џ5SZXʶnsQ ,`xJ,ـĒuN<+oXOV^WAk'TCλk1(;TQA MμS)KQLg^B[nƞDmoލall.?]0F+w > Os^6:'aeAL +aEG)}L,N˺S/b[nۮX6J<>=afİчxfbȘp6rp/%ՌK8b_=_zŁ$8'J~yhOBh߫T e|$}Js[õXO@o`/~XetեCt_8^q.\#*'c~)!, ,kmreg#t+Qh4(gGN|2 w q5-s݉t֎oEckCCho8qx":ݣ=b3NSYg-i+Am[{7P ,/sߓXraxOyMy*W8u0uN:o"ΝHԽ9dɳS~{&?7Yq$ȱZc;&p <p.ˊ 1V.Em-Y= {^rڕK+붌cCw+s"+$xYVNg?Víb|TS_!9/ V<%ZAF}T<~cNR'd@moF`֟T93^FVNCNXkwKX!%efo4Dߓ-'\z'~&L{#C&!uFzөwQ~b!DisQb|øquSl^g'zY}3>s{fNmy)Eۢ%2s^&uw.8)aqft+7zMluFWa UNo_\+*-#>ȫyV@quE6J} ʹdEmuխVzA1 g=v3}xs!g-Ƈ wM*ǜX KpI5ibVSmܣi[⽣3G%U1za&?u̼d y-tC\T0dDz߼u?Dd   0  # A" X2(_*:] @=U X2(_*:N!܁G)# x\ pUr^tj@A{[ H!JZH%7BꔁtZ;b PAh;L4`KP:Ej;}Y6w_֛9={v?=w3ՠLӆA3F7 )0ĹBL2څ4!Dʞeo"Lnrۖ3Q2P1罱=q(`c6;(E"'qUqZ@E7muJ q[%PxT3_0(!n|6`yJ<[So'ã=vb_*sȜ2VsqAv6_SiX. ۮ|ɫ7¢y<'!NmUX4ko SoŢªFH])_aϏ[CqG?:Y]k9S%p,WT'٧reߓm~o+>,n8)Gb"I9j2O|5P7ވ%îi2ͣm}OqJ}/ylj25_fM-yWӨ .#ݯ`gg-B 7ş4R$ؚtu2lkQ-e|R3)cyllp&d>y66AmLqJ,yjCQ&sٿbV/6\'|;34?My>N^˾iR~?^.H6W3\|5CP|TwϨCweZzu7evV҃mr!h7biSO#>-^2Q~eif >=^6ʾ}]z1㵂iOTxIc\VOV`M0wf!>3^vV.#r|;ڊȵ)[˲۵gzx`iFxYsBb5|Ո=ȵ),^v~^{Hq4#Ms/{J0EXh.cF:d#IXX&ۀiU D|^,噧`24ϲiiW#^/KywzﳽvZ e5/*X#Iac]BJ ZxYʳP ZEbj #Ǧjīۭst^@}1tO7=s_Й$mىv5#i<7.uc;#{^^G$eyLUVjgFtNK}XqV O3JAi2=2ozt wŻ.A9Y}eM;zK_)~NЭbMmH gshr;eTly =߿Zw1Ŀ`P,Ώ!qѾR_f/^ǣD}zfOLk9QOtJr=t2[ |ڱJZ<urK@𥬣K>J/e=-=m ,{.wTRYbc?S?g&?}bǗ2?~:hgh;2;юG@K?iONK)1{';W/_ 3f+Ktߺՠ>&P=[g]M;+g^p/E{ªx<5PX- AӰm<{,l룅ǡwV?sPX'^}Ȃ蛽ߝ13A>vad[S`؇'ϳJ鞄XHm%w^&ʋ, 1h8@wUd/ }&Ü&adZj`=*VHb67km[V3-U;lTG?[9;وT4b#>[?y?gyձwv-8 |ͻ,}UF.#WRhfZl!f V*+]U9s3J%%x,o߷+2%Vc+Xe)6r +aEZڦ۰5 jԀxe6E-تaZjRvMjlg:!\ whYxwS,L,L13۾Z:C:#vYב>^k]G\G7di4'ĕl]n yخ5_mW΂уM["d~L/gN}u۠~{l7 eEmc%V REGRESSION ANALYSIS ASSIGNMENTjerry Normal.dotjkiefer4Microsoft Office Word@캃@jYO@@ߖ ՜.+,0 hp|   G REGRESSION ANALYSIS ASSIGNMENT Title  FMicrosoft Office Word Document MSWordDocWord.Document.89q@@@ NormalCJ_HaJmH sH tH DA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List j@j  Table Grid7:V0B^`B J Normal (Web)dd[$\$ 8 -.?@rs$%)-056:>AFGKORWX\`chimqtyz{:Qtuv5WwVW/09CDISTUstvwyz    & ' (     ( ) * 000000 000000000 00000000000000000000000000 00000000 00000000000 00 00 00 0 0 0 0 0 0 0 0 000000003030303030303030303030303030303030303030303030303030303030303030Ustvw K004_K000&K00K00K00K00 t $ 5 F W h y /CS(   !   :::::: .2SU 3333 @{U  ThED^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.Th{        3A|3+x4l9>H9Q ]fMJ0' } AXps$%)-056:>AFGKORWX\`chimqtyz/09CDIST @rrt=rr @@UnknownGz Times New Roman5Symbol3& z Arial"q@hÆÆÆ  !24 2QHX(?ps2REGRESSION ANALYSIS ASSIGNMENTjerryjkiefer CompObjq