vyvojovy rok vyvojovy rok 0 1 2 3 0 1 2 3 2011 10200 2508 1608 985 2011 14.52991453 3.572649573 2.290598291 1.403133903 2012 9830 2456 1438 1065.376 2012 14.56296296 3.638518519 2.13037037 1.578334815 2013 10350 2507 1622.651214 1077.517037 2013 14.57746479 3.530985915 2.285424245 1.51762963 2014 9976 2530.442368 1623.38255 1078.002679 2014 14.60614934 3.704893657 2.376841215 1.578334815 počet škod 702 lambda 3= d3 21.67063953 "S3,1" 3.704893657 675 rezerva 2015 5218.469582 r3 0.064748154 "S3,2" 2.376841215 710 rezerva 2016 2700.899587 "lambda 2= d2/(S0,2+S1,2)" 21.9262669 "S3,3" 1.578334815 683 rezerva 2017 1078.002679 r2 0.101405559 celkem 8997.371847 lambda1 21.74934735 r1 0.164388215 r0 0.669458072 lambda0 21.70399481 inflace 0.04 lambda4 22.53746511 lambda5 23.43896372 lambda6 24.37652226 ##### Sheet/List 2 ##### rok 0 1 2 3 rok 0 1 2 3 2011 6450 2510 1520 750 2011 7126.423987 2705.588838 1590.72256 768 2012 7100 3320 1820 2012 7653.259264 3474.47296 1863.68 2013 6900 3001 2013 7221.0432 3073.024 2014 7460 2014 7639.04 inflace 2011 2012 2013 2014 1.025 1.03 1.022 1.024 rok 0 1 2 3 2011 7126.423987 9832.012826 11422.73539 12190.73539 2012 7653.259264 11127.73222 12991.41222 13864.88117 2013 7221.0432 10294.0672 11990.64567 12796.82873 2014 7639.04 10851.87448 12640.38588 13490.2538 lambda3 1.067234333 lambda2 1.164811287 rezervy 9227.444277 lambda1 1.420580921 O S "chyba v poli 2013,0" 7246.378609 7221.0432 -0.003508552 abs 0.00351