FFT in Excel

[dharshanie]

Hi!

Can anyone please tell me how I could calculate FFT (Fast Fourier
Transform) of a certain range of values in excel? Any sort of help
would be greatly appreciated. Even if could point me to some place
useful, I'd be grateful. I've tried googling but have had no luck
except for paid software packages. I don't think it's that complex but
please feel free to correct me.

Thanks

Dharshie

 

[Tom Ogilvy]

If you add the Analysis toolpak in Tools=>Addins, then it will add an
Analysis entry to the Tools menu. One of the the choices under analysis is
Fourier Analysis. I believe this is what you want. See Fast Fourier
Transform in Excel Help.

 

[dharshanie]

Thank you sooooooo much for helping me find FFT in Excel. . . However
now I need to plot a graph with these FFT values- as in how do i plot
graphs for complex numbers that have an imaginary value?

Basically what I want is a frequency spectrum of the FFT data I have
from my results. Can excel do this for me?

 

[Dana DeLouis]

One common way is to just plot the absolute value of the complex number.
=IMABS(A1)