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

{"sheet":"Лист1","index":0,"n_rows":91,"n_cols":14,"rows_kept":91,"flags":["formulas_cached_only"]}
[null,"Данные о рынке строящегося жилья:"]
[]
["№","у","х1","х2","х3","х4","х5","х6","х7","х8",null,null,"Вариант:",1]
[1,15.9,1,1,{"v":39,"d":"39.0"},{"v":20,"d":"20.0"},8.2,0,1,0]
[2,{"v":27,"d":"27.0"},3,1,68.4,40.5,10.7,0,1,0]
[3,13.5,1,1,34.8,{"v":16,"d":"16.0"},10.7,0,1,12]
[4,15.1,1,1,{"v":39,"d":"39.0"},{"v":20,"d":"20.0"},8.5,0,1,12]
[5,{"v":21.099999999999998,"d":"21.1"},2,1,54.7,{"v":28,"d":"28.0"},10.7,0,1,12]
[6,28.7,3,1,74.7,46.3,10.7,0,1,12]
[7,27.2,3,1,71.7,45.9,10.7,0,{"v":0,"d":"0.0"},0]
[8,28.3,3,1,74.5,47.5,10.4,0,{"v":0,"d":"0.0"},0]
[9,52.3,4,1,137.7,87.2,14.6,0,1,0]
[10,{"v":22,"d":"22.0"},1,1,{"v":40,"d":"40.0"},17.7,{"v":11,"d":"11.0"},1,1,8]
[11,{"v":28,"d":"28.0"},2,1,{"v":53,"d":"53.0"},31.1,{"v":10,"d":"10.0"},1,1,8]
[12,{"v":45,"d":"45.0"},3,1,{"v":86,"d":"86.0"},48.7,{"v":14,"d":"14.0"},1,1,8]
[13,{"v":51,"d":"51.0"},4,1,{"v":98,"d":"98.0"},65.8,{"v":13,"d":"13.0"},1,1,8]
[14,34.4,2,1,62.6,21.4,{"v":11,"d":"11.0"},1,1,0]
[15,24.7,1,1,45.3,20.6,10.4,1,1,8]
[16,30.8,2,1,56.4,29.7,9.4,1,1,8]
[17,15.9,1,1,{"v":37,"d":"37.0"},17.8,8.3,0,1,0]
[18,{"v":29,"d":"29.0"},3,1,67.5,43.5,8.3,0,1,0]
[19,15.4,2,1,{"v":37,"d":"37.0"},17.8,8.3,0,1,3]
[20,28.6,3,1,{"v":69,"d":"69.0"},42.4,8.3,1,1,3]
[21,15.6,1,1,{"v":40,"d":"40.0"},{"v":20,"d":"20.0"},8.3,0,{"v":0,"d":"0.0"},0]
[22,{"v":27.700000000000003,"d":"27.7"},3,1,69.1,41.3,8.3,0,1,0]
[23,34.1,2,1,68.1,35.4,{"v":13,"d":"13.0"},1,1,20]
[24,37.7,2,1,75.3,41.4,12.1,1,1,20]
[25,41.9,3,1,83.7,48.5,12.1,1,1,20]
[26,24.4,1,1,48.7,22.3,12.4,1,1,20]
[27,21.3,1,1,39.9,{"v":18,"d":"18.0"},8.1,1,{"v":0,"d":"0.0"},0]
[28,36.7,2,1,68.6,35.5,{"v":17,"d":"17.0"},1,{"v":1,"d":"1.0"},12]
[29,21.5,1,1,{"v":39,"d":"39.0"},{"v":20,"d":"20.0"},9.2,1,{"v":0,"d":"0.0"},0]
[30,26.4,2,1,48.6,{"v":31,"d":"31.0"},{"v":8,"d":"8.0"},1,{"v":0,"d":"0.0"},0]
[31,53.9,3,1,{"v":98,"d":"98.0"},{"v":56,"d":"56.0"},{"v":22,"d":"22.0"},1,{"v":0,"d":"0.0"},0]
[32,34.2,2,1,68.5,30.7,8.3,1,{"v":1,"d":"1.0"},6]
[33,35.6,2,1,71.1,36.2,13.3,1,1,6]
[34,{"v":34,"d":"34.0"},3,1,{"v":68,"d":"68.0"},{"v":41,"d":"41.0"},{"v":8,"d":"8.0"},1,1,12]
[35,{"v":19,"d":"19.0"},1,1,{"v":38,"d":"38.0"},{"v":19,"d":"19.0"},7.4,1,1,12]
[36,46.6,2,1,93.2,49.5,{"v":14,"d":"14.0"},1,1,12]
[37,58.5,3,1,{"v":117,"d":"117.0"},55.2,{"v":25,"d":"25.0"},1,1,12]
[38,24.2,1,2,{"v":42,"d":"42.0"},{"v":21,"d":"21.0"},10.2,1,{"v":0,"d":"0.0"},12]
[39,35.7,2,2,{"v":62,"d":"62.0"},{"v":35,"d":"35.0"},{"v":11,"d":"11.0"},1,{"v":0,"d":"0.0"},12]
[40,51.2,3,2,{"v":89,"d":"89.0"},52.3,11.5,1,1,12]
[41,75.9,4,2,{"v":132,"d":"132.0"},89.6,{"v":11,"d":"11.0"},1,1,12]
[42,21.2,1,2,40.8,19.2,10.1,1,1,6]
[43,39.8,2,2,59.2,31.9,11.2,1,1,6]
[44,{"v":34,"d":"34.0"},3,2,65.4,38.9,9.3,1,1,6]
[45,31.9,2,2,60.2,36.3,10.9,1,1,12]
[46,43.6,3,2,82.2,49.7,13.8,1,1,12]
[47,52.2,3,2,98.4,52.3,15.3,1,1,12]
[48,43.1,3,3,76.7,44.7,{"v":8,"d":"8.0"},1,1,0]
[49,{"v":25,"d":"25.0"},1,3,38.7,{"v":20,"d":"20.0"},10.2,1,1,6]
[50,35.2,2,3,56.4,32.7,10.1,1,1,6]
[51,40.8,3,3,76.7,44.7,{"v":8,"d":"8.0"},1,1,6]
[52,18.2,1,3,38.7,{"v":20,"d":"20.0"},10.2,1,{"v":0,"d":"0.0"},0]
[53,20.1,1,3,41.5,{"v":20,"d":"20.0"},10.2,1,{"v":1,"d":"1.0"},0]
[54,22.7,2,3,48.8,28.5,{"v":8,"d":"8.0"},1,{"v":0,"d":"0.0"},0]
[55,27.6,2,3,57.4,33.5,10.1,1,{"v":1,"d":"1.0"},0]
[56,{"v":36,"d":"36.0"},3,3,76.7,44.7,{"v":8,"d":"8.0"},1,1,0]
[57,17.8,1,4,{"v":37,"d":"37.0"},17.5,8.3,0,1,7]
[58,25.9,2,4,{"v":54,"d":"54.0"},30.5,8.3,0,1,7]
[59,32.6,3,4,{"v":68,"d":"68.0"},42.5,8.3,0,1,7]
[60,19.8,1,4,40.5,{"v":16,"d":"16.0"},{"v":11,"d":"11.0"},0,1,3]
[61,29.9,2,4,{"v":61,"d":"61.0"},{"v":31,"d":"31.0"},{"v":11,"d":"11.0"},0,1,3]
[62,39.2,3,4,{"v":80,"d":"80.0"},45.6,{"v":11,"d":"11.0"},0,1,3]
[63,22.4,1,3,{"v":52,"d":"52.0"},21.2,11.2,1,1,18]
[64,{"v":35.199999999999996,"d":"35.2"},2,3,78.1,{"v":40,"d":"40.0"},11.6,1,1,18]
[65,41.2,3,3,91.6,53.8,{"v":16,"d":"16.0"},1,{"v":0,"d":"0.0"},18]
[66,17.8,1,4,39.9,19.3,8.4,0,{"v":1,"d":"1.0"},6]
[67,{"v":25,"d":"25.0"},2,4,56.2,31.4,11.1,0,{"v":1,"d":"1.0"},6]
[68,35.2,3,4,79.1,42.4,15.5,0,{"v":1,"d":"1.0"},6]
[69,40.8,4,4,91.6,55.2,9.4,0,{"v":1,"d":"1.0"},6]
[]
[]
["у - цена квартиры, млн. руб;"]
["х1 - число комнат в квартире;"]
["х2- район города (1, 2, 3, 4);"]
["х3 - общая площадь квартиры (м2);"]
["х4 - жилая площадь квартиры (м2);"]
["х5 - площадь кухни (м2);"]
["х6 - тип дома (1 - кирпичный, 0 - другой);"]
["х7- наличие балкона (1-есть, 0 -нет);"]
["х8 - число месяцев до окончания срока строительства."]
[]
[]
["Требуется:"]
[]
["1. Выявите наличие фиктивных переменных; сформируйте фиктивную переменную z, отражающую местоположение квартиры и позволяющую разделить всю совокупность квартир на две группы: квартиры на севере города (1, 2) и на юге (3, 4)."]
["2. Составьте матрицу парных коэффициентов корреляции. Вместо переменной x2 используйте фиктивную переменную z. Для дальнешего анализа используйте наиболее существенные факторы."]
["3. Постройте уравнение множественной регрессии в линейной форме со статистически значимыми факторами?"]
["4. Постройте частные уравнения регрессии. Рассчитайте частные коэффициенты эластичности."]

{"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"]}