Multiply each column by a elements of cell array

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

Answer 1

[KSSV]

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{:}]'))

[lucksBi]

Thanks alot. Will it be same if matrix is a cell array instead of 2D?

[KSSV]

No...it is better to work with matrices. I suggest to convert your mul to matrix.

Answer 2

[Guillaume]

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]

Yes Thanks alot for suggestion but it was kind of requirement. Thanks for your time.

Answer 3

[Andrei Bobrov]

result = matrix.'*cat(1,mul{:});

or

result = [mul{:}]*matrix;

[lucksBi]

Thank You for helping. @Andrei Bobrov