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.

Principles Of Radiographic Imaging: An Art And A Science
6th Edition
ISBN:9781337711067
Author:Richard R. Carlton, Arlene M. Adler, Vesna Balac
Publisher:Richard R. Carlton, Arlene M. Adler, Vesna Balac
Chapter1: Basic Mathematics
Section: Chapter Questions
Problem 7RQ
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
Principles Of Radiographic Imaging: An Art And A …
Principles Of Radiographic Imaging: An Art And A …
Health & Nutrition
ISBN:
9781337711067
Author:
Richard R. Carlton, Arlene M. Adler, Vesna Balac
Publisher:
Cengage Learning
Basic Clinical Laboratory Techniques 6E
Basic Clinical Laboratory Techniques 6E
Biology
ISBN:
9781133893943
Author:
ESTRIDGE
Publisher:
Cengage
Principles Of Pharmacology Med Assist
Principles Of Pharmacology Med Assist
Biology
ISBN:
9781337512442
Author:
RICE
Publisher:
Cengage
Biomedical Instrumentation Systems
Biomedical Instrumentation Systems
Chemistry
ISBN:
9781133478294
Author:
Chatterjee
Publisher:
Cengage
Curren'S Math For Meds: Dosages & Sol
Curren'S Math For Meds: Dosages & Sol
Nursing
ISBN:
9781305143531
Author:
CURREN
Publisher:
Cengage
Case Studies In Health Information Management
Case Studies In Health Information Management
Biology
ISBN:
9781337676908
Author:
SCHNERING
Publisher:
Cengage