Extracting data from excel file; Adding a new column; plotting the first and the newly added column

1 回表示 (過去 30 日間)
Ali Awada
Ali Awada 2020 年 10 月 16 日
コメント済み: Ameer Hamza 2020 年 10 月 16 日
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

サインインしてこの質問に回答する。

採用された回答

Ameer Hamza
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!

Translated by