Tõenäosusteooria ja matemaatilise statistika kodutöö (3)

Overview

algandmed
minu andmed
tabelid
valjund
usaldusvahemik
Diagramm
regressioon

Sheet 1: algandmed

Jrk HARIDUS SUGU ASULA TULU KULU PALK 1 4 1 2 240.40 817.51 1,000.00 2 2 1 1 708.29 674.66 2,000.00 3 4 1 1 725.00 754.21 3,500.00 4 5 1 1 800.00 641.75 1,600.00 5 3 1 2 880.82 1,351.81 2,000.00 6 5 2 2 908.63 709.14 1,700.00 7 3 2 1 1,035.67 818.93 2,115.00 8 4 2 2 1,050.84 917.61 1,428.00 9 5 1 1 1,119.87 1,429.05 4,500.00 10 5 2 1 1,370.20 1,011.09 2,780.00 11 5 1 1 1,383.33 925.63 1,800.00 12 6 2 2 1,414.59 914.67 2,700.00 13 5 1 1 1,593.33 1,100.67 5,130.00 14 5 1 1 1,663.33 1,064.77 3,200.00 15 5 1 1 1,664.17 1,596.55 4,595.00 16 6 2 1 1,869.33 1,394.66 5,608.00 17 5 1 1 1,894.00 1,508.87 4,552.00 18 3 2 1 1,972.50 1,956.39 1,814.00 19 6 1 1 2,364.33 2,864.48 4,000.00 20 6 1 1 2,493.75 2,907.01 5,400.00 21 3 1 2 2,562.44 1,938.39 2,600.00 22 5 1 1 2,750.00 2,391.02 4,500.00 23 3 1 1 3,000.00 6,840.31 3,000.00 24 5 1 1 3,007.47 3,136.87 2,500.00 25 6 1 1 3,276.90 2,393.62 6,094.00 26 5 1 1 3,279.52 2,203.85 6,080.00 27 3 2 1 3,586.26 4,082.08 2,620.00 28 3 2 2 3,809.38 3,927.17 6,392.00 29 5 1 1 4,000.00 3,705.48 4,000.00 30 6 1 1 4,483.33 4,010.36 7,400.00 31 3 1 1 5,000.00 4,987.98 5,000.00 32 6 2 2 5,341.00 2,395.21 3,849.00 33 6 1 1 7,972.00 6,770.87 25,700.00 34 6 1 1 12,937.34 6,154.91 13,996.00 35 6 1 1 26,325.00 21,023.27 52,650.00

Sheet 2: minu andmed

Jrk HARIDUS SUGU ASULA TULU KULU PALK 1 1 1 2 243.40 820.51 1,000.00 2 1 1 1 711.29 677.66 2,000.00 3 1 1 1 728.00 757.21 3,500.00 4 1 1 1 803.00 644.75 1,600.00 5 1 1 2 883.82 1,354.81 2,000.00 6 1 2 2 911.63 712.14 1,700.00 7 1 2 1 1,038.67 821.93 2,115.00 8 1 2 2 1,053.84 920.61 1,428.00 9 1 1 1 1,122.87 1,432.05 4,500.00 10 1 2 1 1,373.20 1,014.09 2,780.00 11 1 1 1 1,386.33 928.63 1,800.00 12 2 2 2 1,417.59 917.67 2,700.00 13 1 1 1 1,596.33 1,103.67 5,130.00 14 1 1 1 1,666.33 1,067.77 3,200.00 15 1 1 1 1,667.17 1,599.55 4,595.00 16 2 2 1 1,872.33 1,397.66 5,608.00 17 1 1 1 1,897.00 1,511.87 4,552.00 18 1 2 1 1,975.50 1,959.39 1,814.00 19 2 1 1 2,367.33 2,867.48 4,000.00 20 2 1 1 2,496.75 2,910.01 5,400.00 21 1 1 2 2,565.44 1,941.39 2,600.00 22 1 1 1 2,753.00 2,394.02 4,500.00 23 1 1 1 3,003.00 6,843.31 3,000.00 24 1 1 1 3,010.47 3,139.87 2,500.00 25 2 1 1 3,279.90 2,396.62 6,094.00 26 1 1 1 3,282.52 2,206.85 6,080.00 27 1 2 1 3,589.26 4,085.08 2,620.00 28 1 2 2 3,812.38 3,930.17 6,392.00 29 1 1 1 4,003.00 3,708.48 4,000.00 30 2 1 1 4,486.33 4,013.36 7,400.00 31 1 1 1 5,003.00 4,990.98 5,000.00 32 2 2 2 5,344.00 2,398.21 3,849.00 33 2 1 1 7,975.00 6,773.87 25,700.00 34 2 1 1 12,940.34 6,157.91 13,996.00 35 2 1 1 26,328.00 21,026.27 52,650.00
Keskmised: 3,388.23 2,897.88 5,937.23
Standardhälve: 4588.5343893307 3553.2884794987 9101.4903115156

