Assignment: Build a Dataset in Excel

Instructions

Using the 20 data collection sheets posted, create a data set in Excel. Each variable should be represented in 1 column. Each participant should be represented in a single row. If there are any categorical variables (i.e., nominal or ordinal levels of measurement), make sure that you develop a method of coding those variables. For example, if you had the variable of gender, you could assign all males a value of 1 and all females a value of 2.

"Blood pressure (S)" is systolic pressure and "Blood pressure (D)" is diastolic pressure.

Data Collection Sheets

Data sheet: #01

Age:	18	Temperature:	98.6
Height:	66	Heart rate:	65
Weight:	120	Respiration:	16
BMI:	19.4	Smoking:	No
Blood pressure (S):	120	Diabetes:	No
Blood pressure (D):	80

Data Sheet: #02

Age:	20	Temperature:	98.9
Height:	68	Heart rate:	70
Weight:	160	Respiration:	15
BMI:	24.3	Smoking:	Yes
Blood pressure (S):	110	Diabetes:	Type 1
Blood pressure (D):	80

Data sheet: #03

Age:	25	Temperature:	97.2
Height:	64	Heart rate:	85
Weight:	145	Respiration:	19
BMI:	24.9	Smoking:	No
Blood pressure (S):	105	Diabetes:	Type 2
Blood pressure (D):	65

Data sheet: #04

Age:	33	Temperature:	97.6
Height:	72	Heart rate:	110
Weight:	220	Respiration:	22
BMI:	29.8	Smoking:	No
Blood pressure (S):	103	Diabetes:	No
Blood pressure (D):	70

Data sheet: #05

Age:	48	Temperature:	99.6
Height:	67	Heart rate:	105
Weight:	250	Respiration:	26
BMI:	39.2	Smoking:	Yes
Blood pressure (S):	135	Diabetes:	Type 2
Blood pressure (D):	90

Data sheet: #06

Age:	27	Temperature:	98.1
Height:	74	Heart rate:	107
Weight:	230	Respiration:	24
BMI:	29.5	Smoking:	Yes
Blood pressure (S):	125	Diabetes:	Type 1
Blood pressure (D):	83

Data sheet: #07

Age:	31	Temperature:	96.9
Height:	75	Heart rate:	59
Weight:	190	Respiration:	14
BMI:	16.9	Smoking:	Yes
Blood pressure (S):	70	Diabetes:	Type 1
Blood pressure (D):	40

Data sheet: #08

Age:	58	Temperature:	97.5
Height:	61	Heart rate:	57
Weight:	110	Respiration:	13
BMI:	14.5	Smoking:	No
Blood pressure (S):	63	Diabetes:	Type 2
Blood pressure (D):	45

Data sheet: #09

Age:	64	Temperature:	98.6
Height:	60	Heart rate:	97
Weight:	150	Respiration:	18
BMI:	29.3	Smoking:	No
Blood pressure (S):	101	Diabetes:	No
Blood pressure (D):	84

Data sheet: #10

Age:	26	Temperature:	98.3
Height:	61	Heart rate:	64
Weight:	125	Respiration:	20
BMI:	23.6	Smoking:	Yes
Blood pressure (S):	96	Diabetes:	Type 1
Blood pressure (D):	74

Data sheet: #11

Age:	38	Temperature:	99.2
Height:	68	Heart rate:	81
Weight:	148	Respiration:	17
BMI:	22.5	Smoking:	No
Blood pressure (S):	61	Diabetes:	No
Blood pressure (D):	30

Data sheet: #12

Age:	46	Temperature:	99.3
Height:	63	Heart rate:	90
Weight:	139	Respiration:	16
BMI:	24.6	Smoking:	Yes
Blood pressure (S):	75	Diabetes:	Type 1
Blood pressure (D):	68

Data sheet: #13

Age:	51	Temperature:	98.6
Height:	66	Heart rate:	73
Weight:	142	Respiration:	15
BMI:	22.9	Smoking:	Yes
Blood pressure (S):	102	Diabetes:	Type 1
Blood pressure (D):	81

Data sheet: #14

Age:	42	Temperature:	98.0
Height:	65	Heart rate:	101
Weight:	175	Respiration:	23
BMI:	29.1	Smoking:	No
Blood pressure (S):	138	Diabetes:	Type 2
Blood pressure (D):	95

Data sheet: #15

Age:	30	Temperature:	96.3
Height:	69	Heart rate:	92
Weight:	189	Respiration:	21
BMI:	27.9	Smoking:	No
Blood pressure (S):	110	Diabetes:	Type 2
Blood pressure (D):	90

Data sheet: #16

Age:	22	Temperature:	98.1
Height:	70	Heart rate:	98
Weight:	215	Respiration:	22
BMI:	30.8	Smoking:	No
Blood pressure (S):	108	Diabetes:	Type 1
Blood pressure (D):	89

Data sheet: #17

Age:	27	Temperature:	98.9
Height:	64	Heart rate:	64
Weight:	115	Respiration:	14
BMI:	19.7	Smoking:	No
Blood pressure (S):	59	Diabetes:	No
Blood pressure (D):	36

Data sheet: #18

Age:	23	Temperature:	100.3
Height:	65	Heart rate:	73
Weight:	146	Respiration:	16
BMI:	24.3	Smoking:	Yes
Blood pressure (S):	70	Diabetes:	No
Blood pressure (D):	56

Data sheet: #19

Age:	35	Temperature:	95.9
Height:	66	Heart rate:	96
Weight:	157	Respiration:	20
BMI:	25.3	Smoking:	No
Blood pressure (S):	106	Diabetes:	Type 1
Blood pressure (D):	82

Data sheet: #20

Age:	53	Temperature:	98.9
Height:	59	Heart rate:	78
Weight:	120	Respiration:	15
BMI:	24.2	Smoking:	No
Blood pressure (S):	83	Diabetes:	Type 1
Blood pressure (D):	51