ࡱ>   ` 0'bjbjss "x* C C C8DC4xCE:EEEEANANAN$hcRM|ANRREEUUUR^EEURUUftz6EE `V C9S^^|08S0AN:{OU[PQANANAN!U^ANANANRRRR;BB Microsoft Excel Data Analysis ShortCourse Handout  Copyright 2004 Heide Mansouri, Technology Support, Texas Tech University. ALL RIGHTS RESERVED. Members of Texas Tech University or Texas Tech Health Sciences Center may print and use this material for their personal use only. No part of this material may be reproduced in any form without written permission from the  HYPERLINK "mailto:heide.mansouri@ttu.edu" author. Introduction Microsoft Excel is an excellent data analysis tool. Simple functions such as Average, Median, and Mode are built into the program. However, you can add in pre-packed, statistical tools called the Analysis ToolPak to perform analytic analysis. You can use these tools to calculate Descriptive Statistics, create Histograms, create Rank-and-Percentile Tables, and more. In this shortcourse, well explore statistical analysis functions built into Excel, as well as those included with the Analysis ToolPak. You should already have a basic knowledge of Excel formulas, functions, and some experience with the science of statistics to gain the most from this shortcourse. Course Objectives After completing this shortcourse, you should be able to: Calculate Descriptive Statistics for a set of data; Create a Histogram; Create Frequencies; Create a Pivot Table; and Make changes to a Pivot Table. To Perform Data Analysis From the Tools menu, click Data Analysis. If Data Analysis is not available, load the Analysis ToolPak. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. Data Entry in Excel List Format The key point on data management in Excel is to enter or organize the data so that it is in Excels "list format." To Create Lists: Use the top row of the table to assign labels to each column. Keep column labels short (no more than 8 characters). Use numerical codes for any well defined variable, e.g. Gender: 0 = Female, 1 = Male. Tools To Summarize Data in Excel PivotTables Descriptive Statistics Histograms Descriptive Statistics The Descriptive Analysis tool generates a detailed list of statistics for a set of data, including mean, median, and mode. From the Tools menu, click Data Analysis > Choose Descriptive Statistics > Specify the Input and the Output range > OK. PivotTable A pivot table is an interactive table that provides summary information about data stored in an Excel Worksheet by using the row and column headings of your table. For example, you may use a Pivot table to count the number of occurrences of each category in a Data set.  Creating a PivotTable Organize your data in a List. Remove all totals and subtotals created. Place your cursor inside the List (anywhere). Click Data>PivotTable Wizard. Follow the Wizard steps. Making Changes to a PivotTable Select any data cell in the table; bring up the mouse shortcut menu (right-click) and choose the option you want. -Or- Select any data cell in the table. Click the PivotTable>Field Setting. Select the PivotTable (from the PivotTable Toolbar, Select) Click Edit>Clear. To Delete a PivotTable Click inside the PivotTable. From the PivotTable Toolbar > Select > Entire Table. Click Edit>Clear. Printing PivotTables Choose File>Page Setup. On the Sheet Tab, clear Rows To Repeat At Top and. Select any cell in your PivotTable. Choose PivotTable>Table Options. Select Set Print Titles. Frequency Frequency function calculates how often values occur within a range of values and then returns a vertical array of numbers. An array is a collection of items (an orderly arrangement). For example, use FREQUENCY to count the number of test scores that fall within ranges of scores. Because FREQUENCY returns an array, it must be entered as an array formula. Array formula acts on two or more sets of values called array arguments, returning multiple results (an array). Syntax: FREQUENCY(data_array,bins_array) Where: Data_arrayis an array of or reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY returns an array of zeros. Bins_array is an array of or reference to intervals into which you want to group the values in data_array. Array Formula Rules Select the cell or range that will contain the results. Type your formula into the formula bar. Press Ctrl + Shift + Enter (to lock the formula). The Histogram Analysis Tool The Histogram Analysis tool calculates individual and cumulative frequencies for a cell range of data and data bins. You should determine the intervals of the distribution before using this tool. Creating a Histogram Select Tools>Data Analysis>Histogram from the menu bar, and a dialog box will appear. Insert the input range by either entering the reference by keyboard or highlighting the input range on the worksheet. Set up the ranges for the histogram divisions. Check the chart output box to obtain the histogram and click on the OK button. Where to Get Help If you need help with your project, you may contact Help Central Office at 742-HELP. If you need help from your instructor, you may e-mail  HYPERLINK "mailto:heide.mansouri@ttu.edu" heide.mansouri@ttu.edu. Exercise 1 Find the Descriptive Statistics for the following data: Vehicle mileage: 27, 29, 33, 21, 21, 12, 16, 25, 8, 17, 24, 34, 38, 15, 19, 19, 41 Steps: Enter the data in a single column in a worksheet. Click in a cell where you want the results to go (C4 for example). From the Tools menu, choose the Data Analysis. Double-click the Descriptive Statistics. Enter the range of the cells containing the data, including the label (drag over the cells or type). Click columns for "Grouped By" options. Check box Labels in the first row. Check-mark the summary statistics and other options. Exercise 2 10 people were asked to rate 3 restaurant owners business outlooks (1=very unfavorable, to 6=very favorable). The following data was obtained: IDOutlookOwner26161262422631326432265322662126713268522694327042 Tally the results using the PivotTable Wizard. Exercise 3 Using the PivotTable Wizard, find the percentages of each academic major for the following data: IDMajor1Finance2Accounting3Finance4Accounting5Computer6Accounting7Computer8Finance9Computer10ComputerExercise 4 Using the PivotTable Wizard, tally the following data (construct a contingency table): NameStatusChange of schoolTimEnrolledTransferMaryProbationComputerTomEnrolledBusinessAliceEnrolledTransfer Exercise 5 Academic rank of 20 professors is tabulated in the following table. Find the frequency distribution of the data, making sure to create a bin array first. Professor-IDAcademic rank (1-5)122231445563728394102114125135142155162173184192205 Exercise 6 SAT test scores of 20 students are given in the following table. Using the bin values of 850, 900, 950, 1000, 1050, 1100, and 1150: Construct a frequency distribution table of the total SAT scores. Construct a histogram, checking the Chart Output box in the Output Options of the Histogram dialog box. Format your histogram: Change the background color of the chart. Type SAT Scores for bin on the x-axis of the chart. Perform more charts editing, if you can. Student -IDVerbalMathTotal1418518936246555510203466556102245335701103547656610426520554107474704999698468545101395035491052105515191070114144889021249747797413444502946144205249441552053310531651148910001741147788818509540104919521530105120412560972  Please e-mail your comments or suggestions to:  HYPERLINK "mailto:Heide.mansouri@ttu.edu" heide.mansouri@ttu.edu     Data Analysis SC Copyright 2004 Heide Mansouri  PAGE 1 Texas Tech University Updated: 10/19/2006 Row field Column field Summary field %3456@BFGUVx y ` b t D \ >^&%9:f| )yuhSWhSWCJ\aJhSW5CJ\aJhSW5CJaJhSW>*B*CJphjhSWCJUhQhQCJ hQCJ hSWCJhSWCJaJ"jhSWCJUaJmHnHu hhhQ5CJOJQJ\aJhSW5CJOJQJ\aJ.346 2 3 ` b t $ C D ] =>^ & F & Fdhgd$a$"'''^&a&%9;<TUV & F*h^h^ & F$ & FVWXYZ[\]^_`abcdef|()ID & F$ & F)GDEKU\re}ZdnPfmRS~2=hSWhSWCJ\aJhSW0JCJaJjhSWCJUaJjhSWCJUaJ hQ\hQCJaJhSW5CJaJ hSW\"jhSWCJUaJmHnHuhSWCJaJhSW5CJ\aJ8DWXYZ[\s:^ }Z & F & F & Fh^h & F & F<noPQf3c12=@&dhdhh^h & F & F & F=s} $$Ifa$@& & F'   B M !!!!!!'!(!4!5!@!!!!!!!!!!"""""""""""""""""""hSWCJOJQJ^JaJ hSW^JhSW5CJaJhSWCJOJQJ\^JaJhSWCJaJ hSW5CJOJQJ\^JaJJqh__ $$Ifa$ $$Ifa$kd$$IfTlyF&,(&0H6    44 laTqh__ $$Ifa$ $$Ifa$kd$$IfTlF&,&(&0H6    44 laTqh__ $$Ifa$ $$Ifa$kdA$$IfTlF&,&(&0H6    44 laTqh__ $$Ifa$ $$Ifa$kd$$IfTlF&,&(&0H6    44 laTqh__ $$Ifa$ $$Ifa$kd$$IfTlF&,&(&0H6    44 laTqh__ $$Ifa$ $$Ifa$kdB$$IfTlF&,&(&0H6    44 laTqh__ $$Ifa$ $$Ifa$kd$$IfTlF&,&(&0H6    44 laTqh__ $$Ifa$ $$Ifa$kd$$IfTlF&,&(&0H6    44 laT   qh__ $$Ifa$ $$Ifa$kdC$$IfTlF&,&(&0H6    44 laT    qh__ $$Ifa$ $$Ifa$kd$$IfTlF&,&(&0H6    44 laT   A B M qooojgg\\ $$$Ifa$$$@&kd$$IfTlF&,&(&0H6    44 laT ||$$If{kdD$$IfTl0d&&0|644 laT ||$$If{kd$$IfTl0d&&0|644 laT ~~$If{kdn $$IfTl0d&&0|644 laT ~~$If{kd $$IfTl0d&&0|644 laT ~~$If{kd $$IfTl0d&&0|644 laT !~~$If{kd- $$IfTl0d&&0|644 laT!!!!~~$If{kd $$IfTl0d&&0|644 laT!!!!~~$If{kdW $$IfTl0d&&0|644 laT!!!'!~~$If{kd $$IfTl0d&&0|644 laT'!(!+!4!~~$If{kd $$IfTl0d&&0|644 laT4!5!@!!!!!!yyy$If@&{kd$$IfTl0d&&0|644 laT!!!!!$Ifikd$$IfTl;FT''~'+ i6    44 laT!!!!!$IfikdX$$IfTlFT''~'+ i6    44 laT!!!!!$Ifikd$$IfTlFT''~'+ i6    44 laT!!" ""$Ifikd$$IfTlFT''~'+ i6    44 laT""""""""" $$Ifa$@&ikd$$IfTlDFT''~'+ i6    44 laT"""""""HVkd$$IfTl0U''p1644 laT $$Ifa$VkdD$$IfTlL0U'p1644 laT"""""""HVkd%$$IfTl0U''p1644 laT $$Ifa$Vkd$$IfTl0U''p1644 laT"""""""HVkdo$$IfTl0U''p1644 laT $$Ifa$Vkd$$IfTl0U''p1644 laT""#####HVkd$$IfTl0U''p1644 laT $$Ifa$Vkd$$IfTl0U''p1644 laT"#### # #######$#%#*#+#0#1#6#7#<#=#B#C#H#I#N#O#R#_#j#:%=%>%\%]%k%l%{%|%%%%%%%%%%%%%%%%% & &&&+&,&;&<&L&M&]&^&m&n&~&&&&& hSW5CJOJQJ\^JaJhQCJaJhQ5CJaJhSW5CJaJhSWCJaJhSWCJOJQJ^JaJK## # # ###HVkd$$IfTl0U''p1644 laT $$Ifa$Vkd^$$IfTl0U''p1644 laT#######HVkdM$$IfTl0U''p1644 laT $$Ifa$Vkd$$IfTl0U''p1644 laT##"#$#%#(#*#HVkd$$IfTl0U''p1644 laT $$Ifa$Vkd$$IfTl0U''p1644 laT*#+#.#0#1#4#6#HVkd$$IfTl0U''p1644 laT $$Ifa$Vkd<$$IfTl0U''p1644 laT6#7#:#<#=#@#B#H= $$$Ifa$Vkd+$$IfTl0U''p1644 laT $$Ifa$Vkd$$IfTl0U''p1644 laTB#C#F#H#I#L#N#=Vkdu$$IfTl0U''p1644 laT $$Ifa$ $$$Ifa$Vkd$$IfTl0U''p1644 laTN#O#P#Q#R#S#T#U#V#W#X#Y#Z#[#\#]#^#_#j#@&Vkd$$IfTl0U''p1644 laTj##2$$$$%:%;%<%=%>%J%Q%V%\% $$Ifa$gdQ & F, & F,\%]%_%c%g%k%yyyy $$Ifa$|kd$$IfTl\ ]' '<''644 laTk%l%n%r%v%{%yyyy $$Ifa$|kdt $$IfTl\ ]' '<''644 laT{%|%~%%%%yyyy $$Ifa$|kd7!$$IfTl\ ]' '<''644 laT%%%%%%yyyy $$Ifa$|kd!$$IfTl\ ]' '<''644 laT%%%%%%yyyy $$Ifa$|kd"$$IfTl\ ]' '<''644 laT%%%%%%yyyy $$Ifa$|kd#$$IfTl\ ]' '<''644 laT%%%%%%yyyy $$Ifa$|kdC$$$IfTl\ ]' '<''644 laT%%%%%%yyyy $$Ifa$|kd%$$IfTl\ ]' '<''644 laT%%%%%%yyyy $$Ifa$|kd%$$IfTl\ ]' '<''644 laT%%%%%%yyyy $$Ifa$|kd&$$IfTl\ ]' '<''644 laT%%%&& &yyyy $$Ifa$|kdO'$$IfTl\ ]' '<''644 laT & &&&&&yyyy $$Ifa$|kd($$IfTl\ ]' '<''644 laT&&&#&'&+&yyyy $$Ifa$|kd($$IfTl\ ]' '<''644 laT+&,&/&3&7&;&yyyy $$Ifa$|kd)$$IfTl\ ]' '<''644 laT;&<&?&C&G&L&yyyy $$Ifa$|kd[*$$IfTl\ ]' '<''644 laTL&M&P&T&X&]&yyyy $$Ifa$|kd+$$IfTl\ ]' '<''644 laT]&^&a&e&i&m&yyyy $$Ifa$|kd+$$IfTl\ ]' '<''644 laTm&n&q&u&y&~&yyyy $$Ifa$|kd,$$IfTl\ ]' '<''644 laT~&&&&&&yyyy $$Ifa$|kdg-$$IfTl\ ]' '<''644 laT&&&&&&yyyy $$Ifa$|kd*.$$IfTl\ ]' '<''644 laT&&&&&&' '!'"'$'%'''('}}x}}}}}}}dh@&|kd.$$IfTl\ ]' '<''644 laT &&&&&&&'''''!'"'#'%'&'(')'+','.'?'@'J'L'P'Q'_'a'b'h'i'ѸvdVdhSW0JCJOJQJaJ#jhSW0JCJOJQJUaJhQhQCJOJQJaJhQCJOJQJaJhSWCJOJQJaJhQhQCJaJhXjhXUhSWhSW0JCJaJj/hSWCJUaJjhSWCJUaJ"jhSWCJUaJmHnHuhSW5CJaJhSWCJaJ ('*'+'-'.'?'@'l'''''''''''''gdgdQi'j'k'l''''''''''''''¶hSWCJaJhXhSWhSWOJQJhCJOJQJaJhQCJOJQJaJhSWCJOJQJaJ#jhSW0JCJOJQJUaJ%h0JCJOJQJaJmHnHu,1h/ =!"#$% n]tnP SUO(PNG  IHDRY2sRGB pHYs+PLTE'???1jMMM@@@SWfMMMMqod|||hhhMMM¸MM/MѨaIDATx݉b۸Ie8:n(_Hc7$y4m/4|v.OαKzYy칄__Ҕ-C3b 6VRm4_?s;|h44~)d;wKG7tK3Ptۈ_ #;G/푱~wwamv~)lw [4_w_9oK( m/ylgŊ~=1p59vIqx= E 51piV>}s-5i_c7ys޿;jw SxMOGụG5qˠ;"{g,u{cuDlbxĶ6M_s~~+9P5;3~o0}R?{V0VaXW%ڑ%{լy-UۿK7q?h_ۯgg}H\GjWT?g&lB\9Rчk37+~|1Ծty9oujVCp_GP'HM-H}J~۽9ɨ,gk5f'>}SvH+~Աwϣ{Gl\^?:Oїh^.9o֥p_!5 %=ުԇA/YJLW梨gJniu};3}e5}O}.|,9PJŚ0߫ow$ &vPWhA_{~'=wœ!==K{{|9/%ᗻ~ ~kkZABf/d ~ݵ]]Z]MX0j&j[ UѡU؝kU4ݿ8+s !9*cZ ~% "0g֥f!$WNVoyޯCf7r;(2\~t_f[ח/l:2WBŌ\%CתBPx EjDth0g#<~\ܯ\!2 ѷWbJ`Ft~-ԯwAWY/W͚Æ^ W抿lR0ם?P_ kf?0_7& VypMkp|m>j%>4?.PG7W=\ ?Wk0F?Z'}߹\C͏ g;w)`R{~K #t*hmJ+Ww£~}a6/A {(v`Rr>j_~س&Ru_,/GgПtz-RAak ^_/%X;T_.aB0u}E|P_-+v67n~tez*й J bݴ׮yҨKؾ_\N?U_=D;5:_^dzt}]Q]3WO<AzBa߈KRygߵ~w7~w_~^[#' ￾ZwR6ᗿz]k"+6w!k6qI_.Q~G}~ٍ8k ܿ:)V~.?_*")V~2%_*^ow+"e]gYK'V >*E;UJ%3]g Q sE:Q6"___]/{M?'֯/Z>j0p߮æOP?lҠ?ow荗c_ cDߎ$¯(bKolWu~λ|4~_]_}vMxLuΚﺞҫpc˺/3֯_V>} n///~c;{_8C'UdAuԟ~,7ߡ ?34= կp~zIg?? /WNt<_B;_Qvgߖ+PӪ~oCbr;_p/v;o_w_=_~}Υ 3uW2SKu__ߵu, % k%?~7~_ݵ߷ 7o 7=~~~~7oxz_"qdp-6Ej jm6#8QV@E◇`z&3r~7oDg{IG$fAl~_U~6u%*Sra櫌;x(3UDKds p|74Vd6״W(OD_;Ư5j~Y!Il;-////oۦoc___E97?//o_o~Cο%m4v_ ._ƕl\ɚ_M<'e6/R:RLG7My{BnRX]P_Kj@QcԗH{Yd_-]_@k^$9d|V[~7"-'_\F4ܖKVEV[FyB},__2L[?t zE?0#Fnïo~w _GC:/__hd԰_VOҺ{dDF śUeCov.R~~W~G 9E\roooo8~H/n_ݞ_///o_ԯ~/!q)ߌ-~7Cԝ;_1F7`׀h%~~~~~~~7y&Kt#J[oo//fWe~K i_k-bF_;rݿazu7gvu濟ZW-*~[_{W F@ {{_]o׃9>ws~cߋ~UcP/|homU )M//zfl,)7[?>K8lEp+*` q?K#+zGf$nY=HY~ȼC8.fZce7O탕?hsdh;;~77 ;گ{׵oohY䏭_GcwjϿXS[37fjzlt/~ǵFMs7A.h_L~qߌWyM%x#~ů_EaPvki>'+E Oi[?o4?zFjGd/%pn ~ozgfkf"wςa?WAߊϟ,_8kr-m+zT] 2jzy/M+ e76U^MOW $̯W}-lm/r_Wd<~,22M!~ᗒ@t~Oۯt&Y_Yߴo~sDcH}Nr+¿Obx[ʁo[E[ow% o.~I9ՏkZU}l?!v÷Qzo=}&éVI>N~[&~ZRi~e%;CsE_Y?1>pKVu w[-]~칟t0v"kjfW_r?]/\^eZ~Հ}vnq;֋Y٭G(jE;俍,WmT]^:ͯdCQh^nL_/[#zZXm5 V}x.]cSڋhp9]hԯ׹{~Ŝ׿e?jؕJa\.N/MWU*ʥEqjy;;E >m7Iw<7/+~Yىc ] +?~CR ʓZ"VlYܿ_=c` Yljʩw~c-Y0 xW)/~7~7~Zu__ߕWov~X Knݗ_^ =w~~77%//fo_?___@_GC:/:~~~W_/P E:/_/k 1m ߰ ~~~~~wDf눿~~7o/n/E|, ~EXUo -ԯ5//_*~~waߟ3z# C~S*~2oJ?e0B>vpsGҼ;HXm$ɰۅaM.J_&mG!g|IwקURo㷟_4گbHH7iCq~~&7_oq ~7 K%o~K"#_\ G__ݟ_~q3___ݹ_ _GE~ Ŷv>w~~w~~7뷄_݅__ou E _}oV~////s?+_IENDB`n(}vͨPNG  IHDR/gsRGB pHYs.>PLTE@@@MMMMMMMz|}vyMMM¸̿÷MMMIDATx흋43ٝuu:ԻYEQײx_B7.%-Z(b䡂M0R=&xxmݝ)wbys+L '^wbI^zOuq^%&L]͋_3+W=pz)/RL.tF|xHah/xxmlZj cه- m;5W\5WќNx]IyE.ͬ ,@t~ztZйm3yF,ڃgzK՜өl\CO}ErKW,}`3xcO׼(= Wy}B+M:Z'X;WYQl^{9mQ9ˢ}E!^~FK*Jɋ9ËUxQ*[)Y# _W˧׷>pH_K7>/}bC^c'WUvv{B$76(Do5ww_e}j݅ S_g 󊖏@;}M7Ӈ/ZOeZipיL+.ϟ?問z&;$S3B_J;|^fK40x O_cx0{[^#x)uG1:*~yO_NҼ/^+TEƯWţf6CHEX}5JӨ5&^^2xU`8%~ -A}ͳqvh} Կz. ѻVQl#펆tTZ;>HM_J_6/+lG3*-^ԯ.+$k|^zb^M!^+zיs+m/^Wyjszǟ5A{jټeBi7^,n^k(Q  U*36Q^5xq꫽.k>zJф헏D<\Gze7>VhZ_%ͫZU iX~^v9/*9 x]x^^2Kt ZVKzQ^ڮWku9^^us^l ^k6ȋ/Mk/kZ"!}." k2/ >E,^촅k^B#x xxxx-ˋ/ x9-WED&]EsETMӦoP뫶l;ıMk|wS+P+cGA-^^^/B_^/^(շ#A_=zxF ȍFW+4"dnVԷ0/wD?[Q}dgrFV{)+g"T@j_#!m74]H[(\}F9M~/cir⽣LG "a^$%oo8ޫ.d+%@μf /*un<ڿ+9/##%^诅 +'^Go'me:]ڶ/ף/'wSYzZUf2zW M.Jї ^vh|yO_^feJ|,/tNY}S0/}*l44//Ey!vڤځ?C!~"'(ڃ?"~3|+ik 3@IENDB`DyK heide.mansouri@ttu.eduyK <mailto:heide.mansouri@ttu.edu$$If!vh5,55G#v,#v#vG:V ly0H6,5,5(599T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh5,55G#v,#v#vG:V l0H65,5(59T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55#v#v:V l0|6559T$$If!vh55~5+ #v#v~#v+ :V l;i6,55~5+ 9/ /  / T$$If!vh55~5+ #v#v~#v+ :V li6,55~5+ 9/ / / /  T$$If!vh55~5+ #v#v~#v+ :V li6,55~5+ 9/ / / /  T$$If!vh55~5+ #v#v~#v+ :V li6,55~5+ 9/ / / /  T$$If!vh55~5+ #v#v~#v+ :V lDi6,55~5+ 9/ / / /  T$$If!vh55p#v#vp:V lL16,55p9/ /  / T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh55p#v#vp:V l16,55p9/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ /  / T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  T$$If!vh5 5<55#v #v<#v:V l6,5 5<59/ / / /  TDyK Heide.mansouri@ttu.eduyK <mailto:Heide.mansouri@ttu.eduH@H Normal CJOJQJ_HaJmH sH tH N@N Heading 17$8$@&H$CJ!OJQJ^JaJ!B@B Heading 2$@&5CJ\aJDA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k(No List ZYZ  Document Map-D M CJOJQJ^JaJ6U@6  Hyperlink >*B*ph:B@: Body TextxCJaJ4@"4 Header  !FV@1F FollowedHyperlink >*B* ph4 @B4 Footer  !.)@Q. Page Number () (),34623`bt $CD]=>^&a&  % 9 ; < T U V W X Y Z [ \ ] ^ _ ` a b c d e f |  ( ) I  D W X Y Z [ \ s  : ^   }Z<noPQf3c12=s} ABM'(+45@ "   "$%(*+.01467:<=@BCFHILNOPQRSTUVWXYZ[\]^_j2:;<=>JQV\]_cgklnrv{|~  #'+,/37;<?CGLMPTX]^aeimnquy~ !"$%'(*+-.?@l000000000000000 0 0 0 0 000 0 0 000000 0 0 00000 0 0 000* 0* 00000000000000000000000000 0 0 0 0 000 0 0 0 0 0000000 0 0 000 0  0  0  0  0 0 0  0  0  0  0  0  0 0 0  0  0  0 0 0  0  0 0 0  0  0  0  0 0 0 00000000' 0' 0' 0' 0' 0' 0' 0' 0000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000K0K0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 0K 00>0>0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 000 0 0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  000000000000000000h, 0h, 0h, 0h, 0h, 0h, 0h00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000000h007h00h007h00h007h00h007h00@0h0 0 4` @0@0h00h000h0 0h0 0h0h0L46j0*j0h0j0 wwwz)"&i''=[]^VD=  !!!'!4!!!!!"""""###*#6#B#N#j#\%k%{%%%%%%%%% &&+&;&L&]&m&~&&&('' !"#$%&'()*+,-./0123456789:;<>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ\'xRXXX?FHz!&(Ob$tnP SUO(e.$b$(}vͨb$M݀ @'r(  NB  S DoNB  S Do   NA?f ? "`T  `' '#" h  3 "` \ X  &L  `' & `'h  3 "`  Z`  @ & %#"  `'Vn  &E "  #"  @ &b   C A  "` %En  C  "`X &1  L P ! $P !`B B c $D<1 !`B  c $DP P `B #B c $Dl B S  ?49 D (#t'8 !t \ PQt@t"t3lH313033333l333\3Z3D[32313S3333lº3D1ú3,3ĺ3Ԓ3ź3Pkkqv33<llrw     pu;>>qv    8*urn:schemas-microsoft-com:office:smarttagsCity9*urn:schemas-microsoft-com:office:smarttagsState=*urn:schemas-microsoft-com:office:smarttags PlaceName=*urn:schemas-microsoft-com:office:smarttags PlaceType9*urn:schemas-microsoft-com:office:smarttagsplace 6(""$$%%'(*+-.""$$%%'(*+-.$D]&f | I D  ^ oQf=@"R_j>""$$%%'(*+-.>l""$$%%'(*+-.,n@+~ziH4>H obC~ #6&-M~zi 4\i f \R=_M P*" {!XQ"%Ds'zl0( hJ)lnLq,ȝvb.أ;&R;z]n%[E< <Bښu#:ObwV0OPO/PJ嬑Z6P(He *Q“zU? UȝvPZB|s;`DyK`vf*bvok*:lv8ylTtmqnH̳.#p~b(q )t&R,x/LoE>xJ,#7x@>N|r< ^`OJQJo(l ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(l ^`OJQJo(l ^`OJQJo("  pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH ^`OJQJo(l ^`OJQJo("  pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH. ^`OJQJo(l ^`OJQJo("  pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(l ^`OJQJo(l ^`OJQJo("  pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(l^`OJQJo(hH^`OJQJ^Jo(hHohpp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH ^`OJQJo(l ^`OJQJo("  pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`. ^`OJQJo(l ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hH ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(l ^`OJQJo(l ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`.hpp^p`.h@ L@ ^@ `L.h^`.h^`.hL^`L.h^`.hPP^P`.h L ^ `L.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hH^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`.hpp^p`.h@ L@ ^@ `L.h^`.h^`.hL^`L.h^`.hPP^P`.h L ^ `L.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH ^`OJQJo(l ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hH ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(l ^`OJQJo(l ^`OJQJo("  pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hH ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hH^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`. ^`OJQJo(l ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH ^`OJQJo(l ^`OJQJo(l pp^p`OJQJo(l @ @ ^@ `OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l ^`OJQJo(l PP^P`OJQJo(lh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH,O/P>N|;~ s'XQ"%7xs;`.#pnPZ; )tb._MLq,? Uvfe *Qqn{!E>x0O8yl*J)b(qJu#:OJl0(&-M+<Bif\H,xyK`Z6P[E< 4H okl,,                           %jDγL@ d;r rBVZ         |hz 4 _m2tJ"`KN@S֌                  Ā $Rh*n6:$j) Ժ\U         j6QHrrIQD.d&GS                  &M0Cj dnw~Z..ԣxL*J qQ"m<%kp\~{[N Υ&I9B&.0`7XdTpv=Υ&I9B&.0`7XdTpv                             $Rh*n6:$j) Ժ\U                                     ,zG480U]hRzݮ Pu|=          <%kp\~{[N                                              0Cj dnw~Z..ԣxL*J q                  R,zG480U]hRzݮ Pu|=         X .SWsQ '(+45    "$%(*+.01467:<=@BCFHILNO>JQV\]_cgklnrv{|~  #'+,/37;<?CGLMPTX]^aeimnquy~@33hva33P@UnknownGz Times New Roman5Symbol3& z Arial7&  Verdana?& Arial Black5& zaTahoma;Wingdings?5 z Courier New"1hZH }8}8!4d 2QHX ?Q2Microsoft Excel DataAnalysis Heide MansouriHeide Mansouri,                           ! " # $ % & ' ( ) * + Oh+'0 0< \ h t  Microsoft Excel DataAnalysis Heide Mansouri Normal.dotHeide Mansouri8Microsoft Office Word@vA@$Y@urU@4>3}՜.+,D՜.+,\ hp  Texas Tech University8 Microsoft Excel DataAnalysis Title 8@ _PID_HLINKSATfmailto:Heide.mansouri@ttu.edufmailto:heide.mansouri@ttu.edufmailto:heide.mansouri@ttu.edu  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoqrstuvwxyz{|}~ Root Entry F0 WData p01TableWordDocumentSummaryInformation(DocumentSummaryInformation8CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89qRoot Entry F`f&#UData p01TableWordDocument՜.+,D՜.+,\ hp  Texas Tech University8 Microsoft Excel DataAnalysis Title 8@ _PID_HLINKSATfmailto:Heide.mansouri@ttu.edufmailto:heide.mansouri@ttu.edufmailto:heide.mansouri@ttu.eduSummaryInformation(DocumentSummaryInformation8CompObjq