Fast Fourier Transform in excel

  • Thread starter lavster
  • Start date
  • #1
217
0

Main Question or Discussion Point

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

Thanks
 

Attachments

Answers and Replies

  • #3
217
0
thats what I was following. It only works for a constant sampling rate...
 
  • #4
4,465
72
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
 

Attachments

Last edited:

Related Threads on Fast Fourier Transform in excel

Replies
1
Views
20K
Replies
1
Views
5K
Replies
5
Views
9K
Replies
2
Views
1K
  • Last Post
Replies
4
Views
1K
  • Last Post
Replies
7
Views
933
Replies
5
Views
37K
Replies
5
Views
914
Top