book1.xlsx
TRANSCRIPT
Rm A5 Hvmax HV n458 33.2 334 263 1.44565 28 326 300 1.327
1332 8.4 689 527 1.1931136 14.8 665 544 0.96
553 27.4 296 251 1.625591 26 381 320 1.078466 33.6 334 244 1.635558 24.4 296 237 1.707387 34 296 234 1.658550 29.2 334 268 1.317975 15.6 494 427 1.489
1052 14.8 642 510 1945 14.6 526 448 1.404802 20 642 393 1.511810 21.6 561 469 1.256
Rm n458 1.44565 1.327 SUMMARY OUTPUT
1332 1.1931136 0.96 Regression Statistics
553 1.625 Multiple R 0.610956813591 1.078 R Square 0.373268228466 1.635 Adjusted R S 0.325058091558 1.707 Standard Err 0.197726054387 1.658 Observations 15550 1.317975 1.489 ANOVA
1052 1 df SS MS F945 1.404 Regression 1 0.30269863412 0.302699 7.742526802 1.511 Residual 13 0.50824269921 0.039096810 1.256 Total 14 0.81094133333
Coefficients Standard Error t Stat P-valueIntercept 1.756320326 0.14680248765 11.96383 2.167E-08Rm -0.00051385 0.00018466821 -2.782539 0.01554
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.520978587 -0.08097858724 -0.425012 1.465997002 -0.13899700197 -0.7295143 1.071876666 0.12112333358 0.6357064 1.172590598 -0.21259059832 -1.1157645 1.472163161 0.15283683893 0.8021526 1.452636991 -0.3746369906 -1.9662527 1.516867815 0.11813218549 0.6200078 1.469593928 0.23740607189 1.2460069 1.557461695 0.10053830477 0.527667
10 1.473704701 -0.15670470084 -0.82245211 1.2553199 0.23368010048 1.22645112 1.215753712 -0.21575371199 -1.13236613 1.270735297 0.13326470274 0.69942914 1.34421536 0.16678464018 0.87535615 1.340104587 -0.08410458709 -0.441416
Significance F0.0155403696
Lower 95% Upper 95% Lower 95,0% Upper 95,0%1.4391728331 2.07346782 1.43917283 2.0734678191-0.000912798 -0.0001149 -0.0009128 -0.000114895
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
A5 n33.2 1.44
28 1.327 SUMMARY OUTPUT8.4 1.193
14.8 0.96 Regression Statistics27.4 1.625 Multiple R 0.529127017
26 1.078 R Square 0.279975433.6 1.635 Adjusted R S 0.22458889224.4 1.707 Standard Erro 0.211932084
34 1.658 Observations 1529.2 1.31715.6 1.489 ANOVA14.8 1 df SS MS F14.6 1.404 Regression 1 0.22704362404 0.227044 5.054939
20 1.511 Residual 13 0.58389770929 0.04491521.6 1.256 Total 14 0.81094133333
Coefficients Standard Error t Stat P-valueIntercept 1.010411335 0.17044214332 5.928178 5E-05A5 0.015751823 0.0070060442 2.248319 0.042539
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.533371853 -0.09337185338 -0.4572062 1.451462375 -0.12446237462 -0.6094443 1.142726647 0.05027335303 0.2461694 1.243538313 -0.28353831314 -1.3883775 1.442011281 0.18298871909 0.8960256 1.419958729 -0.34195872894 -1.6744397 1.539672583 0.09532741748 0.4667818 1.394755812 0.31224418761 1.5289389 1.545973312 0.11202668835 0.548551
10 1.470364562 -0.15336456202 -0.75096711 1.256139771 0.23286022859 1.14022612 1.243538313 -0.24353831314 -1.19251213 1.240387949 0.16361205143 0.80114514 1.325447792 0.1855522081 0.90857715 1.350650708 -0.09465070844 -0.463468
Significance F0.0425392378
Lower 95% Upper 95% Lower 95,0% Upper 95,0%0.6421934709 1.3786292 0.642193471 1.3786291990.0006161845 0.0308875 0.000616185 0.030887461
5 10 15 20 25 30 35 40
-0.4
-0.2
0
0.2
0.4
A5 Residual Plot
A5
Resid
uals
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
5 10 15 20 25 30 35 40
-0.4
-0.2
0
0.2
0.4
A5 Residual Plot
A5
Resid
uals
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
Hvmax n334 1.44326 1.327 SUMMARY OUTPUT689 1.193665 0.96 Regression Statistics296 1.625 Multiple R 0.6243377842381 1.078 R Square 0.3897976688334 1.635 Adjusted R 0.342859028296 1.707 Standard Err0.1951012148296 1.658 Observation 15334 1.317494 1.489 ANOVA642 1 df SS MS F526 1.404 Regression 1 0.31610304128 0.316103 8.304409642 1.511 Residual 13 0.49483829205 0.038064561 1.256 Total 14 0.81094133333
Coefficients Standard Error t Stat P-valueIntercept 1.8190974126 0.16268176719 11.18194 4.851E-08Hvmax -0.000980995 0.0003404179 -2.881737 0.01285
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.4914451184 -0.05144511841 -0.2736382 1.4992930776 -0.17229307755 -0.9164323 1.1431919315 0.04980806849 0.2649314 1.1667358089 -0.20673580894 -1.0996345 1.5287229243 0.09627707567 0.5121016 1.4453383585 -0.36733835846 -1.9538837 1.4914451184 0.14355488159 0.7635738 1.5287229243 0.17827707567 0.9482619 1.5287229243 0.12927707567 0.687629
10 1.4914451184 -0.17444511841 -0.92787911 1.3344859356 0.15451406442 0.82186512 1.1892986915 -0.18929869147 -1.00688513 1.303094099 0.10090590098 0.53672114 1.1892986915 0.32170130853 1.71113915 1.2687592778 -0.01275927777 -0.067867
Significance F0.012850496
Lower 95% Upper 95% Lower 95,0% Upper 95,0%1.4676448217 2.17055 1.467644822 2.170550003-0.001716423 -0.0002456 -0.00171642 -0.00024557
250 300 350 400 450 500 550 600 650 700 750
-0.6-0.4-0.2
00.20.4
Hvmax Residual Plot
Hvmax
Resid
uals
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
250 300 350 400 450 500 550 600 650 700 750
-0.6-0.4-0.2
00.20.4
Hvmax Residual Plot
Hvmax
Resid
uals
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
HV n263 1.44300 1.327 SUMMARY OUTPUT527 1.193544 0.96 Regression Statistics251 1.625 Multiple R 0.7190767539320 1.078 R Square 0.5170713779244 1.635 Adjusted R S 0.4799230224237 1.707 Standard Erro0.1735659442234 1.658 Observations 15268 1.317427 1.489 ANOVA510 1 df SS MS F448 1.404 Regression 1 0.41931455265 0.419315 13.91909393 1.511 Residual 13 0.39162678068 0.030125469 1.256 Total 14 0.81094133333
Coefficients Standard Error t Stat P-valueIntercept 1.9133395163 0.15152050896 12.62759 1.131E-08HV -0.001490357 0.00039947076 -3.73083 0.002518
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.5213755068 -0.0813755068 -0.4865432 1.4662322811 -0.1392322811 -0.8324683 1.1279211398 0.0650788602 0.3891064 1.1025850631 -0.1425850631 -0.8525155 1.5392597962 0.08574020383 0.512646 1.4364251321 -0.3584251321 -2.143027 1.5496922983 0.08530770168 0.5100548 1.5601248005 0.14687519953 0.8781659 1.5645958728 0.09340412717 0.558462
10 1.5139237195 -0.1969237195 -1.17740511 1.2769568849 0.21204311514 1.26780412 1.1532572165 -0.1532572165 -0.91632313 1.2456593784 0.1583406216 0.94671714 1.3276290382 0.18337096182 1.09637315 1.2143618719 0.04163812806 0.248954
Significance F0.00251770783
Lower 95% Upper 95% Lower 95,0% Upper 95,0%1.5859993579 2.2406797 1.585999358 2.240679675
-0.0023533615 -0.000627 -0.002353362 -0.00062735
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
Rm A5 n458 33.2 1.44 SUMMARY OUTPUT565 28 1.327
1332 8.4 1.193 Regression Statistics1136 14.8 0.96 Multiple R 0.66624255
553 27.4 1.625 R Square 0.443879136591 26 1.078 Adjusted R S 0.351192325466 33.6 1.635 Standard Erro0.193860215558 24.4 1.707 Observations 15387 34 1.658550 29.2 1.317 ANOVA975 15.6 1.489 df SS MS
1052 14.8 1 Regression 2 0.35995993813 0.17998945 14.6 1.404 Residual 12 0.45098139521 0.037582802 20 1.511 Total 14 0.81094133333810 21.6 1.256
Coefficients Standard Error t StatIntercept 3.186586517 1.167615752 2.72914Rm -0.00141594 0.00075291128 -1.880617A5 -0.03289528 0.02664966265 -1.23436
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.445963449 -0.0059634491 -0.0332262 1.465513554 -0.1385135543 -0.7717513 1.024236631 0.16876336921 0.9402924 1.091230672 -0.1312306721 -0.7311735 1.502241982 0.12275801846 0.6839666 1.494489733 -0.4164897331 -2.320547 1.421477831 0.21352216907 1.1896738 1.593848144 0.11315185618 0.6304449 1.520178824 0.13782117583 0.767893
10 1.447278284 -0.1302782842 -0.72586611 1.292880473 0.1961195272 1.09271212 1.210169469 -0.2101694694 -1.17099313 1.368253899 0.03574610114 0.19916514 1.393098507 0.1179014929 0.65690715 1.329138548 -0.0731385479 -0.407503
F Significance F4.789022 0.0295811555
P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%0.018296 0.64257033643 5.7306027 0.642570336 5.7306026980.084507 -0.0030563908 0.00022451 -0.003056391 0.0002245150.240695 -0.0909599111 0.02516934 -0.090959911 0.025169343
Standard Residuals
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
5 10 15 20 25 30 35 40
-0.6-0.4-0.2
00.20.4
A5 Residual Plot
A5
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
5 10 15 20 25 30 35 40
-0.6-0.4-0.2
00.20.4
A5 Residual Plot
A5
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
Rm Hvmax n458 334 1.44 SUMMARY OUTPUT565 326 1.327
1332 689 1.193 Regression Statistics1136 665 0.96 Multiple R 0.632042064
553 296 1.625 R Square 0.399477171591 381 1.078 Adjusted R S 0.299390033466 334 1.635 Standard Erro0.201450735558 296 1.707 Observations 15387 296 1.658550 334 1.317 ANOVA975 494 1.489 df SS MS
1052 642 1 Regression 2 0.32395254961 0.161976945 526 1.404 Residual 12 0.48698878372 0.040582802 642 1.511 Total 14 0.81094133333810 561 1.256
Coefficients Standard Error t StatIntercept 1.812656219 0.16861347998 10.75036Rm -0.00020508 0.00046630243 -0.439797Hvmax -0.00063044 0.00087114778 -0.723687
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.508163958 -0.06816395834 -0.3654762 1.491264068 -0.164264068 -0.8807393 1.105119858 0.08788014196 0.4711894 1.160445751 -0.20044575059 -1.0747355 1.512638153 0.11236184738 0.6024536 1.451257932 -0.37325793237 -2.0013067 1.506523331 0.12847666933 0.6888578 1.51161276 0.19538723968 1.0476139 1.546681177 0.1113188231 0.596861
10 1.48929674 -0.17229674007 -0.92380811 1.301268298 0.18773170176 1.00656612 1.192172418 -0.19217241756 -1.03037613 1.287246633 0.11675336728 0.62599914 1.243442032 0.26755796756 1.43457215 1.292866891 -0.03686689114 -0.19767
F Significance F3.991294 0.0469004632
P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%1.63E-07 1.4452790059 2.180033433 1.445279006 2.180033433
0.6679 -0.001221064 0.000810907 -0.001221064 0.0008109070.483128 -0.002528506 0.00126763 -0.002528506 0.00126763
Standard Residuals
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.6-0.4-0.2
00.20.4
Hvmax Residual Plot
Hvmax
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.6-0.4-0.2
00.20.4
Hvmax Residual Plot
Hvmax
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
Rm HV n458 263 1.44 SUMMARY OUTPUT565 300 1.327
1332 527 1.193 Regression Statistics1136 544 0.96 Multiple R 0.7558356034
553 251 1.625 R Square 0.5712874594591 320 1.078 Adjusted R S 0.4998353693466 244 1.635 Standard Err 0.1702108299558 237 1.707 Observation 15387 234 1.658550 268 1.317 ANOVA975 427 1.489 df SS MS
1052 510 1 Regression 2 0.46328061407 0.23164945 448 1.404 Residual 12 0.34766071926 0.028972802 393 1.511 Total 14 0.81094133333810 469 1.256
Coefficients Standard Error t StatIntercept 1.9783368026 0.15768102627 12.54645Rm 0.0006294886 0.00051099453 1.231889HV -0.0029646245 0.00125923991 -2.3543
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.4869463201 -0.04694632005 -0.297912 1.4446104897 -0.11761048974 -0.746333 1.2544584559 -0.06145845587 -0.394 1.0806800806 -0.12068008063 -0.765815 1.5823232277 0.04267677225 0.2708186 1.4016847023 -0.3236847023 -2.054047 1.5483100942 0.08668990582 0.5501178 1.6269754137 0.08002458635 0.507829 1.5282267426 0.12977325736 0.823515
10 1.5300361455 -0.21303614546 -1.3518811 1.3261934889 0.16280651107 1.03313712 1.1286002744 -0.12860027441 -0.8160713 1.2450517174 0.15894828263 1.00865414 1.3180892005 0.19291079953 1.22417315 1.0978136465 0.15818635345 1.003819
F Significance F7.99539 0.006208649
P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%2.94E-08 1.63477936 2.321894246 1.6347793595 2.32189424560.24158 -0.00048387 0.00174285 -0.000483873 0.001742850.03643 -0.00570827 -0.00022098 -0.005708273 -0.000220976
Standard Residuals
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.20.3
Rm Residual Plot
Rm
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.20.3
Rm Residual Plot
Rm
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
A5 Hvmax n33.2 334 1.44 SUMMARY OUTPUT
28 326 1.3278.4 689 1.193 Regression Statistics
14.8 665 0.96 Multiple R 0.624944899627.4 296 1.625 R Square 0.3905561275
26 381 1.078 Adjusted R 0.288982148733.6 334 1.635 Standard Err0.202941540624.4 296 1.707 Observation 15
34 296 1.65829.2 334 1.317 ANOVA15.6 494 1.489 df SS MS14.8 642 1 Regression 2 0.31671810676 0.15835914.6 526 1.404 Residual 12 0.49422322658 0.041185
20 642 1.511 Total 14 0.8109413333321.6 561 1.256
Coefficients Standard Error t StatIntercept 1.8918958922 0.61927522775 3.055016A5 -0.001658693 0.01357301607 -0.12221Hvmax -0.0010571 0.0007163951 -1.47558
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.4837558564 -0.04375585643 -0.232882 1.5008378619 -0.17383786194 -0.925223 1.1496209297 0.04337907034 0.2308784 1.164375694 -0.20437569403 -1.087765 1.5335460796 0.09145392039 0.4867496 1.4460147454 -0.36801474538 -1.95877 1.4830923791 0.15190762088 0.8085048 1.5385221594 0.16847784056 0.8966969 1.522598704 0.13540129604 0.720651
10 1.4903906296 -0.17339062955 -0.9228411 1.3438128491 0.14518715091 0.77273512 1.1886889953 -0.18868899533 -1.0042713 1.3116443406 0.09235565944 0.49154814 1.1800637903 0.33093620972 1.76135415 1.2630349856 -0.00703498562 -0.03744
F Significance F3.84504 0.051239194
P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%0.00999 0.5426110809 3.2411807 0.5426110809 3.2411807040.90476 -0.031231755 0.02791437 -0.031231755 0.0279143680.16581 -0.002617991 0.00050379 -0.002617991 0.000503791
Standard Residuals
5 10 15 20 25 30 35 40
-0.6-0.4-0.2
00.20.4
A5 Residual Plot
A5
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.6-0.4-0.2
00.20.4
Hvmax Residual Plot
Hvmax
Resid
uals
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
5 10 15 20 25 30 35 40
-0.6-0.4-0.2
00.20.4
A5 Residual Plot
A5
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.6-0.4-0.2
00.20.4
Hvmax Residual Plot
Hvmax
Resid
uals
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
A5 HV n33.2 263 1.44 SUMMARY OUTPUT
28 300 1.3278.4 527 1.193 Regression Statistics
14.8 544 0.96 Multiple R 0.77540081427.4 251 1.625 R Square 0.601246422
26 320 1.078 Adjusted R S 0.53478749233.6 244 1.635 Standard Err 0.1641558624.4 237 1.707 Observations 15
34 234 1.65829.2 268 1.317 ANOVA15.6 427 1.489 df SS MS14.8 510 1 Regression 2 0.48757557508 0.24378814.6 448 1.404 Residual 12 0.32336575825 0.026947
20 393 1.511 Total 14 0.8109413333321.6 469 1.256
Coefficients Standard Error t StatIntercept 2.851589805 0.60667502912 4.700358A5 -0.02043966 0.01284232479 -1.591586HV -0.00278011 0.00089410384 -3.109382
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.441824043 -0.00182404275 -0.0120022 1.445246181 -0.11824618076 -0.7780443 1.214778408 -0.0217784084 -0.1432994 1.03670271 -0.0767027097 -0.5046935 1.593735393 0.03126460686 0.2057176 1.430523288 -0.35252328837 -2.3195567 1.486470279 0.14852972056 0.9773068 1.693975919 0.01302408135 0.0856979 1.506095521 0.1519044788 0.999511
10 1.509682127 -0.19268212713 -1.26782211 1.345623916 0.14337608369 0.94339512 1.131226468 -0.13122646831 -0.86345213 1.307681254 0.0963187459 0.63376414 1.350213174 0.16078682591 1.05795615 1.106221318 0.14977868235 0.985524
F Significance F9.046887 0.004020014
P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%0.000514 1.529758468 4.17342114 1.5297584679 4.1734211420.137463 -0.04842068 0.00754136 -0.048420681 0.0075413630.009031 -0.0047282 -0.000832 -0.004728195 -0.000832026
Standard Residuals
5 10 15 20 25 30 35 40
-0.4-0.3-0.2-0.1
00.10.2
A5 Residual Plot
A5
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.2
HV Residual Plot
HV
Resid
uals
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
5 10 15 20 25 30 35 40
-0.4-0.3-0.2-0.1
00.10.2
A5 Residual Plot
A5
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.2
HV Residual Plot
HV
Resid
uals
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
Hvmax HV n334 263 1.44 SUMMARY OUTPUT326 300 1.327689 527 1.193 Regression Statistics665 544 0.96 Multiple R 0.744774818296 251 1.625 R Square 0.55468953381 320 1.078 Adjusted R 0.480471119334 244 1.635 Standard Err 0.173474462296 237 1.707 Observation 15296 234 1.658334 268 1.317 ANOVA494 427 1.489 df SS MS642 510 1 Regression 2 0.449820667246 0.2249103526 448 1.404 Residual 12 0.361120666087 0.0300934642 393 1.511 Total 14 0.810941333333561 469 1.256
Coefficients Standard Error t StatIntercept 1.913629017 0.151440919026 12.636142Hvmax 0.00098912 0.000982406531 1.0068341HV -0.00273161 0.001295863649 -2.107943
RESIDUAL OUTPUT
Observation Predicted n ResidualsStandard Residuals1 1.52558279 -0.08558278993 -0.5328742 1.416600398 -0.08960039813 -0.5578893 1.155576484 0.037423515732 0.23301424 1.08540029 -0.12540029045 -0.7807945 1.520775491 0.104224509496 0.64894476 1.416369894 -0.33836989418 -2.106837 1.577483307 0.057516692509 0.35812268 1.559017977 0.147982022875 0.9213979 1.567212796 0.090787204313 0.5652785
10 1.511924759 -0.194924759 -1.21368211 1.235858633 0.253141367189 1.576162412 1.155525133 -0.15552513254 -0.96836413 1.210146754 0.193853245604 1.207010214 1.475123056 0.035876943558 0.223384615 1.187402237 0.06859776294 0.4271179
F Significance F7.473746 0.007797896
P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%2.714E-08 1.5836675997 2.243590434 1.5836676 2.2435904340.333886 -0.00115136 0.0031296 -0.00115136 0.00312960.056739 -0.005555051 9.18382E-05 -0.00555505 9.183816E-05
Standard Residuals
250 300 350 400 450 500 550 600 650 700 750
-0.4-0.3-0.2-0.1
00.10.20.3
Hvmax Residual Plot
Hvmax
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
250 300 350 400 450 500 550 600 650 700 750
-0.4-0.3-0.2-0.1
00.10.20.3
Hvmax Residual Plot
Hvmax
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
Rm A5 Hvmax n458 33.2 334 1.44 SUMMARY OUTPUT565 28 326 1.327
1332 8.4 689 1.193 Regression Statistics1136 14.8 665 0.96 Multiple R 0.675667239
553 27.4 296 1.625 R Square 0.456526218591 26 381 1.078 Adjusted R S 0.308306096466 33.6 334 1.635 Standard Erro0.200164785558 24.4 296 1.707 Observations 15387 34 296 1.658550 29.2 334 1.317 ANOVA975 15.6 494 1.489 df SS
1052 14.8 642 1 Regression 3 0.37021598022945 14.6 526 1.404 Residual 11 0.44072535312802 20 642 1.511 Total 14 0.81094133333810 21.6 561 1.256
Coefficients Standard ErrorIntercept 3.106727835 1.21587676523Rm -0.00112176 0.00097078018A5 -0.03014107 0.02804965292Hvmax -0.00044643 0.00088236332
RESIDUAL OUTPUT
Observation Predicted n Residuals1 1.443169907 -0.00316990722 1.483446161 -0.1564461613 1.051765556 0.141234444274 1.089442643 -0.12944264345 1.528384759 0.096615240716 1.490009007 -0.41200900687 1.422139366 0.212860634448 1.613199164 0.093800836259 1.515666484 0.14233351563
10 1.460531921 -0.143531921311 1.322272661 0.1667273387512 1.193938619 -0.193938619113 1.371781017 0.0322189831414 1.317646022 0.1933539779415 1.296606712 -0.0406067123
MS F Significance F0.123405 3.080056 0.07234478790.040066
t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%2.555134 0.026749 0.4306011179 5.7828546 0.4306011179 5.782854551
-1.155528 0.272357 -0.003258437 0.0010149 -0.003258437 0.001014909-1.074561 0.305577 -0.091877945 0.0315958 -0.091877945 0.031595795-0.505944 0.622881 -0.002388495 0.0014956 -0.002388495 0.001495642
Standard Residuals-0.017866-0.8817490.796014
-0.7295540.544535
-2.3221311.1997070.5286720.802208
-0.8089630.939695
-1.0930610.18159
1.089766-0.228864
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
5 10 15 20 25 30 35 40
-0.6-0.4-0.2
00.20.4
A5 Residual Plot
A5
Resid
uals
200 400 600 800 1000 1200 1400
-0.6-0.4-0.2
00.20.4
Rm Residual Plot
Rm
Resid
uals
5 10 15 20 25 30 35 40
-0.6-0.4-0.2
00.20.4
A5 Residual Plot
A5
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.6-0.4-0.2
00.20.4
Hvmax Residual Plot
Hvmax
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
Rm Hvmax HV n458 334 263 1.44 SUMMARY OUTPUT565 326 300 1.327
1332 689 527 1.193 Regression Statistics1136 665 544 0.96 Multiple R 0.7744336
553 296 251 1.625 R Square 0.599747401591 381 320 1.078 Adjusted R S 0.490587602466 334 244 1.635 Standard Err 0.171777175558 296 237 1.707 Observations 15387 296 234 1.658550 334 268 1.317 ANOVA975 494 427 1.489 df SS
1052 642 510 1 Regression 3 0.48635995741945 526 448 1.404 Residual 11 0.32458137592802 642 393 1.511 Total 14 0.81094133333810 561 469 1.256
Coefficients Standard ErrorIntercept 1.973229475 0.15923681971Rm 0.00057757 0.00051902749Hvmax 0.000865891 0.00097907731HV -0.00392964 0.00167500187
RESIDUAL OUTPUT
Observation Predicted n Residuals1 1.493469045 -0.053469045072 1.402945276 -0.075945275623 1.268231988 -0.075231988344 1.067442919 -0.107442918665 1.562590055 0.062409944516 1.386993316 -0.30899331647 1.572752767 0.062247232678 1.620492867 0.086507133239 1.533517242 0.12448275793
10 1.526957325 -0.2099573254711 1.28615458 0.2028454198812 1.132619266 -0.1326192655513 1.214013542 0.1899864577514 1.447994529 0.0630054709315 1.083825282 0.17217471819
MS F Significance F0.16212 5.494215 0.014903301
0.029507
t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%12.39179 8.36E-08 1.622751598 2.32370735 1.6227515982 2.3237073521.112794 0.289524 -0.000564801 0.00171994 -0.000564801 0.0017199420.884395 0.395403 -0.001289044 0.00302083 -0.001289044 0.003020826-2.34605 0.038756 -0.007616294 -0.000243 -0.007616294 -0.000242986
Standard Residuals-0.35116-0.49877-0.49409-0.705630.409879-2.029320.4088110.5681380.817545
-1.37891.332194-0.870981.247742
0.413791.130763
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.20.3
Rm Residual Plot
Rm
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.4-0.3-0.2-0.1
00.10.20.3
Hvmax Residual Plot
Hvmax
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.20.3
Rm Residual Plot
Rm
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.4-0.3-0.2-0.1
00.10.20.3
Hvmax Residual Plot
Hvmax
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
Rm A5 HV n458 33.2 263 1.44 SUMMARY OUTPUT565 28 300 1.327
1332 8.4 527 1.193 Regression Statistics1136 14.8 544 0.96 Multiple R 0.77554714
553 27.4 251 1.625 R Square 0.60147337591 26 320 1.078 Adjusted R 0.49278429466 33.6 244 1.635 Standard Err 0.17140641558 24.4 237 1.707 Observation 15387 34 234 1.658550 29.2 268 1.317 ANOVA975 15.6 427 1.489 df SS
1052 14.8 510 1 Regression 3 0.48775961601945 14.6 448 1.404 Residual 11 0.32318171732802 20 393 1.511 Total 14 0.81094133333810 21.6 469 1.256
Coefficients Standard ErrorIntercept 2.91691469 1.04044251376Rm -0.0000733 0.00092606095A5 -0.0220276 0.02413224722HV -0.0027087 0.0012987215
RESIDUAL OUTPUT
Observation Predicted n Residuals1 1.43965242 0.000347576162 1.44613329 -0.11913329093 1.20679305 -0.01379304734 1.0341348 -0.0741347965 1.59295354 0.032046460536 1.43410976 -0.35610975977 1.48171949 0.1532805138 1.69659111 0.010408888019 1.50578524 0.15221475697
10 1.50747655 -0.19047655411 1.34522583 0.1437741731412 1.13238582 -0.13238581613 1.3125705 0.0914295037114 1.35307851 0.1579214940115 1.1113901 0.14460989849
MS F Significance F0.162587 5.53389 0.0145694519
0.02938
t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%2.803533 0.017166 0.626916157 5.20691322 0.626916157 5.2069132224-0.07915 0.938338 -0.002111541 0.00196495 -0.00211154 0.0019649522-0.91279 0.380925 -0.075142338 0.0310871 -0.07514234 0.0310870983-2.08563 0.0611 -0.005567123 0.00014981 -0.00556712 0.0001498107
Standard Residuals0.002288
-0.7841-0.09078-0.487940.210921-2.343821.0088520.0685091.001838-1.253670.946284-0.871330.6017651.0393980.951785
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.2
Rm Residual Plot
Rm
Resid
uals
5 10 15 20 25 30 35 40
-0.4-0.3-0.2-0.1
00.10.2
A5 Residual Plot
A5
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.2
HV Residual Plot
HV
Resid
uals
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.2
Rm Residual Plot
Rm
Resid
uals
5 10 15 20 25 30 35 40
-0.4-0.3-0.2-0.1
00.10.2
A5 Residual Plot
A5
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.2
HV Residual Plot
HV
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
A5 Hvmax HV n33.2 334 263 1.44 SUMMARY OUTPUT
28 326 300 1.3278.4 689 527 1.193 Regression Statistics
14.8 665 544 0.96 Multiple R 0.795677524327.4 296 251 1.625 R Square 0.6331027227
26 381 320 1.078 Adjusted R 0.533039828933.6 334 244 1.635 Standard Err0.164463913524.4 296 237 1.707 Observation 15
34 296 234 1.65829.2 334 268 1.317 ANOVA15.6 494 427 1.489 df SS14.8 642 510 1 Regression 3 0.5134091660814.6 526 448 1.404 Residual 11 0.29753216725
20 642 393 1.511 Total 14 0.8109413333321.6 561 469 1.256
Coefficients Standard ErrorIntercept 2.8205098876 0.60864492564A5 -0.019756775 0.01288538475Hvmax 0.0009115649 0.00093275122HV -0.003880944 0.00143918207
RESIDUAL OUTPUT
Observation Predicted n Residuals1 1.4483592346 -0.008359234562 1.4002070006 -0.073207000573 1.2373634578 -0.044363457764 1.0230664832 -0.063066483225 1.5748803977 0.05011960236 1.4122377311 -0.334237731057 1.5141944695 0.120805530528 1.6884839457 0.01851605439 1.5104617378 0.14753826216
10 1.5079816127 -0.1909816127411 1.305453968 0.1835460320412 1.1340526025 -0.134052602513 1.2728809861 0.1311190139314 1.485387875 0.0256121249815 1.0849884978 0.17101150218
MS F Significance F0.171136 6.327048 0.00943166370.027048
t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%4.634081 0.000724 1.4808914385 4.16012834 1.480891438 4.160128337-1.53327 0.153452 -0.048117316 0.00860377 -0.04811732 0.0086037650.977286 0.349431 -0.001141407 0.00296454 -0.00114141 0.002964536-2.69663 0.020781 -0.007048563 -0.0007133 -0.00704856 -0.000713326
Standard Residuals-0.05734-0.50217-0.30431-0.432610.343799-2.292730.8286740.1270121.012049-1.310051.259047-0.919540.89942
0.1756881.173066
5 10 15 20 25 30 35 40
-0.4-0.3-0.2-0.1
00.10.20.3
A5 Residual Plot
A5
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.4-0.3-0.2-0.1
00.10.20.3
Hvmax Residual Plot
Hvmax
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
5 10 15 20 25 30 35 40
-0.4-0.3-0.2-0.1
00.10.20.3
A5 Residual Plot
A5
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.4-0.3-0.2-0.1
00.10.20.3
Hvmax Residual Plot
Hvmax
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
Rm A5 Hvmax HV n458 33.2 334 263 1.44565 28 326 300 1.327 SUMMARY OUTPUT
1332 8.4 689 527 1.1931136 14.8 665 544 0.96 Regression Statistics
553 27.4 296 251 1.625 Multiple R 0.7965478558591 26 381 320 1.078 R Square 0.6344884866466 33.6 334 244 1.635 Adjusted R 0.4882838813558 24.4 296 237 1.707 Standard Err0.1721651515387 34 296 234 1.658 Observation 15550 29.2 334 268 1.317975 15.6 494 427 1.489 ANOVA
1052 14.8 642 510 1 df945 14.6 526 448 1.404 Regression 4802 20 642 393 1.511 Residual 10810 21.6 561 469 1.256 Total 14
CoefficientsIntercept 2.982357258Rm -0.00018249A5 -0.023692939Hvmax 0.0009350492HV -0.003731395
RESIDUAL OUTPUT
Observation Predicted n1 1.44312062952 1.40125542793 1.2180630914 1.01632150095 1.57244795766 1.42069636217 1.50308003738 1.69485385339 1.5098016823
10 1.502446293611 1.303427906912 1.137011993813 1.284157836514 1.496004533515 1.0973108939
SS MS F Significance F0.51453293933 0.128633 4.33973 0.02722047260.29640839401 0.0296410.81094133333
Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%1.04731418531 2.847624 0.01732 0.6487958315 5.31591868 0.648795831 5.315918685
0.0009372294 -0.19471 0.849517 -0.002270768 0.00190579 -0.00227077 0.0019057870.02430232221 -0.97492 0.352591 -0.077841887 0.03045601 -0.07784189 0.0304560090.00098384932 0.950399 0.364314 -0.001257104 0.0031272 -0.0012571 0.0031272020.00169105526 -2.20655 0.051863 -0.007499301 3.6511E-05 -0.0074993 3.651084E-05
ResidualsStandard Residuals-0.00312062947 -0.02145-0.07425542794 -0.51033-0.02506309104 -0.17225-0.05632150085 -0.387070.05255204242 0.361167
-0.34269636208 -2.35520.13191996272 0.9066280.01214614671 0.0834750.14819831771 1.018502
-0.18544629357 -1.274490.18557209311 1.275356
-0.13701199381 -0.941620.11984216353 0.8236230.01499546649 0.1030570.15868910606 1.090601
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.20.3
Rm Residual Plot
Rm
Resid
uals
200 400 600 800 1000 1200 1400
-0.4-0.3-0.2-0.1
00.10.20.3
Rm Residual Plot
Rm
Resid
uals
5 10 15 20 25 30 35 40
-0.4-0.3-0.2-0.1
00.10.20.3
A5 Residual Plot
A5
Resid
uals
250 300 350 400 450 500 550 600 650 700 750
-0.4-0.3-0.2-0.1
00.10.20.3
Hvmax Residual Plot
Hvmax
Resid
uals
200 250 300 350 400 450 500 550 600
-0.4-0.3-0.2-0.1
00.10.20.3
HV Residual Plot
HV
Resid
uals
200 400 600 800 1000 1200 14000
0.51
1.52
Rm Line Fit Plot
nPredicted n
Rm
n
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
5 10 15 20 25 30 35 400
0.51
1.52
A5 Line Fit Plot
nPredicted n
A5
n
250300
350400
450500
550600
650700
7500
0.51
1.52
Hvmax Line Fit Plot
nPredicted n
Hvmax
n
200 250 300 350 400 450 500 550 6000
0.51
1.52
HV Line Fit Plot
nPredicted n
HV
n
1. nezavisno promjenljiva a b1Rm 1.75632 -0.000514A5 1.010411 0.015752HVmax 1.819097 -0.000981HV 1.91334 -0.00149
2.nezavisno promjenljive a b1 b2Rm;A5 3.186587 -0.001416 -0.0328952842Rm;HVmax 1.812656 -0.000205 -0.0006304381Rm;HV 1.978337 0.000629 -0.0029646245A5;Hvmax 1.891896 -0.001659 -0.0010571001A5;HV 2.85159 -0.02044 -0.0027801105Hvmax;HV 1.913629 0.000989 -0.0027316062
3.nezavisno promjenljive a b1 b2 b3Rm;A5;Hvmax 3.106728 -0.001122 -0.0301410748 -0.000446Rm;Hvmax;HV 1.973229 0.000578 0.0008658911 -0.00393Rm;A5;HV 2.916915 -0.000073 -0.0220276197 -0.002709A5;Hvmax;HV 2.82051 -0.019757 0.0009115649 -0.003881
4.nezavisno promjenljive a b1 b2 b3 b4Rm;A5;Hvmax;HV 2.982357 -0.000182 -0.0236929389 0.000935 -0.003731
Rezultati analize varijanse
Redni broj Uključene varijableRegresiona Rezidualna Koeficijent Koeficijentsuma kvadrata suma kvadrata determinacije korelacije
1 Rm 0.3026986341241 0.508242699209 0.37326822753 0.610956812 A5 0.2270436240405 0.583897709293 0.27997539983 0.529127023 HVmax 0.316103041283 0.49483829205 0.34285902796 0.624337784 HV 0.4193145526541 0.391626780679 0.51707137794 0.719076755 Rm;A5 0.3599599381263 0.450981395207 0.44387913568 0.666242556 Rm;HVmax 0.3239525496118 0.486988783722 0.39947717091 0.632042067 Rm;HV 0.4632806140688 0.347660719264 0.57128745943 0.75583568 A5;Hvmax 0.3167181067575 0.494223226576 0.39055612748 0.62494499 A5;HV 0.4875755750824 0.323365758251 0.60124642196 0.77540081
10 Hvmax;HV 0.4498206672459 0.361120666087 0.55468953025 0.7447748211 Rm;A5;Hvmax 0.3702159802163 0.440725353117 0.45652621836 0.6756672412 Rm;Hvmax;HV 0.4863599574092 0.324581375924 0.59974740147 0.774433613 Rm;A5;HV 0.4877596160147 0.323181717319 0.60147336924 0.7755471414 A5;Hvmax;HV 0.5134091660805 0.297532167253 0.6331027227 0.7956775215 Rm;A5;Hvmax;HV 0.5145329393263 0.296408394007 0.63448848662 0.79654786
0.00138576393
Standardnagreška0.1977260540.2119320840.1951012150.1735659440.1938602150.201450735
0.170210830.202941541
0.164155860.1734744620.2001647850.1717771750.1714064060.1644639130.172165152