Re: significant figures?

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

Actually I can get addition to work. I have not found away to apply the
multiplication and division rule to apply.
Excel needs to count the number of significant figures in each number, then
apply the minimum number to the answer in rounding.

"bgarey" wrote:

This is all correct. But is there away to get Excel to round to the correct
place value.
I know the TI-83 calculators have an application that can round to correct
significant figures. I have no idea how to do this.

"Fred Smith" wrote:

When I took significant figures, we differentiated it as follows:

1. 1200 is 2 sig figs
2. 1200. is 4 sig figs (note the decimal point)
3. 1.20 x 10^3 is 3 sig figs

Regards,
Fred.

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:HqudnafX9fTwPCDVnZ2dnUVZ8jmdnZ2d@xxxxxxxxx
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?
    ... measured to 3 or 4 significant figures? ... least significant place value of the measurements: ... When multiply and dividing, the final answer should be rounded off to the ... "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)