Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Fast Fourier Transform in excel

  1. Oct 1, 2012 #1
    I really need your help - i cant work out how to do a FFT in excel. The main problem is I dont have a constant sampling rate - I recorded the time and then the corresponding magnitude of the wave. I have followed everything oneline but I cant seem to get anything to work as I cant fill the frequency column. Can someone help please? ive attached my spreadsheet. The first column is the time, the second is the data taken at that time and the other stuff is using the Data Analysis tool in excel


    Attached Files:

  2. jcsd
  3. Oct 1, 2012 #2
  4. Oct 2, 2012 #3
    thats what I was following. It only works for a constant sampling rate...
  5. Oct 2, 2012 #4
    It's a bit of work but if you look at the delta t's it's always a multitude of 0.5E-8.

    So expand the rows until all are equally separated by a t= 0.5E-8 and intrapolate.

    Edit: see attached for starters

    Attached Files:

    Last edited: Oct 2, 2012
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook