{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Рис. 17","Для рис. 18","Формулы"],"not_rendered":{"charts":2,"images":0,"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":"Рис. 17","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,4,1,6],[1,7,2,7]]}
[]
[null,"Элементы выборки",null,null,"Квартили",null,null,"Межквартильный интервал"]
[null,null,null,"Номер метода по Хиндману и Фану ",0.25,0.5,0.75]
[null,2,null,4,{"$f":"Quantile($B$4:$B$13,E$3,$D4)","v":4},{"$f":"Quantile($B$4:$B$13,F$3,$D4)","v":11},18,{"$f":"G4-E4","v":14}]
[null,3,null,5,{"$f":"Quantile($B$4:$B$13,E$3,$D5)","v":5},12,19,{"$f":"G5-E5","v":14}]
[null,5,null,6,4.5,12,20,15.5]
[null,7,null,7,5.5,12,18.5,13]
[null,11,null,8,4.833333333333333,12,19.333333333333336,14.500000000000004]
[null,13,null,9,4.875,12,19.25,14.375]
[null,17]
[null,19]
[null,23]
[null,39]

{"sheet":"Для рис. 18","index":1,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,16,0,20]]}
[null,0.25,0.25,0.25,0.25,0.25,0.5,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0.75,"Межквартильный размах"]
[null,5,6,7,8,9,5,6,7,8,9,5,6,7,8,9,5,6,7,8,9]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8,{"$f":"Quantile($A$3:$A10,B$1,B$2)","v":2.5},{"$f":"Quantile($A$3:$A10,C$1,C$2)","v":2.25},{"$f":"Quantile($A$3:$A10,D$1,D$2)","v":2.75},{"$f":"Quantile($A$3:$A10,E$1,E$2)","v":2.4166666666666665},{"$f":"Quantile($A$3:$A10,F$1,F$2)","v":2.4375},{"$f":"Quantile($A$3:$A10,G$1,G$2)","v":4.5},{"$f":"Quantile($A$3:$A10,H$1,H$2)","v":4.5},{"$f":"Quantile($A$3:$A10,I$1,I$2)","v":4.5},{"$f":"Quantile($A$3:$A10,J$1,J$2)","v":4.5},{"$f":"Quantile($A$3:$A10,K$1,K$2)","v":4.5},{"$f":"Quantile($A$3:$A10,L$1,L$2)","v":6.5},{"$f":"Quantile($A$3:$A10,M$1,M$2)","v":6.75},{"$f":"Quantile($A$3:$A10,N$1,N$2)","v":6.25},{"$f":"Quantile($A$3:$A10,O$1,O$2)","v":6.583333333333333},{"$f":"Quantile($A$3:$A10,P$1,P$2)","v":6.5625},{"$f":"L10-B10","v":4},{"$f":"M10-C10","v":4.5},3.5,4.1666666666666661,4.125]
[9,{"$f":"Quantile($A$3:$A11,B$1,B$2)","v":2.75},{"$f":"Quantile($A$3:$A11,C$1,C$2)","v":2.5},{"$f":"Quantile($A$3:$A11,D$1,D$2)","v":3},{"$f":"Quantile($A$3:$A11,E$1,E$2)","v":2.6666666666666665},{"$f":"Quantile($A$3:$A11,F$1,F$2)","v":2.6875},{"$f":"Quantile($A$3:$A11,G$1,G$2)","v":5},{"$f":"Quantile($A$3:$A11,H$1,H$2)","v":5},{"$f":"Quantile($A$3:$A11,I$1,I$2)","v":5},{"$f":"Quantile($A$3:$A11,J$1,J$2)","v":5},{"$f":"Quantile($A$3:$A11,K$1,K$2)","v":5},{"$f":"Quantile($A$3:$A11,L$1,L$2)","v":7.25},{"$f":"Quantile($A$3:$A11,M$1,M$2)","v":7.5},{"$f":"Quantile($A$3:$A11,N$1,N$2)","v":7},{"$f":"Quantile($A$3:$A11,O$1,O$2)","v":7.333333333333333},{"$f":"Quantile($A$3:$A11,P$1,P$2)","v":7.3125},{"$f":"L11-B11","v":4.5},{"$f":"M11-C11","v":5},{"$f":"N11-D11","v":4},{"$f":"O11-E11","v":4.6666666666666661},{"$f":"P11-F11","v":4.625}]
[10,{"$f":"Quantile($A$3:$A12,B$1,B$2)","v":3},{"$f":"Quantile($A$3:$A12,C$1,C$2)","v":2.75},{"$f":"Quantile($A$3:$A12,D$1,D$2)","v":3.25},{"$f":"Quantile($A$3:$A12,E$1,E$2)","v":2.9166666666666665},{"$f":"Quantile($A$3:$A12,F$1,F$2)","v":2.9375},{"$f":"Quantile($A$3:$A12,G$1,G$2)","v":5.5},{"$f":"Quantile($A$3:$A12,H$1,H$2)","v":5.5},{"$f":"Quantile($A$3:$A12,I$1,I$2)","v":5.5},{"$f":"Quantile($A$3:$A12,J$1,J$2)","v":5.5},{"$f":"Quantile($A$3:$A12,K$1,K$2)","v":5.5},{"$f":"Quantile($A$3:$A12,L$1,L$2)","v":8},{"$f":"Quantile($A$3:$A12,M$1,M$2)","v":8.25},{"$f":"Quantile($A$3:$A12,N$1,N$2)","v":7.75},{"$f":"Quantile($A$3:$A12,O$1,O$2)","v":8.0833333333333339},{"$f":"Quantile($A$3:$A12,P$1,P$2)","v":8.0625},5,5.5,4.5,5.1666666666666679,5.125]
[11,{"$f":"Quantile($A$3:$A13,B$1,B$2)","v":3.25},{"$f":"Quantile($A$3:$A13,C$1,C$2)","v":3},{"$f":"Quantile($A$3:$A13,D$1,D$2)","v":3.5},{"$f":"Quantile($A$3:$A13,E$1,E$2)","v":3.1666666666666665},{"$f":"Quantile($A$3:$A13,F$1,F$2)","v":3.1875},{"$f":"Quantile($A$3:$A13,G$1,G$2)","v":6},{"$f":"Quantile($A$3:$A13,H$1,H$2)","v":6},{"$f":"Quantile($A$3:$A13,I$1,I$2)","v":6},{"$f":"Quantile($A$3:$A13,J$1,J$2)","v":6},{"$f":"Quantile($A$3:$A13,K$1,K$2)","v":6},{"$f":"Quantile($A$3:$A13,L$1,L$2)","v":8.75},{"$f":"Quantile($A$3:$A13,M$1,M$2)","v":9},{"$f":"Quantile($A$3:$A13,N$1,N$2)","v":8.5},{"$f":"Quantile($A$3:$A13,O$1,O$2)","v":8.8333333333333339},{"$f":"Quantile($A$3:$A13,P$1,P$2)","v":8.8125},5.5,6,5,5.6666666666666679,5.625]
[12,{"$f":"Quantile($A$3:$A14,B$1,B$2)","v":3.5},{"$f":"Quantile($A$3:$A14,C$1,C$2)","v":3.25},{"$f":"Quantile($A$3:$A14,D$1,D$2)","v":3.75},{"$f":"Quantile($A$3:$A14,E$1,E$2)","v":3.4166666666666665},{"$f":"Quantile($A$3:$A14,F$1,F$2)","v":3.4375},{"$f":"Quantile($A$3:$A14,G$1,G$2)","v":6.5},{"$f":"Quantile($A$3:$A14,H$1,H$2)","v":6.5},{"$f":"Quantile($A$3:$A14,I$1,I$2)","v":6.5},{"$f":"Quantile($A$3:$A14,J$1,J$2)","v":6.5},{"$f":"Quantile($A$3:$A14,K$1,K$2)","v":6.5},{"$f":"Quantile($A$3:$A14,L$1,L$2)","v":9.5},{"$f":"Quantile($A$3:$A14,M$1,M$2)","v":9.75},{"$f":"Quantile($A$3:$A14,N$1,N$2)","v":9.25},{"$f":"Quantile($A$3:$A14,O$1,O$2)","v":9.5833333333333339},{"$f":"Quantile($A$3:$A14,P$1,P$2)","v":9.5625},6,6.5,5.5,6.1666666666666679,6.125]
[13,{"$f":"Quantile($A$3:$A15,B$1,B$2)","v":3.75},{"$f":"Quantile($A$3:$A15,C$1,C$2)","v":3.5},{"$f":"Quantile($A$3:$A15,D$1,D$2)","v":4},{"$f":"Quantile($A$3:$A15,E$1,E$2)","v":3.6666666666666665},{"$f":"Quantile($A$3:$A15,F$1,F$2)","v":3.6875},{"$f":"Quantile($A$3:$A15,G$1,G$2)","v":7},{"$f":"Quantile($A$3:$A15,H$1,H$2)","v":7},{"$f":"Quantile($A$3:$A15,I$1,I$2)","v":7},{"$f":"Quantile($A$3:$A15,J$1,J$2)","v":7},{"$f":"Quantile($A$3:$A15,K$1,K$2)","v":7},{"$f":"Quantile($A$3:$A15,L$1,L$2)","v":10.25},{"$f":"Quantile($A$3:$A15,M$1,M$2)","v":10.5},{"$f":"Quantile($A$3:$A15,N$1,N$2)","v":10},{"$f":"Quantile($A$3:$A15,O$1,O$2)","v":10.333333333333334},{"$f":"Quantile($A$3:$A15,P$1,P$2)","v":10.3125},6.5,7,6,6.6666666666666679,6.625]
[14,{"$f":"Quantile($A$3:$A16,B$1,B$2)","v":4},{"$f":"Quantile($A$3:$A16,C$1,C$2)","v":3.75},{"$f":"Quantile($A$3:$A16,D$1,D$2)","v":4.25},{"$f":"Quantile($A$3:$A16,E$1,E$2)","v":3.9166666666666665},{"$f":"Quantile($A$3:$A16,F$1,F$2)","v":3.9375},{"$f":"Quantile($A$3:$A16,G$1,G$2)","v":7.5},{"$f":"Quantile($A$3:$A16,H$1,H$2)","v":7.5},{"$f":"Quantile($A$3:$A16,I$1,I$2)","v":7.5},{"$f":"Quantile($A$3:$A16,J$1,J$2)","v":7.5},{"$f":"Quantile($A$3:$A16,K$1,K$2)","v":7.5},{"$f":"Quantile($A$3:$A16,L$1,L$2)","v":11},{"$f":"Quantile($A$3:$A16,M$1,M$2)","v":11.25},{"$f":"Quantile($A$3:$A16,N$1,N$2)","v":10.75},{"$f":"Quantile($A$3:$A16,O$1,O$2)","v":11.083333333333334},{"$f":"Quantile($A$3:$A16,P$1,P$2)","v":11.0625},7,7.5,6.5,7.1666666666666679,7.125]
[15,{"$f":"Quantile($A$3:$A17,B$1,B$2)","v":4.25},{"$f":"Quantile($A$3:$A17,C$1,C$2)","v":4},{"$f":"Quantile($A$3:$A17,D$1,D$2)","v":4.5},{"$f":"Quantile($A$3:$A17,E$1,E$2)","v":4.166666666666667},{"$f":"Quantile($A$3:$A17,F$1,F$2)","v":4.1875},{"$f":"Quantile($A$3:$A17,G$1,G$2)","v":8},{"$f":"Quantile($A$3:$A17,H$1,H$2)","v":8},{"$f":"Quantile($A$3:$A17,I$1,I$2)","v":8},{"$f":"Quantile($A$3:$A17,J$1,J$2)","v":8},{"$f":"Quantile($A$3:$A17,K$1,K$2)","v":8},{"$f":"Quantile($A$3:$A17,L$1,L$2)","v":11.75},{"$f":"Quantile($A$3:$A17,M$1,M$2)","v":12},{"$f":"Quantile($A$3:$A17,N$1,N$2)","v":11.5},{"$f":"Quantile($A$3:$A17,O$1,O$2)","v":11.833333333333334},{"$f":"Quantile($A$3:$A17,P$1,P$2)","v":11.8125},7.5,8,7,7.666666666666667,7.625]
[16,{"$f":"Quantile($A$3:$A18,B$1,B$2)","v":4.5},{"$f":"Quantile($A$3:$A18,C$1,C$2)","v":4.25},{"$f":"Quantile($A$3:$A18,D$1,D$2)","v":4.75},{"$f":"Quantile($A$3:$A18,E$1,E$2)","v":4.416666666666667},{"$f":"Quantile($A$3:$A18,F$1,F$2)","v":4.4375},{"$f":"Quantile($A$3:$A18,G$1,G$2)","v":8.5},{"$f":"Quantile($A$3:$A18,H$1,H$2)","v":8.5},{"$f":"Quantile($A$3:$A18,I$1,I$2)","v":8.5},{"$f":"Quantile($A$3:$A18,J$1,J$2)","v":8.5},{"$f":"Quantile($A$3:$A18,K$1,K$2)","v":8.5},{"$f":"Quantile($A$3:$A18,L$1,L$2)","v":12.5},{"$f":"Quantile($A$3:$A18,M$1,M$2)","v":12.75},{"$f":"Quantile($A$3:$A18,N$1,N$2)","v":12.25},{"$f":"Quantile($A$3:$A18,O$1,O$2)","v":12.583333333333334},{"$f":"Quantile($A$3:$A18,P$1,P$2)","v":12.5625},8,8.5,7.5,8.1666666666666679,8.125]
[17,{"$f":"Quantile($A$3:$A19,B$1,B$2)","v":4.75},{"$f":"Quantile($A$3:$A19,C$1,C$2)","v":4.5},{"$f":"Quantile($A$3:$A19,D$1,D$2)","v":5},{"$f":"Quantile($A$3:$A19,E$1,E$2)","v":4.666666666666667},{"$f":"Quantile($A$3:$A19,F$1,F$2)","v":4.6875},{"$f":"Quantile($A$3:$A19,G$1,G$2)","v":9},{"$f":"Quantile($A$3:$A19,H$1,H$2)","v":9},{"$f":"Quantile($A$3:$A19,I$1,I$2)","v":9},{"$f":"Quantile($A$3:$A19,J$1,J$2)","v":9},{"$f":"Quantile($A$3:$A19,K$1,K$2)","v":9},{"$f":"Quantile($A$3:$A19,L$1,L$2)","v":13.25},{"$f":"Quantile($A$3:$A19,M$1,M$2)","v":13.5},{"$f":"Quantile($A$3:$A19,N$1,N$2)","v":13},{"$f":"Quantile($A$3:$A19,O$1,O$2)","v":13.333333333333334},{"$f":"Quantile($A$3:$A19,P$1,P$2)","v":13.3125},8.5,9,8,8.6666666666666679,8.625]
[18,{"$f":"Quantile($A$3:$A20,B$1,B$2)","v":5},{"$f":"Quantile($A$3:$A20,C$1,C$2)","v":4.75},{"$f":"Quantile($A$3:$A20,D$1,D$2)","v":5.25},{"$f":"Quantile($A$3:$A20,E$1,E$2)","v":4.916666666666667},{"$f":"Quantile($A$3:$A20,F$1,F$2)","v":4.9375},{"$f":"Quantile($A$3:$A20,G$1,G$2)","v":9.5},{"$f":"Quantile($A$3:$A20,H$1,H$2)","v":9.5},{"$f":"Quantile($A$3:$A20,I$1,I$2)","v":9.5},{"$f":"Quantile($A$3:$A20,J$1,J$2)","v":9.5},{"$f":"Quantile($A$3:$A20,K$1,K$2)","v":9.5},{"$f":"Quantile($A$3:$A20,L$1,L$2)","v":14},{"$f":"Quantile($A$3:$A20,M$1,M$2)","v":14.25},{"$f":"Quantile($A$3:$A20,N$1,N$2)","v":13.75},{"$f":"Quantile($A$3:$A20,O$1,O$2)","v":14.083333333333334},{"$f":"Quantile($A$3:$A20,P$1,P$2)","v":14.0625},9,9.5,8.5,9.1666666666666679,9.125]
[19,{"$f":"Quantile($A$3:$A21,B$1,B$2)","v":5.25},{"$f":"Quantile($A$3:$A21,C$1,C$2)","v":5},{"$f":"Quantile($A$3:$A21,D$1,D$2)","v":5.5},{"$f":"Quantile($A$3:$A21,E$1,E$2)","v":5.166666666666667},{"$f":"Quantile($A$3:$A21,F$1,F$2)","v":5.1875},{"$f":"Quantile($A$3:$A21,G$1,G$2)","v":10},{"$f":"Quantile($A$3:$A21,H$1,H$2)","v":10},{"$f":"Quantile($A$3:$A21,I$1,I$2)","v":10},{"$f":"Quantile($A$3:$A21,J$1,J$2)","v":10},{"$f":"Quantile($A$3:$A21,K$1,K$2)","v":10},{"$f":"Quantile($A$3:$A21,L$1,L$2)","v":14.75},{"$f":"Quantile($A$3:$A21,M$1,M$2)","v":15},{"$f":"Quantile($A$3:$A21,N$1,N$2)","v":14.5},{"$f":"Quantile($A$3:$A21,O$1,O$2)","v":14.833333333333334},{"$f":"Quantile($A$3:$A21,P$1,P$2)","v":14.8125},9.5,10,9,9.6666666666666679,9.625]
[20,{"$f":"Quantile($A$3:$A22,B$1,B$2)","v":5.5},{"$f":"Quantile($A$3:$A22,C$1,C$2)","v":5.25},{"$f":"Quantile($A$3:$A22,D$1,D$2)","v":5.75},{"$f":"Quantile($A$3:$A22,E$1,E$2)","v":5.416666666666667},{"$f":"Quantile($A$3:$A22,F$1,F$2)","v":5.4375},{"$f":"Quantile($A$3:$A22,G$1,G$2)","v":10.5},{"$f":"Quantile($A$3:$A22,H$1,H$2)","v":10.5},{"$f":"Quantile($A$3:$A22,I$1,I$2)","v":10.5},{"$f":"Quantile($A$3:$A22,J$1,J$2)","v":10.5},{"$f":"Quantile($A$3:$A22,K$1,K$2)","v":10.5},{"$f":"Quantile($A$3:$A22,L$1,L$2)","v":15.5},{"$f":"Quantile($A$3:$A22,M$1,M$2)","v":15.75},{"$f":"Quantile($A$3:$A22,N$1,N$2)","v":15.25},{"$f":"Quantile($A$3:$A22,O$1,O$2)","v":15.583333333333334},{"$f":"Quantile($A$3:$A22,P$1,P$2)","v":15.5625},10,10.5,9.5,10.166666666666668,10.125]

