[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
    - BETADIST
    - BETAINV
    - BINOMDIST
    - CHIDIST
    - CHIINV
    - CHITEST
    - CONFIDENCE
    - COVAR
    - CRITBINOM
    - EXPONDIST
    - FDIST
    - FLOOR
    - FTEST
    - GAMMADIST
    - GAMMAINV
    - HYPGEOMDIST
    - LOGINV
    - LOGNORMDIST
    - MODE
    - NEGBINOMDIST
    - NORM.INV
    - NORMDIST
    - NORMSDIST
    - NORMSINV
    - PERCENTILE
    - PERCENTRANK
    - POISSON
    - QUARTILE
    - RANK
    - STDEV
    - STDEVP
    - TDIST
    - TINV
    - TTEST
    - VAR
    - VARP
    - WEIBULL
    - ZTEST
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

NEGBINOMDIST

This function returns the negative binomial distribution.

Syntax

NEGBINOMDIST( x, r, p )

Arguments

This function has these arguments:

Argument	Description
x	An integer representing the number of failures in trials
r	An integer representing the threshold number of successes
p	Probability of success on each trial A number between 0 and 1.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

NEGBINOMDIST(B1,C15,0.335)

NEGBINOMDIST(R1C2,R15C3,0.75)

NEGBINOMDIST(4,13,0.85) gives the result 0.111399299