Use a spreadsheet to calculate the mean and standard deviation of the data set. 54.99, 54.40, 54.60, 54.63, 54.36 The figure shows a suggested setup for your spreadsheet, where you enter the data in the highlighted cells and enter formulas in cells C4:D8 and B9:B11 to carry out the appropriate calculations.

Principles of Instrumental Analysis
7th Edition
ISBN:9781305577213
Author:Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Chapter1: Introduction
Section: Chapter Questions
Problem 1.10QAP
icon
Related questions
Question
Use a spreadsheet to calculate the mean and standard
deviation of the data set.
54.99, 54.40, 54.60, 54.63, 54.36
The figure shows a suggested setup for your spreadsheet,
where you enter the data in the highlighted cells and enter
formulas in cells C4:D8 and B9:B11 to carry out the
appropriate calculations.
mean:
standard deviation:
Transcribed Image Text:Use a spreadsheet to calculate the mean and standard deviation of the data set. 54.99, 54.40, 54.60, 54.63, 54.36 The figure shows a suggested setup for your spreadsheet, where you enter the data in the highlighted cells and enter formulas in cells C4:D8 and B9:B11 to carry out the appropriate calculations. mean: standard deviation:
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Activities
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.
Similar questions
Recommended textbooks for you
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
Appl Of Ms Excel In Analytical Chemistry
Appl Of Ms Excel In Analytical Chemistry
Chemistry
ISBN:
9781285686691
Author:
Crouch
Publisher:
Cengage