Proyecto mermelada (regresiones calculos)
55
Tiempo (min) Brix pH Temperatura 1 24 6.6 24 2 24 6.5 26 3 24 6.4 28 4 26 6.3 30 5 26 6.2 32 6 27 6.1 34 7 27 6 36 8 29 5.9 38 9 30 5.8 40 10 31 5.7 42 11 33 5.6 44 12 34 5.5 46 13 35 5.4 48 14 36 5.3 50 15 36 5.2 52 16 36 5.1 54 17 38 5 56 18 38 4.9 58 19 40 4.8 60 20 41 4.7 62 21 41 4.6 64 22 44 4.5 66 23 47 4.4 68 24 51 4.3 70 25 51 4.2 72 26 51 4.1 74 27 51 4 76 28 51 3.9 78 29 51 3.8 80 30 52 3.7 82 31 52 3.6 84 32 52 3.5 85 33 53 3.4 85 34 54 3.3 85 35 54 3.3 85 36 55 3.3 85 37 55 3.3 85 38 56 3.3 85 39 57 3.3 85 40 57 3.3 85 41 58 3.3 85 42 59 3.3 85 43 59 3.3 85 44 60 3.3 85 45 60 3.3 85 46 60 3.3 85 47 60 3.3 85 48 60 3.3 85 49 60 3.3 85 50 61 3.3 85
-
Upload
luiggifel -
Category
Technology
-
view
609 -
download
3
Transcript of Proyecto mermelada (regresiones calculos)
Tiempo (min)Brix pH Temperatura1 24 6.6 242 24 6.5 263 24 6.4 284 26 6.3 305 26 6.2 326 27 6.1 347 27 6 368 29 5.9 389 30 5.8 40
10 31 5.7 4211 33 5.6 4412 34 5.5 4613 35 5.4 4814 36 5.3 5015 36 5.2 5216 36 5.1 5417 38 5 5618 38 4.9 5819 40 4.8 6020 41 4.7 6221 41 4.6 6422 44 4.5 6623 47 4.4 6824 51 4.3 7025 51 4.2 7226 51 4.1 7427 51 4 7628 51 3.9 7829 51 3.8 8030 52 3.7 8231 52 3.6 8432 52 3.5 8533 53 3.4 8534 54 3.3 8535 54 3.3 8536 55 3.3 8537 55 3.3 8538 56 3.3 8539 57 3.3 8540 57 3.3 8541 58 3.3 8542 59 3.3 8543 59 3.3 8544 60 3.3 8545 60 3.3 8546 60 3.3 8547 60 3.3 8548 60 3.3 8549 60 3.3 8550 61 3.3 85
51 61 3.3 8552 61 3.3 8553 62 3.3 8554 62 3.3 8555 62 3.3 8556 63 3.3 8557 63 3.3 8558 63 3.3 8559 63 3.3 8560 63 3.3 8561 63 3.3 8562 63 3.3 8563 63 3.3 8564 63 3.3 8565 63 3.3 8566 63 3.3 8567 63 3.3 8568 63 3.3 8569 63 3.3 8570 63 3.3 8571 63 3.3 8572 63 3.3 8573 63 3.3 8574 63 3.2 8575 64 3.2 8576 64 3.2 8577 64 3.2 8578 64 3.2 8579 64 3.2 8580 64 3.2 8581 64 3.2 8582 64 3.2 8583 64 3.2 8584 64 3.2 8585 64 3.2 8586 64 3.2 8587 64 3.2 8588 64 3.2 8589 64 3.2 8590 64 3.2 8591 64 3.2 8592 64 3.2 8593 64 3.2 8594 64 3.2 8595 64 3.2 8596 64 3.2 8597 64 3.2 8598 64 3.2 8599 64 3.2 85
100 64 3.2 85101 64 3.2 85
102 64 3.2 85103 64 3.2 85104 64 3.2 85105 64 3.2 85106 64 3.2 85107 64 3.2 85108 64 3.2 85109 65 3.1 85110 65 3.1 85111 65 3.1 85112 65 3.1 85113 65 3.1 85114 65 3.1 85115 65 3.1 85116 65 3.1 85117 65 3.1 85118 65 3.1 85119 65 3.1 85120 65 3.1 85
x yTiempo (min) Brix X*Y X^2 Y^2
1 24 24 1 5762 24 48 4 5763 24 72 9 5764 26 104 16 6765 26 130 25 6766 27 162 36 7297 27 189 49 7298 29 232 64 8419 30 270 81 900
10 31 310 100 96111 33 363 121 108912 34 408 144 115613 35 455 169 122514 36 504 196 129615 36 540 225 129616 36 576 256 129617 38 646 289 144418 38 684 324 144419 40 760 361 160020 41 820 400 168121 41 861 441 168122 44 968 484 193623 47 1081 529 220924 51 1224 576 260125 51 1275 625 260126 51 1326 676 260127 51 1377 729 260128 51 1428 784 260129 51 1479 841 260130 52 1560 900 270431 52 1612 961 270432 52 1664 1024 270433 53 1749 1089 280934 54 1836 1156 291635 54 1890 1225 291636 55 1980 1296 302537 55 2035 1369 302538 56 2128 1444 313639 57 2223 1521 324940 57 2280 1600 324941 58 2378 1681 336442 59 2478 1764 348143 59 2537 1849 348144 60 2640 1936 360045 60 2700 2025 360046 60 2760 2116 360047 60 2820 2209 360048 60 2880 2304 360049 60 2940 2401 360050 61 3050 2500 372151 61 3111 2601 372152 61 3172 2704 3721
53 62 3286 2809 384454 62 3348 2916 384455 62 3410 3025 384456 63 3528 3136 396957 63 3591 3249 396958 63 3654 3364 396959 63 3717 3481 396960 63 3780 3600 396961 63 3843 3721 396962 63 3906 3844 396963 63 3969 3969 396964 63 4032 4096 396965 63 4095 4225 396966 63 4158 4356 396967 63 4221 4489 396968 63 4284 4624 396969 63 4347 4761 396970 63 4410 4900 396971 63 4473 5041 396972 63 4536 5184 396973 63 4599 5329 396974 63 4662 5476 396975 64 4800 5625 409676 64 4864 5776 409677 64 4928 5929 409678 64 4992 6084 409679 64 5056 6241 409680 64 5120 6400 409681 64 5184 6561 409682 64 5248 6724 409683 64 5312 6889 409684 64 5376 7056 409685 64 5440 7225 409686 64 5504 7396 409687 64 5568 7569 409688 64 5632 7744 409689 64 5696 7921 409690 64 5760 8100 409691 64 5824 8281 409692 64 5888 8464 409693 64 5952 8649 409694 64 6016 8836 409695 64 6080 9025 409696 64 6144 9216 409697 64 6208 9409 409698 64 6272 9604 409699 64 6336 9801 4096
100 64 6400 10000 4096101 64 6464 10201 4096102 64 6528 10404 4096103 64 6592 10609 4096104 64 6656 10816 4096105 64 6720 11025 4096106 64 6784 11236 4096107 64 6848 11449 4096
108 64 6912 11664 4096109 65 7085 11881 4225110 65 7150 12100 4225111 65 7215 12321 4225112 65 7280 12544 4225113 65 7345 12769 4225114 65 7410 12996 4225115 65 7475 13225 4225116 65 7540 13456 4225117 65 7605 13689 4225118 65 7670 13924 4225119 65 7735 14161 4225120 65 7800 14400 4225
totales 7260 6728 449002 583220 394632prom.x 60.5prom.y 56.067
60.556.067
72606728
449002583220394632
38.44
0.29
60.556.067
72606728
449002583220394632
x y Ycorregido e e^21 24 38.73 -14.73 216.932 24 39.02 -15.02 225.63 24 39.31 -15.31 234.444 26 39.6 -13.6 185.045 26 39.89 -13.89 193.056 27 40.19 -13.19 173.867 27 40.48 -13.48 181.638 29 40.77 -11.77 138.59 30 41.06 -11.06 122.32 0 20 40 60 80 100 120 140
01020304050607080
yYcorregido
n
Xib
n
Yib ∑∑ −= 10
∑∑∑∑∑
=
=
=
=
==
=
394632
583220
449002.
6728
7260
067.56
5.60
2
2
Y
X
YX
Y
X
Y
X
43.38120
72602913.0
120
6728
0
0
=
−=
b
b
291.0120
7260583220
120
6728*7260449002
*
2
22
=
−=
−=
∑∑
∑ ∑∑
b
b
n
yxi
n
yiXiyixi
b
∑∑∑∑∑
=
=
=
=
==
=
394632
583220
449002.
6728
7260
067.56
5.60
2
2
Y
X
YX
Y
X
Y
X
10 31 41.35 -10.35 107.1511 33 41.64 -8.64 74.6912 34 41.93 -7.93 62.9513 35 42.23 -7.23 52.2114 36 42.52 -6.52 42.4715 36 42.81 -6.81 46.3516 36 43.1 -7.1 50.417 38 43.39 -5.39 29.0618 38 43.68 -5.68 32.2919 40 43.97 -3.97 15.7920 41 44.27 -3.27 10.6621 41 44.56 -3.56 12.6522 44 44.85 -0.85 0.7223 47 45.14 1.86 3.4624 51 45.43 5.57 31.0225 51 45.72 5.28 27.8626 51 46.01 4.99 24.8627 51 46.3 4.7 22.0428 51 46.6 4.4 19.3929 51 46.89 4.11 16.9130 52 47.18 4.82 23.2431 52 47.47 4.53 20.5232 52 47.76 4.24 17.9633 53 48.05 4.95 24.4734 54 48.34 5.66 31.9835 54 48.64 5.36 28.7736 55 48.93 6.07 36.8837 55 49.22 5.78 33.4238 56 49.51 6.49 42.1239 57 49.8 7.2 51.8240 57 50.09 6.91 47.7141 58 50.38 7.62 5842 59 50.68 8.32 69.2943 59 50.97 8.03 64.5344 60 51.26 8.74 76.4145 60 51.55 8.45 71.446 60 51.84 8.16 66.5647 60 52.13 7.87 61.8948 60 52.42 7.58 57.3949 60 52.72 7.28 53.0650 61 53.01 7.99 63.8951 61 53.3 7.7 59.3152 61 53.59 7.41 54.9153 62 53.88 8.12 65.9154 62 54.17 7.83 61.2755 62 54.46 7.54 56.7956 63 54.76 8.24 67.9757 63 55.05 7.95 63.2558 63 55.34 7.66 58.759 63 55.63 7.37 54.3260 63 55.92 7.08 50.1161 63 56.21 6.79 46.0762 63 56.5 6.5 42.263 63 56.8 6.2 38.564 63 57.09 5.91 34.97
0 20 40 60 80 100 120 1400
1020304050607080
yYcorregido
65 63 57.38 5.62 31.6166 63 57.67 5.33 28.4267 63 57.96 5.04 25.3968 63 58.25 4.75 22.5469 63 58.54 4.46 19.8670 63 58.83 4.17 17.3571 63 59.13 3.87 15.0172 63 59.42 3.58 12.8373 63 59.71 3.29 10.8374 63 60 3 975 64 60.29 3.71 13.7576 64 60.58 3.42 11.6777 64 60.87 3.13 9.7778 64 61.17 2.83 8.0379 64 61.46 2.54 6.4680 64 61.75 2.25 5.0781 64 62.04 1.96 3.8482 64 62.33 1.67 2.7883 64 62.62 1.38 1.984 64 62.91 1.09 1.1885 64 63.21 0.79 0.6386 64 63.5 0.5 0.2587 64 63.79 0.21 0.0488 64 64.08 -0.08 0.0189 64 64.37 -0.37 0.1490 64 64.66 -0.66 0.4491 64 64.95 -0.95 0.9192 64 65.25 -1.25 1.5593 64 65.54 -1.54 2.3694 64 65.83 -1.83 3.3495 64 66.12 -2.12 4.4996 64 66.41 -2.41 5.8197 64 66.7 -2.7 7.398 64 66.99 -2.99 8.9699 64 67.29 -3.29 10.79
100 64 67.58 -3.58 12.79101 64 67.87 -3.87 14.96102 64 68.16 -4.16 17.3103 64 68.45 -4.45 19.81104 64 68.74 -4.74 22.49105 64 69.03 -5.03 25.34106 64 69.33 -5.33 28.36107 64 69.62 -5.62 31.55108 64 69.91 -5.91 34.9109 65 70.2 -5.2 27.03110 65 70.49 -5.49 30.15111 65 70.78 -5.78 33.43112 65 71.07 -6.07 36.89113 65 71.36 -6.36 40.51114 65 71.66 -6.66 44.31115 65 71.95 -6.95 48.27116 65 72.24 -7.24 52.4117 65 72.53 -7.53 56.71118 65 72.82 -7.82 61.18119 65 73.11 -8.11 65.83
120 65 73.4 -8.4 70.64total 5189.11
varianza
44
3.- el error estandar de la regresion
Error estadar 6.63
4.- errores estandar de los estimadores
1.48
0
5.- coeficiente de determinacion
0.84
17415.47
5189.11
0.7
12226.36
a 38.437
∑∑∑∑∑
=
=
=
=
==
=
394632
583220
449002.
6728
7260
067.56
5.60
2
2
Y
X
YX
Y
X
Y
X
b 0.291Sa 1.218Sb 0.015
interpretacion
31.55
11.-usando la prueba tb
19.94
12.- encontrar el valor del intervalos de confianza
Ls 38.59Li 38.44
γ=
±
n
SataIC
67.69......exp...var..
6967.0
...............
.........º......exp..
8378.0
..var..
..inf......º437.38......
29.0437.38ˆ
ˆ
29.0......
....º....min.....
......
.......
º
291.0º
ˆ
2
unenlicadaestaiabilidaddeporcebtajeel
R
ceroasercanomuyestaqueporaltamuy
estiempoelyBrixloentraexistequerelacionlalicanos
r
xianlela
sobreluenciahaynoBrixquedicenos
xy
bxay
deinvrementoun
sufreBrixlospasequeutocadaporqueb
origenelporpasa
rectalaqueindicanosa
tiempox
BrixY
XBrix
bxay
=
=
+=+=
=
===
=+=
Resumen
Estadísticas de la regresiónCoeficiente de correlación múltiple0.84Coeficiente de determinación R^20.7R^2 ajustado 0.7Error típico 6.63Observaciones 120
ANÁLISIS DE VARIANZAGrados de libertadSuma de cuadradosPromedio de los cuadradosF Valor crítico de F
Regresión 1 12226.36 12226.36 278.03 0Residuos 118 5189.11 43.98Total 119 17415.47
Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95%Intercepción 38.44 1.22 31.55 0 36.02 40.85Variable X 1 0.29 0.02 16.67 0 0.26 0.33
Análisis de los residuales Resultados de datos de probabilidad
ObservaciónPronóstico para Y ResiduosResiduos estándares Percentil Y1 38.73 -14.73 -2.23 0.42 242 39.02 -15.02 -2.27 1.25 243 39.31 -15.31 -2.32 2.08 244 39.6 -13.6 -2.06 2.92 265 39.89 -13.89 -2.1 3.75 266 40.19 -13.19 -2 4.58 277 40.48 -13.48 -2.04 5.42 278 40.77 -11.77 -1.78 6.25 299 41.06 -11.06 -1.67 7.08 30
10 41.35 -10.35 -1.57 7.92 3111 41.64 -8.64 -1.31 8.75 3312 41.93 -7.93 -1.2 9.58 3413 42.23 -7.23 -1.09 10.42 3514 42.52 -6.52 -0.99 11.25 3615 42.81 -6.81 -1.03 12.08 3616 43.1 -7.1 -1.08 12.92 3617 43.39 -5.39 -0.82 13.75 3818 43.68 -5.68 -0.86 14.58 3819 43.97 -3.97 -0.6 15.42 4020 44.27 -3.27 -0.49 16.25 4121 44.56 -3.56 -0.54 17.08 4122 44.85 -0.85 -0.13 17.92 4423 45.14 1.86 0.28 18.75 4724 45.43 5.57 0.84 19.58 5125 45.72 5.28 0.8 20.42 5126 46.01 4.99 0.76 21.25 5127 46.3 4.7 0.71 22.08 5128 46.6 4.4 0.67 22.92 5129 46.89 4.11 0.62 23.75 51
30 47.18 4.82 0.73 24.58 5231 47.47 4.53 0.69 25.42 5232 47.76 4.24 0.64 26.25 5233 48.05 4.95 0.75 27.08 5334 48.34 5.66 0.86 27.92 5435 48.64 5.36 0.81 28.75 5436 48.93 6.07 0.92 29.58 5537 49.22 5.78 0.88 30.42 5538 49.51 6.49 0.98 31.25 5639 49.8 7.2 1.09 32.08 5740 50.09 6.91 1.05 32.92 5741 50.38 7.62 1.15 33.75 5842 50.68 8.32 1.26 34.58 5943 50.97 8.03 1.22 35.42 5944 51.26 8.74 1.32 36.25 6045 51.55 8.45 1.28 37.08 6046 51.84 8.16 1.24 37.92 6047 52.13 7.87 1.19 38.75 6048 52.42 7.58 1.15 39.58 6049 52.72 7.28 1.1 40.42 6050 53.01 7.99 1.21 41.25 6151 53.3 7.7 1.17 42.08 6152 53.59 7.41 1.12 42.92 6153 53.88 8.12 1.23 43.75 6254 54.17 7.83 1.19 44.58 6255 54.46 7.54 1.14 45.42 6256 54.76 8.24 1.25 46.25 6357 55.05 7.95 1.2 47.08 6358 55.34 7.66 1.16 47.92 6359 55.63 7.37 1.12 48.75 6360 55.92 7.08 1.07 49.58 6361 56.21 6.79 1.03 50.42 6362 56.5 6.5 0.98 51.25 6363 56.8 6.2 0.94 52.08 6364 57.09 5.91 0.9 52.92 6365 57.38 5.62 0.85 53.75 6366 57.67 5.33 0.81 54.58 6367 57.96 5.04 0.76 55.42 6368 58.25 4.75 0.72 56.25 6369 58.54 4.46 0.67 57.08 6370 58.83 4.17 0.63 57.92 6371 59.13 3.87 0.59 58.75 6372 59.42 3.58 0.54 59.58 6373 59.71 3.29 0.5 60.42 6374 60 3 0.45 61.25 6375 60.29 3.71 0.56 62.08 6476 60.58 3.42 0.52 62.92 6477 60.87 3.13 0.47 63.75 6478 61.17 2.83 0.43 64.58 6479 61.46 2.54 0.39 65.42 6480 61.75 2.25 0.34 66.25 6481 62.04 1.96 0.3 67.08 6482 62.33 1.67 0.25 67.92 6483 62.62 1.38 0.21 68.75 6484 62.91 1.09 0.16 69.58 64
85 63.21 0.79 0.12 70.42 6486 63.5 0.5 0.08 71.25 6487 63.79 0.21 0.03 72.08 6488 64.08 -0.08 -0.01 72.92 6489 64.37 -0.37 -0.06 73.75 6490 64.66 -0.66 -0.1 74.58 6491 64.95 -0.95 -0.14 75.42 6492 65.25 -1.25 -0.19 76.25 6493 65.54 -1.54 -0.23 77.08 6494 65.83 -1.83 -0.28 77.92 6495 66.12 -2.12 -0.32 78.75 6496 66.41 -2.41 -0.37 79.58 6497 66.7 -2.7 -0.41 80.42 6498 66.99 -2.99 -0.45 81.25 6499 67.29 -3.29 -0.5 82.08 64
100 67.58 -3.58 -0.54 82.92 64101 67.87 -3.87 -0.59 83.75 64102 68.16 -4.16 -0.63 84.58 64103 68.45 -4.45 -0.67 85.42 64104 68.74 -4.74 -0.72 86.25 64105 69.03 -5.03 -0.76 87.08 64106 69.33 -5.33 -0.81 87.92 64107 69.62 -5.62 -0.85 88.75 64108 69.91 -5.91 -0.89 89.58 64109 70.2 -5.2 -0.79 90.42 65110 70.49 -5.49 -0.83 91.25 65111 70.78 -5.78 -0.88 92.08 65112 71.07 -6.07 -0.92 92.92 65113 71.36 -6.36 -0.96 93.75 65114 71.66 -6.66 -1.01 94.58 65115 71.95 -6.95 -1.05 95.42 65116 72.24 -7.24 -1.1 96.25 65117 72.53 -7.53 -1.14 97.08 65118 72.82 -7.82 -1.18 97.92 65119 73.11 -8.11 -1.23 98.75 65120 73.4 -8.4 -1.27 99.58 65
0 20 40 60 80 100 120 1400
1020304050607080
yYcorregido
0 20 40 60 80 100 120 1400
1020304050607080
yYcorregido
60.556.0772606728
449002583220394632
interpretacion
67.69......exp...var..
6967.0
...............
.........º......exp..
8378.0
..var..
..inf......º437.38......
29.0437.38ˆ
ˆ
29.0......
....º....min.....
......
.......
º
291.0º
ˆ
2
unenlicadaestaiabilidaddeporcebtajeel
R
ceroasercanomuyestaqueporaltamuy
estiempoelyBrixloentraexistequerelacionlalicanos
r
xianlela
sobreluenciahaynoBrixquedicenos
xy
bxay
deinvrementoun
sufreBrixlospasequeutocadaporqueb
origenelporpasa
rectalaqueindicanosa
tiempox
BrixY
XBrix
bxay
=
=
+=+=
=
===
=+=
Inferior 95,0%Superior 95,0%36.02 40.85
0.26 0.33
Resultados de datos de probabilidad
0 20 40 60 80 100 120 140-20
-10
0
10
20
Variable X 1 Gráfico de los residuales
Variable X 1
Resi
duos
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 91 96 101
106
111
116
0
20
40
60
80
Variable X 1 Curva de regresión ajustada
Column CColumn J
Variable X 1Y
0.42
4.58
8.75
12.9
217
.08
21.2
525
.42
29.5
833
.75
37.9
242
.08
46.2
550
.42
54.5
858
.75
62.9
267
.08
71.2
575
.42
79.5
883
.75
87.9
292
.08
96.2
5
020406080
Gráfico de probabilidad normal
Column O
Muestra percentil
Y
140
Variable X 1 Gráfico de los residuales
Resi
duos
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 91 96 101
106
111
116
Variable X 1 Curva de regresión ajustada
Column CColumn J
Y
0.42
4.58
8.75
12.9
217
.08
21.2
525
.42
29.5
833
.75
37.9
242
.08
46.2
550
.42
54.5
858
.75
62.9
267
.08
71.2
575
.42
79.5
883
.75
87.9
292
.08
96.2
5Gráfico de probabilidad normal
Column O
Muestra percentil
Y
y X1 X2Brix Tiempo (min) Temperatura Y^2 x1^2 X2^2
24 1 24 576 1 57624 2 26 576 4 67624 3 28 576 9 78426 4 30 676 16 90026 5 32 676 25 102427 6 34 729 36 115627 7 36 729 49 129629 8 38 841 64 144430 9 40 900 81 160031 10 42 961 100 176433 11 44 1089 121 193634 12 46 1156 144 211635 13 48 1225 169 230436 14 50 1296 196 250036 15 52 1296 225 270436 16 54 1296 256 291638 17 56 1444 289 313638 18 58 1444 324 336440 19 60 1600 361 360041 20 62 1681 400 384441 21 64 1681 441 409644 22 66 1936 484 435647 23 68 2209 529 462451 24 70 2601 576 490051 25 72 2601 625 518451 26 74 2601 676 547651 27 76 2601 729 577651 28 78 2601 784 608451 29 80 2601 841 640052 30 82 2704 900 672452 31 84 2704 961 705652 32 85 2704 1024 722553 33 85 2809 1089 722554 34 85 2916 1156 722554 35 85 2916 1225 722555 36 85 3025 1296 722555 37 85 3025 1369 722556 38 85 3136 1444 722557 39 85 3249 1521 722557 40 85 3249 1600 722558 41 85 3364 1681 722559 42 85 3481 1764 722559 43 85 3481 1849 722560 44 85 3600 1936 722560 45 85 3600 2025 722560 46 85 3600 2116 722560 47 85 3600 2209 722560 48 85 3600 2304 722560 49 85 3600 2401 722561 50 85 3721 2500 722561 51 85 3721 2601 722561 52 85 3721 2704 722562 53 85 3844 2809 7225
62 54 85 3844 2916 722562 55 85 3844 3025 722563 56 85 3969 3136 722563 57 85 3969 3249 722563 58 85 3969 3364 722563 59 85 3969 3481 722563 60 85 3969 3600 722563 61 85 3969 3721 722563 62 85 3969 3844 722563 63 85 3969 3969 722563 64 85 3969 4096 722563 65 85 3969 4225 722563 66 85 3969 4356 722563 67 85 3969 4489 722563 68 85 3969 4624 722563 69 85 3969 4761 722563 70 85 3969 4900 722563 71 85 3969 5041 722563 72 85 3969 5184 722563 73 85 3969 5329 722563 74 85 3969 5476 722564 75 85 4096 5625 722564 76 85 4096 5776 722564 77 85 4096 5929 722564 78 85 4096 6084 722564 79 85 4096 6241 722564 80 85 4096 6400 722564 81 85 4096 6561 722564 82 85 4096 6724 722564 83 85 4096 6889 722564 84 85 4096 7056 722564 85 85 4096 7225 722564 86 85 4096 7396 722564 87 85 4096 7569 722564 88 85 4096 7744 722564 89 85 4096 7921 722564 90 85 4096 8100 722564 91 85 4096 8281 722564 92 85 4096 8464 722564 93 85 4096 8649 722564 94 85 4096 8836 722564 95 85 4096 9025 722564 96 85 4096 9216 722564 97 85 4096 9409 722564 98 85 4096 9604 722564 99 85 4096 9801 722564 100 85 4096 10000 722564 101 85 4096 10201 722564 102 85 4096 10404 722564 103 85 4096 10609 722564 104 85 4096 10816 722564 105 85 4096 11025 722564 106 85 4096 11236 722564 107 85 4096 11449 722564 108 85 4096 11664 7225
65 109 85 4225 11881 722565 110 85 4225 12100 722565 111 85 4225 12321 722565 112 85 4225 12544 722565 113 85 4225 12769 722565 114 85 4225 12996 722565 115 85 4225 13225 722565 116 85 4225 13456 722565 117 85 4225 13689 722565 118 85 4225 13924 722565 119 85 4225 14161 722565 120 85 4225 14400 7225
totales 6728 7260 9239 394632 583220 743341Pro.x1 60.5Pro X2 76.992 a 7.51Pro Y 56.067 b1 0.11
7260 b2 0.5492396728
394632583220743341449002540705606684
60.576.99256.067
143990
47724.5
32014.99
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
( )
143990120
7260583220
1
11
2
11
2
2111
∑∑
=
=
=
XX
XX
XX
S
S
n
XXS
( ) ( )
447724.120
9239*7260606684
2*1
21
21
2121
∑∑∑
=
=
=
XX
XX
XX
S
S
n
XXXXS
( )
9917.32014120
9239743341
2
22
2
22
2
2222
∑∑
=
=
=
XX
XX
XX
S
S
n
XXS
2211 XbXbYa −−=
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
41958
22705.07
17415.47
( )
9917.32014120
9239743341
2
22
2
22
2
2222
∑∑
=
=
=
XX
XX
XX
S
S
n
XXS
( ) ( )
( ) ( )
44120
6728*7260449002
*1
1
1
11
∑∑∑
=
=
=
YX
YX
YX
S
S
n
YXYXS
( ) ( )
7222705.06120
)6728*9239(540705
*2
2
2
22
∑∑∑
=
=
=
YX
YX
YX
S
S
n
YXYXS
( )
4667.17415120
)6728(394632
2
2
2
=
−=
−= ∑∑
Syy
Syy
n
YYSYY
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
( )( )[ ]
( ) ( )
( )[ ]
0,8713999.32014*143990
66468456
120
9239743341*
120
7260583220
120
9239*7260606684
21
21
2221
2
222
2
121
2121
21
=
−=
−−
−
=
−
−
−
=
−
−
−
−
∑ ∑∑ ∑
∑ ∑∑
r
r
r
n
XX
n
XX
n
XXXX
r
X1*Y X2*Y X1*X2 Ycorre (Y-Ymedia)^2(Ycorr-Ymedia)^2 (y-Ycorre)^224 576 24 20.66 1028.27 1253.940 11.1848 624 52 21.85 1028.27 1170.546 4.6172 672 84 23.05 1028.27 1090.022 0.9
104 780 120 24.25 904 1012.366 3.07130 832 160 25.45 904 937.580 0.31162 918 204 26.64 844.87 865.664 0.13189 972 252 27.84 844.87 796.616 0.71232 1102 304 29.04 732.6 730.438 0270 1200 360 30.24 679.47 667.130 0.06310 1302 420 31.44 628.34 606.690 0.19363 1452 484 32.63 532.07 549.120 0.13408 1564 552 33.83 486.94 494.419 0.03455 1680 624 35.03 443.8 442.588 0504 1800 700 36.23 402.67 393.626 0.05540 1872 780 37.42 402.67 347.533 2.03576 1944 864 38.62 402.67 304.309 6.88646 2128 952 39.82 326.4 263.955 3.31684 2204 1044 41.02 326.4 226.470 9.11760 2400 1140 42.22 258.14 191.854 4.91820 2542 1240 43.41 227 160.108 5.82861 2624 1344 44.61 227 131.231 13.04968 2904 1452 45.81 145.6 105.223 3.27
1081 3196 1564 47.01 82.2 82.085 01224 3570 1680 48.2 25.67 61.816 7.821275 3672 1800 49.4 25.67 44.416 2.551326 3774 1924 50.6 25.67 29.885 0.161377 3876 2052 51.8 25.67 18.224 0.641428 3978 2184 53 25.67 9.432 3.981479 4080 2320 54.19 25.67 3.510 10.21560 4264 2460 55.39 16.54 0.457 11.51612 4368 2604 56.59 16.54 0.273 21.061664 4420 2720 57.24 16.54 1.385 27.491749 4505 2805 57.35 9.4 1.659 18.961836 4590 2890 57.47 4.27 1.958 12.011890 4590 2975 57.58 4.27 2.282 12.81980 4675 3060 57.69 1.14 2.631 7.232035 4675 3145 57.8 1.14 3.005 7.842128 4760 3230 57.91 0 3.403 3.652223 4845 3315 58.02 0.87 3.826 1.052280 4845 3400 58.13 0.87 4.274 1.292378 4930 3485 58.25 3.74 4.747 0.062478 5015 3570 58.36 8.6 5.245 0.412537 5015 3655 58.47 8.6 5.767 0.282640 5100 3740 58.58 15.47 6.315 2.022700 5100 3825 58.69 15.47 6.887 1.712760 5100 3910 58.8 15.47 7.483 1.432820 5100 3995 58.91 15.47 8.105 1.182880 5100 4080 59.02 15.47 8.752 0.952940 5100 4165 59.14 15.47 9.423 0.753050 5185 4250 59.25 24.34 10.119 3.073111 5185 4335 59.36 24.34 10.840 2.693172 5185 4420 59.47 24.34 11.585 2.343286 5270 4505 59.58 35.2 12.356 5.85
3348 5270 4590 59.69 35.2 13.151 5.323410 5270 4675 59.8 35.2 13.971 4.823528 5355 4760 59.92 48.07 14.816 9.513591 5355 4845 60.03 48.07 15.685 8.843654 5355 4930 60.14 48.07 16.580 8.193717 5355 5015 60.25 48.07 17.499 7.563780 5355 5100 60.36 48.07 18.443 6.963843 5355 5185 60.47 48.07 19.412 6.393906 5355 5270 60.58 48.07 20.405 5.843969 5355 5355 60.7 48.07 21.424 5.314032 5355 5440 60.81 48.07 22.467 4.814095 5355 5525 60.92 48.07 23.535 4.334158 5355 5610 61.03 48.07 24.628 3.884221 5355 5695 61.14 48.07 25.745 3.464284 5355 5780 61.25 48.07 26.888 3.064347 5355 5865 61.36 48.07 28.055 2.684410 5355 5950 61.47 48.07 29.247 2.334473 5355 6035 61.59 48.07 30.464 24536 5355 6120 61.7 48.07 31.705 1.74599 5355 6205 61.81 48.07 32.972 1.424662 5355 6290 61.92 48.07 34.263 1.174800 5440 6375 62.03 62.94 35.579 3.884864 5440 6460 62.14 62.94 36.920 3.454928 5440 6545 62.25 62.94 38.285 3.054992 5440 6630 62.37 62.94 39.676 2.675056 5440 6715 62.48 62.94 41.091 2.325120 5440 6800 62.59 62.94 42.531 1.995184 5440 6885 62.7 62.94 43.996 1.695248 5440 6970 62.81 62.94 45.485 1.415312 5440 7055 62.92 62.94 47.000 1.165376 5440 7140 63.03 62.94 48.539 0.935440 5440 7225 63.14 62.94 50.103 0.735504 5440 7310 63.26 62.94 51.692 0.555568 5440 7395 63.37 62.94 53.305 0.45632 5440 7480 63.48 62.94 54.943 0.275696 5440 7565 63.59 62.94 56.607 0.175760 5440 7650 63.7 62.94 58.295 0.095824 5440 7735 63.81 62.94 60.007 0.035888 5440 7820 63.92 62.94 61.745 0.015952 5440 7905 64.04 62.94 63.507 06016 5440 7990 64.15 62.94 65.295 0.026080 5440 8075 64.26 62.94 67.106 0.076144 5440 8160 64.37 62.94 68.943 0.146208 5440 8245 64.48 62.94 70.805 0.236272 5440 8330 64.59 62.94 72.691 0.356336 5440 8415 64.7 62.94 74.602 0.56400 5440 8500 64.82 62.94 76.538 0.666464 5440 8585 64.93 62.94 78.499 0.866528 5440 8670 65.04 62.94 80.485 1.086592 5440 8755 65.15 62.94 82.495 1.326656 5440 8840 65.26 62.94 84.530 1.596720 5440 8925 65.37 62.94 86.590 1.886784 5440 9010 65.48 62.94 88.675 2.26848 5440 9095 65.59 62.94 90.784 2.546912 5440 9180 65.71 62.94 92.919 2.91
7085 5525 9265 65.82 79.8 95.078 0.677150 5525 9350 65.93 79.8 97.262 0.867215 5525 9435 66.04 79.8 99.471 1.087280 5525 9520 66.15 79.8 101.704 1.337345 5525 9605 66.26 79.8 103.962 1.597410 5525 9690 66.37 79.8 106.246 1.897475 5525 9775 66.49 79.8 108.553 2.217540 5525 9860 66.6 79.8 110.886 2.557605 5525 9945 66.71 79.8 113.244 2.927670 5525 10030 66.82 79.8 115.626 3.317735 5525 10115 66.93 79.8 118.033 3.737800 5525 10200 67.04 79.8 120.465 4.17
449002 540705 606684 6728 17415.47 17005.72 409.75
726092396728
394632583220743341449002540705606684
60.576.99256.067
7260
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
92396728
394632583220743341449002540705606684
60.576.99256.067
726092396728
394632583220743341 a 7.51449002 b1 0.11540705 b2 0.54606684 R^2 0.98
60.5 r 0.8776.99256.067
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
067.56
992.762
5.60
6066842*1
540705*2
449002*1
7433412
5832201
394632
6728
92392
72601
∑∑∑∑∑∑∑∑∑
2
2
2
=
=
=
=
=
=
=
=
=
=
=
=
Y
X
X
XX
YX
YX
X
X
y
y
X
x
.. .. .. .e x p. .. .6 1.9 7... .
. .. .. .. . .. .
6 1.9 7... .. .e x p.. .. .. .. .. .. . º. . .v a r..
9 7 6 1.0
. .. .. .. ... .. .. .
. .. .. .. .. º......e x p..
8 7 1 3 9.0
. .v a r. . .. .. .. . .. .. .. .. .v a r. .
. .. .. ..
º
2 9 1.0º
ˆ
2
2
1
2211
e c u a c io ne s tap o rl i c a d ae s tae lso lo
e n c o n t r a d ae c ia c io ne s taad e b id ae s
u ne nl i c a d ae s tat i e m p oe lyB r i xd eia b i l i d a dd ep o r c e n ta jee l
R
c e r oase r c a n om u ye s taq u ep o ra l tam u y
e st i e m p oe lyB r i xloe n t r ae x i s t eq u er e la c io nlal i c an o s
r
ia b led o sla se n t r ee x i s teq u elaid i c aia n le sla s
r e c talaq u ein d ic an o sa
ate m p e r a tu rx
t i e m p ox
B r ixY
XB r ix
xbxbay
=
=
====
=++=
Ycorre^2 Resumen426.66477.57Estadísticas de la regresión531.36 Coeficiente de correlación múltiple0.99588.01 Coeficiente de determinación R^20.98647.54 R^2 ajustado 0.98709.93 Error típico 0.87775.19 Observaciones 120843.32914.33 ANÁLISIS DE VARIANZA
988.2 Grados de libertadSuma de cuadradosPromedio de los cuadradosF Valor crítico de F1064.94 Regresión 2 17005.72 8502.86 2427.91 01144.55 Residuos 117 409.75 3.51227.02 Total 119 17415.471312.371400.59 Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95%1491.67 Intercepción 7.51 0.91 8.29 0 5.71 9.31585.63 Variable X 1 0.11 0.01 16.06 0 0.1 0.131682.46 Variable X 2 0.54 0.01 36.94 0 0.51 0.571782.151884.711990.152098.45 Análisis de los residuales Resultados de datos de probabilidad2209.622323.66 ObservaciónPronóstico para Y ResiduosResiduos estándares Percentil Y2440.57 1 20.66 3.34 1.8 0.42 242560.35 2 21.85 2.15 1.16 1.25 24
2683 3 23.05 0.95 0.51 2.08 242808.52 4 24.25 1.75 0.94 2.92 262936.91 5 25.45 0.55 0.3 3.75 263068.16 6 26.64 0.36 0.19 4.58 273202.29 7 27.84 -0.84 -0.45 5.42 27
3276.8 8 29.04 -0.04 -0.02 6.25 293289.56 9 30.24 -0.24 -0.13 7.08 303302.34 10 31.44 -0.44 -0.23 7.92 313315.15 11 32.63 0.37 0.2 8.75 333327.99 12 33.83 0.17 0.09 9.58 343340.85 13 35.03 -0.03 -0.02 10.42 353353.73 14 36.23 -0.23 -0.12 11.25 363366.64 15 37.42 -1.42 -0.77 12.08 363379.58 16 38.62 -2.62 -1.41 12.92 363392.54 17 39.82 -1.82 -0.98 13.75 383405.52 18 41.02 -3.02 -1.63 14.58 383418.53 19 42.22 -2.22 -1.19 15.42 403431.56 20 43.41 -2.41 -1.3 16.25 413444.62 21 44.61 -3.61 -1.95 17.08 413457.71 22 45.81 -1.81 -0.97 17.92 443470.81 23 47.01 -0.01 0 18.75 473483.95 24 48.2 2.8 1.51 19.58 51
3497.1 25 49.4 1.6 0.86 20.42 513510.29 26 50.6 0.4 0.22 21.25 513523.49 27 51.8 -0.8 -0.43 22.08 513536.73 28 53 -2 -1.08 22.92 513549.98 29 54.19 -3.19 -1.72 23.75 51
3563.26 30 55.39 -3.39 -1.83 24.58 523576.57 31 56.59 -4.59 -2.47 25.42 52
3589.9 32 57.24 -5.24 -2.83 26.25 523603.26 33 57.35 -4.35 -2.35 27.08 533616.64 34 57.47 -3.47 -1.87 27.92 543630.04 35 57.58 -3.58 -1.93 28.75 543643.47 36 57.69 -2.69 -1.45 29.58 553656.93 37 57.8 -2.8 -1.51 30.42 553670.41 38 57.91 -1.91 -1.03 31.25 563683.91 39 58.02 -1.02 -0.55 32.08 573697.44 40 58.13 -1.13 -0.61 32.92 57
3711 41 58.25 -0.25 -0.13 33.75 583724.58 42 58.36 0.64 0.35 34.58 593738.18 43 58.47 0.53 0.29 35.42 593751.81 44 58.58 1.42 0.77 36.25 603765.46 45 58.69 1.31 0.71 37.08 603779.14 46 58.8 1.2 0.65 37.92 603792.84 47 58.91 1.09 0.59 38.75 603806.57 48 59.02 0.98 0.53 39.58 603820.32 49 59.14 0.86 0.47 40.42 60
3834.1 50 59.25 1.75 0.94 41.25 613847.9 51 59.36 1.64 0.88 42.08 61
3861.73 52 59.47 1.53 0.82 42.92 613875.58 53 59.58 2.42 1.3 43.75 623889.46 54 59.69 2.31 1.24 44.58 623903.36 55 59.8 2.2 1.18 45.42 623917.29 56 59.92 3.08 1.66 46.25 633931.24 57 60.03 2.97 1.6 47.08 633945.21 58 60.14 2.86 1.54 47.92 633959.21 59 60.25 2.75 1.48 48.75 633973.24 60 60.36 2.64 1.42 49.58 633987.29 61 60.47 2.53 1.36 50.42 634001.37 62 60.58 2.42 1.3 51.25 634015.47 63 60.7 2.3 1.24 52.08 634029.59 64 60.81 2.19 1.18 52.92 634043.74 65 60.92 2.08 1.12 53.75 634057.91 66 61.03 1.97 1.06 54.58 634072.11 67 61.14 1.86 1 55.42 634086.34 68 61.25 1.75 0.94 56.25 634100.59 69 61.36 1.64 0.88 57.08 634114.86 70 61.47 1.53 0.82 57.92 634129.16 71 61.59 1.41 0.76 58.75 634143.48 72 61.7 1.3 0.7 59.58 634157.83 73 61.81 1.19 0.64 60.42 63
4172.2 74 61.92 1.08 0.58 61.25 634186.6 75 62.03 1.97 1.06 62.08 64
4201.02 76 62.14 1.86 1 62.92 644215.47 77 62.25 1.75 0.94 63.75 644229.94 78 62.37 1.63 0.88 64.58 644244.44 79 62.48 1.52 0.82 65.42 644258.96 80 62.59 1.41 0.76 66.25 64
4273.5 81 62.7 1.3 0.7 67.08 644288.08 82 62.81 1.19 0.64 67.92 644302.67 83 62.92 1.08 0.58 68.75 644317.29 84 63.03 0.97 0.52 69.58 64
4331.94 85 63.14 0.86 0.46 70.42 644346.61 86 63.26 0.74 0.4 71.25 64
4361.3 87 63.37 0.63 0.34 72.08 644376.02 88 63.48 0.52 0.28 72.92 644390.77 89 63.59 0.41 0.22 73.75 644405.54 90 63.7 0.3 0.16 74.58 644420.33 91 63.81 0.19 0.1 75.42 644435.15 92 63.92 0.08 0.04 76.25 644449.99 93 64.04 -0.04 -0.02 77.08 644464.86 94 64.15 -0.15 -0.08 77.92 644479.76 95 64.26 -0.26 -0.14 78.75 644494.67 96 64.37 -0.37 -0.2 79.58 64
394222.25 97 64.48 -0.48 -0.26 80.42 6498 64.59 -0.59 -0.32 81.25 6499 64.7 -0.7 -0.38 82.08 64
100 64.82 -0.82 -0.44 82.92 64101 64.93 -0.93 -0.5 83.75 64102 65.04 -1.04 -0.56 84.58 64103 65.15 -1.15 -0.62 85.42 64104 65.26 -1.26 -0.68 86.25 64105 65.37 -1.37 -0.74 87.08 64106 65.48 -1.48 -0.8 87.92 64107 65.59 -1.59 -0.86 88.75 64108 65.71 -1.71 -0.92 89.58 64109 65.82 -0.82 -0.44 90.42 65110 65.93 -0.93 -0.5 91.25 65111 66.04 -1.04 -0.56 92.08 65112 66.15 -1.15 -0.62 92.92 65113 66.26 -1.26 -0.68 93.75 65114 66.37 -1.37 -0.74 94.58 65115 66.49 -1.49 -0.8 95.42 65116 66.6 -1.6 -0.86 96.25 65117 66.71 -1.71 -0.92 97.08 65118 66.82 -1.82 -0.98 97.92 65119 66.93 -1.93 -1.04 98.75 65120 67.04 -2.04 -1.1 99.58 65
.. .. .. .e x p. .. .6 1.9 7... .
. .. .. .. . .. .
6 1.9 7... .. .e x p.. .. .. .. .. .. . º. . .v a r..
9 7 6 1.0
. .. .. .. ... .. .. .
. .. .. .. .. º......e x p..
8 7 1 3 9.0
. .v a r. . .. .. .. . .. .. .. .. .v a r. .
. .. .. ..
º
2 9 1.0º
ˆ
2
2
1
2211
e c u a c io ne s tap o rl i c a d ae s tae lso lo
e n c o n t r a d ae c ia c io ne s taad e b id ae s
u ne nl i c a d ae s tat i e m p oe lyB r i xd eia b i l i d a dd ep o r c e n ta jee l
R
c e r oase r c a n om u ye s taq u ep o ra l tam u y
e st i e m p oe lyB r i xloe n t r ae x i s t eq u er e la c io nlal i c an o s
r
ia b led o sla se n t r ee x i s teq u elaid i c aia n le sla s
r e c talaq u ein d ic an o sa
ate m p e r a tu rx
t i e m p ox
B r ixY
XB r ix
xbxbay
=
=
====
=++=
Inferior 95,0%Superior 95,0%5.71 9.3
0.1 0.130.51 0.57
Resultados de datos de probabilidad
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 91 96 101
106
111
116
0
20
40
60
80
Variable X 1 Curva de regresión ajustada
Column BColumn Q
Variable X 1Y
2430
3642
4854
6066
7278
8485
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
020406080
Variable X 2 Curva de regresión ajustada
Column BColumn Q
Variable X 2
Y
0.42
4.58
8.75
12.9
217
.08
21.2
525
.42
29.5
833
.75
37.9
242
.08
46.2
550
.42
54.5
858
.75
62.9
267
.08
71.2
575
.42
79.5
883
.75
87.9
292
.08
96.2
5
020406080
Gráfico de probabilidad normal
Column V
Muestra percentil
Y
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 91 96 101
106
111
116
0
20
40
60
80
Variable X 1 Curva de regresión ajustada
Column BColumn Q
Variable X 1Y
0.42
4.58
8.75
12.9
217
.08
21.2
525
.42
29.5
833
.75
37.9
242
.08
46.2
550
.42
54.5
858
.75
62.9
267
.08
71.2
575
.42
79.5
883
.75
87.9
292
.08
96.2
5
020406080
Gráfico de probabilidad normal
Column V
Muestra percentil
Y
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 91 96 101
106
111
116
Variable X 1 Curva de regresión ajustada
Column BColumn Q
Y
8585
8585
8585
8585
8585
8585
8585
Variable X 2 Curva de regresión ajustada
Column BColumn Q
Y
0.42
4.58
8.75
12.9
217
.08
21.2
525
.42
29.5
833
.75
37.9
242
.08
46.2
550
.42
54.5
858
.75
62.9
267
.08
71.2
575
.42
79.5
883
.75
87.9
292
.08
96.2
5
Gráfico de probabilidad normal
Column V
Muestra percentil
Y
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 91 96 101
106
111
116
Variable X 1 Curva de regresión ajustada
Column BColumn Q
Y
2430
3642
4854
6066
7278
8485
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
8585
020406080
Variable X 2 Curva de regresión ajustada
Column BColumn QVariable X 2
Y
0.42
4.58
8.75
12.9
217
.08
21.2
525
.42
29.5
833
.75
37.9
242
.08
46.2
550
.42
54.5
858
.75
62.9
267
.08
71.2
575
.42
79.5
883
.75
87.9
292
.08
96.2
5
Column V
Y
8585
8585
8585
85
Variable X 2 Curva de regresión ajustada
Column BColumn Q
Y
