analisis bidimensional-laboratorio
DESCRIPTION
ANALISIS BIDIMENSIONALTRANSCRIPT
MODELO LINEAL (ORIGINAL)
TABLA DE DATOSN° X Y XY Y2 X2 Y* Error1 20.44 19.35 395.51 374.42 417.79 22.20 2.852 19.48 21.87 426.03 478.30 379.47 22.20 0.333 21.75 22.67 493.07 513.93 473.06 22.20 -0.474 21.64 20.33 439.94 413.31 468.29 22.20 1.875 20.32 18.82 382.42 354.19 412.90 22.20 3.386 23.25 22.89 532.19 523.95 540.56 22.20 -0.697 23.02 22.54 518.87 508.05 529.92 22.20 -0.348 22.70 23.03 522.78 530.38 515.29 22.20 -0.839 26.02 25.88 673.40 669.77 677.04 22.20 -3.68
10 25.85 26.05 673.39 678.60 668.22 22.20 -3.8511 25.80 25.34 653.77 642.12 665.64 22.20 -3.1412 22.41 21.66 485.40 469.16 502.21 22.20 0.5413 20.90 21.05 439.95 443.10 436.81 22.20 1.1514 24.22 25.98 629.24 674.96 586.61 22.20 -3.7815 24.39 24.04 586.34 577.92 594.87 22.20 -1.8416 26.74 26.33 704.06 693.27 715.03 22.20 -4.1317 24.93 24.35 607.05 592.92 621.50 22.20 -2.1518 27.50 27.89 766.98 777.85 756.25 22.20 -5.6919 21.89 22.04 482.46 485.76 479.17 22.20 0.1620 23.11 23.67 547.01 560.27 534.07 22.20 -1.4721 24.56 25.00 614.00 625.00 603.19 22.20 -2.8022 23.13 22.98 531.53 528.08 535.00 22.20 -0.7823 21.68 21.32 462.22 454.54 470.02 22.20 0.8824 21.82 22.11 482.44 488.85 476.11 22.20 0.0925 20.16 19.77 398.56 390.85 406.43 22.20 2.4326 21.23 21.66 459.84 469.16 450.71 22.20 0.5427 25.31 26.10 660.59 681.21 640.60 22.20 -3.9028 22.70 2.02 45.85 4.08 515.29 22.20 20.1829 208.20 21.12 4397.18 446.05 43347.24 22.05 0.9330 22.92 21.88 501.49 478.73 525.33 22.20 0.3231 22.79 22.32 508.67 498.18 519.38 22.20 -0.1232 20.31 20.83 423.06 433.89 412.50 22.20 1.3733 25.12 26.05 654.38 678.60 631.01 22.20 -3.8534 22.64 22.15 501.48 490.62 512.57 22.20 0.0535 18.50 19.25 356.13 370.56 342.25 22.21 2.9636 19.13 18.77 359.07 352.31 365.96 22.20 3.43
Σ 1006.56 799.11 22316.34 18352.98 61728.31 799.11PROMEDIO 27.96 22.20 619.90 509.80 1714.68 22.20N° DATOS 36.00
COVARIANZA (Cxy) -0.743741666666665
VARIANZA L^2(x) 932.913594444445DESVIACION TIPICA L(x) 30.543634270408
B -0.000797225A 22.219790
VARIANZA L^2(y) 17.08DESVIACION TIPICA L(y) 4.13COEFICIENTE DE DETERMINACION 0.0000347232CORRELACION (%) 0.003% PositivaCOEFICIENTE DE CORRELACION 3.472324288788E-05
0.00 50.00 100.00 150.00 200.00 250.000.00
5.00
10.00
15.00
20.00
25.00
30.00
f(x) = − 0.000797224599465253 x + 22.2197903998011R² = 3.47232428876687E-05
Modelo Lineal
Column CLinear (Column C)
SL
Perf
orac
ión
DDH
0.00 50.00 100.00 150.00 200.00 250.000.00
5.00
10.00
15.00
20.00
25.00
30.00
f(x) = − 0.000797224599465253 x + 22.2197903998011R² = 3.47232428876687E-05
Modelo Lineal
Column CLinear (Column C)
SL
Perf
orac
ión
DDH
MODELO LINEAL
TABLA DE DATOSN° X Y XY Y2 X2 Y*1 20.44 19.35 395.51 374.42 417.79 20.392 19.48 21.87 426.03 478.30 379.47 19.433 21.75 22.67 493.07 513.93 473.06 21.704 21.64 20.33 439.94 413.31 468.29 21.595 20.32 18.82 382.42 354.19 412.90 20.276 23.25 22.89 532.19 523.95 540.56 23.207 23.02 22.54 518.87 508.05 529.92 22.978 22.70 23.03 522.78 530.38 515.29 22.659 26.02 25.88 673.40 669.77 677.04 25.97
10 25.85 26.05 673.39 678.60 668.22 25.8011 25.80 25.34 653.77 642.12 665.64 25.7512 22.41 21.66 485.40 469.16 502.21 22.3613 20.90 21.05 439.95 443.10 436.81 20.8514 24.22 25.98 629.24 674.96 586.61 24.1715 24.39 24.04 586.34 577.92 594.87 24.3416 26.74 26.33 704.06 693.27 715.03 26.6917 24.93 24.35 607.05 592.92 621.50 24.8818 27.50 27.89 766.98 777.85 756.25 27.4519 21.89 22.04 482.46 485.76 479.17 21.8420 23.11 23.67 547.01 560.27 534.07 23.0621 24.56 25.00 614.00 625.00 603.19 24.5122 23.13 22.98 531.53 528.08 535.00 23.0823 21.68 21.32 462.22 454.54 470.02 21.6324 21.82 22.11 482.44 488.85 476.11 21.7725 20.16 19.77 398.56 390.85 406.43 20.1126 21.23 21.66 459.84 469.16 450.71 21.1827 25.31 26.10 660.59 681.21 640.60 25.2628 22.70 20.20 458.54 408.04 515.29 22.6529 20.82 21.12 439.72 446.05 433.47 20.7730 22.92 21.88 501.49 478.73 525.33 22.8731 22.79 22.32 508.67 498.18 519.38 22.7432 20.31 20.83 423.06 433.89 412.50 20.2633 25.12 26.05 654.38 678.60 631.01 25.0734 22.64 22.15 501.48 490.62 512.57 22.5935 18.50 19.25 356.13 370.56 342.25 18.4536 19.13 18.77 359.07 352.31 365.96 19.08Σ 819.18 817.29 18771.56 18756.93 18814.54 817.29
PROMEDIO 22.75 22.70 521.43 521.03 522.63 22.70N° DATOS 36.00
COVARIANZA (Cxy) 4.836870833
VARIANZA L^2(x) 4.836069444DESVIACION TIPICA L(x) 2.19910651
B 1.00A -0.06
VARIANZA L^2(y) 5.62DESVIACION TIPICA L(y) 2.37COEFICIENTE DE DETERMINACION 0.860CORRELACION (%) 86.042% PositivaCOEFICIENTE DE CORRELACION 0.860419529
18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.000.00
5.00
10.00
15.00
20.00
25.00
30.00
f(x) = 1.00016571079016 x − 0.0562707490300021R² = 0.860419529274929
Sondaje De Perforación
Column CLinear (Column C)
SL
Perf
orac
ión
DDH
18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.000.00
5.00
10.00
15.00
20.00
25.00
30.00
f(x) = 1.00016571079012 x − 0.0562707490291814R² = 1
Sondaje De Perforación Ajustado
Column GLinear (Column G)
SL
Perf
orac
ion
DDH
18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.000.00
5.00
10.00
15.00
20.00
25.00
30.00
f(x) = 1.00016571079016 x − 0.0562707490300021R² = 0.860419529274929
Sondaje De Perforación
Column CLinear (Column C)
SL
Perf
orac
ión
DDH
18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.000.00
5.00
10.00
15.00
20.00
25.00
30.00
f(x) = 1.00016571079012 x − 0.0562707490291814R² = 1
Sondaje De Perforación Ajustado
Column GLinear (Column G)
SL
Perf
orac
ion
DDH
MODELO POTENCIAL
TABLA DE DATOSN° X Y X' Y' X'Y' ei21 20.44 19.35 1.310 1.287 1.686 1.717 20.400 1.1022 19.48 21.87 1.290 1.340 1.728 1.663 19.452 5.8483 21.75 22.67 1.337 1.355 1.813 1.789 21.693 0.9554 21.64 20.33 1.335 1.308 1.747 1.783 21.584 1.5735 20.32 18.82 1.308 1.275 1.667 1.711 20.281 2.1356 23.25 22.89 1.366 1.360 1.858 1.867 23.172 0.0807 23.02 22.54 1.362 1.353 1.843 1.855 22.946 0.1658 22.70 23.03 1.356 1.362 1.847 1.839 22.630 0.1609 26.02 25.88 1.415 1.413 2.000 2.003 25.902 0.000
10 25.85 26.05 1.412 1.416 2.000 1.995 25.735 0.09911 25.80 25.34 1.412 1.404 1.982 1.993 25.685 0.11912 22.41 21.66 1.350 1.336 1.804 1.824 22.344 0.46813 20.90 21.05 1.320 1.323 1.747 1.743 20.854 0.03814 24.22 25.98 1.384 1.415 1.958 1.916 24.129 3.42715 24.39 24.04 1.387 1.381 1.916 1.924 24.296 0.06616 26.74 26.33 1.427 1.420 2.027 2.037 26.611 0.07917 24.93 24.35 1.397 1.386 1.937 1.951 24.828 0.22918 27.50 27.89 1.439 1.445 2.080 2.072 27.359 0.28219 21.89 22.04 1.340 1.343 1.800 1.796 21.831 0.04420 23.11 23.67 1.364 1.374 1.874 1.860 23.034 0.40421 24.56 25.00 1.390 1.398 1.943 1.933 24.464 0.28822 23.13 22.98 1.364 1.361 1.857 1.861 23.054 0.00523 21.68 21.32 1.336 1.329 1.775 1.785 21.624 0.09224 21.82 22.11 1.339 1.345 1.800 1.793 21.762 0.12125 20.16 19.77 1.304 1.296 1.691 1.702 20.123 0.12526 21.23 21.66 1.327 1.336 1.772 1.761 21.180 0.23127 25.31 26.10 1.403 1.417 1.988 1.969 25.203 0.80528 22.70 20.20 1.356 1.305 1.770 1.839 22.630 5.90529 20.82 21.12 1.318 1.325 1.747 1.738 20.775 0.11930 22.92 21.88 1.360 1.340 1.823 1.850 22.847 0.93531 22.79 22.32 1.358 1.349 1.831 1.843 22.719 0.15932 20.31 20.83 1.308 1.319 1.724 1.710 20.271 0.31233 25.12 26.05 1.400 1.416 1.982 1.960 25.016 1.07034 22.64 22.15 1.355 1.345 1.823 1.836 22.571 0.17735 18.50 19.25 1.267 1.284 1.628 1.606 18.483 0.58836 19.13 18.77 1.282 1.273 1.632 1.643 19.106 0.113Σ 819.18 817.29 48.782 48.734 66.100 66.165 816.595 28.319
PROMEDIO 22.76 22.70 1.355 1.354 1.836 1.838 22.683 0.787N° DATOS 36
COVARIANZA (Cxy) 0.001740 Matriz36 48.782 48.734
VARIANZA L^2(x') 0.001809 48.782 66.165 66.100DESVIACION L(x') 0.042531 Matriz Inversaa' 0.0131018792b 0.989350 29.0297255 -21.4028192a 1.0306E+00 -21.4028192 15.79482435
VARIANZA L^2(y') 0.002DESVIACION L(y') 0.046COEFICIENTE DE CORRELACION 0.919CORRELACION (%) 91.943% "Positiva"COEFICIENTE DE DETERMINACION 0.8453533347ERROR 0.9126437212
X'2 Y*=a*xb
GRAFICA - MODELO POTENCIAL
18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.000.000
5.000
10.000
15.000
20.000
25.000
30.000
f(x) = 1.03062786256488 x^0.989349789999778R² = 1
Modelo Potencial
Column HPower (Column H)
X
Y*
MODELO EXPONENCIALTABLA DE DATOS
N° X Y Y' XY' ei21 20.44 19.35 1.287 26.300 417.794 1.656 20.410 1.1242 19.48 21.87 1.340 26.100 379.470 1.795 19.573 5.2773 21.75 22.67 1.355 29.481 473.063 1.837 21.611 1.1214 21.64 20.33 1.308 28.308 468.290 1.711 21.508 1.3875 20.32 18.82 1.275 25.900 412.902 1.625 20.304 2.2016 23.25 22.89 1.360 31.612 540.563 1.849 23.073 0.0347 23.02 22.54 1.353 31.145 529.920 1.830 22.843 0.0928 22.70 23.03 1.362 30.924 515.290 1.856 22.526 0.2549 26.02 25.88 1.413 36.765 677.040 1.996 26.038 0.025
10 25.85 26.05 1.416 36.599 668.223 2.005 25.845 0.04211 25.80 25.34 1.404 36.218 665.640 1.971 25.789 0.20212 22.41 21.66 1.336 29.932 502.208 1.784 22.243 0.33913 20.90 21.05 1.323 27.656 436.810 1.751 20.824 0.05114 24.22 25.98 1.415 34.263 586.608 2.001 24.071 3.64515 24.39 24.04 1.381 33.681 594.872 1.907 24.250 0.04416 26.74 26.33 1.420 37.983 715.028 2.018 26.869 0.29017 24.93 24.35 1.386 34.565 621.505 1.922 24.828 0.22918 27.50 27.89 1.445 39.750 756.250 2.089 27.775 0.01319 21.89 22.04 1.343 29.403 479.172 1.804 21.743 0.08820 23.11 23.67 1.374 31.758 534.072 1.888 22.932 0.54421 24.56 25.00 1.398 34.333 603.194 1.954 24.431 0.32422 23.13 22.98 1.361 31.488 534.997 1.853 22.953 0.00123 21.68 21.32 1.329 28.808 470.022 1.766 21.545 0.05124 21.82 22.11 1.345 29.339 476.112 1.808 21.677 0.18725 20.16 19.77 1.296 26.127 406.426 1.680 20.162 0.15426 21.23 21.66 1.336 28.356 450.713 1.784 21.126 0.28527 25.31 26.10 1.417 35.855 640.596 2.007 25.243 0.73428 22.70 20.20 1.305 29.631 515.290 1.704 22.526 5.40929 20.82 21.12 1.325 27.580 433.472 1.755 20.751 0.136
X2 Y'2 Y*=a*ebx
30 22.92 21.88 1.340 30.714 525.326 1.796 22.743 0.74531 22.79 22.32 1.349 30.737 519.384 1.819 22.614 0.08732 20.31 20.83 1.319 26.783 412.496 1.739 20.295 0.28733 25.12 26.05 1.416 35.565 631.014 2.005 25.035 1.03034 22.64 22.15 1.345 30.459 512.570 1.810 22.467 0.10035 18.50 19.25 1.284 23.762 342.250 1.650 18.753 0.24736 19.13 18.77 1.273 24.361 365.957 1.622 19.276 0.256Σ 819.18 817.29 48.734 1112.242 18814.539 66.046 816.652 27.035
PROMEDIO 22.76 22.70 1.354 30.896 522.626 1.835 22.685 0.751N° DATOS 36
COVARIANZA (Cxy) 0.0916580068736033 Matriz36 819.180 48.734
VARIANZA L^2(x) 4.974243 819.180 18814.539 1112.242DESVIACION L(x) 2.2303010687221 Matriz Inversa
3.00189889 -0.13070187a' 0.92244753874158 -0.13070187 0.005743875b' 0.01895299642128a 8.36464547653371b' 0.04364088703457VARIANZA L^2(y') 0.00209449157027838DESVIACION L(y') 0.045765615589418COEFICIENTE DE CORRELACION 0.924CORRELACION (%) 92.364%COEFICIENTE DE DETERMINACION 0.8531ERROR 0.89170727000921
GRAFICA - MODELO EXPONENCIAL
18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.000.000
5.000
10.000
15.000
20.000
25.000
30.000
f(x) = 8.36464547653371 exp( 0.0436408870272032 x )R² = 1
Modelo Exponencial
Column H
Expo-nential (Column H)
X
Y*