Question

Steps

1. Open the Heart Rate Dataset in Excel
2. Using the classification of variables from Unit 1 assignment as qualitative, quantitative discrete, or quantitative continuous, match each of the 3 variables to the most 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 and title your graphs to clearly identify what the graph is about.
6. Heart rate before and after exercise
7. M=0 F=1 Resting After Exercise
8. 0 85.9 87.5
9. 0 67.7 79.4
10. 0 80.3 93.4
11. 0 85.2 97.7
12. 0 86.3 99.7
13. 0 76.6 83.7
14. 0 94.4 101.9
15. 0 86.4 100.6
16. 0 83.4 97.4
17. 0 89.8 97.4
18. 0 88.7 97.1
19. 0 78.4 87.2
20. 0 71.3 79.9
21. 0 92.6 104.7
22. 0 86.2 95.9
23. 0 83.9 93.9
24. 0 78.1 90.1
25. 0 64.0 70.7
26. 0 72.8 86.7
27. 0 72.7 81.2
28. 0 80.2 83.3
29. 0 78.2 86.0
30. 0 70.6 90.2
31. 0 75.5 84.4
32. 0 82.7 94.2
33. 0 87.7 95.1
34. 0 80.0 88.7
35. 0 73.4 82.7
36. 0 89.5 94.6
37. 0 77.6 84.6
38. 0 76.6 86.4
39. 0 85.6 96.2
40. 0 74.2 82.1
41. 0 79.0 91.6
42. 0 74.6 86.7
43. 0 88.8 98.8
44. 0 82.1 85.6
45. 0 77.6 80.6
46. 0 77.9 83.8
47. 0 88.1 93.9
48. 0 81.6 90.3
49. 0 91.2 100.6
50. 0 80.3 88.0
51. 0 76.7 91.8
52. 0 88.4 103.0
53. 0 75.2 86.5
54. 0 75.2 84.9
55. 0 73.1 71.9
56. 0 77.0 84.7
57. 0 59.0 68.2
58. 0 84.9 96.0
59. 0 87.5 105.9
60. 0 75.6 84.3
61. 0 84.0 90.4
62. 0 78.2 94.0
63. 0 86.6 90.6
64. 0 84.9 95.1
65. 0 78.8 90.4
66. 0 69.4 82.6
67. 0 78.3 91.1
68. 0 76.9 92.3
69. 0 84.2 87.9
70. 0 76.3 85.9
71. 0 86.3 99.7
72. 0 72.3 80.9
73. 0 81.8 93.8
74. 0 92.8 99.8
75. 0 74.8 90.2
76. 0 91.7 99.2
77. 0 71.0 87.0
78. 0 96.1 100.2
79. 0 82.5 95.1
80. 0 81.9 97.5
81. 0 89.7 94.8
82. 0 81.4 100.9
83. 0 74.8 94.0
84. 0 88.1 102.1
85. 0 69.2 81.4
86. 0 78.8 90.9
87. 0 85.3 94.2
88. 0 74.8 81.3
89. 0 77.7 89.9
90. 0 78.0 89.8
91. 0 80.5 95.3
92. 0 75.4 84.8
93. 0 81.5 84.2
94. 0 73.9 85.2
95. 0 69.4 74.1
96. 0 89.4 96.7
97. 0 70.9 82.0
98. 0 82.9 90.2
99. 0 89.6 106.7
100. 0 74.5 75.6
101. 0 92.3 102.2
102. 0 87.7 98.0
103. 0 78.9 89.7
104. 0 79.8 81.5
105. 0 85.5 97.4
106. 0 87.3 94.1
107. 0 77.8 97.8
108. 0 71.0 80.1
109. 0 82.5 90.7
110. 0 74.8 83.7
111. 0 69.2 79.4
112. 0 80.5 87.4
113. 0 89.4 99.2
114. 0 74.5 88.0
115. 0 85.5 92.0
116. 1 76.6 88.2
117. 1 79.2 90.4
118. 1 80.6 101.3
119. 1 75.5 93.1
120. 1 83.9 90.5
121. 1 73.9 89.1
122. 1 76.8 90.8
123. 1 85.2 93.5
124. 1 82.1 93.5
125. 1 76.3 87.0
126. 1 97.0 104.5
127. 1 81.5 86.5
128. 1 65.3 86.3
129. 1 80.8 86.7
130. 1 78.5 89.9
131. 1 86.3 97.6
132. 1 89.8 92.9
133. 1 87.8 98.5
134. 1 76.2 89.9
135. 1 74.2 88.8
136. 1 67.4 78.8
137. 1 75.5 80.2
138. 1 80.0 90.2
139. 1 76.4 88.0
140. 1 94.9 95.7
141. 1 89.2 96.9
142. 1 83.3 87.7
143. 1 85.8 90.4
144. 1 75.3 84.1
145. 1 77.9 99.0
146. 1 70.0 83.0
147. 1 88.0 94.2
148. 1 86.9 95.0
149. 1 87.1 95.9
150. 1 79.3 82.7
151. 1 81.2 90.7
152. 1 82.9 91.9
153. 1 87.4 103.6
154. 1 83.0 90.0
155. 1 76.8 83.3
156. 1 76.9 87.7
157. 1 79.8 88.2
158. 1 83.2 93.0
159. 1 79.5 88.6
160. 1 82.4 89.3
161. 1 80.8 84.2
162. 1 83.2 94.5
163. 1 71.6 81.5
164. 1 82.8 93.1
165. 1 76.8 92.8
166. 1 93.2 100.4
167. 1 91.4 100.9
168. 1 97.3 103.3
169. 1 88.3 90.1
170. 1 80.6 85.2
171. 1 87.4 91.7
172. 1 96.5 99.3
173. 1 77.9 91.6
174. 1 76.1 84.1
175. 1 85.2 89.7
176. 1 68.6 72.8
177. 1 79.4 92.0
178. 1 85.2 99.2
179. 1 74.3 85.6
180. 1 74.3 89.2
181. 1 78.5 98.5
182. 1 80.4 90.8
183. 1 82.9 85.9
184. 1 78.9 90.7
185. 1 78.6 87.0
186. 1 87.5 93.9
187. 1 78.9 91.4
188. 1 80.0 89.1
189. 1 80.4 89.2
190. 1 88.3 93.5
191. 1 80.6 95.9
192. 1 85.8 90.5
193. 1 84.6 93.0
194. 1 80.5 91.8
195. 1 92.4 101.2
196. 1 84.4 96.7
197. 1 82.3 86.9
198. 1 77.2 85.8
199. 1 83.3 82.1
200. 1 86.2 98.9
201. 1 81.3 97.7
202. 1 90.2 96.4
203. 1 78.4 85.5
204. 1 84.7 101.6
205. 1 89.7 94.3
206. 1 78.4 88.0
207. 1 79.9 88.5

Answer 1

The bar graphs for Gender are:

Bar Graph for number of Males Gender: 0 Count Gender

Bar Graph for number of Females Gender: 1 Count Gender

Histogram for Males & Females before exercising is:

Histogram for Males before exercising Gender: 0 Mean = 80.39 Std. Dev. = 7.052 N = 108 Frequency 50.00 60.00 70.00 80.00 90.00 100.00 BeforeExercising

Histogram for Females before exercising Gender: 1 Mean = 81.77 Std. Dev. = 6.269 N = 92 Frequency 0.0 60.00 70.00 80.00 90.00 100.00 BeforeExercising

Histogram of Males & Females for Resting After Exercise is:

Histogram of Males for Resting After Exercise Gender: 0 Mean = 90.28 Std. Dev. = 7.82 N = 108 Frequency 60.00 70.00 80.00 90.00 100.00 110.00 Restingafterexercising

Histogram of Females for Resting After Exercise Gender: 1 Mean = 91.23 Std. Dev. = 5.914 N = 92 Frequency 70.00 80.00 90.00 100.00 110.00 Restingafterexercising

Please give me a thumbs-up if this helps you out. Thank you!