dane1

Overview

dane1
Arkusz3

Sheet 1: dane1
Ref Number Business Line Entry Year Revenue Assets Employees Audit Index Gross Loss Big Loss




liczba zdarzeń
36 Payment and Settlement 2003 7636.2 26591.2 27550 28.14 8 0




11
37 Payment and Settlement 2003 101.1 278.6 618 151.56 1 0




10
54 Payment and Settlement 2004 0 198.8 0 846.53 0.97 0




10
92 Payment and Settlement 2006 11262.3 1038952.4 98080 2.31 100 1




14
1 Retail Banking 2002 0 0 0 0.29 105 1




15
2 Retail Banking 2002 69.9 112.2 482 0.84 95 0




7
3 Retail Banking 2002 0 0 0 118.76 4.1 0
Przedziały Częstość wynik funkcji Częstość
10
5 Retail Banking 2002 0 0 0 913.99 1 0

8
6 Retail Banking 2002 7.476 103.962 0 151.21 6.5 0




5
7 Retail Banking 2002 13051 186582 47000 68.76 12.8 0
2002 32 32
10
8 Retail Banking 2002 0 0 0 99.17 4.75 0
2003 45 13
9
9 Retail Banking 2002 1891.8 2260.88 4000 0.32 1025 1
2004 55 10
11
10 Retail Banking 2002 0 0 0 7.95 52 0
2005 78 23
10
11 Retail Banking 2002 10389.3 0 9399 14.42 54 0
2006 95 17
6
12 Retail Banking 2002 53116 621764 142670 102.3 2.5 0
2007 116 21
6
15 Retail Banking 2002 0 0 0 43.59 9.36 0
2008 127 11
13
16 Retail Banking 2002 11045.14 445779.78 54300 396.64 1.85 0




13
17 Retail Banking 2002 0 0 0 80.14 3 0

Średnia 18.1428571428571
14
20 Retail Banking 2002 709.18 51201.1 5791 166 5.04 0

Odchylenie std. 7.84
14
21 Retail Banking 2002 723 10907.28 1765 402.33 1.6 0




10
22 Retail Banking 2002 0 0 0 8.65 96.4 0




9
23 Retail Banking 2002 31795.4 725300.2 65926 33.32 28.815 0




12
25 Retail Banking 2002 2883.077 31691.953 13473 111.25 1.8 0




8
27 Retail Banking 2002 82093 716937 180000 22.71 12.1 0




11
28 Retail Banking 2002 0 0 0 97.77 3.9 0




16
31 Retail Banking 2002 0 0 0 25.92 30 0




10
33 Retail Banking 2003 0 0 0 308.48 2.22 0




11
34 Retail Banking 2003 88 0 63 163.59 2.22 0




7
35 Retail Banking 2003 2.25 0 15 214.01 1.6 0




10
41 Retail Banking 2003 19037 268298 52459 31.77 9 0




12
42 Retail Banking 2003 58939 1097190 255000 535.25 1.6 0




8
43 Retail Banking 2003 15586 341839 80778 88.96 6 0




7
46 Retail Banking 2004 25866 175001 78200 12.15 75 0




9
47 Retail Banking 2004 491.6 1989.2 1266 5.32 117.9 1




10
48 Retail Banking 2004 25038.65 506430.01 57055 193.49 4.6 0




15
51 Retail Banking 2004 456.6 7300.4 3360 130.04 3.57 0




16
52 Retail Banking 2004 4078 102118.9 25567 530.25 0.4 0




12
53 Retail Banking 2004 57047 1264032 253000 5.5 89.46 0




12
55 Retail Banking 2004 2089.1 93973.4 10838 524.56 1.6 0




15
57 Retail Banking 2005 36.59 268.83 229 389.34 1.8 0




15
58 Retail Banking 2005 566.63 23329.7 10511 60.11 8.65 0




10
60 Retail Banking 2005 26579 706907.2 110201 1389.26 0.1 0




12
61 Retail Banking 2005 9.97 730.52 93 615.03 1.1 0




2
63 Retail Banking 2005 -6.36 68.21 12 161.34 2.37 0




10
66 Retail Banking 2005 4114 94456 19659 51.31 17 0




15
68 Retail Banking 2005 418.63 7540.45 749 7.88 48 0




5
70 Retail Banking 2005 189.2 992.35 93 0.01 1.5 0




16
71 Retail Banking 2005 891.7 4794.3 1328 102.2 5.89 0




10
72 Retail Banking 2005 6097 131984.7 70 3.46 18.98 0




11
74 Retail Banking 2005 43227 1110457 175742 0.17 12.5 0




15
75 Retail Banking 2005 30595 1157248 160968 48.22 12.5 0




12
76 Retail Banking 2005 1399.6 5408.1 1977 160.19 3.87 0




