{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["przykład","zadanie","Arkusz3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"przykład","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"merged":[[0,0,2,5],[4,0,4,7],[21,0,21,6],[23,0,23,6],[26,0,26,6],[27,0,28,6]],"flags":["formulas_cached_only"]}
["Zad. Na podstawie liniowego modelu ekonometrycznego z jedną zmienną objaśniającą otrzymano następujące wartości teoretyczne. Proszę zbadać autokorelację rozkładu reszt."]
[]
[]
[]
["Obliczenia konieczne do zweryfikowania hipotezy o braku autokorelacji resztowej"]
["Y","Y^","Reszty","ei-ei-1","(ei-ei-1)2","ei2"]
[{"v":14,"d":"14.0"},14.42,-0.42,"-","-",{"v":0.17639999999999995,"d":"0.1764"}]
[{"v":17,"d":"17.0"},17.18,-0.18,{"v":0.24,"d":"0.2400"},{"v":0.0576000000000001,"d":"0.0576"},{"v":0.0323999999999999,"d":"0.0324"}]
[14.5,14.42,{"v":0.08000000000000007,"d":"0.08"},{"v":0.26,"d":"0.2600"},{"v":0.06759999999999988,"d":"0.0676"},{"v":0.006400000000000012,"d":"0.0064"}]
[{"v":20,"d":"20.0"},19.46,{"v":0.5399999999999991,"d":"0.54"},{"v":0.4599999999999991,"d":"0.4600"},{"v":0.21159999999999915,"d":"0.2116"},{"v":0.2915999999999991,"d":"0.2916"}]
[21.6,{"v":21.8,"d":"21.80"},{"v":-0.1999999999999993,"d":"-0.20"},{"v":-0.7399999999999984,"d":"-0.7400"},{"v":0.5475999999999976,"d":"0.5476"},{"v":0.039999999999999716,"d":"0.0400"}]
[{"v":23,"d":"23.0"},22.76,{"v":0.23999999999999844,"d":"0.24"},{"v":0.4399999999999977,"d":"0.4400"},{"v":0.193599999999998,"d":"0.1936"},{"v":0.05759999999999925,"d":"0.0576"}]
[24.5,24.86,{"v":-0.35999999999999943,"d":"-0.36"},{"v":-0.5999999999999979,"d":"-0.6000"},{"v":0.35999999999999743,"d":"0.3600"},{"v":0.1295999999999996,"d":"0.1296"}]
[{"v":28,"d":"28.0"},{"v":27.8,"d":"27.80"},{"v":0.1999999999999993,"d":"0.20"},{"v":0.5599999999999987,"d":"0.5600"},{"v":0.31359999999999855,"d":"0.3136"},{"v":0.039999999999999716,"d":"0.0400"}]
[26.4,{"v":26,"d":"26.00"},{"v":0.3999999999999986,"d":"0.40"},{"v":0.1999999999999993,"d":"0.2000"},{"v":0.039999999999999716,"d":"0.0400"},{"v":0.15999999999999887,"d":"0.1600"}]
[{"v":29,"d":"29.0"},29.66,-0.66,{"v":-1.06,"d":"-1.0600"},{"v":1.1235999999999973,"d":"1.1236"},{"v":0.4356000000000002,"d":"0.4356"}]
[{"v":30,"d":"30.0"},30.72,{"v":-0.7199999999999989,"d":"-0.72"},{"v":-0.05999999999999872,"d":"-0.0600"},{"v":0.0035999999999998464,"d":"0.0036"},{"v":0.5183999999999984,"d":"0.5184"}]
[30.9,31.22,-0.32,{"v":0.3999999999999986,"d":"0.4000"},{"v":0.15999999999999887,"d":"0.1600"},{"v":0.10240000000000019,"d":"0.1024"}]
[31.3,{"v":31.1,"d":"31.10"},{"v":0.1999999999999993,"d":"0.20"},{"v":0.52,"d":"0.5200"},{"v":0.27039999999999953,"d":"0.2704"},{"v":0.039999999999999716,"d":"0.0400"}]
[null,null,"suma","x",{"v":3.3491999999999864,"d":"3.3492"},{"v":2.0303999999999944,"d":"2.0304"}]
[]
["Otrzymano następującą wartość statystyki testowej Durbina - Watsona"]
["d",{"v":1.6495271867612271,"d":"1.650"}]
["Odczytano wartości krytyczne statystyki Durbina - Watsona z tablic "]
["dL",{"v":1.01,"d":"1.010"}]
["dU",{"v":1.34,"d":"1.340"}]
["Ostatecznie otrzymano następujący wynik testu:"]
["Ponieważ d jest większe od du nie ma podstaw do odrzucenia hipotezy zerowej zakładającej, że autokorelacja resztowa nie występuje"]

{"sheet":"zadanie","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[0,0,2,5]],"flags":["formulas_cached_only"]}
["Zad. Na podstawie liniowego modelu ekonometrycznego z jedną zmienną objaśniającą otrzymano następujące wartości teoretyczne. Proszę zbadać autokorelację rozkładu reszt."]
[]
[]
[]
[]
["Yi","Yi^","Reszty (ei)","ei-ei-1","(ei-ei-1)2","ei2"]
[15,14.42]
[16,17.18]
[15,14.42]
[19,19.46]
[23,21.8]
[24.5,22.76]
[24,24.86]
[28,27.8]
[27,26]
[29,29.66]
[31.5,30.72]
[32,31.22]
[32,31.1]

{"sheet":"Arkusz3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}