Fast Fourier Transform in excel

Click For Summary
The discussion centers on performing a Fast Fourier Transform (FFT) in Excel without a constant sampling rate. The user is struggling to fill the frequency column due to irregular time intervals in their data. Suggestions include following a specific online guide for FFT in Excel and noting that the frequency column requires an equation that assumes a constant sampling rate. To address the issue, it is recommended to adjust the time intervals by expanding the rows to ensure they are equally spaced at 0.5E-8 seconds, allowing for interpolation of the data. An attachment with a starter spreadsheet is also provided to assist with the process.
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

MATLAB Turning Fourier coefficients into an interpolated freq domain function
  • · Replies 8 ·
Replies
8
Views
2K
MATLAB FFT for one 1*N Green function in MATLAB
  • · Replies 2 ·
Replies
2
Views
2K
MATLAB Fast Fourier Transform in MATLAB
  • · Replies 4 ·
Replies
4
Views
3K
Undergrad Get the time axis right in an inverse Fast Fourier Transform
  • · Replies 2 ·
Replies
2
Views
3K
Graduate Memory issues in numerical integration of oscillatory function
  • · Replies 3 ·
Replies
3
Views
2K
Mathematica Issues with Direct Fourier Transform in Mathematica
  • · Replies 1 ·
Replies
1
Views
3K
MATLAB Discrete Fourier Transform in MATLAB
  • · Replies 5 ·
Replies
5
Views
5K
Undergrad Please discuss discrete Fourier analysis
  • · Replies 12 ·
Replies
12
Views
2K
Fourier transform: duality property and convolution
  • · Replies 1 ·
Replies
1
Views
2K
MATLAB Is FFT the Proper Method for Transforming Green Function in MATLAB?
  • · Replies 6 ·
Replies
6
Views
2K