3rd and 4th discussed ways to record height and lung capacity when we were testing to discover whether taller people had greater lung capacity. We had decided on a scatter graph and realized that Excel could make a very good scatter graph for us. We worked in trios recording lung capacity, 1 person recording on Excel, one keeping the measuring bottle submerged, and the third manipulating the tube into the neck of the measuring bottle to allow the subject to blow in.
This the scattergraph from Excel and an extract from our measures (names omitted)
Scatter graph from Excel
| Height
in Cm |
Lung capacity in ml |
|
|
| 130 |
1600 |
| 135 |
1100 |
| 135 |
1450 |
| 135 |
2000 |
| 136 |
1750 |
| 136 |
1900 |
| 137 |
1700 |
| 137 |
1000 |
| 137 |
1700 |
| 138 |
1700 |
| 140 |
1500 |
| 142 |
1550 |
| 143 |
1700 |
| 143 |
1850 |
| 144 |
|
| 144 |
1800 |
| 145 |
1700 |
| 145 |
1850 |
| 146 |
2000 |
| 147 |
1800 |
| 149 |
1850 |
| 151 |
1900 |
| 153 |
2000 |
| 154 |
1650 | | | | |
No comments:
Post a Comment