Hi there,

could someone remind me how to compare two values. I have 2.03085 and 2.495.

I know it should be something fairly simple, but just plain forgot!!

Printable View

- Nov 22nd 2012, 08:43 PMNettieLCompare
Hi there,

could someone remind me how to compare two values. I have 2.03085 and 2.495.

I know it should be something fairly simple, but just plain forgot!! - Nov 22nd 2012, 10:37 PMProve ItRe: Compare
What do you mean by compare?

- Nov 22nd 2012, 11:06 PMNettieLRe: Compare
by saying the percentage of difference between each value

- Nov 22nd 2012, 11:11 PMProve ItRe: Compare
First work out the difference, then write that difference as a proportion of the original amount, finally multiply by 100% to get the percentage.

- Nov 22nd 2012, 11:20 PMNettieLRe: Compare
so 2.495-2.03085=0.46415

but then 'write as a proportion of the origional amount', which origional amount?? - Nov 22nd 2012, 11:24 PMgrillageRe: Compare
You can take either number as your original amount. If you take 2.495 then you will express your "comparison" as a decrease. If you take the 2.03085 as the original then the change is an increase.

- Nov 22nd 2012, 11:44 PMNettieLRe: Compare
so it could be 0.46415/2.495=0.186(100)=18.6% decrease?

- Nov 22nd 2012, 11:56 PMgrillageRe: Compare
Yes, that seems ok.

- Nov 23rd 2012, 12:08 AMNettieLRe: Compare
great, thank you for your help :)