Effacer les filtres
Effacer les filtres

Calculate value based on previous row plus adjacent row

5 vues (au cours des 30 derniers jours)
chels19
chels19 le 19 Juil 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.

Réponses (3)

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

Azzi Abdelmalek
Azzi Abdelmalek le 19 Juil 2016
Modifié(e) : Azzi Abdelmalek le 19 Juil 2016
idx=1:6
out=B(idx)+A(idx+1)

Thorsten
Thorsten le 19 Juil 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']

Catégories

En savoir plus sur Shifting and Sorting Matrices dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by