How to organize a data or results table
Posted by Jim Clark on 29th May and posted in Tutorial
You have just done an experiment in which you have measured A, in qwags, B in grugs, and calculated C in qwags/grug. It is our fear, based upon past experience, that your data and results tables might just look like this:
| 23.45 | 6.1 | 3.8442623 |
| 16.7 | 4 | 4.175 |
| 11.19 | 3.1 | 3.6096774 |
| 19.47 | 4.8 | 4.05625 |
They should look like this:
|
Experimental determination of C in qwags/grug |
|||||
|
Data |
Calculations
Calculation of C C = A/B C = 23.45qwags/3.1grugs C = 7.6 qwags/grug |
Results |
|||
|
# |
A |
B |
# |
C |
|
|
qwags |
grugs |
qwags/grug |
|||
|
1 |
11.19 |
3.1 |
1 |
3.6 |
|
|
2 |
16.70 |
4.0 |
2 |
4.2 |
|
|
3 |
19.47 |
4.8 |
3 |
4.1 |
|
|
4 |
23.45 |
6.1 |
4 |
3.8 |
|
Let’s examine what was wrong with the first table
- There was no title to the table [Experimental determination of C in qwags/grug].
- Data and Results were not separated and Calculations were not between them. [Data are numbers read directly from laboratory instruments. Results are the results of calculations. One sample calculation should be shown. Of course calculations need not be a part of the table and are not normally presented in this manner. However calculations must appear in the laboratory report between data and results for the same reason that chapter 2 must appear between chapters 1 and 3 in a novel.]
- The trials were not numbered such that, later in the lab report, a specific trial could be identified by number.
- The variables, A, B, and C, were not identified.
- The units for A, B, and C [qwags, grugs, and qwags/grug] were omitted.
- Errors were made in writing the measurements of A [16.7 qwags] and B [4 grugs]. It is logical to assume that the same equipment was used to take each measurement of A. The number of decimal places does not depend upon the sample size, but rather than the scale on the measuring instrument. Presumably A was measured with an instrument capable of giving qwags to two decimal places. Probably the student recorded 16.7 qwags when the actual measurement was 16.70 qwags. The same reasoning can be applied to the measurement of 4 grugs.
- No attention was paid to the order of the experiments listed. The trials should be ordered from the lowest to the highest values of the independent variable, A [from 11.19 to 23.45].
- The answers, C, were not rounded to the correct number of significant figures. The answer to a division problem involving measurements will have as many significant figures as the measurement with the fewest significant figures. [In this case, for each trial, the measurement with the fewest significant figures is B, with 2 sig figs, hence all of the answers will have 2 sig figs].
- Notice that in the calculations section, the variable being calculated is identified [Calculation of C], then the general equation is written [C=A/B] followed by a sample calculation with units [C = 23.45qwags/3.1grugs], followed by the answer [C = 7.6 qwags/grug]. These calculations were not presented in the first table but would have almost certainly been done incorrectly based upon the information presented.
Since you will be held accountable for these ideas, if there is anything above that is not completely clear, see your teacher for help.
Related posts:
- Density Lab Evaluation Sheet Students: ____________________________________________________ Factor based upon number of trials: ___________________ Format (2) /2 Follow the format described in “The Laboratory Report”. Introduction (3) /3: Write a...
- Density unit Test Problem 1. How many significant figures are in each of the following measurements: (.2 each) a. 200.010 cm b. 8.0 E 2 mL c. 170 g....
- How to writing Laboratory Report Use the following design when writing formal lab reports. Although many lab reports will not be formal ones, you are expected to know the...
- The Best Statistic Help When a student are asking to make a research containing statistic calculations, most of them will surely complaining because they know nothing about statistic; they...
- Three-Dimensional Optical Data Storage Chemists have made real advances towards the realization of three-dimensional optical data storage. Chemical and Engineering News (dyes that absorb two photons at infrared wavelengths...

