Sunday
March 29, 2015

Homework Help: Math (excel formulas)

Posted by Emily on Sunday, March 1, 2009 at 12:41am.

I am finding absolute and relative differences in excel. I have a compared value of 1.00 (D6) and a reference value of 38.50 (D6). I found the absolute difference to be -37.50 (D6-D9). For the relative difference I took the compared value of 1.00 (D6) and subtracted the reference value (D9) and divided it by the reference value (D9).
My formula looks like this =D6-D9/D9. I got an answer of 0.00%. When I write the formula like this =(D6-D9)/D9 it gives me an answer of -97.40%.
My teacher emailed me and said that 'The relative difference percents can be more than 100% but cannot be less than 100%.' Can someone please tell me what I'm doing wrong?

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

math - HI, I am having trouble working this problem. This is the question: Two ...
Chemistry - How do you find Absolute error and how do you find relative error? ...
math, help - For the following set, which number has the largest absolute value...
Excel - How am i to Calculate the appropriate discount using the IF function ...
Math - 1. Suppose a and b are integers, and the absolute value of a is > than...
math !!!!!!please part of a major grade!!!!!! - when in the absolute value of x ...
math - i can figure this out -2+|-5+6| i try inverse but im still getting it ...
Geometry - Show the conhecture is false by finding a counterexample... 1. The ...
math - when in the absolute value of x equal to the absolute value of negative x...
Excel & Math - I'm not sure what two excel functions to use that will give the ...

Members