A B C AB AC BC ABC Y1 Y2
-1 -1 -1 1 1 1 -1 5.747 0.05
-1 -1 -1 1 1 1 -1 5.6875 0.054
1 -1 -1 -1 -1 1 1 5.697 0.05
1 -1 -1 -1 -1 1 1 5.694 0.05
-1 1 -1 -1 1 -1 1 6.3905 0.07
-1 1 -1 -1 1 -1 1 6.347 0.05
1 1 -1 1 -1 -1 -1 6.3005 0.072
1 1 -1 1 -1 -1 -1 6.45 0.045
-1 -1 1 1 -1 -1 1 6.2065 0.054
-1 -1 1 1 -1 -1 1 6.425 0.073
1 -1 1 -1 1 -1 -1 5.691 0.054
1 -1 1 -1 1 -1 -1 5.625 0.051
-1 1 1 -1 -1 1 -1 6.394 0.052
-1 1 1 -1 -1 1 -1 6.4095 0.062
1 1 1 1 1 1 1 5.6016 0.053
1 1 1 1 1 1 1 5.6565 0.048
AB A B C AC BC ABC Y1
1 -1 -1 -1 1 1 -1 5.747
1 -1 -1 -1 1 1 -1 5.6875
-1 1 -1 -1 -1 1 1 5.697
-1 1 -1 -1 -1 1 1 5.694
-1 -1 1 -1 1 -1 1 6.3905
-1 -1 1 -1 1 -1 1 6.347
1 1 1 -1 -1 -1 -1 6.3005
1 1 1 -1 -1 -1 -1 6.45
1 -1 -1 1 -1 -1 1 6.2065
1 -1 -1 1 -1 -1 1 6.425
-1 1 -1 1 1 -1 -1 5.691
-1 1 -1 1 1 -1 -1 5.625
-1 -1 1 1 -1 1 -1 6.394
-1 -1 1 1 -1 1 -1 6.4095
1 1 1 1 1 1 1 5.6016
1 1 1 1 1 1 1 5.6565
Resumen
Estadísticas de la regresión
Coeficiente d 0.98936704
Coeficiente d 0.97884714
R^2 ajustado 0.96033839
Error típico 0.07208687
Observacione 16
ANÁLISIS DE VARIANZA
Grados de libertadSuma de cuadrados Promedio de los cuadrados F Valor crítico de F
Regresión 7 1.9237475075 0.2748210725 52.8856371 4.50092E-06
Residuos 8 0.0415721299999999 0.00519651624999999
Total 15 1.9653196375
Coeficientes Error típico Estadístico t Probabilidad Inferior 95%
Intercepción 6.0201625 0.0180217165005168 334.050449624339 7.2212E-18 5.97860435
A -0.1807125 0.0180217165005168 -10.0274854503908 8.31598E-06 -0.22227065
B 0.1735375 0.0180217165005168 9.62935467301485 1.12451E-05 0.13197935
C -0.019025 0.0180217165005168 -1.05567080690979 0.32195347 -0.06058315
AB -0.0108375 0.0180217165005168 -0.60135781182049 0.56424901 -0.05239565
AC -0.1769 0.0180217165005168 -9.81593512443319 9.74939E-06 -0.21845815
BC -0.159275 0.0180217165005168 -8.83794837164554 2.11754E-05 -0.20083315
ABC -0.0179 0.0180217165005168 -0.99324612056164 0.34967836 -0.05945815
Análisis de los residuales
Observación Pronóstico Y1 Residuos
1 5.71725 0.0297499999999999
2 5.71725 -0.0297499999999999
3 5.6955 0.0015000000000009
4 5.6955 -0.0014999999999992
5 6.36875 0.0217499999999999
6 6.36875 -0.0217499999999999
7 6.37525 -0.074749999999999
8 6.37525 0.0747500000000008
9 6.31575 -0.109249999999999
10 6.31575 0.10925
11 5.658 0.0330000000000004
12 5.658 -0.0329999999999995
13 6.40175 -0.0077499999999997
14 6.40175 0.0077500000000006
15 5.62905 -0.0274499999999991
16 5.62905 0.0274500000000009
or crítico de F
Superior 95%Inferior 95,0%
Superior 95,0%
6.06172065 5.97860435 6.06172065
-0.13915435 -0.22227065 -0.13915435
0.21509565 0.13197935 0.21509565
0.02253315 -0.06058315 0.02253315
0.03072065 -0.05239565 0.03072065
-0.13534185 -0.21845815 -0.13534185
-0.11771685 -0.20083315 -0.11771685
0.02365815 -0.05945815 0.02365815
Resumen
Estadísticas de la regresión
Coeficiente de correla 0.98888369
Coeficiente de determ 0.97789095
R^2 ajustado 0.96315158
Error típico 0.06948329
Observaciones 16
ANÁLISIS DE VARIANZA
Grados de libertad
Suma de cuadradosPromedio de los cuadrados F Valor crítico de F
Regresión 6 1.92186829 0.320311380833334 66.3455166 6.12295E-07
Residuos 9 0.04345135 0.00482792805555555
Total 15 1.96531964
Coeficientes Error típico Estadístico t Probabilidad Inferior 95%
Intercepción 6.0201625 0.01737082 346.567481721437 7.05744E-20 5.98086697
A -0.1807125 0.01737082 -10.4032201855988 2.57252E-06 -0.22000803
B 0.1735375 0.01737082 9.99017125521677 3.60764E-06 0.13424197
C -0.019025 0.01737082 -1.09522730320823 0.30185911 -0.05832053
AC -0.1769 0.01737082 -10.1837429664934 3.07441E-06 -0.21619553
BC -0.159275 0.01737082 -9.16911057653043 7.33012E-06 -0.19857053
ABC -0.0179 0.01737082 -1.03046353363613 0.32968831 -0.05719553
TCRT 2.26215716279821
Análisis de los residuales
A
Observación Pronóstico Y1 Residuos AC
1 5.7280875 0.0189125 B
2 5.7280875 -0.0405875 BC
3 5.6846625 0.0123375 C
4 5.6846625 0.0093375 ABC
5 6.3579125 0.0325875
6 6.3579125 -0.0109125
7 6.3860875 -0.0855875
8 6.3860875 0.0639125
9 6.3265875 -0.1200875
10 6.3265875 0.0984125
11 5.6471625 0.0438375
12 5.6471625 -0.0221625
13 6.3909125 0.0030875
14 6.3909125 0.0185875
15 5.6398875 -0.0382875
16 5.6398875 0.0166125
or crítico de F
Superior 95%Inferior 95,0%
Superior 95,0%
6.05945803 5.98086697 6.05945803
-0.14141697 -0.22000803 -0.14141697
0.21283303 0.13424197 0.21283303
0.02027053 -0.05832053 0.02027053
-0.13760447 -0.21619553 -0.13760447
-0.11997947 -0.19857053 -0.11997947
0.02139553 -0.05719553 0.02139553 minimo o maximo --- coeficiente
Maximización
Coeficientes Estadístico t abst nivel
-0.1807125 -10.4032202 10.4032202 -1 Los que me importan
-0.1769 -10.183743 10.183743 -1
0.1735375 9.99017126 9.99017126 1
-0.159275 -9.16911058 9.16911058 -1
-0.019025 -1.0952273 1.0952273 1 Por la formulación de la multiplicación
-0.0179 -1.03046353 1.03046353 -1
peso de 6 ----solver
Factores Y1predicho
A 0.06855923 5.99999398
B -0.06583716
C 0.00721776
A B C AB AC BC ABC Y2
-1 -1 -1 1 1 1 -1 0.05
-1 -1 -1 1 1 1 -1 0.054
1 -1 -1 -1 -1 1 1 0.05
1 -1 -1 -1 -1 1 1 0.05
-1 1 -1 -1 1 -1 1 0.07
-1 1 -1 -1 1 -1 1 0.05
1 1 -1 1 -1 -1 -1 0.072
1 1 -1 1 -1 -1 -1 0.045
-1 -1 1 1 -1 -1 1 0.054
-1 -1 1 1 -1 -1 1 0.073
1 -1 1 -1 1 -1 -1 0.054
1 -1 1 -1 1 -1 -1 0.051
-1 1 1 -1 -1 1 -1 0.052
-1 1 1 -1 -1 1 -1 0.062
1 1 1 1 1 1 1 0.053
1 1 1 1 1 1 1 0.048
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.98936704
R Square 0.97884714
Adjusted R S 0.96033839
Standard Erro 0.07208687
Observations 16
ANOVA
df SS MS F Significance F
Regression 7 1.92374751 0.27482107 52.8856371 4.50092E-06
Residual 8 0.04157213 0.00519652
Total 15 1.96531964
CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Lower 95,0%
Intercept 6.0201625 0.01802172 334.05045 7.2212E-18 5.97860435 6.06172065 5.97860435
A -0.1807125 0.01802172 -10.0274855 8.31598E-06 -0.22227065 -0.13915435 -0.22227065
B 0.1735375 0.01802172 9.62935467 1.12451E-05 0.13197935 0.21509565 0.13197935
C -0.019025 0.01802172 -1.05567081 0.32195347 -0.06058315 0.02253315 -0.06058315
AB -0.0108375 0.01802172 -0.60135781 0.56424901 -0.05239565 0.03072065 -0.05239565
AC -0.1769 0.01802172 -9.81593512 9.74939E-06 -0.21845815 -0.13534185 -0.21845815
BC -0.159275 0.01802172 -8.83794837 2.11754E-05 -0.20083315 -0.11771685 -0.20083315
ABC -0.0179 0.01802172 -0.99324612 0.34967836 -0.05945815 0.02365815 -0.05945815
Upper 95,0%
6.06172065
-0.13915435
0.21509565
0.02253315
0.03072065
-0.13534185
-0.11771685
0.02365815
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.98888369
R Square 0.97789095
Adjusted R S 0.96315158
Standard Erro 0.06948329
Observations 16
ANOVA
df SS MS F Significance F
Regression 6 1.92186829 0.32031138 66.3455166 6.12295E-07
Residual 9 0.04345135 0.00482793
Total 15 1.96531964
CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Lower 95,0%
Intercept 6.0201625 0.01737082 346.567482 7.05744E-20 5.98086697 6.05945803 5.98086697
A -0.1807125 0.01737082 -10.4032202 2.57252E-06 -0.22000803 -0.14141697 -0.22000803
B 0.1735375 0.01737082 9.99017126 3.60764E-06 0.13424197 0.21283303 0.13424197
C -0.019025 0.01737082 -1.0952273 0.30185911 -0.05832053 0.02027053 -0.05832053
AC -0.1769 0.01737082 -10.183743 3.07441E-06 -0.21619553 -0.13760447 -0.21619553
BC -0.159275 0.01737082 -9.16911058 7.33012E-06 -0.19857053 -0.11997947 -0.19857053
ABC -0.0179 0.01737082 -1.03046353 0.32968831 -0.05719553 0.02139553 -0.05719553
Upper 95,0%
6.05945803
-0.14141697
0.21283303
0.02027053
-0.13760447
-0.11997947
0.02139553
A B C AC BC ABC Y1
-1 -1 -1 1 1 -1 5.747
-1 -1 -1 1 1 -1 5.6875
1 -1 -1 -1 1 1 5.697
1 -1 -1 -1 1 1 5.694
-1 1 -1 1 -1 1 6.3905
-1 1 -1 1 -1 1 6.347
1 1 -1 -1 -1 -1 6.3005
1 1 -1 -1 -1 -1 6.45
-1 -1 1 -1 -1 1 6.2065
-1 -1 1 -1 -1 1 6.425
1 -1 1 1 -1 -1 5.691
1 -1 1 1 -1 -1 5.625
-1 1 1 -1 1 -1 6.394
-1 1 1 -1 1 -1 6.4095
1 1 1 1 1 1 5.6016
1 1 1 1 1 1 5.6565
