How to average certain columns in a matrix
4 views (last 30 days)
Show older comments
Gregory Manoukian
on 2 Jul 2021
Answered: madhan ravi
on 2 Jul 2021
I have a 107x16 matrix, the first column is time data, the last 15 are data points. I'd like to average the 15 data columns and collapse this matrix into a 107x2 matrix of time and average data.
Thank you!
0 Comments
Accepted Answer
madhan ravi
on 2 Jul 2021
Edited: madhan ravi
on 2 Jul 2021
matrix = rand(107, 16);
Matrix = [matrix(:, 1), mean(matrix(:, 2 : end), 2)];
size(Matrix)
0 Comments
More Answers (1)
madhan ravi
on 2 Jul 2021
T = array2table(rand(2, 3))
T = [T(:, 1), array2table(mean(T{:, 2 : end}, 2), 'V', {'AVERAGE'})] % where Var1 is the time data
0 Comments
See Also
Categories
Find more on Matrix Indexing 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!