# Multiply each column by a elements of cell array

2 views (last 30 days)
lucksBi on 13 Jun 2017
Commented: lucksBi on 13 Jun 2017
hey
i have a matrix like this:
matrix=
0 2 4
3 0 0
0 1 0
3 0 1
0 0 0
and cell array: mul={1,1,0.6,0.6,0.3}
i want to multiply all columns by 'mul' and then add. e.g. [0x1 + 3x1 + 0x0.6 + 3x0.6 + 0x0.3] and same for all other columns.
Thanks

KSSV on 13 Jun 2017
matrix=[0 2 4
3 0 0
0 1 0
3 0 1
0 0 0];
mul={1,1,0.6,0.6,0.3} ;
iwant = sum(bsxfun(@times,matrix,[mul{:}]'))
##### 2 CommentsShow NoneHide None
lucksBi on 13 Jun 2017
Edited: lucksBi on 13 Jun 2017
Thanks alot. Will it be same if matrix is a cell array instead of 2D?
KSSV on 13 Jun 2017
No...it is better to work with matrices. I suggest to convert your mul to matrix.

### More Answers (2)

Guillaume on 13 Jun 2017
Conceptually it would make a lot more sense for your cell array to be a column rather than a row.
Anyway, the easiest way to do what you want is to convert your cell array into a column vector. It is then trivial to multiply it with the matrix:
result = sum(matrix .* cell2mat(mul')); %requires R2016b or later
%in <R2016b: result = sum(bsxfun(@times, matrix, cell2mat(mul')));
lucksBi on 13 Jun 2017
Yes Thanks alot for suggestion but it was kind of requirement. Thanks for your time.

Andrei Bobrov on 13 Jun 2017
result = matrix.'*cat(1,mul{:});
or
result = [mul{:}]*matrix;
lucksBi on 13 Jun 2017
Thank You for helping. @Andrei Bobrov