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

Descriptives

Sheet1

Descriptives

USEFUL NOTES FOR:

1a. Gather 10 MORE heights on 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.)

Introduction

In this week, we will continue with our data analysis by looking at the mean and standard deviation for our data set. The mean is 5’5″ and the standard deviation is 4 inches.

1a. Gather 10 MORE heights on your own to add to the 10 provided by your instructor. Do the following: Survey or measure 10 people to find their heights.

To measure a person’s height, you can use any of the following methods:

A ruler or measuring tape. This is the most basic method and it’s good to begin with because it allows you to get an idea of how much space there is between people. If you’re using a ruler or measuring tape, make sure that your arms are straight and parallel; otherwise, this will yield incorrect results (your friend may not be as tall as you thought).

A scale. Scales are great for weighing objects like food or medicine bottles—but what if we wanted to measure heights? Well then we’d need something else… like this!

Determine the mean and standard deviation for the 20 values by using the Week 3 Excel spreadsheet. (Round statistics to two decimals.)

Now that you’ve collected your data, it’s time to calculate the mean and standard deviation for the 20 values. To do this, follow these steps:

Open the Week 3 Excel spreadsheet and look at column A. It will contain a list of 20 heights in increments from 1 to 5 feet (for example, height 1 = 5 feet). These numbers represent how many people have each height value on average (in this case, 10 people per group). If a person has two different heights in their group—say one person had 2 feet for their first measurement and 3 feet for their second measurement—they would appear twice in column A because they are counted once as one member of each group (2/5=0; 3/5=1).

Next, look at column B where you’ll see another set of numbers arranged according to standard deviation (i.e., how much off from the mean each value is). This represents how much variation there is between individual measurements taken by different people who measured themselves during this exercise!

The mean is 5’5″ and the standard deviation is 4 inches

The mean is 5’5″ and the standard deviation is 4 inches.

The mean of your sample data is 5’4″, but you’d like to know what it would be for all 20 people in your class if they were all at their respective heights (5’6″). So, what’s an easy way to find out? Just use Excel! Take a look at this spreadsheet:

Select cells A1 through A20, then click on “Data” and then “Average” (or press Ctrl+A).

In cell B1 enter =mean(range$A1:G20)

Conclusion

Hopefully, you’ve enjoyed this exercise as much as we have. We hope that it has been useful in helping you gather some more data, and that you can use it to improve your own work. Remember that Excel is a powerful tool, and while it can be tricky to learn how best to use it, there are many resources available online if you need more guidance on how best practice works with spreadsheets. Good luck!