# Distributions ### Cumulative distribution function and probability density function in MS EXCEL

the definition of the distribution Function of a random variable and probability Density continuous random variable. These concepts are widely used in articles about the site's statistics ]]>www.excel-in-practice.com]]>. Examples of calculation of distribution Function and probability Density with the help of the MS EXCEL.

### Generate a Random Sample Using Excel

Tool in the analysis ToolPak of MS EXCEL Sample retrieves a random sample of the input range, treating it as a population. Also a random sample can be extracted using formulas.

### Probability distributions in EXCEL

the article presents a list of probability distributions available in MS EXCEL 2010 and earlier versions.  links to the articles describing the respective functions of MS EXCEL.

### Several relationships among probability distributions in EXCEL

Рассмотрим взаимосвязь Биномиального распределения, распределения Пуассона, Нормального распределения и Гипергеометрического распределения. Определим условия, когда возможна аппроксимация одного распределения другим, приведем примеры и графики.

### Fisher distribution (F-distribution) in EXCEL

Consider the Fisher distribution (F-distribution). Using the function MS EXCEL F.DIS() construct graphs of the distribution function and probability density, explain the use of that distribution for purposes of mathematical statistics.

### Chi-squared distribution in EXCEL

Consider the Distribution of CHI-square. Using MS EXCEL functions ХИ2.DIS() construct graphs of the distribution function and probability density, explain the use of that distribution for purposes of mathematical statistics.

### Student's t-distribution in EXCEL

Consider the student Distribution (t-distribution). Using MS EXCEL functions STUDENT.DIS() construct graphs of the distribution function and probability density explain the use of that distribution for purposes of mathematical statistics.

### Beta Distribution. Сontinuous Distributions in EXCEL

let's Consider a Beta distribution, compute its mathematical expectation, variance, mode. Using function MS EXCEL BETA.DIS() construct graphs of the distribution function and probability density. Generate array of random numbers and make an assessment of the distribution parameters.

### Weibull Distribution. Continuous Probability Distributions in EXCEL

Consider the Weibull distribution, compute its mathematical expectation, variance, median. By using MS EXCEL WEIBULL.DIS() construct graphs of the distribution function and probability density. Generate array of random numbers and make an assessment of the distribution parameters.

### Gamma Distribution. Continuous Probability Distributions in EXCEL

Consider the Gamma distribution, we compute its expectation, variance, mode. Using function MS EXCEL GAMMA.DIS() construct graphs of the distribution function and probability density. Generate array of random numbers and make an assessment of the distribution parameters.

### Exponential Distribution. Continuous Probability Distributions in EXCEL

Consider the Exponential distribution, compute its mathematical expectation, variance, median. By using MS EXCEL EXP.DIS() construct graphs of the distribution function and probability density. Generate array of random numbers to produce the estimate of the parameter of the distribution.

### Lognormal Distribution. Continuous Probability Distributions in EXCEL

Consider the Lognormal distribution. By using MS EXCEL LOGNORM.DIS() construct graphs of the distribution function and probability density. Generate an array of random numbers distributed according to the law to obey the lognormal distribution, we perform the evaluation of the distribution parameters, mean and standard deviation.

### Normal Distribution. Continuous Probability Distributions in EXCEL

Consider the Normal distribution. Using the function MS EXCEL RULES.DIS() construct graphs of the distribution function and probability density. Generate an array of random numbers distributed according to the normal law, let's make an assessment of the distribution parameters, mean and standard deviation.

### Hypergeometric Distribution. Discrete Probability Distributions in EXCEL

Consider the Hypergeometric distribution, we compute its expectation, variance, mode. Using the function MS EXCEL HYPERGEO.DIS() construct graphs of the distribution function and probability density. Here is an example of a hypergeometric approximation of the binomial distribution.

### Negative Binomial Distribution. Discrete Probability Distribution in EXCEL

let us Consider the Negative Binomial distribution, compute its mathematical expectation and variance. Using function MS  EXCEL URBINA.DIS() construct graphs of the distribution function and probability density.

### Poisson Distribution. Discrete Probability Distributions in EXCEL

let us Consider the Poisson distribution, compute its mathematical expectation, variance, mode. By using MS EXCEL POISSON.DIS() construct graphs of the distribution function and probability density. Let's make an assessment of the parameter of the distribution, its mathematical expectation and standard deviation.

### Binomial Distribution. Discrete Distributions in EXCEL

Consider the Binomial distribution, compute its mathematical expectation, variance, mode. By using MS EXCEL BINOM.DIS() construct graphs of the distribution function and probability density. Let's make an assessment of the distribution parameter p, the mathematical expectation of the distribution and standard deviation. Also, consider the Bernoulli distribution.

### Discrete Uniform Distribution in EXCEL

Consider the discrete Uniform distribution, we construct a graph of the distribution function, calculate mean and variance. Generate random values (the sample) by using MS EXCEL RANDBETWEEN(). On the basis of sampling rate the mean and standard deviation of the distribution.

### Generating Discrete Random Variable with given Probability Function in EXCEL

Consider the generation of random numbers by using add-ins Analysis ToolPak and formulas MS EXCEL.

### Continuous Uniform Distribution in EXCEL

Consider the uniform continuous distribution. Calculate mathematical expectation and variance. Generate random values using the function in MS EXCEL Rand() and add-ins Analysis ToolPak, perform the estimate of the average value and standard deviation.

### Geometric Distribution. Discrete Probability Distributions in EXCEL

Consider the Geometric distribution, we calculate its expectation and variance. Using function MS EXCEL URBINA.DIS() construct graphs of the distribution function and probability density.

### Generating Random Variable with given Descrete Probability Function in EXCEL

Set arbitrary distribution function of discrete random variable. Generate a random number from that of the General population. Also consider the function LIKELIHOOD().