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.

Mathematics For Machine Technology
8th Edition
ISBN:9781337798310
Author:Peterson, John.
Publisher:Peterson, John.
Chapter25: Achievement Review—section Two
Section: Chapter Questions
Problem 25AR: Engine pistons and cylinder heads are made of an aluminum casting alloy that contains 4% silicon,...
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
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt