How to average certain columns in a matrix
    13 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 Creating and Concatenating Matrices 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!