{"sheet":"Формулы","index":2,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Метод 6 (N+1)",null,null,null,null,null,"Метод 7 (N-1)"]
[null,79,90,39,87,null,null,79,90,39,87]
[null,45,39,14,73,null,null,45,39,14,73]
[null,36,60,2,56,null,null,36,60,2,56]
[null,20,51,19,31,null,null,20,51,19,31]
[null,2,15,22,21,null,null,2,15,22,21]
[null,3,41,3,39,null,null,3,41,3,39]
[null,51,60,13,2,null,null,51,60,13,2]
[null,46,53,49,66,null,null,46,53,49,66]
[null,null,2,98,19,null,null,null,2,98,19]
[null,null,null,23,50,null,null,null,null,23,50]
[null,null,null,null,44,null,null,null,null,null,44]
["р",0.25,null,null,null,null,"р",0.25]
["n",{"$f":"COUNT(B$2:B$12)","v":8},{"$f":"COUNT(C$2:C$12)","v":9},10,11,null,"n",{"$f":"COUNT(H$2:H$12)","v":8},{"$f":"COUNT(I$2:I$12)","v":9},10,11]
["x",{"$f":"(B14+1)*$B$13","v":2.25},{"$f":"(C14+1)*$B$13","v":2.5},{"$f":"(D14+1)*$B$13","v":2.75},{"$f":"(E14+1)*$B$13","v":3},null,"x",{"$f":"(H14-1)*$H$13+1","v":2.75},{"$f":"(I14-1)*$H$13+1","v":3},3.25,3.5]
["i",{"$f":"INT(B15)","v":2},{"$f":"INT(C15)","v":2},2,3,null,"i",{"$f":"INT(H15)","v":2},{"$f":"INT(I15)","v":3},3,3]
["Аi",{"$f":"SMALL(B$2:B$12,B16)","v":3},{"$f":"SMALL(C$2:C$12,C16)","v":15},3,21,null,"Аi",{"$f":"SMALL(H$2:H$12,H16)","v":3},{"$f":"SMALL(I$2:I$12,I16)","v":39},13,21]
["Аi+1",{"$f":"SMALL(B$2:B$12,B16+1)","v":20},{"$f":"SMALL(C$2:C$12,C16+1)","v":39},13,31,null,"Аi+1",{"$f":"SMALL(H$2:H$12,H16+1)","v":20},{"$f":"SMALL(I$2:I$12,I16+1)","v":41},14,31]
["Qp",{"$f":"(1-(B15-B16))*B17+(B15-B16)*B18","v":7.25},{"$f":"(1-(C15-C16))*C17+(C15-C16)*C18","v":27},10.5,21,null,"Qp",{"$f":"(1-(H15-H16))*H17+(H15-H16)*H18","v":15.75},{"$f":"(1-(I15-I16))*I17+(I15-I16)*I18","v":39},13.25,26]
["КВАРТИЛЬ.ИСКЛ",{"$f":"_xlfn.QUARTILE.EXC(B2:B12,1)","v":7.25},{"$f":"_xlfn.QUARTILE.EXC(C2:C12,1)","v":27},10.5,21,null,"КВАРТИЛЬ.ВКЛ",{"$f":"_xlfn.QUARTILE.INC(H2:H12,1)","v":15.75},{"$f":"_xlfn.QUARTILE.INC(I2:I12,1)","v":39},13.25,26]