excel modul statistik.xlsx

download excel modul statistik.xlsx

of 87

Transcript of excel modul statistik.xlsx

  • 8/18/2019 excel modul statistik.xlsx

    1/87

    No. Nilai statistika

    1 95 Nilai statistika

    2 75

    3 52 Mean

    4 80Standard Error5 75 Median

    6 68 Mode

    7 80 Standard Deviation

    8 78 Sample Variance

    9 97 Kurtoi

    10 85 S!e"ne

    11 64 #an$e

    12 100 Minimum

    13 70 Ma%imum

    14 67 Sum

    15 90 &ount

    16 68 'ar$et(1)

    17 86 Smallet(1)

    18 89 &on*dence 'evel(95+0,)

    19 75

    20 60

    ran$e

    -!

    p

    Nilai Statis

    52

    63

    74

    85

    96

  • 8/18/2019 excel modul statistik.xlsx

    2/87

    77+7 BIN Frequency Cumulative % BIN Frequency  

    2+868247 62 2 10+00, 84 6

    76+5 73 5 35+00, 73 5

    75 84 6 65+00, 95 5

    12+82719 95 5 90+00, 62 2

    164+5368 106 2 100+00, 106 2

    .0+533098 More 0 100+00, More 0

    .0+025267

    48

    52

    100

    1554

    20

    100

    52

    6+00331

    48

    5+31942 5

    9+6 10

    tika Frekuensi /

    . 62 2 62

    . 73 5 73

    . 84 6 84

    . 95 5 95

    . 106 2 106

    BIN Frekuensi

    62 273 5

    84 6

    95 5

    106 2

  • 8/18/2019 excel modul statistik.xlsx

    3/87

    Cumulative %

    30+00,

    55+00,

    80+00,

    90+00,

    100+00,

    100+00,0

    2

    4

    6

    8

    0+00,

    50+00,

    100+00,

    150+00,

    Histogram

     

    bin range

    Frequency

    62 73 84 95 106

    0

    2

    4

    6

    8

    Histogram

    Bin Range

    Frekuensi

    0

    2

    4

    6

    8

    0+00,

    50+00,100+00,

    150+00,

    Histogram

     

    BIN

    Frequency

    0

    2

    4

    6

    8

    0+00,

    50+00,

    100+00,

    150+00,

    Histogram

     

    BIN

    Frequency

    0

    2

    4

    6

    8

    0+00,

    50+00,

    100+00,

    150+00,

    Histogram

     

    BIN

    Frequency

  • 8/18/2019 excel modul statistik.xlsx

    4/87

    reuenc

    &umulative ,

    re!ueni

    reuenc

    &umulative ,

    reuenc

    &umulative ,

    reuenc

    &umulative ,

  • 8/18/2019 excel modul statistik.xlsx

    5/87

    No Emiten/perusahaan

    1 /an! $ro ia$a -!+ (#)

    2 /an! &/ /umi utra -!+ (//)

    3 /an! &apital ndoneia -!+ (/&)

    4 /an! E!onomi #a:ar;a -!+ (/EK)

    5 /an! /u!opin -!+ (//K)

    6 /an! uantara ara:an$an -!+ (//)

    7 /an! a-un$an e$ara (erero) -!+ (//)

    8 /an! Mutiara -!+ (/&&)

    9 /an! undi ndoneia -!+ (/EKS)

    10 /an!

  • 8/18/2019 excel modul statistik.xlsx

    6/87

  • 8/18/2019 excel modul statistik.xlsx

    7/87

    1350 Harga saham per lembar bin range

    2225 983

    1675 Mean 1391+75 1532

    1525 Standard Error 146+36934 2081

    1925 Median 1400 2630

    900 Mode 1400 3179

    1575 Standard Deviation 654+583586 More

    3175 Sample Variance 428479+671

    1125 Kurtoi 1+52328789

    800 S!e"ne 0+86908443

    1400 #an$e 2740

    1900 Minimum 435

    600 Ma%imum 3175

    1900 Sum 27835

    975 &ount 20

    1475 'ar$et(1) 3175

    525 Smallet(1) 435

    950 &on*dence 'evel(95+0,) 306+354548

    1400

    435

    ran$e 2740-! 5+31941959 5

    p 548

    Harga saham Frekuensi

    435 . 983 7

    984 . 1532 6

    1533 . 2081 5

    2082 . 2630 1

    2631 . 3179 1

    -in ran$e

    983

    1532

    2081

    2630

    3179

    Hargasaham per

    lembar

    Freque

  • 8/18/2019 excel modul statistik.xlsx

    8/87

    bin range Frequency mulative bin range

    358 8 40+00, 358

    672 2 50+00, 1614

    986 2 60+00, 672

    1300 2 70+00, 986

    1614 6 100+00, 1300More 0 100+00, More

  • 8/18/2019 excel modul statistik.xlsx

    9/87

    Frequency Cumulative % bin range Frequency Cumulative %

    7 35+00, 983 7 35+00,

    6 65+00, 1532 6 65+00,

    5 90+00, 2081 5 90+00,

    1 95+00, 2630 1 95+00,

    1 100+00, 3179 1 100+00,

    0 100+00, More 0 100+00,

    983 1532 2081 2630 3179 More

    0

    2

    4

    6

    8

    0+00,

    50+00,

    100+00,

    150+00,

    Histogram

    reuenc

    &umulative ,

    bin range

    cy

  • 8/18/2019 excel modul statistik.xlsx

    10/87

    Frequency Cumulative %

    8 40+00,

    6 70+00,

    2 80+00,

    2 90+00,

    2 100+00,0 100+00,

  • 8/18/2019 excel modul statistik.xlsx

    11/87

    Nilai Statistika Frekuensi // /

    52 . 62 2 51+5 62+5

    63 . 73 5 62+5 73+5

    74 . 84 6 73+5 84+5

    85 . 95 5 84+5 95+5

    96 . 106 2 95+5 106+5

    rata.rata > 76+65

    im+ /a!u > 12+97

  • 8/18/2019 excel modul statistik.xlsx

    12/87

    i ?1 ?2 p1 p2 Ei

    2 .10+00 .1+09 0+00 0+14 0+14 2+75

    5 .1+09 .0+24 0+14 0+40 0+27 5+33

    6 .0+24 0+61 0+40 0+73 0+32 6+47

    5 0+61 1+45 0+73 0+93 0+20 3+99

    2 1+45 10+00 0+93 1+00 0+07 1+46

    20+00

    57 68 79 9

    02

    4

    6

    8

    Histogram

    Nilai Tengah

    Frekuensi

  • 8/18/2019 excel modul statistik.xlsx

    13/87

    // / ilai en$a: i Ei

    51+5 62+5 57 2 3

    62+5 73+5 68 5 5 1

    73+5 84+5 79 6 6

    84+5 95+5 90 5 4

    95+5 106+5 101 2 2

    20 20 2

    i Ei

    7 8 3

    6 6

    7 6

    ilai ten$a: re!ueni

    57 268 5

    79 6

    90 5

    101 2

    4

    5

    101

    re!ueni

  • 8/18/2019 excel modul statistik.xlsx

    14/87

    MEM/@ AESS

    Ao B Data /erditri-ui ormal

    Ai B Data tida! -erditri-ui normal

     # C

    @

  • 8/18/2019 excel modul statistik.xlsx

    15/87

    Harga Saham Frekuensi // / i

    435 . 983 7 434+5 983+5 7

    984 . 1532 6 983+5 1532+5 6

    1533 . 2081 5 1532+5 2081+5 5

    2082 . 2630 1 2081+5 2630+5 1

    2631 . 3179 1 2630+5 3179+5 1

    rata.rata > 1391+75

    im+ /a!u > 654+58

  • 8/18/2019 excel modul statistik.xlsx

    16/87

    ?1 ?2 p1 p2 Ei //

    .10+00 .0+62 0+00 0+27 0+27 5+33 434+5

    .0+62 0+22 0+27 0+59 0+32 6+37 983+5

    0+22 1+05 0+59 0+85 0+27 5+38 1532+5

    1+05 1+89 0+85 0+97 0+12 2+34 2081+5

    1+89 10+00 0+97 1+00 0+03 0+58 2630+5

    20+00

    709 1258 1807 2356 2905

    0

    2

    4

    6

    8

    Histogram

    Nilai Tengah

    Frekuensi

  • 8/18/2019 excel modul statistik.xlsx

    17/87

    / ilai en$a: i Ei   nalisis Hasil

    983+5 709 7 5

    1532+5 1258 6 6 1 MEM/@ A

    2081+5 1807 5 5 Ao B Data /erdit

    2630+5 2356 1 2 Ai B Data tida! -e

    3179+5 2905 1 1

    20 20 2 # C

    i Ei

    7 5 3 @

  • 8/18/2019 excel modul statistik.xlsx

    18/87

    SS

    i-ui ormal

    rditri-ui normal

    -ilit

      un$ c:i uare ta-el ma!a Ao diterima

      @@S

    a Data /erditri-ui ormal

  • 8/18/2019 excel modul statistik.xlsx

    19/87

    Observasi

    Jenis Pekerjaan Kepuasan Kerja

    Sangat Puas Puas Kurang Puas

    Bagian Produksi 28 47 20

    Bagian Pemasaran 37 39 !

    Bagian Operasiona" 3 2# 29

    $ota" 78 !#

    %&pe'ted

    Jenis Pekerjaan Kepuasan Kerja

    Sangat Puas Puas Kurang PuasBagian Produksi 28(34 40(33 23(!2

    Bagian Pemasaran 2!(#2 37(74 22(0

    Bagian Operasiona" 23(4 32(93 9(28

    $ota" 78 !#

    nalisis Hasil

    1 MEM/@ AESS

    rtina ta-el !ontin$eni di ata adala: independen at

    rtina ta-el !ontin$eni di ata adala: dependen ata

    2

    3 @F11>F12G+>F13

    A1 >F11

    HF12

    G+HF13

    α > 5,

  • 8/18/2019 excel modul statistik.xlsx

    20/87

     ;i!a c:i uare :itun$ c:i uare ta-el ma!a Ao diter

    5 EM/' KE@@S

    Ao Di tola!

    !eimpulan

    Ao ditola! rtina ta-el !ontin$eni di ata adala: depe

  • 8/18/2019 excel modul statistik.xlsx

    21/87

    $ota"

    $idak Puas

    4 09

    0 02

    22 89

    4! 300

    $ota"

    $idak Puas!(7 09

    #(!4 02

    3(!# 89

    4! 300

      au !epuaan !er;a di uatu perua:aan tida! -er$antun$ pada ;eni pe!er;aan

      !epuaan !er;a di uatu perua:aan -er$antun$ pada ;eni pe!er;aan

  • 8/18/2019 excel modul statistik.xlsx

    22/87

    ima

    nden atau !epuaan !er;a di uatu perua:aan -er$antun$ pada ;eni pe!er;aan

  • 8/18/2019 excel modul statistik.xlsx

    23/87

    Observasi

    )PK $ingkat peng*asi"an +jutaan,

    -.# .!/3.# 3.#/#.# #.#

    3.# 23 3 3 20

    2.7#/3.# ! #2 40 9

    -2.7# !3 4# 2# #

    $ota" 47 28 9! #4

    Observasi

    )PK $ingkat peng*asi"an +jutaan,

    -.# .!/3.# 3.#/#.# #.#

    3.# 3!(32 3(!2 23(72 3(34

    2.7#/3.# #9(49 #(80 38(8# 2(8#

    -2.7# #(9 44(#7 33(43 8(80$ota" 47 28 9! #4

    nalisis Hasil

    1 MEM/@ AESS

    rtina ta-el !ontin$eni di ata adala: independen atau in$!at

    rtina ta-el !ontin$eni di ata adala: dependen atau in$!at p

    2

    3 @

  • 8/18/2019 excel modul statistik.xlsx

    24/87

    Ao Di tola!

    !eimpulan

    Ao ditola! rtina ta-el !ontin$eni di ata adala: dependen atau

  • 8/18/2019 excel modul statistik.xlsx

    25/87

    $ota"

    0#

    72

    48

    42#

    $ota"

    0#

    72

    4842#

    pen$:ailan tida! -er$antun$ pada nilai K 

      en$:ailan -er$antun$ pada nilai K 

  • 8/18/2019 excel modul statistik.xlsx

    26/87

      tin$!at pen$:ailan -er$antun$ pada nilai K 

  • 8/18/2019 excel modul statistik.xlsx

    27/87

    No Ichiko Multimax Platinum

    1 25 28

    2 26 26

    3 26 27

    4 24 29

    5 28 26

    6 27 24

    7 21 20

    8 20 28

    9 24 29

    10 24 26

    11 25 24

    12 21 23

    13 23 28

    14 22 2015 26

    16 24

    17 26

    18 28

    19 20

    20 24

  • 8/18/2019 excel modul statistik.xlsx

    28/87

    VARIANS POPULASI

    Ichiko Multimax Platinum

    !.""#### $.%$&&!!'#(

  • 8/18/2019 excel modul statistik.xlsx

    29/87

    ?.etB "o Sample Ior Mean

    Ichiko Multimax Platinum

    Mean 24+2 25+5714285714

    Kno"n Variance 5+66 8+387755102

    -ervation 20 14

    Apot:ei?ed Mean DiJerence 0

    ? .1+460186

    (>?) one.tail 0+07212

    ? &ritical one.tail 1+644854

    (>?) t"o.tail 0+144239

    ? &ritical t"o.tail 1+959964

  • 8/18/2019 excel modul statistik.xlsx

    30/87

    'SS AS'

    1 Mem-uat Aipotei

    Ao B L1>L2 artina tida! ada per-edaan antar -iaa -iaa promoi pada main

    A1 B L1>L2 artna ada per-edaan antara -iaa promoi untu! !edua mer!

    2 araI ata Si$ni*!an

    0+05 N 0+025

    3 @;i Statiti! >norminv() >a-

    ? :itun$ > .1+460186 1+46

    ? ta-el > 1+959964 .1+96 1+96

    4 Kaida: Keputuan 

  • 8/18/2019 excel modul statistik.xlsx

    31/87

    $.main$ mer!

    .main$ mer!

  • 8/18/2019 excel modul statistik.xlsx

    32/87

    Hari PT. Lippo Cikarang PT. Lippo Karawaci

    1 200 210

    2 210 280

    3 225 250

    4 180 210

    5 175 250

    6 200 210

    7 210 210

    8 175 225

    9 210 200

    10 208 209

    11 205 180

    12 222 225

  • 8/18/2019 excel modul statistik.xlsx

    33/87

    VARIANS POPULASI

    PT. Lippo Cikarang PT. Lippo Karawaci

    ($%.'!'!'! &('.)#'!'!

  • 8/18/2019 excel modul statistik.xlsx

    34/87

    ?.etB "o Sample Ior Mean

    P! "ippo Cikarang P! "ippo #ara$aci

    Mean 201+6666666667 221+5833333333

    Kno"n Variance 283+151515 721+901515

    -ervation 12 12

    Apot:ei?ed Mean DiJerence 0

    ? .2+1762700701

    (>?) one.tail 0+0147675361

    ? &ritical one.tail 1+644853627

    (>?) t"o.tail 0+0295350722

    ? &ritical t"o.tail 1+9599639845

  • 8/18/2019 excel modul statistik.xlsx

    35/87

    'SS AS'

    1 Mem-uat Aipotei

    Ao B L1>L2 artina tida! ada per-edaan antara rata.rata :ar$a

    A1 B L1>L2 artna ada per-edaan antara rata.rata :ar$a a:a

    2 araI ata Si$ni*!an

    0+05 N 0+025

    3 @;i Statiti! >norminv>a-

    ? :itun$ > .2+17627 2+18

    ? ta-el > 1+959964 .1+96 1+96

    4 Kaida: Keputuan 

  • 8/18/2019 excel modul statistik.xlsx

    36/87

    a:am pada + 'ippo &i!aran$ den$an + 'ippo Kara"aci

    pada + 'ippo &i!aran$ den$an + 'ippo Kara"aci

    + 'ippo &i!aran$ den$an + 'ippo Kara"aci

  • 8/18/2019 excel modul statistik.xlsx

    37/87

    %miten 1arga sesuda* kebijakan

    )O 8(47 8(44!

    P5S 3(!4 3(24

    $B6S #(#8 #(38

    S6 4(8# 4(803

    6S1 2(228 2(222

    :$) (08# (082

    B55 70 72

    S)P 9(#4! 9(03

    5O 4(37# 4(2#

    BB5 0 9(998

    BB$ (! (#9

    BB5 #(9# #(93#

     )SP (# (47#

    1

    2

    3

    4

    5

    1arga sebe"umkebijakan

  • 8/18/2019 excel modul statistik.xlsx

    38/87

    t.etB aired "o Sample Ior Mean

    Harga sebelum kebiakan

    Mean 10+6720769231

    Variance 332+2886385769

    -ervation 13

    earon &orrelation 0+9999109019

    Apot:ei?ed Mean DiJerence 0

    dI 12

    t Stat .0+3497595504

    (>t) one.tail 0+3662904165

    t &ritical one.tail 1+7822875556

    (>t) t"o.tail 0+732580833

    t &ritical t"o.tail 2+1788128297

    'SS A

    Mem-uat Aipotei

    Ao B L1>L2 artina tida! ada per-edaan antara rata.rata :ar$a a:am

    A1 B L1L2 artina ada per-edaan antara rata.rata :ar$a a:am e-e

     araI ata Si$ni*!an

    0+05

    @;i Statiti!t :itun$ > .0+3497595504

    t ta-el > 1+7822875556

    en$am-ilan Keputuan

     ;i!a t :itun$ .t ta-el ma!a Ao ditola!

    Keputuan

    Ao diterima

    KeimpulanAo diterima artina tida! ada per-edaan antara rata.rata e-elum dan

    α  >

  • 8/18/2019 excel modul statistik.xlsx

    39/87

    Harga sesu&ah kebiakan

    10+7306153846

    352+6651339231

    13

      S'

    e-elum dan euda: !e-i;a!an

    lum dan euda: Ke-i;a!an

    1+7822875556 .1+782288

    euda: !e-i;a!an

  • 8/18/2019 excel modul statistik.xlsx

    40/87

    Perusa*aan

    5";a retai"indo 7#0 9#0

    5neka tambang 87# 900

    ankos aboratories 40# 200

    1+78 1+78

    4 en$am-ilan Keputuan

     ;i!a t :itun$ .t ta-el ma!a Ao ditola!

    5 Keputuan

    Ao ditola!

    Keimpulan

    Ao ditola! artina ada per-edaan antara rata.rata :

    1arga sa*am sebe"um"edakan S:

    1arga sa*am sesuda*"edakan S:

    α  >

  • 8/18/2019 excel modul statistik.xlsx

    41/87

    t.etB aired "o Sample Ior Mean

    Harga saham sebelum le&akan '(N

    Mean 540+7692307692

    Variance 69107+6923076923

    -ervation 13

    earon &orrelation 0+66846301

    Apot:ei?ed Mean DiJerence 0

    dI 12

    t Stat .3+5199723618

    (>t) one.tail 0+0021118228

    t &ritical one.tail 1+7822875556

    (>t) t"o.tail 0+0042236455

    t &ritical t"o.tail 2+1788128297

    'SS AS'

      .rata :ar$a a:am e-elum dan euda: leda!an S@

    :ar$a a:am e-elum dan euda: leda!an S@

    .1+78

      r$a a:am e-elum dan euda: leda!an S@

  • 8/18/2019 excel modul statistik.xlsx

    42/87

    Harga saham sesu&ah le&akan '(N

    817+6923076923

    145340+064102564

    13

  • 8/18/2019 excel modul statistik.xlsx

    43/87

     o Pertanian Peternakan )ndustri Perdagangan

    4(3 (# #(# 4(7

    2 8( 2( 2(7 (!

    3 7(8 ( 8(2 4(3

    4 7(3 (9 4(7 (4

    # 9(# (! 8( 2(!

    ! (# 4(9 4(2

    7 3(! 3(7 !(

    8 4(2 (4

    9 9(2

    0 2(7

    1

    2

    3

    4

    5

  • 8/18/2019 excel modul statistik.xlsx

    44/87

    novaB Sin$le actor

    S@MM#C

    )roups Count 'um *verage +ariance

    ertanian 10 158+2 15+82 8+281778

    eterna!an 5 58+2 11+64 0+148

    ndutri 8 119+2 14+9 5+722857

    erda$an$an 7 94+9 13+55714 3+022857

    V

    'ource o, +ariation '' &, M' F P-value F crit  

    /et"een roup 65+14986 3 21+71662 4+235001 0+014533 2+975154

    =it:in roup 133+3251 26 5+12789

     otal 198+475 29

    'SS AS'

    Mem-uat Aipotei

    Ao B L1>L2>L3>L4 artina rata.rata tin$!at !euntun$an invetai di etiap e!tor tida!

    A1 B L1L2 artina edi!itna ada atu rata.rata tin$!at !euntun$an invetai di etiap

     araI ata Si$ni*!an

    0+05

    @;i Statiti!

    :itun$ > 4+24

    ta-el > 2+98 2+98

    en$am-ilan Keputuan

     ;i!a :itun$ ta-el ma!a Ao diterima

    Keputuan

    Ao ditola!

    Keimpulan

    Ao ditola! artina edi!itna ada atu rata.rata tin$!at !euntun$an invetai di etiap e

    α  >

  • 8/18/2019 excel modul statistik.xlsx

    45/87

    -er-eda

    e!tor an$ -er-eda

      tor an$ -er-eda

  • 8/18/2019 excel modul statistik.xlsx

    46/87

    Sanpe"

    39 49 #0

    2 43 4! ##

    3 4# 44 #

    4 3# 4# #3

    # 48 3! 3

    ! 30 3 4#

    7 4 4! 3#

    8 34 33 39

    9 4# 39 48

    Pendapatan dikota kara=a'i

    Pendapatan di kotaBintaro

    Pendapatan di kota+BS,

  • 8/18/2019 excel modul statistik.xlsx

    47/87

    novaB Sin$le actor

    3

    #2 S@MM#C

    34 )roups Count 'um

    48 endapatan di !ota !ara"aci 9 360

    34 endapatan di !ota /intaro 9 369

    44 endapatan di !ota (/SD) 9 407

    32 endapatan di Kota &i!aran$ 9 350

    3#

    40

    V

    'ource o, +ariation '' &,  

    /et"een roup 206+7778 3=it:in roup 1638+444 32

     otal 1845+222 35

    'SS AS'

    1 Mem-uat Aipotei

    Ao B L1>L2>L3>L4 artina rata.rata tin$!at !euntun$

    A1 B L1L2 artina edi!itna ada atu rata.rata tin$!

    2 araI ata Si$ni*!an0+05

    3 @;i Statiti!

    :itun$ > 1+35

    ta-el > 2+90 2+90

    4 en$am-ilan Keputuan

     ;i!a :itun$ ta-el ma!a Ao diterima

    5 KeputuanAo diterima

    Keimpulan

    Ao diterima artina rata.rata tin$!at !euntun$an inve

    Pendapatan diKota ikarang

    α  >

  • 8/18/2019 excel modul statistik.xlsx

    48/87

     *verage +ariance

    40 35+75

    41 41+5

    45+22222 70+69444

    38+88889 56+86111

    M' F P-value F crit  

    68+92593 1+346173 0+27683 2+9011251+20139

    an invetai di etiap e!tor tida! -er-eda

    at !euntun$an invetai di etiap e!tor an$ -er-eda

    tai di etiap e!tor tida! -er-eda

  • 8/18/2019 excel modul statistik.xlsx

    49/87

    NoJumlah Produksi Durian (X) Jumlah Pupuk Organik (Y)

    *+g, *+g,

    1 300 3(48

    2 320 3(48

    3 40 2(384 2#0 3(34

    5 20 3(!

    6 90 2(!3

    7 200 2(34

    8 220 2(#2

    0 200 400

    0

    1

    2

    3

    4

    -ersamaan regresi

    eramaan re$rei

    'inear (eramaan

    re$rei)

     umlah prouksi urian *0,

     umlah pupuk organik *1,

  • 8/18/2019 excel modul statistik.xlsx

    50/87

    S@MM#C @@

    .egression 'tatistics

    Multiple # 0+848307

    # Suare 0+719625d;uted # Suare 0+672896

    Standard Error 0+284588

    -ervation 8

    V

    &, '' M' F igni/cance F  

    #e$reion 1 1+247 1+247 15+400 0+008

    #eidual 6 0+486 0+081

     otal 7 1+733

    Coe0cients tan&ar& 1rro t 'tat P-value "o$er 23%

    ntercept 1+284 0+428 2+999 0+024 0+236

     aR-Q C>128R0007Q

    nalii Koe*ien #e$rei

    a+ Mem-uat Aipotei

    -+ Menentu!an ta-el dan :itun$

      :itun$ 3+92

      ta-el 2+45

    c+ en$am-ilan Keputuan

    Kaida: Keputuan

     

  • 8/18/2019 excel modul statistik.xlsx

    51/87

     

    (pper 23% "o$er 23!4%(pper 23!4%

    2+331 0+236 2+331

    0+012 0+003 0+012

    adap

  • 8/18/2019 excel modul statistik.xlsx

    52/87

    Tahun Produksi (X) Harga (Y) S@MM#C @@

    2002 4(#4 37

    2003 4(#3 39 .egression 'tati

    2004 #(03 4 Multiple #

    200# 8(0# !48 # Suare

    200! !(09 487 d;uted # Suare

    2007 8(4 !40 Standard Error

    2008 !(37 483 -ervation

    2009 7(4 !84

    200 #(22 472 V

    20 7(8 40

    202 8(49 740 #e$reion

    #eidual

     otal

    TahunProduksi (X) Harga (Y)

    *2uta ton, *3S 4/ton,

    2002 4(#4 27 ntercept

    2003 4(#3 39 rodu!i (Q)

    2004 #(03 4  C>aR-Q

    200# !(0# 348

    200! !(09 287 nalii Koe*ien #e$r

    2007 !(4 330 a+ Mem-uat Aipotei

    2008 !(37 3832009 7(4 384

    200 7(22 472

    20 7(8 !0 -+ Menentu!an ta-el

    202 8(49 !40   :itun$

      ta-el

    c+ en$am-ilan Keputu

    Kaida: Keputuan

     

  • 8/18/2019 excel modul statistik.xlsx

    53/87

    tics

    0+823992

    0+678962

    0+643291

    83+86007

    11

    &, '' M' F gni/cance F  

    1 133857+4 133857+4 19+03408 0+001816

    9 63292+6 7032+511

    10 197150

    oe0cient an&ar& 1rr t 'tat P-value o$er 23%(pper 23%o$er 23!4 pper 23!4

    20+97223 116+0248 0+180756 0+860564 .241+4942 283+4386 .241+4942 283+4386

    75+82399 17+37964 4+362807 0+001816 36+50852 115+1395 36+50852 115+1395

     C>2097R7582Q

    i

    dan :itun$

    4+36

    2+26

    an

    ma!a Ao di tola!

    ma!a Ao di terima

      apat pen$aru: antara varia-el Q dan varia-el C

    ada pen$aru: antara varia-el Q den$an varia-el pat pen$aru: antara varia-el Q den$an Varia-el C

  • 8/18/2019 excel modul statistik.xlsx

    54/87

  • 8/18/2019 excel modul statistik.xlsx

    55/87

    Bank 

    B5 970#2 !#0 43#9

    65)) 27279 3320 379

    B) 20373 20#0 484:OB 892 0#0 3#7

     )55 #489 890 770

    B) 82484 !42 ##8

     )SP 2732 900 20!

    %KOO6) 49#! 420 #8#

    )PO 30343 2#40 4!#

    B$P 00## 27# 338

    5set (X1) +mi"iar,

    1arga Sa*am (X2)

    +rupia*>"embar,

    Keuntungan (Y)+mi"iar,

  • 8/18/2019 excel modul statistik.xlsx

    56/87

  • 8/18/2019 excel modul statistik.xlsx

    57/87

    S@MM#C @@

    .egression 'tatistics

    Multiple # 0+82# Suare 0+67

    d;uted # Suare 0+57

    Standard Error 861+92

    -ervation 10

    V

    &, '' M'

    #e$reion 2 10325566+64 5162783+32

    #eidual 7 5200394+262 742913+466

     otal 9 15525960+9

    Coe0cients tan&ar& 1rro t 'tat 

    ntercept 45+97 508+94 0+09

    et (Q1) (miliar) 0+01 0+00 1+93

    Aar$a Sa:am (Q2) (rupia:lem-ar) 0+41 0+19 2+20

    1 eramaan #e$rei

     C> aR-Q1RcQ2

     C> 4597 R 001Q1 R041Q2

    2 Korelai -er$anda

    nilai pen$aru: 0+815507018 mem-u!ti!an -a:"a :u-u

    3 Koe*ien re$rei -er$anda

    analii :ail untu! main$.main$ varia-elindividu

    a+ Mem-uat :ipotei

    varia-el Q1

    varia-el Q2

    -+ menentu!an t ta-el dan t :itun$

    AoBβ>0 artina tida! ada pen$aru: antara et ter:adap !euntun$anA1B βH0 B artina terdapat pen$aru: antara et ter:adap !euntun$an

    AoBβ>0 artina tida! ada pen$aru: antara Aar$a Sa:am ter:adap !euntun

    A1B βH0 B artina terdapat pen$aru: antara Aar$a Sa:am ter:adap !euntun

  • 8/18/2019 excel modul statistik.xlsx

    58/87

      ta-el 1+89

      :itun$

    Q varia-el 1 1+93

    Q varia-el 2 2+20

    c+ Kaida: Keputuan

     β2>0 artina tida! ada pen$aru: antara aet dan :ar$a a:am ter:

    A1 B palin$ tida! atu dari β1 H 0

  • 8/18/2019 excel modul statistik.xlsx

    59/87

    F igni/cance F  

    6+949373724 0+0217481

    P-value "o$er 23% pper 23 "o$er 23!4% pper 23!4%

    0+93 .1157+47 1249+42 .1157+47 1249+42

    0+10 0+00 0+01 0+00 0+01

    0+06 .0+03 0+85 .0+03 0+85

    n$an varia-el Q den$an varia-el C an$at erat+!arena nilai multiple # le-i: dari 0

    an

    an

  • 8/18/2019 excel modul statistik.xlsx

    60/87

      tara et ter:adap !euntun$an

      tara Aar$a a:am ter:adap !euntun$an

     !euntun$an

      adap !euntun$an

  • 8/18/2019 excel modul statistik.xlsx

    61/87

  • 8/18/2019 excel modul statistik.xlsx

    62/87

  • 8/18/2019 excel modul statistik.xlsx

    63/87

    $a*un

    2003 8(9 290# 20(37

    2004 9(#2 2997 20(!9

    200# 4(48 4074 9(2#

    200! 9(77 28 #(242007 9(24 !20# 9(77

    2008 !(09 230# !(8!

    2009 9(47 238# 7(02

    200 (0# #700 8(49

    20 2(!3 !02# 2#(09

    202 2(0 800 23(22

    $a*un

    +?>ta*un, +p>:S@, +?>ta*un,

    2003 8(9 90# #(37

    2004 9(#2 997 20(!9

    200# 9(48 2074 9(2#

    200! 9(77 28 #(24

    2007 9(24 420# !(77

    2008 !(09 230# !(8! 1

    2009 !(47 238# 7(02

    200 (0# #700 8(4920 77(!3 802# 2#(09

    202 !(0 700 2!(22 2

    3

    )n;"asi (X1)  i"ai $ukar (X

    2) Suku Bunga (Y)

    )n;"asi (X1)  i"ai $ukar (X2) Suku Bunga (Y)

  • 8/18/2019 excel modul statistik.xlsx

    64/87

  • 8/18/2019 excel modul statistik.xlsx

    65/87

    S@MM#C @@

    .egression 'tatistics

    Multiple # 0+819272

    # Suare 0+671207d;uted # Suare 0+577266

    Standard Error 1+933399

    -ervation 10

    V

    &, '' M' F gni/cance F  

    #e$reion 2 53+41639 26+7082 7+144993 0+020381

    #eidual 7 26+16621 3+73803

     otal 9 79+5826

    Coe0cient an&ar& 1rr t 'tat P-value "o$er 23%(pper 23%

    ntercept 12+97453 1+894735 6+847675 0+000242 8+494195 17+45487

    nTai (Q1) 0+328059 0+172535 1+901404 0+099001 .0+079922 0+73604

    ilai u!ar (Q2) 0+000688 0+000353 1+951488 0+091966 .0+000146 0+001522

    eramaan #e$rei

     C> 1297 R 033Q1 R00007Q2

    Korelai -er$anda

    nilai pen$aru: 0+819272 mem-u!ti!an -a:"a :u-un$an varia-el Q den$an var

    Koe*ien re$rei -er$anda

    analii :ail untu! main$.main$ varia-elindividu

    a+ Mem-uat :ipotei

    -+ menentu!an t ta-el dan t :itun$

      ta-el 1+894579

      :itun$

    Q varia-el 1 1+901404

    Q varia-el 2 1+951488

    AoBβ>0 artina tida! ada pen$aru: antara varia-el Q ter:adap varia-el

    A1B βH0 B artina terdapat pen$aru: antara varia-el Q ter:adap Varia-el C

  • 8/18/2019 excel modul statistik.xlsx

    66/87

    c+ Kaida: Keputuan

     β2>0 artina tida! ada pen$aru: antara varia-el.varia-el ter:adap varia-el C

    A1 B palin$ tida! atu dari β1 H 0

  • 8/18/2019 excel modul statistik.xlsx

    67/87

    o$er 23!4 pper 23!4%

    8+494195 17+45487

    .0+079922 0+73604

    .0+000146 0+001522

      ia-el C an$at erat+!arena nilai multiple # le-i: dari 06

  • 8/18/2019 excel modul statistik.xlsx

    68/87

  • 8/18/2019 excel modul statistik.xlsx

    69/87

    o Kepuasan (X) Loyalias (Y) o Kepuaan (Q)

    1 2 9 1 2

    2 0 4 2 0

    3 8 8 3 8

    4 20 8 4 205 30 # 5 30

    6 # ! 6 #

    7 2# 0 7 2#

    8 2! 4 8 2!

    9 24 9 9 24

    10 30 10 30

    nalia Aail

    1+

    2+

    a+ Mem-uat Aipo

    Ao B r >0 artin

    A1 B r N 0 artin

    -+ Menentu!an &

      ta-el

    c+ Kaida: Keputu

     

  • 8/18/2019 excel modul statistik.xlsx

    70/87

    #an! 'oalita (C) #an! d d2

    5 9 6 .1 1

    1 4 1 0 0

    3 8 4 .1 1

    4 8 4 0 09 # 10 .1 1

    2 ! 3 .1 1

    7 0 8 .1 1

    8 4 1 7 49

    6 9 6 0 0

    9 9 0 0

    Σ 54

    0+68

    ei

    a tida! terdapat :u-un$an U den$an retai Ker;a

    a terdapat :u-un$an U den$an retai Ker;a

      dan ta-el

    2+59

    1+86

    an

    a!a Ao diterima

    :u-un$an U den$an retai Ker;a

    ien !orelai Spearman (rs)

    ani rs

  • 8/18/2019 excel modul statistik.xlsx

    71/87

    No I Pr!s"asi K!r#a o

    1 122 1670 1

    2 118 1526 2

    3 129 1625 3

    4 121 1200 4

    5 128 1700 56 120 1475 6

    7 112 1580 7

    8 137 1750 8

    9 108 1100 9

    10 116 1450 10

    11 120 1550 11

    12 122 1655 12

    nalia Aa

    1+

    2+

  • 8/18/2019 excel modul statistik.xlsx

    72/87

    U #an! retai Ker;a #an! d d2

    122 8 1670 10 .2 4

    118 4 1526 5 .1 1

    129 10 1625 8 2 4

    121 7 1200 2 5 25

    128 9 1700 11 .2 4

    120 5 1475 4 1 1

    112 2 1580 7 .5 25

    137 11 1750 12 .1 1

    108 1 1100 1 0 0

    116 3 1450 3 0 0

    120 5 1550 6 .1 1

    122 8 1655 9 .1 1

    Σ 67

      il

    0+597598

    a+ Mem-uat Aipotei

    Ao B r >0 artina tida! terdapat :u-un$an U den$an retai Ker;a

    A1 B r N 0 artina terdapat :u-un$an U den$an retai Ker;a

    -+ Menentu!an dan ta-el

    2+108093

      ta-el 1+859548

    c+ Kaida: Keputuan

     

  • 8/18/2019 excel modul statistik.xlsx

    73/87

    No Item

    1 2 3 4 5 6 ! " 1#

    1   4 5 5 4 4 5 4 5 4 4 44

    2   3 4 4 4 3 4 4 3 4 3 36

    3   4 4 3 3 5 4 5 4 3 4 39

    4   3 5 4 4 5 4 4 5 4 4 42

    5   4 4 3 3 4 4 3 3 4 4 36

    6   5 4 4 5 4 4 4 4 3 3 40

      3 4 3 4 4 3 4 4 4 4 37

    !   4 3 4 5 3 4 4 4 3 4 38

    "   3 4 4 3 3 4 4 3 4 4 36

    1#   4 4 3 4 4 4 4 3 4 3 37

    11   3 4 4 4 3 3 4 3 4 3 35

    12   4 4 4 5 4 4 5 4 3 4 41

    13   4 3 3 3 2 3 3 3 3 3 30

    14   3 4 3 4 3 4 4 5 3 3 36

    15   3 4 3 4 3 4 5 4 3 3 36

    r 0+24 0+72 0+61 0+47 0+75 0+70 0+45 0+68 0+11 0+52

    t :itun$ 0+90 3+70 2+79 1+92 4+09 3+57 1+80 3+31 0+41 2+22

      ta-el 1+77 1+77 1+77 1+77 1+77 1+77 1+77 1+77 1+77 1+77

    Keputu a! Val Valid Valid Valid Valid Valid Valid Valid da! ValiValid

    NoRe$%

  • 8/18/2019 excel modul statistik.xlsx

    74/87

    o #eptem ertanaan

    1 2 3 4 5 6 7 8 9 10

    1 5 4 5 3 4 5 5 5 5 5

    2 5 4 5 4 5 5 4 5 5 5

    3 2 3 2 3 3 2 2 1 4 3

    4 4 4 4 4 2 4 2 3 4 4

    5 4 4 4 4 4 4 4 4 4 4

    6 5 4 5 4 4 5 4 4 4 4

    7 5 5 4 5 4 4 4 4 5 4

    8 5 5 5 5 4 5 4 5 4 4

    9 5 5 5 5 5 5 5 5 5 5

    10 5 5 5 5 5 5 5 5 4 5

    11 4 4 5 4 4 4 3 3 4 4

    12 5 5 5 4 4 5 4 4 5 4

    13 5 4 4 4 4 5 4 4 4 4

    14 4 4 4 5 4 5 4 5 5 4

    15 4 4 5 4 4 3 3 4 4 4

    16 5 4 4 5 4 5 4 5 4 4

    17 5 4 5 5 5 5 4 5 4 4

    18 5 5 5 4 4 5 4 3 4 4

    19 4 4 4 4 4 4 4 5 3 3

    20 5 5 5 5 5 4 3 5 5 4

    r 0+90 0+70 0+78 0+61 0+76 0+83 0+81 0+85 0+45 0+73t :itun$ 8+93 3+56 4+56 2+78 4+25 5+42 5+00 5+77 1+84 3+89

      ta-el 1+73 1+73 1+73 1+73 1+73 1+73 1+73 1+73 1+73 1+73

    Keputuan Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid

  • 8/18/2019 excel modul statistik.xlsx

    75/87

    46

    47

    25

    35

    40

    43

    44

    46

    50

    49

    39

    45

    42

    44

    39

    44

    46

    43

    39

    46

  • 8/18/2019 excel modul statistik.xlsx

    76/87

    No Re$%No Item

    1 2 3 4 5 6 ! " 1#

    1   4 5 5 4 4 5 4 5 4 4

    2   3 4 4 4 3 4 4 3 4 3

    3   4 4 3 3 5 4 5 4 3 4

    4   3 5 4 4 5 4 4 5 4 4

    5   4 4 3 3 4 4 3 3 4 4

    6   5 4 4 5 4 4 4 4 3 3

      3 4 3 4 4 3 4 4 4 4

    !   4 3 4 5 3 4 4 4 3 4

    "   3 4 4 3 3 4 4 3 4 4

    1#   4 4 3 4 4 4 4 3 4 3

    11   3 4 4 4 3 3 4 3 4 3

    12   4 4 4 5 4 4 5 4 3 4

    13   4 3 3 3 2 3 3 3 3 3

    14   3 4 3 4 3 4 4 5 3 3

    15   3 4 3 4 3 4 5 4 3 3

    0+40 0+29 0+40 0+50 0+69 0+27 0+35 0+60 0+27 0+27

    4+01905

    11+266666667

    r 0+71476

    t :itun$ 3+68485

    t ta-el 1+77093

    Keputuan #elia-el

    σ2 -utir

    Σσ2 /utir

    σ2 otal

  • 8/18/2019 excel modul statistik.xlsx

    77/87

    44

    36

    39

    42

    36

    40

    37

    38

    36

    37

    35

    41

    30

    36

    36

  • 8/18/2019 excel modul statistik.xlsx

    78/87

    o #eptem ertanaan

    1 2 3 4 5 6

    1 5 4 5 3 4 5

    2 5 4 5 4 5 5

    3 2 3 2 3 3 2

    4 4 4 4 4 2 4

    5 4 4 4 4 4 4

    6 5 4 5 4 4 5

    7 5 5 4 5 4 4

    8 5 5 5 5 4 5

    9 5 5 5 5 5 5

    10 5 5 5 5 5 5

    11 4 4 5 4 4 4

    12 5 5 5 4 4 5

    13 5 4 4 4 4 5

    14 4 4 4 5 4 5

    15 4 4 5 4 4 3

    16 5 4 4 5 4 5

    17 5 4 5 5 5 5

    18 5 5 5 4 4 5

    19 4 4 4 4 4 4

    20 5 5 5 5 5 4

    0+58 0+33 0+58 0+43 0+52 0+68

    5+5530+88421

    r 0+911346

    t :itun$ 9+392916

    t ta-el 1+734064

    Keputuan #elia-el

    σ2 -utir

    Σσ2 /utirσ2 otal

  • 8/18/2019 excel modul statistik.xlsx

    79/87

    7 8 9 10

    5 5 5 5 46

    4 5 5 5 47

    2 1 4 3 25

    2 3 4 4 35

    4 4 4 4 40

    4 4 4 4 43

    4 4 5 4 44

    4 5 4 4 46

    5 5 5 5 50

    5 5 4 5 49

    3 3 4 4 39

    4 4 5 4 45

    4 4 4 4 42

    4 5 5 4 44

    3 4 4 4 39

    4 5 4 4 44

    4 5 4 4 46

    4 3 4 4 43

    4 5 3 3 39

    3 5 5 4 46

    0+69 1+12 0+33 0+31

  • 8/18/2019 excel modul statistik.xlsx

    80/87

    V#/E' MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4

    1 11 6 4 9

    2 3 3 6 8

    3 9 9 4 114 33 51 39 45

    5 44 31 47 27

     otal 100 100 100 100

    ##S MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4

    1 0+11 0+06 0+04 0+09

    2 0+03 0+03 0+06 0+083 0+09 0+09 0+04 0+11

    4 0+33 0+51 0+39 0+45

    5 0+44 0+31 0+47 0+27

    ##S K@M@' MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4

    1 0+11 0+06 0+04 0+09

    2 0+14 0+09 0+10 0+17

    3 0+23 0+18 0+14 0+28

    4 0+56 0+69 0+53 0+73

    5 1 1 1 1

    ' MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4

    1 .1+23 .1+55 .1+75 .1+34

    2 .1+08 .1+34 .1+28 .0+95

    3 .0+74 .0+92 .1+08 .0+58

    4 0+15 0+50 0+08 0+61

    5 W W W W

    DESS MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4

  • 8/18/2019 excel modul statistik.xlsx

    81/87

    1 0+19 0+12 0+09 0+16

    2 0+22 0+16 0+18 0+25

    3 0+30 0+26 0+22 0+34

    4 0+39 0+35 0+40 0+33

    5 0+00 0+00 0+00 0+00

    S&#E V'@E MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4

    1 .1+71 .1+99 .2+15 .1+80

    2 .1+15 .1+44 .1+49 .1+13

    3 .0+90 .1+11 .1+18 .0+76

    4 .0+28 .0+18 .0+45 0+01

    5 0+90 1+14 0+85 1+22

     #S#MS MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4

    1 1+00 1+00 1+00 1+00

    2 1+56 1+54 1+67 1+67

    3 1+81 1+87 1+98 2+04

    4 2+43 2+81 2+71 2+82

    5 3+61 4+12 4+00 4+03

  • 8/18/2019 excel modul statistik.xlsx

    82/87

    5

    8

    5

    958

    20

    100

    5

    0+08

    0+050+09

    0+58

    0+2

    5

    0+08

    0+13

    0+22

    0+80

    1

    5

    .1+41

    .1+13

    .0+77

    0+84

    W

    5

  • 8/18/2019 excel modul statistik.xlsx

    83/87

    0+15

    0+21

    0+30

    0+28

    0+00

    5

    .1+86

    .1+26

    .0+94

    0+03

    1+40

    5

    1+00

    1+60

    1+92

    2+89

    4+26

  • 8/18/2019 excel modul statistik.xlsx

    84/87

    V#/E' MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4 5 6 7 8

    1 8 3 1 12 7 11 6 2

    2 3 3 6 10 5 2 7 3

    3 3 9 4 11 9 9 22 94 33 48 39 33 59 35 52 45

    5 53 37 50 34 20 43 13 41

     otal 100 100 100 100 100 100 100 100

    ##S MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4 5 6 7 8

    1 0+08 0+03 0+01 0+12 0+07 0+11 0+06 0+02

    2 0+03 0+03 0+06 0+1 0+05 0+02 0+07 0+033 0+03 0+09 0+04 0+11 0+09 0+09 0+22 0+09

    4 0+33 0+48 0+39 0+33 0+59 0+35 0+52 0+45

    5 0+53 0+37 0+5 0+34 0+2 0+43 0+13 0+41

    ##S K@M@' MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4 5 6 7 8

    1 0+08 0+03 0+01 0+12 0+07 0+11 0+06 0+02

    2 0+11 0+06 0+07 0+22 0+12 0+13 0+13 0+05

    3 0+14 0+15 0+11 0+33 0+21 0+22 0+35 0+14

    4 0+47 0+63 0+5 0+66 0+8 0+57 0+87 0+59

    5 1 1 1 1 1 1 1 1

    ' MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4 5 6 7 8

    1 .1+41 .1+88 .2+33 .1+17 .1+48 .1+23 .1+55 .2+05

    2 .1+23 .1+55 .1+48 .0+77 .1+17 .1+13 .1+13 .1+64

    3 .1+08 .1+04 .1+23 .0+44 .0+81 .0+77 .0+39 .1+08

    4 .0+08 0+33 0+00 0+41 0+84 0+18 1+13 0+23

    5 W W W W W W W W

    DESS MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4 5 6 7 8

  • 8/18/2019 excel modul statistik.xlsx

    85/87

    1 0+15 0+07 0+03 0+20 0+13 0+19 0+12 0+05

    2 0+19 0+12 0+13 0+30 0+20 0+21 0+21 0+10

    3 0+22 0+23 0+19 0+36 0+29 0+30 0+37 0+22

    4 0+40 0+38 0+40 0+37 0+28 0+39 0+21 0+39

    5 0+00 0+00 0+00 0+00 0+00 0+00 0+00 0+00

    S&#E V'@E MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4 5 6 7 8

    1 .1+86 .2+27 .2+67 .1+67 .1+92 .1+71 .1+99 .2+42

    2 .1+31 .1+70 .1+79 .0+96 .1+32 .1+18 .1+32 .1+82

    3 .1+15 .1+27 .1+34 .0+60 .0+98 .0+94 .0+72 .1+33

    4 .0+53 .0+30 .0+54 .0+01 0+01 .0+28 0+31 .0+37

    5 0+75 1+02 0+80 1+08 1+40 0+91 1+63 0+95

     #S#MS MEDE S@&&ESVE E#V'

    rdinal tem ertanaan

    1 2 3 4 5 6 7 8

    1 1+00 1+00 1+00 1+00 1+00 1+00 1+00 1+00

    2 1+55 1+57 1+87 1+71 1+60 1+53 1+67 1+60

    3 1+71 2+00 2+32 2+07 1+94 1+77 2+26 2+09

    4 2+33 2+97 3+12 2+65 2+93 2+43 3+29 3+05

    5 3+61 4+29 4+46 3+74 4+32 3+62 4+61 4+37

  • 8/18/2019 excel modul statistik.xlsx

    86/87

    9 10

    2 1

    3 4

    7 1347 55

    41 27

    100 100

    9 10

    0+02 0+01

    0+03 0+040+07 0+13

    0+47 0+55

    0+41 0+27

    9 10

    0+02 0+01

    0+05 0+05

    0+12 0+18

    0+59 0+73

    1 1

    9 10

    .2+05 .2+33

    .1+64 .1+64

    .1+17 .0+92

    0+23 0+61

    W W

    9 10

  • 8/18/2019 excel modul statistik.xlsx

    87/87

    0+05 0+03

    0+10 0+10

    0+20 0+26

    0+39 0+33

    0+00 0+00

    9 10

    .2+42 .2+67

    .1+82 .1+91

    .1+38 .1+23

    .0+40 .0+12

    0+95 1+22

    9 10

    1+00 1+00

    1+60 1+75

    2+04 2+44

    3+02 3+54

    4+37 4+89