How can I form a matrix of 400 X 7 and multiply values of 1st column of matrix with 4th Column ?

1 visualización (últimos 30 días)
Jay Mistry
Jay Mistry el 12 de Nov. de 2018
Comentada: madhan ravi el 13 de Nov. de 2018
How can I form a matrix of 400 X 7 and multiply values of 1st column of matrix with 4th Column ?

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

madhan ravi
madhan ravi el 12 de Nov. de 2018
Editada: madhan ravi el 12 de Nov. de 2018
EDITED
[num,~,~]=xlsread('myexcelfile.xlsx')
RESULT = num(:,1).*num(:,3)
average = mean(RESULT)
  2 comentarios
Jay Mistry
Jay Mistry el 12 de Nov. de 2018
Editada: Jay Mistry el 12 de Nov. de 2018
Thank you for answering, So basically I've an Excel File which has 7 columns and 400 rows. The task is to multiply column 1 with column 3 and find average value of the column multiplication result

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Creating and Concatenating Matrices en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by