Difference between revisions of "Manuals/calci/COMBIN"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''COMBIN( | + | <div style="font-size:30px">'''COMBIN(number,Numberchosen)'''</div><br/> |
| − | *<math> | + | *<math>Number</math> is the number of items. |
| − | *<math> | + | *<math>Numberchosen</math> is the number of items in each arrangement. |
==Description== | ==Description== | ||
| − | *This function gives the combination of <math> | + | *This function gives the combination of <math>Number</math> objects. |
| − | *i.e An arrangement of <math> | + | *i.e An arrangement of <math>Numberchosen</math> objects without any repetition, selected from <math>Number</math> different objects is called a combination of <math>Number</math> objects taken <math>Numberchosen</math> at a time. |
*If the order is not a matter, it is a Combination. | *If the order is not a matter, it is a Combination. | ||
*If the order is a matter it is a Permutation. | *If the order is a matter it is a Permutation. | ||
| + | *Let Number be "n" and Number chosen be "r". | ||
*A combination is denoted by nCr or <math>\binom{n}{r}</math>. | *A combination is denoted by nCr or <math>\binom{n}{r}</math>. | ||
*A formula for the number of possible combinations of <math>r</math> objects from a set of <math>n</math> objects is: | *A formula for the number of possible combinations of <math>r</math> objects from a set of <math>n</math> objects is: | ||
| Line 23: | Line 24: | ||
==ZOS Section== | ==ZOS Section== | ||
{{#ev:youtube|4AQx4Hnctcw|400|right|Combination}} | {{#ev:youtube|4AQx4Hnctcw|400|right|Combination}} | ||
| − | *The | + | *The syntax is to calculate COMBIN in ZOS is COMBIN(Number,Numberchoen) |
**<math>n</math> is the number of items. | **<math>n</math> is the number of items. | ||
**<math>r</math> is the number of items in each arrangement. | **<math>r</math> is the number of items in each arrangement. | ||
Revision as of 03:06, 9 April 2014
COMBIN(number,Numberchosen)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} is the number of items.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Numberchosen} is the number of items in each arrangement.
Description
- This function gives the combination of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} objects.
- i.e An arrangement of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Numberchosen} objects without any repetition, selected from Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} different objects is called a combination of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} objects taken Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Numberchosen} at a time.
- If the order is not a matter, it is a Combination.
- If the order is a matter it is a Permutation.
- Let Number be "n" and Number chosen be "r".
- A combination is denoted by nCr or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \binom{n}{r}} .
- A formula for the number of possible combinations of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} objects from a set of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} objects is:
where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n!=1*2*3*...*n } & Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r \le n} .
- This function will give Error Result when
- The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} & Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} are non numeric
- The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} & Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r < 0 } or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n < r}
- When we are giving the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} & Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} values in decimals, it will automatically convert into Integers.
- For e.g.
- COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
- COMBIN(5,-2)=NAN, because Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} is negative.
ZOS Section
- The syntax is to calculate COMBIN in ZOS is COMBIN(Number,Numberchoen)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is the number of items.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} is the number of items in each arrangement.
Examples
| COMBIN(n,r) | n | r | RESULT |
|---|---|---|---|
| COMBIN(12,3) | 12 | 3 | 220 |
| COMBIN(4,4) | 4 | 4 | 1 |
| COMBIN(4,0) | 4 | 0 | 1 |