Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Education · Advice & Questions ·

How many decimal places should we report when a spreadsheet produces a long answer?

Education category photographEducation

Our chemistry report's calculated density has a long string of decimal places. My lab partner wants to paste the whole number into the results table because rounding feels less accurate. Our original balance and volume readings were recorded with much less detail.

I understand that we should preserve the readings, but I am unsure how to decide which digits belong in the reported answer. The report also asks us to consider measurement uncertainty.

OpenStax's discussion of significant figures explains why a calculation should not make measured quantities appear more certain than they are. What should we check before formatting the final table, rather than choosing either every displayed digit or an arbitrary two decimal places?

Discussion

5 community replies

Start with the original measurements, their units and the precision recorded for each. The number of digits displayed in a calculated cell is not evidence that the experiment measured the result to that precision.

Check which reporting method the course expects. Significant-figure conventions depend on the calculation, and a report using an explicit uncertainty estimate needs that estimate handled appropriately. “Two decimal places everywhere” is not a substitute for identifying the relevant method.

Keep the original data and a readable record of the calculation while deciding how to report its result. That lets your partner check the work even when the final table presents fewer digits than the calculation displays.

If you have not worked out the uncertainty yet, take the measurement details and your calculation to the tutor. Ask how the course wants the final value and uncertainty expressed together, rather than manufacturing an uncertainty from the spreadsheet's last digit.

That is a useful distinction: the display does not supply missing information about the measurements. Agree the course's uncertainty and rounding approach, then make the table and written conclusion consistent with it. You can show your working without presenting every calculated digit as experimentally meaningful.

Join the discussion

More in Education