{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Dados","Am. AleatóriaSimples","1) Estimador de Regressão","2) Estimadores Regressao x Raza"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"defined_names":4,"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":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Dados para os Exercícios que se seguem: Compartimentos em Floresta Nativa"]
["Compartimento: 350 x 700 m"]
["Área total do Compartimento: 24,5 ha"]
["Censo das árvores com DAP maior que 50cm: área basal média = 5,180449 m2/ha"]
["Amostra das árvores com DAP maior que 20cm"]
["Amostra de 14 faixas de 350 x 10 m"]
["Tamano da População: N = 700 / 10 = 70"]
[]
[null,"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)"]
[null,1,162.86,17.89,31.4,187.22,9.39]
[null,2,125.71,9.08,27.38,80,2.47]
[null,3,151.43,13.92,29.59,137.61,6.4]
[null,4,140,9.58,26.68,83.77,2.71]
[null,5,140,8.51,25.01,73.01,1.92]
[null,6,111.43,7.61,25.51,71.63,2.24]
[null,7,137.14,11.25,28.08,106.25,3.78]
[null,8,131.43,17.63,34.57,192.63,10.75]
[null,9,165.71,12.26,27.97,107.8,2.74]
[null,10,145.71,12.52,29.37,116.93,5.34]
[null,11,140,14.97,32.77,146.16,8.41]
[null,12,137.14,15.17,32.93,152.77,7.1]
[null,13,165.71,10.25,25.8,85.49,1.81]
[null,14,94.29,7.27,27.46,66.84,2.86]
[null,"med.x",139.18285714285713,11.993571428571428,28.894285714285708,114.86500000000001,4.851428571428571]
[null,"var.x",null,12.393501648351625]

