Program for the equation

The input excel sheet contains 504 rows x 14 columns How to do Matlab program for the below equation? MF = sum (amplitude(f)*f)/sum (amplitude(f)) f = summation--varies from 0.5 to 3.9 Hz where, amplitude(f) associated with each of the frequencies (0.5 to 3.9). Kindly help me in this regard.

Answer 1

[dpb]

Presuming you've loaded the spreadsheet into two variables f and ampl,

MATL
MF=sum(ampl.*f)/sum(f);

If it's as an array of two columns, then just use the column indices instead

MATL

MF=sum(x(:,1).*x(:,2))/sum(x(:,1));

NB the .* to do element-by-element multiplication.