Descriptive statistics

Описательная статистика в 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.

Compute the median and the expectation of a random variable in MS 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.

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.

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

Untitled Document

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

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.

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

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.

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.

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.

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

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