Cristaloquimica

PRACTICA No 4
GEOQUIMICA GENERAL
SE TIENE UNA MATRIZ DE LA CUENCA DEL RIO SUPE CON EL MUESTREO DE SEDIMENTOS DE QUEBRADAS
1.- GRAFICAR EN IMÁGENES DE GOOGLE EARTH LOS PUNTOS DE MUESTREO.

2.- INGRESAR LA DATA DE EXCELL A IBM-SPPSS

3.- DETERMINAR LA PRUEBA DE NORMALIDAD DE KOLMOROV-SMIRNOV-LILIEFORS

| Kolmogorov-Smirnova |   |   | Shapiro-Wilk |   |   |
  | Estadístico | gl | Sig.| Estadístico | gl | Sig. |
AG_PPM | .428 | 47 | .000 | .593 | 47 | .000 |
Puntuación Z(LnAG_PPM) | .439 | 47 | .000 | .613 | 47 | .000 |
AS_PPM | .136 | 47 | .030 | .916 | 47 | .003 |
Puntuación Z(LnAS_PPM) | .107 | 47 | .200 | .980 | 47 | .602 |
CR_PPM | .186 | 47 | .000 | .890 | 47 | .000 |
Puntuación Z(LnCR_PPM) | .121 | 47 | .084 | .965 | 47 | .164 |
CU_PPM | .155 | 47 | .006 |.867 | 47 | .000 |
Puntuación Z(LnCU_PPM) | .071 | 47 | .200 | .980 | 47 | .593 |
FE__ | .141 | 47 | .021 | .781 | 47 | .000 |
Puntuación Z(LnFE__) | .069 | 47 | .200 | .960 | 47 | .107 |
MO_PPM | .275 | 47 | .000 | .525 | 47 | .000 |
Puntuación Z(LnMO_PPM) | .205 | 47 | .000 | .891 | 47 | .000 |
NI_PPM | .158 | 47 | .005 | .969 | 47 | .253 |
Puntuación Z(LnNI_PPM) | .127 | 47 | .056| .979 | 47 | .549 |
PB_PPM | .079 | 47 | .200 | .975 | 47 | .403 |
Puntuación Z(LnPB_PPM) | .111 | 47 | .195 | .886 | 47 | .000 |
SB_PPM | .411 | 47 | .000 | .618 | 47 | .000 |
Puntuación Z(LnSB_PPM) | .421 | 47 | .000 | .634 | 47 | .000 |
V_PPM | .134 | 47 | .034 | .887 | 47 | .000 |
Puntuación Z(LnV_PPM) | .089 | 47 | .200 | .976 | 47 | .437 |
W_PPM | .274 | 47 | .000 | .656 | 47| .000 |
Puntuación Z(LnW_PPM) | .246 | 47 | .000 | .735 | 47 | .000 |
ZN_PPM | .180 | 47 | .001 | .907 | 47 | .001 |
Puntuación Z(LnZN_PPM) | .113 | 47 | .169 | .975 | 47 | .392 |
HG_PPM | .533 | 47 | .000 | .314 | 47 | .000 |

4.- GRAFICAR LOS HISTOGRAMAS EN PPM Y LNPPM DE CADA UNO DE LOS ELEMENTOS
AG:

As:

Cd:

Cr:

Cu:

Fe:

Mo:

Ni:

Pb:

Sb:

Sn:

V:

W:Hg:

5.- HACER UNA TABLA EN EXCELL QUE MUESTRE LA NORMALIDAD DE LOS ELEMENTOS.
Pruebas de normalidadb,c,d,e,f,g |   |
| Kolmogorov-Smirnova | Shapiro-Wilk |   |
| Estadístico | gl | Sig. | Estadístico | gl | Sig. |   |
AG_PPM | .426 | 43 | .000 | .597 | 43 | .000 |   |
LnAG_PPM | .437 | 43 | .000 | .617 | 43 | .000 | No es normal |
AS_PPM | .099 | 43 | .200 | .956 | 43 | .100|   |
LnAS_PPM | .120 | 43 | .130 | .972 | 43 | .363 | Normal |
CR_PPM | .160 | 43 | .007 | .907 | 43 | .002 |   |
LnCR_PPM | .094 | 43 | .200 | .968 | 43 | .275 | Normal |
CU_PPM | .166 | 43 | .004 | .872 | 43 | .000 |   |
LnCU_PPM | .073 | 43 | .200 | .985 | 43 | .845 | Normal |
FE__ | .134 | 43 | .049 | .780 | 43 | .000 |   |
LnFE__ | .075 | 43 | .200 | .958 | 43 | .119 | Normal |MO_PPM | .272 | 43 | .000 | .540 | 43 | .000 |   |
LnMO_PPM | .190 | 43 | .000 | .903 | 43 | .002 | No es normal |
NI_PPM | .134 | 43 | .049 | .976 | 43 | .489 |   |
LnNI_PPM | .120 | 43 | .127 | .980 | 43 | .647 | Normal |
PB_PPM | .084 | 43 | .200 | .974 | 43 | .419 |   |
LnPB_PPM | .126 | 43 | .082 | .874 | 43 | .000 | No es normal |
SB_PPM | .413 | 43 | .000 | .632 | 43 | .000 |  |
LnSB_PPM | .422 | 43 | .000 | .643 | 43 | .000 | Normal |
V_PPM | .112 | 43 | .200 | .897 | 43 | .001 |   |
LnV_PPM | .088 | 43 | .200 | .977 | 43 | .528 | Normal |
W_PPM | .268 | 43 | .000 | .670 | 43 | .000 |   |
LnW_PPM | .237 | 43 | .000 | .748 | 43 | .000 | No es normal |
ZN_PPM | .163 | 43 | .006 | .923 | 43 | .007 |   |
LnZN_PPM | .113 | 43 | .197 | .971 | 43 | .348 |Normal |

6.- HALLAR LOS DESCRITIVOS ESTADISTICOS DE LOS ELEMENTOS
Estadísticos descriptivos |
| N | Mínimo | Máximo | Media | Desv. típ. |
AG_PPM | 47 | .20 | .50 | .2362 | .06733 |
CD_PPM | 47 | 1.00 | 1.00 | 1.0000 | .00000 |
LnMO_PPM | 47 | .00 | 3.14 | 1.1321 | .54599 |
LnSB_PPM | 47 | 1.61 | 2.56 | 1.7610 | .26161 |
LnW_PPM | 47 | 2.30 | 3.33 | 2.4760 | .24937 |
LnPB_PPM |...