Using Data from Some Species and Inferring Metabolic Rate about Others | |
![]() Since the numbers cover a wide range of values, from almost zero to thousands, it makes sense to transform the raw numbers to logarithms before drawing the graph. This process can be accomplished easily in the spreadsheet by making two additional columns and using the natural log function that is built in (see the formula up above in the formula bar). | |
2. Next, select (by placing the cursor over the first cell, then clicking and draging the cursor to the last cell) the numbers in the two log columns and use the Chart Wizard by clicking on the Chart Wizard icon and following the appropriate steps.
The resulting graph is shown below. Draw a straight line that best fits the points on the graph.![]() | |
![]() | |
Data from: Avian Energy Balance & Thermoregulation |