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

{"sheet":"Лист1","index":0,"n_rows":184,"n_cols":9,"rows_kept":184,"flags":["formulas_cached_only"]}
[]
[{"$nulls":6},"в процентах"]
[null," y1"," y2","y3","x1"," x2","x3"]
[1,99.8,92.3,83.8,65.6,99.8,105.1]
[2,99.9,{"v":82,"d":"82.0"},106.2,114.4,109.4,87.8]
[3,99.9,91.5,83.7,66.8,92.2,97.5]
[4,{"v":100,"d":"100.0"},99.4,111.5,130.1,102.7,{"v":105,"d":"105.0"}]
[5,100.2,91.9,80.6,61.3,95.1,105.7]
[6,100.7,82.5,108.4,114.3,113.8,{"v":106,"d":"106.0"}]
[7,100.8,91.7,91.5,85.7,94.3,106.3]
[8,101.1,{"v":99,"d":"99.0"},121.5,122.3,113.9,107.7]
[9,101.4,97.7,{"v":105,"d":"105.0"},134.8,105.1,91.2]
[10,101.9,98.7,106.3,121.7,104.7,98.1]
[11,{"v":102,"d":"102.0"},89.3,115.1,122.6,{"v":112,"d":"112.0"},97.8]
[12,{"v":102,"d":"102.0"},82.8,{"v":111,"d":"111.0"},117.6,112.6,113.5]
[13,{"v":102,"d":"102.0"},102.5,115.5,126.7,115.1,119.3]
[14,102.1,87.5,110.5,120.9,114.2,118.2]
[15,102.2,90.1,117.5,121.7,111.9,117.3]
[16,102.2,88.8,110.3,127.6,111.7,91.1]
[17,102.3,99.4,110.1,123.1,111.3,{"v":99,"d":"99.0"}]
[18,102.3,98.2,95.6,111.4,99.5,91.7]
[19,102.5,96.7,117.8,118.6,111.4,113.2]
[20,102.5,101.6,127.1,122.6,114.1,111.6]
[21,103.1,79.4,113.9,119.6,112.9,110.6]
[22,103.1,103.1,119.5,127.5,114.1,105.5]
[23,103.1,98.9,118.3,{"v":119,"d":"119.0"},111.9,100.4]
[24,103.3,103.8,118.7,128.9,113.9,103.6]
[25,103.4,96.8,123.9,120.7,114.4,100.9]
[26,103.5,97.9,118.6,121.6,111.8,101.6]
[27,103.5,98.8,{"v":113,"d":"113.0"},{"v":121,"d":"121.0"},{"v":111,"d":"111.0"},99.2]
[28,103.5,99.7,99.3,100.3,106.1,91.3]
[]
["Для первого уравнения приведенной формы модели получаем"]
["ВЫВОД ИТОГОВ"]
[]
["Регрессионная статистика"]
["Множественный R",0.9989355566519796]
["R-квадрат",0.9978722463436004]
["Нормированный R-квадрат",0.9577020260510883]
["Стандартная ошибка",4.976695287472651]
["Наблюдения",28]
[]
["Дисперсионный анализ"]
[null,"df","SS","MS","F","Значимость F"]
["Регрессия",3,290386.0226003911,96795.34086679704,3908.160151835696,2.1261627888490608e-32]
["Остаток",25,619.1873996088124,24.767495984352493]
["Итого",28,291005.21]
[]
[null,"Коэффициенты","Стандартная ошибка","t-статистика","P-Значение","Нижние 95%","Верхние 95%","Нижние 95,0%","Верхние 95,0%"]
["Y-пересечение",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["x1",-0.17125162369027264,0.07322429790418031,-2.3387267422402425,0.027644757234735032,-0.3220598869704766,-0.020443360410068695,-0.3220598869704766,-0.020443360410068695]
[" x2",1.0145995572270952,0.16636653737653437,6.098579517410826,2.251787212262032e-06,0.6719612624560374,1.357237851998153,0.6719612624560374,1.357237851998153]
["x3",0.10654499310433078,0.1211157665162367,0.8796954861367898,0.3874023240690202,-0.14289759531168716,0.35598758152034876,-0.14289759531168716,0.35598758152034876]
[]
[]
["Анализируя качество уравнения регрессии и его параметров получаем уравнение:"]
{"$rows_empty":8}
["Для второго уравнения приведенной формы модели получаем"]
[]
["ВЫВОД ИТОГОВ"]
[]
["Регрессионная статистика"]
["Множественный R",0.9959007494299847]
["R-квадрат",0.9918183027152052]
["Нормированный R-квадрат",0.9511637669324216]
["Стандартная ошибка",9.055827888836415]
["Наблюдения",28]
[]
["Дисперсионный анализ"]
[null,"df","SS","MS","F","Значимость F"]
["Регрессия",3,248533.5595311943,82844.51984373144,1010.2002353456601,2.2220444382696664e-25]
["Остаток",25,2050.2004688056854,82.00801875222741]
["Итого",28,250583.76]
[]
[null,"Коэффициенты","Стандартная ошибка","t-статистика","P-Значение","Нижние 95%","Верхние 95%","Нижние 95,0%","Верхние 95,0%"]
["Y-пересечение",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["x1",-0.04056478911165585,0.13324236281259083,-0.30444363380669986,0.7633097928454016,-0.3149825699063899,0.23385299168307822,-0.3149825699063899,0.23385299168307822]
[" x2",0.7469975102116613,0.3027283452004686,2.46755060123952,0.020800848968783505,0.12351681743513965,1.370478202988183,0.12351681743513965,1.370478202988183]
["x3",0.16985376440091315,0.22038792267559812,0.7707035954548691,0.4481055018625314,-0.284043655143227,0.6237511839450534,-0.284043655143227,0.6237511839450534]
[]
["Анализируя качество уравнения регрессии и его параметров получаем уравнение:"]
{"$rows_empty":9}
["Для третьего уравнения приведенной формы модели получаем"]
[]
["ВЫВОД ИТОГОВ"]
[]
["Регрессионная статистика"]
["Множественный R",0.999115451359126]
["R-квадрат",0.9982316851445501]
["Нормированный R-квадрат",0.958090219956114]
["Стандартная ошибка",4.883853816392159]
["Наблюдения",28]
[]
["Дисперсионный анализ"]
[null,"df","SS","MS","F","Значимость F"]
["Регрессия",3,336617.79929750285,112205.93309916761,4704.251253992664,2.3080747676280604e-33]
["Остаток",25,596.3007024972065,23.852028099888262]
["Итого",28,337214.1]
[]
[null,"Коэффициенты","Стандартная ошибка","t-статистика","P-Значение","Нижние 95%","Верхние 95%","Нижние 95,0%","Верхние 95,0%"]
["Y-пересечение",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["x1",0.3621625893940273,0.07185828066913423,5.039956230814599,3.361150833219539e-05,0.21416769124977453,0.51015748753828,0.21416769124977453,0.51015748753828]
[" x2",0.5301424417150364,0.16326292882178017,3.2471697374346777,0.003309516775321307,0.1938961483620945,0.8663887350679784,0.1938961483620945,0.8663887350679784]
["x3",0.10012778175362541,0.11885632218925257,0.8424270573860928,0.40753634971535935,-0.14466139400179354,0.3449169575090444,-0.14466139400179354,0.3449169575090444]
[]
[]
[]
[]
[]
["Анализируя качество уравнения регрессии и его параметров получаем уравнение:"]
{"$rows_empty":8}
["Таким образом имеем приведенную систему уравнений:"]
{"$rows_empty":15}
["Далее находим параметры уравнений структурной модели (идентификация структурной модели)."]
[]
[]
["Из 2-го уравнения выражаем х2 подставляем в первое уравнение, получаем первое уравнение структурной формы модели:"]
[]
[]
[]
[]
["коэф. B13=0"]
[]
["Второе уравнение структурной формы модели получаем сразу из второго уравнения приведенной формы модели"]
[]
[]
[]
[]
["где коэф. b21 и b23 равны 0"]
[]
[]
["Для получения третьего уравнения структурной формы модели выражаем из 1-го уравнения приведенной формы модели x1, из второго - x2"]
{"$rows_empty":8}
["Подставляя x1 и x2 в y3 получаем "]
[]
[]
[]
[]
["где а33=0"]
[]
["Таким образом, структурная форма модели, которую мы можем использовать для прогноза, имеет вид"]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}