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

2 views (last 30 days)
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

Accepted Answer

VBBV
VBBV on 18 Jan 2022
X= 51./data(:,4);
Use the element wise division operator

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!