Difference between revisions of "Manuals/calci/PASCALTRIANGLE"

From ZCubes Wiki
Jump to navigation Jump to search
Line 27: Line 27:
  
 
==See Also==
 
==See Also==
*[[Manuals/calci/BINOMIAL | BINOMIAL ]]
+
*[[Manuals/calci/BINOMDIST | BINOMDIST ]]
  
 
==References==
 
==References==
 
*  [http://www.mathsisfun.com/pascals-triangle.html Pascal's Triangle  ]
 
*  [http://www.mathsisfun.com/pascals-triangle.html Pascal's Triangle  ]

Revision as of 00:15, 8 January 2014

PASCALTRIANGLE(r)


  • is the row number.

Description

  • This function gives the Coefficients of the Pascal triangle.
  • In , r 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 1 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 the .

Examples

  • 1.=PASCALTRIANGLE(1)
                 1
  • 2.=PASCALTRIANGLE(2)
                 1   
                 1       1
  • 3.=PASCALTRIANGLE(3)
                 1    
                 1       1
                 1       2         1

  • 4.=PASCALTRIANGLE(0) = NULL

See Also

References