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

{"sheet":"Лист1","index":0,"n_rows":82,"n_cols":8,"rows_kept":82,"hidden":true,"merged":[[60,0,61,0],[60,1,60,2]],"flags":["formulas_cached_only"]}
[{"$nulls":6},"задача 2.6"]
[5,43,215,{"v":1.5076923076923077,"d":"1.5"},{"v":64.83076923076923,"d":"64.8"},{"v":97.74485207100592,"d":"97.7"}]
[6,32,192,{"v":0.5076923076923077,"d":"0.5"},{"v":16.246153846153845,"d":"16.2"},{"v":8.248047337278106,"d":"8.2"}]
[7,25,175,{"v":0.49230769230769234,"d":"0.5"},{"v":12.307692307692308,"d":"12.3"},{"v":6.059171597633137,"d":"6.1"}]
[8,13,104,{"v":1.4923076923076923,"d":"1.5"},19.4,{"v":28.95076923076923,"d":"29.0"}]
[9,10,90,{"v":2.4923076923076923,"d":"2.5"},{"v":24.923076923076923,"d":"24.9"},{"v":62.11597633136095,"d":"62.1"}]
[10,7,70,{"v":3.4923076923076923,"d":"3.5"},{"v":24.446153846153848,"d":"24.4"},{"v":85.37349112426037,"d":"85.4"}]
[null,130,846,{"v":9.984615384615385,"d":"10.0"},{"v":162.1538461538462,"d":"162.2"},{"v":288.4923076923077,"d":"288.5"}]
[]
["х=",{"v":6.507692307692308,"d":"6.5"}]
[]
[]
["группы ком банков по размеру активов, млн. руб","удельный вес банков в % к итогу","середина интервалов , Х","x f","x f"]
["до 200",8,150,1200,180000]
["200-300",25,250,6250,1562500]
["300-400",50,350,17500,6125000]
["400-500",5,450,2250,1012500]
["500-600",10,550,5500,3025000]
["600 и более",2,650,1300,845000]
["итого",100,null,34000,12750000]
[]
["Выполнение норм выработки, %","Число рабочих","середина интервалов , Х","x f","(х-Х)","(х-Х)*f","(х-Х)*f","задача 2.20"]
[1,2,3,4,5,6,7]
["До 100",20,95,1900,21.700000000000003,434.00000000000006,9417.800000000003]
["100 – 110",76,105,7980,11.700000000000003,889.2000000000003,10403.640000000005]
["110 – 120",184,115,21160,1.7000000000000028,312.8000000000005,531.7600000000018]
["120 – 130",66,125,8250,8.299999999999997,547.7999999999998,4546.739999999997]
["130 – 140",44,135,5940,18.299999999999997,805.1999999999998,14735.159999999994]
["140 и более",10,145,1450,28.299999999999997,283,8008.9]
["Итого",400,null,46680,90,3272.0000000000005,47644.00000000001]
[]
["Х=",116.7]
[]
[]
["Урожайность, ц/1 га","Посевная площадь, га","середина интервалов , Х","x f","(х-Х)","(х-Х)*f","(х-Х)*f","задача 2.49"]
[1,2,3,4,5,6,7]
["28-30",2,29,58,{"v":6.840000000000003,"d":"6.8"},{"v":13.680000000000007,"d":"13.7"},{"v":93.57120000000009,"d":"93.6"}]
["30-32",7,31,217,{"v":4.840000000000003,"d":"4.8"},{"v":33.880000000000024,"d":"33.9"},{"v":163.97920000000022,"d":"164.0"}]
["32-34",16,33,528,{"v":2.8400000000000034,"d":"2.8"},{"v":45.440000000000055,"d":"45.4"},{"v":129.0496000000003,"d":"129.0"}]
["34-36",25,35,875,{"v":0.8400000000000034,"d":"0.8"},{"v":21.000000000000085,"d":"21.0"},{"v":17.640000000000143,"d":"17.6"}]
["36-38",30,37,1110,{"v":1.1599999999999966,"d":"1.2"},{"v":34.7999999999999,"d":"34.8"},{"v":40.36799999999976,"d":"40.4"}]
["38-40",12,39,468,{"v":3.1599999999999966,"d":"3.2"},{"v":37.91999999999996,"d":"37.9"},{"v":119.82719999999973,"d":"119.8"}]
["40-42",8,41,328,{"v":5.159999999999997,"d":"5.2"},{"v":41.27999999999997,"d":"41.3"},{"v":213.0047999999997,"d":"213.0"}]
["Итого",100,null,3584,null,228,777.4399999999999]
[]
["Х=",{"v":35.84,"d":"35.8"}]
[]
[]
["Размер пенсии, руб.","Удельный вес пенсионеров, %","середина интервалов , Х","x f","(х-Х)","(х-Х)*f","(х-Х)*f","задача 2.50"]
[1,2,3,4,5,6,7]
["До 600",3,575,1725,213.5,640.5,{"v":136746.75,"d":"136746.8"}]
["650-700",15,675,10125,113.5,1702.5,{"v":193233.75,"d":"193233.8"}]
["750-800",50,775,38750,13.5,{"v":675,"d":"675.0"},9112.5]
["850-900",30,875,26250,86.5,{"v":2595,"d":"2595.0"},224467.5]
["950-1000",1,975,975,186.5,186.5,{"v":34782.25,"d":"34782.3"}]
["Свыше  1000",1,1025,1025,236.5,236.5,{"v":55932.25,"d":"55932.3"}]
["Итого",100,null,78850,null,6036,654275]
[]
["Х=",788.5]
[]
["Номер цеха","Расход материала, м",null,null,"задача 2.55"]
[null,"на одно изделие,\nх","на все изделия,\nw=x*f","f=w/x"]
[1,0.6,150,250]
[2,0.7,126,180]
[3,0.9,261,290]
[4,0.4,200,500]
[5,0.5,250,500]
[6,1.3,260,200]
[7,1.4,420,300]
["итого",null,1667,2220]
[]
[]
[]
["Размер вклада, руб.","Число вкладчиков","середина интервалов , Х","x f","(х-Х)","(х-Х)*f","(х-Х)*f","задача 2.60"]
["До 400",32,300,9600,480,15360,7372800]
["400-600",56,500,28000,280,15680,4390400]
["600-800",120,700,84000,80,9600,768000]
["800-1000",104,900,93600,120,12480,1497600]
["Свыше 1000",88,1100,96800,320,28160,9011200]
["Итого",400,3500,312000,1280,81280,23040000]
[]
["Х=",{"v":780,"d":"780.0"}]

