{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["автокорр.ф.","Скольз ср","аддит","мультипл","Лист2","фикт.пер."],"not_rendered":{"charts":6,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"автокорр.ф.","index":0,"n_rows":53,"n_cols":13,"rows_kept":53,"flags":["formulas_cached_only"]}
[]
["Задание"]
["В таблице приводятся данные об объемах продаж "]
["Номер квартала","Объем продаж"]
[1,{"v":3973.6638391268207,"d":"3974"}]
[2,{"v":4133.755834515905,"d":"4134"}]
[3,{"v":4054.473508852243,"d":"4054"}]
[4,{"v":4200.225357982563,"d":"4200"}]
[5,{"v":3994.702284311643,"d":"3995"}]
[6,{"v":4162.354397565796,"d":"4162"}]
[7,{"v":4091.2914370017825,"d":"4091"}]
[8,{"v":4224.042582329712,"d":"4224"}]
[9,{"v":4037.9747144607245,"d":"4038"}]
[10,{"v":4191.300910551217,"d":"4191"}]
[11,{"v":4124.569793670962,"d":"4125"}]
[12,{"v":4258.986860444129,"d":"4259"}]
[13,{"v":4079.1609797689307,"d":"4079"}]
[14,{"v":4240.4947651177645,"d":"4240"}]
[15,{"v":4181.263500709902,"d":"4181"}]
[16,{"v":4319.960558600142,"d":"4320"}]
[17,{"v":4125.680158210453,"d":"4126"}]
[18,{"v":4284.855621682509,"d":"4285"}]
[19,{"v":4213.285242655693,"d":"4213"}]
[20,{"v":4358.620077096566,"d":"4359"}]
[21,{"v":4142.668668963015,"d":"4143"}]
[22,{"v":4311.495815265807,"d":"4311"}]
[23,{"v":4239.535604072444,"d":"4240"}]
[24,{"v":4390.379907305614,"d":"4390"}]
["t","y(t)","y(t-1)","y(t-2)","y(t-3)","y(t-4)","y(t-5)","y(t-6)",{"$nulls":3},"Лаг","Коэффициент автокорреляции уровней"]
[1,3974,{"$nulls":9},1,0.040300177715832]
[2,4134,3974,{"$nulls":8},2,0.8022317965691533]
[3,4054,4134,3974,{"$nulls":7},3,0.148122770936459]
[4,4200,4054,4134,3974,{"$nulls":6},4,0.9940293180996259]
[5,3995,4200,4054,4134,3974,{"$nulls":5},5,0.150854363465485]
[6,4162,3995,4200,4054,4134,3974,{"$nulls":4},6,0.7820418486859252]
[7,4091,4162,3995,4200,4054,4134,3974]
[8,4224,4091,4162,3995,4200,4054,4134]
[9,4038,4224,4091,4162,3995,4200,4054]
[10,4191,4038,4224,4091,4162,3995,4200]
[11,4125,4191,4038,4224,4091,4162,3995]
[12,4259,4125,4191,4038,4224,4091,4162]
[13,4079,4259,4125,4191,4038,4224,4091]
[14,4240,4079,4259,4125,4191,4038,4224]
[15,4181,4240,4079,4259,4125,4191,4038]
[16,4320,4181,4240,4079,4259,4125,4191]
[17,4126,4320,4181,4240,4079,4259,4125]
[18,4285,4126,4320,4181,4240,4079,4259]
[19,4213,4285,4126,4320,4181,4240,4079]
[20,4359,4213,4285,4126,4320,4181,4240]
[21,4143,4359,4213,4285,4126,4320,4181]
[22,4311,4143,4359,4213,4285,4126,4320]
[23,4240,4311,4143,4359,4213,4285,4126]
[24,4390,4240,4311,4143,4359,4213,4285]

{"sheet":"Скольз ср","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"flags":["formulas_cached_only"]}
["Номер квартала","Объем продаж","Сглаж по 3 т","Сглаж по 5 т","Сглаж по 4 т"]
[1,{"v":3973.6638391268207,"d":"3974"}]
[2,{"v":4133.755834515905,"d":"4134"},{"v":4053.9643941649897,"d":"4054"}]
[3,{"v":4054.473508852243,"d":"4054"},{"v":4129.484900450237,"d":"4129"},{"v":4071.364164957835,"d":"4071"},{"v":4090.529635119383,"d":"4091"},{"v":4093.1594407674856,"d":"4093"}]
[4,{"v":4200.225357982563,"d":"4200"},{"v":4083.1337170488164,"d":"4083"},{"v":4109.10227664563,"d":"4109"},{"v":4095.7892464155884,"d":"4096"},{"v":4099.364066796825,"d":"4099"}]
[5,{"v":3994.702284311643,"d":"3995"},{"v":4119.094013286667,"d":"4119"},{"v":4100.609397142805,"d":"4101"},{"v":4102.938887178061,"d":"4103"},{"v":4107.541128196754,"d":"4108"}]
[6,{"v":4162.354397565796,"d":"4162"},{"v":4082.7827062930737,"d":"4083"},{"v":4134.523211838299,"d":"4135"},{"v":4112.143369215446,"d":"4112"},{"v":4115.12052225884,"d":"4115"}]
[7,{"v":4091.2914370017825,"d":"4091"},{"v":4159.229472299096,"d":"4159"},{"v":4102.0730831339315,"d":"4102"},{"v":4118.097675302233,"d":"4118"},{"v":4123.5067290708685,"d":"4124"}]
[8,{"v":4224.042582329712,"d":"4224"},{"v":4117.76957793074,"d":"4118"},{"v":4141.392808381846,"d":"4141"},{"v":4128.915782839504,"d":"4129"},{"v":4132.534096962681,"d":"4133"}]
[9,{"v":4037.9747144607245,"d":"4038"},{"v":4151.106069113885,"d":"4151"},{"v":4133.83588760288,"d":"4134"},{"v":4136.152411085859,"d":"4136"},{"v":4140.3122056695065,"d":"4140"}]
[10,{"v":4191.300910551217,"d":"4191"},{"v":4117.948472894302,"d":"4118"},{"v":4167.374972291349,"d":"4167"},{"v":4144.472000253154,"d":"4144"},{"v":4148.840035017456,"d":"4149"}]
[11,{"v":4124.569793670962,"d":"4125"},{"v":4191.619188222103,"d":"4192"},{"v":4138.398651779193,"d":"4138"},{"v":4153.208069781758,"d":"4153"},{"v":4158.356352945284,"d":"4158"}]
[12,{"v":4258.986860444129,"d":"4259"},{"v":4154.239211294674,"d":"4154"},{"v":4178.902661910601,"d":"4179"},{"v":4163.50463610881,"d":"4164"},{"v":4169.653867929628,"d":"4170"}]
[13,{"v":4079.1609797689307,"d":"4079"},{"v":4192.880868443608,"d":"4193"},{"v":4176.895179942338,"d":"4177"},{"v":4175.803099750447,"d":"4176"},{"v":4182.889813130314,"d":"4183"}]
[14,{"v":4240.4947651177645,"d":"4240"},{"v":4166.973081865533,"d":"4167"},{"v":4215.9733329281735,"d":"4216"},{"v":4189.976526510181,"d":"4190"},{"v":4197.598238779683,"d":"4198"}]
[15,{"v":4181.263500709902,"d":"4181"},{"v":4247.239608142602,"d":"4247"},{"v":4189.311992481438,"d":"4189"},{"v":4205.219951049185,"d":"4205"},{"v":4211.034848354375,"d":"4211"}]
[16,{"v":4319.960558600142,"d":"4320"},{"v":4208.968072506832,"d":"4209"},{"v":4230.450920864154,"d":"4230"},{"v":4216.849745659565,"d":"4217"},{"v":4222.394852730158,"d":"4222"}]
[17,{"v":4125.680158210453,"d":"4126"},{"v":4243.498779497701,"d":"4243"},{"v":4225.00901637174,"d":"4225"},{"v":4227.939959800751,"d":"4228"},{"v":4231.942677543975,"d":"4232"}]
[18,{"v":4284.855621682509,"d":"4285"},{"v":4207.940340849552,"d":"4208"},{"v":4260.4803316490725,"d":"4260"},{"v":4235.945395287199,"d":"4236"},{"v":4240.777835099252,"d":"4241"}]
[19,{"v":4213.285242655693,"d":"4213"},{"v":4285.586980478256,"d":"4286"},{"v":4225.021953721647,"d":"4225"},{"v":4245.610274911305,"d":"4246"},{"v":4247.7338387553755,"d":"4248"}]
[20,{"v":4358.620077096566,"d":"4359"},{"v":4238.191329571758,"d":"4238"},{"v":4262.185085132718,"d":"4262"},{"v":4249.857402599446,"d":"4250"},{"v":4253.187426797358,"d":"4253"}]
[21,{"v":4142.668668963015,"d":"4143"},{"v":4270.928187108463,"d":"4271"},{"v":4253.121081610705,"d":"4253"},{"v":4256.51745099527,"d":"4257"},{"v":4259.798746172364,"d":"4260"}]
[22,{"v":4311.495815265807,"d":"4311"},{"v":4231.233362767089,"d":"4231"},{"v":4288.540014540689,"d":"4289"},{"v":4263.080041349458,"d":"4263"},{"v":4267.050020125589,"d":"4267"}]
[23,{"v":4239.535604072444,"d":"4240"},{"v":4313.803775547955,"d":"4314"},null,{"v":4271.01999890172,"d":"4271"}]
[24,{"v":4390.379907305614,"d":"4390"}]

{"sheet":"аддит","index":2,"n_rows":79,"n_cols":20,"rows_kept":79,"merged":[[29,8,30,8],[29,9,30,9],[29,10,29,13],[42,1,42,6]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":14},"t","Потребление электроэнергии, y(t)","Итого за 4 квартала","Скользящая средняя за 4 квартала","Центрированная скользящая средняя","Оценка сезонной компоненты"]
[{"$nulls":14},1,3974,"-"]
[{"$nulls":14},2,4134,{"v":16362,"d":"16362.0"},{"v":4090.5,"d":"4090.50"}]
[{"$nulls":14},3,4054,{"v":16383,"d":"16383.0"},4095.75,4093.125,-39.125]
[{"$nulls":14},4,4200,{"v":16411,"d":"16411.0"},4102.75,{"v":4099.25,"d":"4099.250"},{"v":100.75,"d":"100.750"}]
[{"$nulls":14},5,3995,{"v":16448,"d":"16448.0"},{"v":4112,"d":"4112.00"},4107.375,-112.375]
[{"$nulls":14},6,4162,{"v":16472,"d":"16472.0"},{"v":4118,"d":"4118.00"},{"v":4115,"d":"4115.000"},{"v":47,"d":"47.000"}]
[{"$nulls":14},7,4091,{"v":16515,"d":"16515.0"},4128.75,4123.375,-32.375]
[{"$nulls":14},8,4224,{"v":16544,"d":"16544.0"},{"v":4136,"d":"4136.00"},4132.375,91.625]
[{"$nulls":14},9,4038,{"v":16578,"d":"16578.0"},{"v":4144.5,"d":"4144.50"},{"v":4140.25,"d":"4140.250"},{"v":-102.25,"d":"-102.250"}]
[{"$nulls":14},10,4191,{"v":16613,"d":"16613.0"},4153.25,4148.875,42.125]
[{"$nulls":14},11,4125,{"v":16654,"d":"16654.0"},{"v":4163.5,"d":"4163.50"},4158.375,-33.375]
[{"$nulls":14},12,4259,{"v":16703,"d":"16703.0"},4175.75,4169.625,89.375]
[{"$nulls":14},13,4079,{"v":16759,"d":"16759.0"},4189.75,{"v":4182.75,"d":"4182.750"},{"v":-103.75,"d":"-103.750"}]
[{"$nulls":14},14,4240,{"v":16820,"d":"16820.0"},{"v":4205,"d":"4205.00"},4197.375,42.625]
[{"$nulls":14},15,4181,{"v":16867,"d":"16867.0"},4216.75,4210.875,-29.875]
[{"$nulls":14},16,4320,{"v":16912,"d":"16912.0"},{"v":4228,"d":"4228.00"},4222.375,97.625]
[{"$nulls":14},17,4126,{"v":16944,"d":"16944.0"},{"v":4236,"d":"4236.00"},{"v":4232,"d":"4232.000"},{"v":-106,"d":"-106.000"}]
[{"$nulls":14},18,4285,{"v":16983,"d":"16983.0"},4245.75,4240.875,44.125]
[{"$nulls":14},19,4213,{"v":17000,"d":"17000.0"},{"v":4250,"d":"4250.00"},4247.875,-34.875]
[{"$nulls":14},20,4359,{"v":17026,"d":"17026.0"},{"v":4256.5,"d":"4256.50"},{"v":4253.25,"d":"4253.250"},{"v":105.75,"d":"105.750"}]
[{"$nulls":14},21,4143,{"v":17053,"d":"17053.0"},4263.25,4259.875,-116.875]
[{"$nulls":14},22,4311,{"v":17084,"d":"17084.0"},{"v":4271,"d":"4271.00"},4267.125,43.875]
[{"$nulls":14},23,4240]
[{"$nulls":14},24,4390]
[]
[null,null,"Расчет значений сезонной компоненты S"]
[]
[{"$nulls":8},"Показатели","Год","№ квартала, t"]
[{"$nulls":10},1,2,3,4]
[{"$nulls":9},1,null,null,-39.125,{"v":100.75,"d":"100.750"}]
[{"$nulls":9},2,-112.375,{"v":47,"d":"47.000"},-32.375,91.625]
[{"$nulls":9},3,{"v":-102.25,"d":"-102.250"},42.125,-33.375,89.375]
[{"$nulls":9},4,{"v":-103.75,"d":"-103.750"},42.625,-29.875,97.625]
[{"$nulls":9},5,{"v":-106,"d":"-106.000"},44.125,-34.875,{"v":105.75,"d":"105.750"}]
[{"$nulls":9},6,-116.875,43.875]
[{"$nulls":8},"Итого за i-й квартал (за все годы)",null,{"v":-541.25,"d":"-541.250"},{"v":219.75,"d":"219.750"},-169.625,485.125]
[{"$nulls":8},"Средняя оценка сезонной компоненты для i-го квартала (Si)",null,{"v":-108.25,"d":"-108.250"},{"v":43.95,"d":"43.950"},-33.925,97.025]
[{"$nulls":8},"Скорректированная сезонная компонента (Si-k)",null,{"v":-107.95,"d":"-107.950"},{"v":44.25,"d":"44.250"},-33.625,97.325,{"v":0,"d":"0.000"}]
[{"$nulls":10},"к=ΣSi /4"]
[]
[null,"Расчет выравненных значений T и ошибок E в аддитивной модели"]
[]
["t","Yt","St","T+E=Yt-St","T","T+S","E=Yt-(T+S)","E^2","y-yср","(y-yср)^2"]
[1,3974,{"v":-107.95,"d":"-107.950"},{"v":4081.95,"d":"4081.950"},{"v":4070.861833333333,"d":"4070.862"},{"v":3962.911833333333,"d":"3962.912"},{"v":11.088166666666893,"d":"11.088"},{"v":122.9474400277828,"d":"122.9474"},{"v":-206.58333333333303,"d":"-207"},{"v":42676.673611110986,"d":"42676.6736111110"}]
[2,4134,{"v":44.25,"d":"44.250"},{"v":4089.75,"d":"4089.750"},{"v":4080.4028333333326,"d":"4080.403"},{"v":4124.652833333333,"d":"4124.653"},{"v":9.347166666667363,"d":"9.347"},{"v":87.36952469445745,"d":"87.3695"},{"v":-46.58333333333303,"d":"-47"},{"v":2170.006944444416,"d":"2170.0069444444"},{"$nulls":3},9.541000000000006,4061.3208333333328]
[3,4054,-33.625,4087.625,{"v":4089.943833333333,"d":"4089.944"},{"v":4056.318833333333,"d":"4056.319"},{"v":-2.3188333333328046,"d":"-2.319"},{"v":5.376988027775326,"d":"5.3770"},{"v":-126.58333333333303,"d":"-127"},{"v":16023.340277777701,"d":"16023.3402777777"},{"$nulls":3},9.541000000000006,4061.3208333333328]
[4,4200,97.325,4102.675,{"v":4099.484833333333,"d":"4099.485"},{"v":4196.809833333333,"d":"4196.810"},{"v":3.19016666666721,"d":"3.190"},{"v":10.177163361114577,"d":"10.1772"},{"v":19.41666666666697,"d":"19"},{"v":377.0069444444562,"d":"377.0069444445"},{"$nulls":3},9.541000000000006,4061.3208333333328]
[5,3995,{"v":-107.95,"d":"-107.950"},{"v":4102.95,"d":"4102.950"},{"v":4109.025833333333,"d":"4109.026"},{"v":4001.0758333333333,"d":"4001.076"},{"v":-6.075833333333321,"d":"-6.076"},{"v":36.9157506944443,"d":"36.9158"},{"v":-185.58333333333303,"d":"-186"},{"v":34441.173611111,"d":"34441.1736111110"},{"$nulls":3},9.541000000000006,4061.3208333333328]
[6,4162,{"v":44.25,"d":"44.250"},{"v":4117.75,"d":"4117.750"},{"v":4118.566833333332,"d":"4118.567"},{"v":4162.816833333332,"d":"4162.817"},{"v":-0.8168333333323972,"d":"-0.817"},{"v":0.6672166944429151,"d":"0.6672"},{"v":-18.58333333333303,"d":"-19"},{"v":345.3402777777665,"d":"345.3402777778"},{"$nulls":3},9.541000000000006,4061.3208333333328]
[7,4091,-33.625,4124.625,{"v":4128.107833333333,"d":"4128.108"},{"v":4094.4828333333326,"d":"4094.483"},{"v":-3.4828333333325645,"d":"-3.483"},{"v":12.130128027772422,"d":"12.1301"},{"v":-89.58333333333303,"d":"-90"},{"v":8025.173611111057,"d":"8025.1736111111"}]
[8,4224,97.325,4126.675,{"v":4137.648833333333,"d":"4137.649"},{"v":4234.973833333333,"d":"4234.974"},{"v":-10.97383333333255,"d":"-10.974"},{"v":120.42501802776059,"d":"120.4250"},{"v":43.41666666666697,"d":"43"},{"v":1885.0069444444707,"d":"1885.0069444445"},{"$nulls":3},"T=4061.321+9.541t"]
[9,4038,{"v":-107.95,"d":"-107.950"},{"v":4145.95,"d":"4145.950"},{"v":4147.189833333333,"d":"4147.190"},{"v":4039.239833333333,"d":"4039.240"},{"v":-1.239833333333081,"d":"-1.240"},{"v":1.537186694443819,"d":"1.5372"},{"v":-142.58333333333303,"d":"-143"},{"v":20330.006944444358,"d":"20330.0069444444"}]
[10,4191,{"v":44.25,"d":"44.250"},{"v":4146.75,"d":"4146.750"},{"v":4156.730833333333,"d":"4156.731"},{"v":4200.980833333333,"d":"4200.981"},{"v":-9.980833333333067,"d":"-9.981"},{"v":99.61703402777245,"d":"99.6170"},{"v":10.41666666666697,"d":"10"},{"v":108.50694444445077,"d":"108.5069444445"}]
[11,4125,-33.625,4158.625,{"v":4166.271833333333,"d":"4166.272"},{"v":4132.646833333333,"d":"4132.647"},{"v":-7.646833333333234,"d":"-7.647"},{"v":58.474060027776254,"d":"58.4741"},{"v":-55.58333333333303,"d":"-56"},{"v":3089.5069444444107,"d":"3089.5069444444"}]
[12,4259,97.325,4161.675,{"v":4175.8128333333325,"d":"4175.813"},{"v":4273.137833333332,"d":"4273.138"},{"v":-14.13783333333231,"d":"-14.138"},{"v":199.87833136108216,"d":"199.8783"},{"v":78.41666666666697,"d":"78"},{"v":6149.173611111159,"d":"6149.1736111112"}]
[13,4079,{"v":-107.95,"d":"-107.950"},{"v":4186.95,"d":"4186.950"},{"v":4185.353833333333,"d":"4185.354"},{"v":4077.403833333333,"d":"4077.404"},{"v":1.596166666667159,"d":"1.596"},{"v":2.5477480277793494,"d":"2.5477"},{"v":-101.58333333333303,"d":"-102"},{"v":10319.17361111105,"d":"10319.1736111110"},null,"R=",0.6995442072079086]
[14,4240,{"v":44.25,"d":"44.250"},{"v":4195.75,"d":"4195.750"},{"v":4194.894833333333,"d":"4194.895"},{"v":4239.144833333333,"d":"4239.145"},{"v":0.8551666666671736,"d":"0.855"},{"v":0.7313100277786447,"d":"0.7313"},{"v":59.41666666666697,"d":"59"},{"v":3530.3402777778138,"d":"3530.3402777778"}]
[15,4181,-33.625,4214.625,{"v":4204.435833333333,"d":"4204.436"},{"v":4170.810833333333,"d":"4170.811"},{"v":10.189166666667006,"d":"10.189"},{"v":103.81911736111803,"d":"103.8191"},{"v":0.41666666666696983,"d":"0"},{"v":0.17361111111136374,"d":"0.1736111111"}]
[16,4320,97.325,4222.675,{"v":4213.976833333333,"d":"4213.977"},{"v":4311.301833333333,"d":"4311.302"},{"v":8.69816666666702,"d":"8.698"},{"v":75.65810336111727,"d":"75.6581"},{"v":139.41666666666697,"d":"139"},{"v":19437.00694444453,"d":"19437.0069444445"}]
[17,4126,{"v":-107.95,"d":"-107.950"},{"v":4233.95,"d":"4233.950"},{"v":4223.517833333332,"d":"4223.518"},{"v":4115.567833333333,"d":"4115.568"},{"v":10.4321666666674,"d":"10.432"},{"v":108.8301013611264,"d":"108.8301"},{"v":-54.58333333333303,"d":"-55"},{"v":2979.3402777777446,"d":"2979.3402777777"}]
[18,4285,{"v":44.25,"d":"44.250"},{"v":4240.75,"d":"4240.750"},{"v":4233.058833333333,"d":"4233.059"},{"v":4277.308833333333,"d":"4277.309"},{"v":7.691166666667414,"d":"7.691"},{"v":59.15404469445593,"d":"59.1540"},{"v":104.41666666666697,"d":"104"},{"v":10902.840277777841,"d":"10902.8402777778"}]
[19,4213,-33.625,4246.625,{"v":4242.599833333333,"d":"4242.600"},{"v":4208.974833333333,"d":"4208.975"},{"v":4.025166666667246,"d":"4.025"},{"v":16.201966694449112,"d":"16.2020"},{"v":32.41666666666697,"d":"32"},{"v":1050.8402777777974,"d":"1050.8402777778"}]
[20,4359,97.325,4261.675,{"v":4252.140833333333,"d":"4252.141"},{"v":4349.465833333333,"d":"4349.466"},{"v":9.53416666666726,"d":"9.534"},{"v":90.90033402778911,"d":"90.9003"},{"v":178.41666666666697,"d":"178"},{"v":31832.506944444554,"d":"31832.5069444446"}]
[21,4143,{"v":-107.95,"d":"-107.950"},{"v":4250.95,"d":"4250.950"},{"v":4261.681833333333,"d":"4261.682"},{"v":4153.731833333333,"d":"4153.732"},{"v":-10.73183333333327,"d":"-10.732"},{"v":115.17224669444309,"d":"115.1722"},{"v":-37.58333333333303,"d":"-38"},{"v":1412.5069444444216,"d":"1412.5069444444"}]
[22,4311,{"v":44.25,"d":"44.250"},{"v":4266.75,"d":"4266.750"},{"v":4271.222833333333,"d":"4271.223"},{"v":4315.472833333333,"d":"4315.473"},{"v":-4.472833333333256,"d":"-4.473"},{"v":20.006238027777083,"d":"20.0062"},{"v":130.41666666666697,"d":"130"},{"v":17008.506944444525,"d":"17008.5069444445"}]
[23,4240,-33.625,4273.625,{"v":4280.7638333333325,"d":"4280.764"},{"v":4247.1388333333325,"d":"4247.139"},{"v":-7.138833333332514,"d":"-7.139"},{"v":50.9629413610994,"d":"50.9629"},{"v":59.41666666666697,"d":"59"},{"v":3530.3402777778138,"d":"3530.3402777778"}]
[24,4390,97.325,4292.675,{"v":4290.304833333333,"d":"4290.305"},{"v":4387.6298333333325,"d":"4387.630"},{"v":2.370166666667501,"d":"2.370"},{"v":5.617690027781733,"d":"5.6177"},{"v":209.41666666666697,"d":"209"},{"v":43855.340277777905,"d":"43855.3402777779"}]
[null,{"v":4180.583333333333,"d":"4181"},{"$nulls":4},{"v":58.546570138889166,"d":"58.547"},{"v":1405.11768333334,"d":"1405.1177"},null,{"v":281479.8333333333,"d":"281479.8333"},11728.326388888889]
[null,12238.253623187542,11728.326388888889,{"$nulls":3},{"v":58.546570138889166,"d":"58.547"},{"v":61.09207318840608,"d":"61.0921"},{"v":58.546570138889166,"d":"59"},null,0.9950081053171956]
[{"$nulls":5},"R=",0.9950081053171952,99.50081053171957,"Аддитивная модель  объясняет 99,5% общей вариации уровней временного ряда объема продаж "]
[]
[]
[]
[]
[]
[{"$nulls":14},25]
[{"$nulls":13},"Y=",4191.895833333333]

{"sheet":"мультипл","index":3,"n_rows":66,"n_cols":14,"rows_kept":66,"merged":[[26,0,27,0],[26,1,27,1],[26,2,26,5]],"flags":["formulas_cached_only"]}
["t","Потребление электроэнергии, y(t)","Итого за 4 квартала","Скользящая средняя за 4 квартала","Центрированная скользящая средняя","Оценка сезонной компоненты"]
[1,3974,"-"]
[2,4134,{"v":16362,"d":"16362.0"},{"v":4090.5,"d":"4090.50"}]
[3,4054,{"v":16383,"d":"16383.0"},4095.75,{"v":4093.125,"d":"4093.12500"},{"v":0.9904412887463735,"d":"0.990"}]
[4,4200,{"v":16411,"d":"16411.0"},4102.75,{"v":4099.25,"d":"4099.25000"},{"v":1.0245776666463378,"d":"1.025"}]
[5,3995,{"v":16448,"d":"16448.0"},{"v":4112,"d":"4112.00"},{"v":4107.375,"d":"4107.37500"},{"v":0.9726406768313095,"d":"0.973"}]
[6,4162,{"v":16472,"d":"16472.0"},{"v":4118,"d":"4118.00"},{"v":4115,"d":"4115.00000"},{"v":1.0114216281895505,"d":"1.011"}]
[7,4091,{"v":16515,"d":"16515.0"},4128.75,{"v":4123.375,"d":"4123.37500"},{"v":0.992148422105678,"d":"0.992"}]
[8,4224,{"v":16544,"d":"16544.0"},{"v":4136,"d":"4136.00"},{"v":4132.375,"d":"4132.37500"},{"v":1.0221724795063372,"d":"1.022"}]
[9,4038,{"v":16578,"d":"16578.0"},{"v":4144.5,"d":"4144.50"},{"v":4140.25,"d":"4140.25000"},{"v":0.975303423706298,"d":"0.975"}]
[10,4191,{"v":16613,"d":"16613.0"},4153.25,{"v":4148.875,"d":"4148.87500"},{"v":1.0101533548251032,"d":"1.010"}]
[11,4125,{"v":16654,"d":"16654.0"},{"v":4163.5,"d":"4163.50"},{"v":4158.375,"d":"4158.37500"},{"v":0.9919740283163495,"d":"0.992"}]
[12,4259,{"v":16703,"d":"16703.0"},4175.75,{"v":4169.625,"d":"4169.62500"},{"v":1.0214347813052733,"d":"1.021"}]
[13,4079,{"v":16759,"d":"16759.0"},4189.75,{"v":4182.75,"d":"4182.75000"},{"v":0.9751957444265137,"d":"0.975"}]
[14,4240,{"v":16820,"d":"16820.0"},{"v":4205,"d":"4205.00"},{"v":4197.375,"d":"4197.37500"},{"v":1.01015515649662,"d":"1.010"}]
[15,4181,{"v":16867,"d":"16867.0"},4216.75,{"v":4210.875,"d":"4210.87500"},{"v":0.9929052750319114,"d":"0.993"}]
[16,4320,{"v":16912,"d":"16912.0"},{"v":4228,"d":"4228.00"},{"v":4222.375,"d":"4222.37500"},{"v":1.0231208739157465,"d":"1.023"}]
[17,4126,{"v":16944,"d":"16944.0"},{"v":4236,"d":"4236.00"},{"v":4232,"d":"4232.00000"},{"v":0.974952741020794,"d":"0.975"}]
[18,4285,{"v":16983,"d":"16983.0"},4245.75,{"v":4240.875,"d":"4240.87500"},{"v":1.0104046924278598,"d":"1.010"}]
[19,4213,{"v":17000,"d":"17000.0"},{"v":4250,"d":"4250.00"},{"v":4247.875,"d":"4247.87500"},{"v":0.9917900126533855,"d":"0.992"}]
[20,4359,{"v":17026,"d":"17026.0"},{"v":4256.5,"d":"4256.50"},{"v":4253.25,"d":"4253.25000"},{"v":1.0248633397989773,"d":"1.025"}]
[21,4143,{"v":17053,"d":"17053.0"},4263.25,{"v":4259.875,"d":"4259.87500"},{"v":0.972563748936295,"d":"0.973"}]
[22,4311,{"v":17084,"d":"17084.0"},{"v":4271,"d":"4271.00"},{"v":4267.125,"d":"4267.12500"},{"v":1.0102820986026892,"d":"1.010"}]
[23,4240,{"v":12941,"d":"12941.0"}]
[24,4390,{"v":8630,"d":"8630.0"}]
[]
["Показатели","Год","№ квартала, t"]
[null,null,1,2,3,4]
[null,1,null,null,{"v":0.9904412887463735,"d":"0.99044"},{"v":1.0245776666463378,"d":"1.025"}]
[null,2,{"v":0.9726406768313095,"d":"0.973"},{"v":1.0114216281895505,"d":"1.011"},{"v":0.992148422105678,"d":"0.99215"},{"v":1.0221724795063372,"d":"1.022"}]
[null,3,{"v":0.975303423706298,"d":"0.975"},{"v":1.0101533548251032,"d":"1.010"},{"v":0.9919740283163495,"d":"0.99197"},{"v":1.0214347813052733,"d":"1.021"}]
[null,4,{"v":0.9751957444265137,"d":"0.975"},{"v":1.01015515649662,"d":"1.010"},{"v":0.9929052750319114,"d":"0.99291"},{"v":1.0231208739157465,"d":"1.023"}]
[null,5,{"v":0.974952741020794,"d":"0.975"},{"v":1.0104046924278598,"d":"1.010"},{"v":0.9917900126533855,"d":"0.99179"},{"v":1.0248633397989773,"d":"1.025"}]
[null,6,{"v":0.972563748936295,"d":"0.973"},{"v":1.0102820986026892,"d":"1.010"}]
["Итого за i-й квартал (за все годы)",null,{"v":4.87065633492121,"d":"4.871"},{"v":5.052416930541822,"d":"5.052"},{"v":4.959259026853698,"d":"4.95926"},{"v":5.116169141172672,"d":"5.116"}]
["Средняя оценка сезонной компоненты для i-го квартала",null,{"v":0.974131266984242,"d":"0.974"},{"v":1.0104833861083644,"d":"1.010"},{"v":0.9918518053707397,"d":"0.99185"},{"v":1.0232338282345343,"d":"1.023"},{"v":3.9997002866978804,"d":"4.000"}]
["Скорректированная сезонная компонента",null,{"v":0.9742042624783536,"d":"0.974"},{"v":1.0105591056099967,"d":"1.011"},{"v":0.9919261287346152,"d":"0.99193"},{"v":1.0233105031770346,"d":"1.023"},{"v":4,"d":"4.000"}]
[null,null,"k=4/ΣSi"]
["t","Yt","St","T*E=Yt/St","T","T*S","E=Yt/(T*S)","E^2","y-yср","(y-yср)^2",null,null,"Ea=Yt-(T*S)","E2a"]
[1,3974,{"v":0.9742042624783536,"d":"0.974"},{"v":4079.2266602182935,"d":"4079.227"},{"v":4070.728886998534,"d":"4070.72889"},{"v":3965.721433107736,"d":"3965.721"},{"v":1.002087531116823,"d":"1.002"},{"v":1.0041794200198095,"d":"1.0042"},{"v":-206.58333333333303,"d":"-207"},{"v":42676.673611110986,"d":"42676.67"},null,null,{"v":8.278566892263825,"d":"8.279"},{"v":68.53466978968673,"d":"68.535"}]
[2,4134,{"v":1.0105591056099967,"d":"1.011"},{"v":4090.8047605039615,"d":"4090.805"},{"v":4080.2683565066545,"d":"4080.26836"},{"v":4123.352341000136,"d":"4123.352"},{"v":1.002582282113995,"d":"1.003"},{"v":1.0051712324089062,"d":"1.0052"},{"v":-46.58333333333303,"d":"-47"},{"v":2170.006944444416,"d":"2170.01"},9.539469508120654,4061.1894174904132,{"v":10.64765899986378,"d":"10.648"},{"v":113.37264217738013,"d":"113.373"}]
[3,4054,{"v":0.9919261287346152,"d":"0.992"},{"v":4086.997894865039,"d":"4086.998"},{"v":4089.8078260147754,"d":"4089.80783"},{"v":4056.7872441273685,"d":"4056.787"},{"v":0.9993129429867432,"d":"0.999"},{"v":0.9986263580208259,"d":"0.9986"},{"v":-126.58333333333303,"d":"-127"},{"v":16023.340277777701,"d":"16023.34"},null,null,{"v":-2.787244127368467,"d":"-2.787"},{"v":7.768729825550008,"d":"7.769"}]
[4,4200,{"v":1.0233105031770346,"d":"1.023"},{"v":4104.326093556563,"d":"4104.326"},{"v":4099.347295522896,"d":"4099.34730"},{"v":4194.905143678951,"d":"4194.905"},{"v":1.0012145343330887,"d":"1.001"},{"v":1.0024305437598238,"d":"1.0024"},{"v":19.41666666666697,"d":"19"},{"v":377.0069444444562,"d":"377.01"},null,null,{"v":5.09485632104861,"d":"5.095"},{"v":25.957560932128978,"d":"25.958"}]
[5,3995,{"v":0.9742042624783536,"d":"0.974"},{"v":4100.782714537514,"d":"4100.783"},{"v":4108.886765031017,"d":"4108.88677"},{"v":4002.89500053411,"d":"4002.895"},{"v":0.9980276773352645,"d":"0.998"},{"v":0.996059244727223,"d":"0.9961"},{"v":-185.58333333333303,"d":"-186"},{"v":34441.173611111,"d":"34441.17"},"T=4061.189+9.5394t",null,{"v":-7.89500053410984,"d":"-7.895"},{"v":62.33103343359466,"d":"62.331"}]
[6,4162,{"v":1.0105591056099967,"d":"1.011"},{"v":4118.512194779266,"d":"4118.512"},{"v":4118.426234539137,"d":"4118.42623"},{"v":4161.913132096617,"d":"4161.913"},{"v":1.0000208721087216,"d":"1.000"},{"v":1.000041744653088,"d":"1.0000"},{"v":-18.58333333333303,"d":"-19"},{"v":345.3402777777665,"d":"345.34"},null,null,{"v":0.0868679033828812,"d":"0.087"},{"v":0.007546032638137582,"d":"0.008"}]
[7,4091,{"v":0.9919261287346152,"d":"0.992"},{"v":4124.299059667705,"d":"4124.299"},{"v":4127.9657040472575,"d":"4127.96570"},{"v":4094.637040364856,"d":"4094.637"},{"v":0.9991117551253011,"d":"0.999"},{"v":0.9982242992295597,"d":"0.9982"},{"v":-89.58333333333303,"d":"-90"},{"v":8025.173611111057,"d":"8025.17"},null,null,{"v":-3.637040364856148,"d":"-3.637"},{"v":13.228062615592941,"d":"13.228"}]
[8,4224,{"v":1.0233105031770346,"d":"1.023"},{"v":4127.779385519744,"d":"4127.779"},{"v":4137.505173555379,"d":"4137.50517"},{"v":4233.952501048539,"d":"4233.953"},{"v":0.9976493593052653,"d":"0.998"},{"v":0.9953042441222064,"d":"0.9953"},{"v":43.41666666666697,"d":"43"},{"v":1885.0069444444707,"d":"1885.01"},null,null,{"v":-9.95250104853858,"d":"-9.953"},{"v":99.05227712116152,"d":"99.052"}]
[9,4038,{"v":0.9742042624783536,"d":"0.974"},{"v":4144.9213019530625,"d":"4144.921"},{"v":4147.044643063499,"d":"4147.04464"},{"v":4040.0685679604835,"d":"4040.069"},{"v":0.9994879869176261,"d":"0.999"},{"v":0.9989762359926487,"d":"0.9990"},{"v":-142.58333333333303,"d":"-143"},{"v":20330.006944444358,"d":"20330.01"},null,null,{"v":-2.068567960483506,"d":"-2.069"},{"v":4.278973407138891,"d":"4.279"}]
[10,4191,{"v":1.0105591056099967,"d":"1.011"},{"v":4147.209180278689,"d":"4147.209"},{"v":4156.58411257162,"d":"4156.58411"},{"v":4200.473923193098,"d":"4200.474"},{"v":0.9977445585030805,"d":"0.998"},{"v":0.9954942040225071,"d":"0.9955"},{"v":10.41666666666697,"d":"10"},{"v":108.50694444445077,"d":"108.51"},null,null,{"v":-9.473923193098017,"d":"-9.474"},{"v":89.75522066872053,"d":"89.755"}]
[11,4125,{"v":0.9919261287346152,"d":"0.992"},{"v":4158.575805702587,"d":"4158.576"},{"v":4166.12358207974,"d":"4166.12358"},{"v":4132.486836602345,"d":"4132.487"},{"v":0.9981882975316383,"d":"0.998"},{"v":0.9963798773291105,"d":"0.9964"},{"v":-55.58333333333303,"d":"-56"},{"v":3089.5069444444107,"d":"3089.51"},null,null,{"v":-7.486836602344738,"d":"-7.487"},{"v":56.0527223102089,"d":"56.053"}]
[12,4259,{"v":1.0233105031770346,"d":"1.023"},{"v":4161.982102966049,"d":"4161.982"},{"v":4175.663051587861,"d":"4175.66305"},{"v":4272.999858418127,"d":"4273.000"},{"v":0.9967236464118888,"d":"0.997"},{"v":0.9934580273166119,"d":"0.9935"},{"v":78.41666666666697,"d":"78"},{"v":6149.173611111159,"d":"6149.17"},null,null,{"v":-13.999858418126678,"d":"-14.000"},{"v":195.9960357275924,"d":"195.996"}]
[13,4079,{"v":0.9742042624783536,"d":"0.974"},{"v":4187.006931814399,"d":"4187.007"},{"v":4185.202521095982,"d":"4185.20252"},{"v":4077.242135386857,"d":"4077.242"},{"v":1.000431140598172,"d":"1.000"},{"v":1.0008624670785595,"d":"1.0009"},{"v":-101.58333333333303,"d":"-102"},{"v":10319.17361111105,"d":"10319.17"},null,null,{"v":1.7578646131428286,"d":"1.758"},{"v":3.0900879981397864,"d":"3.090"}]
[14,4240,{"v":1.0105591056099967,"d":"1.011"},{"v":4195.697190260473,"d":"4195.697"},{"v":4194.741990604102,"d":"4194.74199"},{"v":4239.034714289579,"d":"4239.035"},{"v":1.0002277135658189,"d":"1.000"},{"v":1.0004554789851057,"d":"1.0005"},{"v":59.41666666666697,"d":"59"},{"v":3530.3402777778138,"d":"3530.34"},null,null,{"v":0.9652857104210852,"d":"0.965"},{"v":0.9317765027431393,"d":"0.932"}]
[15,4181,{"v":0.9919261287346152,"d":"0.992"},{"v":4215.031622701215,"d":"4215.032"},{"v":4204.281460112223,"d":"4204.28146"},{"v":4170.336632839832,"d":"4170.337"},{"v":1.0025569559723781,"d":"1.003"},{"v":1.005120449968601,"d":"1.0051"},{"v":0.41666666666696983,"d":"0"},{"v":0.17361111111136374,"d":"0.17"},null,null,{"v":10.663367160167581,"d":"10.663"},{"v":113.70739919254044,"d":"113.707"}]
[16,4320,{"v":1.0233105031770346,"d":"1.023"},{"v":4221.592553372466,"d":"4221.593"},{"v":4213.820929620344,"d":"4213.82093"},{"v":4312.047215787714,"d":"4312.047"},{"v":1.0018443175165541,"d":"1.002"},{"v":1.00369203654021,"d":"1.0037"},{"v":139.41666666666697,"d":"139"},{"v":19437.00694444453,"d":"19437.01"},null,null,{"v":7.952784212286133,"d":"7.953"},{"v":63.246776727187566,"d":"63.247"}]
[17,4126,{"v":0.9742042624783536,"d":"0.974"},{"v":4235.251434338369,"d":"4235.251"},{"v":4223.360399128464,"d":"4223.36040"},{"v":4114.41570281323,"d":"4114.416"},{"v":1.0028155388330957,"d":"1.003"},{"v":1.005639004925112,"d":"1.0056"},{"v":-54.58333333333303,"d":"-55"},{"v":2979.3402777777446,"d":"2979.34"},null,null,{"v":11.584297186769618,"d":"11.584"},{"v":134.19594131139849,"d":"134.196"}]
[18,4285,{"v":1.0105591056099967,"d":"1.011"},{"v":4240.226995345784,"d":"4240.227"},{"v":4232.899868636585,"d":"4232.89987"},{"v":4277.59550538606,"d":"4277.596"},{"v":1.001730994575017,"d":"1.002"},{"v":1.0034649854922528,"d":"1.0035"},{"v":104.41666666666697,"d":"104"},{"v":10902.840277777841,"d":"10902.84"},null,null,{"v":7.404494613940187,"d":"7.404"},{"v":54.826540487869245,"d":"54.827"}]
[19,4213,{"v":0.9919261287346152,"d":"0.992"},{"v":4247.292089557575,"d":"4247.292"},{"v":4242.439338144705,"d":"4242.43934"},{"v":4208.18642907732,"d":"4208.186"},{"v":1.0011438587628674,"d":"1.001"},{"v":1.0022890259386041,"d":"1.0023"},{"v":32.41666666666697,"d":"32"},{"v":1050.8402777777974,"d":"1050.84"},null,null,{"v":4.813570922679901,"d":"4.814"},{"v":23.170465027669433,"d":"23.170"}]
[20,4359,{"v":1.0233105031770346,"d":"1.023"},{"v":4259.704152812634,"d":"4259.704"},{"v":4251.978807652827,"d":"4251.97881"},{"v":4351.094573157302,"d":"4351.095"},{"v":1.0018168823292115,"d":"1.002"},{"v":1.0036370657198213,"d":"1.0036"},{"v":178.41666666666697,"d":"178"},{"v":31832.506944444554,"d":"31832.51"},null,null,{"v":7.905426842698034,"d":"7.905"},{"v":62.49577356525061,"d":"62.496"}]
[21,4143,{"v":0.9742042624783536,"d":"0.974"},{"v":4252.701573549167,"d":"4252.702"},{"v":4261.518277160947,"d":"4261.51828"},{"v":4151.589270239604,"d":"4151.589"},{"v":0.997931088631244,"d":"0.998"},{"v":0.9958664576567399,"d":"0.9959"},{"v":-37.58333333333303,"d":"-38"},{"v":1412.5069444444216,"d":"1412.51"},null,null,{"v":-8.589270239604048,"d":"-8.589"},{"v":73.77556324894778,"d":"73.776"}]
[22,4311,{"v":1.0105591056099967,"d":"1.011"},{"v":4265.955327172854,"d":"4265.955"},{"v":4271.0577466690675,"d":"4271.05775"},{"v":4316.156296482541,"d":"4316.156"},{"v":0.9988053499159095,"d":"0.999"},{"v":0.9976121270206425,"d":"0.9976"},{"v":130.41666666666697,"d":"130"},{"v":17008.506944444525,"d":"17008.51"},null,null,{"v":-5.156296482540711,"d":"-5.156"},{"v":26.587393415861705,"d":"26.587"}]
[23,4240,{"v":0.9919261287346152,"d":"0.992"},{"v":4274.511858467628,"d":"4274.512"},{"v":4280.597216177188,"d":"4280.59722"},{"v":4246.036225314809,"d":"4246.036"},{"v":0.9985783858180906,"d":"0.999"},{"v":0.9971587926230633,"d":"0.9972"},{"v":59.41666666666697,"d":"59"},{"v":3530.3402777778138,"d":"3530.34"},null,null,{"v":-6.036225314808689,"d":"-6.036"},{"v":36.43601605113726,"d":"36.436"}]
[24,4390,{"v":1.0233105031770346,"d":"1.023"},{"v":4289.997988265075,"d":"4289.998"},{"v":4290.136685685309,"d":"4290.13669"},{"v":4390.141930526889,"d":"4390.142"},{"v":0.9999676706290741,"d":"1.000"},{"v":0.9999353423033365,"d":"0.9999"},{"v":209.41666666666697,"d":"209"},{"v":43855.340277777905,"d":"43855.34"},null,null,{"v":-0.14193052688915486,"d":"-0.142"},{"v":0.020144274463033112,"d":"0.020"}]
[null,{"v":4180.583333333333,"d":"4181"},{"$nulls":7},{"v":281479.8333333333,"d":"281479.83"},null,null,{"v":55.3674645706069,"d":"55.367"},{"v":55.3674729935251,"d":"55.367"}]
[null,11728.326388888889,{"$nulls":5},{"v":0.019670138474168403,"d":"0.0197"}]
[{"$nulls":6},"R=",0.9952791674843684,null,"Мультипликативная модель  объясняет 99,5% общей вариации уровней временного ряда объема продаж "]

{"sheet":"Лист2","index":4,"n_rows":56,"n_cols":8,"rows_kept":56,"hidden":true,"flags":["formulas_cached_only"]}
["вариант",0]
["кол-во кварталов",20,null,null,4000,10]
[]
["Номер квартала","Объем продаж",{"$nulls":4},"сезон","случ-я"]
[1,{"v":3973.6638391268207,"d":"3974"},{"$nulls":4},-50,13.663839126820676]
[2,{"v":4133.755834515905,"d":"4134"},{"$nulls":4},100,13.755834515905008]
[3,{"v":4054.473508852243,"d":"4054"},{"$nulls":4},20,4.473508852242958]
[4,{"v":4200.225357982563,"d":"4200"},{"$nulls":4},150,10.225357982562855]
[5,{"v":3994.702284311643,"d":"3995"},{"$nulls":4},-50,-5.29771568835713]
[6,{"v":4162.354397565796,"d":"4162"},{"$nulls":4},100,2.354397565795807]
[7,{"v":4091.2914370017825,"d":"4091"},{"$nulls":4},20,1.2914370017824695]
[8,{"v":4224.042582329712,"d":"4224"},{"$nulls":4},150,-5.957417670288123]
[9,{"v":4037.9747144607245,"d":"4038"},{"$nulls":4},-50,-2.025285539275501]
[10,{"v":4191.300910551217,"d":"4191"},{"$nulls":4},100,-8.699089448782615]
[11,{"v":4124.569793670962,"d":"4125"},{"$nulls":4},20,-5.430206329037901]
[12,{"v":4258.986860444129,"d":"4259"},{"$nulls":4},150,-11.013139555871021]
[13,{"v":4079.1609797689307,"d":"4079"},{"$nulls":4},-50,-0.8390202310692985]
[14,{"v":4240.4947651177645,"d":"4240"},{"$nulls":4},100,0.49476511776447296]
[15,{"v":4181.263500709902,"d":"4181"},{"$nulls":4},20,11.263500709901564]
[16,{"v":4319.960558600142,"d":"4320"},{"$nulls":4},150,9.960558600141667]
[17,{"v":4125.680158210453,"d":"4126"},{"$nulls":4},-50,5.680158210452646]
[18,{"v":4284.855621682509,"d":"4285"},{"$nulls":4},100,4.855621682509081]
[19,{"v":4213.285242655693,"d":"4213"},{"$nulls":4},20,3.285242655692855]
[20,{"v":4358.620077096566,"d":"4359"},{"$nulls":4},150,8.620077096566092]
[21,{"v":4142.668668963015,"d":"4143"},{"$nulls":4},-50,-17.33133103698492]
[22,{"v":4311.495815265807,"d":"4311"},{"$nulls":4},100,-8.504184734192677]
[23,{"v":4239.535604072444,"d":"4240"},{"$nulls":4},20,-10.464395927556325]
[24,{"v":4390.379907305614,"d":"4390"},{"$nulls":4},150,0.3799073056143243]
[25,{"v":4210.053940968646,"d":"4210"},{"$nulls":4},-50,10.053940968646202]
[26,{"v":4369.151403901342,"d":"4369"},{"$nulls":4},100,9.151403901341837]
[27,{"v":4297.069002094795,"d":"4297"},{"$nulls":4},20,7.069002094794996]
[28,{"v":4431.732519194775,"d":"4432"},{"$nulls":4},150,1.7325191947747953]
[29,{"v":4219.093718138756,"d":"4219"},{"$nulls":4},-50,-20.90628186124377]
[30,{"v":4393.389201335958,"d":"4393"},{"$nulls":4},100,-6.610798664041795]
[31,{"v":4334.1611201595515,"d":"4334"},{"$nulls":4},20,4.161120159551501]
[32,{"v":4492.940002963878,"d":"4493"},{"$nulls":4},150,22.940002963878214]
[33,{"v":4270.728179000143,"d":"4271"},{"$nulls":4},-50,-9.271820999856573]
[34,{"v":4429.475895745272,"d":"4429"},{"$nulls":4},100,-10.524104254727717]
[35,{"v":4335.989263728261,"d":"4336"},{"$nulls":4},20,-34.010736271739006]
[36,{"v":4511.744172095641,"d":"4512"},{"$nulls":4},150,1.744172095641261]
[37,{"v":4325.745891940023,"d":"4326"},{"$nulls":4},-50,5.745891940023284]
[38,{"v":4479.165584085858,"d":"4479"},{"$nulls":4},100,-0.834415914141573]
[39,{"v":4421.0567270894535,"d":"4421"},{"$nulls":4},20,11.056727089453489]
[40,{"v":4551.073419753084,"d":"4551"},{"$nulls":4},150,1.0734197530837264]
[41,{"v":4375.777322914801,"d":"4376"},{"$nulls":4},-50,15.777322914800607]
[42,{"v":4528.124789019348,"d":"4528"},{"$nulls":4},100,8.1247890193481]
[43,{"v":4451.717774011922,"d":"4452"},{"$nulls":4},20,1.7177740119223017]
[44,{"v":4586.344251940172,"d":"4586"},{"$nulls":4},150,-3.6557480598276015]
[45,{"v":4411.086376616731,"d":"4411"},{"$nulls":4},-50,11.086376616731286]
[46,{"v":4560.369959707314,"d":"4560"},{"$nulls":4},100,0.3699597073136829]
[47,{"v":4478.79259237583,"d":"4479"},{"$nulls":4},20,-11.207407624169718]
[48,{"v":4639.6683152150945,"d":"4640"},{"$nulls":4},150,9.66831521509448]
[49,{"v":4450.802341421368,"d":"4451"},{"$nulls":4},-50,10.8023414213676]
[50,{"v":4600.545321654499,"d":"4601"},{"$nulls":4},100,0.5453216544992756]
[51,{"v":4527.198756318539,"d":"4527"},{"$nulls":4},20,-2.801243681460619]
[52,{"v":4669.675969775126,"d":"4670"},{"$nulls":4},150,-0.32403022487415]

{"sheet":"фикт.пер.","index":5,"n_rows":52,"n_cols":15,"rows_kept":52,"flags":["formulas_cached_only"]}
["t","x1","x2","x3","y(t)"]
[1,0,0,0,3974,null,"ВЫВОД ИТОГОВ"]
[2,1,0,0,4134]
[3,0,1,0,4054,null,"Регрессионная статистика"]
[4,0,0,1,4200,null,"Множественный R",0.9975234838006828]
[5,0,0,0,3995,null,"R-квадрат",0.9950531007338511]
[6,1,0,0,4162,null,"Нормированный R-квадрат",0.9940116482567671]
[7,0,1,0,4091,null,"Стандартная ошибка",8.560780771550354]
[8,0,0,1,4224,null,"Наблюдения",24]
[9,0,0,0,4038]
[10,1,0,0,4191,null,"Дисперсионный анализ"]
[11,0,1,0,4125,null,null,"df","SS","MS","F","Значимость F"]
[12,0,0,1,4259,null,"Регрессия",4,280087.38095238095,70021.84523809524,955.4474377169445,1.304383423991573e-21]
[13,0,0,0,4079,null,"Остаток",19,1392.4523809523794,73.28696741854628]
[14,1,0,0,4240,null,"Итого",23,281479.8333333333]
[15,0,1,0,4181]
[16,0,0,1,4320,null,null,"Коэффициенты","Стандартная ошибка","t-статистика","P-Значение","Нижние 95%","Верхние 95%","Нижние 95.0%","Верхние 95.0%"]
[17,0,0,0,4126,null,"Y-пересечение",3954.0773809523807,4.48688137158252,881.2529357239905,2.805456947025105e-45,3944.6862303328126,3963.468531571949,3944.6862303328126,3963.468531571949]
[18,1,0,0,4285,null,"t",9.553571428571432,0.2558022524099187,37.3474875164977,3.012173198061702e-19,9.018171162270427,10.088971694872438,9.018171162270427,10.088971694872438]
[19,0,1,0,4213,null,"x1",151.77976190476193,4.9491841683103095,30.66763263258816,1.2008636641088658e-17,141.4210004133275,162.13852339619635,141.4210004133275,162.13852339619635]
[20,0,0,1,4359,null,"x2",72.39285714285717,4.968976585663026,14.568967250063539,9.181870262357185e-12,61.992669645898744,82.79304463981559,61.992669645898744,82.79304463981559]
[21,0,0,0,4143,null,"x3",204.1726190476191,5.001789906679139,40.81991104324018,5.673995444433395e-20,193.70375248061833,214.64148561461985,193.70375248061833,214.64148561461985]
[22,1,0,0,4311]
[23,0,1,0,4240]
[24,0,0,1,4390]
[{"$nulls":6},"ВЫВОД ОСТАТКА"]
[]
[{"$nulls":6},"Наблюдение","Предсказанное y(t)","Остатки",null,null,25]
[{"$nulls":6},1,3963.6309523809523,10.369047619047706,null,"Y=",4192.916666666667]
[{"$nulls":6},2,4124.964285714285,9.035714285714675]
[{"$nulls":6},3,4055.1309523809523,-1.1309523809522943]
[{"$nulls":6},4,4196.464285714285,3.5357142857146755]
[{"$nulls":6},5,4001.845238095238,-6.845238095238074]
[{"$nulls":6},6,4163.178571428571,-1.178571428570649]
[{"$nulls":6},7,4093.345238095238,-2.3452380952380736]
[{"$nulls":6},8,4234.678571428572,-10.678571428571558]
[{"$nulls":6},9,4040.059523809524,-2.059523809523853]
[{"$nulls":6},10,4201.392857142857,-10.392857142856883]
[{"$nulls":6},11,4131.559523809524,-6.559523809523853]
[{"$nulls":6},12,4272.892857142857,-13.892857142856883]
[{"$nulls":6},13,4078.273809523809,0.7261904761908227]
[{"$nulls":6},14,4239.607142857143,0.392857142856883]
[{"$nulls":6},15,4169.773809523809,11.226190476190823]
[{"$nulls":6},16,4311.107142857143,8.892857142856883]
[{"$nulls":6},17,4116.488095238095,9.511904761904589]
[{"$nulls":6},18,4277.8214285714275,7.178571428572468]
[{"$nulls":6},19,4207.9880952380945,5.011904761905498]
[{"$nulls":6},20,4349.321428571428,9.678571428571558]
[{"$nulls":6},21,4154.702380952381,-11.702380952380736]
[{"$nulls":6},22,4316.035714285714,-5.035714285713766]
[{"$nulls":6},23,4246.202380952381,-6.202380952380736]
[{"$nulls":6},24,4387.535714285715,2.4642857142853245]