How to multiply the column in matlab..?

Question

nani kalyan 2015-5-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/217955-how-to-multiply-the-column-in-matlab

回答： dpb 2015-5-21

load.xlsx

Here i have attached the Excel file, in this i should calculate the column 2 and column 3 has to be multiply.so, for that i need some commands, please help me friends.

2 个评论
显示无隐藏无

Star Strider 2015-5-21

You have to describe what you want to do in more detail.

What specifically do you want to do with Column 2 and Column 3?

nani kalyan 2015-5-21

i want to multiply the both columns.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2015-5-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/217955-how-to-multiply-the-column-in-matlab#answer_179956

在 MATLAB Online 中打开

Just use the : operator in the row position to collect all rows and a specific column number in the column position. NB: also that * is matrix multiplication so if you want the element-wise multiplication as would presume from the question you do, you have to use the "dot" operator .*

p=x(:,2).*x(:,3);

assuming the array read from Excel is in variable x

See the help page on Arithmetic Operators under the Language Fundamentals section in *Getting Started" section or

doc times % for direct link from command line for details