# Descriptive statistics

### Variance and Standard Deviation in EXCEL

Calculate MS EXCEL variance and standard deviation of the sample. Also we calculate the variance of a random variable if its distribution is known.

### Mean value calculation in EXCEL

Compute the median and the expectation of a random variable in MS EXCEL.

### Normal probability plot in EXCEL

the graph check the distribution for normality (Normal Probability Plot) is a graphical method of determining the compliance of sample values to the normal distribution.

### Quartile and Interquartile Range (IRQ) in EXCEL

To calculate the quartiles in MS EXCEL there is a function QUARTILE(). In this article we give the definition of quartiles and learn to compute them for the sample and for a continuous distribution. Also calculate interquartile range.

### Quantile: Definition and How to Calculate for Continuous Distributions in EXCEL

let us Consider the computation of quantiles for some features of the distributions presented in MS EXCEL.

### Calculate Percentiles in EXCEL

Untitled Document

let us Consider the concept of percentile function PERCENTILE.INC(), percentile rank, and construct percentile curve.

### Median in EXCEL

To calculate the median in MS EXCEL there is a function MEDIAN(). In this article we give the definition of median and how to calculate it for the sample and for a given distribution law of a random variable.

### Mode in EXCEL

To calculate the fashion selections in MS EXCEL there is a function MOD(). Calculate a fashion for a given distribution of the random variable.

### Descriptive Statistics in EXCEL

Consider the Descriptive statistics tool, included in the add-in Analysis ToolPak. We calculate the characteristics of the sample: mean, median, mode, variance, standard deviation, etc.

### Histogram in EXCEL

the Histogram is a tool that allows to visually assess the magnitude and nature of the data variation. Create a histogram for a continuous random variable by using built-in tools of MS EXCEL add-ins analysis ToolPak and manually using the function FREQUENCY() and diagrams.

### 2 Variables in one EXCEL Histogram

the Histogram is a tool that allows you to visually assess the magnitude and nature of the scatter of data in the sample. With the help of a diagram MS EXCEL create a two-dimensional histogram for comparison of 2 data sets.

### Box Plot and Whisker Сhart in EXCEL

Block diagram (plots, a box with a mustache) is a clear and compact way to represent the distribution of data in the sample.

### Use the Rank and Percentile Tool from the Analysis ToolPak in Excel

Consider a tool Rank and Percentile add-in analysis Package.