Trzby=Y Vyroba=X 31331 13814 22318 5175 5841 16148 104131 104161 SUMMARY OUTPUT SUMMARY OUTPUT 21732 18029 20465 6474 Regression Statistics Regression Statistics 36865 7838 Multiple R 0.456703168 Multiple R 0.932259004 12706 4376 R Square 0.208577784 R Square 0.86910685 21622 13642 Adjusted R Square 0.095517468 Adjusted R Square 0.850407829 Standard Error 52930.73284 Standard Error 11201.41127 Observations 9 Observations 9 ANOVA ANOVA df SS MS F Significance F df SS MS F Significance F Regression 1 5168608840 5168608840 1.844836371 0.216533546 "<0,05" Regression 1 5831761851 5831761851 46.47873445 0.000249208 Residual 7 19611637352 2801662479 Residual 7 878301301.4 125471614.5 Total 8 24780246192 Total 8 6710063152 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% "Lower 95,0%" "Upper 95,0%" Coefficients Standard Error t Stat P-value Lower 95% Upper 95% "Lower 95,0%" "Upper 95,0%" Intercept 29090.83832 21830.4834 1.332578752 0.22441052 -22530.05215 80711.72879 -22530.05215 80711.72879 Intercept 12747.30413 4575.673938 2.785885598 0.027068046 1927.554565 23567.05369 1927.554565 23567.05369 13814 0.808065853 0.594932684 1.358247537 0.216533546 -0.5987264 2.214858106 -0.5987264 2.214858106 X Variable 1 0.855677686 0.125511367 6.817531404 0.000249208 0.558890464 1.152464908 0.558890464 1.152464908 RESIDUAL OUTPUT PROBABILITY OUTPUT Observation Predicted 31331 Residuals Standard Residuals Percentile 31331 1 33272.57911 -10954.57911 -0.221250246 5.555555556 5841 2 42139.48571 -36298.48571 -0.733122543 16.66666667 12706 3 113259.7856 -9128.785616 -0.184374593 27.77777778 20465 4 43659.45758 -21927.45758 -0.442870086 38.88888889 21622 5 34322.25665 -13857.25665 -0.279875787 50 21732 6 35424.45847 1440.541526 0.029094698 61.11111111 22318 7 32626.93449 -19920.93449 -0.402344227 72.22222222 36865 8 44151.56968 129139.4303 2.608236287 83.33333333 104131 9 40114.47268 -18492.47268 -0.373493504 94.44444444 173291 Tržby=Y Výroba=X1 Dotácie=X2 SUMMARY OUTPUT 31331 13814 5932 22318 5175 5734 Regression Statistics 5841 16148 14207 Multiple R 0.479760886 104131 104161 4859 R Square 0.230170508 21732 18029 3796 Adjusted R Square 0.010219224 20465 6474 231 Standard Error 52422.85387 36865 7838 4924 Observations 10 12706 4376 3411 173291 18638 5941 ANOVA 21622 13642 30081 df SS MS F Significance F Regression 2 5751677024 2875838512 1.046461308 0.400295684 Residual 7 19237089258 2748155608 Total 9 24988766282 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% "Lower 95,0%" "Upper 95,0%" Intercept 34898.0287 26736.36149 1.305264694 0.233066466 -28323.42008 98119.47748 -28323.42008 98119.47748 X Variable 1 0.79974844 0.588570669 1.358797646 0.216367428 -0.592000038 2.191496918 -0.592000038 2.191496918 X Variable 2 -0.824888623 2.048291931 -0.402720242 0.699169331 -5.668329398 4.018552152 -5.668329398 4.018552152