How ro divide a scalar by a excel data and plot the result?

Hello everyone,

I am trying to plot a excel data, where the data is divided by a single scalar value. But when I am trying to plot the data I am not getting the desired result. The clear explaniation is: 51 a scalar value should be divided by the data in coloum 4. So basically 51/data(:,4). I am attaching the data and the code. Please kindly help me. Thanks in advance.

Z = readtable('centerlinevel.xlsx') ;

data = table2array(Z) ;

N = size(data,2);

Nsp = N/2;

X= 51/data(:,4);

plot(data(:,1), data(:,2), '*');

hold on

plot(data(:,3), X, 'linewidth', 2);

hold off

Answer 1

[VBBV]

 X= 51./data(:,4);

Use the element wise division operator

[Vishnuvardhan Naidu Tanga]

Thank you. It worked.