Lab statistics, option 3

Introduction
Initial data
Extract from the rating of the largest Russian companies by sales volume in 2011 (Retail trade (last 25 organizations))
Rank Company Volume of sales, mln. Profit before tax, mln. Reporting Form
388 "Major Auto Center"
14,700.8 24.6 RAS
375 "Amway"
ND 15763.3 management
370 Genser 15976,3 494,1 RAS
328 Supermarket chain "ABC of Taste"
ND 18700 management
323 "OrifleymKosmetiks"
19114.8 -47.5 RAS
319 Company "Holiday"
19503.8 212.4 RAS
318 "Retail-1" (a network of "Maria Ra") 19605.2 1116.5 RAS
289 Supermarket chain "attack"
21662.5 519.8 RAS
271 "EyvonByuti Products Company"
23035.1 2115 RAS
239 Hypermarket chain "Globe"
26878.9 600.1 RAS
232 trading house "TsentrObuv"
27794.8 567 RAS
228 JV "Business Car"
28294 1624.4 RAS
224 Corporation GRINN
28750 2197.5 management
208 Trading Network "Coin"
ND 31900 management
199 "Real-Hypermarket"
33349.5 -118.4 RAS
189 Media-SaturnRussia
ND 35705.7 management
176 "Crocus International"
38868.8 207.4 RAS
165 Holding "Atlant-M"
ND 41621 management
153 Group of companies "Independence"
ND 44548.2 management
152 Chain stores "Sportmaster"
44658.3 5133.5 RAS
146 "Avilon AG"
ND 47689.2 management
129 "Ikea Home"
53142.7 3657.4 RAS
125 "The Seventh Continent" 54229.1 1235.7 RAS
121 "LeruaMerlen East"
55527.8 3870.9 RAS
99 "Euroset" 69371 2762.2 RAS
1. Descriptive statistics - the characteristic state of the industry in 2011
1.1. We calculate the indicators:
1.1.1. Absolute (consolidated): the number of enterprises, total volume of the studied parameters;
1.1.2. The relative indicators of the structure - the proportion of individual enterprises of the studied population in the summary data.
1.2. We construct a series of distribution companies for the studied parameters and their graphs:
1.2.1. Attributive basis (on reporting format).
1.2.2. By quantity - for each of the studied quantitative indicators, in accordance with the original data.
1.2.3. We construct grafikipoluchennyh in the early stages of distribution series. We construct a histogram, polygon and cumulates.
1.3. Conclusions.

2. The most important laws of the studied population
To calculate the studied quantitative traits:
2.1. Averages - the arithmetic mean, median, and mode;
2.2. Absolute and relative performance variations.
2.3. Conclusions.

3. Statistical methods for analysis of the relationship of profits and sales volume
3.1. Statistical methods for the analysis of a relationship of profits and sales volume:
- Plotting of the field correlation.
- Construction of analytical categories.
- Calculation of the linear correlation coefficient.
3.2. Construction of regression equations and theoretical values \u200b\u200bof profit. (The calculation can be carried out using statistical programs and MicrosoftExcel.):
- Dimensioning equations depending on profits from sales. Using packet data analysis "regression" analysis The results are presented in the figure.
- Construct a graph of the theoretical regression line (using the correlation graph of the field).

4. Analysis of the dynamics of the industry
4.1. Plot the dynamic series.
4.2. We calculate performance indicators:
- Absolute increases (chain, basic, secondary);
- Growth rate (chain, basic, secondary);
- Growth rate (chain, basic, medium).
4.3. We give a forecast figure for 2012 and 2013:
4.3.1. using performance indicators (calculated in paragraph 4.2.):
4.3.2. Using analytical smoothing method (The calculation can be carried out using statistical programs and MicrosoftExcel.):