Calculating average and saving to a new file

9 views (last 30 days)
aditi
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
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
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];

Categories

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!