proyecciones

8
AÑOS X Y XY LINEAL 1987 -5 10 -50 100 25 -17.95 1988 -4 20 -80 400 16 7.64 1989 -3 30 -90 900 9 33.23 1990 -2 45 -90 2025 4 58.82 1991 -1 70 -70 4900 1 84.41 1992 0 90 0 8100 0 110 1993 1 125 125 15625 1 135.59 1994 2 150 300 22500 4 161.18 1995 3 180 540 32400 9 186.77 1996 4 220 880 48400 16 212.36 1997 5 270 1350 72900 25 237.95 1998 6 36 263.54 SUMATORIA 0 1210 2815 208250 110 b 25.5909091 a 110 y 263.545455 LINEAL -6 -4 -2 0 2 4 6 0 50 100 150 200 250 300 f(x) = 25.5909090909091 x + 110 R² = 0.958594931349422 Column C Linear (Colum

Upload: hernancruz

Post on 15-Nov-2015

212 views

Category:

Documents


0 download

DESCRIPTION

se identifica los tipos de proyecciones que se le pueden realizar a un proyecto. se aplica en gestión de proyectos con el fin de hacer programas a futuro teniendo en cuenta los datos del presente.

TRANSCRIPT

14 FEBREROEXPONENCIALAOSXYXYYXLINEALEXPONENCIAL1987-510-5010025-17.9515.3794688091988-420-80400167.6421.0317547321989-330-90900933.2328.76137743131990-245-902025458.8239.33180289941991-170-704900184.4153.787087319199209008100011073.55519931125125156251135.59100.588046214719942150300225004161.18137.556318962719953180540324009186.77188.1112279103199642208804840016212.36257.24615439541997527013507290025237.95351.78965490981998636263.54481.0799274819SUMATORIA012102815208250110b25.5909090909LOGARITMICAY POTENCIAL NO SE PUEDEN HACER POR QUE TIENEN DATOS CERO Y DATOS NEGATIVOSa110y 263.5454545455LINEALr9588312251000246500r0.9585949313ok

r3096531626.6738687457r0.9790786135okSe18.5938786495

15 FEBRERO

EXPONENCIALAOSXYXYYXLINEALEXPONENCIALLOGARITMICAPOTENCIAL1987110101001-17.9515.3764120949-51.2147.791519882204040047.6421.027574609719.015672334320.7192675668198933090900933.2328.75566102460.097397087936.71463080720.9583199044518020251658.8239.323985589389.245344668755.09697086630.9789279851199157035049002584.4153.7763969792111.854249287875.4862326294199269054081003611073.5403807302130.327069422297.6320681911199371258751562549135.59100.5680540485145.9456163023121.35408762811994815012002250064161.18137.5289792448159.475017003146.51464820611995918016203240081186.77188.0738402575171.4087941757173.0044427017199610220220048400100212.36257.1950259752182.0839216222200.7340629479199711270297072900121237.95351.7197356943191.7407490399229.6286929248199812144263.54480.9843114493200.5567417565259.6245837067SUMATORIA66121010075208250506

LOGARITMICAb25.5909090909oka-43.5454545455oky 263.5454545455

LINEALr9588312251000246500r0.9585949313ok

r3096531626.6738687457r0.9790786135ok

Se18.5938786495okPOTENCIAL