469,207518796993 | 6753,22105263158 | ||||||||||||||
t | Y8 | trend | Y/trend | IErrorI | |||||||||||
95 | 1 | 1 | 6970 | 7222,42857142857 | 0,965049350238345 | 0,965049350238345 | 0,940127511108943 | 6790,00379701926 | 179,996202980741 | 179,996 | |||||
2 | 2 | 8487 | 7691,63609022556 | 1,10340633649909 | 1,10340633649909 | 1,06949102335404 | 8226,13575340217 | 260,864246597834 | 260,864 | ||||||
3 | 3 | 9519 | 8322,375 | 8160,84360902256 | 1,16642352874841 | 1,16642352874841 | 1,09849181621232 | 8964,6199178999 | 554,380082100104 | 554,380 | |||||
4 | 4 | 7575 | 8742,500 | 8630,05112781955 | 0,877746827661482 | 0,877746827661482 | 0,891889649324702 | 7697,05327404523 | -122,053274045227 | 122,053 | |||||
96 | 5 | 1 | 8447 | 9186,625 | 9099,25864661654 | 0,928317385849991 | 0,928317385849991 | 0,940127511108943 | 8554,46338438014 | -107,463384380137 | 107,463 | ||||
6 | 2 | 10371 | 9565,750 | 9568,46616541353 | 1,08387277759181 | 1,08387277759181 | 1,06949102335404 | 10233,3886711766 | 137,611328823421 | 137,611 | |||||
7 | 3 | 11188 | 9879,625 | 10037,6736842105 | 1,11460088781318 | 1,11460088781318 | 1,09849181621232 | 11026,302395915 | 161,697604084966 | 161,698 | |||||
8 | 4 | 8939 | 10202,125 | 10506,8812030075 | 0,850775775159738 | 0,850775775159738 | 0,891889649324702 | 9370,97859164668 | -431,978591646681 | 431,979 | |||||
97 | 9 | 1 | 9594 | 10600,250 | 10976,0887218045 | 0,874081855856456 | 0,874081855856456 | 0,940127511108943 | 10318,922971741 | -724,922971741011 | 724,923 | ||||
10 | 2 | 11804 | 11065,000 | 11445,2962406015 | 1,03134071428628 | 1,03134071428628 | 1,06949102335404 | 12240,641588951 | -436,64158895099 | 436,642 | |||||
11 | 3 | 12940 | 11636,625 | 11914,5037593985 | 1,08607125074702 | 1,08607125074702 | 1,09849181621232 | 13087,9848739302 | -147,984873930174 | 147,985 | |||||
12 | 4 | 10905 | 12241,000 | 12383,7112781955 | 0,880592235641094 | 0,880592235641094 | 0,891889649324702 | 11044,9039092481 | -139,903909248134 | 139,904 | |||||
98 | 13 | 1 | 12201 | 12727,000 | 12852,9187969925 | 0,949278540750991 | 0,949278540750991 | 0,940127511108943 | 12083,3825591019 | 117,617440898113 | 117,617 | ||||
14 | 2 | 14032 | 13169,250 | 13322,1263157895 | 1,05328531402447 | 1,05328531402447 | 1,06949102335404 | 14247,8945067254 | -215,894506725401 | 215,895 | |||||
15 | 3 | 14600 | 13698,750 | 13791,3338345865 | 1,05863581979181 | 1,05863581979181 | 1,09849181621232 | 15149,6673519453 | -549,667351945312 | 549,667 | |||||
16 | 4 | 12783 | 14292,625 | 14260,5413533835 | 0,896389532713434 | 0,896389532713434 | 0,891889649324702 | 12718,8292268496 | 64,1707731504139 | 64,171 | |||||
99 | 17 | 1 | 14559 | 14866,250 | 14729,7488721805 | 0,988407889797569 | 0,988407889797569 | 0,940127511108943 | 13847,8421464628 | 711,157853537236 | 711,158 | ||||
18 | 2 | 16425 | 15198,9563909774 | 1,08066630217785 | 1,08066630217785 | 1,06949102335404 | 16255,1474244998 | 169,852575500185 | 169,853 | ||||||
19 | 3 | 16796 | 15668,1639097744 | 1,07198265838424 | 1,07198265838424 | 1,09849181621232 | 17211,3498299605 | -415,349829960451 | 415,350 | ||||||
20 | 4 | 15463 | 16137,3714285714 | 0,958210577753856 | 0,958210577753856 | 0,891889649324702 | 14392,754544451 | 1070,24545554896 | 1070,245 | ||||||
21 | 16606,5789473684 | 0,94102700449867 | 1,0705142889159 | 1,09954282909693 | 0,892742989785921 | 1,00095677807436 | 0,940127511108943 | 15612,3017338236 | MAE | ||||||
22 | 17075,7864661654 | 0,940127511108943 | 1,06949102335404 | 1,09849181621232 | 0,891889649324702 | 1 | 1,06949102335404 | 18262,4003422742 | 335,973 | ||||||
23 | 17544,9939849624 | 1,09849181621232 | 19273,0323079756 | ||||||||||||
24 | 18014,2015037594 | 0,891889649324702 | 16066,6798620525 | ||||||||||||
PODSUMOWANIE - WYJŚCIE | |||||||||||||||
Statystyki regresji | |||||||||||||||
Wielokrotność R | 0,858124760032986 | ||||||||||||||
R kwadrat | 0,736378103781669 | ||||||||||||||
Dopasowany R kwadrat | 0,721732442880651 | ||||||||||||||
Błąd standardowy | 589,623022557768 | ||||||||||||||
Obserwacje | 20 | ||||||||||||||
ANALIZA WARIANCJI | |||||||||||||||
df | SS | MS | F | Istotność F | |||||||||||
Regresja | 1 | 17479972,9928571 | 17479972,9928571 | 50,2796090090045 | 1,30639230849259E-06 | ||||||||||
Resztkowy | 18 | 6257795,55714286 | 347655,308730159 | ||||||||||||
Razem | 19 | 23737768,55 | |||||||||||||
Współczynniki | Błąd standardowy | t Stat | Wartość-p | Dolne 95% | Górne 95% | Dolne 95,0% | Górne 95,0% | ||||||||
Przecięcie | 284,800000000001 | 273,89844120477 | 1,03980146344492 | 0,312198508851992 | -290,639270989026 | 860,239270989027 | -290,639270989026 | 860,239270989027 | |||||||
Zmienna X 1 | 162,128571428571 | 22,8646001045303 | 7,09081159029095 | 1,30639230849259E-06 | 114,091829204945 | 210,165313652198 | 114,091829204945 | 210,165313652198 | |||||||
469,207518796993 | 6753,22105263158 | |||||||||||||||
t | Y8 | trend | Y-trend | IErrorI | ||||||||||||
95 | 1 | 1 | 6970 | 7222,42857142857 | -252,428571428571 | -252,428571428571 | -621,888721804511 | 6600,53984962406 | 369,46015037594 | 369,460 | ||||||
2 | 2 | 8487 | 7691,63609022556 | 795,363909774436 | 795,363909774436 | 778,503759398496 | 8470,13984962406 | 16,8601503759401 | 16,860 | |||||||
3 | 3 | 9519 | 8322,375 | 8160,84360902256 | 1358,15639097744 | 1358,15639097744 | 1094,0962406015 | 9254,93984962406 | 264,060150375941 | 264,060 | ||||||
4 | 4 | 7575 | 8742,500 | 8630,05112781955 | -1055,05112781955 | -1055,05112781955 | -1250,71127819549 | 7379,33984962406 | 195,660150375941 | 195,660 | ||||||
96 | 5 | 1 | 8447 | 9186,625 | 9099,25864661654 | -652,258646616541 | -652,258646616541 | -621,888721804511 | 8477,36992481203 | -30,3699248120301 | 30,370 | |||||
6 | 2 | 10371 | 9565,750 | 9568,46616541353 | 802,533834586466 | 802,533834586466 | 778,503759398496 | 10346,969924812 | 24,0300751879695 | 24,030 | ||||||
7 | 3 | 11188 | 9879,625 | 10037,6736842105 | 1150,32631578947 | 1150,32631578947 | 1094,0962406015 | 11131,769924812 | 56,2300751879702 | 56,230 | ||||||
8 | 4 | 8939 | 10202,125 | 10506,8812030075 | -1567,88120300752 | -1567,88120300752 | -1250,71127819549 | 9256,16992481203 | -317,169924812029 | 317,170 | ||||||
97 | 9 | 1 | 9594 | 10600,250 | 10976,0887218045 | -1382,08872180451 | -1382,08872180451 | -621,888721804511 | 10354,2 | -760,199999999999 | 760,200 | |||||
10 | 2 | 11804 | 11065,000 | 11445,2962406015 | 358,703759398497 | 358,703759398497 | 778,503759398496 | 12223,8 | -419,799999999999 | 419,800 | ||||||
11 | 3 | 12940 | 11636,625 | 11914,5037593985 | 1025,4962406015 | 1025,4962406015 | 1094,0962406015 | 13008,6 | -68,6000000000004 | 68,600 | ||||||
12 | 4 | 10905 | 12241,000 | 12383,7112781955 | -1478,71127819549 | -1478,71127819549 | -1250,71127819549 | 11133 | -228 | 228,000 | ||||||
98 | 13 | 1 | 12201 | 12727,000 | 12852,9187969925 | -651,918796992481 | -651,918796992481 | -621,888721804511 | 12231,030075188 | -30,0300751879695 | 30,030 | |||||
14 | 2 | 14032 | 13169,250 | 13322,1263157895 | 709,873684210528 | 709,873684210528 | 778,503759398496 | 14100,630075188 | -68,630075187968 | 68,630 | ||||||
15 | 3 | 14600 | 13698,750 | 13791,3338345865 | 808,666165413535 | 808,666165413535 | 1094,0962406015 | 14885,430075188 | -285,430075187969 | 285,430 | ||||||
16 | 4 | 12783 | 14292,625 | 14260,5413533835 | -1477,54135338346 | -1477,54135338346 | -1250,71127819549 | 13009,830075188 | -226,830075187969 | 226,830 | ||||||
99 | 17 | 1 | 14559 | 14866,250 | 14729,7488721805 | -170,748872180451 | -170,748872180451 | -621,888721804511 | 14107,8601503759 | 451,13984962406 | 451,140 | |||||
18 | 2 | 16425 | 15198,9563909774 | 1226,04360902256 | 1226,04360902256 | 778,503759398496 | 15977,4601503759 | 447,53984962406 | 447,540 | |||||||
19 | 3 | 16796 | 15668,1639097744 | 1127,83609022557 | 1127,83609022557 | 1094,0962406015 | 16762,2601503759 | 33,7398496240639 | 33,740 | |||||||
20 | 4 | 15463 | 16137,3714285714 | -674,371428571427 | -674,371428571427 | -1250,71127819549 | 14886,6601503759 | 576,339849624063 | 576,340 | |||||||
21 | 16606,5789473684 | -621,888721804511 | 778,503759398497 | 1094,0962406015 | -1250,71127819549 | 5,96855898038484E-13 | -621,888721804511 | 15984,6902255639 | MAE | |||||||
22 | 17075,7864661654 | -621,888721804511 | 778,503759398496 | 1094,0962406015 | -1250,71127819549 | 0 | 778,503759398496 | 17854,2902255639 | 243,506 | |||||||
23 | 17544,9939849624 | 1094,0962406015 | 18639,0902255639 | |||||||||||||
24 | 18014,2015037594 | -1250,71127819549 | 16763,4902255639 | |||||||||||||
PODSUMOWANIE - WYJŚCIE | ||||||||||||||||
Statystyki regresji | ||||||||||||||||
Wielokrotność R | 0,858124760032986 | |||||||||||||||
R kwadrat | 0,736378103781669 | |||||||||||||||
Dopasowany R kwadrat | 0,721732442880651 | |||||||||||||||
Błąd standardowy | 589,623022557768 | |||||||||||||||
Obserwacje | 20 | |||||||||||||||
ANALIZA WARIANCJI | ||||||||||||||||
df | SS | MS | F | Istotność F | ||||||||||||
Regresja | 1 | 17479972,9928571 | 17479972,9928571 | 50,2796090090045 | 1,30639230849259E-06 | |||||||||||
Resztkowy | 18 | 6257795,55714286 | 347655,308730159 | |||||||||||||
Razem | 19 | 23737768,55 | ||||||||||||||
Współczynniki | Błąd standardowy | t Stat | Wartość-p | Dolne 95% | Górne 95% | Dolne 95,0% | Górne 95,0% | |||||||||
Przecięcie | 284,800000000001 | 273,89844120477 | 1,03980146344492 | 0,312198508851992 | -290,639270989026 | 860,239270989027 | -290,639270989026 | 860,239270989027 | ||||||||
Zmienna X 1 | 162,128571428571 | 22,8646001045303 | 7,09081159029095 | 1,30639230849259E-06 | 114,091829204945 | 210,165313652198 | 114,091829204945 | 210,165313652198 | ||||||||
475,34375 | -612,684375 | 781,571875 | 1091,028125 | 6688,790625 | |||||||||||||||
1091,028125 | 781,571875 | -612,684375 | 475,34375 | 6688,790625 | |||||||||||||||
Y8 | t | V1t -V4t | V2t -V4t | V3t -V4t | WART. TEORET | MODUŁ BŁĘDU | PODSUMOWANIE - WYJŚCIE | ||||||||||||
95 | 1 | 6970 | 1 | 1 | 0 | 0 | 6551,45 | 418,550000000002 | 418,550 | ||||||||||
2 | 8487 | 2 | 0 | 1 | 0 | 8421,05 | 65,9500000000007 | 65,950 | Statystyki regresji | ||||||||||
3 | 9519 | 3 | 0 | 0 | 1 | 9205,85 | 313,150000000001 | 313,150 | Wielokrotność R | 0,994060583623255 | |||||||||
4 | 7575 | 4 | -1 | -1 | -1 | 7330,25 | 244,750000000002 | 244,750 | R kwadrat | 0,988156443913407 | |||||||||
96 | 1 | 8447 | 5 | 1 | 0 | 0 | 8452,825 | -5,82499999999891 | 5,825 | Dopasowany R kwadrat | 0,984998162290315 | ||||||||
2 | 10371 | 6 | 0 | 1 | 0 | 10322,425 | 48,5750000000007 | 48,575 | Błąd standardowy | 364,230430725752 | |||||||||
3 | 11188 | 7 | 0 | 0 | 1 | 11107,225 | 80,7750000000015 | 80,775 | Obserwacje | 20 | |||||||||
4 | 8939 | 8 | -1 | -1 | -1 | 9231,625 | -292,625 | 292,625 | |||||||||||
97 | 1 | 9594 | 9 | 1 | 0 | 0 | 10354,2 | -760,199999999999 | 760,200 | ANALIZA WARIANCJI | |||||||||
2 | 11804 | 10 | 0 | 1 | 0 | 12223,8 | -419,799999999999 | 419,800 | df | SS | MS | F | Istotność F | ||||||
3 | 12940 | 11 | 0 | 0 | 1 | 13008,6 | -68,5999999999985 | 68,600 | Regresja | 4 | 166030279,85 | 41507569,9625 | 312,877875325805 | 2,99207510339172E-14 | |||||
4 | 10905 | 12 | -1 | -1 | -1 | 11133 | -228 | 228,000 | Resztkowy | 15 | 1989957,1 | 132663,806666667 | |||||||
98 | 1 | 12201 | 13 | 1 | 0 | 0 | 12255,575 | -54,5749999999989 | 54,575 | Razem | 19 | 168020236,95 | |||||||
2 | 14032 | 14 | 0 | 1 | 0 | 14125,175 | -93,1750000000011 | 93,175 | |||||||||||
3 | 14600 | 15 | 0 | 0 | 1 | 14909,975 | -309,975 | 309,975 | Współczynniki | Błąd standardowy | t Stat | Wartość-p | Dolne 95% | Górne 95% | Dolne 95,0% | Górne 95,0% | |||
4 | 12783 | 16 | -1 | -1 | -1 | 13034,375 | -251,375 | 251,375 | Przecięcie | 7185,43125 | 171,716638400726 | 41,8447001811888 | 5,97844540894673E-17 | 6819,42590081294 | 7551,43659918706 | 6819,42590081294 | 7551,43659918706 | ||
99 | 1 | 14559 | 17 | 1 | 0 | 0 | 14156,95 | 402,049999999999 | 402,050 | t | 476,4875 | 14,3974719279694 | 33,095219937491 | 1,94610666398445E-15 | 445,800015144222 | 507,174984855778 | 445,800015144222 | 507,174984855778 | |
2 | 16425 | 18 | 0 | 1 | 0 | 16026,55 | 398,449999999999 | 398,450 | V1t -V4t | -619,81875 | 142,709380193849 | -4,34322361401942 | 0,000579238034641 | -923,996592150782 | -315,640907849218 | -923,996592150782 | -315,640907849218 | ||
3 | 16796 | 19 | 0 | 0 | 1 | 16811,35 | -15,3500000000022 | 15,350 | V2t -V4t | 779,29375 | 141,249399288914 | 5,51714735725011 | 5,91241726202017E-05 | 478,227783471136 | 1080,35971652886 | 478,227783471136 | 1080,35971652886 | ||
4 | 15463 | 20 | -1 | -1 | -1 | 14935,75 | 527,249999999998 | 527,250 | V3t -V4t | 1095,60625 | 141,249399288914 | 7,75653741195051 | 1,25729715339153E-06 | 794,540283471136 | 1396,67221652886 | 794,540283471136 | 1396,67221652886 | ||
21 | 1 | 0 | 0 | 16058,325 | MAE | ||||||||||||||
22 | 0 | 1 | 0 | 17927,925 | 249,950 | ||||||||||||||
23 | 0 | 0 | 1 | 18712,725 | |||||||||||||||
24 | -1 | -1 | -1 | 16837,125 | |||||||||||||||