Error: Index exceeds matrix dimensions.

clear
clc

[num,txt]=xlsread('tire_ratings.xls');
ratings=num(:,1);
speed=num(:,2);
vehicles =num(:,3);
text=txt(1,1:3);

TR=triangulation(ratings,speed,vehicles);
size(TR)

%This is the error/output
Index exceeds matrix dimensions.

Error in ENG1102_11C (line 9)
speed=num(:,2);

[Andrew Newell]

I highlighted your code for you. In future, please select your code and click on the {} Code button.

[Andrew Newell]

What size is num?

[Star Strider]

Care to share ‘tire_ratings.xls’ with the rest of us so we can help you understand what the problem is? (Use the ‘paperclip’ icon, and remember to use both the ‘Choose file’ and ‘Attach file’ buttons.)

[Cody Baumann]

I apologize for the inconvenience I have never have used any sort of a half forum before. I'll post the problem and the file.

[Cody Baumann]

help*

[Cody Baumann]

Load the values into a number vector called speed and a text matrix called txt . Use the size command to determine how many rows are in the text matrix. Extract all tire ratings and store them in a vector called ratings . Extract all vehicle types and store them in a vector called vehicles .

Answer 1

[Star Strider]

This works:

ratings=num(:,1);
speed=txt(:,1);
vehicles =txt(:,3);

The ‘num’ variable has one column, ‘txt’ has three, only 1 and 3 with any information.