Fast Fourier Transform in excel

Click For Summary

Discussion Overview

The discussion centers around performing a Fast Fourier Transform (FFT) in Excel, particularly when dealing with non-constant sampling rates. Participants are exploring methods to calculate the frequency column necessary for the FFT using recorded time and corresponding wave magnitudes.

Discussion Character

  • Technical explanation, Homework-related, Exploratory

Main Points Raised

  • One participant expresses difficulty in executing an FFT in Excel due to the lack of a constant sampling rate and seeks assistance with filling the frequency column.
  • Another participant suggests following a specific online guide for performing FFT in Excel, indicating that an equation for the frequency column is necessary.
  • A participant points out that the guide only applies to data with a constant sampling rate, implying that the current situation is more complex.
  • One participant proposes a method of expanding the rows based on consistent delta times of 0.5E-8 and suggests interpolation to achieve equally spaced time intervals.

Areas of Agreement / Disagreement

Participants do not appear to reach a consensus on how to handle the non-constant sampling rate issue, with multiple approaches being suggested and no clear resolution to the problem presented.

Contextual Notes

The discussion highlights the challenge of applying FFT techniques in Excel when the data does not conform to a constant sampling rate, which may require additional steps such as interpolation.

lavster
Messages
213
Reaction score
0
I really need your help - i can't work out how to do a FFT in excel. The main problem is I don't have a constant sampling rate - I recorded the time and then the corresponding magnitude of the wave. I have followed everything oneline but I can't seem to get anything to work as I can't fill the frequency column. Can someone help please? I've 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

Physics news on Phys.org
thats what I was following. It only works for a constant sampling rate...
 
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:

Similar threads

  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 13 ·
Replies
13
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 5 ·
Replies
5
Views
5K