Suppose you have a sample data set 23, 43, 23, 20, 68, 68, 54, 154, 74, 43, 23, 11, 11 Ex.1 Put your new data set in column H starting with cell H2. Ex.1 Using Excel, find the mean of this data set. Put your result in cell H15 Ex. 3 Using Excel, evaluate the standard deviation of this new data set. Put your result in cell H16.
Suppose you have a sample data set 23, 43, 23, 20, 68, 68, 54, 154, 74, 43, 23, 11, 11 Ex.1 Put your new data set in column H starting with cell H2. Ex.1 Using Excel, find the mean of this data set. Put your result in cell H15 Ex. 3 Using Excel, evaluate the standard deviation of this new data set. Put your result in cell H16.
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 3CYU
Related questions
Question
Exercises
Suppose you have a sample data set 23, 43, 23, 20, 68, 68, 54, 154, 74, 43, 23, 11, 11
Ex.1 Put your new data set in column H starting with cell H2.
Ex.1 Using Excel, find the mean of this data set. Put your result in cell H15
Ex. 3 Using Excel, evaluate the standard deviation of this new data set. Put your result in cell H16.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt