biol 2260 EXCEL workshop assignment-worksheet Fall 2023 (1) (1)

Instruction Review a set of EXCEL instruction Videos- access through mytrent, complete the attached EXCEL worksheet and There are a total of 10 worksheet questions. They are highlighted in yellow. Please put your answers in the cells highlighted in blue. Sample answers are given for some of the questions. Additional hints for some of the questions are immbeded as comments within the hightlighted cells. ( Note the red Exercise 1- Basic Functions Table 1: Length of mature crayfish at 4 different cold wat Bear creek Willow Creek Whitlaw Creek 5 8 9 6 7 6 4 5 7 4 5 6 5 8 9 4 5 4 6 4 9 6 4 4 6 8 6 5 6 4 9 4 7 8 4 8 5 6 7 5 7 4 EXCEL- Workshop assignment #1 - please submit Completed EXCEL file into to Blackboard EXCEL workshop assessment board

Bear creek Willow Creek Whitlaw Creek 7 22 13 34 127 88 4.86 5.772727273 6.769230769 5) Calculate the standard deviation 0.9 65.8 1.8 1.0 73.1 2.0 1.6 1.8 1.9 Fig 1: Bar graph showing (com the sd average if the length of the crayf Sugar Maple age (years) DBH (cm) 100 38.1 101 40.64 140 52.07 180 60.96 Sample answers -see if you can work out the same answers listed below) 1) Count the number of samples taken at each creek 2) Sum the number crayfish collected at each creek 4) Calculate the average size of crayfish for each creek 6) Calculate the relative SD. This is the SD for the creek divided by the lowest SD of all four creeks 7) Calculate the natural log (ln) of the average 8) Make a bar graph showing the average length of crayfish sampled at each site. Include SD bars . 1 2 3 4 0 1 2 3 4 5 6 7 8 crayfish sample average SD of the crayfish

d submit the EXCEL exercise sheet into the workshop assignment box d red corner of the highted cells.) Exercise 2- Multiple calculations in a single step ter streams Harper Creek Bear creek Willow Creek Whitlaw Creek Harper Creek 8 25 64 81 64 5 36 49 36 25 10 16 25 49 100 5 16 25 36 25 10 25 64 81 100 10 16 25 16 100 7 36 16 81 49 9 36 16 81 5 16 36 25 9 64 36 81 9 25 36 81 8 16 81 64 8 16 49 64 6 64 36 7 16 49 7 64 49 7 25 49 9 36 81 10 49 100 6 25 36 10 49 100 5 16 25 6 36 5 25 9 81 5 25 8 64 7 49 10 100 10) Square each value in the table 1 and put the values in the table below

9 81 6 36 7 49 9 81 5 25 Harper Creek 34 256 7.529411765 1.8 2.0 2.0 fish sample for each site. 4

Su Pl DBH (cm)