How do I apply a formula to a list of data in Excel 2007 - Geeks to Go Forums

Jump to content

Log in Register Register Malware removal guide How it works

How do I apply a formula to a list of data in Excel 2007

#1 joshuagor44

  • Group: Member
  • Posts: 54
  • Joined: 08-March 06

Posted 27 September 2007 - 06:08 PM

I have a long list of data and I need to apply the formula:

(Yn+2 - Yn-2) / (Tn+2 - Tn-2) = X

Where n is a data point.

So if I have a data table like this:

Y | T
-------
0 | 12
1 | 13
2 | 14
3 | 15
4 | 16
5 | 17

For Y = 2, the calculation would be:

(4 - 0) / (16 - 12) = X = 1

The formula obviously won't work for the first and last two data points, but that's fine.

Share this topic: