Administracion

DETERMINACIÓN AUTOMÁTICA DE LA ECUACIÓN DE REGRESIÓN PARA PRONOSTICAR CON DOS VARIABLES INDEPENDIENTES.

x1=a+b2x2+b3x3 |
XI=Variable dependiente |
X2 Y X3= variables independientes |
||
x1= Cantidad de vetas |
x2= Años de experiencia |
x3= Calificación prueba de capacita. |
|
x1 | x2 | x3 | x1x2 | x2^2 | x2x3 | x1x3 | x3^2 | x1^2 |
96 | 1.5 | 5 | 144 | 2.25 | 7.5 |480 | 25 | 9216 |
90 | 2 | 2 | 180 | 4 | 4 | 180 | 4 | 8100 |
95 | 1.5 | 4 | 142.5 | 2.25 | 6 | 380 | 16 | 9025 |
92 | 2.5 | 2.5 | 230 | 6.25 | 6.25 | 230 | 6.25 | 8464 |
95 | 3.3 | 3 | 313.5| 10.89 | 9.9 | 285 | 9 | 9025 |
94 | 2.3 | 3.5 | 216.2 | 5.29 | 8.05 | 329 | 12.25 | 8836 |
94 | 4.2 | 2.5 | 394.8 | 17.64 | 10.5 | 235 | 6.25 | 8836 |
94 | 2.5 | 3 | 235 | 6.25 | 7.5 | 282| 9 | 8836 |
750 | 19.8 | 25.5 | 1856 | 54.82 | 59.7 | 2401 | 87.75 | 70338 |

∑₌X₁ | ∑X₂ | | |
| | | |
SUMATORIA DE ECUACIONES: | |
1= | ∑X₁=na + b₂∑X₂+b₃∑X₃ | |
2= | ∑₍X₁X₂₎₌a∑X₂+b₂∑₍X₂₎^2₊b₃∑X₂X₃ |
3= | ∑₍X₁X₃₎₌a ∑X₃+b₂∑X₂X₃₊b₃∑X₃^2 |
| | | |

| Método de solución |   |   |   | | |
| a | b₂ | b₃ | Resultados | | |
| 8 | 19.8 | 25.5 | 750 | 8 | || 19.8 | 54.82 | 59.7 | 1856 | | |
| 25.5 | 59.7 | 87.75 | 2401 | | |
| 1 | 2.475 | 3.1875 | 93.75 | -19.8 | -25.5 |
| 0 | 5.815 | -3.4125 | -0.25 | 5.815 | |
| 0 | -3.4125 |6.46875 | 10.375 | | |
| 1 | 0 | 4.63993981 | 93.8564058 | | |
| 0 | 1 | -0.58684437 | -0.04299226 | -2.475 | 3.4125 |
| 0 | 0 | 4.46614359 | 10.2282889 | 4.46614359 | |
| 1 | 0 | 0 |83.2300917 | | |
| 0 | 1 | 0 | 1.3009891 | | |
| 0 | 0 | 1 | 2.29018362 | 0.58684437 | -4.63993981 |

a= | 83.2300917 | |
b₂= | 1.3009891 | |
b₃₌ | 2.29018362 | |
| | |calculo de la confianza del procnostico |
S₁‚₂₃=∑x₁^2-a∑x₁-b₂∑x₁x₂-b₃∑x₁x₃ | 0.25807403 |
n | | |
s₁^2 | | 0.80859375 |
| | |
R₁‚₂₃=√₁-ѕ^2₁‚₂₃ | 0.82512786 | 82.51% |
s₁ | |...