Clear Filters
Clear Filters

Calculate value based on previous row plus adjacent row

5 views (last 30 days)
Hi,
I have a matrix of two columns and need to calculate the values of the second column based on the previous row of column 2 plus the adjacent row of column 1. For example,
Given the above matrix, cell B4 has been calculated by getting the value of cell B3 + A4. This carries on for the duration of the matrix.
I can do this quite easily in Excel but am finding it rather difficult in Matlab.
Any help/suggestions would be greatly appreciated please.

Answers (3)

Adam
Adam on 19 Jul 2016
For that particular example:
B = cumsum( A )';

Azzi Abdelmalek
Azzi Abdelmalek on 19 Jul 2016
Edited: Azzi Abdelmalek on 19 Jul 2016
idx=1:6
out=B(idx)+A(idx+1)

Thorsten
Thorsten on 19 Jul 2016
A = [0:5];
B = [0 1 3 6 10 15];
ind = 3:6;
C(ind) = A(ind) + B(ind-1)
M = [A' B' C']

Categories

Find more on Shifting and Sorting Matrices 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!