Average in a summation

2 views (last 30 days)
Omar
Omar on 11 Feb 2014
Edited: Azzi Abdelmalek on 11 Feb 2014
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.

Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 11 Feb 2014
Edited: Azzi Abdelmalek on 11 Feb 2014
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)

Categories

Find more on Mathematics in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!