{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["DADOS","Estimador Padrão","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","formulas":"cached_only"}

{"sheet":"DADOS","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Identificador da Quadra","Perímetro da Quadra em m","Número de Árvores nas Vias Públicas da Quadra","Perímetro da Quadra em Km"]
[2064,654.92,37,0.6549200000000001]
[2066,446.81,6,0.44681000000000004]
[42416,462.81,33,0.46281000000000005]
[44275,457.04,42,0.45704000000000006]
[45028,315.35,13,0.31535]
[45754,539.1,26,0.5391]
[47461,306.49,20,0.30649000000000004]
[47481,604.48,25,0.60448]
[47597,559.6,23,0.5596]
[47649,322.4,17,0.3224]
[47659,545.79,33,0.54579]
[47691,282.13,20,0.28213000000000005]
[47724,467.16,25,0.46716]
[47725,458.38,31,0.45838000000000007]
[47758,721.19,54,0.7211900000000001]
[47802,534.6,33,0.5346000000000001]
[47821,473.62,38,0.47362000000000004]
[47827,824.22,47,0.8242200000000001]
[47880,455.53,25,0.45553000000000005]
[47949,561.04,59,0.5610400000000001]
[47952,720,70,0.72]
[47972,1067.21,89,1.06721]
[48054,688.45,29,0.68845]
[48506,544.56,41,0.54456]
[48639,588.72,36,0.58872]
[50423,1235.38,44,1.23538]
[50923,458.1,29,0.4581]
[53375,666.78,36,0.66678]
[55238,641.77,38,0.6417700000000001]
[59547,468.52,41,0.46852000000000005]

{"sheet":"Estimador Padrão","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Estimadores Padrão da Amostragem Aleatória Simples"]
["Número Total de Quadras","N =",275]
["Perímetro Total das Quadras","Tau_x =",157.9079,"Km"]
["Tamanho Médio das Quadras","mu_x =",0.5742105454545451,"Km"]
[]
["Número de Árvores por Quadra",null,null,null,"Número de Árvores por Km de Via Pública"]
["Média","mu =",35.3333333333333,null,"mu =",61.5337590245116,"árvores/Km"]
["Variância","s^2 =",281.67816091954,null,"s^2 =",854.300869403652,"(árvores/Km)^2"]
["Tamanho da Amostra","n =",30]
["Correção p/ Pop. Finita","Correcao =",0.8909090909090911]
["Variância da Média ","Var(mu) =",8.36498780912574,null,"Var(mu) =",25.3701470307751,"(árvores/Km)^2"]
["Estatística t","t =",2.04522964213271]
["Erro Amostral","E.A. =",5.91527220709079,null,"E.A. =",10.3015736194957,"árvores/Km"]
["Erro Amostra l%","E.A.% =",16.7413364351626,"%","E.A.% =",16.7413364351626,"%"]
[]
[]
["Tamanho de Amostra Para Erro Amostral"]
[null,"E_% =",5]
[null,"V_% = ",47.4998215158051]
[]
[null,"Iteração","t","n*"]
[null,1,2.04522964213271,9816]
[null,2,1.9602057123877001,9017]
[null,3,1.96022713719324,9017]
[null,4,1.96022713719324,9017]

{"sheet":"Estimador de Razao","index":2,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Estimadores de Razão na Amostragem Aleatória Simples"]
["Número Total de Quadras","N =",275]
["Perímetro Total das Quadras","Tau_x =",157.9079,"Km"]
["Tamanho Médio das Quadras","mu_x =",0.5742105454545451,"Km"]
[]
["Y = Número de Árvores",{"$nulls":4},"Quadra","(y_i – R x_i)^2","y_i^2","x_i^2","x_i y_i"]
["X = Perímetro da Quadra (m)"]
["Tamanho de Amostra","n =",30,null,null,2064,13.4220170036578,1369,0.4289202064,24.23204]
["Média Amostrais","mu_y =",35.3333333333333,"arvores",null,2066,472.722242689981,36,0.1996391761,2.68086]
[null,"mu_x =",0.5690716666666671,"Km",null,42416,18.1850441839436,1089,0.2141930961,15.27273]
[{"$nulls":5},44275,185.576554405916,1764,0.20888556160000002,19.19568]
["Estimador de Razão","R =",62.089426346418,"arvores/Km",null,45028,43.2950918840735,169,0.0994456225,4.09955]
[{"$nulls":5},45754,55.8369073725709,676,0.29062881,14.0166]
["Variância Populacional","Soma(y_i^2) =",45622,null,null,47461,0.9413107798524841,400,0.0939361201,6.1298]
[null,"Soma(x_i^2) =",10.942245550300001,null,null,47481,157.046423232788,625,0.3653960704,15.112]
[null,"Soma(x_i y_i) =",670.55478,null,null,47597,137.950732740411,529,0.31315216,12.8708]
[{"$nulls":5},47649,9.10609717857912,289,0.10394176000000001,5.4808]
[null,"s^2_R =",156.437698561406,null,null,47659,0.788167542907615,1089,0.2978867241,18.01107]
[null,"s^2_R =",156.437698561406,null,null,47691,6.16384966351534,400,0.07959733690000001,5.6426]
[{"$nulls":5},47724,16.0456037450507,625,0.21823846560000001,11.679]
[{"$nulls":5},47725,6.44879996062599,961,0.21011222440000002,14.20978]
["Estimador do Número Médio de Árvores por Kilometro de Perímetro de Quadra",{"$nulls":4},47758,85.0402417290953,2916,0.5201150161,38.94426]
["É o próprio estimador de razão (mu_R = R)","R =",62.089426346418,"arvores/Km",null,47802,0.0372518274245492,1089,0.28579716,17.6418]
["Correção para População Finita","correcao =",0.8909090909090911,null,null,47821,73.8431875334025,1444,0.22431590440000002,17.99756]
["Variância do Estimador","Var( R ) =",14.0900075486954,"(arvores/Km)^2",null,47827,17.4335224304902,2209,0.6793386084,38.73834]
[{"$nulls":5},47880,10.7820052102846,625,0.20750758090000002,11.38825]
["Estatística t","t =",2.04522964213271,null,null,47949,583.964055686404,3481,0.3147658816,33.10136]
[{"$nulls":5},47952,639.8680385928,4900,0.5184,50.4]
["Erro Amostral","E.A. =",7.67710872716769,"arvores/Km",null,47972,516.995875721341,7921,1.1389371841,94.98169]
["Erro Amostra l%","E.A. % =",12.3645992223128,"%",null,48054,188.937823686337,841,0.4739634025,19.96505]
[{"$nulls":5},48506,51.6757110096224,1681,0.2965455936,22.32696]
[{"$nulls":5},48639,0.306126591415669,1296,0.3465912384,21.19392]
["Tamanho de Amostra Para Erro Amostral",{"$nulls":4},50423,1069.55393928282,1936,1.5261637444,54.35672]
[null,"E_% =",5,null,null,50923,0.310063870471916,841,0.20985561,13.2849]
[null,"V_% = ",20.1443408725632,null,null,53375,29.1598671522089,1296,0.44459556840000003,24.00408]
[{"$nulls":5},55238,3.41189347178183,1444,0.41186873290000003,24.38726]
[null,"Iteração","t","n*",null,59547,141.844812101011,1681,0.2195109904,19.20932]
[null,1,2.04522964213271,118]
[null,2,1.9804475986834,114]
[null,3,1.98118035941466,114]
[null,4,1.98118035941466,114]
[]
["Estimador do Número TOTAL de Árvores no Bairro"]
["Estimador do Total de Árvores","Tau_y =",9804.41092656754,"árvores"]
["Variância do Total","Var( Tau_y ) =",351332.998019158,"árvores^2"]
[]
["Estatística t","t =",2.04522964213271]
[]
["Erro Amostral","E.A. =",1212.27611717872,"arvores"]
["Erro Amostra l%","E.A. % =",12.3645992223128,"%"]

{"sheet":"Comparacao","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Número Médio de Árvores em Vias Públicas num Bairro"]
[]
["Estimador Padrão da Amostragem Aleatória Simples"]
["Média","mu =",35.3333333333333,"árvores/quadra","mu =",61.5337590245116,"árvores/Km"]
["Variância da Média ","Var(mu) =",489.880374180578,"(árvores/quadra)^2","Var(mu) =",25.3701470307751,"(árvores/Km)^2"]
["Tamanho da Amostra p/ Erro de 5%","'n* =",9017]
[]
[]
["Estimador de Razão"]
["Média","mu =",62.089426346418,"árvores/Km"]
["Variância da Média ","Var(mu) =",14.0900075486954,"(árvores/Km)^2"]
["Tamanho da Amostra p/ Erro de 5%","'n* =",114]
[]
["Comparação"]
["Razão das Variâncias da Média",null,null,"Var(mu_R) / Var(mu) * 100 =",2.87621392717839,"%"]
["Razão dos Tamanhos de Amostra p/ E=5%",null,null,"n*_R / n* * 100 =",1.2642785848952,"%"]