Biology Research. Expert ONLY

profileBling112
VCdataSpring2019ALL1.xlsx
Home>Biology homework help>Biology Research. Expert ONLY

Sheet1

Vital Capacity
No. Sex Smoker Age Athlete Height C.C. Pulse Rate (BPM) Standing Sitting Ave. notes
1 F N 18 N 158 92 93.2 3.5 3.47 3.485
2 F N 20 N 180 86 93.3 2.9 3.2 3.05
3 F N 20 N 155 73 58.7 2.1 2.1 2.1
4 F N 19 Y 174 78 65.33 3.56 3.3 3.43
5 F N 19 N 172 86 57.32 3.36 3.4 3.38
6 M N 20 N 179 92.7 57 4.23 4.24 4.235
7 F N 20 N 171 79 56 2.3 2.56 2.43
8 F N 19 N 163 82.6 48 2.63 2.63 2.63
9 F N 18 Y 172 85.1 74.6 3.1 2.9 3
10 F N 26 N 153.5 80 96 2.6 2.5 2.55 ASTHMA
11 F N 18 N 155 79 47 2.9 2.5 2.7 COLD
12 M Y 20 N 188 92.7 86.6 4 4.13 4.065
13 M N 18 N 180 88.9 109.3 3.3 3.8 3.55
14 M N 19 Y 180 116.8 76 3.73 3.8 3.765
15 F N 20 N 169 91 60 2.27 2.23 2.25
16 F N 20 N 170 90 97.3 3.53 3.46 3.495
17 F N 20 N 169 85.5 102.67 2.93 2.9 2.915 ASTHMA
18 F N 19 Y 165.5 80.5 66.67 3.6 3.47 3.535
19 F N 19 Y 172 78.5 65.33 3.56 3.4 3.48
20 F N 23 N 166 100 85.3 2.9 2.8 2.85
21 M N 38 N 183 104 79 4.8 4.8 4.8
22 F N 21 Y 165 81 58 3.06 3 3.03
23 F N 20 N 167 84 81 3.4 3.06 3.23
24 M N 19 N 194 91.5 100 4.9 4.9 4.9
25 m n 19 n 172 68 70.66 3.5 3.5 3.5
26 F N 20 N 172 80 81.3 3.2 3.67 3.435
27 M N 24 Y 189 99 69 5.3 5.3 5.3
28 m n 19 y 170 87.6 76 4.6 4.8 4.7 asthma
29 M Y 27 N 169 89 64 4 4 4
30 M N 21 N 181 89 78 4.5 3.4 3.95
31 M N 21 Y 170 89 64 4.1 3.93 4.015
32 F N 18 N 174 88 92 2.97 3.15 3.06
33 F N 19 N 171 78 84 3 3.03 3.015
34 F N 18 Y 169 74 65 3.1 3 3.05
35 M N 19 Y 178 89 70 4.3 4 4.15
36 F N 19 N 161 95 80 2 1.9 1.95
37 f N 18 N 161 75.3 78.68 2.4 2.37 2.385
38 F N 20 N 170 67 86.67 2.8 2.73 2.765
39 F N 22 N 162 109 69 2.4 2.5 2.45 asthma; bronchitis
40 F N 18 Y 164 78 98.6 3.26 3.1 3.18
41 F y 19 N 164 75 77.3 2.8 2.8 2.8
42 f n 19 y 170 92 89.33 3.35 3.1 3.225 asthma
43 f n 18 y 159 75 84 2.8 3 2.9
44 f y 19 n 180 93 73 3.8 3.9 3.85 heart & lung meds
45 F N 21 N 167 91.5 78.6 3.1 3 3.05
46 F N 19 N 178 89 88 3.2 3.3 3.25
47 f n 18 N 157 102 108 2.4 2.3 2.35 asthma
48 M N 20 N 185 94 76 3.6 3.63 3.615
49 F N 20 N 165 73 70 3.16 3.16 3.16
50 F N 22 N 169 91 60 3.3 3.27 3.285
51 F N 18 Y 173.5 88 84 3.43 3.13 3.28
52 f N 24 N 165 102 76 1.9 2.3 2.1
53 m n 22 n 179 90 72 3.4 3.75 3.575
54 F N 20 N 169 79 88 3.1 3 3.05
55 f N 20 N 161 80 64 2.3 2.3 2.3
56 F N 18 n 170 69.5 60 2.7 2.76 2.73
57 F N 20 N 170 71 68 2.2 2 2.1
58 F N 18 Y 169 89 73 2.8 2.8 2.8
59 M N 20 N 168 97 91 4.6 4.7 4.65
60 F N 18 N 170 86 71 2.7 2.6 2.65
61 F N 18 N 160 72 69.3 2.31 2.36 2.335
62 M N 19 N 175 96 80 4.8 4.83 4.815
63 f n 19 n 176 105.5 61 3.53 3.56 3.545
64 F N 19 N 167 130 92 3 3 3
65 F N 19 N 154 91 101 1.96 1.86 1.91
66 F N 19 N 165 75 54 2.83 2.7 2.765
67 F N 20 N 168 73 74 2.6 2.7 2.65
68 ERROR:#DIV/0!
97 ERROR:#DIV/0!
98 ERROR:#DIV/0!
99 ERROR:#DIV/0!
100 ERROR:#DIV/0!
Class average VC: 3.2164179104
Female average VC: you will calculate the value
Male average VC: you will calculate the value
Correlation coefficient for vital capacity vs. height: 0.7088293695
Correlation coefficient for vital capacity vs. chest circumference: 0.2992734608
Correlation coefficient for vital capacity vs. resting pulse rate: 0.0750973797
158 180 155 174 172 179 171 163 172 153.5 155 188 180 180 169 170 169 165.5 172 166 183 165 167 194 172 172 189 170 169 181 170 174 171 169 178 161 161 170 162 164 164 170 159 180 167 178 157 185 165 169 173.5 165 179 169 161 170 170 169 168 170 160 175 176 167 154 165 168 3.4850000000000003 3.05 2.1 3.4299999999999997 3.38 4.2350000000000003 2.4299999999999997 2.63 3 2.5499999999999998 2.7 4.0649999999999995 3.55 3.7649999999999997 2.25 3.4950000000000001 2.915 3.5350000000000001 3.48 2.8499999999999996 4.8 3.0300000000000002 3.23 4.9000000000000004 3.5 3.4350000000000001 5.3 4.6999999999999993 4 3.95 4.0149999999999997 3.06 3.0149999999999997 3.05 4.1500000000000004 1.95 2.3849999999999998 2.7649999999999997 2.4500000000000002 3.1799999999999997 2.8 3.2250000000000001 2.9 3.8499999999999996 3.05 3.25 2.3499999999999996 3.6150000000000002 3.16 3.2850000000000001 3.2800000000000002 2.0999999999999996 3.5750000000000002 3.05 2.2999999999999998 2.73 2.1 2.8 4.6500000000000004 2.6500000000000004 2.335 4.8149999999999995 3.5449999999999999 3 1.9100000000000001 2.7650000000000001 2.6500000000000004 0

