{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Inventario Urbano","Amostragem Dupla"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"Inventario Urbano","index":0,"n_rows":115,"n_cols":32,"rows_kept":115,"cut":false,"hidden":false,"merged":[[1,0,1,5]],"flags":["formulas_cached_only"]}
["Bairro Santo Amaro – Cidade de São Paulo"]
["Encontre o NÚMERO TOTAL de árvores no Bairro Santo Amaro com o respectivo intervalo de confiança de 95%."]
[{"$nulls":7},"Praças-Canteiros",{"$nulls":5},"Quadras",{"$nulls":7},"Bairro Jardins"]
["Dados Populacionais",{"$nulls":6},"Dados populacionais",{"$nulls":5},"Dados populacionais",{"$nulls":7},"Dados populacionais",null,null,"Praça-Canteiro","Quadra","Total"]
[null,"Número total de quadras =",273,"Praça-Canteiros",null,null,null,"Tamanho da pop",null,"N=",273,null,null,"Tamanho da pop",null,null,"N=",665,null,null,null,"Tamanho da Pop.",null,"N=",273,665,938]
[null,null,665,"Quadras (propriamente ditas)",null,null,null,"Total Populacional",null,"tau_x=",90586.71,null,null,"Total Populacional",null,null,"tau_x=",385875.54,null,null,null,"Total Pop. X",null,"tau_x=",90586.71,385875.54,476462.25]
[{"$nulls":7},"Média Populacional",null,"m_x=",331.81945054945055,null,null,"Média Populacional",null,null,"m_x=",580.263969924812,null,null,null,"Média populacional X",null,"m_x=",331.81945054945055,580.263969924812,507.95549040511725]
[null,"Perímetro total das quadras =",90586.71,"m","Praça-Canteiros"]
[null,null,385875.54,"m","Quadras",null,null,"Dados amostrais",{"$nulls":5},"Dados amostrais"]
[{"$nulls":7},"Tamanho da Amostra",null,"n=",29,null,null,"Tamanho da Amostra",null,null,"n=",71,null,null,null,"Estimativas por estrato (tipo de quadra) e Bairro Jardins"]
[null,"Área total das quadras =",421928,"m2","Praça-Canteiros",null,null,"Correção pop. Finita",null,null,0.8937728937728938,null,null,"Correção pop. Finita",null,null,null,0.8932330827067669,null,null,null,"Tamanho da Pop","Tot. Variavel Aux X","Tam Amostra","Índice do Estrato","Var Pop","Coef. Variação","Tot. Variável de Interesse Y ","Variância do total"]
[null,null,12633952,"m2","Quadras",{"$nulls":16},"N","tau_x","n","a","s^²_R","V","tau_Y_R","var(tau_Y_R)","a*s^²_R","(a*s^²_R)^²"]
[{"$nulls":7},"Médias Amostrais",null,"m_x_hat=",414.61103448275867,null,null,"Médias Amostrais",null,null,"m_x_hat=",533.3,null,null,"Praça-Canteiro",273,90586.71,29,2296.97,340,144.4,3488,780.962,780969.7999999999,21816900920]
["Amostra",{"$nulls":8},"m_y_hat=",15.96551724137931,{"$nulls":5},"m_y_hat=",20.52,null,null,"Quadra",665,385875.54,71,5563.52,209.43,64.8,14848,1165164,1165167.9936000002,19394391894]
["Tipo de Quadra","Identificador da Quadra","Area da Quadra (m2)","Perímetro da Quadra (m)","Número de Árvores na Quadra","(Yi-R.Xi)²",{"$nulls":20},47884.5661]
["Praca_Canteiro",264,36,35.16,2,0.4174274246153936,null,"Estimador de Razão ",null,"R=",0.038507217400272124,null,null,"Estimador da Razão",null,null,"R=",0.038,null,null,"Total do Bairro",938]
["Praca_Canteiro",1182,20537,626.51,20,17.016918405494934,{"$nulls":14},"Média do Bairro",507.95549040511725,{"$nulls":4},"tau_R=",null,18336,1946137.7936,1946137.7936,41211292814]
["Praca_Canteiro",2224,577,110.47,3,1.5722459155677702,null,"Variância Populacional",null,"s²_R=",340,null,null,"Variância Populacional",null,null,"s²_R=",209.43,{"$nulls":8},"m_R=",null,0.027702633639022537,1e-07]
["Praca_Canteiro",4701,37,48.98,0,3.5573110001504493,{"$nulls":4},4.4473042,"%"]
["Praca_Canteiro",4742,25,36.04,0,1.925989159487692,null,"Variância Estim. de Razão",null,"Var(R)=",9.5e-05,null,null,"Variância Estim. De Razão",null,null,"Var(R)=",7.8e-06,{"$nulls":5},"Tamanho Amostral Efetivo",null,null,"n.e=",null,91]
["Praca_Canteiro",4879,3140,406.41,0,244.91368047947373,{"$nulls":17},"Estat t",null,null,"t=",null,1.9863771544186202]
["Praca_Canteiro",6147,3100,520.07,29,80.52462556550336,null,"Estatística t",null,"t=",2.0484071417952445,null,null,"Estatística t",null,null,"t=",1.9944371117711854]
["Praca_Canteiro",6185,114,52.58,2,0.0006105589408489247,{"$nulls":17},"Erro amostral total",null,null,"E.A.(tau_R)=",null,2771.0764341357485]
["Praca_Canteiro",6201,244,139.33,4,1.86379998338969,null,"Densidade de Arborização = número de Árvores por metro",{"$nulls":5},"Densidade de Arbiorização = número de Árvores por metro",{"$nulls":9},"Erro amostral média",null,null,"E.A.(m.u_R)=",null,0.0006281476100086838]
["Praca_Canteiro",7652,262,286.55,36,623.2890152906524,null,null,"R=",null,0.038507217400272124,null,null,null,"R=",null,null,0.03848,{"$nulls":5},"Erro amostral %",null,null,"E.A%=",null,15.112764147773497,"%"]
["Praca_Canteiro",7686,344,319.57,8,18.539495674947787,null,"Erro amostral",null,null,0.019965403145516182,null,null,"Erro amostral",null,null,null,0.0056]
["Praca_Canteiro",7687,20713,3228.49,204,6348.875897725878,null,"Erro amostral %",null,null,51.84847021788463,null,null,"Erro amostral %",null,null,null,14,"%",null,null,null,"Tamaho Amostral Para Erro Desejado"]
["Praca_Canteiro",7711,1541,525.34,19,1.5113790915171332,{"$nulls":15},"Erro amostral Desejado",null,"E%=",5]
["Praca_Canteiro",7714,370,412.92,16,0.009920118383106611,null,"Número Total de Árvores em Praça-Canteiro",{"$nulls":5},"Número Total de Árvores em Quadras"]
["Praca_Canteiro",7717,880,264.13,13,8.003742691780154,null,"Total Estimado","tau_y_R=",null,3488,null,null,"Total Estimador",null,null,"tau_y_R=",14848,null,null,null,"Amostragem","W_h","Proporcional"]
["Praca_Canteiro",9380,739,114.76,0,19.528341127933906,null,"Variância do Total","Var(tau_Y_R)=",null,780962,null,null,"Variância do Total",null,null,"Var(tau_Y_R)=",1165164,{"$nulls":4},"Praça-Canteiro",0.337349397590361]
["Praca_Canteiro",10158,213,252.45,0,94.50069963134669,null,"Erro amostral",null,null,1810,"arv",null,"Erro amostral",null,null,null,2153,{"$nulls":4},"Quadra",0.662650602409639]
["Praca_Canteiro",10194,58,69.93,0,7.251224149355564,null,"Erro amostral %",null,null,52,"%",null,"Erro amostral %",null,null,null,14,"%",null,null,null,"Total",1]
["Praca_Canteiro",10205,495,208.09,0,64.20763804084909]
["Praca_Canteiro",10312,11936,2630.78,58,1875.2379223115731,{"$nulls":17},"Proporcional"]
["Praca_Canteiro",11068,1912,333.39,13,0.026269534467151134,{"$nulls":16},"Iteração","t","n*"]
["Praca_Canteiro",12559,2838,220.91,6,6.283190928360492,{"$nulls":16},1,1.9863771544186202,379]
["Praca_Canteiro",12752,397,122.54,9,18.329748719998523,{"$nulls":16},2,1.9662,377]
["Praca_Canteiro",12789,1174,159.62,2,17.19364504007673,{"$nulls":16},3,1.9663,377]
["Praca_Canteiro",12987,2096,207.58,8,4.451307605070246e-05,{"$nulls":16},4,1.9663,377]
["Praca_Canteiro",13007,3776,276.72,6,21.675702637095167]
["Praca_Canteiro",15070,891,133.71,0,26.510141837388364]
["Praca_Canteiro",15232,225,65.6,0,6.38104713268165]
["Praca_Canteiro",60050,642,215.09,5,10.774920419752487]
["Quadra",364,24383,744.13,32]
["Quadra",5397,14422,530.44,22]
["Quadra",16196,148197,2576.97,57]
["Quadra",16240,25922,728.45,21]
["Quadra",16251,4784,343.67,6]
["Quadra",16292,6813,384.21,18]
["Quadra",16331,10726,533.26,31]
["Quadra",16354,69405,1564.95,89]
["Quadra",16368,9493,502.66,63]
["Quadra",16405,22004,596.75,8]
["Quadra",16490,5790,298.18,5]
["Quadra",16496,14546,503.66,16]
["Quadra",16600,7657,342.51,15]
["Quadra",16603,2842,219.81,8]
["Quadra",16724,8030,358.02,1]
["Quadra",16737,17870,562.77,42]
["Quadra",16966,6911,339.43,3]
["Quadra",16982,7367,338.47,9]
["Quadra",16992,21949,766.02,27]
["Quadra",16996,21084,612.14,14]
["Quadra",17050,11668,518.4,10]
["Quadra",17095,11893,474.39,15]
["Quadra",17139,7383,337.41,12]
["Quadra",17210,6779,418.52,9]
["Quadra",17308,7459,338.07,12]
["Quadra",17382,3407,249.42,1]
["Quadra",17386,7423,339.27,11]
["Quadra",17440,4177,269.14,7]
["Quadra",17506,7448,337.64,7]
["Quadra",17580,6480,372.83,7]
["Quadra",17581,4832,276.31,10]
["Quadra",17593,30491,833.96,16]
["Quadra",18904,7452,338.9,6]
["Quadra",19689,1356,149.9,0]
["Quadra",20746,3506,261.76,12]
["Quadra",21746,12939,574.23,25]
["Quadra",23327,6013,315.58,8]
["Quadra",23360,12754,519.12,9]
["Quadra",25243,18148,642.55,15]
["Quadra",25244,7482,351.84,3]
["Quadra",30512,2575,377.26,16]
["Quadra",37858,5941,320.66,13]
["Quadra",39928,21155,776.29,85]
["Quadra",39942,15159,507.18,16]
["Quadra",39952,9960,394.88,10]
["Quadra",40055,17020,515,29]
["Quadra",40056,22199,600.1,40]
["Quadra",40059,8792,456.24,17]
["Quadra",40082,25646,821.75,52]
["Quadra",40175,24848,715.63,20]
["Quadra",40184,13616,494.14,29]
["Quadra",40188,14237,516.55,20]
["Quadra",40193,7436,392.7,13]
["Quadra",40203,14363,530.91,29]
["Quadra",40213,21910,594.23,36]
["Quadra",40272,8215,434.8,14]
["Quadra",40305,11261,519.74,19]
["Quadra",40331,5894,315.73,5]
["Quadra",40337,15814,647.09,48]
["Quadra",40339,24598,634.64,50]
["Quadra",40391,21789,716.47,32]
["Quadra",40395,10713,417.15,17]
["Quadra",40413,9831,419.74,19]
["Quadra",40414,9237,413.24,11]
["Quadra",40426,6183,369.44,12]
["Quadra",40440,21515,797.9,9]
["Quadra",40441,25076,730.23,56]
["Quadra",40448,17101,776.68,15]
["Quadra",40473,21961,594.89,27]
["Quadra",40544,8451,495.27,11]
["Quadra",41877,27949,802.1,5]

{"sheet":"Amostragem Dupla","index":1,"n_rows":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[[8,0,8,6],[9,0,9,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[6,0,6,6],[7,0,7,6]],"flags":["formulas_cached_only"]}
["Amostragem Dupla em Floresta de Eucalipto",{"$nulls":7},"Dados da Segunda Fase"]
["Encontre a estimativa de produção de madeira (m3/ha), com o respectivo intervalo de confiança de 95%,  utilizando os seguintes métodos:",{"$nulls":7},"ponto","arvore","dap.mm","h.dm"]
["1) Amostragem Aleatória Simples e",{"$nulls":7},"10-3",1,155,252]
["2) Amostragem Dupla.",{"$nulls":7},"10-3",2,153,"NA"]
["3) Compare os resultados obtidos pelos dois métodos.",{"$nulls":7},"10-3",3,160,"NA"]
[{"$nulls":8},"10-3",4,120,"NA"]
["Método Arbustimétrico utilizado:  Pontos de Bitterlich com fator de área basal de 2 m2/ha.",{"$nulls":7},"10-3",5,153,"NA"]
["Para obter o volume das árvores individuais utilize a equação de volume (m3):",{"$nulls":7},"10-3",6,163,"NA"]
["V = exp( -10,085 + 1,853*Ln( DAP) + 1,070*Ln( H ) )",{"$nulls":7},"10-3",7,107,"NA"]
["DAP em centímetros e H em metros.",{"$nulls":7},"10-3",8,110,"NA"]
[{"$nulls":8},"10-3",9,118,"NA"]
["Dados da Primeira Fase",{"$nulls":7},"10-3",10,174,238]
["ponto","area.basal (m2/ha)",{"$nulls":6},"10-3",11,88,"NA"]
["1-1",24,{"$nulls":6},"10-3",12,175,"NA"]
["1-2",24,{"$nulls":6},"10-3",13,161,"NA"]
["10-1",24,{"$nulls":6},"11-1",1,162,254]
["10-2",33,{"$nulls":6},"11-1",2,144,"NA"]
["10-3",25,{"$nulls":6},"11-1",3,176,"NA"]
["10-4",24,{"$nulls":6},"11-1",4,194,"NA"]
["10-5",26,{"$nulls":6},"11-1",5,183,"NA"]
["10-6",21,{"$nulls":6},"11-1",6,173,"NA"]
["10-7",21,{"$nulls":6},"11-1",7,144,"NA"]
["11-1",21,{"$nulls":6},"11-1",8,183,"NA"]
["11-2",23,{"$nulls":6},"11-1",9,176,"NA"]
["11-3",23,{"$nulls":6},"11-1",10,166,"NA"]
["11-4",28,{"$nulls":6},"11-1",11,165,257]
["11-5",20,{"$nulls":6},"11-1",12,168,"NA"]
["11-6",17,{"$nulls":6},"11-1",13,161,"NA"]
["11-7",18,{"$nulls":6},"17-1",1,205,284]
["12-1",24,{"$nulls":6},"17-1",2,145,"NA"]
["13-1",23,{"$nulls":6},"17-1",3,212,"NA"]
["13-2",21,{"$nulls":6},"17-1",4,141,"NA"]
["13-3",22,{"$nulls":6},"17-1",5,165,"NA"]
["14-1",25,{"$nulls":6},"17-1",6,175,"NA"]
["14-2",27,{"$nulls":6},"17-1",7,182,"NA"]
["14-3",25,{"$nulls":6},"17-1",8,162,"NA"]
["14-4",20,{"$nulls":6},"17-1",9,182,"NA"]
["15-1",24,{"$nulls":6},"17-1",10,162,"NA"]
["15-2",23,{"$nulls":6},"17-1",11,193,302]
["15-3",27,{"$nulls":6},"17-1",12,113,"NA"]
["16-1",24,{"$nulls":6},"17-1",13,135,"NA"]
["16-2",29,{"$nulls":6},"17-1",14,176,"NA"]
["17-1",25,{"$nulls":6},"17-1",15,110,"NA"]
["17-2",19,{"$nulls":6},"2-2",1,183,288]
["18-1",20,{"$nulls":6},"2-2",2,143,"NA"]
["19-1",20,{"$nulls":6},"2-2",3,99,"NA"]
["2-1",26,{"$nulls":6},"2-2",4,138,"NA"]
["2-2",34,{"$nulls":6},"2-2",5,167,"NA"]
["2-3",37,{"$nulls":6},"2-2",6,171,"NA"]
["20-1",28,{"$nulls":6},"2-2",7,186,"NA"]
["21-1",28,{"$nulls":6},"2-2",8,101,"NA"]
["21-2",22,{"$nulls":6},"2-2",9,148,"NA"]
["25-1",36,{"$nulls":6},"2-2",10,179,"NA"]
["26-1",26,{"$nulls":6},"2-2",11,97,181]
["26-2",22,{"$nulls":6},"2-2",12,211,"NA"]
["26-3",9,{"$nulls":6},"2-2",13,205,"NA"]
["26-4",19,{"$nulls":6},"2-2",14,184,"NA"]
["26-5",16,{"$nulls":6},"2-2",15,143,"NA"]
["27-1",20,{"$nulls":6},"2-2",16,116,"NA"]
["27-2",21,{"$nulls":6},"2-2",17,122,"NA"]
["27-3",23,{"$nulls":6},"2-2",18,106,"NA"]
["27-4",28,{"$nulls":6},"2-2",19,173,"NA"]
["27-5",20,{"$nulls":6},"2-2",20,123,"NA"]
["27-6",15,{"$nulls":6},"27-4",1,195,258]
["28-1",25,{"$nulls":6},"27-4",2,190,"NA"]
["28-2",28,{"$nulls":6},"27-4",3,145,"NA"]
["28-3",17,{"$nulls":6},"27-4",4,160,"NA"]
["28-4",16,{"$nulls":6},"27-4",5,160,"NA"]
["29-1",27,{"$nulls":6},"27-4",6,145,"NA"]
["29-2",19,{"$nulls":6},"27-4",7,163,"NA"]
["29-3",22,{"$nulls":6},"27-4",8,180,"NA"]
["3-1",19,{"$nulls":6},"27-4",9,173,"NA"]
["3-2",24,{"$nulls":6},"27-4",10,170,"NA"]
["3-3",29,{"$nulls":6},"27-4",11,190,252]
["3-4",21,{"$nulls":6},"27-4",12,170,"NA"]
["3-5",24,{"$nulls":6},"27-4",13,160,"NA"]
["3-6",27,{"$nulls":6},"27-4",14,122,"NA"]
["30-1",21,{"$nulls":6},"27-4",15,190,"NA"]
["30-2",22,{"$nulls":6},"27-4",16,120,"NA"]
["30-3",23,{"$nulls":6},"29-3",1,165,267]
["31-1",22,{"$nulls":6},"29-3",2,163,"NA"]
["31-2",22,{"$nulls":6},"29-3",3,176,"NA"]
["31-3",11,{"$nulls":6},"29-3",4,125,"NA"]
["31-4",23,{"$nulls":6},"29-3",5,165,"NA"]
["32-1",24,{"$nulls":6},"29-3",6,170,"NA"]
["32-2",18,{"$nulls":6},"29-3",7,165,"NA"]
["33-1",22,{"$nulls":6},"29-3",8,110,"NA"]
["34-1",29,{"$nulls":6},"29-3",9,155,"NA"]
["4-1",30,{"$nulls":6},"29-3",10,145,"NA"]
["4-2",33,{"$nulls":6},"29-3",11,145,256]
["4-3",29,{"$nulls":6},"29-3",12,180,"NA"]
["4-4",24,{"$nulls":6},"29-3",13,155,"NA"]
["4-5",29,{"$nulls":6},"3-2",1,155,271]
["4-6",24,{"$nulls":6},"3-2",2,148,"NA"]
["5-1",22,{"$nulls":6},"3-2",3,160,"NA"]
["5-2",22,{"$nulls":6},"3-2",4,183,"NA"]
["5-3",16,{"$nulls":6},"3-2",5,173,"NA"]
["5-4",27,{"$nulls":6},"3-2",6,175,"NA"]
["5-5",20,{"$nulls":6},"3-2",7,112,"NA"]
["5-6",22,{"$nulls":6},"3-2",8,155,"NA"]
["5-7",18,{"$nulls":6},"3-2",9,185,"NA"]
["5-8",25,{"$nulls":6},"3-2",10,156,"NA"]
["6-1",19,{"$nulls":6},"3-2",11,175,278]
["6-2",13,{"$nulls":6},"3-2",12,170,"NA"]
["6-3",17,{"$nulls":6},"3-2",13,171,"NA"]
["6-4",19,{"$nulls":6},"3-2",14,172,"NA"]
["6-5",21,{"$nulls":6},"3-5",1,180,291]
["6-6",15,{"$nulls":6},"3-5",2,196,"NA"]
["6-7",23,{"$nulls":6},"3-5",3,160,"NA"]
["8-1",24,{"$nulls":6},"3-5",4,163,"NA"]
["8-2",22,{"$nulls":6},"3-5",5,195,"NA"]
["8-3",24,{"$nulls":6},"3-5",6,155,"NA"]
["9-1",19,{"$nulls":6},"3-5",7,210,"NA"]
["9-2",18,{"$nulls":6},"3-5",8,180,"NA"]
["9-3",20,{"$nulls":6},"3-5",9,175,"NA"]
["9-4",18,{"$nulls":6},"3-5",10,205,"NA"]
["9-5",22,{"$nulls":6},"3-5",11,114,247]
["9-6",16,{"$nulls":6},"3-5",12,100,"NA"]
[{"$nulls":8},"3-5",13,180,"NA"]
[{"$nulls":8},"4-6",1,206,294]
[{"$nulls":8},"4-6",2,160,"NA"]
[{"$nulls":8},"4-6",3,129,"NA"]
[{"$nulls":8},"4-6",4,143,"NA"]
[{"$nulls":8},"4-6",5,134,"NA"]
[{"$nulls":8},"4-6",6,159,"NA"]
[{"$nulls":8},"4-6",7,151,"NA"]
[{"$nulls":8},"4-6",8,160,"NA"]
[{"$nulls":8},"4-6",9,109,"NA"]
[{"$nulls":8},"4-6",10,172,"NA"]
[{"$nulls":8},"4-6",11,179,294]
[{"$nulls":8},"4-6",12,165,"NA"]
[{"$nulls":8},"4-6",13,144,"NA"]
[{"$nulls":8},"8-3",1,135,167]
[{"$nulls":8},"8-3",2,156,"NA"]
[{"$nulls":8},"8-3",3,172,"NA"]
[{"$nulls":8},"8-3",4,109,"NA"]
[{"$nulls":8},"8-3",5,152,"NA"]
[{"$nulls":8},"8-3",6,132,"NA"]
[{"$nulls":8},"8-3",7,113,"NA"]
[{"$nulls":8},"8-3",8,195,"NA"]
[{"$nulls":8},"8-3",9,105,"NA"]
[{"$nulls":8},"8-3",10,164,251]
[{"$nulls":8},"8-3",11,168,"NA"]
[{"$nulls":8},"8-3",12,99,"NA"]
[{"$nulls":8},"8-3",13,191,"NA"]
[{"$nulls":8},"8-3",14,108,"NA"]
[{"$nulls":8},"8-3",15,170,"NA"]