need to convert excel (time domain data ) to frequency domain data

Question

Jignesh 2014-4-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127251-need-to-convert-excel-time-domain-data-to-frequency-domain-data

回答： rifat 2014-4-26

i have excel (.csv) file ... that is time vs acceleration data for cantilever beam. i need to convert in to frequency domain for find out natural frequency of cantilever beam

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

rifat 2014-4-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127251-need-to-convert-excel-time-domain-data-to-frequency-domain-data#answer_134663

在 MATLAB Online 中打开

Assuming the Excel file contains time data in column 1 and acceleration data in column 2

% read data
data=xlsread('fileName.xlsx');
% frequency analysis
y=fft(data(:,2));
len=length(data(:,1));
n=0:len-1;
fs=50; % mention your sampling freq
N=n*fs/(len-1);
plot(N,abs(y));