8
77 Retail Banking 2005 2752 79723 23700 37.7 5.25 0




12
79 Retail Banking 2006 189.2 992.35 93 55.58 8.9 0




15
80 Retail Banking 2006 21187.6 635293.1 59294 13.65 29.6 0




14
82 Retail Banking 2006 404.27 9105.72 827 8.36 8.5 0




11
85 Retail Banking 2006 16303.7 227647.1 31063 144.06 6.83 0




19
87 Retail Banking 2006 948.6 1821.2 3400 48.01 11.53 0




13
89 Retail Banking 2006 58626 1291803 202500 8.86 40.88 0




13
95 Retail Banking 2006 404.27 9105.72 827 52.31 12 0




12
96 Retail Banking 2007 370 6800.3 4878 216.63 4.2 0




10
100 Retail Banking 2007 2142.1 26766.6 21079 215.62 1.1 0




11
102 Retail Banking 2007 5737.9 198150.4 9150 6035.58 0.14 0




14
106 Retail Banking 2007 12845 213887 17307 1.23 481.91 1




11
108 Retail Banking 2007 1871.1 19658.5 20446 215.56 3.3 0




13
109 Retail Banking 2007 376.3 6212.5 6543 577.29 1.68 0




8
110 Retail Banking 2007 46732.6 1099586.6 129749 4019.72 0.11 0




13
112 Retail Banking 2007 78585 1459737 203425 610.99 1.5 0




9
113 Retail Banking 2007 14945.46 712564.24 55800 1305.46 0.13 0




9
114 Retail Banking 2007 58493.4 1663208 77063 4299.61 0.11 0




6
116 Retail Banking 2007 2812.6 13408.2 2938 0.72 560.49 1




8
117 Retail Banking 2008 30056.4 499672.9 38822 11.15 20 0




11
119 Retail Banking 2008 15522.1 384683.9 53251 0.42 347.96 1




13
120 Retail Banking 2008 2580.2 37228.3 26869 308.89 0.75 0




7
123 Retail Banking 2008 94.4 4269.4 556 5.45 18.7 0




20
125 Retail Banking 2008 58493.4 1663208 77063 431.43 0.64 0




11
126 Retail Banking 2008 14945.46 712564.24 55800 2.81 51.24 0




12
4 Retail Brokerage 2002 82093 716937 180000 237.71 3 0




11
14 Retail Brokerage 2002 0 0 0 270.51 1 0




9
18 Retail Brokerage 2002 0 0 0 48.07 2.593 0




18
19 Retail Brokerage 2002 0 0 0 240.27 2.3 0




6
24 Retail Brokerage 2002 0 0 0 481.48 1.8 0




8
30 Retail Brokerage 2002 0 0 0 562.51 1 0




11
32 Retail Brokerage 2002 0 0 0 202.92 3.17 0




15
38 Retail Brokerage 2003 3429.32 48460.97 15878 41.13 14.3 0




12
40 Retail Brokerage 2003 0 0 0 60 9.2 0




11
56 Retail Brokerage 2005 32114.2 295125.6 27708 418.57 0.13 0




15
59 Retail Brokerage 2005 2538.86 3723.16 29200 1.23 300 1




8
62 Retail Brokerage 2005 3779.8 4603.9 11200 564.35 0.83 0




11
64 Retail Brokerage 2005 32467 648059 53100 20.63 13.5 0




17
65 Retail Brokerage 2005 4103 35104 2600 5078.66 0.13 0




15
69 Retail Brokerage 2005 29115 192638 77500 12.3 2.4 0




10
73 Retail Brokerage 2005 28348 401058 39418 5954.1 0.13 0




8
78 Retail Brokerage 2005 7245 93113 11196 21.36 42.3 0




14
84 Retail Brokerage 2006 47783 681015 55500 80.02 2.5 0




9
90 Retail Brokerage 2006 18092.3 170425.8 11787 97.84 3.83 0




9
93 Retail Brokerage 2006 23689 520755 97134 168.59 2.5 0




6
97 Retail Brokerage 2007 23689 520755 97134 564.75 1.7 0




9
98 Retail Brokerage 2007 7159.55 164452.54 450 2776.3 0.34 0




10
103 Retail Brokerage 2007 76551 1120645 55310 10.59 53.5 0




8
105 Retail Brokerage 2007 76551 1120645 55310 1831.84 0.5 0





107 Retail Brokerage 2007 68622 841299 56200 312.62 1.6 0





111 Retail Brokerage 2007 29.5 0 60 6589.8 0.1 0





118 Retail Brokerage 2008 32265 707121 108238 1169.52 0.3 0





124 Retail Brokerage 2008 59107 1351520 174360 3170.2 0.23 0





127 Retail Brokerage 2008 708.6 2045.4 1676 16.05 56.93 0





13 Trading & Sales 2002 0 0 0 4.34 69.2 0





