Average in a summation
1 回表示 (過去 30 日間)
古いコメントを表示
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.
0 件のコメント
回答 (1 件)
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)
0 件のコメント
参考
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!