{"sheet":"Am. AleatóriaSimples","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.18,"m²/ha"]
[]
[]
["Área Basal Média do Compartimento (DAP >= 20)"]
[]
["Tamanho da Amostra","n=",14]
["Média – área basal DAP >= 20","mu =",11.993571428571428,"m²/ha"]
["Variância","S^2 =",12.393501648351625,"(m²/ha)^2"]
[]
["Variância da Média","Cor. Pop. Finita =",0.8]
[null,"Var( mu ) =",0.7082000941915214,"(m²/ha)"]
[]
["Estatística t","t =",2.1603686564627917]
["Erro Amostral",null,1.8181]
["Erroa Amostral %",null,0.15]
[]
[]
["Tamanho de Amostra Adequado"]
[]
["Erro Amostral Desejado","E_% =",5]
["Coeficiente de Variação","V_% =",29.3527]
[]
[null,"Iteração","t","n*"]
[null,1,2.1603686564627917,49]
[null,2,2.0106347576242314,47]
[null,3,2.01289559891943,47]
[null,4,2.01289559891943,47]

{"sheet":"1) Estimador de Regressão","index":2,"n_rows":105,"n_cols":13,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,0,0,5],[6,0,6,5]],"flags":["formulas_cached_only"]}
["Utilizando a área basal das árvores com DAP maior que 50cm, utilize o estimador de regressão para obter a média e o intervalo de confiança de 95% para seguintes variáveis"]
["1.1.) Número de Árvores por Hectare"]
["1.2.) DAP médio (cm)"]
["1.3.) DAP médio quadrático (cm)"]
["1.4.) Produção de madeira (m3/ha)"]
[]
["1.5.) Encontre o tamanho de amostra necessário para erro amostral de 5% (com 95% de probabilidade) para cada uma dessas variáveis."]
[{"$nulls":6},"Variável Aux.","Variável Inter."]
[{"$nulls":6},"(área basal)","(N. árvr/ha)"]
["Árvores/hectare",{"$nulls":4},"Parcela","xi","yi","xi²","yi²","xi yi","(xi - mu_x)²","(yi - mu_y)²"]
[null,"N",70,null,null,1,9.39,465.3142857142858,88.17210000000001,216517.384489796,4369.3011428571435,20.598630612244904,4576.384439816766]
[null,"n",14,null,null,2,2.47,359.1714285714286,6.100900000000001,129004.11510204081,887.1534285714287,5.6712020408163255,1481.778608912946]
[null,"mu_x",4.851428571428571,"m2/ha",null,3,6.4,432.6571428571429,40.96000000000001,187192.20326530616,2769.005714285715,2.3980734693877563,1224.4286380674807]
[null,"mu_y",397.6653061224489,"cm",null,4,2.71,400,7.3441,160000,1084,4.585716326530612,5.450795501874607]
[{"$nulls":5},5,1.92,400,3.6864,160000,768,8.593273469387755,5.450795501874607]
[null,"∑ xi",67.92,null,null,6,2.24,318.3714285714286,5.017600000000001,101360.36653061227,713.1520000000002,6.819559183673468,6287.519017076197]
[null,"∑ yi",5567.314285714285,null,null,7,3.78,391.8285714285714,14.2884,153529.6293877551,1481.1119999999999,1.1479591836734697,34.06747188671297]
[null,"∑ xi²",449.7489999999999,null,null,8,10.75,375.51428571428573,115.5625,141010.97877551022,4036.7785714285715,34.79314489795918,490.6677051228609]
[null,"∑ yi²",2256361.5836734693,null,null,9,2.74,473.4571428571429,7.507600000000001,224161.66612244904,1297.2725714285716,4.458130612244897,5744.4025156185135]
[null,"∑ xi yi",27402.318,null,null,10,5.34,416.31428571428575,28.5156,173317.58448979593,2223.118285714286,0.2387020408163264,347.7844398167473]
[{"$nulls":5},11,8.41,400,70.7281,160000,3364,12.663430612244898,5.450795501874607]
[null,"Beta =",3.2675524078668388,null,null,12,7.1,391.8285714285714,50.41,153529.6293877551,2781.982857142857,5.056073469387753,34.06747188671297]
[null,"S²_L =",3429.1711638160764,"(m2/ha)^2",null,13,1.81,473.4571428571429,3.2761,224161.66612244904,856.9574285714287,9.25028775510204,5744.4025156185135]
[null,"mu_L =",398.74039761606485,"m2/ha",null,14,2.86,269.40000000000003,8.179599999999999,72576.36000000002,770.484,3.9657877551020415,16451.988754685517]
[{"$nulls":5},"∑",67.92,5567.314285714285,449.7489999999999,2256361.5836734693,27402.318,120.23997142857142,42433.84396501459]
[null,"Corr. Pop. Finita",0.8]
[null,"Var mu_L",195.95263793234722,"(m2/ha)^2"]
[null,"t-stat",2.1603686564627917]
[null,"Erro amostral",30.241506700892877,"m2/ha"]
[null,"Erro amostral (%)",7.6047636631345785,"%"]
[]
[null,"E_% =",5]
[null,"V_% =",14.68602773074573]
[]
[null,"Iteração","t-stat","n*"]
[null,1,2.1603686564627917,26]
[null,2,2.0595385527532977,25]
[null,3,2.0638985616280254,25]
[]
[]
[]
[{"$nulls":5},"Variável Aux.","Variável Inter."]
[{"$nulls":5},"(área basal)","(DAP médio)"]
["DAP médio (cm)",null,null,null,"Parcela","xi","yi","xi²","yi²","xi yi","(xi - mu_x)²","(yi - mu_y)²"]
["N",70,null,null,1,9.39,31.4,88.17210000000001,985.9599999999999,294.846,20.598630612244904,6.278604081632678]
["n",14,null,null,2,2.47,27.38,6.100900000000001,749.6644,67.6286,5.6712020408163255,2.2930612244897794]
["mu_x",4.851428571428571,"m2/ha",null,3,6.4,29.59,40.96000000000001,875.5681,189.376,2.3980734693877563,0.4840183673469474]
["mu_y",28.894285714285708,"cm",null,4,2.71,26.68,7.3441,711.8224,72.3028,4.585716326530612,4.903061224489769]
[{"$nulls":4},5,1.92,25.01,3.6864,625.5001000000001,48.0192,8.593273469387755,15.08767551020402]
["∑ xi",67.92,null,null,6,2.24,25.51,5.017600000000001,650.7601000000001,57.14240000000001,6.819559183673468,11.453389795918314]
["∑ yi",404.5199999999999,null,null,7,3.78,28.08,14.2884,788.4863999999999,106.1424,1.1479591836734697,0.6630612244897883]
["∑ xi²",449.7489999999999,null,null,8,10.75,34.57,115.5625,1195.0849,371.6275,34.79314489795918,32.2137326530613]
["∑ yi²",11805.713600000001,null,null,9,2.74,27.97,7.507600000000001,782.3208999999999,76.6378,4.458130612244897,0.8543040816326434]
["∑ xi yi",2075.1908000000003,null,null,10,5.34,29.37,28.5156,862.5969,156.8358,0.2387020408163264,0.22630408163266008]
[{"$nulls":4},11,8.41,32.77,70.7281,1073.8729000000003,275.5957,12.663430612244898,15.02116122448987]
["Beta =",0.9372167420437136,null,null,12,7.1,32.93,50.41,1084.3849,233.803,5.056073469387753,16.286989795918416]
["S²_L =",0.9817776093631458,"(m2/ha)^2",null,13,1.81,25.8,3.2761,665.64,46.698,9.25028775510204,9.574604081632609]
["mu_L =",29.20264916841725,"m2/ha",null,14,2.86,27.46,8.179599999999999,754.0516,78.5356,3.9657877551020415,2.0571755102040608]
[{"$nulls":4},"∑",67.92,404.5199999999999,449.7489999999999,11805.713600000001,2075.1908000000003,120.23997142857142,117.39714285714287]
["Corr. Pop. Finita",0.8]
["Var mu_L",0.056101577677894046,"(m2/ha)^2"]
["t-stat",2.1603686564627917]
["Erro amostral",0.5116999859119467,"m2/ha"]
["Erro amostral (%)",1.7709383473665712,"%"]
[]
["E_% =",5]
["V_% =",3.393003523367007]
[]
["Iteração","t-stat","n*"]
[1,2.1603686564627917,2.0852140582065832]
[2,12.706204736174694,36.053896245857324]
[]
[]
[]
[{"$nulls":5},"Variável Aux.","Variável Inter."]
[{"$nulls":5},"(área basal)","(Produção)"]
["Produção (m³/ha)",null,null,null,"Parcela","xi","yi","xi²","yi²","xi yi","(xi - mu_x)²","(yi - mu_y)²"]
["N",70,null,null,1,9.39,187.22,88.17210000000001,35051.3284,1757.9958000000001,20.598630612244904,5235.246024999999]
["n",14,null,null,2,2.47,80,6.100900000000001,6400,197.60000000000002,5.6712020408163255,1215.5682250000007]
["mu_x",4.851428571428571,"m2/ha",null,3,6.4,137.61,40.96000000000001,18936.512100000004,880.7040000000002,2.3980734693877563,517.3350250000002]
["mu_y",114.86500000000001,"cm",null,4,2.71,83.77,7.3441,7017.412899999999,227.0167,4.585716326530612,966.8990250000008]
[{"$nulls":4},5,1.92,73.01,3.6864,5330.460100000001,140.1792,8.593273469387755,1751.8410250000004]
["∑ xi",67.92,null,null,6,2.24,71.63,5.017600000000001,5130.8569,160.4512,6.819559183673468,1869.2652250000012]
["∑ yi",1608.1100000000001,null,null,7,3.78,106.25,14.2884,11289.0625,401.625,1.1479591836734697,74.21822500000016]
["∑ xi²",449.7489999999999,null,null,8,10.75,192.63,115.5625,37106.3169,2070.7725,34.79314489795918,6047.3952249999975]
["∑ yi²",208032.9589,null,null,9,2.74,107.8,7.507600000000001,11620.84,295.372,4.458130612244897,49.914225000000165]
["∑ xi yi",9415.8945,null,null,10,5.34,116.93,28.5156,13672.6249,624.4062,0.2387020408163264,4.264224999999991]
[{"$nulls":4},11,8.41,146.16,70.7281,21362.7456,1229.2056,12.663430612244898,979.3770249999992]
["Beta =",13.425349996518873,null,null,12,7.1,152.77,50.41,23338.6729,1084.667,5.056073469387753,1436.789025]
["S²_L =",137.11238256870365,"(m2/ha)^2",null,13,1.81,85.49,3.2761,7308.540099999999,154.7369,9.25028775510204,862.8906250000008]
["mu_L =",119.28221440957608,"m2/ha",null,14,2.86,66.84,8.179599999999999,4467.5856,191.1624,3.9657877551020415,2306.4006250000007]
[{"$nulls":4},"∑",67.92,1608.1100000000001,449.7489999999999,208032.9589,9415.8945,120.23997142857142,23317.403749999998]
["Corr. Pop. Finita",0.8]
["Var mu_L",7.834993289640209,"(m2/ha)^2"]
["t-stat",2.1603686564627917]
["Erro amostral",6.047100440320212,"m2/ha"]
["Erro amostral (%)",5.264528307421941,"%"]
[]
["E_% =",5]
["V_% =",9.816635053235345]
[]
["Iteração","t-stat","n*"]
[1,2.1603686564627917,15]
[2,2.1447866879178035,15]
[3,2.1447866879178035,15]

