MATH221 WK2 Statistics for Decision Making Lab & Descriptive Statistics Paper Open the Week 2 Lab Document (Links to an external site.)Links to an external

MATH221 WK2 Statistics for Decision Making Lab & Descriptive Statistics Paper Open the Week 2 Lab Document (Links to an external site.)Links to an external site.. All of the directions are included in the document.

The data for this lab is distributed by your professor.

Don't use plagiarized sources. Get Your Custom Essay on
MATH221 WK2 Statistics for Decision Making Lab & Descriptive Statistics Paper Open the Week 2 Lab Document (Links to an external site.)Links to an external
Just from $13/Page
Order Essay

The document includes places where you need to input the answers. Any place where you see a gray box is where you need to put an answer.

Deliverables

Fill in the document, save it with your name in the title, and submit the document.

Below is the grading rubric for this assignment.

Category

Points

%

Description

Questions 1-3, 9 points each, 27 points total

27

32%

Creating graphs and charts

Question 4

9

11%

Calculating means and standard deviations

Questions 5-11, 7 points each, 49 total

49

57%

Interpreting and using data

Total

85

100%

A quality lab will meet or exceed all of the above requirements. Drive (miles)
36
20
88
6
71
42
76
63
36
63
38
28
55
33
40
80
86
83
4
39
25
25
54
54
81
73
29
76
78
77
42
36
71
94
6
State
MI
IL
CA
IL
MI
IL
NY
PA
TX
NY
OR
NY
OH
SC
IL
NV
FL
FL
NY
SC
CA
GA
FL
CA
CA
FL
TX
PA
CA
PA
TX
OR
PA
KY
OR
Shoe Size
10
5
6
12
8
8
9
10
7
11
10
7
9
11
10
12
11
13
9
11
8
9
9
5
10
12
9
11
9
10
9
9
7
11
13
Height (inches)
61
62
63
63
64
65
65
66
66
67
67
67
67
68
68
69
69
69
69
69
69
69
70
70
70
70
70
71
71
71
73
73
74
74
75
Sleep (hours)
7
7
5
7
6
8
7
8
5
8
8
4
8
8
6
8
8
8
7
10
6
7
8
5
8
7
7
4
9
8
7
7
8
8
10
Gender
M
F
F
F
F
F
F
F
M
M
F
F
F
M
M
M
M
M
F
M
F
M
F
F
F
F
M
M
M
M
F
M
M
M
M
Car
blue
black
black
blue
blue
red
red
silver
orange
green
silver
black
dark blue
blue
green
white
black
blue
blue
red
silver
silver
green
green
black
green
silver
silver
blue
blue
black
blue
black
red
silver
TV (hours)Money (dollars) Coin
3
5.00
7
3
10.00
2
3
43.00
6
2
44.00
2
2
1.00
4
4
4.00
4
3
7.00
6
3
5.00
7
3
6.00
3
3
4.00
6
2
15.00
4
1
29.00
4
4
31.00
4
1
9.00
4
5
16.00
5
4
3.00
4
3
6.00
3
3
8.00
3
5
21.00
5
3
26.00
4
4
34.00
4
3
53.00
5
2
5.00
3
6
6.00
7
2
7.00
7
4
15.00
3
2
32.00
3
5
13.00
5
2
47.00
2
1
52.00
5
3
7.00
3
5
23.00
5
4
6.00
7
3
20.00
4
6
7.00
4
Die1
4
3
5
6
4
3
2
4
5
4
2
3
1
3
4
5
3
4
5
4
3
4
5
6
4
3
2
1
2
3
4
5
6
5
4
Die2
1
1
2
1
4
3
5
6
5
4
3
4
3
2
2
1
4
3
6
5
4
6
3
4
3
2
1
4
5
6
4
3
2
3
4
Die3
6
4
5
3
4
3
4
5
2
3
1
2
3
3
2
4
6
5
4
5
3
2
1
4
5
4
3
2
3
4
5
6
1
1
3
Die4
Die5
6
2
5
3
3
5
2
1
5
6
4
3
6
4
2
4
2
2
2
3
2
2
3
3
3
2
6
6
1
1
2
2
2
1
5
Die6
4
3
5
2
1
6
1
2
6
3
3
6
4
3
1
2
2
2
5
6
6
1
3
4
4
2
5
2
5
3
2
2
4
5
1
2
3
5
6
5
4
5
2
4
4
6
3
4
1
2
4
1
1
2
6
6
2
3
2
1
5
2
4
4
2
1
2
1
1
1
Die7
Die8
2
5
2
4
6
2
2
5
2
5
6
3
2
6
3
4
1
5
2
2
2
2
5
5
6
1
3
4
3
2
6
1
2
3
6
Die9
5
2
1
2
5
3
4
1
1
6
5
3
1
6
2
4
3
3
4
5
5
2
5
1
6
1
4
2
1
2
1
4
4
2
6
Die10
4
4
3
5
2
6
1
3
4
1
1
1
1
2
3
1
3
5
5
3
5
6
2
1
4
5
3
5
1
6
5
5
1
5
1
4
2
5
3
2
1
2
5
2
5
3
3
5
3
6
4
2
6
1
4
1
2
6
6
6
4
2
4
4
3
2
1
6
1
4
1
MATH221 Statistics for Decision Making
Week 2 Lab
Name: _______________________
Statistical Concepts that you will learn after completing this Lab:
• 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 Lab data file (Excel) for this lab from your instructor.
➢ Use the Week 1 spreadsheet (available from Week 1: Resources) for graphs and
calculations. You will need to copy data from the Lab data file into the Week 1
calculations spreadsheet to answer some of these Lab questions.
➢ The names of each variable from the survey are in the first row of the Lab data
Worksheet. This row has a double-underline to identify the heading row 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 the last page of this Week 2 Lab document, you will find a
Code Sheet section that identifies the correspondence between the variable names and
the survey questions.
➢ Follow the directions below and then paste the graphs from Excel into the gray
response 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 gray areas. When asked for explanations, please give thorough, multisentence 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 filename format,
replacing “Your_Name_Here” with your “Last name_First name”:
MATH221_W2_Lab_Excel_Your_Name_Here.docx
Week 2 Lab Instructions-END
Last Revised for SEP18
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 histogram for the variable Height. You need to create a frequency
distribution for the data by hand. Use 5 classes, find the class width, and then create
the classes. Once you have the classes, count how many data points fall within each
class. It may be helpful to sort the data based on the Height variable first. Once you
have the classes and the frequency counts, put those data into the table in the Freq
Distribution worksheet of the Week 1 Excel file. Copy and paste the graph here.
3. Create a scatter plot with the variables of height and money. Copy the height 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.
Calculating Descriptive Statistics
4. Calculate descriptive statistics for the variable Height by Gender. Sort the data by
gender by clicking on Data and then Sort. Copy the heights of the males form the
data file into the Descriptive Statistics worksheet of the week 1 Excel file. Type the
standard deviations below. These are sample data. Then from the data file, copy and
paste the female data into the Descriptive Statistics workbook and do the same
Mean
Females
Males
Last Revised for SEP18
Standard deviation
3
Short Answer Writing Assignment
All answers should be complete sentences.
5. What is the most common color of car for students who participated in this survey?
Explain how you arrived at your answer.
6. What is seen in the histogram created for the heights of students in this class (include
the shape)? Explain your answer.
7. What is seen in the scatter plot for the height and money variables? Explain your
answer.
8. Compare the mean for the heights of males and the mean for the heights of females in
these data. Compare the values and explain what can be concluded based on the
numbers.
9. Compare the standard deviation for the heights of males and the standard deviation for
the heights of females in the class. Compare the values and explain what can be
concluded based on the numbers.
10. Using the empirical rule, 95% of female heights should be between what two values?
Either show work or explain how your answer was calculated.
Last Revised for SEP18
4
11. Using the empirical rule, 68% of male heights should be between what two values?
Either show work or explain how your answer was calculated.
Last Revised for SEP18
5
Code Sheet
Do NOT answer these questions.
The Code Sheet just lists the variables name and the question used by the researchers on
the survey instrument that produced the data that are included in the data file. This is just
information. The first question for the lab is after the code sheet.
Variable Name
Question
Drive
Question 1 – How long does it take you to drive to the school on
average (to the nearest minute)?
State
Question 2 – What state/country were you born?
Temp
Question 3 – What is the temperature outside right now?
Rank
Question 4 – Rank all of the courses you are currently taking. The
class you look most forward to taking will be ranked one, next two,
and so on. What is the rank assigned to this class?
Height
Question 5 – What is your height to the nearest inch?
Shoe
Question 6 – What is your shoe size?
Sleep
Question 7 – How many hours did you sleep last night?
Gender
Question 8 – What is your gender?
Race
Question 9 – What is your race?
Car
Question 10 – What color of car do you drive?
TV
Question 11 – How long (on average) do you spend a day watching
TV?
Money
Question 12 – How much money do you have with you right now?
Coin
Question 13 – Flip a coin 10 times. How many times did you get
tails?
Die1
Question 14 – Roll a six-sided die 10 times and record the results.
Die2
Die3
Die4
Die5
Die6
Die7
Die8
Die9
Die10
Last Revised for SEP18

Purchase answer to see full
attachment

Homework On Time
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers