Average in a summation

1 次查看(过去 30 天)
Omar
Omar 2014-2-11
Say I have an Excel File with X and Y columns.
How can I compile a program to do the (average between 2, X terms) times (the difference between the 2, Y terms) for n number of terms in consecutive order.
I tried Sum([X(1:end-1) + X(2:end)]/2.* (y(2:end)-Y(1:end))) for some reason the actual value was half the amount from what I got so I'm not sure if I made and error in my coding.

回答(1 个)

Azzi Abdelmalek
Azzi Abdelmalek 2014-2-11
编辑:Azzi Abdelmalek 2014-2-11
You did 2 errors
X=rand(10,1);
Y=rand(10,1);
sum((X(1:end-1)+X(2:end))/2.*(Y(2:end)-Y(1:end-1)))
sum instead of Sum
Y(2:end)-Y(1:end) is not correct (different sizes)

类别

Help CenterFile Exchange 中查找有关 Mathematics 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by