AST Correlation

Bella10
STData_B_Pacheco.xlsx
Home>Nursing homework help>AST Correlation

Sheet1

AGE Smoker PULSE HDL LDL WEIGHT HEIGHT BMI Region SYSTOLIC BMI SMOKERS BMI NON SMOKERS
31 0 66 46 134 110.5 169.1 38.6 1 112 25.2 38.6
60 0 58 65 162 62.4 159.4 24.6 2 132 35 24.6
57 0 62 78 135 105.8 162.2 40.2 2 142 26.6 40.2
46 0 80 64 156 83.8 170.9 28.7 1 122 30.9 28.7
69 0 58 44 104 63.6 162.5 24.1 1 134 25.6 24.1
25 0 82 72 84 48.0 160.3 18.7 1 122 24.7 18.7
63 0 76 42 113 89.7 181.4 27.3 4 120 24.8 27.3
66 0 70 43 160 92.0 157.5 37.1 4 158 17.9 37.1
36 0 88 51 98 62.7 165.6 22.9 1 122 43.7 22.9
29 0 44 44 121 85.5 169.3 29.8 3 108 30.8 29.8
51 0 58 59 100 52.1 154.1 21.9 3 128 24.2 21.9
68 0 64 63 88 87.4 167.6 31.1 4 158 24 31.1
32 0 68 55 81 55.2 166.9 19.8 2 96 22 19.8
70 0 70 52 126 89.7 156.6 36.6 1 156 24.7 36.6
45 0 58 53 81 90.3 155.6 37.3 1 116 32.5 37.3
45 0 72 49 122 100.4 162.9 37.8 1 120 24.5 37.8
47 0 80 56 146 95.3 168.8 33.4 1 130 26.8 33.4
27 0 70 42 72 97.0 157.4 39.2 4 124 30.5 39.2
22 0 74 63 77 54.5 162.2 20.7 2 94 22.9 20.7
60 0 72 86 96 74.5 157.3 30.1 4 126 32.2 30.1
67 0 66 52 151 65.6 162.6 24.8 3 146 25.2 24.8
31 0 82 33 112 140.1 157.0 56.8 3 134 25.3 56.8
41 0 98 56 126 86.2 161.4 33.1 4 112 24.7 33.1
41 0 74 78 117 72.8 167.7 25.9 4 110 31.7 25.9
58 0 80 65 128 90.4 167.0 32.4 2 132 22.6 32.4
41 0 82 59 80 115.5 156.5 47.2 3 126 26.1 47.2
80 0 56 90 145 46.3 156.5 18.9 4 154 30.6 18.9
22 0 78 55 80 72.2 158.4 28.8 2 112 33.3 28.8
18 0 100 58 151 68.8 167.6 24.5 2 126 27.6 24.5
80 0 56 63 158 48.5 144.4 23.3 2 150 25.5 23.3
57 0 68 66 172 93.3 150.6 41.1 3 142 22.8 41.1
78 0 72 65 70 68.5 160.3 26.7 4 146 26.5 26.7
21 0 64 47 70 56.7 159.4 22.3 3 98 29.2 22.3
58 0 94 54 106 138.9 162.5 52.6 4 128 29.2 52.6
49 0 72 51 113 72.8 147.9 33.3 3 122 22 33.3
45 0 56 58 83 60.8 164.4 22.5 3 118 33.9 22.5
46 0 80 68 84 83.6 166.1 30.3 3 114 45.9 30.3
37 0 76 48 126 89.9 169.1 31.4 1 112 24.5 31.4
42 0 56 51 96 105.1 149.5 47.0 3 106 35 47.0
56 0 56 47 86 101.8 162.8 38.4 2 118 26.6 38.4
29 0 54 69 92 84.5 165.1 31.0 4 106 22.6 31.0
43 0 72 57 57 75.3 164.0 28.0 3 144 28.4 28.0
22 0 70 67 87 64.5 165.2 23.6 3 130 40 23.6
21 0 80 56 80 52.6 162.9 19.8 4 116 24.8 19.8
20 0 72 40 128 92.5 163.1 34.8 3 106 25.9 34.8
45 0 62 94 119 62.2 163.3 23.3 2 112 30.1 23.3
20 0 96 66 68 62.1 162.9 23.4 1 122 25.2 23.4
55 0 72 54 155 71.7 166.1 26.0 1 114 28 26.0
45 0 60 61 124 75.6 173.2 25.2 4 102 36.2 25.2
37 0 98 72 158 125.7 169.8 43.6 2 126 27.3 43.6
23 0 72 38 73 56.7 156.1 23.3 3 106 39.9 23.3
23 0 80 61 113 61.7 168.0 21.9 4 110 20.3 21.9
20 0 84 36 50 108.3 163.0 40.8 4 112 24.4 40.8
60 0 68 48 157 56.5 147.2 26.1 1 102 24.4 26.1
61 0 86 53 166 101.3 176.1 32.7 2 114 23.4 32.7
76 0 72 56 147 60.1 153.3 25.6 4 130 29.8 25.6
70 0 80 38 79 90.5 165.4 33.1 2 160 27.5 33.1
75 0 64 48 115 60.4 161.9 23.0 2 144 30.2 23.0
22 0 82 42 102 84.5 166.9 30.3 2 118 28.9 30.3
46 0 80 64 127 57.7 155.6 23.8 1 108 31.9 23.8
46 0 62 63 118 69.6 168.6 24.5 1 114 30.3 24.5
74 0 74 91 132 67.3 177.3 21.4 1 106 17 21.4
34 0 96 37 69 133.3 171.1 45.5 3 120 31.2 45.5
38 1 40 44 158 80.3 178.5 25.2 4 134 31.9
34 1 74 43 94 99.5 168.5 35.0 2 124 19.2
64 1 74 83 118 83.9 177.5 26.6 4 142 31.8
65 1 76 43 159 86.2 166.9 30.9 1 116 32.4
47 1 66 89 136 81.8 178.6 25.6 2 120 34.2
66 1 66 37 115 69.6 167.9 24.7 1 132 30.9
76 1 82 43 68 77.2 176.3 24.8 2 102 26.4
27 1 64 49 90 50.3 167.5 17.9 2 108 21.6
75 1 84 35 114 132.1 173.8 43.7 4 134 24.7
23 1 64 26 106 80.7 161.8 30.8 2 120 31
19 1 80 56 82 81.5 183.5 24.2 4 112 33.2
29 1 62 57 125 68.1 168.5 24.0 3 118 21.2
33 1 70 62 113 56.7 160.6 22.0 1 126 27.4
54 1 82 40 147 73.1 171.9 24.7 2 120 29.9
42 1 78 66 105 95.3 171.2 32.5 3 142 31.1
41 1 74 54 116 67.6 166.2 24.5 2 118
51 1 64 42 120 80.3 173.2 26.8 3 122
61 1 52 53 98 89.9 171.7 30.5 1 136
76 1 60 68 111 67.0 170.9 22.9 4 126
46 1 66 52 138 108.8 183.7 32.2 3 112
62 1 58 56 171 69.1 165.7 25.2 2 102
37 1 74 113 76 73.0 170.0 25.3 4 122
72 1 70 92 118 67.6 165.6 24.7 1 112
58 1 66 27 85 91.3 169.8 31.7 1 136
60 1 72 43 138 73.1 180.0 22.6 3 106
58 1 66 71 66 81.7 177.0 26.1 2 126
56 1 52 53 162 99.8 180.5 30.6 4 130
66 1 82 34 85 97.9 171.5 33.3 1 118
60 1 66 48 108 89.2 179.8 27.6 2 116
45 1 66 31 129 73.1 169.3 25.5 2 114
61 1 70 37 121 64.6 168.2 22.8 2 114
35 1 68 41 134 91.5 185.7 26.5 1 114
80 1 66 59 39 87.1 172.6 29.2 2 136
52 1 56 30 175 95.8 181.1 29.2 3 124
26 1 72 39 81 63.9 170.5 22.0 1 116
80 1 60 48 98 97.5 169.7 33.9 2 136
54 1 102 78 130 127.5 166.6 45.9 2 144
58 1 74 49 76 85.0 186.3 24.5 4 124
21 1 64 37 124 109.1 176.6 35.0 3 110
70 1 88 53 129 77.8 171.1 26.6 4 100
74 1 60 62 124 70.5 176.8 22.6 4 128
69 1 80 98 118 90.6 178.7 28.4 3 156
56 1 86 48 193 116.2 170.4 40.0 3 124
24 1 72 43 52 75.2 174.3 24.8 2 112
39 1 74 48 143 81.3 177.2 25.9 4 122
49 1 92 31 99 91.4 174.4 30.1 4 128
74 1 58 63 64 79.1 177.1 25.2 1 158
44 1 64 43 102 89.1 178.4 28.0 4 134
53 1 68 39 149 116.0 179.1 36.2 4 136
19 1 64 34 61 74.7 165.3 27.3 4 94
80 1 62 41 83 104.8 162.0 39.9 4 146
19 1 64 55 52 64.9 178.7 20.3 4 106
26 1 64 34 115 79.0 180.1 24.4 3 120
40 1 58 29 64 74.2 174.4 24.4 3 106
30 1 66 54 107 66.9 169.0 23.4 4 118
42 1 58 41 43 90.7 174.4 29.8 3 120
30 1 72 55 186 82.6 173.2 27.5 3 122
75 1 60 43 76 103.6 185.1 30.2 1 150
29 1 62 44 153 88.4 174.8 28.9 2 122
68 1 82 46 153 94.5 172.0 31.9 1 166
57 1 82 50 176 92.2 174.4 30.3 2 134
56 1 72 57 127 56.8 182.8 17.0 1 126
42 1 62 49 127 100.4 179.4 31.2 1 118
39 1 76 63 142 103.7 180.3 31.9 3 116
24 1 78 46 124 61.0 178.2 19.2 1 114
27 1 78 42 192 104.4 181.1 31.8 4 126
52 1 84 38 125 96.2 172.2 32.4 2 120
80 1 74 31 71 98.7 169.8 34.2 3 122
33 1 72 43 150 115.3 193.3 30.9 2 130
51 1 60 61 173 67.4 159.9 26.4 2 112
80 1 70 57 50 58.4 164.5 21.6 4 126
30 1 66 63 77 83.2 183.6 24.7 4 130
43 1 82 37 75 84.8 165.4 31.0 4 116
30 1 80 42 163 96.2 170.1 33.2 2 138
21 1 54 58 105 65.3 175.7 21.2 1 120
45 1 80 43 101 72.6 162.8 27.4 4 140
53 1 76 26 202 90.3 173.7 29.9 3 142
48 1 70 77 116 89.2 169.4 31.1 2 120

