Calculating average and saving to a new file

9 views (last 30 days)
aditi on 22 Aug 2014
Answered: Guillaume on 22 Aug 2014
I have few points between 200 to 500 which are unevenly spaced.
I have to make a file with x and y as average of all ponts in interval of 10 (if there is no point in that interval it will give 0)
i.e for 200 to 500... i will have 1 point for 200 to 210 (which will b average of all points in this interval) then 2nd point for 211 to 220... and so on..
like if my file is:
202 10000
205 12000
211 30000 .... and so on
so new x1 = average of(202,205) and new y1 = average(10000,12000) bcoz only those 2 points of the file come under 1st interval of 10.
plz help me

Answers (2)

Patrik Ek
Patrik Ek on 22 Aug 2014
Edited: Patrik Ek on 22 Aug 2014
I am not exactly sure what you want to do, but the guess is that you have to set of points x and y. Then calculate average with mean and save the data to .mat file with save.
xm = mean(x); % mean of x
ym = mean(y); % mean of y
xym = join(xm,ym); % Create a struct to save the data to hold down the number of variables in the file
save('meanValues','xym'); % Save the data
Then to load the data use load('meanValues') and if you want to split up the struct again use split(xym).
  1 Comment
aditi on 22 Aug 2014
i will explain with example...
4 20
2 24
6 33
11 22
17 222
29 344
now for limits of x 1 to 100 and for binning of value 10 i.e for intervals of 10 i will have 1 point for interval 1 to 10 which will be average of 4,2,6 in above example (as only these values lie in 1st interval of value 10) and corresponding y value will b average of y values associated with them. similarly 2nd value of x will be average of 11,17 as only these lie in next interval of 10 i.e 11-20... and so on... i hope i made my point clear

Sign in to comment.

Guillaume on 22 Aug 2014
If I understood correctly what you want to do:
points = [4 20;2 24;6 33;11 22;17 222; 29 344];
[~, interval] = histc(points(:, 1), 1:10:101); %to find which interval the points belong to
xmeans = accumarray(interval, v(:, 1), [], @mean); %to average x according to interval
ymeans = accumarray(interval, v(:, 2), [], @mean); %to average y according to interval
meanpoints = [xmeans, ymeans];


Find more on Preprocessing Data 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!