Unable to perform assignment because the indices on the left side are not compatible with the size of the right side.

Hi, Im trying to get matlab to read my excel file but it keeps coming up with the above error message. Not sure how to recitfy it, please help!

Answer 1

[Yongjian Feng]

Try to initialize Y first?

Y = zeros(size_determined_by_your_Data, 6);

[Safa Sharif]

same error message comes up

[Yongjian Feng]

Note that log(Data(:,6)) has the same size of Data(:, 6). But diff(log(Data(:, 6))) has one less. If your Data(:, 6) has size of n, then diff(log(Data(:, 6))) has size of n-1. Most likely the error is caused by this difference.

In other words, your Y shall be initialized with this in mind.