Mapa distribución excel

Á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



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



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



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

Mapa distribución excel

Documents

Transcript of Mapa distribución excel