iYogi

Home » Technology » How to do a Fast Fourier Transform (FFT) in Microsoft Excel

How to do a Fast Fourier Transform (FFT) in Microsoft Excel

Fast Fourier Transform (FFT) is the easiest way to show the dominant frequencies in a signal. FFT is an efficient algorithm to compute the discrete Fourier Transform and in its inverse. There are many distinct FFT algorithms which involves a wide range of mathematics, which starts from simple complex-number arithmetic to group theory and number theory too. You also need Microsoft Excel with the Data Analysis package.If you don’t have this you can install this under Tools or Add-ins.

Microsoft ExcelIn this article you will see how to perform a FFT graph in Microsoft excel.

Step 1:

First and foremost open a blank spreadsheet and then follow the following titles to the first cells in column A, B, C, D and E of your spreadsheet: Time, Data, FFT Frequency, FFT Complex, and FFT Magnitude.

Step 2:

You need to add your data to the “Data” column. It will be helpful for you to make a note of the number of data points that is samples in your list and taking into consideration the sampling rate at which your data is taken. Do not forget o write and label these two numbers somewhere in your spreadsheet.

Step 3:

In the “Time” column, you need to determine the time at which each point was taken. The easiest way to do this is to divide the total time by the number of data points.

Step 4:

Next you need to perform a Fourier Analysis of your data which can be either Data/Data Analysis/ Fourier Analysis. You have make sure that the input range is your entire data column and the output range is you entire FFT Complete column. This column is known as FFT Complex column because the Fourier Analysis function outputs a complex number.

Step 5:

In the very first cell of the “FTT Magnitude” column, you need to type the following equation: =IMABS (E2)

Now you need to drag this equation down so that it fills every cell in this column. This will turn all the complex numbers in the “FTT Complex” column into a real number so that we can use the dominant frequencies.

STEP 6:

Now we need to calibrate the axis A of the graph to show the dominant frequencies. It may prove beneficial if we create a separate column showing zero through the number of data points minus one (N-1). It will also help to create a separate cell with the following function:

=(S/2)/ (N/2) over here S is a sampling rate and N is the number of samples.

In the “FTT Frequency” column you need to type the following function:

=F2*SG$4

Here F2 is the appropriate number from the number column, and $G$4 denotes the function dividing the sampling rate by the number of samples. Now drag this function down to half of your data of your data points.

Step 7:

Now create a graph of “FTT Magnitude” column (Y axis) versus the “FTT Frequency” column (X axis). If all you have done is right then you should get a graph with peaks where the dominant frequencies are.

Harmeet

About Harmeet


loves to simplify technology for all readers who are interested in the genre but find it complex to comprehend. She is a writer by passion and wants to enrich the life of others by writing about the latest gadgets, apps, and devices in the simplest and the most useful manner. Her blogs are detailed, interesting, and definitely fun to read…


Experience the Best Computer Support

5 Responses to " How to do a Fast Fourier Transform (FFT) in Microsoft Excel "

  1. Oscar says:

    Hi,

    I came across your notes, while I was searching for a recipe to do FFT analysis on a data set using excel.

    as easy as they seem, I am having a bit difficulty to follow the instructions.

    is G4 equal to (S/2)/(N/2) where S is the sampling frequency, and N is the number of points. Why is it (S/2)/(N/2)? why did not you write S/N? How is it any different?

    also why fft frequency equal to F2*G$4? is this the definition of fft frequency?

    Thank you very much,

    Oscar

  2. Schwarzer says:

    I agree with Oscar. You have errors in your instructions and there must be steps missing…

  3. Robin says:

    You have no idea how greatly I was looking for these steps. I was trying to find online solution and luckily I ended up here. I have bookmarked this page to refer to the steps whenever I want and I have even shared it with my brother who often trouble me with Microsoft word and excel issues. TechGenie is a good platform to look for details like this

  4. Techie Justin says:

    Every time I try to perform a FFT graph in Microsoft excel, I get stuck at the fifth step where we need to type the equation. Performing a FFT graph is not easy but thanks to the DIY solution here, I can now perform it easily. TechGenie has helped me to resolve many technical issues like this before.

  5. Reenie says:

    I always end up doing something wrong while performing a FFT graph in Microsoft excel. I usually get confused at the equation step but the steps here are easy to follow and next time I will be able to do it on my own. I have a request that you please continue to give such DIY’s as it is of great help to the technically challenged people like me. TechGenie is a big hope for me and I always look forward to the information given here

Leave a comment

*