{"sheet":"вар 6","index":1,"n_rows":72,"n_cols":5,"rows_kept":72,"merged":[[0,0,0,5],[1,0,1,4],[4,0,5,0],[4,3,5,3],[48,0,48,3],[50,0,50,5],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2],[60,0,60,2],[61,0,61,2],[63,0,63,5],[64,0,64,5],[65,0,65,5],[66,0,66,5],[67,0,67,5],[68,0,68,5],[69,0,69,5],[70,0,70,5],[71,0,71,5]],"flags":["formulas_cached_only"]}
["Задача 1.6"]
["Проведите группировку кредитной задолженности банка по характеру погашения ссуд. По каждой группе рассчитайте удельный вес и средний срок кредита. Результаты расчета оформите в виде таблицы."]
[{"$nulls":4},"Таблица 1.1"]
[]
["№ п/п","Сумма кредита, тыс. руб.","Срок кредита,","Вид обеспечения","Характер"]
[null,null,"дней",null,"погашения"]
[1,2,3,4,5]
[1,1000,30,"Залог","в срок"]
[2,700,180,"Залог","в срок"]
[3,5000,360,"Гарантия","в срок"]
[4,20000,360,"Залог","просрочена"]
[5,5,30,"нет обеспечения","в срок"]
[6,45000,90,"Страховка","в срок"]
[7,100000,360,"нет обеспечения","в срок"]
[8,10,30,"Залог","в срок"]
[9,50,30,"Залог","в срок"]
[10,70,30,"Страховка","просрочена"]
[11,100,5,"нет обеспечения","в срок"]
[12,280,360,"Страховка","просрочена"]
[13,560,90,"Гарантия","в срок"]
[14,20000,360,"Залог","в срок"]
[15,90000,720,"Залог","в срок"]
[16,100,7,"Залог","в срок"]
[17,50,30,"нет обеспечения","в срок"]
[18,600,360,"Залог","в срок"]
[19,72,180,"Гарантия","просрочена"]
[20,500,90,"Страховка","в срок"]
[21,840,90,"Страховка","просрочена"]
[22,1000,30,"Залог","в срок"]
[23,100000,10,"Залог","в срок"]
[24,48,90,"Залог","в срок"]
[25,50,270,"Залог","в срок"]
[26,10,10,"Гарантия","в срок"]
[27,800,30,"нет обеспечения","просрочена"]
[28,56,360,"Страховка","в срок"]
[29,4,90,"нет обеспечения","просрочена"]
[30,5,30,"Залог","просрочена"]
[31,20000,180,"Залог","просрочена"]
[32,10,30,"Гарантия","в срок"]
[33,40,5,"Залог","в срок"]
[34,40,10,"нет обеспечения","в срок"]
[35,18,360,"Залог","в срок"]
[36,56,360,"Страховка","в срок"]
[37,100000,30,"Страховка","просрочена"]
[38,20000,360,"Залог","в срок"]
[39,10,270,"Гарантия","в срок"]
[40,20000,270,"Залог","в срок"]
[]
["Задача 2.6"]
[]
["По данным обследования рабочих-сдельщиков машиностроительного завода получено следующее распределение их по проценту выполнения норм выработки:"]
[]
[]
["Выполнение норм выработки, %",null,null,"Число рабочих"]
[1,null,null,2]
["До 110",null,null,123]
["110-130",null,null,99]
["130-150",null,null,48]
["150-170",null,null,24]
["170-190",null,null,45]
["190 и более",null,null,20]
["Итого",null,null,359]
[]
["Для характеристики вариации выполнения норм рабочими вычислите:"]
["а) среднее линейное отклонение;"]
["а) среднее линейное отклонение;"]
["б) размах вариации, дисперсию, среднее квадратическое отклонение, коэффицент вариации;"]
["в) коэффициент вариации;"]
["г) моду и медиану."]
["д)представьте данные в графическом виде (постройте гистограмму, полигон частот, кумуляту)"]
[]
["Сделайте выводы."]