How can I perform a mathematical operations on all elements of a column of numerical data imported from Excel in Matlab?

I have imported 2 columns of numerical data from excel in matlab and I want to divide each element of the first column by sqrt(3), how can that be done in matlab?

Answer 1

[Star Strider]

Try this:

D = xlsread('YourFile.xlsx');
D1new = D(:,1)/sqrt(3);

[Neha Sinha]

Thanks :)

[Star Strider]

As always, my pleasure!