Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Practica 5

    Uploaded by

    Monse Sias

    Copyright:

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

    Practica 5

    Uploaded by

    Monse Sias
    3 views14 pages

    Original Title

    Practica 5 (2)

    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
    3 views14 pages

    Practica 5

    Uploaded by

    Monse Sias

    Copyright:

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

    N.

    de Observacion Tv (X1) Radio (X2) Ventas (Y) X1Y X2Y


    1 1.3 56 10 13 560
    2 1.4 55 12 16.8 660
    3 1.5 60 11 16.5 660
    4 1.7 65 13 22.1 845
    5 1.75 69 12 21 828
    6 1.3 67 14 18.2 938
    7 1.45 68 16 23.2 1088
    8 0.9 67 12 10.8 804
    9 0.8 97 14 11.2 1358
    10 0.9 66 11 9.9 726
    11 0.8 65 10 8 650
    12 1 60 19 19 1140
    13 1.7 70 8.5 14.45 595
    14 1.8 110 8 14.4 880
    15 1.85 75 9 16.65 675
    16 1.9 80 13 24.7 1040
    17 2 85 16 32 1360
    18 2 90 18 36 1620
    19 1.3 56 20 26 1120
    20 1.4 55 22 30.8 1210
    Totales 28.75 1416 268.5 384.7 18757

    ∑Y = na + b1(∑X1) + b2(∑X2)

    ∑X1Y =∑X1 a +b1(∑X12)+b2(∑X1X2)

    ∑X2Y =∑X2 a +b1(∑X1X2)+b2(∑X22)

    Resolvemos las incognitas usando un sistema de matriz de Gauss-Jordan

    a= 17.385 b1= 0.382 b2= -0.063


    X1X2 X12 X22 Y2
    72.8 1.69 3136 100
    77 1.96 3025 144
    90 2.25 3600 121
    110.5 2.89 4225 169
    120.75 3.0625 4761 144
    87.1 1.69 4489 196
    98.6 2.1025 4624 256
    60.3 0.81 4489 144
    77.6 0.64 9409 196
    59.4 0.81 4356 121
    52 0.64 4225 100
    60 1 3600 361
    119 2.89 4900 72.25
    198 3.24 12100 64
    138.75 3.4225 5625 81
    152 3.61 6400 169
    170 4 7225 256
    180 4 8100 324
    72.8 1.69 3136 400
    77 1.96 3025 484
    2073.6 44.3575 104450 3902.25

    268.5 =20a+b1(28.75)+b2(1416)

    384.7 =28.75a+b1(44.3575)+b2(2073.6)

    18757 =1416a+b1(2073.6)+b2(104450)

    Ecuación de Regresión Lineal Multiple

    Y =17.385+0.832X1-0.063X2
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.22907479
    R Square 0.05247526
    Adjusted R S -0.05899824
    Standard Erro 4.07300218
    Observations 20

    ANOVA
    df SS MS F Significance F
    Regression 2 15.6186054 7.80930272 0.47074203 0.6324406
    Residual 17 282.018895 16.5893467
    Total 19 297.6375

    CoefficientsStandard Error t Stat P-value Lower 95%


    Intercept 17.3854337 4.95450634 3.50901432 0.00269093 6.93233904
    X Variable 1 0.38234701 2.48634838 0.15377853 0.8795951 -4.86338954
    X Variable 2 -0.06370138 0.06679726 -0.95365251 0.35362398 -0.20463128
    ificance F

    Upper 95% Lower 95.0% Upper 95.0%


    27.8385283 6.93233904 27.8385283
    5.62808356 -4.86338954 5.62808356
    0.07722853 -0.20463128 0.07722853
    Y P1 X1 (tamano) x2 (masa) X3(longitud)
    5.67 1 3022 2148 4.3
    10 1 1400 1225 3.25
    4 1 4400 2500 4.78
    5 1 3510 2263 4.58
    6 1 3500 2035 4.5
    6 1 3050 1925 4.3
    12 1 850 1013 2.98
    5.67 1 3050 1983 4.25
    7.33 1 1320 1495 3.83
    6.67 1 2320 1600 3.25
    5.67 1 3180 2070 4.45
    9.67 1 750 1010 3.08
    11.31 1 850 985 2.93
    4.33 1 4020 2343 4.68
    7.33 1 2490 1675 3.93
    7.65 1 2250 1685 4.03
    14.67 1 910 870 2.75
    8 1 2500 1688 3.95
    10.67 1 970 1132 3.13
    9 1 1110 1078 3.28

    1 1 1 1 1 1
    3022 1400 4400 3510 3500 3050
    2148 1225 2500 2263 2035 1925
    4.3 3.25 4.78 4.58 4.5 4.3
    X'X Ecuacion de regr
    20 45452 32723 76.23 Y=19.1019+0.001x1-0.0
    45452 129546384 85602266 187281.2
    32723 85602266 58545507 131025.52 Betha'
    76.23 187281.2 131025.52 298.9739 19.101538189342

    Inversa
    7.894462183 0.001017567 0.001618569 -3.35962422337 5.67
    0.001017567 9.903974E-07 -2.48817E-06 0.00021059088
    0.001618569 -2.48817E-06 9.68607E-06 -0.00309899735 SCR
    -3.359624223 0.000210591 -0.003098997 2.08617601884

    X'Y Betha SCE


    156.64 19.10153819
    299685.24 0.001401457
    230538.6 -0.007648437 Syy
    564.2237 -0.509117192

    Matriz transpuesta X'


    1 1 1 1 1 1
    850 3050 1320 2320 3180 750
    1013 1983 1495 1600 2070 1010
    2.98 4.25 3.83 3.25 4.45 3.08
    Ecuacion de regresion
    Y=19.1019+0.001x1-0.007x2-0.509x3

    Betha'
    0.0014015 -0.00764844 -0.509117192

    Y'
    10 4 5 6 6 12 5.67

    1361.54511 - 1226.80448 R^2 0.89029900747


    = 134.740629524
    R 0.94355657354
    1378.1476 - 1361.54510952
    = 16.602490476
    F0 43.2836683047
    1378.1476 - 1226.80448
    = 151.34312 Fisher 3.23887151745

    1 1 1 1 1 1 1
    850 4020 2490 2250 910 2500 970
    985 2343 1675 1685 870 1688 1132
    2.93 4.68 3.93 4.03 2.75 3.95 3.13
    Y'
    7.33 6.67 5.67 9.67 11.31 4.33 7.33 7.65

    Conclusion
    Se rechaza la hipotesis nula se acepta la
    alternativa

    1
    1110
    1078
    3.28
    14.67 8 10.67 9
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.94355657
    R Square 0.89029901
    Adjusted R S 0.86973007
    Standard Erro 1.01865384
    Observations 20

    ANOVA
    df SS MS F Significance F
    Regression 3 134.74063 44.9135432 43.2836683 6.65189E-08
    Residual 16 16.6024905 1.03765565
    Total 19 151.34312

    CoefficientsStandard Error t Stat P-value Lower 95%


    Intercept 19.1015382 2.86212042 6.67391142 5.34549E-06 13.0341139
    X Variable 1 0.00140146 0.00101375 1.38244709 0.18582852 -0.0007476
    X Variable 2 -0.00764844 0.0031703 -2.41252741 0.02820669 -0.01436917
    X Variable 3 -0.50911719 1.47130294 -0.34603152 0.73382727 -3.62814009
    ificance F

    Upper 95% Lower 95.0% Upper 95.0%


    25.1689624 13.0341139 25.1689624
    0.00355051 -0.0007476 0.00355051
    -0.0009277 -0.01436917 -0.0009277
    2.60990571 -3.62814009 2.60990571

    You might also like