{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Dados","Amost. Aleatória Simples","Estimador de Razao","Comparacao"],"not_rendered":{"charts":0,"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"}

{"sheet":"Dados","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["parcela","area.par.ha","n.arv","n.arv.ha","area.basal","area.basal.ha"]
[101,0.115,47,409,2.61,22.71]
[405,0.25,72,288,3.74,14.97]
[408,0.25,83,332,3.79,15.15]
[410,0.25,95,380,6.72,26.88]
[412,0.25,105,420,6.06,24.23]
[413,0.25,108,432,12.08,48.31]
[415,0.25,60,240,5.61,22.44]
[416,0.25,91,364,4.89,19.57]
[417,0.25,83,332,8.35,33.4]
[401,0.5,158,316,10.24,20.47]
[403,0.5,121,242,6.81,13.63]
[404,0.5,120,240,6.48,12.95]
[406,0.5,171,342,8.27,16.55]
[407,0.5,143,286,8.82,17.64]
[409,0.5,166,332,11.08,22.16]
[411,0.5,192,384,15.54,31.09]
[414,0.5,170,340,14.38,28.77]

{"sheet":"Amost. Aleatória Simples","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Área da Florestal","S=",500,"ha"]
["Eixo de alinha das parcelas em faixa",null,12500,"m"]
["Tamanho Médio de parcelas de 10m",null,0.4,"ha"]
["Número de Parcelas em faixa","N =",1250]
[]
[]
["Área Basal"]
["Média","mu =",22.9952941176471,"m2/ha"]
["Variância","s^2 =",79.2855014705882,"(m2/ha)^2"]
["Tamanho da Amostra","n =",17]
["Variância da Média ","Var(mu) =",4.60042462650519,"(m2/ha)^2"]
["Estatística t","t =",2.11990529922125]
["Erro Amostral",null,4.54690018233666,"m2/ha"]
["Erro Amostral %",null,19.7731768903416,"%"]
[]
[]
["Tamanho de Amostra Para Erro Amostral"]
[null,"E_% =",5]
[null,"V_% = ",38.7220124248497]
[]
[null,"Iteração","t","n*"]
[null,1,2.11990529922125,7008]
[null,2,1.96030259936687,5993]
[null,3,1.96035996957775,5993]
[null,4,1.96035996957775,5993]

{"sheet":"Estimador de Razao","index":2,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Área da Florestal","tau_x =",500,"ha"]
["Eixo de alinha das parcelas em faixa","W =",12500,"m"]
["Tamanho Médio de parcelas de 10m","mu_x =",0.4,"ha"]
["Número de Parcelas em faixa","N =",1250]
[]
["Y = Área Basal da parcela (m2)",{"$nulls":4},"parcela","(y_i – R x_i)^2","y_i^2","x_i^2","x_i y_i"]
["X = Área da Parcela (ha)"]
["Tamanho de Amostra","n =",17,null,null,101,0.0038840514558452,6.8121,0.013225,0.30015]
["Média Amostrais","mu_y =",7.96882352941177,"m2",null,405,3.23435078841154,13.9876,0.0625,0.935]
[null,"mu_x =",0.359705882352941,"ha",null,408,3.05700777941726,14.3641,0.0625,0.9475]
[{"$nulls":5},410,1.39610745235266,45.1584,0.0625,1.68]
["Estimador de Razão","R =",22.1537203597711,"m2/ha",null,412,0.272035171077112,36.7236,0.0625,1.515]
[{"$nulls":5},413,42.7921368881662,145.9264,0.0625,3.02]
["Variância Populacional","Soma(y_i^2) =",649.6959,null,null,415,0.00512225202560085,31.4721,0.0625,1.4025]
[null,"Soma(x_i^2) =",1.513225,null,null,416,0.420461581543182,23.9121,0.0625,1.2225]
[null,"Soma(x_i y_i) =",29.01015,null,null,417,7.90492535913925,69.7225,0.0625,2.0875]
[{"$nulls":5},401,0.700334960678039,104.8576,0.25,5.12]
[null,"s^2_R =",6.68762810386272,null,null,403,18.2060957946928,46.3761,0.25,3.405]
[null,"s^2_R =",6.68762810386273,null,null,404,21.1311235134172,41.9904,0.25,3.24]
[{"$nulls":5},406,7.87846406942702,68.3929,0.25,4.135]
[]
["Estimador da Área Basal da Floresta"]
["É o próprio estimador de razão","R =",22.1537203597711,"m2/ha"]
[]
["Variância da Razão","Cor. Pop. Finita =",0.9864]
[null,"Var( R ) =",2.42524866237139,"(m2/ha)^2"]
[]
["Estatística t","t =",2.11990529922125]
[]
["Erro Amostra",null,3.30137301689152,"m2/ha"]
["Erro Amostra %",null,14.9021155962882,"%"]
[]
[]
["Tamanho de Amostra Para Erro Amostral"]
[null,"E_% =",5]
[null,"V_% = ",11.6731855174548]
[]
[null,"Iteração","t","n*"]
[null,1,2.11990529922125,137]
[null,2,1.97756077655893,121]
[null,3,1.97993040508244,121]
[null,4,1.97993040508244,121]

{"sheet":"Comparacao","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Área Basal"]
[]
["Estimador Padrão da Amostragem Aleatória Simples"]
["Média","mu =",22.9952941176471,"m2/ha"]
["Variância da Média ","Var(mu) =",4.60042462650519,"(m2/ha)^2"]
["Tamanho da Amostra p/ Erro de 5%","'n* =",5993]
[]
[]
["Estimador de Razão"]
["Média","mu =",22.1537203597711,"m2/ha"]
["Variância da Média ","Var(mu) =",2.42524866237139,"(m2/ha)^2"]
["Tamanho da Amostra p/ Erro de 5%","'n* =",121]
[]
["Comparação"]
["Razão das Variâncias da Média",null,null,"Var(mu_R) / Var(mu) * 100 =",52.7179306101094,"%"]
["Razão dos Tamanhos de Amostra p/ E=5%",null,null,"n*_R / n* * 100 =",2.01902219255798,"%"]