Sheet2

BMI SMOKERS BMI NON SMOKERS
25.2 38.6
35 24.6
26.6 40.2
30.9 28.7
25.6 24.1
24.7 18.7
24.8 27.3
17.9 37.1
43.7 22.9
30.8 29.8
24.2 21.9
24 31.1
22 19.8
24.7 36.6
32.5 37.3
24.5 37.8
26.8 33.4
30.5 39.2
22.9 20.7
32.2 30.1
25.2 24.8
25.3 56.8
24.7 33.1
31.7 25.9
22.6 32.4
26.1 47.2
30.6 18.9
33.3 28.8
27.6 24.5
25.5 23.3
22.8 41.1
26.5 26.7
29.2 22.3
29.2 52.6
22 33.3
33.9 22.5
45.9 30.3
24.5 31.4
35 47.0
26.6 38.4
22.6 31.0
28.4 28.0
40 23.6
24.8 19.8
25.9 34.8
30.1 23.3
25.2 23.4
28 26.0
36.2 25.2
27.3 43.6
39.9 23.3
20.3 21.9
24.4 40.8
24.4 26.1
23.4 32.7
29.8 25.6
27.5 33.1
30.2 23.0
28.9 30.3
31.9 23.8
30.3 24.5
17 21.4
31.2 45.5
31.9
19.2
31.8
32.4
34.2
30.9
26.4
21.6
24.7
31
33.2
21.2
27.4
29.9
31.1

