Re: significant figures?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



How would you distinguish 1200 measured to 2 significant figures from 1200
measured to 3 or 4 significant figures?
--
David Biddulph

"bgarey" <bgarey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F9E0F63E-8B50-403E-9AA8-5EF89A8D9E9C@xxxxxxxxxxxxxxxx
When adding measurements, the final answer needs to be rounded off to the
least significant place value of the measurements:

The answer to 12.3 + 312.56 should be rounded off to the .10's place.
The answer to 1200 + 346 should be rounded off to the 100's place.

When multiply and dividing, the final answer should be rounded off to the
least number of significant digits.

The answer to 245 x 1.2 should be rounded to 2 digits and adding zero's
for
place value if necessasry.


"Rick Rothstein" wrote:

I am not finding your question to be clear.. can you provide a little
more
detail as to what you are looking for along with 3 or 4 examples of what
you
have and what you expect them to look like after being rounded?

--
Rick (MVP - Excel)


"bgarey" <bgarey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:13DF4ED1-5161-4D92-961C-6A0FF95D0927@xxxxxxxxxxxxxxxx
Can I use excel to round operations with measurements to significant
figures




.



Relevant Pages

  • Re: significant figures?
    ... Excel needs to count the number of significant figures in each number, ... least significant place value of the measurements: ... "Rick Rothstein" wrote: ...
    (microsoft.public.excel.misc)
  • Re: OT: definition of "significant figures"
    ... > Given a set of measurements x, I'd like to print their average to ... > the "correct" number of significant figures. ... > I've got some adhocery that more or less does it, ... for I in X'Range loop ...
    (comp.lang.ada)
  • OT: definition of "significant figures"
    ... Given a set of measurements x, I'd like to print their average to ... the "correct" number of significant figures. ... I've got some adhocery that more or less does it, ... Prev by Date: ...
    (comp.lang.ada)
  • Re: OT: definition of "significant figures"
    ... > the "correct" number of significant figures. ... > moderately standard, formal, definition? ... The base 10 logarithm of the standard-deviation of your measurements. ... Prev by Date: ...
    (comp.lang.ada)