Sheet 3: tabelid

Valimkeskmiste arvutamine
Tabel 1
Tulu Kulu Palk Leibkonnapea on kõrgharidusega 6850.757 5085.906 12739.7 Leibkonnapea on muu haridusega 2003.218 2022 .6716 3216.24 Kõik Leibkonnad 3,388.23 2,897.88 5,937.23
Tabel 2
Tulu Kulu Palk Leibkonnapea on mees 3847.9848 3330.756 7071.88 Leibkonnapea on naine 2238.84 1815.695 3100 .6 Kõik Leibkonnad 3,388.23 2,897.88 5,937.23
Tabel 3
Tulu Kulu Palk Leibkonnapea elab linnas 3790.96 3275.1977777778 6893.8518518519 Leibkonnapea elab maal 2029.0125 1624.43875 2708.625 Kõik Leibkonnad 3,388.23 2,897.88 5,937.23

Sheet 4: valjund

SUMMARY OUTPUT


Regression Statistics
Multiple R 0.9484228769
R Square 0.8995059534
Adjusted R Square 0.8964606792
Standard Error 1160.0526146352
Observations 35

ANOVA

df SS MS F Significance F
Regression 1 397496237.381002 397496237.381002 295.3776612718 4.96970831766134E-018
Residual 33 44408828.2678262 1345722.06872201
Total 34 441905065.648829


Coefficients Standard Error t Stat P- value Lower 95% Upper 95% Lower 95,0% Upper 95,0% Intercept 429.6002289878 245.692413075 1.7485286729 0.0896708332 -70.2647413676 929.4651993431 -70.2647413676 929.4651993431 X Variable 1 0.7344436799 0.0427336191 17.1865546655 4.96970831766142E-018 0.6475014786 0.8213858811 0.6475014786 0.8213858811

Sheet 5: usaldusvahemik

90% Usaldusvahemik
Alumine piir
Ülemine piir Tulu: 2,112.47 ; 4,663.98 Kulu: 1909.957050032 ; 3885.8058071108 Palk: 3406.7320435882 ; 8467.7250992689

Sheet 6: Diagramm

Sheet 7: regressioon

x y x*y x^2
TULU KULU KULU*TULU KULU^2
243.40 820.51 199712.134 59,243.56
711.29 677.66 482012.7814 505,933.46
728.00 757.21 551248.88 529,984.00
803.00 644.75 517734.25 644,809.00
883.82 1,354.81 1197408.1742 781,137.79
911.63 712.14 649208.1882 831,069.26
1,038.67 821.93 853714.0331 1,078,835.37
1,053.84 920.61 970175.6424 1,110,578.75
1,122.87 1,432.05 1608005.9835 1,260,837.04
1,373.20 1,014.09 1392548.388 1,885,678.24
1,386.33 928.63 1287387.6279 1,921,910.87
1,417.59 917.67 1300879.8153 2,009,561.41
1,596.33 1,103.67 1761821.5311 2,548,269.47
1,666.33 1,067.77 1779257.1841 2,776,655.67
1,667.17 1,599.55 2666721.7735 2,779,455.81
1,872.33 1,397.66 2616880.7478 3,505,619.63
1,897.00 1,511.87 2868017.39 3,598,609.00
1,975.50 1,959.39 3870774.945 3,902,600.25
2,367.33 2,867.48 6788271.4284 5,604,251.33
2,496.75 2,910.01 7265567.4675 6,233,760.56
2,565.44 1,941.39 4980519.5616 6,581,482.39
2,753.00 2,394.02 6590737.06 7,579,009.00
3,003.00 6,843.31 20550459.93 9,018,009.00
3,010.47 3,139.87 9452484.4389 9,062,929.62
3,279.90 2,396.62 7860673.938 10,757,744.01
3,282.52 2,206.85 7244029.262 10,774,937.55
3,589.26 4,085.08 14662414.2408 12,882,787.35
3,812.38 3,930.17 14983301.5046 14,534,241.26
4,003.00 3,708.48 14845045.44 16,024,009.00
4,486.33 4,013.36 18005257.3688 20,127,156.87
5,003.00 4,990.98 24969872.94 25,030,009.00
5,344.00 2,398.21 12816034.24 28,558,336.00
7,975.00 6,773.87 54021613.25 63,600,625.00
12,940.34 6,157.91 79685449.0894 167,452,399.32
26,328.00 21,026.27 553579636.56 693,163,584.00 Summa: 118,588.02 101,425.85 884,874,877.19 1,138,716,059.83

b1= 0.7344436799
b0= 409.4179486577