{"sheet":"2) Estimadores Regressao x Raza","index":3,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Dentre as variáveis apresentadas nos dados, existe alguma em que o estimador de RAZÃO seria mais apropriado que o estimador de Regressão?  Demonstre e explique sua resposta."]
[]
[]
["Gráfico 1","Área Basal DAP >= 50 cm (m2/ha)","Número (arv/ha)","Gráfico 2","Área Basal DAP >= 50 cm (m2/ha)","DAP médio (cm)","Gráfico 3","Área Basal DAP >= 50 cm (m2/ha)","Produção (m³/ha)"]
[null,9.39,465.3142857142858,null,9.39,31.4,null,9.39,187.22]
[null,2.47,359.1714285714286,null,2.47,27.38,null,2.47,80]
[null,6.4,432.6571428571429,null,6.4,29.59,null,6.4,137.61]
[null,2.71,400,null,2.71,26.68,null,2.71,83.77]
[null,1.92,400,null,1.92,25.01,null,1.92,73.01]
[null,2.24,318.3714285714286,null,2.24,25.51,null,2.24,71.63]
[null,3.78,391.8285714285714,null,3.78,28.08,null,3.78,106.25]
[null,10.75,375.51428571428573,null,10.75,34.57,null,10.75,192.63]
[null,2.74,473.4571428571429,null,2.74,27.97,null,2.74,107.8]
[null,5.34,416.31428571428575,null,5.34,29.37,null,5.34,116.93]
[null,8.41,400,null,8.41,32.77,null,8.41,146.16]
[null,7.1,391.8285714285714,null,7.1,32.93,null,7.1,152.77]
[null,1.81,473.4571428571429,null,1.81,25.8,null,1.81,85.49]
[null,2.86,269.40000000000003,null,2.86,27.46,null,2.86,66.84]
[]
["Gráfico 1",{"$nulls":4},"Gráfico 2",{"$nulls":4},"Gráfico 3"]