promedio movil

Upload: hector-hugo-garcia

Post on 05-Mar-2016

10 views

Category:

Documents


0 download

DESCRIPTION

hoja de calculo promedio movil

TRANSCRIPT

  • Hora de entrada de

    Semana Da Hora de Entrada

    1I 504II 500 1977.00 494.25III 498 1949.00 487.25IV 475 1937.00 484.25

    2I 476 1917.00 479.25II 488 1924.00 481.00III 478 1924.00 481.00IV 482 1901.00 475.25

    3I 476 1918.00 479.50II 465 1933.00 483.25III 495 1932.00 483.00IV 497 1945.00 486.25

    4I 475 1912.00 478.00II 478 1898.00 474.50III 462IV 483

    *Estimacin Evaluada en minutos

    Total Mvil de 4

    Trimestres

    Promedio Mvil de las 4 semanas

  • Hora de entrada de

    Semana Da

    1

    I490.75 102.70 103% II485.75 102.93 103% III481.75 103.37 103% IV480.13 98.93 99% V481.00 98.96 99%

    2

    I478.13 102.07 102% II477.38 100.13 100% III481.38 100.13 100% IV483.13 98.53 99% V484.63 95.95 96%

    3

    I482.13 102.67 103% II476.25 104.36 104% III

    IVV

    4

    IIIIIIIVV

    Promedio mvil

    centrado de 4 semanas

    Porcentaje del valor

    real respecto al promedio

    mvil

  • 504500 2453 490.6 489 103.07498 2437 487.4 485.2 103.05475 2415 483 481.4 103.45476 2399 479.8 479.9 98.98488 2400 480 478.9 99.39478 2389 477.8 478.5 101.99482 2396 479.2 481.1 99.36476 2415 483 482.3 99.94465 2408 481.6 481.8 98.80495 2410 482 481.7 96.53497 2407 481.4 480.2 103.08475 2395 479 477.7 104.04478 2382 476.4 478 99.37462 2398 479.6 481.2 99.33483 2414 482.8 483.9 95.47484 2425 485491494473

    Hora de Entrada

    Total Mvil de 4

    semanas

    Promedio Mvil de las 4 semanas

    Promedio mvil

    centrado de 4 semanas

    Porcentaje del valor

    real respecto al promedio

    mvil

  • 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20440

    450

    460

    470

    480

    490

    500

    510

    RealMovil

  • 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20440

    450

    460

    470

    480

    490

    500

    510

    RealMovil

  • I II III IV I II III IV I II III IV I II III IV440

    450

    460

    470

    480

    490

    500

    510

    Hora de entrada

    Dias

  • I II III IV I II III IV I II III IV I II III IV440

    450

    460

    470

    480

    490

    500

    510

    Hora de entrada

    Dias

  • I II III IV I II III IV I II III IV I II III IV440

    450

    460

    470

    480

    490

    500

    510

    Hora de entrada

    Dias

    Sheet1Sheet2