Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    Minimos Cuadrados

    Uploaded by

    dayra22a3

    Copyright:

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

    Minimos Cuadrados

    Uploaded by

    dayra22a3
    7 views6 pages

    Original Title

    Minimos-cuadrados (1)

    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
    7 views6 pages

    Minimos Cuadrados

    Uploaded by

    dayra22a3

    Copyright:

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

    LINEAL Potencial EXPONENCIAL

    X Y LOG X LOG Y X
    0 50 0 1.698970004 0
    3 46 0.477121255 1.662757832 3
    6 43 0.77815125 1.633468456 6
    9 41 0.954242509 1.612783857 9
    12 40 1.079181246 1.602059991 12
    15 38 1.176091259 1.579783597 15
    18 37 1.255272505 1.568201724 18
    21 35 1.322219295 1.544068044 21
    24 36 1.380211242 1.556302501 24
    27 35 1.431363764 1.544068044 27
    30 33 1.477121255 1.51851394 30
    33 33 1.51851394 1.51851394 60 33
    36 32 1.556302501 1.505149978 50
    36
    39 31 1.591064607 1.491361694 39
    42 30 1.62324929 1.477121255 40 42
    45 30 1.653212514 1.477121255 30
    45
    48 29 1.681241237 1.462397998 48
    20

    10
    m= -0.378267973856209 =PENDIENTE(E4:F20)
    b= 45.4901960784314 1.768407765 0
    0 10
    r= -0.959994328782487 -0.96388991
    r^2= 0.921589111294539 0.944647064
    EXPONENCIAL LOGARITMICA
    LOG Y LOG X Y
    1.698970004 0 50
    1.662757832 0.477121255 46
    1.633468456 0.77815125 43
    1.612783857 0.954242509 41
    1.602059991 1.079181246 40
    1.579783597 1.176091259 38
    1.568201724 1.255272505 37
    1.544068044 1.322219295 35
    1.556302501 1.380211242 36
    1.544068044 1.431363764 35
    1.51851394
    Chart Title
    1.477121255 33
    60 1.51851394 1.51851394 33
    50
    1.505149978 1.556302501 32
    1.491361694 1.591064607 31
    40 1.477121255 1.62324929 30
    30
    1.477121255 1.653212514 30
    1.462397998 1.681241237 29
    20

    10
    -0.00411091 -14.3406079
    0 1.651932824 54.34382029
    0 10 20 30 40 50 60
    -0.98539342 -0.98153668
    0.971000201 Column D
    0.969004105
    Gràfi ca lineal
    60

    50

    40

    30
    T °C

    20

    10

    0
    0 2 4 6 8 10 12 14 16 18

    tiempo (MIN)

    Column C Column D
    Gráfi ca Potencial
    1.8

    1.6

    1.4

    1.2

    1
    LOG T °C

    0.8

    0.6

    0.4

    0.2

    0
    0 2 4 6 8 10 12 14 16 18

    LOG tiempo

    Column E Column F
    Gráfi ca Exponencial
    60

    50

    40
    LOG T°C

    30

    20

    10

    0
    0 2 4 6 8 10 12 14 16 18

    Column G tiempo (MIN)


    Column H
    Gráfi ca Logarìtmica
    50

    45

    40

    35

    30

    25
    T °C

    20

    15

    10

    0
    0 2 4 6 8 10 12 14 16 18

    LOG tiempo
    Column I Column J

    You might also like