BMI SMOKERS AND NON SMOKERS

BMI SMOKERS 25.2 35 26.6 30.9 25.6 24.7 24.8 17.899999999999999 43.7 30.8 24.2 24 22 24.7 32.5 24.5 26.8 30.5 22.9 32.200000000000003 25.2 25.3 24.7 31.7 22.6 26.1 30.6 33.299999999999997 27.6 25.5 22.8 26.5 29.2 29.2 22 33.9 45.9 24.5 35 26.6 22.6 28.4 40 24.8 25.9 30.1 25.2 28 36.200000000000003 27.3 39.9 20.3 24.4 24.4 23.4 29.8 27.5 30.2 28.9 31.9 30.3 17 31.2 31.9 19.2 31.8 32.4 34.200000000000003 30.9 26.4 21.6 24.7 31 33.200000000000003 21.2 27.4 29.9 31.1 BMI NON SMOKERS 38.6 24.6 40.200000000000003 28.7 24.1 18.7 27.3 37.1 22.9 29.8 21.9 31.1 19.8 36.6 37.299999999999997 37.799999999999997 33.4 39.200000000000003 20.7 30.1 24.8 56.8 33.1 25.9 32.4 47.2 18.899999999999999 28.8 24.5 23.3 41.1 26.7 22.3 52.6 33.299999999999997 22.5 30.3 31.4 47 38.4 31 28 23.6 19.8 34.799999999999997 23.3 23.4 26 25.2 43.6 23.3 21.9 40.799999999999997 26.1 32.700000000000003 25.6 33.1 23 30.3 23.8 24.5 21.4 45.5

Sheet3

