Homework Help is Here – Start Your Trial Now!
Math
Statistics
TABLE 1: Hg concentration in Fish Oreochromis niloticus Lobochilus bo Hemibagrus planiceps 1 0.3972 0.6739 1.6168 0.3892 0.6339 1.6563 0.4202 0.6851 1.6768 uestions: 1 Use the built-in function of Excel to calculate the average and standard deviation of Hg in each species. Plot a bar graph of the Hg concentrations in three species with error bars. Label the y and x-axis. 3 Use the Excel data analysis function to analyse whether there is any significant different in the Hg concentrations in three species of fish at 95% confidence level. You need to show the statistical analysis results.

TABLE 1: Hg concentration in Fish Oreochromis niloticus Lobochilus bo Hemibagrus planiceps 1 0.3972 0.6739 1.6168 0.3892 0.6339 1.6563 0.4202 0.6851 1.6768 uestions: 1 Use the built-in function of Excel to calculate the average and standard deviation of Hg in each species. Plot a bar graph of the Hg concentrations in three species with error bars. Label the y and x-axis. 3 Use the Excel data analysis function to analyse whether there is any significant different in the Hg concentrations in three species of fish at 95% confidence level. You need to show the statistical analysis results.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section: Chapter Questions
Problem 22SGR
See similar textbooks
icon
Related questions
Question

Use Excel

Need right now, will rate you :)

thanks

TABLE 1: Hg concentration in Fish Oreochromis niloticus Lobochilus bo Hemibagrus planiceps 0.3972 0.6739 1.6168 2 0.3892 0.6339 1.6563 3 0.4202 0.6851 1.6768 Questions: 1 Use the built-in function of Excel to calculate the average and standard deviation of Hg in each species. Plot a bar graph of the Hg concentrations in three species with error bars. Label the y and x-axis. 3 Use the Excel data analysis function to analyse whether there is any significant different in the Hg concentrations in three species of fish at 95% confidence level. You need to show the statistical analysis results.
Transcribed Image Text:TABLE 1: Hg concentration in Fish Oreochromis niloticus Lobochilus bo Hemibagrus planiceps 0.3972 0.6739 1.6168 2 0.3892 0.6339 1.6563 3 0.4202 0.6851 1.6768 Questions: 1 Use the built-in function of Excel to calculate the average and standard deviation of Hg in each species. Plot a bar graph of the Hg concentrations in three species with error bars. Label the y and x-axis. 3 Use the Excel data analysis function to analyse whether there is any significant different in the Hg concentrations in three species of fish at 95% confidence level. You need to show the statistical analysis results.
Expert Solution
steps

Step by step

Solved in 5 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
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
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS