So I'm doing some signal processing and I want to take a signal and find the frequency components and so I need to do the discrete fourier transform. The problem is I'm not sure how about to go about finding them. I'm using excel at the moment just because I vaguely know how to use it.(adsbygoogle = window.adsbygoogle || []).push({});

Anyway as an example I thought I'd try and find the frequency components of a sine wave, there should only be 1 and it should be 1/2pi.

Here is a screenshot of the excel sheet.

http://yfrog.com/5nexcelfftp

What I've done is created a sine wave, taken the FFT using the data analysis add-on, then taken the modulus using the "IMABS" function and plotted it as a line graph. You can see an appropriate spike though the numbers are meaningless. I imagine you see two spikes because of the periodic nature of the fourier transform. What do I have to do next to find the frequency?

Edit: Forgot to mention I would be incredibly grateful if anyone can help me!

**Physics Forums - The Fusion of Science and Community**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Finding Frequency Components with a FFT in Excel

Can you offer guidance or do you also need help?

Draft saved
Draft deleted

Loading...

Similar Threads for Finding Frequency Components | Date |
---|---|

I Can i find this integral in a simpler way | Jan 14, 2018 |

I Q about finding area with double/volume with triple integral | Sep 13, 2017 |

I Finding a unit normal to a surface | Sep 13, 2017 |

I Finding value of parameters to fit some data | Sep 11, 2017 |

I Motivation for Fourier series/transform | Oct 17, 2016 |

**Physics Forums - The Fusion of Science and Community**