Height (cm)

Vital Capacity (L)

92 86 73 78 86 92.7 79 82.6 85.1 80 79 92.7 88.9 116.8 91 90 85.5 80.5 78.5 100 104 81 84 91.5 68 80 99 87.6 89 89 89 88 78 74 89 95 75.3 67 109 78 75 92 75 93 91.5 89 102 94 73 91 88 102 90 79 80 69.5 71 89 97 86 72 96 105.5 130 91 75 73 3.4850000000000003 3.05 2.1 3.4299999999999997 3.38 4.2350000000000003 2.4299999999999997 2.63 3 2.5499999999999998 2.7 4.0649999999999995 3.55 3.76499999 99999997 2.25 3.4950000000000001 2.915 3.5350000000000001 3.48 2.8499999999999996 4.8 3.0300000000000002 3.23 4.9000000000000004 3.5 3.4350000000000001 5.3 4.6999999999999993 4 3.95 4.0149999999999997 3.06 3.0149999999999997 3.05 4.1500000000000004 1.95 2.3849999999999998 2.7649999999999997 2.4500000000000002 3.1799999999999997 2.8 3.2250000000000001 2.9 3.8499999999999996 3.05 3.25 2.3499999999999996 3.6150000000000002 3.16 3.2850000000000001 3.2800000000000002 2.0999999999999996 3.5750000000000002 3.05 2.2999999999999998 2.73 2.1 2.8 4.6500000000000004 2.6500000000000 004 2.335 4.8149999999999995 3.5449999999999999 3 1.9100000000000001 2.7650000000000001 2.6500000000000004 0

Chest circumference (cm)

Vital Capacity (L)

93.2 93.3 58.7 65.33 57.32 57 56 48 74.599999999999994 96 47 86.6 109.3 76 60 97.3 102.67 66.67 65.33 85.3 79 58 81 100 70.66 81.3 69 76 64 78 64 92 84 65 70 80 78.680000000000007 86.67 69 98.6 77.3 89.33 84 73 78.599999999999994 88 108 76 70 60 84 76 72 88 64 60 68 73 91 71 69.3 80 61 92 101 54 74 3.4850000000000003 3.05 2.1 3.4299999999999997 3.38 4.2350000000000003 2.4299999999999997 2.63 3 2.5499999999999998 2.7 4.0649999999999995 3.55 3.7649999999999997 2.25 3.4950000000000001 2.915 3.5350000000000001 3.48 2.8499999999999996 4.8 3.0300000000000002 3.23 4.9000000000000004 3.5 3.4350000000000001 5.3 4.6999999999999993 4 3.95 4.0149999999999997 3.06 3.0149999999999997 3.05 4.1500000000000004 1.95 2.3849999999999998 2.7649999999999997 2.4500000000000002 3.1799999999999997 2.8 3.2250000000000001 2.9 3.8499999999999996 3.05 3.25 2.3499999999999996 3.6150000000000002 3.16 3.2850000000000001 3.2800000000000002 2.0999999999999996 3.5750000000000002 3.05 2.2999999999999998 2.73 2.1 2.8 4.650 0000000000004 2.6500000000000004 2.335 4.8149999999999995 3.5449999999999999 3 1.9100000000000001 2.7650000000000001 2.6500000000000004 0

Resting pulse rate (beats/min)

Vital Capacity (L)

Sheet2

Sheet3