Math - Excel

posted by .

Hi, I need to write an Excel formula and I am trying to double check my work.

We are asked to find the difference and relative difference for this account.

So the values are:

$10,000
$10,700
$11,400
$12,100
$12,800
$13,500
etc.

The difference for each is $700

I have two ways to calculate relative difference:
1) difference/original value or
2) new value - original value/original value

If I do the first one, my Excel formula would be =700/10,700 = 6.54%. Assume those numbers are in cells A3 and B3, so the formula would be B3/A3. ($10,000 in A3, $700 difference in B3)

However, if I use the second formula using the first two values, assuming the $10,000 is in A2, $10,700 is in A3, and difference of $700 is in B3. I would get 10,700 - 10,000/10,000 = 7%. Formula would be (A3 - A2)/A2
The $10,000 would be the original value, and the new value would be the $10,700, so why am I getting a different percentage.

When I copy this formula all the way down, I am one year off. So the percent for year 5 in the first formula is in year 6 for the second, and so forth.

Obviously I'm missing something here, but just am not seeing what.

I'm sorry I tried to make this as clear as possible. I tried to copy and paste the spreadsheet but was not able to do so in a neat format.

Thank you.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. BCIS

    You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/, select …
  2. managerial economics

    my cubic equation is O=C+aL+bL^2+cL3 how can i get the excel to help me to do this equation.I need to do a regression analysis to estimate the firm's short-run production function. see tarha question dated july 2,2007 for all of the …
  3. math using excel

    how do i use excel to plot a graph then find x from the slope of a line?
  4. excel Buget

    I am trying to get a formula for excel I have merchandis Amount shirt 13 29.95 pants 22 shoes18 dress16
  5. Math (excel formulas)

    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 …
  6. engineering physihcs

    I need to create an Excel chart showing world oil reserves vs. time, which are both in columns and cannot find how to graph this in excel. thank you.
  7. Earth Science

    I need help with the following Lab due tonight, 7/30/12, as I feel completely lost and would appreciate the help. The lab goes as follows: Design an experiment that illustrates the determination of the density of a cylindrical object …
  8. Excel formula help

    Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly
  9. basic excel

    Write one Microsoft excel formula that works for conditions below on cell C1 for any number: a) IF A1+B1<=4, return $20 b) IF A1+B1>4 but <=9, return $35 c) IF A1+b1>9 but <=14, return $50 d) And IF A1+B1>15, return …
  10. 9th grade algebra (sequences)

    Can you check my homework please? Given the following representations, tell whether it's arithmetic/geometric, find the difference/ratio, find the explicit formula, find the recursive formula, and the given term. (This whole question

More Similar Questions