Effacer les filtres
Effacer les filtres

Which function should I use to find summation of specific values in a column array? I checked already histcounts function but I could not handle it.

1 vue (au cours des 30 derniers jours)
I need to find summation of last 10 terms in a column and continue with this interval until all the intervals are summed values in that column but my another issue is let's say I have 16 rows so last 10 rows are ok but the sum of remained 6 values are also should be calculated and the only difference btw the summation of 10 terms is their range so which functions should I check? I can do it by formulating but I am looking for a shortcut.
  2 commentaires
Jan
Jan le 6 Mai 2022
Modifié(e) : Jan le 6 Mai 2022
What are your inputs? A vector, matrix multi-dimensional array, time series, table, ...
"I can do it by formulating but I am looking for a shortcut." - How would such a formulation look like for some small example data?
busra gogen
busra gogen le 6 Mai 2022
my inputs may change so this is why I am looking for a function. My input contains years and number of occurence regarding these years. For example, it may be like this:
years #ofevents
1900 5
1901 17
1902 8
1903 9
....
1939 10
This case looks normal because there are 4 intervals but if it ends with 1940, there will be extra one year apart from 10 years intervals.

Connectez-vous pour commenter.

Réponse acceptée

Matt J
Matt J le 6 Mai 2022
Modifié(e) : Matt J le 6 Mai 2022
Let's call your matrix, A. Then,
A=rand(16,2); %hypothetical input
[N,M]=size(A);
N=ceil(N/10)*10;
A(end+1:N,:)=0;
result=sum(reshape(A,10,[]));
result=reshape(result,[],M)
result = 2×2
3.7391 5.6570 3.3933 2.2748
%Check:
sum(A(1:10,:))
ans = 1×2
3.7391 5.6570
sum(A(11:16,:))
ans = 1×2
3.3933 2.2748
  2 commentaires
busra gogen
busra gogen le 6 Mai 2022
Thank you it works well but I want to obtain the summations by starting from end
busra gogen
busra gogen le 6 Mai 2022
I changed the orientation of column, thank you so much!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Mathematics 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