Using Excel plot out your data from the pipetting exercise. You One in which you analyze data for mass vs. volume for water and one in which you analyze the date you collected for mass vs. volume for glycerol. For both graphs make sure to calculate averages and standard deviations for the masses from your three replicates of the experiment. You should graph out the average values and use the standard deviations to include error bars on your graph (as in Exercise 2 of the Excel Tutorial). Make sure to insert a trend line on your graph and, using the equation of this line, determine the density (slope of the line) for both water and 50% glycerol. Hand in these two graphs at the next class period.

Human Anatomy & Physiology (11th Edition)
11th Edition
ISBN:9780134580999
Author:Elaine N. Marieb, Katja N. Hoehn
Publisher:Elaine N. Marieb, Katja N. Hoehn
Chapter1: The Human Body: An Orientation
Section: Chapter Questions
Problem 1RQ: The correct sequence of levels forming the structural hierarchy is A. (a) organ, organ system,...
icon
Related questions
Question
Bio 111 post lab
Using Excel, plot out your data from the pipetting exercise. You should generate two graphs: one in which you analyze data for mass vs. volume for water and one in which you analyze the data you collected for mass vs. volume for glycerol. For both graphs, make sure to calculate averages and standard deviations for the masses from your three replicates of the experiment. You should graph out the average values and use the standard deviations to include error bars on your graph (as in Exercise 2 of the Excel Tutorial). Make sure to insert a trend line on your graph and, using the equation of this line, determine the density (slope of the line) for both water and 50% glycerol. Hand in these two graphs at the next class period.
Transcribed Image Text:Using Excel, plot out your data from the pipetting exercise. You should generate two graphs: one in which you analyze data for mass vs. volume for water and one in which you analyze the data you collected for mass vs. volume for glycerol. For both graphs, make sure to calculate averages and standard deviations for the masses from your three replicates of the experiment. You should graph out the average values and use the standard deviations to include error bars on your graph (as in Exercise 2 of the Excel Tutorial). Make sure to insert a trend line on your graph and, using the equation of this line, determine the density (slope of the line) for both water and 50% glycerol. Hand in these two graphs at the next class period.
**Volume and Mass Measurements for Water and Glycerol**

This table provides data on the mass of different volumes of Water and Glycerol. The table is organized to show three measurements each for Water and Glycerol across five different volume units.

**Volume Measurements:**
1. Volume 1
2. Volume 2
3. Volume 3
4. Volume 4
5. Volume 5

**Water Mass Measurements (in grams):**
- Volume 1: 0.879g, 0.999g, 1.009g
- Volume 2: 1.869g, 1.999g, 2.009g
- Volume 3: 2.769g, 3.009g, 3.009g
- Volume 4: 3.699g, 3.999g, 4.019g
- Volume 5: 4.689g, 4.999g, 5.019g

**Glycerol Mass Measurements (in grams):**
- Volume 1: 1.169g, 1.169g, 1.159g
- Volume 2: 2.319g, 2.319g, 2.309g
- Volume 3: 3.469g, 3.469g, 3.479g
- Volume 4: 4.629g, 4.609g, 4.639g
- Volume 5: 5.779g, 5.769g, 5.779g

This data can be used to analyze the density and consistency of the mass measurements for both fluids across varying volumes.
Transcribed Image Text:**Volume and Mass Measurements for Water and Glycerol** This table provides data on the mass of different volumes of Water and Glycerol. The table is organized to show three measurements each for Water and Glycerol across five different volume units. **Volume Measurements:** 1. Volume 1 2. Volume 2 3. Volume 3 4. Volume 4 5. Volume 5 **Water Mass Measurements (in grams):** - Volume 1: 0.879g, 0.999g, 1.009g - Volume 2: 1.869g, 1.999g, 2.009g - Volume 3: 2.769g, 3.009g, 3.009g - Volume 4: 3.699g, 3.999g, 4.019g - Volume 5: 4.689g, 4.999g, 5.019g **Glycerol Mass Measurements (in grams):** - Volume 1: 1.169g, 1.169g, 1.159g - Volume 2: 2.319g, 2.319g, 2.309g - Volume 3: 3.469g, 3.469g, 3.479g - Volume 4: 4.629g, 4.609g, 4.639g - Volume 5: 5.779g, 5.769g, 5.779g This data can be used to analyze the density and consistency of the mass measurements for both fluids across varying volumes.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Human Anatomy & Physiology (11th Edition)
Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON
Biology 2e
Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax
Anatomy & Physiology
Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,
Molecular Biology of the Cell (Sixth Edition)
Molecular Biology of the Cell (Sixth Edition)
Biology
ISBN:
9780815344322
Author:
Bruce Alberts, Alexander D. Johnson, Julian Lewis, David Morgan, Martin Raff, Keith Roberts, Peter Walter
Publisher:
W. W. Norton & Company
Laboratory Manual For Human Anatomy & Physiology
Laboratory Manual For Human Anatomy & Physiology
Biology
ISBN:
9781260159363
Author:
Martin, Terry R., Prentice-craver, Cynthia
Publisher:
McGraw-Hill Publishing Co.
Inquiry Into Life (16th Edition)
Inquiry Into Life (16th Edition)
Biology
ISBN:
9781260231700
Author:
Sylvia S. Mader, Michael Windelspecht
Publisher:
McGraw Hill Education