Large (28.5-36.5 cm) Replicate 1 Medium (24.5 – 28.4 cm) Replicate 1 Small (12.5 – 24.4 cm) Replicate 1 Large (28.5-36.5 cm) Replicate 2 Medium (24.5 – 28.4 cm) Replicate 2 Small (12.5 – 24.4 cm) Replicate 2 Large (28.5-36.5 cm) Replicate 3 Medium (24.5 – 28.4 cm) Replicate 3 Small (12.5 – 24.4 cm) Replicate 3 5.05 mg/kg 8.26 mg/kg 3.17 mg/kg 4.37 mg/kg 6.17 mg/kg 3.00 mg/kg 5.72 mg/kg 9.49 mg/kg 3.44 mg/kg i. Organize the data into a table according to groups and replicates. ii. Calculate the mean and standard deviation of Hg concentration in three different sizes of Barbonymus schwanenfeldii. You are allowed to use Microsoft Excel. iii. Use Microsoft Excel to plot a bar graph to illustrate the mean concentration of Hg in three different sizes of Barbonymus schwanenfeldii. You must label the axis and include the standard deviation to your graph.

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter1: Variables, Expressions, And Integers
Section1.5: Adding Integers
Problem 45E
icon
Related questions
icon
Concept explainers
Topic Video
Question

Accumulation of mercury (Hg) in fish is hypothesized to correlate with the fish size. Barbonymus schwanenfeldii is a species commonly found in a dam in Sarawak. Table 1 shows data of Hg concentration (mg/kg) present in three sizes of fish caught in the dam in triplicates.

Large (28.5-36.5 cm) Replicate 1
Medium (24.5 – 28.4 cm) Replicate 1
Small (12.5 – 24.4 cm) Replicate 1
Large (28.5-36.5 cm) Replicate 2
Medium (24.5 – 28.4 cm) Replicate 2
Small (12.5 – 24.4 cm) Replicate 2
Large (28.5-36.5 cm) Replicate 3
Medium (24.5 – 28.4 cm) Replicate 3
Small (12.5 – 24.4 cm) Replicate 3
5.05 mg/kg
8.26 mg/kg
3.17 mg/kg
4.37 mg/kg
6.17 mg/kg
3.00 mg/kg
5.72 mg/kg
9.49 mg/kg
3.44 mg/kg
i.
Organize the data into a table according to groups and replicates.
ii.
Calculate the mean and standard deviation of Hg concentration in three
different sizes of Barbonymus schwanenfeldii. You are allowed to use Microsoft
Excel.
iii.
Use Microsoft Excel to plot a bar graph to illustrate the mean concentration of
Hg in three different sizes of Barbonymus schwanenfeldii. You must label the
axis and include the standard deviation to your graph.
Transcribed Image Text:Large (28.5-36.5 cm) Replicate 1 Medium (24.5 – 28.4 cm) Replicate 1 Small (12.5 – 24.4 cm) Replicate 1 Large (28.5-36.5 cm) Replicate 2 Medium (24.5 – 28.4 cm) Replicate 2 Small (12.5 – 24.4 cm) Replicate 2 Large (28.5-36.5 cm) Replicate 3 Medium (24.5 – 28.4 cm) Replicate 3 Small (12.5 – 24.4 cm) Replicate 3 5.05 mg/kg 8.26 mg/kg 3.17 mg/kg 4.37 mg/kg 6.17 mg/kg 3.00 mg/kg 5.72 mg/kg 9.49 mg/kg 3.44 mg/kg i. Organize the data into a table according to groups and replicates. ii. Calculate the mean and standard deviation of Hg concentration in three different sizes of Barbonymus schwanenfeldii. You are allowed to use Microsoft Excel. iii. Use Microsoft Excel to plot a bar graph to illustrate the mean concentration of Hg in three different sizes of Barbonymus schwanenfeldii. You must label the axis and include the standard deviation to your graph.
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Application of Algebra
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill