Calculate speed. Calculating Standard Deviation in Microsoft Excel

11.10.2019

$X$. First, let's recall the following definition:

Definition 1

Population-- a set of randomly selected objects of a given type, over which observations are carried out in order to obtain specific values ​​of a random variable, carried out under unchanged conditions when studying one random variable of a given type.

Definition 2

General variance-- the arithmetic mean of the squared deviations of the values ​​of the variant of the general population from their mean value.

Let the values ​​of the variant $x_1,\ x_2,\dots ,x_k$ have, respectively, the frequencies $n_1,\ n_2,\dots ,n_k$. Then the general variance is calculated by the formula:

Let's consider a special case. Let all variants $x_1,\ x_2,\dots ,x_k$ be distinct. In this case $n_1,\ n_2,\dots ,n_k=1$. We get that in this case the general variance is calculated by the formula:

Also related to this concept is the concept of the general standard deviation.

Definition 3

General standard deviation

\[(\sigma )_r=\sqrt(D_r)\]

Sample variance

Let us be given a sample set with respect to a random variable $X$. First, let's recall the following definition:

Definition 4

Sample population-- part of the selected objects from the general population.

Definition 5

Sample variance-- the arithmetic mean of the values ​​of the variant of the sample population.

Let the values ​​of the variant $x_1,\ x_2,\dots ,x_k$ have, respectively, the frequencies $n_1,\ n_2,\dots ,n_k$. Then the sample variance is calculated by the formula:

Let's consider a special case. Let all variants $x_1,\ x_2,\dots ,x_k$ be distinct. In this case $n_1,\ n_2,\dots ,n_k=1$. We get that in this case, the sample variance is calculated by the formula:

Also related to this concept is the concept of sample standard deviation.

Definition 6

Sample standard deviation-- square root of the general variance:

\[(\sigma )_v=\sqrt(D_v)\]

Corrected variance

To find the corrected variance $S^2$, it is necessary to multiply the sample variance by the fraction $\frac(n)(n-1)$, i.e.

This concept is also associated with the concept of the corrected standard deviation, which is found by the formula:

In the case when the value of the variant is not discrete, but represents intervals, then in the formulas for calculating the general or sample variances, the value of $x_i$ is taken to be the value of the middle of the interval to which $x_i.$ belongs

An example of a problem for finding the variance and standard deviation

Example 1

The sample population is given by the following distribution table:

Picture 1.

Find for it the sample variance, the sample standard deviation, the corrected variance, and the corrected standard deviation.

To solve this problem, first we will make a calculation table:

Figure 2.

The value of $\overline(x_v)$ (sample average) in the table is found by the formula:

\[\overline(x_in)=\frac(\sum\limits^k_(i=1)(x_in_i))(n)\]

\[\overline(x_in)=\frac(\sum\limits^k_(i=1)(x_in_i))(n)=\frac(305)(20)=15.25\]

Find the sample variance using the formula:

Sample standard deviation:

\[(\sigma )_v=\sqrt(D_v)\approx 5,12\]

Corrected variance:

\[(S^2=\frac(n)(n-1)D)_v=\frac(20)(19)\cdot 26.1875\approx 27.57\]

Corrected standard deviation.

In this article, I will talk about how to find standard deviation. This material is extremely important for a full understanding of mathematics, so a math tutor should devote a separate lesson or even several to studying it. In this article, you will find a link to a detailed and understandable video tutorial that explains what the standard deviation is and how to find it.

standard deviation makes it possible to estimate the spread of values ​​obtained as a result of measuring a certain parameter. It is denoted by a symbol (Greek letter "sigma").

The formula for the calculation is quite simple. To find the standard deviation, you need to take the square root of the variance. So now you have to ask, “What is variance?”

What is dispersion

The definition of variance is as follows. Dispersion is the arithmetic mean of the squared deviations of values ​​from the mean.

To find the variance, perform the following calculations sequentially:

  • Determine the mean (simple arithmetic mean of a series of values).
  • Then subtract the average from each of the values ​​​​and square the resulting difference (we got difference squared).
  • The next step is to calculate the arithmetic mean of the squares of the differences obtained (You can find out why exactly the squares are below).

Let's look at an example. Let's say you and your friends decide to measure the height of your dogs (in millimeters). As a result of measurements, you received the following height measurements (at the withers): 600 mm, 470 mm, 170 mm, 430 mm and 300 mm.

Let's calculate the mean, variance and standard deviation.

Let's find the average first. As you already know, for this you need to add all the measured values ​​\u200b\u200band divide by the number of measurements. Calculation progress:

Average mm.

So, the average (arithmetic mean) is 394 mm.

Now we need to define deviation of the height of each of the dogs from the average:

Finally, to calculate the variance, each of the obtained differences is squared, and then we find the arithmetic mean of the results obtained:

Dispersion mm 2 .

Thus, the dispersion is 21704 mm 2 .

How to find the standard deviation

So how now to calculate the standard deviation, knowing the variance? As we remember, take the square root of it. That is, the standard deviation is:

mm (rounded to the nearest whole number in mm).

Using this method, we found that some dogs (eg Rottweilers) are very large dogs. But there are also very small dogs (for example, dachshunds, but you should not tell them this).

The most interesting thing is that the standard deviation carries useful information. Now we can show which of the obtained results of measuring growth are within the interval that we get if we set aside from the average (on both sides of it) the standard deviation.

That is, using the standard deviation, we get a “standard” method that allows you to find out which of the values ​​is normal (statistical average), and which is extraordinarily large or, conversely, small.

What is Standard Deviation

But ... things will be a little different if we analyze sampling data. In our example, we considered the general population. That is, our 5 dogs were the only dogs in the world that interested us.

But if the data is a sample (values ​​chosen from a large population), then the calculations need to be done differently.

If there are values, then:

All other calculations are made in the same way, including the determination of the average.

For example, if our five dogs are just a sample of a population of dogs (all dogs on the planet), we must divide by 4 instead of 5 namely:

Sample variance = mm 2 .

In this case, the standard deviation for the sample is equal to mm (rounded to the nearest whole number).

We can say that we made some "correction" in the case when our values ​​are just a small sample.

Note. Why exactly the squares of the differences?

But why do we take the squares of the differences when calculating the variance? Let's admit at measurement of some parameter, you received the following set of values: 4; 4; -4; -4. If we just add the absolute deviations from the mean (difference) among themselves ... negative values ​​cancel out with positive ones:

.

It turns out that this option is useless. Then maybe it's worth trying the absolute values ​​of the deviations (that is, the modules of these values)?

At first glance, it turns out not bad (the resulting value, by the way, is called the mean absolute deviation), but not in all cases. Let's try another example. Let the measurement result in the following set of values: 7; 1; -6; -2. Then the mean absolute deviation is:

Wow! We again got the result 4, although the differences have a much larger spread.

Now let's see what happens if we square the differences (and then take the square root of their sum).

For the first example, you get:

.

For the second example, you get:

Now it's a completely different matter! The root-mean-square deviation is the greater, the greater the spread of the differences ... which is what we were striving for.

In fact, this method uses the same idea as when calculating the distance between points, only applied in a different way.

And from a mathematical point of view, the use of squares and square roots is more useful than we could get on the basis of the absolute values ​​​​of the deviations, due to which the standard deviation is applicable to other mathematical problems.

Sergey Valerievich told you how to find the standard deviation

Standard deviation is a classic indicator of variability from descriptive statistics.

Standard deviation, standard deviation, RMS, sample standard deviation (English standard deviation, STD, STDev) is a very common measure of dispersion in descriptive statistics. But, because technical analysis is akin to statistics, this indicator can (and should) be used in technical analysis to detect the degree of dispersion of the price of the analyzed instrument over time. Denoted by the Greek symbol Sigma "σ".

Thanks to Karl Gauss and Pearson for the fact that we have the opportunity to use the standard deviation.

Using standard deviation in technical analysis, we turn this "scattering index" V "volatility indicator“Keeping the meaning but changing the terms.

What is Standard Deviation

But in addition to intermediate auxiliary calculations, standard deviation is quite acceptable for self-calculation and applications in technical analysis. As noted by an active reader of our magazine burdock, “ I still don’t understand why RMS is not included in the set of standard indicators of domestic dealing centers«.

Really, standard deviation can in a classical and "pure" way measure the variability of an instrument. But unfortunately, this indicator is not so common in securities analysis.

Applying the Standard Deviation

Manually calculating the standard deviation is not very interesting. but useful for experience. The standard deviation can be expressed formula STD=√[(∑(x-x ) 2)/n] , which sounds like the root sum of the squared differences between the sample items and the mean, divided by the number of items in the sample.

If the number of elements in the sample exceeds 30, then the denominator of the fraction under the root takes on the value n-1. Otherwise, n is used.

step by step standard deviation calculation:

  1. calculate the arithmetic mean of the data sample
  2. subtract this average from each element of the sample
  3. all the resulting differences are squared
  4. sum all the resulting squares
  5. divide the resulting sum by the number of elements in the sample (or by n-1 if n>30)
  6. calculate the square root of the resulting quotient (called dispersion)

Lesson number 4

Topic: “Descriptive statistics. Indicators of the diversity of the trait in the aggregate "

The main criteria for the diversity of a trait in the statistical population are: limit, amplitude, standard deviation, oscillation coefficient and coefficient of variation. In the previous lesson, it was discussed that the average values ​​give only a generalizing characteristic of the studied trait in the aggregate and do not take into account the values ​​of its individual variants: the minimum and maximum values, above the average, below the average, etc.

Example. Average values ​​of two different numerical sequences: -100; -20; 100; 20 and 0.1; -0.2; 0.1 are exactly the same and equalABOUT.However, the data scatter ranges of these relative mean sequences are very different.

The definition of the listed criteria for the diversity of a trait is primarily carried out taking into account its value for individual elements of the statistical population.

Indicators of measuring the variation of a trait are absolute And relative. The absolute indicators of variation include: the range of variation, limit, standard deviation, variance. The coefficient of variation and the coefficient of oscillation refer to relative measures of variation.

Limit (lim)– this is a criterion that is determined by the extreme values ​​of the variant in the variation series. In other words, this criterion is limited by the minimum and maximum values ​​of the attribute:

Amplitude (Am) or range of variation - this is the difference between the extremes. The calculation of this criterion is carried out by subtracting its minimum value from the maximum value of the attribute, which makes it possible to estimate the degree of dispersion of the variant:

The disadvantage of the limit and amplitude as criteria for variability is that they completely depend on the extreme values ​​of the trait in the variation series. In this case, fluctuations in the values ​​of the attribute within the series are not taken into account.

The most complete characterization of the diversity of a trait in a statistical population is given by standard deviation(sigma), which is a general measure of the deviation of a variant from its mean value. The standard deviation is also often referred to as standard deviation.

The basis of the standard deviation is the comparison of each option with the arithmetic mean of this population. Since in the aggregate there will always be options both less and more than it, then the sum of the deviations having the sign "" will be repaid by the sum of the deviations having the sign "", i.e. the sum of all deviations is zero. In order to avoid the influence of the signs of the differences, the deviations of the variant from the arithmetic mean squared are taken, i.e. . The sum of squared deviations is not equal to zero. To obtain a coefficient capable of measuring variability, take the average of the sum of squares - this value is called dispersion:

By definition, variance is the mean square of the deviations of the individual values ​​of a feature from its mean value. Dispersion squared standard deviation .

Dispersion is a dimensional quantity (named). So, if the variants of the number series are expressed in meters, then the dispersion gives square meters; if the variants are expressed in kilograms, then the variance gives the square of this measure (kg 2), and so on.

Standard deviation is the square root of the variance:

, then when calculating the variance and standard deviation in the denominator of the fraction, instead ofit is necessary to put.

The calculation of the standard deviation can be divided into six stages, which must be carried out in a certain sequence:

Applying standard deviation:

a) to judge the fluctuation of variational series and a comparative assessment of the typicality (representativeness) of arithmetic means. This is necessary in differential diagnosis when determining the stability of signs.

b) for the reconstruction of the variational series, i.e. restoring its frequency response based on three sigma rules. In the interval (М±3σ) there is 99.7% of all variants of the series, in the interval (М±2σ) - 95.5% and in the interval (М±1σ) - 68.3% row option(Fig. 1).

c) to identify "pop-up" options

d) to determine the parameters of the norm and pathology using sigma estimates

e) to calculate the coefficient of variation

e) to calculate the average error of the arithmetic mean.

To characterize any general population that hasnormal distribution type , it is enough to know two parameters: the arithmetic mean and the standard deviation.

Figure 1. Three Sigma Rule

Example.

In pediatrics, the standard deviation is used to assess the physical development of children by comparing the data of a particular child with the corresponding standard indicators. The arithmetic mean indicators of the physical development of healthy children are taken as the standard. Comparison of indicators with standards is carried out according to special tables, in which the standards are given along with their corresponding sigma scales. It is believed that if the indicator of the physical development of the child is within the standard (arithmetic mean) ±σ, then the physical development of the child (according to this indicator) corresponds to the norm. If the indicator is within the standard ±2σ, then there is a slight deviation from the norm. If the indicator goes beyond these limits, then the physical development of the child differs sharply from the norm (pathology is possible).

In addition to variation indicators expressed in absolute values, statistical research uses variation indicators expressed in relative values. Oscillation coefficient - this is the ratio of the range of variation to the average value of the trait. The coefficient of variation - this is the ratio of the standard deviation to the average value of the feature. Typically, these values ​​are expressed as a percentage.

Formulas for calculating the relative indicators of variation:

From the above formulas it can be seen that the larger the coefficient V close to zero, the smaller the variation of the trait values. The more V, the more variable the sign.

In statistical practice, the coefficient of variation is most often used. It is used not only for a comparative assessment of variation, but also to characterize the homogeneity of the population. The set is considered homogeneous if the coefficient of variation does not exceed 33% (for distributions close to normal). Arithmetically, the ratio of σ and the arithmetic mean eliminates the influence of the absolute value of these characteristics, and the percentage ratio makes the coefficient of variation a dimensionless (unnamed) value.

The obtained value of the coefficient of variation is estimated in accordance with the approximate gradations of the degree of diversity of the trait:

Weak - up to 10%

Average - 10 - 20%

Strong - more than 20%

The use of the coefficient of variation is advisable in cases where it is necessary to compare features that are different in size and dimension.

The difference between the coefficient of variation and other scatter criteria is clearly demonstrated by example.

Table 1

Composition of employees of an industrial enterprise

Based on the statistical characteristics given in the example, it can be concluded that the age composition and educational level of the enterprise's employees are relatively homogeneous, with low professional stability of the surveyed contingent. It is easy to see that an attempt to judge these social trends by the standard deviation would lead to an erroneous conclusion, and an attempt to compare the accounting features "work experience" and "age" with the accounting feature "education" would generally be incorrect due to the heterogeneity of these features.

Median and Percentiles

For ordinal (rank) distributions, where the criterion for the middle of the series is the median, the standard deviation and variance cannot serve as characteristics of the dispersion of the variant.

The same is true for open variational series. This circumstance is due to the fact that the deviations by which the variance and σ are calculated are counted from the arithmetic mean, which is not calculated in open variational series and in the series of distributions of qualitative features. Therefore, for a compressed description of distributions, another scatter parameter is used - quantile(synonym - "percentile"), suitable for describing qualitative and quantitative characteristics in any form of their distribution. This parameter can also be used to convert quantitative features into qualitative ones. In this case, such scores are assigned depending on which order of the quantile corresponds to one or another specific option.

In the practice of biomedical research, the following quantiles are most often used:

– median;

, are quartiles (quarters), where is the lower quartile, top quartile.

Quantiles divide the area of ​​possible changes in a variational series into certain intervals. The median (quantile) is the variant that is in the middle of the variation series and divides this series in half, into two equal parts ( 0,5 And 0,5 ). The quartile divides the series into four parts: the first part (lower quartile) is the option separating options whose numerical values ​​do not exceed 25% of the maximum possible in this series, the quartile separates options with a numerical value up to 50% of the maximum possible. The upper quartile () separates options up to 75% of the maximum possible values.

In case of asymmetric distribution variable relative to the arithmetic mean, the median and quartiles are used to characterize it. In this case, the following form of displaying the average value is used - Me (;). For example, the trait under study - "the period in which the child began to walk independently" - in the study group has an asymmetric distribution. At the same time, the lower quartile () corresponds to the start of walking - 9.5 months, the median - 11 months, the upper quartile () - 12 months. Accordingly, the characteristic of the average trend of the specified attribute will be presented as 11 (9.5; 12) months.

Assessment of the statistical significance of the study results

The statistical significance of the data is understood as the degree of their correspondence to the displayed reality, i.e. Statistically significant data are those that do not distort and correctly reflect objective reality.

To assess the statistical significance of the results of a study means to determine with what probability it is possible to transfer the results obtained on a sample population to the entire population. An assessment of statistical significance is necessary to understand how part of the phenomenon can be used to judge the phenomenon as a whole and its patterns.

The assessment of the statistical significance of the results of the study consists of:

1. errors of representativeness (errors of average and relative values) - m;

2. confidence limits of average or relative values;

3. reliability of the difference between average or relative values ​​according to the criterion t.

Standard error of the arithmetic mean or representativeness error characterizes fluctuations in the average. It should be noted that the larger the sample size, the smaller the spread of the average values. The standard error of the mean is calculated by the formula:

In modern scientific literature, the arithmetic mean is written together with the representativeness error:

or together with standard deviation:

As an example, consider data for 1,500 urban polyclinics in the country (general population). The average number of patients served in the polyclinic is 18150 people. Random selection of 10% of objects (150 polyclinics) gives an average number of patients equal to 20051 people. The sampling error, obviously related to the fact that not all 1500 polyclinics were included in the sample, is equal to the difference between these averages - the general average ( M gene) and sample mean ( M sb). If we form another sample of the same size from our population, it will give a different amount of error. All these sample means, with sufficiently large samples, are normally distributed around the general mean with a sufficiently large number of repetitions of a sample of the same number of objects from the general population. Standard error of the mean m is the inevitable spread of the sample means around the general mean.

In the case when the results of the study are represented by relative values ​​(for example, percentages), the share standard error:

where P is the indicator in %, n is the number of observations.

The result is displayed as (P ± m)%. For example, the percentage of recovery among patients was (95.2±2.5)%.

If the number of elements in the population, then when calculating the standard errors of the mean and the share in the denominator of the fraction, instead ofit is necessary to put.

For a normal distribution (the distribution of sample means is normal), it is known how much of the population falls within any interval around the mean. In particular:

In practice, the problem lies in the fact that the characteristics of the general population are unknown to us, and the sample is made precisely for the purpose of assessing them. This means that if we take samples of the same size n from the general population, then in 68.3% of cases the interval will contain the value M(it will be on the interval in 95.5% of cases and on the interval in 99.7% of cases).

Since only one sample is actually made, this statement is formulated in terms of probability: with a probability of 68.3%, the average value of the attribute in the general population is contained in the interval, with a probability of 95.5% - in the interval, etc.

In practice, such an interval is built around the sample value, which would, with a given (high enough) probability - confidence probability - would “cover” the true value of this parameter in the general population. This interval is called confidence interval.

Confidence probabilityP is the degree of confidence that the confidence interval will indeed contain the true (unknown) value of the parameter in the population.

For example, if the confidence level R equal to 90%, this means that 90 samples out of 100 will give a correct estimate of the parameter in the general population. Accordingly, the probability of error, i.e. incorrect estimate of the general average for the sample, is equal in percentage: . For this example, this means that 10 samples out of 100 will give an incorrect estimate.

Obviously, the degree of confidence (confidence probability) depends on the size of the interval: the wider the interval, the higher the confidence that an unknown value for the general population will fall into it. In practice, at least twice the sampling error is taken to construct a confidence interval to provide at least 95.5% confidence.

Determining the confidence limits of average and relative values ​​allows us to find their two extreme values ​​- the minimum possible and the maximum possible, within which the indicator under study can occur in the entire general population. Based on this, confidence limits (or confidence interval)- these are the boundaries of average or relative values, going beyond which due to random fluctuations has an insignificant probability.

The confidence interval can be rewritten as: , where t is a confidence criterion.

The confidence limits of the arithmetic mean in the general population are determined by the formula:

M gene = M select + tm M

for relative value:

R gene = P select + tm R

Where M gene And R gene- values ​​of the average and relative values ​​for the general population; M select And R select- the values ​​of the average and relative values ​​obtained on the sample population; m M And m P- errors of average and relative values; t- confidence criterion (accuracy criterion, which is set when planning the study and can be equal to 2 or 3); tm- this is the confidence interval or Δ - the marginal error of the indicator obtained in the sample study.

It should be noted that the value of the criterion t to a certain extent, it is related to the probability of an error-free forecast (p), expressed in%. It is chosen by the researcher himself, guided by the need to obtain a result with the required degree of accuracy. So, for the probability of an error-free forecast of 95.5%, the value of the criterion t is 2, for 99.7% - 3.

The given estimates of the confidence interval are acceptable only for statistical populations with more than 30 observations. With a smaller population size (small samples), special tables are used to determine the criterion t. In these tables, the desired value is at the intersection of the line corresponding to the size of the population (n-1), and a column corresponding to the level of probability of an error-free forecast (95.5%; 99.7%) chosen by the researcher. In medical research, when establishing confidence limits for any indicator, the probability of an error-free forecast is 95.5% or more. This means that the value of the indicator obtained on the sample population must be found in the general population in at least 95.5% of cases.

    Questions on the topic of the lesson:

    The relevance of indicators of the diversity of a trait in the statistical population.

    General characteristics of the absolute indicators of variation.

    Standard deviation, calculation, application.

    Relative indicators of variation.

    Median, quartile score.

    Evaluation of the statistical significance of the results of the study.

    Standard error of the arithmetic mean, calculation formula, example of use.

    Calculation of the share and its standard error.

    The concept of confidence probability, an example of use.

10. The concept of confidence interval, its application.

    Test tasks on the topic with sample answers:

1. ABSOLUTE INDICATORS OF VARIATION ARE

1) coefficient of variation

2) oscillation coefficient

4) median

2. RELATIVE INDICATORS OF VARIATION ARE

1) dispersion

4) coefficient of variation

3. A CRITERION DETERMINED BY THE EXTREME VALUES OF A VARIANT IN A VARIATIONAL SERIES

2) amplitude

3) dispersion

4) coefficient of variation

4. THE DIFFERENCE OF THE EXTREME OPTION IS

2) amplitude

3) standard deviation

4) coefficient of variation

5. MEAN SQUARE OF DEVIATIONS OF INDIVIDUAL SIGNIFICANT VALUES FROM ITS AVERAGE VALUE IS

1) oscillation coefficient

2) median

3) dispersion

6. RATIO OF THE RANGE OF VARIATION TO THE AVERAGE VALUE OF A FEATURE IS

1) coefficient of variation

2) standard deviation

4) oscillation coefficient

7. RATIO OF THE MEAN SQUARE DEVIATION TO THE AVERAGE VALUE OF A FEATURE IS

1) dispersion

2) coefficient of variation

3) oscillation coefficient

4) amplitude

8. A VARIANT THAT IS IN THE MIDDLE OF A VARIATION SERIES AND DIVIDES IT INTO TWO EQUAL PARTS IS

1) median

3) amplitude

9. IN MEDICAL RESEARCH, WHEN ESTABLISHING CONFIDENCE LIMITS OF ANY INDICATOR, THE PROBABILITY OF AN ERROR-FREE PREDICTION IS ACCEPTED

10. IF 90 SAMPLES OUT OF 100 GIVE A CORRECT ESTIMATE OF A PARAMETER IN A GENERAL POPULATION, THEN THIS MEANS THAT THE CONFIDENCE PROBABILITY P EQUAL

11. IN THE EVENT IF 10 SAMPLES OUT OF 100 GIVE AN INCORRECT ESTIMATE, THE PROBABILITY OF ERROR IS

12. THE LIMITS OF AVERAGE OR RELATIVE VALUES, THERE IS A MINOR PROBABILITY TO GO BEYOND THE LIMITS OF WHICH

1) confidence interval

2) amplitude

4) coefficient of variation

13. A SMALL SAMPLE IS CONSIDERED THAT POPULATION IN WHICH

1) n is less than or equal to 100

2) n is less than or equal to 30

3) n is less than or equal to 40

4) n is close to 0

14. FOR THE PROBABILITY OF ERROR-FREE FORECAST 95% CRITERION VALUE t COMPOSES

15. FOR THE PROBABILITY OF ERROR-FREE FORECAST 99% CRITERION VALUE t COMPOSES

16. FOR DISTRIBUTIONS CLOSE TO NORMAL, THE POPULATION IS CONSIDERED HOMOGENEOUS IF THE COEFFICIENT OF VARIATION DOES NOT EXCEED

17. OPTION SEPARATING VARIANTS WHICH NUMERICAL VALUES DO NOT EXCEED 25% OF THE MAXIMUM POSSIBLE IN THIS ROW IS

2) lower quartile

3) upper quartile

4) quartile

18. DATA THAT DO NOT DISTORT AND CORRECTLY REFLECT OBJECTIVE REALITY IS CALLED

1) impossible

2) equally possible

3) reliable

4) random

19. ACCORDING TO THE THREE-SIGM RULE, WITH A NORMAL DISTRIBUTION OF A SIGN WITHIN
WILL BE LOCATED

1) 68.3% option

An approximate method for assessing the fluctuation of a variational series is the determination of the limit and amplitude, however, the values ​​​​of the variant within the series are not taken into account. The main generally accepted measure of the fluctuation of a quantitative trait within the range of variations is standard deviation (σ - sigma). The larger the standard deviation, the higher the degree of fluctuation of this series.

The method for calculating the standard deviation includes the following steps:

1. Find the arithmetic mean (M).

2. Determine the deviations of individual options from the arithmetic mean (d=V-M). In medical statistics, deviations from the mean are denoted as d (deviate). The sum of all deviations is equal to zero.

3. Square each deviation d 2 .

4. Multiply the squared deviations by the corresponding frequencies d 2 *p.

5. Find the sum of products å(d 2 *p)

6. Calculate the standard deviation by the formula:

When n is greater than 30, or when n is less than or equal to 30, where n is the number of all options.

The value of the standard deviation:

1. The standard deviation characterizes the spread of the variant relative to the average value (i.e., the fluctuation of the variation series). The larger the sigma, the higher the degree of diversity of this series.

2. The standard deviation is used for a comparative assessment of the degree of compliance of the arithmetic mean with the variation series for which it was calculated.

Variations of mass phenomena obey the law of normal distribution. The curve representing this distribution has the form of a smooth bell-shaped symmetrical curve (Gaussian curve). According to the theory of probability in phenomena that obey the law of normal distribution, there is a strict mathematical relationship between the values ​​of the arithmetic mean and the standard deviation. The theoretical distribution of a variant in a homogeneous variation series obeys the three sigma rule.

If in the system of rectangular coordinates on the abscissa axis the values ​​of the quantitative trait (options) are plotted, and on the ordinate axis - the frequency of occurrence of the variant in the variation series, then variants with larger and smaller values ​​are evenly located on the sides of the arithmetic mean.



It has been established that with a normal distribution of the trait:

68.3% of the variant values ​​are within М±1s

95.5% of the variant values ​​are within M±2s

99.7% of the variant values ​​are within M±3s

3. The standard deviation allows you to set the normal values ​​for clinical and biological parameters. In medicine, the M ± 1s interval is usually taken outside the normal range for the phenomenon under study. The deviation of the estimated value from the arithmetic mean by more than 1s indicates the deviation of the studied parameter from the norm.

4. In medicine, the three-sigma rule is used in pediatrics for individual assessment of the level of physical development of children (method of sigma deviations), for the development of standards for children's clothing

5. The standard deviation is necessary to characterize the degree of diversity of the trait under study and calculate the error of the arithmetic mean.

The value of the standard deviation is usually used to compare the fluctuation of the same type of series. If two rows with different characteristics are compared (height and weight, average duration of hospital stay and hospital mortality, etc.), then a direct comparison of sigma sizes is impossible. , because standard deviation - a named value, expressed in absolute numbers. In these cases, apply coefficient of variation (Cv), which is a relative value: the percentage of the standard deviation to the arithmetic mean.

The coefficient of variation is calculated by the formula:

The higher the coefficient of variation , the greater the variability of this series. It is believed that the coefficient of variation over 30% indicates the qualitative heterogeneity of the population.



Similar articles