Borrar filtros
Borrar filtros

Calculate value based on previous row plus adjacent row

5 visualizaciones (últimos 30 días)
chels19
chels19 el 19 de Jul. de 2016
Respondida: Thorsten el 19 de Jul. de 2016
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.

Respuestas (3)

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

Azzi Abdelmalek
Azzi Abdelmalek el 19 de Jul. de 2016
Editada: Azzi Abdelmalek el 19 de Jul. de 2016
idx=1:6
out=B(idx)+A(idx+1)

Thorsten
Thorsten el 19 de Jul. de 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']

Categorías

Más información sobre Shifting and Sorting Matrices en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by