Description
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
- Open the Heart Rate Dataset in Excel
- 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)
- 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:
- 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.)
- Copy and paste your graphs and tables into a Word document, along with a brief description of the variable represented in the graph.
Additional Instructions:
Your assignment should be typed into a Word or other word processing document,formatted in APA style. The assignments must include
- Running head
- A title page with
- Assignment name
- Your name
- Professor’s name
- Course
Estimated time to complete: 3 hours
Explanation & Answer
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
Review
