Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)
COURSE of the MONTH
14 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
how many combinations of three numbers can be found in any given quantity
Posted on 2013-02-04
I have to work out and write down (on a spreadsheet):
how many groups of three numbers can be extracted (without repetition) from 80.
as an illustration:
there is only one group of three numbers in 3 (1,2,3)
there are four groups of three numbers in 4 (1,2,3 1,2,4 1,3,4 2,3,4)
there are 10 groups of three numbers in 6 (see attached worksheet)
I hope this calculation makes sense.
I need help with the formula for determining how many combinations, but in addition I also need them written out in a spreadsheet in an ordered way similar to that arranged in the attached worksheet.
I would be very grateful for help
sample-3.xls
how many groups of three numbers can be extracted (without repetition) from 80.
as an illustration:
there is only one group of three numbers in 3 (1,2,3)
there are four groups of three numbers in 4 (1,2,3 1,2,4 1,3,4 2,3,4)
there are 10 groups of three numbers in 6 (see attached worksheet)
I hope this calculation makes sense.
I need help with the formula for determining how many combinations, but in addition I also need them written out in a spreadsheet in an ordered way similar to that arranged in the attached worksheet.
I would be very grateful for help
sample-3.xls
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5
3-
3
- +1
12 Comments
Active today
I have =COMBIN(80, 3) for excel which gives me 18,424 possibilities
Now, what would be great would be a way of listing them all out in order.
1 2 3 (each number to its own cell)
1 2 4
1 2 5
1 2 6.... etc
Now, what would be great would be a way of listing them all out in order.
1 2 3 (each number to its own cell)
1 2 4
1 2 5
1 2 6.... etc
Active today
thankyou d-glitch, I have that already
I need some sort of code that will list them out, so that I can count the occurrence of combinations in a sample
I need some sort of code that will list them out, so that I can count the occurrence of combinations in a sample
since there are 164,320 sets of 3 numbers in the result set, that will be quite a challenge to list each set in Excel.
AW
AW
Active 1 day ago
If you have a programming language and an 80-element array, you can do it with three nested loops:
For i = 1 to 80
For j = i to 80
For k = j to 80
Print Array( i), Array( j), Array( k)
next k
next j
next i
For i = 1 to 80
For j = i to 80
For k = j to 80
Print Array( i), Array( j), Array( k)
next k
next j
next i
Arthur, it's 3! not 3 in the denominator. So there's only 82,160 possibilities.
I don't see why Excel could not handle that. It might take a bit longer than other languages, but I can't imagine it running any longer than a minute. It could be done with either VBA (fairly simple) or formulas (a bit harder).
Does the assignment specify which you need to use?
I don't see why Excel could not handle that. It might take a bit longer than other languages, but I can't imagine it running any longer than a minute. It could be done with either VBA (fairly simple) or formulas (a bit harder).
Does the assignment specify which you need to use?
Or since it's not an array and it's just numbers, you could just do.
row = 1;
For i = 1 to 78
For j = i+1 to 79
For k = j +1to 80
Range("A"&row).Value = i
Range("B"&row).Value = j
Range("C"&row).Value = k
row = row + 1
next k
next j
next i
Active 1 day ago
>> Does Excel have a limit to the amount it can work with ?
Yes. 64k rows and 256 columns.
That is plenty of space. The problem is the available tools.
Yes. 64k rows and 256 columns.
That is plenty of space. The problem is the available tools.
Active 1 day ago
Correction for the program ...
For i = 1 to 80
For j = i+1 to 80
For k = j+1 to 80
Print Array( i), Array( j), Array( k)
next k
next j
next i
For i = 1 to 80
For j = i+1 to 80
For k = j+1 to 80
Print Array( i), Array( j), Array( k)
next k
next j
next i
Featured Post
Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month14 days, 3 hours left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.