Excel PCP

Post on 16-Dec-2015

213 views 0 download

description

Me gusta

Transcript of Excel PCP

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.