MATLAB: How to Calculate linear trend for each column of a matrix

linear

Can we calculate the linear trend of each column of a matrix without drawing any line,

For example I want to calculate the linear trend for the column a,b,c,d,e of the attached data

Thank you for any tips or help

Best Answer

Try this:

[D,S] = xlsread('test.xlsx');
B = [(1:size(D,1))', ones(size(D,1),1)] \ D

producing:

B =
   -0.7307   -0.6702   -0.5743   -0.5264   -0.3016
   38.1515   33.7212   35.0423   35.3009   35.6209

The first row are the slopes and the second row are the intercepts. The columns are for ‘a’ through ‘e’ respectively.

Related Solutions

MATLAB: How to import CSV files with text and numeric values

How about using xlsread?

[num,txt,raw] = xlsread('best.csv') ;

MATLAB: Delete excel rows whose first column is 0

I just created some test data (numeric/text) to try and remove the rows that contain zeros in the first column. Think this is one of the easiest ways to do it, without using actxserver.

clear all;
%%----------- creating test data -----------
%Creating values
values = {1, 2, 3 ; 
          0, 5, 'x'; 
          4, 0, 2;
          3, 8, 9};
%Write xlsx file
xlswrite('A.xlsx',values,'Sheet1');
% ----------- end creating test data -----------
%%----------- Reading test data -----------
%Read xlsx file
[N,T,RAW] = xlsread('A.xlsx');
%Find zeros in first column
ind = find(cell2mat(RAW(:,1))==0);
%Remove rows
N(ind,:) = [];
%New data saved to second sheet of same file
xlswrite('A.xlsx',num2cell(N),'Sheet2');

Best Answer

Related Solutions

MATLAB: How to import CSV files with text and numeric values

MATLAB: Delete excel rows whose first column is 0

Related Question