Week 5 Lab TEMPLATE
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 courseroom.
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. This data set is
posted in the FILES area, in the “Lab Files” folder. (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 heights of your friends, co-workers, random
people in the mall, etc. to add to the 10 provided by your
instructor. Determine the mean and standard deviation for the
20 values by using the Week 3 Excel spreadsheet. (Round
statistics to two decimals. )
Sample mean = 67.75
Sample standard deviation = 3.14
1b. Post a screen shot in the space BELOW of the portion of the
spreadsheet that helped you determine these values. The
screenshot should show ALL 20 pieces of data (10 that I gave you
and 10 that you gathered on your own). Make sure the instructor
data is listed first and then your data is listed under.
