I have to perform the following task

I have an excel data sheet which contains 400X7 values and the following task are to be performed....

1. Display the data in form of a matrix (400 x 7) in matlab
2. Multiply each coulmn with each other ( For ex. Column 1* Column 1, Column 1* Column 2, Column 1* Column 3, similarly 1 with 4, 2 with 1 and so on)
3. Take Mean of each Column multiplication results
4. Form a 400 x 7 Matrix
5. So the mean of multiplication of Column 1 with Column 1 will be the first element (R11) of 400 x 7 matrix, the mean of multiplication of Column 1 with Column 2 will be the 2nd element (R12) of 400 x 7 matrix like wise I need to calulate each and every value of 400 x 7 matrix

Any suggestions pls

[madhan ravi]

what have you tried so far?

[Jay Mistry]

clc

clear all

C1 = xlsread('fire.xls','E1:E400');

C2= xlsread('fire.xls','F1:F400');

C3 = xlsread('fire.xls','G1:G400');

C4 = xlsread('fire.xls','H1:H400');

C5 = xlsread('fire.xls','I1:I400');

C6 = xlsread('fire.xls','J1:J400');

C7 = xlsread('fire.xls','K1:K400');

A= [C1 C2 C3 C4 C5 C6 C7]; % Formlated matrix from the Excel sheet

R11= mean(C1.*C1);

R12= mean(C1.*C2);

R13= mean(C1.*C3);

R14= mean(C1.*C4);

[Arunkumar M]

What do you mean by multiplying Column 1 with Column 1?

You cant multiply m x 1 vector with m x 1 vector.

Do you mean to perform a element wise multiplication? - if so, this again results in m x 1 vector and you can find mean of it.

[Jay Mistry]

I mean multiplying matrix column 1 with column 1, Column 1 with C2, C1 with C4, C1 with C5, C1 with C6, C1 with C7,

Column 2 with Column 1, Column 2 with Column 2,Column 2 with Column 3,Column 2 with Column 4,Column 2 with Column 5,Column 2 with Column 6,Column 2 with Column 7,

Column 3 with Column 1,Column 3 with Column 2,.......

'' '' '' '' " "

'' '' " " " "

Column 7 with Column 1 ...........Column 7 with Column 7.

Multiplying each and every column with each other

Answer 1

[KSSV]

[num,txt,raw] = xlsread(myexcelfile) ;
% num will give you your 400*7 matrix
iwant = num(:,1).*num ;   % this mulitplies every column with first column 
themean1 = mean(num,1) ;  %mean of columns 
themean2 = mean(num,2) ; % mean of rows