{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Заставка","Регр","Ручн","Резт"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":100,"n_cols":29,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"H14/$G$11","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["62CA5D80INTERNET"]
[]
[]
[]
[]
["qaz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"qaz"]
[]
["62CA5D80INTERNET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0]
[]
[]
[3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Регр","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"#п/п","Y","X1","X2"]
[null,null,1,1.6879999999999999,1]
[null,null,2,2.4870000000000001,2]
[null,null,3,2.5499999999999998,3]
[null,null,4,4.125,4]
[null,null,5,3.8370000000000002,5]
[null,null,6,4.4509999999999996,6]
[null,null,7,4.7130000000000001,7]
[null,null,8,6.9059999999999997,8]
[null,null,9,7.48,9]
[null,null,10,7.181,10]

{"sheet":"Ручн","index":2,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"срХ","СрУ",{"$f":"\"r=    \"&TEXT($H$15/SQRT($I$15*$J$15),\"0,000\")","v":"r=    0,960"},"b=",{"$f":"($A$14*$E$15-$C$15*$B$15)/($A$14*$D$15-$C$15*$C$15)","v":0.68461666666666743},"Ftabl=",{"$f":"FINV(0.05,1,9-2)","v":5.591447851220738},"t_tabl=",{"$f":"TINV(0.05,9-2)","v":2.3646242515927849}]
[null,null,null,null,{"$f":"AVERAGE($C$6:$C$14)","v":5},{"$f":"AVERAGE($B$6:$B$14)","v":4.248555555555555},null,"a=",{"$f":"($B$15-$I$1*C15)/$A$14","v":0.82547222222221783},"F=",{"$f":"($F$3/(1-$F$3))*($A$14-2)","v":83.124049330923413},"tnabl(sqrF)",{"$f":"SQRT($K$2)","v":9.117239128756216}]
[null,null,null,null,"R2=",0.92232927779024954,null,"A_",{"$f":"AVERAGE(M6:M14)","v":11.6551202810052}]
["#","Y","X","Xкв","XY","X-X_","Y-Y_","(X-X_)*(Y-Y_)","(X-X_)2","(Y-Y_)2","Y*","|Y-Y*|","A","(Y-Y*)2"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[1,1.6879999999999999,1,{"$f":"C6*C6","v":1},{"$f":"B6*C6","v":1.6879999999999999},{"$f":"C6-$E$2","v":-4},{"$f":"B6-$F$2","v":-2.5605555555555553},{"$f":"F6*G6","v":10.242222222222221},{"$f":"F6*F6","v":16},{"$f":"G6*G6","v":6.5564447530864181},{"$f":"$I$2+$I$1*C6","v":1.5100888888888853},{"$f":"ABS(B6-K6)","v":0.17791111111111468},{"$f":"L6/B6*100","v":10.539757767246131},{"$f":"POWER(L6,2)","v":3.1652363456791392E-2}]
[2,2.4870000000000001,2,{"$f":"C7*C7","v":4},{"$f":"B7*C7","v":4.9740000000000002},{"$f":"C7-$E$2","v":-3},{"$f":"B7-$F$2","v":-1.7615555555555549},{"$f":"F7*G7","v":5.2846666666666646},{"$f":"F7*F7","v":9},{"$f":"G7*G7","v":3.1030779753086395},{"$f":"$I$2+$I$1*C7","v":2.1947055555555526},{"$f":"ABS(B7-K7)","v":0.29229444444444752},{"$f":"L7/B7*100","v":11.752892820444211},{"$f":"POWER(L7,2)","v":8.5436042253088221E-2}]
[3,2.5499999999999998,3,9,7.6499999999999995,-2,-1.6985555555555552,3.3971111111111103,4,2.8850909753086404,2.8793222222222203,0.32932222222222052,12.914596949891003,0.10845312604938159]
[4,4.125,4,16,16.5,-1,-0.12355555555555497,0.12355555555555497,1,1.5265975308641832E-2,3.5639388888888877,0.56106111111111234,13.601481481481512,0.31478957040123595]
[5,3.8370000000000002,5,25,19.185000000000002,0,-0.41155555555555479,0,0,0.16937797530864135,4.248555555555555,0.41155555555555479,10.725972258419462,0.16937797530864135]
[6,4.4509999999999996,6,36,26.705999999999996,1,0.20244444444444465,0.20244444444444465,1,4.0983753086419834E-2,4.9331722222222227,0.48217222222222311,10.832896477695419,0.2324900518827169]
[7,4.7130000000000001,7,49,32.991,2,0.4644444444444451,0.92888888888889021,4,0.21570864197530926,5.6177888888888896,0.90478888888888953,19.197727326307863,0.81864293345679129]
[8,6.9059999999999997,8,64,55.247999999999998,3,2.6574444444444447,7.9723333333333342,9,7.0620109753086435,6.3024055555555574,0.60359444444444232,8.7401454451845098,0.364326253364195]
[9,7.48,9,81,67.320000000000007,4,3.2314444444444455,12.925777777777782,16,10.442233197530872,6.9870222222222251,0.49297777777777529,6.590612002376675,0.24302708938271361]
[null,{"$f":"SUM(B$6:B$14 )","v":38.236999999999995},{"$f":"SUM(C$6:C$14 )","v":45},285,232.262,0,0,41.076999999999998,60,30.490194222222225,38.236999999999995,4.2556777777777803,104.89608252904679,2.3681954055555554]

{"sheet":"Резт","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
[]
[]
[]
["Параметры ЛУР по факту"]
[{"$f":"LINEST(Регр!$D$5:$D$13,Регр!$E$5:$E$13,TRUE,TRUE)","v":0.68461666666666665},0.8254722222222215]
[7.5090348843363283E-2,0.42255699674509745]
[0.92232927779024965,0.58164734106250282]
[83.124049330923611,7]
[28.121998816666668,2.3681954055555559]
[]
[{"$f":"CORREL(Регр!$D$5:$D$13,Регр!$E$5:$E$13)","v":0.96037975707021728}]
[{"$f":"COVAR(Регр!$D$5:$D$13,Регр!$E$5:$E$13)","v":4.564111111111111}]
[{"$f":"STEYX(Регр!$D$5:$D$13,Регр!$E$5:$E$13)","v":0.58164734106250338}]
[{"$f":"FTEST(Регр!$D$5:$D$13,Регр!$E$5:$E$13)","v":0.35778009737532446}]