26 Trading & Sales 2002 0 0 0 44.95 16.6 0





29 Trading & Sales 2002 137.4 984.4 143 48.83 12.1 0





39 Trading & Sales 2003 43372 758800 94335 0.68 140 1





44 Trading & Sales 2003 6722.9 4704.41 23258 0.44 2200 1





45 Trading & Sales 2003 452.8 1912.8 595 4.23 63.5 0





49 Trading & Sales 2004 9493.9 180027 51673 341.22 1.65 0





50 Trading & Sales 2004 33731.8 795817.7 69308 359.9 1.65 0





67 Trading & Sales 2005 30595 1157248 160968 0.43 356 1





81 Trading & Sales 2006 11552.4 292635.2 12519 196.23 1.5 0





83 Trading & Sales 2006 10493.4 319314.6 42843 1.09 250 1





86 Trading & Sales 2006 51840.7 1170303.5 63427 5.35 11.16 0





88 Trading & Sales 2006 48667.2 1016011.2 62519 1826.07 0.25 0





91 Trading & Sales 2006 30359.9 691152.1 78457 2372.05 0.33 0





94 Trading & Sales 2006 11552.4 292635.2 12519 27.13 30 0





99 Trading & Sales 2007 16551.4 292635.2 13566 2.12 160 1





101 Trading & Sales 2007 42392.6 1261738.4 119779 0.3 1365.37 1





104 Trading & Sales 2007 29200.92 460072.69 105855 2324.55 0.4 0





115 Trading & Sales 2007 75879 1860758 312000 0.51 24 0





121 Trading & Sales 2008 64.15 0 374 394.97 2.1 0





122 Trading & Sales 2008 30.99 0 151 746.53 1.28 0





Sheet 2: Arkusz3
Ref Number Business Line Entry Year Gross Loss




liczba zdarzeń w kolejnych latach dotkliwosc pojedynczego zdarzenia student: prognozowanie zyskow na podstawie strat jest kłócące z praktyką strata nie może być ujemna wiec tak jest




1 Retail Banking 2002 105




8 -282.893538735434 0




2 Retail Banking 2002 95

liczba zdarzeń narastająco liczba zdarzeń
10 86.5065555787529 86.5065555787529




3 Retail Banking 2002 4.1
Przedziały Częstość wynik funkcji Częstość
9 -172.675084524881 0




5 Retail Banking 2002 1

8 -78.0008515560534 0


var 7620.85386776508
6 Retail Banking 2002 6.5




8 -206.696989391558 0




7 Retail Banking 2002 12.8
2002 22 22
17 145.906617706432 145.906617706432




8 Retail Banking 2002 4.75
2003 28 6
13 108.63252895223 108.63252895223




9 Retail Banking 2002 1025
2004 35 7
4 -44.2279372348916 0 341.045702237415 roka 2009


10 Retail Banking 2002 52
2005 49 14
15 168.271887321398 168.271887321398




11 Retail Banking 2002 54
2006 56 7
14 19.1381156925578 19.1381156925578




12 Retail Banking 2002 2.5
2007 67 11
12 102.020503379835 102.020503379835




15 Retail Banking 2002 9.36
2008 73 6
11 -261.249049128592 0




16 Retail Banking 2002 1.85




12 -134.018962182663 0




17 Retail Banking 2002 3

Średnia 10.4285714285714
7 88.6813111152966 88.6813111152966




20 Retail Banking 2002 5.04

Odchylenie std. 5.91
11 238.714101885934 238.714101885934




21 Retail Banking 2002 1.6




11 356.496494294051 356.496494294051




22 Retail Banking 2002 96.4




11 43.3782977212919 43.3782977212919




23 Retail Banking 2002 28.815




13 -38.7725952007808 0 9308.57093159046 rok 2010


25 Retail Banking 2002 1.8




9 173.260542158177 173.260542158177




27 Retail Banking 2002 12.1




8 86.6953393939999 86.6953393939999




28 Retail Banking 2002 3.9

średnia wątpliwosci jednego zdarzenia 49.6355479452055
9 28.8944972796249 28.8944972796249




31 Retail Banking 2002 30

odchylenie śtandardowe 149.677327273357
10 113.815069869533 113.815069869533




33 Retail Banking 2003 2.22




15 105.957411267527 105.957411267527




34 Retail Banking 2003 2.22




8 41.6598547760164 41.6598547760164




35 Retail Banking 2003 1.6




8 -210.659068454616 0




41 Retail Banking 2003 9




14 64.1972408063244 64.1972408063244




42 Retail Banking 2003 1.6




14 255.505656912364 255.505656912364 869.985612463567



43 Retail Banking 2003 6




9 13.2948314218898 13.2948314218898




46 Retail Banking 2004 75




14 234.809508344997 234.809508344997




