Question

In this assignment, you will be required to use the Heart Rate Dataset to complete the following: Identify the types of data represented by variables The range or types of values for each variable Give a brief written description of the variables, and how they are used in the data set. Steps Open the Heart Rate Dataset in Excel Identify each of the variables contained in the dataset by type Identify the type of data each variable represents (e.g., qualitative or quantitative) and the possible values for each Briefly describe how the variable is used in the dataset, (e.g., to identify a class, or to give a specific numeric value for an individual).
	Heart rate before and after exercise
	M=0 F=1	Resting	After Exercise
	0	85.9	87.5
	0	67.7	79.4
	0	80.3	93.4
	0	85.2	97.7
	0	86.3	99.7
	0	76.6	83.7
	0	94.4	101.9
	0	86.4	100.6
	0	83.4	97.4
	0	89.8	97.4
	0	88.7	97.1
	0	78.4	87.2
	0	71.3	79.9
	0	92.6	104.7
	0	86.2	95.9
	0	83.9	93.9
	0	78.1	90.1
	0	64.0	70.7
	0	72.8	86.7
	0	72.7	81.2
	0	80.2	83.3
	0	78.2	86.0
	0	70.6	90.2
	0	75.5	84.4
	0	82.7	94.2
	0	87.7	95.1
	0	80.0	88.7
	0	73.4	82.7
	0	89.5	94.6
	0	77.6	84.6
	0	76.6	86.4
	0	85.6	96.2
	0	74.2	82.1
	0	79.0	91.6
	0	74.6	86.7
	0	88.8	98.8
	0	82.1	85.6
	0	77.6	80.6
	0	77.9	83.8
	0	88.1	93.9
	0	81.6	90.3
	0	91.2	100.6
	0	80.3	88.0
	0	76.7	91.8
	0	88.4	103.0
	0	75.2	86.5
	0	75.2	84.9
	0	73.1	71.9
	0	77.0	84.7
	0	59.0	68.2
	0	84.9	96.0
	0	87.5	105.9
	0	75.6	84.3
	0	84.0	90.4
	0	78.2	94.0
	0	86.6	90.6
	0	84.9	95.1
	0	78.8	90.4
	0	69.4	82.6
	0	78.3	91.1
	0	76.9	92.3
	0	84.2	87.9
	0	76.3	85.9
	0	86.3	99.7
	0	72.3	80.9
	0	81.8	93.8
	0	92.8	99.8
	0	74.8	90.2
	0	91.7	99.2
	0	71.0	87.0
	0	96.1	100.2
	0	82.5	95.1
	0	81.9	97.5
	0	89.7	94.8
	0	81.4	100.9
	0	74.8	94.0
	0	88.1	102.1
	0	69.2	81.4
	0	78.8	90.9
	0	85.3	94.2
	0	74.8	81.3
	0	77.7	89.9
	0	78.0	89.8
	0	80.5	95.3
	0	75.4	84.8
	0	81.5	84.2
	0	73.9	85.2
	0	69.4	74.1
	0	89.4	96.7
	0	70.9	82.0
	0	82.9	90.2
	0	89.6	106.7
	0	74.5	75.6
	0	92.3	102.2
	0	87.7	98.0
	0	78.9	89.7
	0	79.8	81.5
	0	85.5	97.4
	0	87.3	94.1
	0	77.8	97.8
	0	71.0	80.1
	0	82.5	90.7
	0	74.8	83.7
	0	69.2	79.4
	0	80.5	87.4
	0	89.4	99.2
	0	74.5	88.0
	0	85.5	92.0
	1	76.6	88.2
	1	79.2	90.4
	1	80.6	101.3
	1	75.5	93.1
	1	83.9	90.5
	1	73.9	89.1
	1	76.8	90.8
	1	85.2	93.5
	1	82.1	93.5
	1	76.3	87.0
	1	97.0	104.5
	1	81.5	86.5
	1	65.3	86.3
	1	80.8	86.7
	1	78.5	89.9
	1	86.3	97.6
	1	89.8	92.9
	1	87.8	98.5
	1	76.2	89.9
	1	74.2	88.8
	1	67.4	78.8
	1	75.5	80.2
	1	80.0	90.2
	1	76.4	88.0
	1	94.9	95.7
	1	89.2	96.9
	1	83.3	87.7
	1	85.8	90.4
	1	75.3	84.1
	1	77.9	99.0
	1	70.0	83.0
	1	88.0	94.2
	1	86.9	95.0
	1	87.1	95.9
	1	79.3	82.7
	1	81.2	90.7
	1	82.9	91.9
	1	87.4	103.6
	1	83.0	90.0
	1	76.8	83.3
	1	76.9	87.7
	1	79.8	88.2
	1	83.2	93.0
	1	79.5	88.6
	1	82.4	89.3
	1	80.8	84.2
	1	83.2	94.5
	1	71.6	81.5
	1	82.8	93.1
	1	76.8	92.8
	1	93.2	100.4
	1	91.4	100.9
	1	97.3	103.3
	1	88.3	90.1
	1	80.6	85.2
	1	87.4	91.7
	1	96.5	99.3
	1	77.9	91.6
	1	76.1	84.1
	1	85.2	89.7
	1	68.6	72.8
	1	79.4	92.0
	1	85.2	99.2
	1	74.3	85.6
	1	74.3	89.2
	1	78.5	98.5
	1	80.4	90.8
	1	82.9	85.9
	1	78.9	90.7
	1	78.6	87.0
	1	87.5	93.9
	1	78.9	91.4
	1	80.0	89.1
	1	80.4	89.2
	1	88.3	93.5
	1	80.6	95.9
	1	85.8	90.5
	1	84.6	93.0
	1	80.5	91.8
	1	92.4	101.2
	1	84.4	96.7
	1	82.3	86.9
	1	77.2	85.8
	1	83.3	82.1
	1	86.2	98.9
	1	81.3	97.7
	1	90.2	96.4
	1	78.4	85.5
	1	84.7	101.6
	1	89.7	94.3
	1	78.4	88.0
	1	79.9	88.5

Answer 1

Data can be classified into 2 different types
Qualitative values that can be sorted into groups of categories		Quantitative values that can be measured. And these numbers can be placed in ascending or descending order.
You can count but not order or measure nominal data.	Ordinal valuesor observations can be ranked.	Discrete data can take on only integer values	continuous data can take on any value.

Now,

Column name	Data type	Reason	Range of data
M=0 F=1	Qualitative, nominal data	Regardless of the numbers assigned to the male and female categories, it is still a qualitative data and not quantitative.	0,1
Resting	Quantitative,continuous data	The values are countable, but it can take any value within a specific range.	59-100. We can make intervals of class size 5.
After exercise	Quantitative, continuous data	It can also take any value within a spacific range	68-107. We can again make intervals of class size 5.