View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Fouriertransformation

Not usre why you want a FFT. I would format you trnad line (right click
trand line) and make it a polynomial of 6th order to get a more precise
trandline.

"maqqusz" wrote:

Hi,

Can anybody tell me how I make a FFT-Transformation in Excel?
I have never used an AddIn before and so I don't know how to
do ist. My Values [2] I want to transform are yearly Temperatures
from 1980 to 2006, so the Imaginary-value may be zeros.

How do I do such a Transformation. There are 127 Values
so if I add one unknown more it should be possible.

[1] http://home.arcor.de/maqqusz/wetterr...temperatur.png
[2] http://home.arcor.de/maqqusz/wetterr...Temperatur.xls
[3] http://home.arcor.de/maqqusz/wetterr...Temperatur.txt

Markus