Upprifjun

48
Tölfræ ði H anda fólkiíhagnýtu nám i.

description

Upprifjun. Meira um tölfræði. Besta lína - aðhvarfslína. Sjá skrána gqgn.xls – dálka K og L U21 – hlutfall ungra ökumanna, % með próf undir 21 Dauðaslysa af 10.000. - PowerPoint PPT Presentation

Transcript of Upprifjun

  • Tlfri

    Handa flki hagntu nmi.

  • Year

    TVprice

    TVcumpr

    1964

    777

    3,104

    1965

    779

    5,798

    1966

    787

    10,910

    1967

    746

    16,373

    1968

    662

    22,588

    1969

    615

    28,779

    1970

    624

    34,099

    1971

    549

    41,373

    1972

    520

    50,218

    1973

    474

    60,289

    1974

    448

    68,700

    1975

    442

    74,919

    1976

    430

    83,113

    1977

    407

    92,454

    1978

    380

    103,674

    1979

    360

    113,170

  • Sheet: Chart1

    Sheet: Sheet1

    Sheet: Sheet2

    Sheet: Sheet3

    Sheet: Sheet4

    Sheet: Sheet5

    1964.0

    1964.0

    1965.0

    1965.0

    1966.0

    1966.0

    1967.0

    1967.0

    1968.0

    1968.0

    1969.0

    1969.0

    1970.0

    1970.0

    1971.0

    1971.0

    1972.0

    1972.0

    1973.0

    1973.0

    1974.0

    1974.0

    1975.0

    1975.0

    1976.0

    1976.0

    1977.0

    1977.0

    1978.0

    1978.0

    1979.0

    1979.0

    777.0

    3.104

    779.0

    5.798

    787.0

    10.91

    746.0

    16.373

    662.0

    22.588

    615.0

    28.779

    624.0

    34.099

    549.0

    41.373

    520.0

    50.218

    474.0

    60.289

    448.0

    68.7

    442.0

    74.919

    430.0

    83.113

    407.0

    92.454

    380.0

    103.674

    360.0

    113.17

    Year

    TVprice

    TVcumpr

    3.104

    5.798

    16.373

    22.588

    28.779

    34.099

    41.373

    50.218

    60.289

    74.919

    83.113

    92.454

    103.674

  • Year

    TVprice

    TVcumpr

    Mean

    1971,5

    562,5

    50,59756

    Standard Error

    1,190238

    38,01831

    8,940049

    Median

    1971,5

    534,5

    45,7955

    Mode

    #N/A

    #N/A

    #N/A

    Standard Deviation

    4,760952

    152,0732

    35,7602

    Sample Variance

    22,66667

    23126,27

    1278,792

    Kurtosis

    -1,2

    -1,42877

    -1,16137

    Skewness

    -6,8E-17

    0,311565

    0,310181

    Range

    15

    427

    110,066

    Minimum

    1964

    360

    3,104

    Maximum

    1979

    787

    113,17

    Sum

    31544

    9000

    809,561

    Count

    16

    16

    16

    Confidence Level(90,0%)

    2,086548

    66,64803

    15,67236

  • Bin

    Frequency

    Cumulative %

    1

    2

    2,11%

    2

    6

    8,42%

    3

    10

    18,95%

    4

    8

    27,37%

    5

    25

    53,68%

    6

    10

    64,21%

    7

    21

    86,32%

    8

    7

    93,68%

    9

    5

    98,95%

    10

    1

    100,00%

  • Sheet: Chart2

    Sheet: Sheet7

    Sheet: Sheet10

    Sheet: Sheet6

    Sheet: Sheet1

    Sheet: Sheet2

    Sheet: Sheet3

    Sheet: Sheet4

    Sheet: Sheet5

    1.0

    1.0

    2.0

    2.0

    3.0

    3.0

    4.0

    4.0

    5.0

    5.0

    6.0

    6.0

    7.0

    7.0

    8.0

    8.0

    9.0

    9.0

    10.0

    10.0

    2.0

    0.021052631578947368

    6.0

    0.08421052631578947

    10.0

    0.18947368421052632

    8.0

    0.2736842105263158

    25.0

    0.5368421052631579

    10.0

    0.6421052631578947

    21.0

    0.8631578947368421

    7.0

    0.9368421052631579

    5.0

    0.9894736842105263

    1.0

    1.0

    Bin

    Frequency

    Cumulative %

    0.010526315789473684

    1.1111111111111112

    1.0

    0.021052631578947368

    2.2222222222222223

    6.0

    0.08421052631578947

    3.3333333333333335

    10.0

    0.18947368421052632

    4.444444444444445

    8.0

    0.2736842105263158

    5.555555555555555

    25.0

    0.5368421052631579

    6.666666666666667

    10.0

    0.6421052631578947

    7.777777777777779

    21.0

    0.8631578947368421

    8.88888888888889

    7.0

    0.9368421052631579

    More

    Bin

    Frequency

    Cumulative %

    0.021052631578947368

    0.08421052631578947

    0.18947368421052632

    0.2736842105263158

    0.5368421052631579

    0.6421052631578947

    0.8631578947368421

    0.9368421052631579

    0.9894736842105263

    Year

    TVprice

    TVcumpr

    Mean

    1971.5

    Mean

    562.5

    Mean

    50.597562499999995

    Standard Error

    1.1902380714238083

    Standard Error

    38.01830699369275

    Standard Error

    8.940049108724532

    Median

    1971.5

    Median

    534.5

    Median

    45.795500000000004

    Mode

    Mode

    Mode

    Standard Deviation

    4.760952285695233

    Standard Deviation

    152.073227974771

    Standard Deviation

    35.76019643489813

    Sample Variance

    22.666666666666668

    Sample Variance

    23126.266666666666

    Sample Variance

    1278.7916490625007

    Kurtosis

    -1.2

    Kurtosis

    -1.4287665387322401

    Kurtosis

    -1.1613678792666469

    Skewness

    -6.767073673905717E-17

    Skewness

    0.31156478242506935

    Skewness

    0.310180526153196

    Range

    15.0

    Range

    427.0

    Range

    110.066

    Minimum

    1964.0

    Minimum

    360.0

    Minimum

    3.104

    Maximum

    1979.0

    Maximum

    787.0

    Maximum

    113.17

    Sum

    31544.0

    Sum

    9000.0

    Sum

    809.5609999999999

    Count

    16.0

    Count

    16.0

    Count

    16.0

    Confidence Level(90,0%)

    2.086548086180656

    Confidence Level(90,0%)

    66.64803252564776

    Confidence Level(90,0%)

    15.672362366846333

    Einkunnir hagfri hausti 1992

    0.0

    0.0

    1.0

    4.0

    2.0

    8.0

    3.0

    8.0

    4.0

    5.0

    5.0

    6.0

    6.0

    1.0

    7.0

    2.0

    8.0

    5.0

    9.0

    7.0

    9.0

    6.0

    4.0

    5.0

    2.0

    5.0

    5.0

    6.0

    3.0

    7.0

    7.0

    4.0

    6.0

    3.0

    7.0

    2.0

    7.0

    7.0

    3.0

    2.0

    5.0

    6.0

    7.0

    4.0

    8.0

    3.0

    5.0

    7.0

    3.0

    3.0

    5.0

    5.0

    8.0

    5.0

    7.0

    5.0

    7.0

    7.0

    8.0

    7.0

    5.0

    7.0

    6.0

    4.0

    3.0

    7.0

    5.0

    2.0

    7.0

    7.0

    5.0

    4.0

    7.0

    3.0

    6.0

    6.0

    5.0

    9.0

    5.0

    5.0

    5.0

    5.0

    8.0

    2.0

    6.0

    5.0

    7.0

    5.0

    4.0

    5.0

    8.0

    6.0

    7.0

    5.0

    5.0

    10.0

    3.0

    5.0

    9.0

    3.0

    7.0

    9.0

    4.0

    9.0

    7.0

    Year

    TVprice

    TVcumpr

    3.104

    5.798

    16.373

    22.588

    28.779

    34.099

    41.373

    50.218

    60.289

    74.919

    83.113

    92.454

    103.674

  • Heiti

    Ger

    Dmi

    Flokkun

    Ggn samanstanda af tknum sem einungis er hgt a greina hvort fr ru, hgt er a flokka ggnin. Ekki er hgt a raa ggnunum tiltekna r grundvelli mlinga.

    A,B,B,A,C,C

    Raskrning

    Mling er skr annig a unnt er a raa ggnum upp r grundvelli mlingarinnar.

    Strarskrning

    Raskrning, ar sem hgt er a segja til um hve miki ein mling er strri en nnur. Mlieining verur a vera fyrir hendi.

    Fjarlg

    Vimisskrning

    Strarskrning, ar sem mia er vi tiltekinn grunn ea upphafspunkt.

    Fjarlg fr tilteknum punkti me formerki.

  • iXE "i", rtaksrmXE "rtaksrm" - Mengi allra hugsanlegra niurstana r mlingu, tkna SYMBOL 87 \f "Symbol". Ef

    er hugsanleg niurstaa r mlingu, gildir

    og i ea rtaksrmi inniheldur n ea endanlega mrg stk.

  • HendingXE "Hending", rtakXE "rtak" - Hlutmengi i, hluti hugsanlegra niurstana r mlingu. Ef A er hending gildir

    . annig gti A veri mengi k mlinga sem fengin vru r rtaksrminu ea

  • GagnavektorXE "Gagnavektor", gagnafrslaXE "gagnafrsla" - Ggnum raa upp r, til dmis eftir eirri r sem eirra var afla

  • Mealtal (mean)XE "Mealtal" rtaks ea hendingar

    er

    MealgildiXE "Mealgildi" is ea rtaksrms

    er

  • Mitala (median),

    XE "Mitala, " - S tala sem skiptir ruum ggnum upp tvo jafn stra hpa, annig a 50% gagnanna su jfn ea minni en

    . Ef fjldi mlinga vri 2n-1 vri mitalan tala nmer n. Ef fjldi mlinga vri 2n er mitala mealtal mlinga nmer n og n+1.

  • Htnitala (mode),

    XE "Htnitala (mode), " - S tala sem oftast kemur fyrir meal gagna.

    Fjrungstlur

    XE "Fjrungstlur " - Tlur sem skipta ruum ggnum fjrunga annig a 25% gagna eru minni ea jfn Q1 en 75% minni ea jfn Q3

  • MileitniXE "Mileitni" - Mealtal, mitala og htnitala eru mlikvarar miju ea mileitni gagna. Ef ggn eru samhverf, er mealtal oft heppilegt mijumat, en ef au eru a ekki eins og oft sr sta launadreifingum, getur mitala gefi betri mynd af miju. Htnitala helst vi tnimlingum.

  • Breytileiki (variance)

  • Staalfrvik (standard deviation)XE "Staalfrvik (standard deviation)" - s og SYMBOL 115 \f "Symbol".

    BreytileikastuullXE "Breytileikastuull"

    Hentugur til a bera saman breytileika, egar mlingar eru ekki gerar smu einingum.

  • z-gildiXE "z-gildi"

    Lsir frviki fr mealtali mldu staalfrvikum.

    Normaldreif ggn. Ef ggn eru nokkurn veginn normaldreif, gildir:

    Regla TebistevXE "Regla Tebistev". - Sama er hvernig ggn dreifast alltaf gildir a bili

  • Raflttur - Fjldi raa me k stkum, sem hgt er a mynda r n stkum er

  • Raflttur me eins stkum - Fjldi raa me k stkum sem hgt er a ba til r n stkum, ar sem k1 eru eins, k2 eru eins, ....., kj eru eins, ar sem k1+k2+....+kj=k, eru

  • Flttur - Fjldi hpa me k stkum sem hgt er amynda r n stkum

  • Meira um tlfri

  • Sambreytileiki - covariance:

    Aallega nota til ess a kanna hvort strir sveiflast eins, fugt ea hvort r su har.

    _1046202803.unknown

    _1046203698.unknown

    _1046202405.unknown

  • Sheet1

    xyxy

    22x5.0833333333

    222y-490.4722222222

    33

    33

    533

    51

    81

    82

    72

    15

    56

    56

    Sheet2

    Sheet3

    Sheet1

    xyxy

    22x5.0833333333

    222y-490.4722222222

    33

    33

    533

    51

    81

    82

    72

    15

    56

    56

    Sheet2

    Sheet3

  • Betri er fylgni sem mlikvari a hvort strir sveiflast eins:

    _1046203351.unknown

  • Sheet1

    xyxy

    22x5.0833333333

    222y-490.4722222222

    33

    33

    533

    51

    81

    82

    72

    15

    56

    56

    Sheet2

    Sheet3

    Sheet1

    xyxy

    22x5.0833333333

    222y-490.4722222222

    33

    33

    533

    51

    81

    82

    72

    15

    56

    56

    Sheet2

    Sheet3

    Sheet1

    xyxy

    22x5.0833333333

    222y-490.4722222222

    33

    33

    533

    51xy

    81x1

    82y-0.18652114291

    72

    15

    56

    56

    Sheet2

    Sheet3

  • Chart1

    2

    22

    3

    3

    33

    1

    1

    2

    2

    5

    6

    6

    y

    x

    y

    Punktarit af (x,y)

    Sheet1

    xyxy

    22x5.0833333333

    222y-490.4722222222

    33

    33

    533

    51xy

    81x1

    82y-0.18652114291

    72

    15

    56

    56

    Sheet1

    y

    x

    y

    Punktarit af (x,y)

    Sheet2

    Sheet3

  • Chart2

    2

    22

    3

    3

    33

    1

    1

    2

    2

    5

    6

    6

    y

    Ahvarfslna

    x

    y

    Punktarit af (x,y)

    Sheet1

    xyxy

    22x5.0833333333

    222y-490.4722222222

    33

    33

    533

    51xy

    81x1

    82y-0.18652114291

    72

    15

    56

    56

    Sheet1

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    y

    Ahvarfslna

    x

    y

    Punktarit af (x,y)

    Sheet2

    Sheet3

  • Besta lna - ahvarfslna

  • Sheet1

    xySUMMARY OUTPUT

    22

    222Regression Statistics

    33Multiple R0.19

    33R Square0.03

    533Adjusted R Square-0.06

    51Standard Error10.24

    81Observations12

    82

    72ANOVA

    15dfSSMSFSignificance F

    56Regression137.7737.770.360.56

    56Residual101047.90104.79

    Total111085.67

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 90,0%Upper 90,0%

    Intercept10.716.601.620.14-3.9925.41-1.2522.66

    x-0.791.31-0.600.56-3.712.13-3.161.59

    RESIDUAL OUTPUT

    ObservationPredicted yResiduals

    19.13-7.13

    29.1312.87

    38.35-5.35

    48.35-5.35

    56.7726.23

    66.77-5.77

    74.41-3.41

    84.41-2.41

    95.20-3.20

    109.92-4.92

    116.77-0.77

    126.77-0.77

    Sheet1

    -7.1338797814

    12.8661202186

    -5.3469945355

    -5.3469945355

    26.2267759563

    -5.7732240437

    -3.412568306

    -2.412568306

    -3.1994535519

    -4.9207650273

    -0.7732240437

    -0.7732240437

    x

    Residuals

    x Residual Plot

    Sheet2

    29.1338797814

    229.1338797814

    38.3469945355

    38.3469945355

    336.7732240437

    16.7732240437

    14.412568306

    24.412568306

    25.1994535519

    59.9207650273

    66.7732240437

    66.7732240437

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet3

    Sheet1

    xySUMMARY OUTPUT

    22

    222Regression Statistics

    33Multiple R0.19

    33R Square0.03

    533Adjusted R Square-0.06

    51Standard Error10.24

    81Observations12

    82

    72ANOVA

    15dfSSMSFSignificance F

    56Regression137.7737.770.360.56

    56Residual101047.90104.79

    Total111085.67

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 90,0%Upper 90,0%

    Intercept10.716.601.620.14-3.9925.41-1.2522.66

    x-0.791.31-0.600.56-3.712.13-3.161.59

    RESIDUAL OUTPUT

    ObservationPredicted yResiduals

    19.13-7.13

    29.1312.87

    38.35-5.35

    48.35-5.35

    56.7726.23

    66.77-5.77

    74.41-3.41

    84.41-2.41

    95.20-3.20

    109.92-4.92

    116.77-0.77

    126.77-0.77

    Sheet1

    x

    Residuals

    x Residual Plot

    Sheet2

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet3

  • Sheet1

    xySUMMARY OUTPUT

    22

    222Regression Statistics

    33Multiple R0.19

    33R Square0.03

    533Adjusted R Square-0.06

    51Standard Error10.24

    81Observations12

    82

    72ANOVA

    15dfSSMSFSignificance F

    56Regression137.7737.770.360.56

    56Residual101047.90104.79

    Total111085.67

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 90,0%Upper 90,0%

    Intercept10.716.601.620.14-3.9925.41-1.2522.66

    x-0.791.31-0.600.56-3.712.13-3.161.59

    RESIDUAL OUTPUT

    ObservationPredicted yResiduals

    19.13-7.13

    29.1312.87

    38.35-5.35

    48.35-5.35

    56.7726.23

    66.77-5.77

    74.41-3.41

    84.41-2.41

    95.20-3.20

    109.92-4.92

    116.77-0.77

    126.77-0.77

    Sheet1

    x

    Residuals

    x Residual Plot

    Sheet2

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet3

    Sheet1

    xySUMMARY OUTPUT

    22

    222Regression Statistics

    33Multiple R0.19

    33R Square0.03

    533Adjusted R Square-0.06

    51Standard Error10.24

    81Observations12

    82

    72ANOVA

    15dfSSMSFSignificance F

    56Regression137.7737.770.360.56

    56Residual101047.90104.79

    Total111085.67

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 90,0%Upper 90,0%

    Intercept10.716.601.620.14-3.9925.41-1.2522.66

    x-0.791.31-0.600.56-3.712.13-3.161.59

    RESIDUAL OUTPUT

    ObservationPredicted yResiduals

    19.13-7.13

    29.1312.87

    38.35-5.35

    48.35-5.35

    56.7726.23

    66.77-5.77

    74.41-3.41

    84.41-2.41

    95.20-3.20

    109.92-4.92

    116.77-0.77

    126.77-0.77

    Sheet1

    x

    Residuals

    x Residual Plot

    Sheet2

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet3

  • Sheet1

    xySUMMARY OUTPUT

    22

    222Regression Statistics

    33Multiple R0.19

    33R Square0.03

    533Adjusted R Square-0.06

    51Standard Error10.24

    81Observations12

    82

    72ANOVA

    15dfSSMSFSignificance F

    56Regression137.7737.770.360.56

    56Residual101047.90104.79

    Total111085.67

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 90,0%Upper 90,0%

    Intercept10.716.601.620.14-3.9925.41-1.2522.66

    x-0.791.31-0.600.56-3.712.13-3.161.59

    RESIDUAL OUTPUT

    ObservationPredicted yResiduals

    19.13-7.13

    29.1312.87

    38.35-5.35

    48.35-5.35

    56.7726.23

    66.77-5.77

    74.41-3.41

    84.41-2.41

    95.20-3.20

    109.92-4.92

    116.77-0.77

    126.77-0.77

    Sheet1

    x

    Residuals

    x Residual Plot

    Sheet2

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet3

  • Chart3

    29.1338797814

    229.1338797814

    38.3469945355

    38.3469945355

    336.7732240437

    16.7732240437

    14.412568306

    24.412568306

    25.1994535519

    59.9207650273

    66.7732240437

    66.7732240437

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet1

    xySUMMARY OUTPUT

    22

    222Regression Statistics

    33Multiple R0.19

    33R Square0.03

    533Adjusted R Square-0.06

    51Standard Error10.24

    81Observations12

    82

    72ANOVA

    15dfSSMSFSignificance F

    56Regression137.7737.770.360.56

    56Residual101047.90104.79

    Total111085.67

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 90,0%Upper 90,0%

    Intercept10.716.601.620.14-3.9925.41-1.2522.66

    x-0.791.31-0.600.56-3.712.13-3.161.59

    RESIDUAL OUTPUT

    ObservationPredicted yResiduals

    19.13-7.13

    29.1312.87

    38.35-5.35

    48.35-5.35

    56.7726.23

    66.77-5.77

    74.41-3.41

    84.41-2.41

    95.20-3.20

    109.92-4.92

    116.77-0.77

    126.77-0.77

    Sheet1

    x

    Residuals

    x Residual Plot

    Sheet2

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet3

  • Chart2

    -7.1338797814

    12.8661202186

    -5.3469945355

    -5.3469945355

    26.2267759563

    -5.7732240437

    -3.412568306

    -2.412568306

    -3.1994535519

    -4.9207650273

    -0.7732240437

    -0.7732240437

    x

    Residuals

    x Residual Plot

    Sheet1

    xySUMMARY OUTPUT

    22

    222Regression Statistics

    33Multiple R0.19

    33R Square0.03

    533Adjusted R Square-0.06

    51Standard Error10.24

    81Observations12

    82

    72ANOVA

    15dfSSMSFSignificance F

    56Regression137.7737.770.360.56

    56Residual101047.90104.79

    Total111085.67

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 90,0%Upper 90,0%

    Intercept10.716.601.620.14-3.9925.41-1.2522.66

    x-0.791.31-0.600.56-3.712.13-3.161.59

    RESIDUAL OUTPUT

    ObservationPredicted yResiduals

    19.13-7.13

    29.1312.87

    38.35-5.35

    48.35-5.35

    56.7726.23

    66.77-5.77

    74.41-3.41

    84.41-2.41

    95.20-3.20

    109.92-4.92

    116.77-0.77

    126.77-0.77

    Sheet1

    x

    Residuals

    x Residual Plot

    Sheet2

    y

    Predicted y

    x

    y

    x Line Fit Plot

    Sheet3

  • Sj skrna gqgn.xls dlka K og L

    U21 hlutfall ungra kumanna, % me prf undir 21

    Dauaslysa af 10.000

    GQGN

    karl_avkarl_kokarl_pekon_avkon_kokon_pedepNYNCHeilsau21daudaslsalestimepotenadvsharechangeacctsworkratingn_sconsANYNC

    84.1234.664.7499.6737.2710.147000132.9623669.8843.174065.14582.92.510.3474.8615.054.901HH796

    99.2165.6748.1470.1838.8223.5910001120.7083473.95108.1358117.35539.85.510.15107.3219.975.110HH2115

    74.5159.3830.69138.4246.555.791200180.8852295.113.8221118.52950.410.91-0.7296.7517.342.900HH4812

    17.9172.9936.0193.6854.1616.7819001121.6524675.56186.1868521.32243.18.270.17195.1213.43.401HH898

    49.5964.4523.5120.8966.7619.7611001112.0916125.96161.7957805.17747.19.150.5180.4417.644.610HH569

    79.7790.426.0289.6671.3110.572000172.6272134.948.9437806.9402.45.510.15104.8816.224.510HH777

    29.3532.0919.2496.443.5714.34000183.835031.66365.0450935.33140.68.540.55256.118.84.611HH4106

    83.3179.735.3779.5576.181300183.683367.45220.3235602.12086.27.07-0.49126.8319.862.300HH3104

    115.9696.086.6867.9564.6814001131.1426519.45127.6446176.88846.212.541.24203.2517.424.900HH446

    105.5441.5820.6151.8920.231700180.6454876.37105.6942053.25673.18.850.31119.5121.412.800HH1106

    66.0936.7319.78130.4145.36800091.0282468.2757.7236829.72761.85.380.37116.2616.323.100HL101914

    50.155.0898.854.335000162.8012533.3123.5833612.71991.85.43-0.65142.2814.514.201HL121014

    97.2622.75104.6752.0711001121.4052408.1113.8221412.81971.58.480.6489.4319.354.300HL191720

    51.2142.7290.0453.631800191.4332337.3813.8220416.91734.77.81.0184.5520.024.210HL111515

    24.0877.6256.847000100.0394586.9586.993627210694.210.340.11119.5115.265.510HL131112

    28.7688.17400090.3382729.24165.8523093.38618.65.150.0480.4915.873.610HL141216

    127.343000111.8493289.4116.2626878.67747.96.640.68136.587.813.410HL172012

    80.24000122.2462800.7842.28395724565.85.450.6678.86164.201HL111313

    134.271000142.8553264.252.8451866.16022.76.31-0.1136.5817.443.610HL181215

    75.549001142.3523453.62165.0458749.83721.16.35-0.03138.2117.983.100HL91510

    86.349100111.2941741.4510.5723990.88617.37-1.6375.6120.991.601

    108.719101174.12035.7513.8225694.93571.58.39-0.43102.4421.663.401

    95.831010182.1915788.1323736.32845.55.150.0476.4221.462.701

    111.9811100163.6234167.4458.4434314.35060.112.880.22136.5824.782.800

    103.958100152.6232799.9721.1422809.535529.14-0.7488.6224.963.901

    78.811710190.835

    123.621510180.82

    125.0111101142.89

    66.44910081.267

    114.426100153.224

    132.317100101.014

    62.2412101100.493

    97.9320101141.443

    90.1710100183.614

    97.7213101101.926

    112.6710100141.643

    81.8512101162.943

    15101121.913

    4100152.814

    10100132.634

    1401190.926

    14011173.256

    20011

    15011

    6010

    5010

    12010

    8010

    12011

    9010

    16011

    12011

    7010

    13011

    6010

    15011

    4010

    6010

    6010

    10011

    &A

    Page &P

  • a sem mli skipti tskriftinni er:

    Coefficients

    Standard Error

    t Stat

    P-value

    Lower 95%

    Upper 95%

    Intercept

    -1,09

    0,47

    -2,33

    0,02

    -2,03

    -0,14

    u21

    0,25

    0,04

    6,83

    0,00

    0,18

    0,33

    Hr ssta bir stular eru vel marktkir, a er eim tilgtum a eir su 0 er hgt a hafna

    _983911616.xls

    Chart2

    2.9622.187225413

    0.7081.9352748535

    0.8850.9274726153

    1.6521.9352748535

    2.0911.6833242939

    2.6273.1950276511

    3.833.4469782107

    3.680.9274726153

    1.1422.187225413

    0.6450.9274726153

    1.0281.1794231748

    2.8012.9430770916

    1.4051.9352748535

    1.4331.1794231748

    0.0391.4313737344

    0.3381.1794231748

    1.8491.6833242939

    2.2461.9352748535

    2.8552.4391759725

    2.3522.4391759725

    1.2941.6833242939

    4.13.1950276511

    2.190.9274726153

    3.6232.9430770916

    2.6232.6911265321

    0.8351.1794231748

    0.820.9274726153

    2.892.4391759725

    1.2670.9274726153

    3.2242.6911265321

    1.0141.4313737344

    0.4931.4313737344

    1.4432.4391759725

    3.6143.4469782107

    1.9261.4313737344

    1.6432.4391759725

    2.9432.9430770916

    1.9131.9352748535

    2.8142.6911265321

    2.6342.187225413

    0.9261.1794231748

    3.2563.1950276511

    daudasl

    Predicted daudasl

    u21

    daudasl

    u21 Besta lna

    Sheet1

    2.141.971.972.062.082.011.972.032.092.03555555560.0612599198

    L=0.0470885733

    1.95291142672.0470885733

    2.2652346262

    2.3060056265

    24.5600.25

    0.2650.028032431

    -2.44716557410.2369675690.293032431

    Sheet2

    914717965710

    x1x2x1x2

    76.8890885207133.6219350073

    30.948891096758.6162752975Mean68.330273850493.2618840047

    102.480093462596.3466880116Standard Error14.021046950414.349269918

    150.994256389556.1755916956Median58.560404456977.4814816546

    147.3224602956116.8237668176Standard Deviation57.810257558245.3763757014

    172.4572558738171.5433825361Sample Variance3342.02587894312059.01547179760.61609800350.26708768533.048754138

    -11.628619060955.6282782477Kurtosis-0.8780534796-1.2716465702

    79.9934815656142.9511473966Skewness0.41522605630.5466305213

    142.466058721443.9826715287Range184.0858749347127.5607110074

    39.925069475156.9291035085Minimum-11.628619060943.9826715287

    58.5604044569Maximum172.4572558738171.5433825361

    11.5496806098Sum1161.6146554565932.6188400473

    4.1951881282Count1710

    45.0514136243Confidence Level(95,0%)29.723285019632.4603284652

    54.6451684637

    -8.5427672024

    64.307531036t-Test: Two-Sample Assuming Equal Variances

    -44.04879204944.048792049

    x1x2

    Mean68.330273850493.2618840047

    Variance3342.02587894312059.0154717976

    Observations1710

    Pooled Variance2880.1421323708

    Hypothesized Mean Difference0

    df25

    t Stat-1.1656977168

    P(T

  • Chart2

    2.9622.187225413

    0.7081.9352748535

    0.8850.9274726153

    1.6521.9352748535

    2.0911.6833242939

    2.6273.1950276511

    3.833.4469782107

    3.680.9274726153

    1.1422.187225413

    0.6450.9274726153

    1.0281.1794231748

    2.8012.9430770916

    1.4051.9352748535

    1.4331.1794231748

    0.0391.4313737344

    0.3381.1794231748

    1.8491.6833242939

    2.2461.9352748535

    2.8552.4391759725

    2.3522.4391759725

    1.2941.6833242939

    4.13.1950276511

    2.190.9274726153

    3.6232.9430770916

    2.6232.6911265321

    0.8351.1794231748

    0.820.9274726153

    2.892.4391759725

    1.2670.9274726153

    3.2242.6911265321

    1.0141.4313737344

    0.4931.4313737344

    1.4432.4391759725

    3.6143.4469782107

    1.9261.4313737344

    1.6432.4391759725

    2.9432.9430770916

    1.9131.9352748535

    2.8142.6911265321

    2.6342.187225413

    0.9261.1794231748

    3.2563.1950276511

    daudasl

    Predicted daudasl

    u21

    daudasl

    u21 Besta lna

    Sheet1

    2.141.971.972.062.082.011.972.032.092.03555555560.0612599198

    L=0.0470885733

    1.95291142672.0470885733

    2.2652346262

    2.3060056265

    24.5600.25

    0.2650.028032431

    -2.44716557410.2369675690.293032431

    Sheet2

    914717965710

    x1x2x1x2

    76.8890885207133.6219350073

    30.948891096758.6162752975Mean68.330273850493.2618840047

    102.480093462596.3466880116Standard Error14.021046950414.349269918

    150.994256389556.1755916956Median58.560404456977.4814816546

    147.3224602956116.8237668176Standard Deviation57.810257558245.3763757014

    172.4572558738171.5433825361Sample Variance3342.02587894312059.01547179760.61609800350.26708768533.048754138

    -11.628619060955.6282782477Kurtosis-0.8780534796-1.2716465702

    79.9934815656142.9511473966Skewness0.41522605630.5466305213

    142.466058721443.9826715287Range184.0858749347127.5607110074

    39.925069475156.9291035085Minimum-11.628619060943.9826715287

    58.5604044569Maximum172.4572558738171.5433825361

    11.5496806098Sum1161.6146554565932.6188400473

    4.1951881282Count1710

    45.0514136243Confidence Level(95,0%)29.723285019632.4603284652

    54.6451684637

    -8.5427672024

    64.307531036t-Test: Two-Sample Assuming Equal Variances

    -44.04879204944.048792049

    x1x2

    Mean68.330273850493.2618840047

    Variance3342.02587894312059.0154717976

    Observations1710

    Pooled Variance2880.1421323708

    Hypothesized Mean Difference0

    df25

    t Stat-1.1656977168

    P(T

  • Chart3

    0.774774587

    -1.2272748535

    -0.0424726153

    -0.2832748535

    0.4076757061

    -0.5680276511

    0.3830217893

    2.7525273847

    -1.045225413

    -0.2824726153

    -0.1514231748

    -0.1420770916

    -0.5302748535

    0.2535768252

    -1.3923737344

    -0.8414231748

    0.1656757061

    0.3107251465

    0.4158240275

    -0.0871759725

    -0.3893242939

    0.9049723489

    1.2625273847

    0.6799229084

    -0.0681265321

    -0.3444231748

    -0.1074726153

    0.4508240275

    0.3395273847

    0.5328734679

    -0.4173737344

    -0.9383737344

    -0.9961759725

    0.1670217893

    0.4946262656

    -0.7961759725

    -0.0000770916

    -0.0222748535

    0.1228734679

    0.446774587

    -0.2534231748

    0.0609723489

    u21

    Residuals

    u21 Afgangsliir

    Sheet1

    2.141.971.972.062.082.011.972.032.092.03555555560.0612599198

    L=0.0470885733

    1.95291142672.0470885733

    2.2652346262

    2.3060056265

    24.5600.25

    0.2650.028032431

    -2.44716557410.2369675690.293032431

    Sheet2

    914717965710

    x1x2x1x2

    76.8890885207133.6219350073

    30.948891096758.6162752975Mean68.330273850493.2618840047

    102.480093462596.3466880116Standard Error14.021046950414.349269918

    150.994256389556.1755916956Median58.560404456977.4814816546

    147.3224602956116.8237668176Standard Deviation57.810257558245.3763757014

    172.4572558738171.5433825361Sample Variance3342.02587894312059.01547179760.61609800350.26708768533.048754138

    -11.628619060955.6282782477Kurtosis-0.8780534796-1.2716465702

    79.9934815656142.9511473966Skewness0.41522605630.5466305213

    142.466058721443.9826715287Range184.0858749347127.5607110074

    39.925069475156.9291035085Minimum-11.628619060943.9826715287

    58.5604044569Maximum172.4572558738171.5433825361

    11.5496806098Sum1161.6146554565932.6188400473

    4.1951881282Count1710

    45.0514136243Confidence Level(95,0%)29.723285019632.4603284652

    54.6451684637

    -8.5427672024

    64.307531036t-Test: Two-Sample Assuming Equal Variances

    -44.04879204944.048792049

    x1x2

    Mean68.330273850493.2618840047

    Variance3342.02587894312059.0154717976

    Observations1710

    Pooled Variance2880.1421323708

    Hypothesized Mean Difference0

    df25

    t Stat-1.1656977168

    P(T

  • Sheet1

    123456

    O51578121360

    E10101010101060

    2.502.500.900.400.400.907.6011.07

    3.113247131.9844674171

    YMU

    Karlar5035.78767123292548.801369863400475

    Konur519.21232876715026.198630137200255

    5575600730

    5.64413056311.6083874069

    10.51357653921.6234667383

    16.15770710233.231854145249.38956124715.9914763568

    Sheet2

    Sheet4

    SUMMARY OUTPUT

    Regression Statistics

    Multiple R0.9623839618

    R Square0.9261828899

    Adjusted R Square0.8734563826

    Standard Error467.0973224143

    Observations25

    ANOVA

    dfSSMSFSignificance F

    Regression1038325030.20636413832503.0206364117.56579258430.0000030187

    Residual143054518.72049195218179.908606568

    Total2441379548.926856

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95,0%Upper 95,0%

    Intercept-1512.2872269172810.6404943865-1.86554611740.0831977997-3250.9397144212226.3652605867-3250.9397144212226.3652605867

    time2.32984932852.05343887921.13460855940.2755930382-2.07434296136.7340416183-2.07434296136.7340416183

    poten0.03394804530.00940568543.60931116070.00284542870.01377483850.05412125210.01377483850.0541212521

    adv0.1619321780.05065881033.19652548190.00646506020.05327973940.27058461660.05327973940.2705846166

    share177.761072878679.6127643022.23282126220.04240412877.0085239382348.51362181897.0085239382348.5136218189

    change267.9818019415213.11447130851.25745473920.2291610061-189.1036856814725.0672895644-189.1036856814725.0672895644

    accts6.2652735.29546159251.18314010790.2564561576-5.092372632217.6229186322-5.092372632217.6229186322

    work20.034613321935.66565368020.56173408460.5831787873-56.460673946496.5299005903-56.460673946496.5299005903

    rating70.9695060286157.62872261490.45023206970.6594363544-267.1107805772409.0497926343-267.1107805772409.0497926343

    n_s-251.9221935333298.0992982251-0.84509488960.4122680853-891.2821687273387.4377816607-891.2821687273387.4377816607

    cons-50.0451517787272.582364307-0.18359644030.8569625832-634.67669811534.5863945526-634.67669811534.5863945526

    RESIDUAL OUTPUT

    ObservationPredicted salesResidualsStandard Residuals

    13450.152431178219.7275688220.6159121561

    23811.8433915345-337.8933915345-0.9471394438

    32620.4111172274-325.3111172274-0.9118704253

    44808.7144226483-133.1544226483-0.3732414098

    55400.4927189276725.46728107242.0335368915

    61926.3381155952208.60188440480.5847260637

    75247.0681255713-215.4081255713-0.6038044465

    83028.6713531804338.77864681960.9496208779

    96316.7828436323202.66715636770.5680905947

    104112.9142458212763.45575417882.14002131

    112650.5911268467-182.3211268467-0.5110592128

    122227.4791057133305.83089428670.8572659613

    132498.1475443203-90.0375443203-0.2523817032

    142128.0983979255209.28160207450.5866313611

    154713.9135216818-126.9635216818-0.3558878697

    162805.7173117825-76.4773117825-0.2143713975

    173289.807902031-0.407902031-0.0011433787

    182877.2866431305-76.5066431305-0.2144536154

    193650.4005149506-386.2005149506-1.0825477801

    204036.1323641542-582.5123641542-1.6328239925

    211297.242304837444.2076951631.2451460723

    222613.7423807423-577.9923807423-1.6201541543

    231749.7297256702-171.7297256702-0.4813707546

    244507.5675303888-340.1275303888-0.9534018955

    252594.9448605092205.02513949080.5747001908

    Sheet4

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    time

    Residuals

    time Residual Plot

    Sheet3

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    poten

    Residuals

    poten Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    adv

    Residuals

    adv Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    share

    Residuals

    share Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    change

    Residuals

    change Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    accts

    Residuals

    accts Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    work

    Residuals

    work Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    rating

    Residuals

    rating Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    n_s

    Residuals

    n_s Residual Plot

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    cons

    Residuals

    cons Residual Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    time

    sales

    time Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    poten

    sales

    poten Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    adv

    sales

    adv Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    share

    sales

    share Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    change

    sales

    change Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    accts

    sales

    accts Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    work

    sales

    work Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    rating

    sales

    rating Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    n_s

    sales

    n_s Line Fit Plot

    3669.880

    3473.950

    2295.10

    4675.560

    6125.960

    2134.940

    5031.660

    3367.450

    6519.450

    4876.370

    2468.270

    2533.310

    2408.110

    2337.380

    4586.950

    2729.240

    3289.40

    2800.780

    3264.20

    3453.620

    1741.450

    2035.750

    15780

    4167.440

    2799.970

    sales

    Predicted sales

    cons

    sales

    cons Line Fit Plot

    salestimepotenadvsharechangeacctsworkratingn_scons

    3669.8843.174065.14582.92.510.3474.8615.054.901

    3473.95108.1358117.35539.85.510.15107.3219.975.110

    2295.113.8221118.52950.410.91-0.7296.7517.342.900

    4675.56186.1868521.32243.18.270.17195.1213.43.401

    6125.96161.7957805.17747.19.150.5180.4417.644.610

    2134.948.9437806.9402.45.510.15104.8816.224.510

    5031.66365.0450935.33140.68.540.55256.118.84.611

    3367.45220.3235602.12086.27.07-0.49126.8319.862.300

    6519.45127.6446176.88846.212.541.24203.2517.424.900

    4876.37105.6942053.25673.18.850.31119.5121.412.800

    2468.2757.7236829.72761.85.380.37116.2616.323.100

    2533.3123.5833612.71991.85.43-0.65142.2814.514.201

    2408.1113.8221412.81971.58.480.6489.4319.354.300

    2337.3813.8220416.91734.77.81.0184.5520.024.210

    4586.9586.993627210694.210.340.11119.5115.265.510

    2729.24165.8523093.38618.65.150.0480.4915.873.610

    3289.4116.2626878.67747.96.640.68136.587.813.410

    2800.7842.28395724565.85.450.6678.86164.201

    3264.252.8451866.16022.76.31-0.1136.5817.443.610

    3453.62165.0458749.83721.16.35-0.03138.2117.983.100

    1741.4510.5723990.88617.37-1.6375.6120.991.601

    2035.7513.8225694.93571.58.39-0.43102.4421.663.401

    15788.1323736.32845.55.150.0476.4221.462.701

    4167.4458.4434314.35060.112.880.22136.5824.782.800

    2799.9721.1422809.535529.14-0.7488.6224.963.901

  • Sheet1

    123456

    O51578121360

    E10101010101060

    2.502.500.900.400.400.907.6011.07

    3.113247131.9844674171

    YMU

    Karlar5035.78767123292548.801369863400475

    Konur519.21232876715026.198630137200255

    5575600730

    5.64413056311.6083874069

    10.51357653921.6234667383

    16.15770710233.231854145249.38956124715.9914763568

    Sheet2

    Sheet4

    SUMMARY OUTPUT

    Regression Statistics

    Multiple R0.9623839618

    R Square0.9261828899

    Adjusted R Square0.8734563826

    Standard Error467.0973224143

    Observations25

    ANOVA

    dfSSMSFSignificance F

    Regression1038325030.20636413832503.0206364117.56579258430.0000030187

    Residual143054518.72049195218179.908606568

    Total2441379548.926856

    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95,0%Upper 95,0%

    Intercept-1512.29810.64-1.870.08-3250.94226.37-3250.94226.37

    time2.332.051.130.28-2.076.73-2.076.73

    poten0.030.013.610.000.010.050.010.05

    adv0.160.053.200.010.050.270.050.27

    share177.7679.612.230.047.01348.517.01348.51

    change267.98213.111.260.23-189.10725.07-189.10725.07

    accts6.275.301.180.26-5.0917.62-5.0917.62

    work20.0335.670.560.58-56.4696.53-56.4696.53

    rating70.97157.630.450.66-267.11409.05-267.11409.05

    n_s-251.92298.10-0.850.41-891.28387.44-891.28387.44

    cons-50.05272.58-0.180.86-634.68534.59-634.68534.59

    RESIDUAL OUTPUT

    ObservationPredicted salesResidualsStandard Residuals

    13450.152431178219.7275688220.6159121561

    23811.8433915345-337.8933915345-0.9471394438

    32620.4111172274-325.3111172274-0.9118704253

    44808.7144226483-133.1544226483-0.3732414098

    55400.4927189276725.46728107242.0335368915

    61926.3381155952208.60188440480.5847260637

    75247.0681255713-215.4081255713-0.6038044465

    83028.6713531804338.77864681960.9496208779

    96316.7828436323202.66715636770.5680905947

    104112.9142458212763.45575417882.14002131

    112650.5911268467-182.3211268467-0.5110592128

    122227.4791057133305.83089428670.8572659613

    132498.1475443203-90.0375443203-0.2523817032

    142128.0983979255209.28160207450.5866313611

    154713.9135216818-126.9635216818-0.3558878697

    162805.7173117825-76.4773117825-0.2143713975

    173289.807902031-0.407902031-0.0011433787

    182877.2866431305-76.5066431305-0.2144536154

    193650.4005149506-386.2005149506-1.0825477801

    204036.1323641542-582.5123641542-1.6328239925

    211297.242304837444.2076951631.2451460723

    222613.7423807423-577.9923807423-1.6201541543

    231749.7297256702-171.7297256702-0.4813707546

    244507.5675303888-340.1275303888-0.9534018955

    252594.9448605092205.02513949080.5747001908

    Sheet4

    43.1

    108.13

    13.82

    186.18

    161.79

    8.94

    365.04

    220.32

    127.64

    105.69

    57.72

    23.58

    13.82

    13.82

    86.99

    165.85

    116.26

    42.28

    52.84

    165.04

    10.57

    13.82

    8.13

    58.44

    21.14

    time

    Residuals

    time Residual Plot

    Sheet3

    74065.1

    58117.3

    21118.5

    68521.3

    57805.1

    37806.9

    50935.3

    35602.1

    46176.8

    42053.2

    36829.7

    33612.7

    21412.8

    20416.9

    36272

    23093.3

    26878.6

    39572

    51866.1

    58749.8

    23990.8

    25694.9

    23736.3

    34314.3

    22809.5

    poten

    Residuals

    poten Residual Plot

    4582.9

    5539.8

    2950.4

    2243.1

    7747.1

    402.4

    3140.6

    2086.2

    8846.2

    5673.1

    2761.8

    1991.8

    1971.5

    1734.7

    10694.2

    8618.6

    7747.9

    4565.8

    6022.7

    3721.1

    861

    3571.5

    2845.5

    5060.1

    3552

    adv

    Residuals

    adv Residual Plot

    2.51

    5.51

    10.91

    8.27

    9.15

    5.51

    8.54

    7.07

    12.54

    8.85

    5.38

    5.43

    8.48

    7.8

    10.34

    5.15

    6.64

    5.45

    6.31

    6.35

    7.37

    8.39

    5.15

    12.88

    9.14

    share

    Residuals

    share Residual Plot

    0.34

    0.15

    -0.72

    0.17

    0.5

    0.15

    0.55

    -0.49

    1.24

    0.31

    0.37

    -0.65

    0.64

    1.01

    0.11

    0.04

    0.68

    0.66

    -0.1

    -0.03

    -1.63

    -0.43

    0.04

    0.22

    -0.74

    change

    Residuals

    change Residual Plot

    74.86

    107.32

    96.75

    195.12

    180.44

    104.88

    256.1

    126.83

    203.25

    119.51

    116.26

    142.28

    89.43

    84.55

    119.51

    80.49

    136.58

    78.86

    136.58

    138.21

    75.61

    102.44

    76.42

    136.58

    88.62

    accts

    Residuals

    accts Residual Plot

    15.05

    19.97

    17.34

    13.4

    17.64

    16.22

    18.8

    19.86

    17.42

    21.41

    16.32

    14.51

    19.35

    20.02

    15.26

    15.87

    7.81

    16

    17.44

    17.98

    20.99

    21.66

    21.46

    24.78

    24.96

    work

    Residuals

    work Residual Plot

    219.727568822

    -337.8933915345

    -325.3111172274

    -133.1544226483

    725.4672810724

    208.6018844048

    -215.4081255713

    338.7786468196

    202.6671563677

    763.4557541788

    -182.3211268467

    305.8308942867

    -90.0375443203

    209.2816020745

    -126.9635216818

    -76.4773117825

    -0.407902031

    -76.5066431305

    -386.2005149506

    -582.5123641542

    444.207695163

    -577.9923807423

    -171.7297256702

    -340.1275303888

    205.0251394908

    rating

    Residuals

    rating Residual Plot

    219.727568822

    -337.8933915345

    -325.3111172274

    -133.1544226483

    725.4672810724

    208.6018844048

    -215.4081255713

    338.7786468196

    202.6671563677

    763.4557541788

    -182.3211268467

    305.8308942867

    -90.0375443203

    209.2816020745

    -126.9635216818

    -76.4773117825

    -0.407902031

    -76.5066431305

    -386.2005149506

    -582.5123641542

    444.207695163

    -577.9923807423

    -171.7297256702

    -340.1275303888

    205.0251394908

    n_s

    Residuals

    n_s Residual Plot

    219.727568822

    -337.8933915345

    -325.3111172274

    -133.1544226483

    725.4672810724

    208.6018844048

    -215.4081255713

    338.7786468196

    202.6671563677

    763.4557541788

    -182.3211268467

    305.8308942867

    -90.0375443203

    209.2816020745

    -126.9635216818

    -76.4773117825

    -0.407902031

    -76.5066431305

    -386.2005149506

    -582.5123641542

    444.207695163

    -577.9923807423

    -171.7297256702

    -340.1275303888

    205.0251394908

    cons

    Residuals

    cons Residual Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    time

    sales

    time Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    poten

    sales

    poten Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    adv

    sales

    adv Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    share

    sales

    share Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    change

    sales

    change Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    accts

    sales

    accts Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    work

    sales

    work Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    rating

    sales

    rating Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    n_s

    sales

    n_s Line Fit Plot

    3669.883450.152431178

    3473.953811.8433915345

    2295.12620.4111172274

    4675.564808.7144226483

    6125.965400.4927189276

    2134.941926.3381155952

    5031.665247.0681255713

    3367.453028.6713531804

    6519.456316.7828436323

    4876.374112.9142458212

    2468.272650.5911268467

    2533.312227.4791057133

    2408.112498.1475443203

    2337.382128.0983979255

    4586.954713.9135216818

    2729.242805.7173117825

    3289.43289.807902031

    2800.782877.2866431305

    3264.23650.4005149506

    3453.624036.1323641542

    1741.451297.242304837

    2035.752613.7423807423

    15781749.7297256702

    4167.444507.5675303888

    2799.972594.9448605092

    sales

    Predicted sales

    cons

    sales

    cons Line Fit Plot

    salestimepotenadvsharechangeacctsworkratingn_scons

    3669.8843.174065.14582.92.510.3474.8615.054.901

    3473.95108.1358117.35539.85.510.15107.3219.975.110

    2295.113.8221118.52950.410.91-0.7296.7517.342.900

    4675.56186.1868521.32243.18.270.17195.1213.43.401

    6125.96161.7957805.17747.19.150.5180.4417.644.610

    2134.948.9437806.9402.45.510.15104.8816.224.510

    5031.66365.0450935.33140.68.540.55256.118.84.611

    3367.45220.3235602.12086.27.07-0.49126.8319.862.300

    6519.45127.6446176.88846.212.541.24203.2517.424.900

    4876.37105.6942053.25673.18.850.31119.5121.412.800

    2468.2757.7236829.72761.85.380.37116.2616.323.100

    2533.3123.5833612.71991.85.43-0.65142.2814.514.201

    2408.1113.8221412.81971.58.480.6489.4319.354.300

    2337.3813.8220416.91734.77.81.0184.5520.024.210

    4586.9586.993627210694.210.340.11119.5115.265.510

    2729.24165.8523093.38618.65.150.0480.4915.873.610

    3289.4116.2626878.67747.96.640.68136.587.813.410

    2800.7842.28395724565.85.450.6678.86164.201

    3264.252.8451866.16022.76.31-0.1136.5817.443.610

    3453.62165.0458749.83721.16.35-0.03138.2117.983.100

    1741.4510.5723990.88617.37-1.6375.6120.991.601

    2035.7513.8225694.93571.58.39-0.43102.4421.663.401

    15788.1323736.32845.55.150.0476.4221.462.701

    4167.4458.4434314.35060.112.880.22136.5824.782.800

    2799.9721.1422809.535529.14-0.7488.6224.963.901

  • Raflttur - Fjldi raa me k stkum, sem hgt er a mynda r n stkum er

  • Hr skal finna hve marga vegu hgt er a skipa 3 manna stjrn sem valin er r hpi 5 mannna, ar sem mli skiptir hver er ritari, gjaldkeri og hver formaur

  • Veljum einhverja 3 menn af 5.

    Flttur - Fjldi hpa me k stkum sem hgt er amynda r n stkum