{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Задача 1","Лист2"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

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

{"sheet":"Лист2","index":1,"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]