{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Данные","Регрессия","Товары"],"not_rendered":{"charts":1,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Данные","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["№","Год","Перевезено грузов, тыс.т","Грузооборот, млн.т.км","Погрузка грузов, млн.т"]
[null,null,"у","х1","х2"]
[1,2010,139937,45224,79.599999999999994]
[2,2011,152775,49406,85.6]
[3,2015,153673,48351,89.1]
[4,2013,140040,43818,79.5]
[5,2014,141437,44997,83.5]
[6,2015,131439,40785,80.3]
[7,2016,{"$f":"2.12*D9+564.46*E9+44.55","v":140873.65148484873},{"$f":"FORECAST($B9,$D$3:$D$8,$B$3:$B$8)","v":43900.848484848626},{"$f":"FORECAST($B9,$E$3:$E$8,$B$3:$B$8)","v":84.61060606060596},"прогноз"]
[8,2017,{"$f":"2.12*D10+564.46*E10+44.55","v":140108.51775757613},{"$f":"FORECAST($B10,$D$3:$D$8,$B$3:$B$8)","v":43391.07575757592},{"$f":"FORECAST($B10,$E$3:$E$8,$B$3:$B$8)","v":85.169696969697043},"прогноз"]
[9,2018,{"$f":"2.12*D11+564.46*E11+44.55","v":139343.38403030319},42881.303030303097,85.728787878787898,"прогноз"]
[null,2019]
[null,2020]
[{"$f":"CONCATENATE(\"y=\",ROUND(Регрессия!B18,2),\"*х1 +\",ROUND(Регрессия!B19,2),\"*x2 + \",ROUND(Регрессия!B17,2))","v":"y=2,12*х1 +564,46*x2 + 44,55"}]
[]
["y = -2575,3x + 152231\nR² = 0,3194"]

{"sheet":"Регрессия","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["ВЫВОД ИТОГОВ"]
[]
["Регрессионная статистика"]
["Множественный R",0.98890623139174205]
["R-квадрат",0.97793553448541759]
["Нормированный R-квадрат",0.96322589080902932]
["Стандартная ошибка",1634.9079529092874]
["Наблюдения",6]
[]
["Дисперсионный анализ"]
[null,"df","SS","MS","F","Значимость F"]
["Регрессия",2,355405940.78987527,177702970.39493763,66.482612087686789,3.2774805076616724E-3]
["Остаток",3,8018772.0434581088,2672924.0144860363]
["Итого",5,363424712.83333337]
[]
[null,"Коэффициенты","Стандартная ошибка","t-статистика","P-Значение","Нижние 95%","Верхние 95%"]
["Y-пересечение",44.55312849713664,15803.6172002077,2.8191728471220561E-3,0.99792761505793326,-50249.610034150595,50338.716291144869]
["Переменная X 1",2.1210521274488179,0.36903325233941914,5.7475908038172552,1.0461645249511944E-2,0.94662361716084598,3.29548063773679]
["Переменная X 2",564.45974935066533,296.92971442981769,1.9009877486817879,0.15348206057232885,-380.50312314762448,1509.4226218489553]
[]
[]
[]
["ВЫВОД ОСТАТКА"]
[]
["Наблюдение","Предсказанное Y","Остатки"]
[1,140898.01058855542,-961.01058855542215]
[2,153155.00908165038,-380.00908165037981]
[3,152892.90820991923,780.09179008076899]
[4,137859.36532242733,2180.6346775726706]
[5,142617.92477809213,-1180.9247780921287]
[6,131877.7820193556,-438.78201935559628]

{"sheet":"Товары","index":2,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,2,15,3],[16,2,16,3]]}
[null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[null,"Погружено грузов - всего",79.599999999999994,85.6,89.1,79.5,83.5,80.3,{"$f":"FORECAST(I1,$C2:$H2,$C1:$H1)","v":81.693333333333271},{"$f":"FORECAST(J1,$C2:$H2,$C1:$H1)","v":81.339047619047619},80.984761904761854]
[null,"нефть и нефтепродукты",17.7,23,24.6,19.8,21.4,22.5,{"$f":"FORECAST(I1,C3:H3,$C$1:$H$1)","v":22.939999999999941},{"$f":"FORECAST(J1,$C$3:$H$3,$C$1:$H$1)","v":23.351428571428528},23.762857142857115]
[null,"черные металлы",2.2999999999999998,2.2999999999999998,2.4,2,2.1,2.1,{"$f":"FORECAST(I1,C4:H4,C1:H1)","v":2},{"$f":"FORECAST(J1,D4:I4,D1:I1)","v":1.9200000000000159},1.8466666666666924]
[null,"химические и минеральные удобрения",12.8,12.8,12,10.1,13.1,13.3,{"$f":"FORECAST(I$1,$C5:$H5,C$1:H$1)","v":12.500000000000014},{"$f":"FORECAST(J$1,$C5:$H5,C$1:H$1)","v":12.542857142857159},{"$f":"FORECAST(K$1,$C5:$H5,$C$1:$H$1)","v":12.585714285714303}]
[null,"цемент",3.4,3.4,3.5,3.8,4.3,3.6,{"$f":"FORECAST(I$1,$C6:$H6,$C$1:$H$1)","v":4.0666666666666629},{"$f":"FORECAST(J$1,$C6:$H6,$C$1:$H$1)","v":4.1809523809523625},4.2952380952380906]
[null,"лесные грузы",4.2,4.3,4.7,4.9000000000000004,5.8,6.6,{"$f":"FORECAST(I$1,$C7:$H7,$C1:$H1)","v":6.7533333333333303},{"$f":"FORECAST(J$1,$C7:$H7,$C1:$H1)","v":7.2304761904762245},7.7076190476191186]
[null,"зерно и продукты перемола",2.1,2,1.8,1.6,1.4,1.2,{"$f":"FORECAST(I$1,$C8:$H8,$C1:$H1)","v":1.033333333333303},{"$f":"FORECAST(J$1,$C8:$H8,$C1:$H1)","v":0.84761904761904816},0.66190476190473646]
[null,"строительные грузы",25,23.4,24,24.6,24,20.100000000000001,{"$f":"FORECAST(I$1,$C9:$H9,$C1:$H1)","v":21.306666666666615},{"$f":"FORECAST(J$1,$C9:$H9,$C1:$H1)","v":20.675238095238001},20.043809523809387]
[null,"прочие грузы",12.1,14.4,16.100000000000001,12.7,11.4,10.9,{"$f":"FORECAST(I$1,$C10:$H10,$C1:$H1)","v":11.093333333333476},{"$f":"FORECAST(J$1,$C10:$H10,$C1:$H1)","v":10.567619047619246},10.041904761904789]
[]
[]
[]
[]
[]
[null,"Наименование показателя","Выберите год"]
[null,null,"2012"]
[null,"Погружено грузов - всего, млн.т",83.5]
[null,"нефть и нефтепродукты",21.4]
[null,"черные металлы",2.1]
[null,"химические и минеральные удобрения",13.1]
[null,"цемент",4.3]
[null,"лесные грузы",5.8]
[null,"зерно и продукты перемола",1.4]
[null,"строительные грузы",24]
[null,"прочие грузы",11.4]