{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Dados","Am. Aleatoria Simples","Est. de Regressão"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Dados","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Parcela","Número de Árvores","Área Basal DAP >= 20 cm (m2/ha)","DAP médio (cm)","Produção (m3/ha)","Área Basal DAP >= 50 cm (m2/ha)"]
[1,162.86,17.89,31.4,187.22,9.39]
[2,125.71,9.08,27.38,80,2.47]
[3,151.43,13.92,29.59,137.61,6.4]
[4,140,9.58,26.68,83.77,2.71]
[5,140,8.51,25.01,73.01,1.92]
[6,111.43,7.61,25.51,71.63,2.24]
[7,137.14,11.25,28.08,106.25,3.78]
[8,131.43,17.63,34.57,192.63,10.75]
[9,165.71,12.26,27.97,107.8,2.74]
[10,145.71,12.52,29.37,116.93,5.34]
[11,140,14.97,32.77,146.16,8.41]
[12,137.14,15.17,32.93,152.77,7.1]
[13,165.71,10.25,25.8,85.49,1.81]
[14,94.29,7.27,27.46,66.84,2.86]

{"sheet":"Am. Aleatoria Simples","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Compartimento de Manejo"]
["Área do Compartimento"," S = ",24.5,"ha"]
["Tamanho da População","N =",70]
["Tamanho médio de parcela","mu_x =",5.180449]
[]
[]
["Área Basal Média do Compartimento (DAP >= 20)"]
[]
["Tamanho da Amostra","n=",14]
["Média – área basal DAP >= 20","mu =",11.9935714285714,"m2/ha"]
["Variância","S^2 =",12.3935016483516,"(m2/ha)^2"]
[]
["Variância da Média","Cor. Pop. Finita =",0.8]
[null,"Var( mu ) =",0.7082000941915231]
[]
["Estatística t","t =",2.16036865646279]
["Erro Amostral",null,1.81805014570274,"m2/ha"]
["Erroa Amostral %",null,15.1585385264954,"%"]
[]
[]
["Tamanho de Amostra Adequado"]
[]
["Erro Amostral Desejado","E_% =",5]
["Coeficiente de Variação","V_% =",29.3527292387235]
[]
[null,"Iteração","t","n*"]
[null,1,2.16036865646279,49]
[null,2,2.01063475762423,47]
[null,3,2.01289559891943,47]
[null,4,2.01289559891943,47]

{"sheet":"Est. de Regressão","index":2,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Compartimento de Manejo"]
["Área do Compartimento"," S = ",24.5,"ha",null,"parcela","x_i^2","y_i^2","x_i y_i"]
["Tamanho da População","N =",70]
["Área Basal Média (DAP >= 50)","mu_x =",5.180449,"m2/ha",null,1,88.1721,320.0521,167.9871]
[{"$nulls":5},2,6.1009,82.4464,22.4276]
[{"$nulls":5},3,40.96,193.7664,89.088]
["Área Basal Média do Compartimento (DAP >= 20)",{"$nulls":4},4,7.3441,91.7764,25.9618]
["Tamanho da Amostra","n =",14,null,null,5,3.6864,72.4201,16.3392]
["X – área basal DAP >= 50","mu_x.hat =",4.85142857142857,"m2/ha",null,6,5.0176,57.9121,17.0464]
["Y – área basal DAP >= 20","mu_y.hat =",11.9935714285714,"m2/ha",null,7,14.2884,126.5625,42.525]
[{"$nulls":5},8,115.5625,310.8169,189.5225]
[null,"Soma( x_i ) =",67.92,null,null,9,7.5076,150.3076,33.5924]
[null,"Soma( y_i ) =",167.91,null,null,10,28.5156,156.7504,66.8568]
[null,"Soma(x_i^2) =",449.749,null,null,11,70.7281,224.1009,125.8977]
[null,"Soma(y_i^2) =",2174.9561,null,null,12,50.41,230.1289,107.707]
[null,"Soma(x_i y_i) =",944.2962,null,null,13,3.2761,105.0625,18.5525]
[{"$nulls":5},14,8.1796,52.8529,20.7922]
[null,"Beta =",1.07861659505194]
[]
["Variância Populacional","s^2_L =",1.7688903560167502,"(m2/ha)^2"]
[]
["Estimativa da Média de Y","mu_L =",12.3484583229396,"m2/ha"]
[]
["Variância da Média","Cor. Pop. Finita =",0.8]
[null,"Var( mu_L ) =",0.10107944891524301,"(m2/ha)^2"]
[]
["Estatística t","t =",2.16036865646279]
[]
["Erro Amostral",null,0.6868458846890511,"m2/ha"]
["Erro Amostral %",null,5.56219948050602,"%"]
[]
[]
["Tamanho de Amostra Adequado"]
[]
["Erro Amostral Desejado","E_% =",5]
["Coeficiente de Variação","V_% =",10.77054592286]
[]
[null,"Iteração","t","n*"]
[null,1,2.16036865646279,17]
[null,2,2.11990529922125,17]
[null,3,2.11990529922125,17]
[null,4,2.11990529922125,17]