Rwr/r-1 |
Ir/r-1 |
dziesiętne |
Ir/s |
- |
- |
- |
100/(A+100)/100)*(B+100)/100)*(C+100)/100)*(D+100)/100) |
A |
A+100 |
(A+100)/100 |
100/(B+100)/100)*(C+100)/100)*(D+100)/100) |
B |
B+100 |
(B+100)/100 |
100/(C+100)/100)*(D+100)/100) |
C |
C+100 |
(C+100)/100 |
100/(D+100)/100) |
D |
D+100 |
(D+100)/100 |
100 - baza |
E |
E+100 |
(E+100)/100 |
100*E+100/100 |
F |
F+100 |
(F+100)/100 |
(100*E+100/100)*F+100)/100 |
G |
G+100 |
(G+100)/100 |
((100*E+100/100)*F+100/100)*G+100/100 |
Rwr/r-1 |
dziesiętne |
Ir/s |
- |
- |
100/(A/100*B/100*C/100*D/100) |
A |
A/100 |
100/(B/100*C/100*D/100) |
B |
B/100 |
100/(C/100*D/100) |
C |
C/100 |
100/D/100 |
D |
D/100 |
100 - baza |
E |
E/100 |
100*E/100 |
F |
F/100 |
(100*E/100)*F/100 |
G |
G/100 |
((100*E/100)*F/100)*G/100 |
Rwr/s |
Ir/s |
Ir/r-1 |
A |
A+100 |
- |
B |
B+100 |
(B+100/A+100)*100 |
C |
C+100 |
(C+100/B+100)*100 |
D |
D+100 |
(D+100/C+100)*100 |
E |
E+100 |
(E+100/D+100)*100 |
F |
F+100 |
(F+100/E+100)*100 |
G |
G+100 |
(G+100/F+100)*100 |
Ir/s |
Ir/r-1 |
A |
- |
B |
B/A*100 |
C |
C/B*100 |
D |
D/C*100 |
E |
E/D*100 |
F |
F/E*100 |
G |
G/F*100 |
Średnie ruchome zmienne |
|||
|
3 |
5 |
7 |
A |
- |
- |
- |
B |
(A+B+C)/3 |
- |
- |
C |
(B+C+D)/3 |
(A+B+C+D+E)/5 |
- |
D |
(C+D+E)/3 |
(B+C+D+E+F)/5 |
(A+B+C+D+E+F+G)/7 |
E |
(D+E+F)/3 |
(C+D+E+F+G)/5 |
(B+C+D+E+F+G+H)/7 |
F |
(E+F+G)/3 |
(D+E+F+G+H)/5 |
- |
G |
(F+G+H)/3 |
- |
- |
H |
- |
- |
- |
max |
|
|
|
min |
|
|
|
R |
|
|
|
Średnie ruchome centrowane |
|||
|
2 |
4 |
6 |
A |
- |
- |
- |
B |
(0,5A+B+0,5C)/2 |
- |
- |
C |
(0,5B+C+0,5D)/2 |
(0,5A+B+C+D+0,5E)/4 |
- |
D |
(0,5C+D+0,5E)/2 |
(0,5B+C+D+E+0,5F)/4 |
(0,5A+B+C+D+E+F+0,5G)/6 |
E |
(0,5D+E+0,5F)/2 |
(0,5C+D+E+F+0,5G)/4 |
(0,5B+C+D+E+F+G+0,5H)/6 |
F |
(0,5E+F+0,5G)/2 |
(0,5D+E+F+G+0,5H)/4 |
- |
G |
(0,5F+G+0,5H)/2 |
- |
- |
H |
- |
- |
- |
Tendencja rozwojowa |
|
|
|
|
ti |
yt(zł.) |
licznik |
mianownik |
yt=a*ti-b |
1 |
A |
(1-śr t)*A |
(1-śr t)^2 |
a*1-b |
2 |
B |
(2-śr t)*B |
(2-śr t)^2 |
a*2-b |
3 |
C |
(3-śr t)*C |
(3-śr t)^2 |
a*3-b |
4 |
D |
(4-śr t)*D |
(4-śr t)^2 |
a*4-b |
5 |
E |
(5-śr t)*E |
(5-śr t)^2 |
a*5-b |
6 |
F |
(6-śr t)*F |
(6-śr t)^2 |
a*6-b |
7 |
G |
(7-śr t)*G |
(7-śr t)^2 |
a*7-b |
8 |
H |
(8-śr t)*H |
(8-śr t)^2 |
a*8-b |
9 |
I |
(9-śr t)*I |
(9-śr t)^2 |
a*9-b |
10 |
J |
(10-śr t)*J |
(10-śr t)^2 |
a*10-b |
|
SUMA |
|
|
|
średnia z t |
||||
śr (1-10) |
||||
|
||||
a |
||||
suma licz/suma mian |
||||
|
||||
średnia z yt |
||||
śr (A-J) |
||||
|
||||
b |
||||
śr (A-J) - a*śr (1-10) |
Sezonowość miesięczną |
|
|
|
|
|
|
|
|
|
|
|
||
|
I |
II |
III |
IV |
V |
VI |
VII |
VIII |
IX |
X |
XI |
XII |
|
2005 |
1a |
2a |
3a |
4a |
5a |
6a |
7a |
8a |
9a |
10a |
11a |
12a |
|
2006 |
1b |
2b |
3b |
4b |
5b |
6b |
7b |
8b |
9b |
10b |
11b |
12b |
|
2007 |
1c |
2c |
3c |
4c |
5c |
6c |
7c |
8c |
9c |
10c |
11c |
12c |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
średnia |
1a,1b,1c |
2a,2b,2c |
3a,3b,3c |
4a4b4c |
5a5b5c |
6a6b6c |
7a7b7c |
8a8b8c |
9a9b9c |
10a10b10c |
11a11b11c |
12a12b12c |
śr (1-12) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
S1 |
S2 |
S3 |
S4 |
S5 |
S6 |
S7 |
S8 |
S9 |
S10 |
S11 |
S12 |
|
|
śr1/śr(1-10)*100 |
śr2/śr(1-10)*100 |
|
|
|
|
|
|
|
|
|
|
suma |
Sezonowość kwartalną |
|
|
|
|
|
|
|
|
|
|
|
|||
|
I |
II |
III |
IV |
V |
VI |
VII |
VIII |
IX |
X |
XI |
XII |
||
2005 |
1a |
2a |
3a |
4a |
5a |
6a |
7a |
8a |
9a |
10a |
11a |
12a |
||
2006 |
1b |
2b |
3b |
4b |
5b |
6b |
7b |
8b |
9b |
10b |
11b |
12b |
||
2007 |
1c |
2c |
3c |
4c |
5c |
6c |
7c |
8c |
9c |
10c |
11c |
12c |
||
|
|
|
4 |
|||||||||||
2005 |
I |
1a,2a,3a |
- |
|||||||||||
|
II |
4a,5a,6a |
- |
|||||||||||
|
III |
7a,8a,9a E |
(0,5I+II+III+IV+0,5I)/4 E |
|||||||||||
|
IV |
10a,11a,12a G |
(0,5II+III+IV+I+0,5II)/4 G |
|||||||||||
2006 |
I |
1b,2b,3b A |
(0,5III+IV+I+II+0,5III)/4 A |
|||||||||||
|
II |
4b,5b,6b C |
(0,5IV+I+II+III+0,5IV)/4 C |
|||||||||||
|
III |
7b,8b,9b F |
(0,5I+II+III+IV+0,5I)/4 F |
|||||||||||
|
IV |
10b,11b,12b H |
(0,5II+III+IV+I+0,5II)/4 H |
|||||||||||
2007 |
I |
1c,2c,3c B |
(0,5III+IV+I+II+0,5III)/4 B |
|||||||||||
|
II |
4c,5c,6c D |
(0,5IV+I+II+III+0,5IV)/4 D |
|||||||||||
|
III |
7c,8c,9c |
- |
|||||||||||
|
IV |
10c,11c,12c |
- |
|||||||||||
|
|
|
|
|||||||||||
S1 |
(A-A)/(B-B)*100 |
s*k |
S1*k |
|||||||||||
S2 |
(C-C)/(D-D)*100 |
s*k |
S2*k |
|||||||||||
S3 |
(E-E)/(F-F)*100 |
s*k |
S3*k |
|||||||||||
S4 |
(G-G)/(H-H)*100 |
s*k |
S4*k |
|||||||||||
suma |
jeżeli <400 |
|
k= ilość S*100/sumę |
|||||||||||
|
liczymy k |
|
|
wzór |
na K |
rok |
r=1 |
półrocze |
r=2 |
kwartał |
r=4 |
miesiąc |
r=12 |