ࡱ> Root Entry F1U:XData  1Table(\WordDocument@ nop!"#$%&')*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWrstuvwxyz{|}~Lab 1 Introduction to Excel Objective: The objective of this lab is to familiarize the student with some of Excels more commonly used features and capabilities. After completing this lab, students should be able to fill and format cells, enter equations and IF statements, understand fixed and relative cell references, use a lookup function, create graphs, and print a desired area in a desired format. In addition, this lab should familiarize students with a variety of common functions. Entering data formatting cells, filling cells Get the following data off the server:  Format the data to 2 decimal places. Add a column to the left of the data labeled Year Fill. Use the fill function to enter years 1989-2003. Format column heading cells using wrap text. Entering equations/formulae relative versus fixed references, cell names, inserting versus typing a function, Excel help Add a column to the left of the Year Fill labeled Year Equation. Enter 1989 in the first cell and then use a formula to fill in the remainder of the values (use = and mouse rather than entering manually). Calculate the geometric mean (geomean), maximum (max), minimum (min), and median (med) values of lambda using Excel functions (Excel function names in parentheses). Use Excel Help to get an explanation of geomean. Add 3 columns titled Diff from Mean, Diff from Min, and Diff from Median. Copy calculated values (2 methods) to a cell above the respective column. Use a formula to calculate these values. Name the cell values (geomean, min, and median) and repeat exercise. If statements Get the following data file off the server: Acorn woodpecker demographic dataFrom: Stacey, P. B., and M. Taper. 1992. Environmental variation and the persistence of small populations. Ecological Applications 2:18-29.   Let the carrying capacity of the population = 52. Add a column to the right of the No Constraints N(t) column titled Model Constrained N(t) or something similar. To fill this column, constrain the population maximum to be =< the carrying capacity using an if statement. Turn auto-calculation off. Change carrying capacity to 49. Hit F9 to re-calculate manually. Turn auto-calculation back on. Lookup function Add a column to the right of the Model Constrained N(t) column titled Empirical l . Use the lookup function to pull the value from the Census Data. Change the cell from a lookup formula to a value. Graph Graph the empirical and model estimated l versus year using appropriate labels and graphics. Create a second graph of the empirical and model estimated l versus year with regression lines. Calculate the 95%CI for the following data and then graph the means and their 95%CI (output from SAS).  Print Print out each worksheet of your workbook formatted to fit on 1 (either portrait +hG ^ k  % & K L M N P Q R   Ž}yugy`\yXyXyTyh5Lh'h 1 hXWh7bjhd],UmHnHuh7bhXWhhXWh`p5hXWh#5h hI2h;c5 h ^J h-^J h#^J hr^JhrOJQJh ]OJQJh%5CJOJQJaJh#5CJOJQJaJh%h%5CJOJQJaJh%h;c5CJOJQJaJ  & M Q R w            f  & Fgd{p & Fgd-gdXWgd ]$a$gd'9)~) 6 7 . 6 c d t  : ; /FGKTU456789ļڤ{tf_ hEJhEJjhEJUmHnHu hEJh-hEJhEJCJ^JaJ hEJ^JhEJhEJ^JhhEJCJ^JaJ&hhEJ5CJOJQJ\^JaJhEJh-h5L5h-h-5 h-5 h:G5hSh-hEh5Lh%Nh{ph' h5h5Lh 15$f < EFU4Fkd$$IflX 'g g 644 la]p $IfgdEJgd- & Fgd- 4567;<PzJ & Fgd & Fgd  & Fgd & Fgd{pgd-Fkds$$Ifl;X 'g g 644 la]p 9:;PPR02z DFHLNPR^(D((((᮪ʦƗ}{whUj6hhU hhhhdohHE}h h OJQJh hyh h{pOJQJhHE}h-5 h:G5hh-hEhEOJQJhEh-5h{phEhEJ hEJhEJjhEJhEJU, or landscape, whichever looks best) page with an appropriate header. Try both setting the page format and setting the print range. Extra Credit Array Function Pick up the spreadsheet FRWS6400_Lab1_STD&SE_Data.xls off the server. Use the FREQUENCY function to make a histogram of the means for samples 1-100. FRWS 6400  DATE \@ "M/d/yyyy" 9/2/2004 PAGE  PAGE 1 (X_AdHocReviewCycleID_EmailSubject _AuthorEmail_AuthorEmailDisplayName +) lab filesmconner@cc.usu.edu Mary Conner&1h:p:G/ =!"#$%`!6~yD. h4'xڕRMK#A}3iq@q/""~ qt4sބ SE[O_?Xn`;|NIwzUWzl~-J"=BE*%N5Ycuw>TA'Ly?/ yqogwu9s;/K7o7"#1Aq P )y lXَSGח;W=3)`*=ft/[ʤ}ˠjG 1Oξ %@ȁ/84rc˗lZmϯ*7ٍqO9~2gh01B*w;MEC v'2%Xb_zO|jjjpZwvU)L5lg*n_{ٸM]8/Y57A듼4cݾaUF%JSK=6QvifrЗMʜ쁈d[hr[Mx, {xe #iKJ wKF(YLm~5'<-a^]ܞe]O1}n=VrӀ/i*Pr+iʗ4Rm|4`K TJn%T[*_n%7 XF/|I#Vʗ[MVj@˭+_HUVrӀ/i*Pr+iʗ4Rm|4`K TJn%T[*_n%7 XF/ewbO7K LcׯQ]ך@,$5*ʀT7d)ǟ{:!A5|y>{[nK%$~#2{0?Q1EI4[Yg}JYI5wsdUAetaS2XѸ`R2A:Sf 12%o~ٰiZ8vL('p!Ϋ#pbt^-:\(q(3 ȗ𬧌1 _0 _>ó2ƀ|9ƗJ?À| z_* :HYQd{_ !<؜P=ha\DsWH~oK TvUX=,Sq DpQ >n= caf>GqbʨXgb,UbدV܄_=bCaE0_oie/?ȻV"(쎲Gf2Cs:"xVF@}9r,*Ή ȗTU/Q&2 _N$SUMc@F*Ȁ|9LU5rh"D2U4@[=qk4VJFK/]D T֥},z& \=`.~4;qO쑤[ySlC{l8_Ɔ`sUN[{\?Z+^Ȕ%Ke2q]BOx)5K|ODϟ:n fO<*X_3) t_ #z@]k3@jrqb4:Gq-72L/o@U2 _*w\/Q;.roQ˗|KTe t^=~_U- .q 1HUe?O(Bdv u΋P`RUPl-wqo&\;~e 6e+UcVޚ.[Z8_p"0pe3[\_;GH' XUK&_t87e (R'!t8|9D+)SCxy Jr) 4]_^k"'W,#R+ ig2)[+#%Ly~!3|IЎ!2 ȗHr)9#_.#R@˥\|K/s02R.l']i-!d@rugY:b̷L*:Gq[Kv,)icv]" њ2QLv;y{&֜4&xQeeJ'|9z"nƗ 5^ p(S2Qɂ*×ѡP3wf!P%>b[4z3{pIwBg%KM*Q.O8Ұ>{U/<[^'h{Aw*كnT +2rpB#MS;1ٯ1_1SJɬ im֌3 4fLł-]dž.d- rt ]W+^!]^k\١J-҇ KK1vECgҞkhssMoipv}1'}8qIӿx;^JzX״oFȜɎ{&JDd 6 0  # A2@iuSΏ7z`!@iuSΏ7 `A#xڭkAMZCmCY:de4x(jS(= BplWœG/B.z y*ͩg'/J7lgٙ;oG * o|U238^R[ e>-,f׽+R$#MS ?׮@gd3;Mˆ?7ξc>EXCksjum.sZ_3Lu;8)`<HYShS8+Tѐmͭw'$ 9[;pN51?d!!h_EtWH`;ltu,ș,Z{ۻ8%ϘcB*?@Y3^I3m1]tjtude3Ą(613$zje@Jd NSc1r#!=(ψ+J?+F+9/H0 HRtSƔBT=]ppp b1y~+L8cū^ Փ(jl=%/߮nx̋5~U/2B&.'.pe ꞷTᾮNTi~tD@D -NormalCJ^J_HaJmH sH tH DA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List H@H  PP Balloon TextCJOJQJ^JaJB1@B ] List Number & FdYDd4@4 rHeader  !4 @"4 rFooter  !>;@2> RW_ List Number 3  & FB:@BB RW_ List Number 2  & FVD20l@Q0RW_ 1 / a / i F@2@b@ YList 2 & F2YD2^.)@q. HE} Page Number ,&MQRwf <EFU4567;<Pw  o k 000000000 0 0 000000000000 0 0 0 0 0 00 000 0 0 0 0 000p 0 00p0 0 000 0 0 0000p00000@0@0@0@0@0@0@0@00EFU456 k 0000:00:00pz`I:00:00:00z00 z004 z00 z004 @0:0 z܏:0:00h 0h@0@0 0zD,7DDDG 9() f 4J) ~) ),37>@G!!/X2$6~yD.(,b$Er b+-յKC.@6(  J  # A"`J  # A"`B S  ?M7 'kTL? Tk FG x j k v 5 k FG x j k  Mary Conner|hZ<}X7~8ru kqΰd"4|  О6`Qp_0X:ppY]*xtVpR!A(@v]a)T:̆@F!vCZ^M  mN #xU'6vXBprB6](~^(w h|W{i{rtFL^`.^`.88^8`. ^`OJQJo( ^`OJQJo( 88^8`OJQJo( ^`OJQJo(^`. hh^h`OJQJo(hh^h`OJQJo(hHo88^8`OJQJ^Jo(hHo^`OJQJo(hH  ^ `OJQJo(hH  ^ `OJQJ^Jo(hHoxx^x`OJQJo(hHHH^H`OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hHh^`.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`.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(hH^`OJQJo(hH^`OJQJ^Jo(hHo pp^p`o(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 ^`o(hH. jj^j`o(hH. ^`o(hH) ::^:`o(hH() ^`o(hH()   ^ `o(hH() r r ^r `o(hH.   ^ `o(hH. BB^B`o(hH.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(hHo^`OJQJ^Jo(hHopp^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(hHh^`.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHpp^p`OJQJ^Jo(hHo @ @ ^@ `o(hH.^`OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hHPP^P`OJQJ^Jo(hHo  ^ `OJQJo(hH hh^h`hH) ^`hH) 88^8`hH) ^`hH() ^`hH()k@ pp^p`hH()   ^ `hH. @ @ ^@ `hH.   ^ `hH. hh^h`hH) ^`hH) 88^8`hH) ^`hH() ^`hH() pp^p`hH()   ^ `hH. @ @ ^@ `hH.   ^ `hH. ^`o(hH ^`o(hH. xx^x`o(hH) ^`o(hH() HH^H`o(hH()   ^ `o(hH()   ^ `o(hH.   ^ `o(hH.   ^ `o(hH.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`.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^`OJQJo(hHopp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hHh^`.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(hH^]vX_0R!rt]a)w hA(p!vC0M~}| mN#xUtB6] W{i6`T:L         L                                                              L                          L                           L                           Y/ZHmih3"%1{pn!h  ,I2u1N7P*@0!+d],-v:-Q-v0 1:{48:u=j>{BCVC:GEJ?@ABCDEFGHIJKLMNOPQRSTUVXYZ[\]^`abcdefiRoot Entry FQEkData  1Table(\WordDocument>SummaryInformation(WDocumentSummaryInformation8_CompObjj  FMicrosoft Word Document MSWordDocWord.Document.89qZOh+'0 ,8 T ` l x!Patterns of Spatial Distributionicratt Mary Conneraryary Normal.dot Mary Conner17yMicrosoft Word 10.0@\@@@ã@@ Z՜.+,0 hp   CDOW/CSUoe  !Patterns of Spatial Distribution TitleJLPR^(((9)d)e)n)o)p){)|)})~)),>.> &`#$gdd],  !#gdrh^hgd((((9)D)E)Y)Z)b)c)d)e)f)l)m)n)o)p)q)w)x)y)z){)|)})~))(>*>,>.>༲{whuWhuW0JmHnHuhuW6CJaJmHnHuh:Gh:G0JmHnHuhd],hHE} hHE}0JjhHE}0JUh7bh6CJaJmHnHu jhrh7b6CJUaJhrh7b6CJaJ h1h1h1h1h5 Է~tIENDB`9/2/20043 D@D -NormalCJ^J_HaJmH sH tH DA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List H@H  PP Balloon TextCJOJQJ^JaJB1@B ] List Number & FdYDd4@4 rHeader  !4 @"4 rFooter  !>;@2> RW_ List Number 3  & FB:@BB RW_ List Number 2  & FVD20l@Q0RW_ 1 / a / i F@2@b@ YList 2 & F2YD2^.)@q. HE} Page Number ,&MQRwf <EFU4567;<Pw  o k 000000000 0 0 000000000000 0 0 0 0 0 00 000 0 0 0 0 000p 0 00p0 0 000 0 0 0000p00000@0@0@0@0@0@0@0@00EFU456 k 0000:00:00pz`I:00:00:00z00 z004 z00 z004 @0:0 z܏:0:00h0b0Qbz@0@0 0zD,7DDDG 9(.> f 4J.> ~) ),37>@G!!/X2$6~yD.(,b$Er b+-յKC.@6(  J  # A"`J  # A"`B S  ?M7 'kTL? Tk j k 5 k FG x j k  Mary Conner|hZ<}X7~8ru kqΰd"4|  О6`Qp_0X:ppY]*xtVpR!A(@v]a)T:̆@F!vCZ^M  mN #xU'6vXBprB6](~^(w h|W{i{rtFL^`.^`.88^8`. ^`OJQJo( ^`OJQJo( 88^8`OJQJo( ^`OJQJo(^`. hh^h`OJQJo(hh^h`OJQJo(hHo88^8`OJQJ^Jo(hHo^`OJQJo(hH  ^ `OJQJo(hH  ^ `OJQJ^Jo(hHoxx^x`OJQJo(hHHH^H`OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hHh^`.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`.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(hH^`OJQJo(hH^`OJQJ^Jo(hHo pp^p`o(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 ^`o(hH. jj^j`o(hH. ^`o(hH) ::^:`o(hH() ^`o(hH()   ^ `o(hH() r r ^r `o(hH.   ^ `o(hH. BB^B`o(hH.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(hHo^`OJQJ^Jo(hHopp^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(hHh^`.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHpp^p`OJQJ^Jo(hHo @ @ ^@ `o(hH.^`OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hHPP^P`OJQJ^Jo(hHo  ^ `OJQJo(hH hh^h`hH) ^`hH) 88^8`hH) ^`hH() ^`hH()k@ pp^p`hH()   ^ `hH. @ @ ^@ `hH.   ^ `hH. hh^h`hH) ^`hH) 88^8`hH) ^`hH() ^`hH() pp^p`hH()   ^ `hH. @ @ ^@ `hH.   ^ `hH. ^`o(hH ^`o(hH. xx^x`o(hH) ^`o(hH() HH^H`o(hH()   ^ `o(hH()   ^ `o(hH.   ^ `o(hH.   ^ `o(hH.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`.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^`OJQJo(hHopp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hHh^`.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(hH^]vX_0R!rt]a)w hA(p!vC0M~}| mN#xUtB6] W{i6`T:L         L                                                              L                          L                           L                           Y/ZHmji3"%1{pn!h  ,I2u1N7P*@uW0!+d],-v:-Q-v0 1:{48:u=j>{BCVC:GEJQR@PR@Q(>QR@PR@P*>PR@UnknownG:Times New Roman5Symbol3& :ArialCFComic Sans MS5& :Tahoma?5 :Courier New;Wingdings"hF  !4e e  3QH + Patterns of Spatial Distribution Mary Conner Mary Conner                       ͡Dz KK ͼ*ꋱ,8 _/[6xrYiɗ-|Kj ^\VZj`Ս*38 %}"k-aUUoxmPϿ9COTK ރj32S^ ltpb0p]@8_nJ׈GuB^eNˡs\-Qgk2v8GvHF_:Eb!8+F^v3&=zgl/yr2dr