# Week 2 Statistics hello

User Generated

whfgNfuyrl123

Mathematics

320 statistics

Herzing University

## Unit 2: Graphing Data

Evaluation Title: Assignment 2 Rubric

Instructions:

In this assignment, you will be required to use the Heart Rate Dataset to complete the following:

• Identify the types of variables
• Match variables to graph types
• Create graphs
• Give a brief written description of the variables based on their graphs

Steps

1. Open the Heart Rate Dataset in Excel
2. Identify each of the variables contained in the dataset by type, and match each to an appropriate graph type. (For example: qualitative data can best be displayed with a pie chart or bar graph; continuous numerical data can best be displayed using a histogram)
3. Use the graphing functions in Excel to create an appropriate graph of the data for each variable. Remember to properly label your graphs. Please note that qualitative data needs to be sorted before you can graph it. For example, if you have 32 Apples, 15 Oranges, and 38 Bananas in your dataset, you need to create a table like the one below before you can generate a graph:
4. If you are unsure how to create a graph in excel, search YouTube for guidance. (A search conducted using “Graphing in Excel” yielded many instructional videos with transcripts.)
5. Copy and paste your graphs and tables into a Word document, along with a brief description of the variable represented in the graph.

Your assignment should be typed into a Word or other word processing document,formatted in APA style. The assignments must include

• A title page with
• Assignment name
• Professor’s name
• Course

Estimated time to complete: 3 hours

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Attached.

Male
Female

108
92

Gender Variable

46%

54%

Male
Female

Heart beat before and after exercise for male
Before Exercise After Exercise
87,5
79,4
93,4
97,7
99,7
83,7
101,9
100,6
97,4
97,4
97,1
87,2
79,9
104,7
95,9
93,9
90,1
70,7
86,7
81,2
83,3
86,0
90,2
84,4
94,2
95,1
88,7
82,7
94,6
84,6
86,4
96,2
82,1
91,6
86,7
98,8
85,6
80,6
83,8
93,9
90,3
100,6
88,0
91,8
103,0

Heart beat before and after excercise for males
120,0
100,0
80,0
60,0
40,0
20,0
0,0

1
5
9
13
17
21
25
29
33
37
41
45
49
53
57
61
65
69
73

85,9
67,7
80,3
85,2
86,3
76,6
94,4
86,4
83,4
89,8
88,7
78,4
71,3
92,6
86,2
83,9
78,1
64,0
72,8
72,7
80,2
78,2
70,6
75,5
82,7
87,7
80,0
73,4
89,5
77,6
76,6
85,6
74,2
79,0
74,6
88,8
82,1
77,6
77,9
88,1
81,6
91,2
80,3
76,7
88,4

Before Exercise

After Exercise

75,2
75,2
73,1
77,0
59,0
84,9
87,5
75,6
84,0
78,2
86,6
84,9
78,8
69,4
78,3
76,9
84,2
76,3
86,3
72,3
81,8
92,8
74,8
91,7
71,0
96,1
82,5
81,9
89,7
81,4
74,8
88,1
69,2
78,8
85,3
74,8
77,7
78,0
80,5
75,4
81,5
73,9
69,4
89,4
70,9
82,9
89,6

86,5
84,9
71,9
84,7
68,2
96,0
105,9
84,3
90,4
94,0
90,6
95,1
90,4
82,6
91,1
92,3
87,9
85,9
99,7
80,9
93,8
99,8
90,2
99,2
87,0
100,2
95,1
97,5
94,8
100,9
94,0
102,1
81,4
90,9
94,2
81,3
89,9
89,8
95,3
84,8
84,2
85,2
74,1
96,7
82,0
90,2
106,7

74,5
92,3
87,7
78,9
79,8
85,5
87,3
77,8
71,0
82,5
74,8
69,2
80,5
89,4
74,5
85,5

75,6
102,...

### Review

Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4