|
|
Дипломная работа: Разработка системы учета и прогнозирования ежедневных поступлений страховых взносов на обязательное пенсионное страхование
Для проведения расчетов,
данные целесообразно расположить в виде таблицы
Таблица 1.3 - Преобразованные данные
|
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
|
1
|
|
y
|
x
|
x2
|
xy
|
x3
|
x4
|
x2y
|
ln(y)
|
x*ln(y)
|
|
2
|
1 |
3,83E+07 |
2,68E+07 |
1,47E+15 |
1,03E+15 |
5,62E+22 |
2,15E+30 |
5,62E+22 |
17,46 |
6,69E+08 |
|
3
|
2 |
2,79E+07 |
1,57E+07 |
7,78E+14 |
4,37E+14 |
2,17E+22 |
6,06E+29 |
2,17E+22 |
17,14 |
4,78E+08 |
|
4
|
3 |
2,69E+07 |
2,66E+07 |
7,25E+14 |
7,16E+14 |
1,95E+22 |
5,26E+29 |
1,95E+22 |
17,11 |
4,61E+08 |
|
5
|
4 |
4,79E+07 |
7,70E+07 |
2,29E+15 |
3,68E+15 |
1,10E+23 |
5,24E+30 |
1,10E+23 |
17,68 |
8,46E+08 |
|
6
|
5 |
6,12E+07 |
5,40E+07 |
3,75E+15 |
3,31E+15 |
2,30E+23 |
1,41E+31 |
2,30E+23 |
17,93 |
1,10E+09 |
|
7
|
6 |
6,40E+07 |
4,41E+07 |
4,09E+15 |
2,82E+15 |
2,62E+23 |
1,68E+31 |
2,62E+23 |
17,97 |
1,15E+09 |
|
8
|
7 |
4,25E+07 |
3,47E+07 |
1,81E+15 |
1,48E+15 |
7,68E+22 |
3,27E+30 |
7,68E+22 |
17,57 |
7,47E+08 |
|
9
|
8 |
8,09E+07 |
4,89E+07 |
6,55E+15 |
3,96E+15 |
5,30E+23 |
4,29E+31 |
5,30E+23 |
18,21 |
1,47E+09 |
|
10
|
9 |
6,60E+07 |
5,41E+07 |
4,36E+15 |
3,57E+15 |
2,88E+23 |
1,90E+31 |
2,88E+23 |
18,01 |
1,19E+09 |
|
11
|
10 |
9,71E+07 |
7,22E+07 |
9,44E+15 |
7,01E+15 |
9,17E+23 |
8,91E+31 |
9,17E+23 |
18,39 |
1,79E+09 |
|
12
|
11 |
2,10E+08 |
1,34E+08 |
4,41E+16 |
2,81E+16 |
9,27E+24 |
1,95E+33 |
9,27E+24 |
19,16 |
4,03E+09 |
|
13
|
12 |
4,05E+07 |
6,14E+07 |
1,64E+15 |
2,49E+15 |
6,65E+22 |
2,70E+30 |
6,65E+22 |
17,52 |
7,10E+08 |
|
14
|
13 |
1,35E+07 |
2,42E+05 |
1,84E+14 |
3,27E+12 |
2,49E+21 |
3,37E+28 |
2,49E+21 |
16,42 |
2,22E+08 |
|
15
|
14 |
1,07E+07 |
2,82E+07 |
1,15E+14 |
3,03E+14 |
1,24E+21 |
1,33E+28 |
1,24E+21 |
16,19 |
1,74E+08 |
|
16
|
15 |
1,09E+07 |
1,07E+07 |
1,19E+14 |
1,17E+14 |
1,30E+21 |
1,42E+28 |
1,30E+21 |
16,21 |
1,77E+08 |
|
17
|
16 |
1,07E+07 |
1,24E+07 |
1,15E+14 |
1,33E+14 |
1,24E+21 |
1,33E+28 |
1,24E+21 |
16,19 |
1,74E+08 |
|
18
|
17 |
9,09E+06 |
7,19E+06 |
8,26E+13 |
6,54E+13 |
7,51E+20 |
6,83E+27 |
7,51E+20 |
16,02 |
1,46E+08 |
|
19
|
18 |
9,20E+06 |
6,53E+06 |
8,47E+13 |
6,01E+13 |
7,80E+20 |
7,18E+27 |
7,80E+20 |
16,04 |
1,48E+08 |
|
20
|
19 |
1,36E+07 |
8,11E+06 |
1,86E+14 |
1,11E+14 |
2,54E+21 |
3,46E+28 |
2,54E+21 |
16,43 |
2,24E+08 |
|
21
|
20 |
2,21E+07 |
1,11E+07 |
4,87E+14 |
2,45E+14 |
1,07E+22 |
2,37E+29 |
1,07E+22 |
16,91 |
3,73E+08 |
|
22
|
21 |
1,43E+07 |
2,60E+05 |
2,05E+14 |
3,72E+12 |
2,93E+21 |
4,19E+28 |
2,93E+21 |
16,48 |
2,36E+08 |
|
23
|
22 |
2,71E+07 |
5,08E+07 |
7,36E+14 |
1,38E+15 |
2,00E+22 |
5,42E+29 |
2,00E+22 |
17,12 |
4,64E+08 |
|
24
|
Сумма
|
9,45E+08
|
9,45E+08
|
8,33E+16
|
6,10E+16
|
1,19E+25
|
2,14E+33
|
1,19E+25
|
3,78E+02
|
1,70E+10
|
Страницы: 1, 2, 3, 4
|
|
Главная