{"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":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"срХ","СрУ",{"$f":"\"r=    \"&TEXT($H$16/SQRT($I$16*$J$16),\"0,000\")","v":"r=    0,966"},"b=",{"$f":"($A$15*$E$16-$C$16*$B$16)/($A$15*$D$16-$C$16*$C$16)","v":0.65785454545454602},"Ftabl=",{"$f":"FINV(0.05,1,10-2)","v":5.3176550715787174},"t_tabl=",{"$f":"TINV(0.05,10-2)","v":2.3060041352041671}]
[null,null,null,null,{"$f":"AVERAGE($C$6:$C$15)","v":5.5},{"$f":"AVERAGE($B$6:$B$15)","v":4.5417999999999994},null,"a=",{"$f":"($B$16-$I$1*C16)/$A$15","v":0.9235999999999962},"F=",{"$f":"($F$3/(1-$F$3))*($A$15-2)","v":113.08663857188503},"tnabl(sqrF)",{"$f":"SQRT($K$2)","v":10.634220167548019}]
[null,null,null,null,"R2=",0.93393160389657137,null,"A_",{"$f":"AVERAGE(M6:M15)","v":10.36245987984635}]
["#","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.5},{"$f":"B6-$F$2","v":-2.8537999999999997},{"$f":"F6*G6","v":12.842099999999999},{"$f":"F6*F6","v":20.25},{"$f":"G6*G6","v":8.1441744399999987},{"$f":"$I$2+$I$1*C6","v":1.5814545454545423},{"$f":"ABS(B6-K6)","v":0.10654545454545761},{"$f":"L6/B6*100","v":6.3119345109868243},{"$f":"POWER(L6,2)","v":1.1351933884298173E-2}]
[2,2.4870000000000001,2,{"$f":"C7*C7","v":4},{"$f":"B7*C7","v":4.9740000000000002},{"$f":"C7-$E$2","v":-3.5},{"$f":"B7-$F$2","v":-2.0547999999999993},{"$f":"F7*G7","v":7.1917999999999971},{"$f":"F7*F7","v":12.25},{"$f":"G7*G7","v":4.2222030399999975},{"$f":"$I$2+$I$1*C7","v":2.2393090909090883},{"$f":"ABS(B7-K7)","v":0.24769090909091185},{"$f":"L7/B7*100","v":9.9594253755895394},{"$f":"POWER(L7,2)","v":6.1350786446282356E-2}]
[3,2.5499999999999998,3,9,7.6499999999999995,-2.5,-1.9917999999999996,4.9794999999999989,6.25,3.9672672399999982,2.8971636363636346,0.34716363636363479,13.614260249554306,0.12052259041322204]
[4,4.125,4,16,16.5,-1.5,-0.41679999999999939,0.62519999999999909,2.25,0.1737222399999995,3.5550181818181805,0.56998181818181948,13.817741046831989,0.32487927305785269]
[5,3.8370000000000002,5,25,19.185000000000002,-0.5,-0.7047999999999992,0.3523999999999996,0.25,0.49674303999999886,4.2128727272727264,0.37587272727272625,9.796005401947518,0.14128030710743725]
[6,4.4509999999999996,6,36,26.705999999999996,0.5,-9.079999999999977E-2,-4.5399999999999885E-2,0.25,8.2446399999999576E-3,4.8707272727272724,0.41972727272727273,9.4299544535446582,0.17617098347107438]
[7,4.7130000000000001,7,49,32.991,1.5,0.17120000000000068,0.25680000000000103,2.25,2.9309440000000235E-2,5.5285818181818183,0.81558181818181819,17.304939914742587,0.66517370214876037]
[8,6.9059999999999997,8,64,55.247999999999998,2.5,2.3642000000000003,5.9105000000000008,6.25,5.5894416400000013,6.1864363636363642,0.71956363636363552,10.419398151804742,0.51777182677685829]
[9,7.48,9,81,67.320000000000007,3.5,2.938200000000001,10.283700000000003,12.25,8.6330192400000065,6.8442909090909101,0.63570909090909034,8.4987846378220624,0.40412604826446208]
[10,7.181,10,100,71.81,4.5,2.6392000000000007,11.876400000000004,20.25,6.9653766400000032,7.502145454545456,0.32114545454545596,4.4721550556392691,0.10313440297520751]
[null,{"$f":"SUM(B$6:B$15 )","v":45.417999999999992},{"$f":"SUM(C$6:C$15 )","v":55},385,304.072,0,0,54.273000000000003,82.5,38.229501600000006,45.417999999999999,4.5589818181818229,103.6245987984635,2.5257618545454554]

{"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$14,Регр!$E$5:$E$14,TRUE,TRUE)","v":0.65785454545454558},0.92359999999999864]
[6.1862039255317532E-2,0.38384385911698288]
[0.93393160389657137,0.56188987516966504]
[113.08663857188523,8]
[35.703739745454548,2.5257618545454545]
[]
[{"$f":"CORREL(Регр!$D$5:$D$14,Регр!$E$5:$E$14)","v":0.96640136790909581}]
[{"$f":"COVAR(Регр!$D$5:$D$14,Регр!$E$5:$E$14)","v":5.4273000000000007}]
[{"$f":"STEYX(Регр!$D$5:$D$14,Регр!$E$5:$E$14)","v":0.56188987516966549}]
[{"$f":"FTEST(Регр!$D$5:$D$14,Регр!$E$5:$E$14)","v":0.26732697886544671}]