calculate the average for each column

I have a matrix called d=

[99  99  0.100  0.120  0  0.500  0;

0       0  0       0       0.150   0.120   0;

0.110  0.010  0.010  0  0  0.300  0.100;

0  0.250  0  0.050  0.060  0.100  0.110;

0  0.120  0.040  0  0.500  0.750  99];

I want to calculate the average of each column but since I have to take the 99's out. the 99's are located at the first row and last row of the matrix

so far I have

for i=1:5;
weekly_a=mean(d(d(:,i)<99)

since I took the 99 for the first column matlab has as the answ=0.0275 when the correct answer should be 0.022

any sugestion about this?

Answer 1

[Walter Roberson]

mean( d( d(:,i)<99, i) )

Notice you had the "i" second dimension missing.