curs 6+7

download curs 6+7

of 28

Transcript of curs 6+7

  • 7/25/2019 curs 6+7

    1/28

    25 23 30 25

    10 11 14 12

    Timp medi

    25

    23

    3025

    20

    33

    18

    21

    22

    30

    26

    26

    27

    29

    20

    17.6

    264

    Timpmediu

    Nr.poli

    e

  • 7/25/2019 curs 6+7

    2/28

    Ipoteza de homoscedasticitate a erorilor

    Residuals^2 Timpul mediu(xi) xi^2

    4 25 625

    0.009699265 23 529

    0.55683253 30 900

    0 25 625

    1.571984045 20 4002.57943067 33 1089

    0.713512971 18 324

    0.038797062 21 441

    0.124096074 22 484

    0.064408287 30 900

    2.400152089 26 676

    6.006212695 26 676

    1.206668962 27 729

    0.038797062 29 841

    3.049256772 20 400

  • 7/25/2019 curs 6+7

    3/28

    Ipoteza de autocorelare a erorilor

    RESID!" #T$T

    epsi epsi%1

    Observation Predicted Nr. polie Residuals Residuals(

    1 12 %2

    2 10.9015151515 0.0984848485 %2

    3 14.7462121212 %0.7462121212 0.098485

    4 12 0 %0.746212

    5 9.2537878788 %1.2537878788 0

    6 16.3939393939 1.6060606061 %1.253788

    7 8.1553030303 0.8446969697 1.606061

    8 9.803030303 0.196969697 0.844697

    9 10.3522727273 %0.3522727273 0.19697

    10 14.7462121212 0.2537878788 %0.352273

    11 12.5492424242 %1.5492424242 0.253788

    12 12.5492424242 2.4507575758 %1.549242

    13 13.0984848485 %1.0984848485 2.450758

    14 14.196969697 %0.196969697 %1.09848515 9.2537878788 1.7462121212 %0.19697

    7 8 9 10 11 12

    -3

    -2

    -1

    0

    1

    2

    3

    Predicted numar d

    R

    e

    s

    i

    d

    u

    a

    l

    s

  • 7/25/2019 curs 6+7

    4/28

    sum

    &'el(epsi epsi(%1)) %0.4134332982

    Ipoteza de normalitate a erorilor

    S**!R+ #T$T

    Regression Statistics

    *ul,iple R 0.883620846

    R S-uae 0.780785799

    !dus,ed R 0.763923168

    S,a/dad E 1.311483261

    #sea,i'/ 15

    !#! df SS MS F

    Reessi'/ 1 79.6401515152 79.6401515152 46.30273

    Residual 13 22.3598484848 1.719988345

    T',al 14 102

    Coefficients Standard Error t Stat P-value

    I/,e&ep, %1.731060606 2.0461202297 %0.8460209625 0.412843

    Timp mediu 0.549242424 0.080716215 6.8046107476 1.3E%005

    2.144787

    RESID!" #T$T

    -3 -2 -1

    t

  • 7/25/2019 curs 6+7

    5/28

    Observation edicted Nr. pol Residuals Standard Residuals

    1 12 %2 %1.5825578166 2.812852

    2 10.90151515 0.0984848485 0.0779289834 2.812852

    3 14.74621212 %0.7462121212 %0.5904619126 2.812852

    4 12 0 0 2.812852

    5 9.253787879 %1.2537878788 %0.9920959039 2.812852

    6 16.39393939 1.6060606061 1.270841883 2.812852

    7 8.15530303 0.8446969697 0.668390896 2.812852

    8 9.803030303 0.196969697 0.1558579668 2.812852

    9 10.35227273 %0.3522727273 %0.2787459791 2.812852

    10 14.74621212 0.2537878788 0.2008169957 2.812852

    11 12.54924242 %1.5492424242 %1.2258828541 2.812852

    12 12.54924242 2.4507575758 1.939232779 2.812852

    13 13.09848485 %1.0984848485 %0.8692078917 2.812852

    14 14.1969697 %0.196969697 %0.1558579668 2.812852

    15 9.253787879 1.7462121212 1.3817408209 2.812852

    16 18 20 22 24 26 28

    -4

    -2

    0

    2

    4

    Timp mediu Residual

    Timp mediu

    Residuals

    16 18 20 22 24 26 28 30 32 34

    0

    10

    20

    Timp mediu Line Fit Plo

    Nr. poli

    Timp mediu

    Nr.polie

    7 8 9 10 11 12-0.72

    -0.07

    0.58

    1.23

    1.88

    2.53

    3.18

    R

    e

    s

    i

    d

    u

    t

  • 7/25/2019 curs 6+7

    6/28

    se/ess 0.381094331 Column

    u,'sis %0.385039139

    7.524638456 *ea/ %6E%016

    S,a/dad E' 0.326306

    *edia/ 0

    *'de :;!S,a/dad Deia,i'/ 1.263777

    Sample aia/&e 1.597132

    u,'sis %0.385039

    Se/ess 0.381094

    Ra/e 4.450758

    *i/imum %2

    *aximum 2.450758

    Sum %9E%015

  • 7/25/2019 curs 6+7

    7/28

    Timp mediu 0.313751

    RESID!" #T$T

    Observation icted Nr. p

    1 10.81067

    2 11.80498

    3 15.26266

    4 12.79289

    5 8.521102

    6 17.64553

    7 8.254005

    8 9.555662

    9 10.04961

    10 13.28043

    11 11.6650212 13.28684

    13 12.60948

    14 13.95779

    15 10.50333

  • 7/25/2019 curs 6+7

    8/28

    20 33 18 21 22 30

    8 18 9 10 10 15

    . p'li@e

    10 0

    11 4

    14 2512 0 S**!R+ #T$T

    8 25

    18 64 Regression Statistics

    9 49 *ul,iple R 0.883620846

    10 16 R S-uae 0.780785799

    10 9 !dus,ed R S 0.763923168

    15 25 S,a/dad E' 1.311483261

    11 1 #sea,i'/s 15

    15 1

    12 4 !#!

    14 16 df SS

    11 25 Reessi'/ 1 79.6401515152Residual 13 22.3598484848

    264 T',al 14 102

    Coefficients Standard Error

    I/,e&ep, %1.731060606 2.0461202297

    Timp mediu 0.549242424 0.080716215

    RESID!" #T$T

    Observation edicted Nr. pol Residuals

    1 12 %2

    2 10.90151515 0.0984848485

    3 14.74621212 %0.7462121212

    4 12 0

    5 9.253787879 %1.2537878788

    6 16.39393939 1.6060606061

    7 8.15530303 0.8446969697

    8 9.803030303 0.196969697

    9 10.35227273 %0.3522727273

    10 14.74621212 0.2537878788

    11 12.54924242 %1.549242424212 12.54924242 2.4507575758

  • 7/25/2019 curs 6+7

    9/28

    13 13.09848485 %1.0984848485

    14 14.1969697 %0.196969697

    15 9.253787879 1.7462121212

    S**!R+ #T$T

    Regression Statistics

    *ul,iple R 0.120068R S-uae 0.014416

    !dus,ed R %0.149848

    S,a/dad 1.92728

    #sea,i' 15

    !#!

    df SS MS F

    Reessi' 2 0.651974029 0.325987015 0.0877627956

    Residual 12 44.57292127 3.714410106

    T',al 14 45.2248953

    Coefficient tandard Erro t Stat P-value

    I/,e&ep, %5.435772 17.36272691 %0.313071349 0.759600863

    Timpul me 0.539948 1.396826408 0.38655337 0.7058538598

    xi 2 %0.010228 0.027535235 %0.371437618 0.7167868682

    RESID!" #T$T

    Observatio ted Resid Residuals

    1 1.670663 2.329337285

    2 1.572619 %1.562919263 1.557806 %1.00097388

    16 18 20 22 24 26 28 30

    -2.5

    -1.5

    -0.5

    0.5

    1.5

    2.5

    Timpul mediu(X)

    R

    e

    s

    i

    d

    u

    a

    l

    s

  • 7/25/2019 curs 6+7

    10/28

    4 1.670663 %1.67066272

    5 1.272138 0.299846128

    6 1.24463 1.33480098

    7 0.969541 %0.25602832

    8 1.392753 %1.3539563

    9 1.492914 %1.36881749

    10 1.557806 %1.49339812

    11 1.689002 0.711150147

    12 1.689002 4.317210753

    13 1.686886 %0.48021696

    14 1.621288 %1.5824911

    15 1.272138 1.777118855

    (esiduals%esiduals(%1)) 2 Residuals^2

    4

    4.4036386593 0.009699 %0.19697

    0.7135129706 0.556833 %0.073491

    0.5568325298 0 0

    1.571984045 1.571984 0

    8.1787333563 2.579431 %2.013659

    0.5796745868 0.713513 1.356635

    0.4195506198 0.038797 0.16638

    0.3016672406 0.124096 %0.069387

    0.3673094582 0.064408 %0.089403

    3.2509182736 2.400152 %0.393179

    16 6.006213 %3.796818

    12.597121786 1.206669 %2.69212

    0.8127295684 0.038797 0.2163683.7759555785 3.049257 %0.343951

    3 14 15 16 17

    e polite

  • 7/25/2019 curs 6+7

    11/28

    53.5296286731 22.35985 %7.929594

    DW 2!"#$$% %0.354635

    Significance F

    1.25366599123984E%005

    #o$er %&' (pper %&' o$er %&.) (pper %&.)'

    %6.1514346176 2.689313 %6.151435 2.689313405

    0.3748656432 0.723619 0.374866 0.723619205

    $R#!I"IT+ #T$T

    0 1 2 3

    -2

    -1.5

    -1

    -0.5

    0

    0.5

    1

    1.5

    2

    2.5

    3

  • 7/25/2019 curs 6+7

    12/28

    Percentile Nr. polie

    3.3333333333 8

    10 9

    16.6666666667 10

    23.3333333333 10

    30 10

    36.6666666667 11

    43.3333333333 11

    50 11

    56.6666666667 12

    63.3333333333 12

    70 14

    76.6666666667 14

    83.3333333333 15

    90 15

    96.6666666667 18

    30 32 34

    Plot

    0 20 40 60 80 100

    0

    10

    20

    Normal Probability

    Sample Percentile

    Nr.polie

    13 14 15 16 17

  • 7/25/2019 curs 6+7

    13/28

    SS MS F Significance F

    90.3642295614 45.18211 46.59643 2.2038E%006

    11.6357704386 0.969648

    102

    Standard Error t Stat P-value #o$er %&' (pper %&'

    1.6277898332 %2.162679 0.051464 %7.06703581 0.0262629320.0005418599 3.325623 0.006047 0.000621411 0.002982633

    e polite

  • 7/25/2019 curs 6+7

    14/28

    0.093204823 3.366252 0.005609 0.110675062 0.51682679

    Residuals

    %0.8106655472

    %0.8049834032

    %1.2626552152

    %0.7928896352

    %0.521102157

    0.3544744877

    0.7459953157

    0.4443381575

    %0.0496149585

    1.7195688728

    %0.66502304281.7131572488

    %0.6094816334

    0.042207755

    0.496673755

  • 7/25/2019 curs 6+7

    15/28

    26 26 27 29 20

    11 15 12 14 11

    MS F Significance F

    79.640151515 46.30273 1.2537E%0051.719988345

    t Stat P-value #o$er %&' (pper %&'

    %0.8460209625 0.412843 %6.15143462 2.689313405

    6.8046107476 1.3E%005 0.374865643 0.723619205

    3000 3500 4000 4500 5000 5500 6000 6500

    -2

    0

    2

    Cheltuieli de promoare!R"N Residual Plot

    Cheltuieli de promoare!R"N

    Residuals

    16 18 20 22 24 26 28 30 32

    -2

    -1

    0

    1

    2

    Timp mediu Residual Pl

    Timp mediu

    Residuals

    0 2 4 6 8

    0

    10

    20

    Normal Probabilit

    Sample Percentile

    Nr.polie

  • 7/25/2019 curs 6+7

    16/28

    Significance F

    0.916560568

    #o$er %&' (pper %&'

    %43.265904481 32.39436

    %2.5034753425 3.583371

    %0.0702217456 0.049767

    32 34

  • 7/25/2019 curs 6+7

    17/28

  • 7/25/2019 curs 6+7

    18/28

  • 7/25/2019 curs 6+7

    19/28

    120

    lot

  • 7/25/2019 curs 6+7

    20/28

  • 7/25/2019 curs 6+7

    21/28

  • 7/25/2019 curs 6+7

    22/28

    4

    t

    10 12

    Plot

  • 7/25/2019 curs 6+7

    23/28

  • 7/25/2019 curs 6+7

    24/28

  • 7/25/2019 curs 6+7

    25/28

  • 7/25/2019 curs 6+7

    26/28

  • 7/25/2019 curs 6+7

    27/28

  • 7/25/2019 curs 6+7

    28/28