Statistics How To

Fourier Analysis: Definition, Steps in Excel

Calculus > Fourier Analysis

What is Fourier Analysis?

Fourier Analysis is an extension of the Fourier theorem, which tells us that every function can be represented by a sum of sines and cosines from other functions. In other words, the analysis breaks down general functions into sums of simpler, trigonometric functions, The Fourier series tells you what the amplitude and the frequency of the sines and cosines are. Fourier Analysis is a useful tool for studying phenomena like sound or neural pathways and is commonly used in everyday items like cell phones, DVDs and JPEGs.

Fourier Analysis Excel: Overview.

Watch the video or read the steps below:

fourier analysis excel The Analysis converts a single set of data points into a second, equal size set of data points. The Fourier analysis Excel tool has a couple of limitations:

  1. The maximum number of points is 4,096
  2. The data points must be in powers of two. In other words, you can only enter 2,4,8,16,32,64,128…4,096 numbers.

If your data set contains fewer numbers (i.e. 5 or 30), pad the data set with extra zeros (to make 8 or 32) so that you can run the Fourier analysis tool.

How to run Fourier Analysis Excel 2013: Steps

Step 1: Type your data into a single column (it only works on a single column of Data).

Step 2: Click the “Data” tab and then click “Data Analysis.” If you don’t see that option, load the Data Analysis Toolpak.

Step 3: Click “Fourier Analysis” and then click “OK.”

Step 4: Type a range for your data into the Input Range box. For example, if your data is in cells J1 to J16, type “J1:J16” into that box.

Step 5: Check the “Labels in first row” box if you have column headers (so that Excel knows to exclude that row).

Step 6: Click in the Output Range box and then select an area immediately to the right of your data. You can also check “New Worksheet,” but having the Fourier Analysis results right next to your data will be more useful.

Step 7: Check the “Inverse” box only if you have results from a prior analysis and you want to find the original function.

Step 8: Click “OK.”

Tip: An “i” in the results means a complex number. If you see a green triangle, it means the data has been converted to text. Click the cell, click the error message and choose “Convert to Number.”

Check out our YouTube channel for more stats help and tips!

------------------------------------------------------------------------------

If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.

Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!
Fourier Analysis: Definition, Steps in Excel was last modified: October 12th, 2017 by Stephanie Glen

2 thoughts on “Fourier Analysis: Definition, Steps in Excel

  1. Thomas Ferrari

    Thank you very much. However, I am not sure how to take the imaginary numbers after the analysis and turn them into meaningful PSD values for various frequency ranges. Can you help me with this or point me to additional resources? Thanks so much, Thomas

  2. Andale Post author

    Hi, Thomas,
    Sorry, but Power Spectral Density (PSD) is outside my area of expertise. Perhaps try a physics forum? If you do find an answer, perhaps you’d consider coming back here and posting it :)
    Best of luck,
    Stephanie