Question 11 Based on the Replicate Data below, find the Mean volume, Median Volume, Spread, and Standard deviation and record them in the same order with no units, no sientific notation and proper number S.F. (Mean Volume and Median Volume - 4 S.F.; Spread and Standard Deviation - 2 S.F.) Replicate Data on the Calibration of a 10ml Pipette No. 2 57699SAWN 4 8 10 11 12 13 14 15 16 17 Blank # 1 Blank # 2 Blank # 3 Blank # 41 Vol, ml. 9.988 9.973 9.986 9.980 9.975 9.982 9.986 9.982 9.981 9.990 9.980 9.989 9.978 9.971 9.982 9.983 9.988 No. 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Vol, ml. 9.975 9.980 9.994 9.992 9.984 9.981 9.987 9.978 9.983 9.982 9.991 9.981 9.969 9.985 9.977 9.976 9.983 N A N No. 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Vol, ml 9.976 9.990 9.988 9.971 9.986 9.978 9.986 9.982 9.977 9.977 9.986 9.978 9.983 9.980 9.983 9.979

Appl Of Ms Excel In Analytical Chemistry
2nd Edition
ISBN:9781285686691
Author:Crouch
Publisher:Crouch
Chapter2: Basic Statistical Analysis With Excel
Section: Chapter Questions
Problem 3P
icon
Related questions
Question
Question 11
Based on the Replicate Data below, find the Mean volume, Median
Volume, Spread, and Standard deviation and record them in the same order with no
units, no sientific notation and proper number S.F. (Mean Volume and Median
Volume - 4 S.F.; Spread and Standard Deviation - 2 S.F.)
Replicate Data on the Calibration of a 10ml Pipette
Vol, ml.
No.
1234
57699SAWN
8
10
11
12
13
14
15
16
17
Blank # 1
Blank # 2.
Blank # 3
Blank # 4
9.988
9.973
9.986
9.980
9.975
9.982
9.986
9.982
9.981
9.990
9.980
9.989
9.978
9.971
9.982
9.983
9.988
No.
18
19
20
21
22
23
24
25
26
27
28
29
30 31 32 33 34
Vol, ml.
9.975
9.980
9.994
9.992
9.984
9.981
9.987
9.978
9.983
9.982
9.991
9.981
9.969
9.985
9.977
9.976
9.983
N
A
N
No.
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Vol, ml
9.976
9.990
9.988
9.971
9.986
9.978
9.986
9.982
9.977
9.977
9.986
9.978
9.983
9.980
9.983
9.979
Transcribed Image Text:Question 11 Based on the Replicate Data below, find the Mean volume, Median Volume, Spread, and Standard deviation and record them in the same order with no units, no sientific notation and proper number S.F. (Mean Volume and Median Volume - 4 S.F.; Spread and Standard Deviation - 2 S.F.) Replicate Data on the Calibration of a 10ml Pipette Vol, ml. No. 1234 57699SAWN 8 10 11 12 13 14 15 16 17 Blank # 1 Blank # 2. Blank # 3 Blank # 4 9.988 9.973 9.986 9.980 9.975 9.982 9.986 9.982 9.981 9.990 9.980 9.989 9.978 9.971 9.982 9.983 9.988 No. 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Vol, ml. 9.975 9.980 9.994 9.992 9.984 9.981 9.987 9.978 9.983 9.982 9.991 9.981 9.969 9.985 9.977 9.976 9.983 N A N No. 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Vol, ml 9.976 9.990 9.988 9.971 9.986 9.978 9.986 9.982 9.977 9.977 9.986 9.978 9.983 9.980 9.983 9.979
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Statistics and Analytical Chemistry
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, chemistry and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Appl Of Ms Excel In Analytical Chemistry
Appl Of Ms Excel In Analytical Chemistry
Chemistry
ISBN:
9781285686691
Author:
Crouch
Publisher:
Cengage
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Fundamentals Of Analytical Chemistry
Fundamentals Of Analytical Chemistry
Chemistry
ISBN:
9781285640686
Author:
Skoog
Publisher:
Cengage
Chemistry & Chemical Reactivity
Chemistry & Chemical Reactivity
Chemistry
ISBN:
9781133949640
Author:
John C. Kotz, Paul M. Treichel, John Townsend, David Treichel
Publisher:
Cengage Learning
Principles of Modern Chemistry
Principles of Modern Chemistry
Chemistry
ISBN:
9781305079113
Author:
David W. Oxtoby, H. Pat Gillis, Laurie J. Butler
Publisher:
Cengage Learning