Monday, 1 May 2017

Recording height and lung capacity in Excel so we can make a scatter graph - 3rd and 4th

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