Download xls - Expo Nen Cial

Transcript
Page 1: Expo Nen Cial

SEMANA EMPLEADOS PRODUCTOS log y1 20 80 1.903089992 25 95 1.977723613 25 98 1.991226084 28 107 2.029383785 40 120 2.079181256 45 130 2.113943357 45 145 2.1613688 65 178 2.250429 60 160 2.20411998

10 70 207 2.31597035

∑ 423 1320 21.0264264

HALLANDO LOS PARAMETROS PARA LA ECUACION EXPONENCIAL

Reemplazando:

log b= (10)(985.78)-(500)(20.13)/(10)(28400)-(250000)log b= -0.006094117647

antilog log b= -0.006094117647b=0.99

log a= (20.13)/10 - (0.99)(500)/10log a= 2.013-49.5log a= -47.487antilog log a= -47.487a=3.26

AJUSTE:

2.666377

y=abx

y=abX

y=(3.26)(0.99)20=

Page 2: Expo Nen Cial

1.671723

1.671423

2.180848

1.97232

1.783731

1.783731

1.783731

1.613174

1.458926

y=(3.26)(0.99)30=

y=(3.26)(0.99)30=

y=(3.26)(0.99)40=

y=(3.26)(0.99)50=

y=(3.26)(0.99)60=

y=(3.26)(0.99)60=

y=(3.26)(0.99)60=

y=(3.26)(0.99)70=

y=(3.26)(0.99)80=

Page 3: Expo Nen Cial

0

x log y y3044.94398 2.6663774697.09356 1.6717234878.50389 1.6714236080.0338 2.180848

9980.06998 1.9723212366.5686 1.78373114102.9262 1.78373126037.3594 1.78373121159.5518 1.61317433558.4103 1.458926

135905.462 1.671723

HALLANDO LOS PARAMETROS PARA LA ECUACION EXPONENCIAL

(10)(985.78)-(500)(20.13)/(10)(28400)-(250000)