BMI
38.6
24.6
40.2
28.7
24.1
18.7
27.3
37.1
22.9
29.8
21.9
31.1
19.8
36.6
37.3
37.8
33.4
39.2
20.7
30.1
24.8
56.8
33.1
25.9
32.4
47.2
18.9
28.8
24.5
23.3
41.1
26.7
22.3
52.6
33.3
22.5
30.3
31.4
47.0
38.4
31.0
28.0
23.6
19.8
34.8
23.3
23.4
26.0
25.2
43.6
23.3
21.9
40.8
26.1
32.7
25.6
33.1
23.0
30.3
23.8
24.5
21.4
45.5
25.2
35.0
26.6
30.9
25.6
24.7
24.8
17.9
43.7
30.8
24.2
24.0
22.0
24.7
32.5
24.5
26.8
30.5
22.9
32.2
25.2
25.3
24.7
31.7
22.6
26.1
30.6
33.3
27.6
25.5
22.8
26.5
29.2
29.2
22.0
33.9
45.9
24.5
35.0
26.6
22.6
28.4
40.0
24.8
25.9
30.1
25.2
28.0
36.2
27.3
39.9
20.3
24.4
24.4
23.4
29.8
27.5
30.2
28.9
31.9
30.3
17.0
31.2
31.9
19.2
31.8
32.4
34.2
30.9
26.4
21.6
24.7
31.0
33.2
21.2
27.4
29.9
31.1

Sheet4

BMI SMOKERS
25.2
35
26.6
30.9
25.6
24.7
24.8
17.9
43.7
30.8
24.2
24
22
24.7
32.5
24.5
26.8
30.5
22.9
32.2
25.2
25.3
24.7
31.7
22.6
26.1
30.6
33.3
27.6
25.5
22.8
26.5
29.2
29.2
22
33.9
45.9
24.5
35
26.6
22.6
28.4
40
24.8
25.9
30.1
25.2
28
36.2
27.3
39.9
20.3
24.4
24.4
23.4
29.8
27.5
30.2
28.9
31.9
30.3
17
31.2
31.9
19.2
31.8
32.4
34.2
30.9
26.4
21.6
24.7
31
33.2
21.2
27.4
29.9
31.1

Sheet5

BMI NON SMOKERS
38.6
24.6
40.2
28.7
24.1
18.7
27.3
37.1
22.9
29.8
21.9
31.1
19.8
36.6
37.3
37.8
33.4
39.2
20.7
30.1
24.8
56.8
33.1
25.9
32.4
47.2
18.9
28.8
24.5
23.3
41.1
26.7
22.3
52.6
33.3
22.5
30.3
31.4
47.0
38.4
31.0
28.0
23.6
19.8
34.8
23.3
23.4
26.0
25.2
43.6
23.3
21.9
40.8
26.1
32.7
25.6
33.1
23.0
30.3
23.8
24.5
21.4
45.5

Sheet6

BMI SMOKERS BMI NON SMOKERS BMI SMOKERS BMI NON SMOKERS
25.2 38.6
35 24.6 Mean 28.1064102564 Mean 30.3476190476
26.6 40.2 Standard Error 0.6068000161 Standard Error 1.0834623748
30.9 28.7 Median 27.35 Median 28.7
25.6 24.1 Mode 24.7 Mode 23.3
24.7 18.7 Standard Deviation 5.359112636 Standard Deviation 8.5997159957
24.8 27.3 Sample Variance 28.7200882451 Sample Variance 73.9551152074
17.9 37.1 Kurtosis 1.3557825179 Kurtosis 0.6082126939
43.7 22.9 Skewness 0.7926206323 Skewness 0.9884778427
30.8 29.8 Range 28.9 Range 38.1
24.2 21.9 Minimum 17 Minimum 18.7
24 31.1 Maximum 45.9 Maximum 56.8
22 19.8 Sum 2192.3 Sum 1911.9
24.7 36.6 Count 78 Count 63
32.5 37.3 Largest(1) 45.9 Largest(1) 56.8
24.5 37.8 Smallest(1) 17 Smallest(1) 18.7
26.8 33.4 Confidence Level(95.0%) 1.2082931992 Confidence Level(95.0%) 2.165810427
30.5 39.2
22.9 20.7
32.2 30.1
25.2 24.8
25.3 56.8
24.7 33.1
31.7 25.9
22.6 32.4
26.1 47.2
30.6 18.9
33.3 28.8
27.6 24.5
25.5 23.3
22.8 41.1
26.5 26.7
29.2 22.3
29.2 52.6
22 33.3
33.9 22.5
45.9 30.3
24.5 31.4
35 47.0
26.6 38.4
22.6 31.0
28.4 28.0
40 23.6
24.8 19.8
25.9 34.8
30.1 23.3
25.2 23.4
28 26.0
36.2 25.2
27.3 43.6
39.9 23.3
20.3 21.9
24.4 40.8
24.4 26.1
23.4 32.7
29.8 25.6
27.5 33.1
30.2 23.0
28.9 30.3
31.9 23.8
30.3 24.5
17 21.4
31.2 45.5
31.9
19.2
31.8
32.4
34.2
30.9
26.4
21.6
24.7
31
33.2
21.2
27.4
29.9
31.1