MATLAB: How to get matrix weighted average

weighted average

Suppose i have matrix A=[1;2;3]. I want the answer as = [1/6;2/6;3/6]

Best Answer

A=[1;2;3];
result=A./6

result=A/6

Related Solutions

MATLAB: Matrix summary – weighted average

variant

inital data (A, B)

A = [cellstr(datestr(sort(rand(20,1)),'HH:MM:SS')),...
                            mat2cell(randi(45,20,2),ones(20,1),2)];
[i1 i2] = meshgrid(0:23,[0 30]);
HM = [i1(:) i2(:)];
B = datestr(datenum([zeros(size(HM,1),3) HM zeros(size(HM,1),1)]),'HH:MM:SS');

solution

ta = rem(datenum(A(:,1),'HH:MM:SS'),1);
tb = rem(datenum(B,'HH:MM:SS'),1);
[n,bin] = histc(ta,tb);
R = accumarray([repmat(bin,2,1),reshape(repmat([1 2],size(bin)),[],1)],...
                    reshape(cell2mat(A(:,2)),[],1),[size(tb,1) 2],@(x){x})  ;
M = arrayfun(@(i1)R{i1,1}'*R{i1,2}/sum(R{i1,2}),(1:size(R,1))','un',0);
C = [cellstr(B) M];

ADD (12.09.2011 16:45 MSK) reply at " I need to take the previous value when there is no data "

t = ~cellfun(@isempty,M);
M2 = M(t);
M = M2(cumsum(t));

MATLAB: Matrix Averaging

If A is your matrix and tol stands for "a certain average,"

if mean(A(:,1))<tol
   M = mean(A(:,2:5));
end

Best Answer

Related Solutions

MATLAB: Matrix summary – weighted average

MATLAB: Matrix Averaging

Related Question