Difference between revisions of "Manuals/calci/PASCALTRIANGLE"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
==Description== | ==Description== | ||
*This function gives the Coefficients of the Pascal triangle. | *This function gives the Coefficients of the Pascal triangle. | ||
− | *In <math>PASCALTRIANGLE(r)</math> , r is the row number of the Pascal triangle. | + | *In <math>PASCALTRIANGLE(r)</math> , <math>r</math> is the row number of the Pascal triangle. |
*Pascal triangle is the arrangement of numbers of the Binomial coefficients in a triangular shape. | *Pascal triangle is the arrangement of numbers of the Binomial coefficients in a triangular shape. | ||
− | *It is started with the number 1 at the top in the 1st row. | + | *It is started with the number <math>1</math> at the top in the 1st row. |
*Then from the 2nd row each number in the triangle is the sum of the two directly above it. | *Then from the 2nd row each number in the triangle is the sum of the two directly above it. | ||
− | *The construction is related to the | + | *The construction is related to the Binomial Coefficients by Pascal's rule is : |
− | <math>(x+y)^n=\sum_{k=0}^n \binom{n}{k}x^{n-k} .y^k </math>. | + | <math>(x+y)^n=\sum_{k=0}^n \binom{n}{k}x^{n-k} .y^k </math>. |
+ | where <math> \dbinom{n}{k}</math> is the binomial coefficient. | ||
*This function will return the result as error when <math> r \le 0</math>. | *This function will return the result as error when <math> r \le 0</math>. | ||
Revision as of 01:57, 22 January 2014
PASCALTRIANGLE(r)
- is the row number.
Description
- This function gives the Coefficients of the Pascal triangle.
- In , is the row number of the Pascal triangle.
- Pascal triangle is the arrangement of numbers of the Binomial coefficients in a triangular shape.
- It is started with the number at the top in the 1st row.
- Then from the 2nd row each number in the triangle is the sum of the two directly above it.
- The construction is related to the Binomial Coefficients by Pascal's rule is :
. where is the binomial coefficient.
- This function will return the result as error when .
Examples
- 1.=PASCALTRIANGLE(1)
1
- 2.=PASCALTRIANGLE(2)
1 1 1
- 3.=PASCALTRIANGLE(3)
1 1 1 1 2 1
- 4.=PASCALTRIANGLE(0) = NULL