Week 5 Lab Assignment
Name:___Justine Saunders__________
Instructor Name: ___Megan Tesar____________
Please use this template to help answer the questions listed in the lab instructions.
The "steps" below
refer to the steps listed in the lab instructions.
Type your answers and post your screenshots in the
spaces given below.
Then, save this document with your name and submit it inside the course room.
Step 1.
Gather Data
Your instructors will post 10 data values to use for this lab.
The data values represent the HEIGHTS of
10 people.
Please reach out to your instructor if you did not receive the assigned 10 data values for the term by
Monday of Week 5.
(
NOTE:
This is NOT the data used in the lab video, which is about midterm grades.
Do not use the
midterm grades data.)
1a.
Gather 10 MORE of your own to add to the 10 provided by your instructor.
Do the following:
Survey or measure 10 people to find their heights. Determine the mean and standard deviation for the
20
values
by using the Week 3 Excel spreadsheet.
(Round statistics to two decimals.)
Instructor
: 60,63,65,66,66,67,70,71,72,73
Student
: 60,60,62,62,63,64,67,69,70,74
Mean Height in Inches
66.20
Sample Standard Deviation in inches
4.47
Your Height in Inches
64 inches
1b.
Post a screen shot in the space BELOW of the portion of the spreadsheet that helped you determine
these values.
Please list the 10 heights your professor provided first followed by the 10 heights you
collected.
There should be 20 values to determine the mean and sample standard deviation.
1