47 Retail Banking 2004 117.9




9 102.190919040085 102.190919040085




48 Retail Banking 2004 4.6




14 -177.590947043709 0




51 Retail Banking 2004 3.57




10 20.5738931414904 20.5738931414904




52 Retail Banking 2004 0.4




12 -207.897042184696 0




53 Retail Banking 2004 89.46




15 152.11505409542 152.11505409542




55 Retail Banking 2004 1.6




5 29.0793693581596 29.0793693581596 552.063575402042



57 Retail Banking 2005 1.8




9 174.423858641321 174.423858641321




58 Retail Banking 2005 8.65




9 -51.8034405670827 0




60 Retail Banking 2005 0.1




15 44.775468029629 44.775468029629




61 Retail Banking 2005 1.1




13 -106.099026436196 0




63 Retail Banking 2005 2.37




9 -156.216877496545 0




66 Retail Banking 2005 17




12 214.063017426897 214.063017426897




68 Retail Banking 2005 48




10 -66.2863906312036 0




70 Retail Banking 2005 1.5




9 -69.4171406051377 0




71 Retail Banking 2005 5.89




14 -120.530613696529 0 433.262344097847



72 Retail Banking 2005 18.98




9 341.276777123939 341.276777123939




74 Retail Banking 2005 12.5




13 -17.4881554469815 0




75 Retail Banking 2005 12.5




12 -141.282887181942 0




76 Retail Banking 2005 3.87




5 -48.5301673164126 0




77 Retail Banking 2005 5.25




13 286.266193814017 286.266193814017




79 Retail Banking 2006 8.9




10 -90.3248631059891 0




80 Retail Banking 2006 29.6




6 205.594277520222 205.594277520222




82 Retail Banking 2006 8.5




9 31.6757420820883 31.6757420820883




85 Retail Banking 2006 6.83




10 -255.809354041331 0




87 Retail Banking 2006 11.53




10 253.372229724564 253.372229724564




89 Retail Banking 2006 40.88




10 181.214973724936 181.214973724936




95 Retail Banking 2006 12




7 168.585846711439 168.585846711439




96 Retail Banking 2007 4.2




6 -91.2847692800919 0




100 Retail Banking 2007 1.1




12 93.2352529504802 93.2352529504802




102 Retail Banking 2007 0.14




11 -8.61684680995531 0




106 Retail Banking 2007 481.91




9 232.202590939496 232.202590939496




108 Retail Banking 2007 3.3




8 170.320957056619 170.320957056619




109 Retail Banking 2007 1.68




6 163.794479465368 163.794479465368




110 Retail Banking 2007 0.11




8 38.54066993671 38.54066993671




112 Retail Banking 2007 1.5




10 147.078097814019 147.078097814019




113 Retail Banking 2007 0.13




13 20.7953314545099 20.7953314545099




114 Retail Banking 2007 0.11




19 142.080258899741 142.080258899741




116 Retail Banking 2007 560.49




6 138.72296834751 138.72296834751




117 Retail Banking 2008 20




12 81.8752293868689 81.8752293868689




119 Retail Banking 2008 347.96




13 -66.9983267128468 0




120 Retail Banking 2008 0.75




11 349.347880490031 349.347880490031




123 Retail Banking 2008 18.7




7 -22.4227262718254 0




125 Retail Banking 2008 0.64




9 -81.2918126596836 0




126 Retail Banking 2008 51.24




11 -84.972926981491 0













9 366.120046908408 366.120046908408













12 192.584861668083 192.584861668083













7 -21.0122900737682 0













12 350.984687190875 350.984687190875













10 41.7972757874755 41.7972757874755













9 43.1378109512385 43.1378109512385













13 91.4947001890046 91.4947001890046













7 -14.5021397314034 0













11 165.362915811501 165.362915811501













17 -39.0998204805423 0













8 134.93844811609 134.93844811609













12 184.413413751544 184.413413751544













13 -99.804871990555 0













13 -338.602111935243 0













13 267.056505197333 267.056505197333













10 -217.30425875131 0













14 180.693182062614 180.693182062614













11 42.645272276504 42.645272276504













8 -138.753184057632 0













7 -321.224476704001 0













7 24.2621506346855 24.2621506346855













14 257.982636628812 257.982636628812













15 -90.910943310801 0













10 155.719634438073 155.719634438073













14 327.231261269562 327.231261269562













9 203.306421770039 203.306421770039













20 360.847706122231 360.847706122231





Wyszukiwarka

Podobne podstrony:
Dane1
dane1(1)
dane1
dane1 torn
Dane1(WEiP 2009)
dane1 facja barierowa
dane1
dane1
dane1
dane1
dane1
dane1
Dane1(WEiP 2009)
Dane1(WEiP 2010)
dane1
Ćwiczenie 1 dane1
DANE1

więcej podobnych podstron