biol 2260 EXCEL workshop assignment-worksheet Fall 2023 (1) (1)
.xlsx
keyboard_arrow_up
School
Trent University *
*We aren’t endorsed by this school
Course
2260H
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
xlsx
Pages
9
Uploaded by sakurahansford
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
195
73.66
245
77.47
150
58.42
170
45.72
145
45.72
175
71.12
100
45.72
9) Make XY graph showing Age (yars) of the sugar maple against diameter at breats height . Include the line of best fit, R2 value and Slope equation. 80
100
120
140
160
180
200
0
10
20
30
40
50
60
70
80
90
sugar maple age (years)
DBhb cm
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
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help