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


--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=514054

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.

--
Regards,
Tom Ogilvy


"dharshanie" wrote
in message ...

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


--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile:
http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=514054

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?


--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=514054

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

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"dharshanie" wrote
in message ...

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?


--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile:
http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=514054