Exercise calculate the mean and standard deviation of the following set of analytical data. 15.67, 15.69, 14.89, 15.91, 16.01 Excel Functions. 1. Statistical functions Functions on Excel AVERAGE() MEDIAN() STDEV()) COUNT() MAX() MIN() Meaning calculate the mean of a series of numbers Calculate the median of a series of numbers Calculate the standard deviation of a series of numbers Calculate the number of entries Find the highest value in a series of numbers Find the lowest value in a series of numbers

Fundamentals Of Analytical Chemistry
9th Edition
ISBN:9781285640686
Author:Skoog
Publisher:Skoog
Chapter7: Statistical Data Treatment And Evaluation
Section: Chapter Questions
Problem 7.33QAP
icon
Related questions
Question
Exercise : calculate the mean and standard deviation of the following set of analytical
data.
15.67, 15.69, 14.89, 15.91, 16.01
Excel Functions.
1. Statistical functions
Functions on Excel Meaning
AVERAGE()
MEDIAN())
STDEV())
COUNT())
MAX())
MIN()
calculate the mean of a series of numbers
Calculate the median of a series of numbers
Calculate the standard deviation of a series of numbers
Calculate the number of entries
Find the highest value in a series of numbers
Find the lowest value in a series of numbers
Transcribed Image Text:Exercise : calculate the mean and standard deviation of the following set of analytical data. 15.67, 15.69, 14.89, 15.91, 16.01 Excel Functions. 1. Statistical functions Functions on Excel Meaning AVERAGE() MEDIAN()) STDEV()) COUNT()) MAX()) MIN() calculate the mean of a series of numbers Calculate the median of a series of numbers Calculate the standard deviation of a series of numbers Calculate the number of entries Find the highest value in a series of numbers Find the lowest value in a series of numbers
Expert Solution
steps

Step by step

Solved in 2 steps with 1 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
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
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning