Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Leidy Fortuna 20200459: N0 Año Real Ventas en Unidades QQ Variacion

    Uploaded by

    Leidy Fortuna

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Leidy Fortuna 20200459: N0 Año Real Ventas en Unidades QQ Variacion

    Uploaded by

    Leidy Fortuna
    15 views2 pages

    Original Title

    proyecciones

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    15 views2 pages

    Leidy Fortuna 20200459: N0 Año Real Ventas en Unidades QQ Variacion

    Uploaded by

    Leidy Fortuna

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    Leidy Fortuna 20200459

    N0 Año real ventas en unidades qq Variacion


    1 2013 5,000.00 0.00
    2 2014 5,800.00 800.00
    3 2015 6,900.00 1100.00
    4 2016 8,400.00 1500.00
    5 2017 10,000.00 1600.00
    6 2018 11,900.00 1900.00
    7 2019 14,000.00 2100.00
    8 2020 16,800.00 2800.00
    11800.00

    N Σxy- Σx Σy ΣY- bΣx


    b= N Σx2- (Σx)2 a= N

    b=(8*424,700)-(36*78,800) a=78,800-(1,669.047*36) y= 2,339.28+ 1,669.047*36


    ((8*204)-1,296) 8 y= 2,339.28+ 60,085.44
    b=3,397,600-2,836,800 a=78,800-60,085.69 y= 62,424.72
    1,632-1,296 8
    b= 560,800 a=18,714.31
    336 8
    b=1,669.047 a= 2,339.28
    X Y
    AÑO VENTAS X*Y X2
    1 2013 5,000.00 5000.00 1
    2 2014 5,800.00 11600.00 4
    3 2015 6,900.00 20700.00 9
    4 2016 8,400.00 33600.00 16
    5 2017 10,000.00 50000.00 25
    6 2018 11,900.00 71400.00 36
    7 2019 14,000.00 98000.00 49
    8 2020 16,800.00 134400.00 64
    36 78,800.00 424700.00 204 sum x2
    1296

    ΣY- bΣx
    N y= a+bx

    5,800.00
    28+ 1,669.047*36 16800+(5800/8-1)
    9.28+ 60,085.44 17628.57
    62,424.72

    You might also like