excel modul statistik.xlsx
-
Upload
dhe-moelyana-asy-syabani-nobilis -
Category
Documents
-
view
227 -
download
0
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