MATLAB Answers


How to take the average every 5 data points?

Asked by Noah Wilson on 18 Sep 2018
Latest activity Answered by Image Analyst
on 18 Sep 2018
I have a matrix 'GoogleDateClose' that is 251 by 2. The first column is just 1-252 to give a number assigned to each value in column 2. In column 2 I have all the data points. I need to write a script to take the mean of every 5 data points and put the resulting values into another matrix so I am able to plot those values. I feel like I did a poor job of describing what I am trying to get so please let me know if I can clarify.


Do you mean take every 5th value (5, 10, 15) and then take the mean or take values 1-5 and calculate the mean and then take values 6-10 and calculate the mean
Take values 1-5 and take the mean then take values 6-10 and take the mean and so on and so forth.

Sign in to comment.




1 Answer

Answer by Image Analyst
on 18 Sep 2018
 Accepted Answer

251 or 251 is not a multiple of 5. So here it is for 250:
data = [(1:252)', rand(252, 1)] % Create sample data
column2 = data(:, 2);
out = reshape(column2(1:250), [], 5)
means5 = mean(out, 2)


Sign in to comment.