Access Millions of academic & study documents

MATH 221 Statistics for Decision Making Lab Exercises

Content type
User Generated
Subject
Statistics
Type
Other
Showing Page:
1/6
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

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/6
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.
Blue
16%
Black
19%
Red
12%
White
19%
Gold
22%
Car Color: Pie Chart
Blue Black Red White Gold Silver

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/6

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 6 pages?
Access Now
Unformatted Attachment Preview
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 ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4