Statistics for Decision Making Week

1
MATH221 Statistics for Decision Making
Week 2 Lab
Name: _______________________
Statistical Concepts that you will learn after completing this iLab:
 Using Excel for Statistics
 Graphics
 Descriptive Statistics
 Empirical Rule
Week 2 Lab Instructions-BEGIN
 Data have already been formatted and entered into an Excel worksheet.
 Obtain the data file for this lab from your instructor.
 Use the Week 1 spreadsheet (available from the top of the Week 1 Lesson) for graphs
and calculations. You will need to copy data from the data file into the calculations
spreadsheet to answer some questions.
 The names of each variable from the survey are in the first row of the Worksheet.
This row has a background color of gray to identify it as the variable names. All other
rows of the Worksheet represent a certain students’ answers to the survey questions.
Therefore, the rows are called observations and the columns are called variables. On
page 6 of this lab, you will find a code sheet that identifies the correspondence
between the variable names and the survey questions.
 Follow the directions below and then paste the graphs from Excel in the grey areas
for question 1 through 3. You will be using the Week 1 Excel Sheet for many of the
calculations. Type your answers to questions 4 through 11 where noted in the grey
areas. When asked for explanations, please give thorough, multi-sentence or
paragraph length explanations.
 The completed Lab Word Document with your responses to the 11 questions will be
the ONE and only document submitted to the Week 2: Lab. When saving and
submitting the document, you are required to use the following format: Last Name_
First Name_Week2Lab.
Week 2 Lab Instructions-END

2
Creating Graphs
1. Create a pie chart for the variable Car Color: Select the column with the Car variable,
including the title of Car Color. Click on Insert, and then Recommended Charts. It
should show a clustered column and click OK. Once the chart is shown, right click
on the chart (main area) and select Change Chart Type. Select Pie and OK. Click
on the pie slices, right click Add Data Labels, and select Add Data Callouts. Add
an appropriate title. Copy and paste the chart here.
2. Create a scatter plot with the variables of Drive and Money. Copy the Drive variable
from the data file and paste it into the x column in the Scatter Plot worksheet of the
Week 1 Excel file. Copy the Money variable from the data file and paste it into the y
column. Copy and paste the scatter plot below.