EJERCICIO 2.2CORRELACIN LINEAL SIMPLE

Resolver el problema con las Herramientas para Anlisis Regresin, y obtengaa. La ecuacin de regresinb. Interpretacin de los parmetrosc. Coeficiente de Correlacin Mltiple. Interpretar

YX1X2X3OrdVentas PromocinCompetencia (Grado rivalidad)Sustitutos (nmero productos)(miles $)(Miles $)179.32.51032200.15.5863163.261294200.17.971651465.28156177.77.6129730.921288291.99510916048410339.49.651611159.65.51171286.3312613237.5661014107.25104151553.5104

SOLUCIONCORRELACION LINEAL MULTIPLE

VENTAS (miles $)PROMOCION (miles $)COMPETENCIA(grado rivalidad)SUSTITUTOS (numero productos)

ORDYX1X2X3179.32.51032200.15.5863163.261294200.17.971651465.28156177.77.6129730.921288291.99510916048410339.49.651611159.65.51171286.3312613237.5661014107.25104151553.5104

Resumen

Estadsticas de la regresinCoeficiente de correlacin mltiple0.9528294926Coeficiente de determinacin R^20.9078840419R^2 ajustado0.8827615078Error tpico27.3840008199Observaciones15ANLISIS DE VARIANZAGrados de libertadSuma de cuadradosPromedio de los cuadradosFValor crtico de FRegresin381298.398823415227099.466274471736.13823512840.0000054548Residuos118248.7185099181749.8835009016Total1489547.1173333333

CoeficientesError tpicoEstadstico tProbabilidadInferior 95%Superior 95%Inferior 95.0%Superior 95.0%Intercepcin172.340048697951.38099631763.354159340.006430047959.2512382921285.428859103759.2512382921285.4288591037X125.94993505374.87744573835.32039441250.000244641615.214749364536.685120742915.214749364536.6851207429X2-13.23840549753.6862390661-3.5913041070.004233937-21.3517629785-5.1250480165-21.3517629785-5.1250480165X3-3.04060817112.3424806584-1.29802914710.2208341674-8.1963733382.1151569959-8.1963733382.1151569959INTERPRETACION

Intercepcion = B0 = 172.340049Variables X1 = B1 = 25.949935Variables X2 = B2 = -13.238406Variables X3 = B3 = -3.040608

ECUACION DE REGRESIONy= 172.34+25.9499X1-13.2384X2-3.0406X3

COEFICIENTE DE DETERMINACIONR^2= 0.9079(90.79%)

Coeficiente de correlacin mltiple0.9528294926