Post on 21-Jul-2015
Árbol de caoba
Mapa de distribuciónExcel
Objetivos
• Identificar dónde se encuentran localizados los árboles de Caoba.
• Utilizar datos tales como DBH, Radians, Seno, Coseno, X y Y para poder graficar la disperción.
DatosÁrbol de Caoba
Datos: cuadrante 1
CuadranteNumero de árbol Distancia (m)
Diametro (cm) Radianes Seno Coseno X Y
1 1 25.5 38 0.663225116 0.615661475 0.816391624 15.69936762 20.81798642
1 2 5 37 0.645771823 0.601815023 0.824309417 3.009075116 4.121547084
1 3 9.7 28 0.488692191 0.469471563 0.891807486 4.553874159 8.650532611
1 4 15 31.5 0.549778714 0.522498565 0.866574985 7.837478471 12.99862477
1 5 23.6 120.5 2.103121749 0.86162916 0.651201956 20.33444819 15.36836616
1 6 18.7 44 0.767944871 0.69465837 0.768272432 12.99011153 14.36669447
1 7 10.9 62 1.082104136 0.882947593 0.634876555 9.624128762 6.920154452
1 8 7.2 35.5 0.619591884 0.580702956 0.836077207 4.181061281 6.019755888
1 9 14.3 40.3 0.703367689 0.64678978 0.798022475 9.249093847 11.41172139
1 10 11.7 15.4 0.268780705 0.265556117 0.964946699 3.107006575 11.28987638
1 11 32.8 25 0.436332313 0.422618262 0.912018188 13.86187899 29.91419657
1 12 25 78 1.361356817 0.978147601 0.558560003 24.45369002 13.96400007
Datos: cuadrante 2
CuadranteNumero de árbol Distancia (m)
Diametro (cm) Radianes Seno Coseno X Y
2 25 13.1 87 1.518436449 0.998629535 0.541455005 13.08204691 7.093060564
2 26 20.9 234 4.08407045-0.80901699
4 0.690210078 -16.90845518 14.42539063
2 27 24.8 220 3.839724354 -0.64278761 0.800427896 -15.94113272 19.85061182
2 28 20.5 197 3.438298626 -0.292371705 0.957562987 -5.993619947 19.63004123
2 29 34 221 3.857177647-0.65605902
9 0.792402366-22.3060069
9 26.94168045
2 30 39.2 152 2.652900463 0.469471563 0.891807486 18.40328526 34.95885344
2 31 30 170 2.967059728 0.173648178 0.984961002 5.20944533 29.54883007
2 32 17.3 165 2.879793266 0.258819045 0.966692905 4.47756948 16.72378725
2 33 28 141 2.460914245 0.629320391 0.80842771 17.62097095 22.63597587
2 34 22.1 213 3.717551307-0.54463903
5 0.855314366 -12.03652267 18.90244749
2 35 16 173 3.019419606 0.121869343 0.992583118 1.949909494 15.88132989
2 36 17 156 2.722713633 0.406736643 0.918416742 6.914522932 15.61308461
Datos: cuadrante 3
CuadranteNumero de árbol Distancia (m)
Diametro (cm) Radianes Seno Coseno X Y
3 37 4.2 158 2.757620218 0.374606593 0.930651644 1.573347692 3.908736904
3 38 11.2 260 4.537856055-0.98480775
3 0.553023298 -11.02984683 6.193860941
3 39 21.7 198 3.455751919-0.30901699
4 0.952632984-6.70566877
8 20.67213575
3 40 7 28 0.488692191 0.469471563 0.891807486 3.28630094 6.2426524
3 41 17.2 195 3.403392041-0.25881904
5 0.966692905 -4.451687576 16.62711796
3 42 21.4 244 4.258603375-0.89879404
6 0.622554172 -19.23419259 13.32265928
3 43 32.4 237 4.136430327-0.83867056
8 0.668452188 -27.1729264 21.6578509
3 44 25.9 100 1.745329252 0.984807753 0.553023298 25.5065208 14.32330343
3 45 20 84 1.466076572 0.994521895 0.544903842 19.89043791 10.89807684
3 46 25 110 1.919862177 0.939692621 0.590036224 23.49231552 14.75090559
3 47 63 180 3.141592654 1.22515E-16 1 7.71844E-15 63
Datos: cuadrante 4
CuadranteNumero de árbol Distancia (m)
Diametro (cm) Radianes Seno Coseno X Y
4 13 22 145 2.530727415 0.573576436 0.839965635 12.6186816 18.47924398
4 14 17 131 2.28638132 0.75470958 0.728470534 12.83006286 12.38399908
4 15 14 42 0.733038286 0.669130606 0.784361251 9.367828489 10.98105751
4 16 11 265 4.625122518-0.99619469
8 0.543500437 -10.95814168 5.978504812
4 17 15.5 160 2.792526803 0.342020143 0.942079051 5.301312222 14.60222528
4 18 22 50 0.872664626 0.766044443 0.720658649 16.85297775 15.85449027
4 19 26.5 86 1.500983157 0.99756405 0.542350482 26.43544733 14.37228777
4 20 21 162 2.827433388 0.309016994 0.952632984 6.489356882 20.00529267
4 21 24.25 248 4.328416545-0.92718385
50.60008908
7-22.4842084
7 14.55216036
4 22 28.6 310 5.410520681-0.76604444
3 0.720658649 -21.90887107 20.61083735
4 23 39.2 152 2.652900463 0.469471563 0.891807486 18.40328526 34.95885344
4 24 31.9 150 2.617993878 0.5 0.877582562 15.95 27.99488372
Gráfica