Extracting data from excel file; Adding a new column; plotting the first and the newly added column
1 次查看(过去 30 天)
显示 更早的评论
Hello,
Can someone please help with the following code:
I need to import data from an excel file(9600x2). Then i need to add a new column such that the new column is equal to the value in the second column minus the mean of the entire second column.
At the end i want to plot the 3rd column values versus the 1st column values.
Thank you in advance
0 个评论
采纳的回答
Ameer Hamza
2020-10-16
Something like this
M = readmatrix('sample.xlsx');
M = [M, M(:,2)-mean(M(:,2))];
plot(M(:,1), M(:,3))
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!