Distributions

Распределения вероятностей в 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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Consider the generation of random numbers by using add-ins Analysis ToolPak and formulas MS 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.

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.

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