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)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!