BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 46

kids flock to swimming pools, leading to more accidents, and the
more ice cream is sold. So you see, although statistics are vital in the
world of decision making, you have to be wise, and ask the right
questions.
STEP 1: Getting Started—Worksheet Template
Please download this week's iLab file: Week7_iLab_Statistics
Your first step should be to save and rename this file according to the
naming convention above.
It is recommended, as you work on this iLab, that you save your work
often.
STEP 2: Create a Documentation Page
This will be a similar documentation page that you have used for all
prior iLabs. Please refer to instructions in iLab 1 for detailed
instructions.
Be sure to place the documentation sheet as your first sheet.
STEP 3: Descriptive Statistics
The Data_1971_2000 worksheet is already loaded with data for you,
which is the actual temperatures for all of the U.S. states between
1971 and 2001. As you can see, the data already contains the
averagetemperature for each state, in both Fahrenheit and Celsius,
along with the ranking of the states, in terms of warmest average
temperature (#1) to the lowest.
1.
Freeze the top row, so that the column headers are visible as
you scroll through the data.