{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1 (2)","Лист1 (3)"],"not_rendered":{"charts":2,"images":0,"macros":0,"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":"Лист1 (2)","index":0,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["имт","ln(ИМТ)"]
[19.705532421177875,{"$f":"LN(A2)","v":2.9808994298799081},null,null,null,"n",{"$f":"COUNT(A2:A88)","v":87},{"$f":"COUNT(B2:B88)","v":87},"или",null,"min",{"$f":"MIN(A2:A88)","v":15.570934256055365}]
[17.998163452708908,{"$f":"LN(A3)","v":2.8902697222856482},null,null,null,"x",{"$f":"AVERAGE(A2:A88)","v":21.119086248021709},{"$f":"AVERAGE(B2:B88)","v":3.0418669783356984},{"$f":"AVERAGE(LN(A2:A88))","v":3.0418669783356984},null,"max",{"$f":"MAX(A2:A88)","v":32.871972318339104}]
[23.306680053067517,3.1487400170383095,null,null,null,"s",{"$f":"STDEV(A2:A88)","v":2.8304065296866709},{"$f":"STDEV(B2:B88)","v":0.1279355551440195},{"$f":"STDEV(LN(A2:A88))","v":0.1279355551440195},null,"n'",{"$f":"MIN(ROUND(SQRT(G2),0),20)","v":9}]
[19.723183391003463,2.9817947657102093,null,null,null,"D+",{"$f":"MAX(RANK(A2:A88,A2:A88,1)/G2-NORMDIST(A2:A88,G3,G4,1))","v":0.10202727981376081},{"$f":"MAX(RANK(B2:B88,B2:B88,1)/H2-NORMDIST(B2:B88,H3,H4,1))","v":7.907802774659578E-2}]
[19.721036967980208,2.9816859323751435,null,null,null,"D-",{"$f":"MAX(NORMDIST(A2:A88,G3,G4,1)-(RANK(A2:A88,A2:A88,1)-1)/G2)","v":6.3157183794044447E-2},{"$f":"MAX(NORMDIST(B2:B88,H3,H4,1)-(RANK(B2:B88,B2:B88,1)-1)/H2)","v":4.573618750645371E-2},null,null,{"$f":"10^-99","v":1E-99}]
[18.289894833104707,2.9063487124193053,null,null,null,"D",{"$f":"MAX(G5:G6)","v":0.10202727981376081},{"$f":"MAX(H5:H6)","v":7.907802774659578E-2},null,null,{"$f":"L2","v":15.570934256055365},{"$f":"COUNTIFS($A$2:$A$88,\">\"&K6,$A$2:$A$88,\"<=\"&K7)","v":1},{"$f":"(LOGNORMDIST(K7,$H$3,$H$4)-LOGNORMDIST(K6,$H$3,$H$4))*$G$2","v":0.89127705366379584}]
[23.183391003460208,3.1434361172666252,null,null,null,"Dcrit(0,95)",{"$f":"1.36/SQRT(G2)","v":0.1458073047379401},{"$f":"1.36/SQRT(H2)","v":0.1458073047379401},null,null,{"$f":"K7+($L$3-$L$2)/$L$4","v":17.493271818531337},{"$f":"COUNTIFS($A$2:$A$88,\">\"&K7,$A$2:$A$88,\"<=\"&K8)","v":4},{"$f":"(LOGNORMDIST(K8,$H$3,$H$4)-LOGNORMDIST(K7,$H$3,$H$4))*$G$2","v":6.0392468952656451}]
[20.549886621315196,3.0228554237160843,null,null,null,null,{"$f":"\"нормальность \"&IF(G7>G8,\"не \",\"\")&\"подтверждена\"","v":"нормальность подтверждена"},{"$f":"\"нормальность \"&IF(H7>H8,\"не \",\"\")&\"подтверждена\"","v":"нормальность подтверждена"},null,null,{"$f":"K8+($L$3-$L$2)/$L$4","v":19.415609381007307},18,17.150188521200924]
[19.841269841269845,2.9877641039048144,null,null,null,"p",0.30445499999999998,0.61936100000000005,null,null,21.337946943483278,29,24.452994817056208]
[24.023808670084982,3.1790453665336389,null,null,null,null,null,null,null,null,23.260284505959248,18,20.529705601052388]
[19.531249999999996,2.9720157469366746,null,null,null,null,null,null,null,null,25.182622068435219,12,11.42312305029348]
[18.556773222226116,2.9208348556821577,null,null,null,null,null,null,null,null,27.104959630911189,0,4.6057342110137505]
[18.359374999999996,2.9101403432185875,null,null,null,null,null,null,null,null,29.02729719338716,4,1.4405413508972689]
[21.629648760330578,3.0740650012908453,null,null,null,null,null,null,null,null,30.94963475586313,0,0.36839322918114981]
[17.959183673469386,2.8881016093616254,null,null,null,null,null,null,null,null,32.871972318339104,1,8.0254139304551608E-2]
[21.146319909102385,3.0514658907829784]
[22.15910864205237,3.0982486373359883]
[21.877551020408163,3.0854610435201208]
[19.86851716581446,2.9891364269956395]
[20.65754000210077,3.0280803860357555]
[23.046874999999996,3.1375301854142483]
[21.971335857220122,3.089738688244914]
[19.289379267775161,2.9595546474354029]
[20.202020202020204,3.0057826094074924]
[20.312499999999996,3.0112364600899562]
[18.902038132807363,2.9392697539662036]
[22.656249999999996,3.1204357520549482]
[16.653061224489797,2.8125940568534804]
[19.031141868512112,2.9460766831081302]
[15.570934256055365,2.7454059876459791]
[27.343749999999996,3.3084879835578875]
[20.202020202020204,3.0057826094074924]
[18.778344671201818,2.9327043267217872]
[19.382144693643447,2.9643522656463461]
[17.959183673469386,2.8881016093616254]
[20.690494543389182,3.0296743940038922]
[21.971335857220122,3.089738688244914]
[18.285714285714285,2.9061201148643039]
[22.642192971863299,3.1198151113589025]
[23.243801652892564,3.1460385009159344]
[24.772096710265558,3.2097178870834351]
[23.566632231404959,3.1598318230482705]
[18.645344042454013,2.9255964657240998]
[20.028841531805796,2.9971733113503949]
[20.069204152249139,2.9991865084220786]
[21.224489795918366,3.0551556940247915]
[20.07960127648894,2.9997044378778219]
[20.700816741315069,3.0301731555951292]
[19.959355494266223,2.9936979804955675]
[23.335466144755166,3.1499743554077497]
[22.656249999999996,3.1204357520549482]
[22.948115744558788,3.1332358305023442]
[23.291229956104985,3.1480768929829326]
[24.879178701135288,3.2140312569215932]
[23.040020199469762,3.1372327125404036]
[17.306122448979593,2.8510603376812766]
[21.410944984758313,3.063902239168816]
[27.681660899653981,3.3207701325495407]
[24.099722991689752,3.1822003463097941]
[23.566632231404959,3.1598318230482705]
[32.871972318339104,3.4926203894762002]
[23.533042706685695,3.1584055061805678]
[21.366869143188548,3.0618415514938904]
[20.761245674740486,3.0330880600977599]
[19.467401285583104,2.9687413377271432]
[20.202020202020204,{"$f":"LN(A67)","v":3.0057826094074924}]
[17.689788851669238,2.8729875720727165]
[20.66115702479339,3.028255465259551]
[20.519134092541297,3.0213578211929639]
[18.749999999999996,2.9311937524164198]
[18.467220683287167,2.9159973055351376]
[20.957171162932475,3.0424808867438853]
[24.655909615804749,3.2050166127616944]
[24.163265306122447,3.1848335173333244]
[21.606648199445985,3.0730010543448021]
[19.284149013878743,2.9592834638459586]
[27.757487216946675,3.3235056134200738]
[18.809206251496189,2.9343464442033342]
[17.224803717352987,2.8463504216158113]
[21.359914560341757,3.0615160140999942]
[22.308149910767405,3.104952078549887]
[16.359309934562763,2.7947971502460471]
[20.904195011337873,3.0399498570753845]
[19.814052735863431,2.9863914200928416]
[20.571428571428573,3.0239031505206873]
[27.748872702046476,3.3231952160176164]
[20.061728395061728,2.9988139400913991]

{"sheet":"Лист1 (3)","index":1,"n_rows":172,"n_cols":13,"rows_kept":172,"cut":false,"hidden":false,"merged":[]}
["имт","ln(ИМТ)"]
[18.491124260355029,{"$f":"LN(A2)","v":2.9172908472474286},null,null,null,"n",{"$f":"COUNT(A2:A172)","v":171},{"$f":"COUNT(B2:B172)","v":171},"или",null,"min",{"$f":"MIN(A2:A172)","v":15.615704937537183}]
[17.898022892819977,{"$f":"LN(A3)","v":2.884690253831252},null,null,null,"x",{"$f":"AVERAGE(A2:A172)","v":21.93106695444741},{"$f":"AVERAGE(B2:B172)","v":3.0733049749962897},{"$f":"AVERAGE(LN(A2:A172))","v":3.0733049749962897},null,"max",{"$f":"MAX(A2:A172)","v":38.568298027757486}]
[20.830703194041156,3.0364280134184378,null,null,null,"s",{"$f":"STDEV(A2:A172)","v":4.0191653983415421},{"$f":"STDEV(B2:B172)","v":0.16642499738036987},{"$f":"STDEV(LN(A2:A172))","v":0.16642499738036987},null,"n'",{"$f":"MIN(ROUND(SQRT(G2),0),20)","v":13}]
[25.390624999999996,3.2343800114041659,null,null,null,"D+",{"$f":"MAX(RANK(A2:A172,A2:A172,1)/G2-NORMDIST(A2:A172,G3,G4,1))","v":0.13800617372350554},{"$f":"MAX(RANK(B2:B172,B2:B172,1)/H2-NORMDIST(B2:B172,H3,H4,1))","v":9.7107891726874729E-2}]
[26.583175803402646,3.2802785270884764,null,null,null,"D-",{"$f":"MAX(NORMDIST(A2:A172,G3,G4,1)-(RANK(A2:A172,A2:A172,1)-1)/G2)","v":8.9190087241140512E-2},{"$f":"MAX(NORMDIST(B2:B172,H3,H4,1)-(RANK(B2:B172,B2:B172,1)-1)/H2)","v":5.7596726459492625E-2},null,null,{"$f":"10^-99","v":1E-99}]
[30.38710529792575,3.414018350596165,null,null,null,"D",{"$f":"MAX(G5:G6)","v":0.13800617372350554},{"$f":"MAX(H5:H6)","v":9.7107891726874729E-2},null,null,{"$f":"L2","v":15.615704937537183},{"$f":"COUNTIFS($A$2:$A$172,\">\"&K6,$A$2:$A$172,\"<=\"&K7)","v":1},{"$f":"(LOGNORMDIST(K7,$H$3,$H$4)-LOGNORMDIST(K6,$H$3,$H$4))*$G$2","v":4.3450863159589339}]
[22.205989773557338,3.1003620621058641,null,null,null,"Dcrit(0,95)",{"$f":"1.36/SQRT(G2)","v":0.10400179935465467},{"$f":"1.36/SQRT(H2)","v":0.10400179935465467},null,null,{"$f":"K7+($L$3-$L$2)/$L$4","v":17.381289021400285},{"$f":"COUNTIFS($A$2:$A$172,\">\"&K7,$A$2:$A$172,\"<=\"&K8)","v":9},{"$f":"(LOGNORMDIST(K8,$H$3,$H$4)-LOGNORMDIST(K7,$H$3,$H$4))*$G$2","v":11.935097422249772}]
[20.017729989419198,2.9966183803163684,null,null,null,null,{"$f":"\"нормальность \"&IF(G7>G8,\"не \",\"\")&\"подтверждена\"","v":"нормальность не подтверждена"},{"$f":"\"нормальность \"&IF(H7>H8,\"не \",\"\")&\"подтверждена\"","v":"нормальность подтверждена"},null,null,{"$f":"K8+($L$3-$L$2)/$L$4","v":19.146873105263385},{"$f":"COUNTIFS($A$2:$A$172,\">\"&K8,$A$2:$A$172,\"<=\"&K9)","v":29},{"$f":"(LOGNORMDIST(K9,$H$3,$H$4)-LOGNORMDIST(K8,$H$3,$H$4))*$G$2","v":23.612712056220065}]
[24.343809494085704,3.1922775869842646,null,null,null,"p",2.6519999999999998E-3,7.4317999999999995E-2,null,null,20.912457189126485,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K9,$A$2:$A$172,\"<=\"&K10)","v":46},{"$f":"(LOGNORMDIST(K10,$H$3,$H$4)-LOGNORMDIST(K9,$H$3,$H$4))*$G$2","v":32.184319389575663}]
[19.591836734693878,2.9751129863512555,null,null,null,null,null,null,null,null,22.678041272989585,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K10,$A$2:$A$172,\"<=\"&K11)","v":34},{"$f":"(LOGNORMDIST(K11,$H$3,$H$4)-LOGNORMDIST(K10,$H$3,$H$4))*$G$2","v":32.865234074607955}]
[19.100091827364558,2.9496931427564492,null,null,null,null,null,null,null,null,24.443625356852685,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K11,$A$2:$A$172,\"<=\"&K12)","v":20},{"$f":"(LOGNORMDIST(K12,$H$3,$H$4)-LOGNORMDIST(K11,$H$3,$H$4))*$G$2","v":26.759335995117052}]
[20.07960127648894,2.9997044378778219,null,null,null,null,null,null,null,null,26.209209440715785,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K12,$A$2:$A$172,\"<=\"&K13)","v":10},{"$f":"(LOGNORMDIST(K13,$H$3,$H$4)-LOGNORMDIST(K12,$H$3,$H$4))*$G$2","v":18.209308325350264}]
[22.03856749311295,3.0927939863971221,null,null,null,null,null,null,null,null,27.974793524578885,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K13,$A$2:$A$172,\"<=\"&K14)","v":10},{"$f":"(LOGNORMDIST(K14,$H$3,$H$4)-LOGNORMDIST(K13,$H$3,$H$4))*$G$2","v":10.736257005488415}]
[20.569329660238754,3.0238011149101709,null,null,null,null,null,null,null,null,29.740377608441985,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K14,$A$2:$A$172,\"<=\"&K15)","v":3},{"$f":"(LOGNORMDIST(K15,$H$3,$H$4)-LOGNORMDIST(K14,$H$3,$H$4))*$G$2","v":5.6404962747633629}]
[19.883853048857468,2.9899079977835452,null,null,null,null,null,null,null,null,31.505961692305085,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K15,$A$2:$A$172,\"<=\"&K16)","v":3},{"$f":"(LOGNORMDIST(K16,$H$3,$H$4)-LOGNORMDIST(K15,$H$3,$H$4))*$G$2","v":2.6992701221837287}]
[17.08984375,2.8384843543121523,null,null,null,null,null,null,null,null,33.271545776168189,{"$f":"COUNTIFS($A$2:$A$172,\">\"&K16,$A$2:$A$172,\"<=\"&K17)","v":1},{"$f":"(LOGNORMDIST(K17,$H$3,$H$4)-LOGNORMDIST(K16,$H$3,$H$4))*$G$2","v":1.1973856371983886}]
[20.006569321269669,2.9960606856843071,null,null,null,null,null,null,null,null,35.037129860031293,1,0.49931153043871346]
[23.167430237401085,3.1427474232472883,null,null,null,null,null,null,null,null,36.802713943894396,2,0.1979645721970259]
[26.026174895895306,3.259102758377145,null,null,null,null,null,null,null,null,38.5682980277575,2,7.5318350599740458E-2]
[21.604938271604937,3.0729219122451208]
[21.9671201814059,3.0895467982147564]
[25.761772853185597,3.2488917208084667]
[19.675166853130666,2.9793572747315826]
[19.77769866698311,2.9845549729638656]
[19.993284698269285,2.9953964520857377]
[18.612244897959183,2.9238196919637049]
[23.225431847873423,3.1452478786227682]
[20.830703194041156,3.0364280134184378]
[21.6712580348944,3.075986868080741]
[27.587326057852245,3.3173564664556734]
[38.568298027757486,3.652430644405904]
[22.031725684986377,3.0924834911547201]
[21.484374999999996,3.0673259267409998]
[17.968749999999996,2.8886341379976237]
[22.571047501795427,3.1166680009972887]
[26.365603028664147,3.2720602450388685]
[20.679012345679013,3.029119289586728]
[17.187499999999996,2.8441823754267896]
[19.921874999999996,2.9918183742328543]
[36.242583693521972,3.5902347726048411]
[19.655451497282922,2.9783547297258868]
[25.605536332179934,3.2428085910798292]
[22.375679950619187,3.107974652553676]
[21.6712580348944,3.075986868080741]
[21.107266435986162,3.0496173620489704]
[16.528925619834713,2.8051119139453413]
[22.10028959000152,3.0955907120578336]
[20.987654320987652,3.0439343753718684]
[18.827111039897449,2.9352979076323074]
[27.815881725346742,3.3256071426598055]
[25.847768218818715,3.2522242613982226]
[18.809206251496189,2.9343464442033342]
[21.6712580348944,3.075986868080741]
[32.604757879483152,3.4844582249468115]
[20.576131687242793,3.0241317480756886]
[27.064051588760066,3.2982063376530637]
[20.679012345679013,3.029119289586728]
[24.772096710265558,3.2097178870834351]
[17.577068685776098,2.8665951369307043]
[22.491349480968861,3.1131307677712963]
[15.615704937537183,2.7482771346111545]
[19.100091827364558,2.9496931427564492]
[19.909972299168974,2.9912207267727249]
[19.368496914553401,2.9636478757788272]
[19.721036967980208,2.9816859323751435]
[20.904195011337873,{"$f":"LN(A67)","v":3.0399498570753845}]
[22.758306781975424,3.124930212025673]
[18.590124925639504,2.9226305217559321]
[19.333729922665082,2.9618512349092132]
[33.412409368839583,3.5089273689687159]
[17.630853994490359,2.8696504350829124]
[23.291229956104985,3.1480768929829326]
[18.78829922534397,2.9332342944454175]
[17.21108680841909,2.8455537580505634]
[23.148148148148145,3.1419147837320724]
[35.235450446415236,3.5620526907590055]
[20.227025721531216,3.0070196172135581]
[19.157088122605362,2.9526727840935441]
[37.637848620572854,3.6280101563507494]
[19.467401285583104,2.9687413377271432]
[26.753864447086801,3.2866789282195636]
[18.827111039897449,2.9352979076323074]
[18.903591682419659,2.9393519401178834]
[18.517804097064154,2.9187326529151476]
[17.056176513282043,2.8365123969731547]
[17.993079584775089,2.8899872164570866]
[18.906901018871892,2.9395269886943103]
[20.415224913494811,3.0162809417813787]
[19.493177387914233,2.9700645268054133]
[19.486961451247168,2.9697455984021359]
[19.467401285583104,2.9687413377271432]
[21.30394857667585,3.0588924347214408]
[20.549886621315196,3.0228554237160843]
[22.491349480968861,3.1131307677712963]
[20.43816558499767,3.0174040149772225]
[22.571047501795427,3.1166680009972887]
[20.65754000210077,3.0280803860357555]
[19.140624999999996,2.9518130396191555]
[22.733564013840834,3.1238424233662241]
[25.826446280991735,3.2513990165737607]
[20.061728395061728,2.9988139400913991]
[18.467220683287167,2.9159973055351376]
[22.720438370810918,3.1232648881567315]
[18.749999999999996,2.9311937524164198]
[19.233560749020178,2.9566567088152182]
[18.903591682419659,2.9393519401178834]
[24.034609838166958,3.1794948681443498]
[20.703124999999996,3.0302846550606506]
[19.477146814404431,2.9692418200539499]
[22.499637102627378,3.113499180308188]
[16.901027582477017,2.8273744237774228]
[18.424036281179141,2.9136561317510923]
[21.513858510523864,3.0686973093647731]
[22.03856749311295,3.0927939863971221]
[21.30394857667585,3.0588924347214408]
[22.321428571428577,3.1055471395611978]
[24.232221201918172,3.1876832021876531]
[22.790357925493058,3.1263375485091247]
[21.545090797168363,3.0701479853623961]
[22.59143813091595,3.117570990734031]
[21.798202394816204,3.0818275074417318]
[28.554631729234906,3.3518191551411691]
[30.299204645878046,3.4111214628598487]
[22.862368541380881,3.129492263733515]
[26.370238143535232,3.2722360311752037]
[21.913805697589478,3.0871168353558436]
[19.333729922665082,2.9618512349092132]
[22.189349112426033,3.0996124040413831]
[20.195578231292519,3.005463681004215]
[23.306680053067517,{"$f":"LN(A131)","v":3.1487400170383095}]
[30.367346938775512,3.4133679172824105]
[19.493177387914233,2.9700645268054133]
[22.308149910767405,3.104952078549887]
[23.566632231404959,3.1598318230482705]
[23.620287912158062,3.1621060000326939]
[25,3.2188758248682006]
[21.604938271604937,3.0729219122451208]
[24.489795918367346,3.1982565376654648]
[17.360441340997646,2.8541941317775765]
[22.530612244897959,3.1148749287264139]
[17.993079584775089,2.8899872164570866]
[19.841269841269845,2.9877641039048144]
[20.957274202271499,3.0424858033943685]
[22.892819979188342,3.1308233233701603]
[19.26530612244898,2.9583058680348739]
[18.749999999999996,2.9311937524164198]
[18.590124925639504,2.9226305217559321]
[23.507805325987146,3.1573325075346936]
[17.715419501133791,2.8744354185978112]
[29.337411441590461,3.3788635425646767]
[26.881720430107524,3.2914465177030361]
[20.307412205454995,3.0109859526764553]
[23.030045351473927,3.136799683065302]
[18.166204254194742,2.8995629587795957]
[22.948115744558788,3.1332358305023442]
[22.230987127541326,3.101487132187764]
[18.590124925639504,2.9226305217559321]
[19.607156612163443,2.9758946328651854]
[27.472527472527471,3.3131865043394422]
[29.387755102040817,3.3805780944594197]
[20.047445621303751,2.9981017452027254]
[21.847008520333322,3.0840640023440318]
[19.369834710743802,2.9637169441219799]
[26.315789473684212,3.2701691192557512]
[20.761245674740486,3.0330880600977599]
[25.099501595611173,3.2228479891920316]
[20.415224913494811,3.0162809417813787]
[17.874812474065561,2.8833925975636734]
[15.755750849059909,2.7572054319003558]
[17.301038062283737,2.8507665033038054]
[24.034609838166958,3.1794948681443498]