excel pcp

6
Año P.B.I. X Y X1 X2 1 9.1 2.1 1.62 2 10.3 2.2 1.63 3 11.2 2.3 1.64 4 11 2.5 1.65 5 11.9 2.7 1.68 6 13.1 2.8 1.68 7 14.5 2.8 1.69 8 15.9 2.9 1.71 Y X1 X2 X1.X2 X1.Y 9.1 0.021 1.62 0.03402 0.1911 10.3 0.022 1.63 0.03586 0.2266 11.2 0.023 1.64 0.03772 0.2576 11 0.025 1.65 0.04125 0.275 11.9 0.027 1.68 0.04536 0.3213 13.1 0.028 1.68 0.04704 0.3668 14.5 0.028 1.69 0.04732 0.406 15.9 0.029 1.71 0.04959 0.4611 97 0.203 13.3 0.33816 2.5055 A) Parametros de Regresion. COMPR 97 0.203 13.3 2.5055 0.005217 0.33816 Demanda de Au Precio miles (dolares) 97=a(8) + b(0.203) + c(13.30) 2.5055 = a(0.203) + b(0.005217) + c(0.33816) 161.743 = a(13.30) + b(0.33816) + c(22.1184) La empresa minera Santa Rita tien datos historicos de la demananda siguiente cuadro. Hallar la ecuacion modelo : Y = a + bx + cx^2 a) Parametros de regresion. b)Coeficiente de Correlacion 0 2 4 6 8 10 12 14 16 18

Upload: ronald-broncano-obregon

Post on 16-Dec-2015

213 views

Category:

Documents


0 download

DESCRIPTION

Me gusta

TRANSCRIPT

Hoja1AoDemanda de AuP.B.I.Precio miles (dolares)XYX1X219.12.11.62210.32.21.63311.22.31.644112.51.65511.92.71.68613.12.81.68714.52.81.69815.92.91.71YX1X2X1.X2X1.YX2.YX1^2X2^2Y^29.10.0211.620.034020.191114.7420.0004412.624482.8110.30.0221.630.035860.226616.7890.0004842.6569106.0911.20.0231.640.037720.257618.3680.0005292.6896125.44110.0251.650.041250.27518.150.0006252.722512111.90.0271.680.045360.321319.9920.0007292.8224141.6113.10.0281.680.047040.366822.0080.0007842.8224171.6114.50.0281.690.047320.40624.5050.0007842.8561210.2515.90.0291.710.049590.461127.1890.0008412.9241252.81970.20313.30.338162.5055161.7430.00521722.11841211.62A) Parametros de Regresion.

COMPROBANDO97=972.5055=2.5054999997161.743=161.7429999811

970.20313.32.50550.0052170.33816a=161.7430.3381622.1184=-152.9924000015B) COEFICIENTE DE CORRELACION80.20313.30.2030.0052170.3381613.30.3381622.1184C.Correlacion=0.9602116829

D1=-0.0000229489Y =12.125T=0.00000015Y^2=147.015625

89713.332.72661986220.2032.50550.3381635.495b=13.3161.74322.1184=-407.5999999901T

D2=-0.00006114T=0.00000015

80.203970.2030.0052172.5055c=13.30.33816161.743=105.5399999999T

D3=0.000015831T=0.00000015

97=a(8) + b(0.203) + c(13.30)2.5055 = a(0.203) + b(0.005217) + c(0.33816)161.743 = a(13.30) + b(0.33816) + c(22.1184)La empresa minera Santa Rita tienes los datos historicos de la demananda en el siguiente cuadro.