INSTRUCTION: Provide Descriptive Statistics using the Data Analysis in Excel for the “Systolic Blood Pressure” set of data. Copy the result of the Descriptive Statistics in a short bond paper. Based on the dataset, what measure of central tendency (Mean, Median or Mode) should be used and explained? Interpret also the values in relation to Skewness and Kurtosis.

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter9: Sequences, Probability And Counting Theory
Section9.7: Probability
Problem 5SE: The union of two sets is defined as a set of elements that are present in at least one of the sets....
icon
Related questions
Question

INSTRUCTION: Provide Descriptive Statistics using the Data Analysis in Excel for the “Systolic Blood Pressure” set of data. Copy the result of the Descriptive Statistics in a short bond paper. Based on the dataset, what measure of central tendency (Mean, Median or Mode) should be used and explained? Interpret also the values in relation to Skewness and Kurtosis.

NOTE: Place your answers in Microsoft Word Document (size: 8.5” x 11”).

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17<
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
A
Patient
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
B
Age
55
78
50
60
31
70
46
59
68
65
66
74
47
63
63
79
73
65
65
76
79
76
45
58
34
77
70
50
38
58
61
75
45
61
50
C
Sex
Male
Male
Male
Male
Male
Male
Male
Male
Female
Male
Female
Male
Female
Male
Female
Male
Male
Male
Male
Male
Male
Male
Female
Female
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Female
D
Body Mass
Index
19.435
22.503
27.406
29.867
27.025
19.040
28.662
27.406
27.532
28.058
28.762
29.024
30.506
28.399
28.731
18.957
26.545
23.739
29.340
39.837
26.156
30.586
43.269
28.192
20.426
26.545
19.044
25.712
30.853
27.369
32.079
37.590
22.850
27.718
24.176
E
Serum
Creatinine
1.600
2.682
1.300
1.091
1.159
1.250
1.307
1.705
1.534
2.000
0.900
1.227
1.386
1.100
0.900
2.239
1.300
1.614
1.200
1.455
1.489
1.700
0.900
1.352
1.886
1.307
1.200
1.034
0.900
0.909
1.273
1.300
1.398
1.659
1.000
F
Systolic Blood
Pressure
150
104
140
140
120
150
140
152
144
120
150
116
120
105
122
150
144
170
170
140
116
130
115
130
116
140
110
140
134
100
128
138
130
128
130
H
CODING: Age Groups
Under 40
Sex
40-49
50-59
60-69
70-79
Under 601
60 & above2
Codes
Male
Female
Codes (A)
1
Age GroupsCodes (B)
2
3
Underweight (<18.5)1
Normal (18.5-24.9)2
Overweight (25.0-29.9)3
Obese (230.0)4
4
5
1
2
Use the table below in coding for BMI:
BMICodes
K
Transcribed Image Text:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17< 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 A Patient 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 B Age 55 78 50 60 31 70 46 59 68 65 66 74 47 63 63 79 73 65 65 76 79 76 45 58 34 77 70 50 38 58 61 75 45 61 50 C Sex Male Male Male Male Male Male Male Male Female Male Female Male Female Male Female Male Male Male Male Male Male Male Female Female Male Male Male Male Male Female Male Male Male Male Female D Body Mass Index 19.435 22.503 27.406 29.867 27.025 19.040 28.662 27.406 27.532 28.058 28.762 29.024 30.506 28.399 28.731 18.957 26.545 23.739 29.340 39.837 26.156 30.586 43.269 28.192 20.426 26.545 19.044 25.712 30.853 27.369 32.079 37.590 22.850 27.718 24.176 E Serum Creatinine 1.600 2.682 1.300 1.091 1.159 1.250 1.307 1.705 1.534 2.000 0.900 1.227 1.386 1.100 0.900 2.239 1.300 1.614 1.200 1.455 1.489 1.700 0.900 1.352 1.886 1.307 1.200 1.034 0.900 0.909 1.273 1.300 1.398 1.659 1.000 F Systolic Blood Pressure 150 104 140 140 120 150 140 152 144 120 150 116 120 105 122 150 144 170 170 140 116 130 115 130 116 140 110 140 134 100 128 138 130 128 130 H CODING: Age Groups Under 40 Sex 40-49 50-59 60-69 70-79 Under 601 60 & above2 Codes Male Female Codes (A) 1 Age GroupsCodes (B) 2 3 Underweight (<18.5)1 Normal (18.5-24.9)2 Overweight (25.0-29.9)3 Obese (230.0)4 4 5 1 2 Use the table below in coding for BMI: BMICodes K
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
A
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
B
31
70
46
59
68
65
66
74
47
63
63
79
73
65
65
76
79
76
45
58
34
77
70
50
38
58
61
75
45
61
50
44
55
49
71
64
Male
Male
Male
Male
Female
Male
Female
Male
Female
Male
Female
Male
Male
Male
Male
Male
Male
Male
Female
Female
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Female
Female
Female
Male
Male
Male
D
27.025
19.040
28.662
27.406
27.532
28.058
28.762
29.024
30.506
28.399
28.731
18.957
26.545
23.739
29.340
39.837
26.156
30.586
43.269
28.192
20.426
26.545
19.044
25.712
30.853
27.369
32.079
37.590
22.850
27.718
24.176
26.370
21.790
15.204
22.229
21.228
E
1.159
1.250
1.307
1.705
1.534
2.000
0.900
1.227
1.386
1.100
0.900
2.239
1.300
1.614
1.200
1.455
1.489
1.700
0.900
1.352
1.886
1.307
1.200
1.034
0.900
0.909
1.273
1.300
1.398
1.659
1.000
1.148
1.170
1.307
1.261
0.900
F
120
150
140
152
144
120
150
116
120
105
122
150
144
170
170
140
116
130
115
130
116
140
110
140
134
100
128
138
130
128
130
124
130
140
100
130
G
H
Sex
60-69
70-79
Under 601
60 & above2
Codes
Male
Female
4
5
Age GroupsCodes (B)
Underweight (<18.5)1
Normal (18.5-24.9)2
Overweight (25.0-29.9)3
Obese (230.0)4
J
1
2
Use the table below in coding for BMI:
BMICodes
K
Transcribed Image Text:6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 B 31 70 46 59 68 65 66 74 47 63 63 79 73 65 65 76 79 76 45 58 34 77 70 50 38 58 61 75 45 61 50 44 55 49 71 64 Male Male Male Male Female Male Female Male Female Male Female Male Male Male Male Male Male Male Female Female Male Male Male Male Male Female Male Male Male Male Female Female Female Male Male Male D 27.025 19.040 28.662 27.406 27.532 28.058 28.762 29.024 30.506 28.399 28.731 18.957 26.545 23.739 29.340 39.837 26.156 30.586 43.269 28.192 20.426 26.545 19.044 25.712 30.853 27.369 32.079 37.590 22.850 27.718 24.176 26.370 21.790 15.204 22.229 21.228 E 1.159 1.250 1.307 1.705 1.534 2.000 0.900 1.227 1.386 1.100 0.900 2.239 1.300 1.614 1.200 1.455 1.489 1.700 0.900 1.352 1.886 1.307 1.200 1.034 0.900 0.909 1.273 1.300 1.398 1.659 1.000 1.148 1.170 1.307 1.261 0.900 F 120 150 140 152 144 120 150 116 120 105 122 150 144 170 170 140 116 130 115 130 116 140 110 140 134 100 128 138 130 128 130 124 130 140 100 130 G H Sex 60-69 70-79 Under 601 60 & above2 Codes Male Female 4 5 Age GroupsCodes (B) Underweight (<18.5)1 Normal (18.5-24.9)2 Overweight (25.0-29.9)3 Obese (230.0)4 J 1 2 Use the table below in coding for BMI: BMICodes K
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax