How can I select n numbers from a large data that equals the given average?

1 view (last 30 days)
For Example: I have a data of rand(1000) numbers. I want to pick the 10 numbers that satisfy the average 47. And provided, only one set of 10 numbers from the group will satisfy the average 47. How can I do this? Is there any Matlab function for this?
  2 Comments
Daniel Shub
Daniel Shub on 7 Aug 2012
The RAND function returns a random number between 0 and 1. It is not possible to take 10 of those numbers that will average 47. Even if you scale the output of RAND, the numbers are floating point so the odds of finding a solution that exactly equals 47 is essentially zero. You need to tell us more about the data and what to do if the answer is not exactly 47 and ideally how close to 47 we need to get.
Raj Shankar
Raj Shankar on 7 Aug 2012
Hi Daniel
It is that I have a data of 1800 rows and 4 coloumns.
I have the formula for slope. And also I have the result of average slope value of 1294 valid points from the above bulk of data. Hereby I need to pick out that valid 1294 points that satisfies the average slope value. This 1294 points may be any from the 1800 points.
This is what. How can I do this?

Sign in to comment.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 7 Aug 2012
a=rand(1000,1)*100; % a your array
c= combnk(a,10);
b=mean(c,2)-47
[i,j]=min(abs(b))
samples=c(j,:) % the result

More Answers (1)

Andrei Bobrov
Andrei Bobrov on 7 Aug 2012
variant
A = randi(4e6,1000);
[d,ii] = sort(A(:));
B = conv(d,.1*ones(10,1),'same');
i1 = find(B <= 47,1,'last');
out = A(sort(ii(i1 + (-4:5))));

Tags

Community Treasure Hunt

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

Start Hunting!