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
icon
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt