Write the solution, answer it in Excel, and capture the spreadsheet. 1. Three students (A, B, and C) are asked to determine the volume of a sample of ethanol. Each student measures the volume five times with a graduated cylinder. The results in milliliters are: A (67.1, 67.4, 66.9, 67.3, 66.8), B (66.9, 67.1, 66.9, 67.1, 67.1), C (67.6, 67.4, 67.5, 67.6, 68.3). The true volume is 67.0 ml. a. Get the mean, SD, and % RSD of each student b. Comment on the precision and the accuracy of each student's results. c. Use the following table to summarize your results. Student A Student B Student C Mean SD %RSD Absolute Error Relative Error Comment
Write the solution, answer it in Excel, and capture the spreadsheet. 1. Three students (A, B, and C) are asked to determine the volume of a sample of ethanol. Each student measures the volume five times with a graduated cylinder. The results in milliliters are: A (67.1, 67.4, 66.9, 67.3, 66.8), B (66.9, 67.1, 66.9, 67.1, 67.1), C (67.6, 67.4, 67.5, 67.6, 68.3). The true volume is 67.0 ml. a. Get the mean, SD, and % RSD of each student b. Comment on the precision and the accuracy of each student's results. c. Use the following table to summarize your results. Student A Student B Student C Mean SD %RSD Absolute Error Relative Error Comment
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter2: Equations And Inequalities
Section: Chapter Questions
Problem 76RE
Related questions
Question
Transcribed Image Text:Write the solution, answer it in Excel, and capture the spreadsheet.
1. Three students (A, B, and C) are asked to determine the volume of a sample of ethanol. Each student
measures the volume five times with a graduated cylinder. The results in milliters are: A (67.1, 67.4,
66.9, 67.3, 66.8), B (66.9, 67.1, 66.9, 67.1, 67.1), C (67.6, 67.4, 67.5, 67.6, 68.3). The true volume is
67.0 ml.
a. Get the mean, SD, and % RSD of each student
b. Comment on the precision and the accuracy of each student's results.
c. Use the following table to summarize your results.
Student A
Student B
Student C
Mean
SD
%RSD
Absolute Error
Relative Error
Comment
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 5 images
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
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