I am facing this error (Attempted to access num(:,2); index out of bounds because size(num)=[14341,1]. Error in Untitled10 (line 3) rpm =num(: , 2);

1 次查看（过去 30 天）

arif hussain 2017-5-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342393-i-am-facing-this-error-attempted-to-access-num-2-index-out-of-bounds-because-size-num-14341

评论： Walter Roberson 2017-5-30

filename = 'first.xlsx';
num = xlsread(filename);
rpm =num(: , 2);
time =num(: , 1);
f= rpm/60;
t=1/f;
N = length(num);
a=sin(2*pi*f)*t/N;
plot(f , a)
xlabel('Frequency (Hz)')
ylabel('Displacement');
title('Displacement Spectrum');

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

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson 2017-5-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342393-i-am-facing-this-error-attempted-to-access-num-2-index-out-of-bounds-because-size-num-14341#answer_268822

I suspect that your time column is being interpreted as text or non-numeric. If you have R2013b or newer consider using readtable

4 个评论
显示 2更早的评论隐藏 2更早的评论

arif hussain 2017-5-30

first.zip

the attached file

Walter Roberson 2017-5-30

在 MATLAB Online 中打开

Your time data looks like '9:29:55 PM0' and has a large number of repetitions of each value. On the other hand, you do not actually use the tie.

I suggest

filename = 'first.xlsx';
num = xlsread(filename);
rpm =num(: , 1);
f = rpm/60;
t = 1 ./ f;
N = length(num);
a = sin(2*pi*f) .* t/N;
plot(f , a)
xlabel('Frequency (Hz)')
ylabel('Displacement');
title('Displacement Spectrum');