0% found this document useful (0 votes)
3 views38 pages

Excel Thesis

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 38

No Tahun Bulan Nilai Tukar USD-IDR Kurs Tanggal

1 2014 1 12179.65 12.118,75 8000 10000 0


2 2014 2 11935.1 11.875,45 10001 12000 8
3 11427.05 11.369,95 12001 14000
3 2014 45
4 2014 4 11435.75 11.378,55 14001 16000 55
5 2014 5 11525.94 11.468,17
6 2014 6 11892.62 11.833,14
7 2014 7 11689.06 11.630,61
8 2014 8 11706.67 11.648,10
9 2014 9 11890.77 11.831,18

10 12144.87 12.084,17
10 2014
11 2014 11 12158.3 12.097,35
12 2014 12 12438.29 12.376,10
13 2015 1 12579.1 12.516,24
14 2015 2 12749.84 12.686,16
15 2015 3 13066.82 13.001,55
16 2015 4 12947.76 12.882,90
17 2015 5 13140.53 13.074,79
18 2015 6 13313.24 13.246,52
19 2015 7 13374.79 13.307,79
20 2015 8 13781.75 13.712,80
21 2015 9 14396.1 14.324,19
22 2015 10 13795.86 13.726,95
23 2015 11 13672.57 13.604,19
24 2015 12 13854.6 13.785,45
25 2016 1 13889.05 13.819,75
26 2016 2 13515.7 13.448,20
27 2016 3 13193.14 13.127,14
28 2016 4 13179.86 13.113,90
29 2016 5 13419.65 13.352,60
30 2016 6 13355.05 13.288,41
31 2016 7 13118.82 13.053,12
32 2016 8 13165 13.099,09
33 2016 9 13118.24 13.052,71
34 2016 10 13017.24 12.952,24
35 2016 11 13310.5 13.243,95
36 2016 12 13417.67 13.350,57
37 2017 1 13358.71 13.291,76
38 2017 2 13340.84 13.273,84
39 2017 3 13345.5 13.278,50
40 2017 4 13306.39 13.239,89
41 2017 5 13323.35 13.256,60
42 2017 6 13298.25 13.231,88
43 2017 7 13342.1 13.275,10
44 2017 8 13341.82 13.274,82
45 2017 9 13303.47 13.236,95
46 2017 10 13526 13.458,32
47 2017 11 13527.36 13.459,36
48 2017 12 13556.21 13.488,21
49 2018 1 13380.36 13.313,36
50 2018 2 13590.05 13.522,16
51 2018 3 13758.29 13.689,29
52 2018 4 13802.95 13.733,86
53 2018 5 14059.7 13.989,40
54 2018 6 14036.14 13.965,93
55 2018 7 14414.5 14.342,36
56 2018 8 14559.86 14.487,14
57 2018 9 14868.74 14.794,47
58 2018 10 15178.87 15.103,00
59 2018 11 14696.86 14.623,33
60 2018 12 14496.95 14.424,42
61 2019 1 14163.14 14.092,36
62 2019 2 14035.21 13.965,05
63 2019 3 14211 14.139,90
64 2019 4 14142.58 14.071,84
65 2019 5 14392.81 14.320,86
66 2019 6 14226.53 14.155,33
67 2019 7 14043.91 13.973,57
68 2019 8 14242.05 14.171,05
69 2019 9 14111.1 14.040,62
70 2019 10 14117.57 14.046,92
71 2019 11 14068.72 13.998,37
72 2019 12 14017.45 13.947,37
73 2020 1 13732.23 13.663,57
74 2020 2 13776.15 13.707,27
75 2020 3 15194.57 15.118,60
76 2020 4 15867.43 15.788,09
77 2020 5 14906.19 14.831,66
78 2020 6 14195.96 14.124,98
79 2020 7 14582.41 14.509,50
80 2020 8 14724.5 14.650,88
81 2020 9 14847.96 14.773,72
82 2020 10 14749.14 14.675,39
83 2020 11 14236.81 14.165,63
84 2020 12 14173.09 14.102,22
85 2021 1 14061.9 13.991,59
86 2021 2 14042.1 13.971,89
87 2021 3 14417.39 14.345,31
88 2021 4 14558.18 14.485,39
18000
89 2021 5 14323.19 14.251,58
16000
90 2021 6 14338.23 14.266,54
14000
91 2021 7 14511.19 14.438,64
Nilai Kurs USD-IDR

12000
92 2021 8 14397.7 14.325,71
10000
8000
6000
4000
16000
14000

Nilai Kurs USD-IDR


12000
10000
93 2021 9 14256.96 14.185,67
94 10 14198.45 14.127,46 8000
2021
95 2021 11 14263.5 14.192,19 6000
96 2021 12 14328.92 14.257,27 4000
97 2022 1 14335.24 14.263,56 2000
98 2022 2 14351.06 14.279,30 0
1 5 9 13 17 21 25 29 33 37 41 45 4
99 2022 3 14348.64 14.276,90
100 2022 4 14368.74 14.296,90 Period
101 2022 5 14608 14.534,96
102 2022 6 14688.57 14.615,13 Nilai Tu
103 2022 7 14984.38 14.909,46
104 2022 8 14850.64 14.776,38
105 2022 9 14971.77 14.896,91
106 2022 10 15417.48 15.340,39
107 2022 11 15658.73 15.580,43
108 2022 12 15615 15.536,93
Date
1/1/2014
1/2/2014 Descriptive Statistics
1/3/2014 Valid N
Nilai_Tukar (listwise)
1/4/2014 N Statistic 108 108
1/5/2014 Range Statistic 4440.38
1/6/2014 Minimum Statistic 11427.05
1/7/2014 Maximum Statistic 15867.43
1/8/2014 Mean Statistic 13785.7842
1/9/2014 Std. Error 90.46826
Std. Statistic 940.17371
1/10/2014
Deviation
1/11/2014 Variance Statistic 883926.605
1/12/2014 Skewness Statistic -0.561
1/1/2015 Std. Error 0.233
1/2/2015 Kurtosis Statistic 0.289
1/3/2015 Std. Error 0.461
1/4/2015 Median 14026.3300
1/5/2015
1/6/2015
1/7/2015
1/8/2015
1/9/2015
1/10/2015
1/11/2015
1/12/2015
1/1/2016
1/2/2016
1/3/2016
1/4/2016
1/5/2016
1/6/2016 Statistics
1/7/2016 Nilai_Tukar
1/8/2016 N Valid 108
1/9/2016 Missing 0
1/10/2016 Mean 13785.7842
1/11/2016 Std. Error of Mean 90.46826
1/12/2016 Median 14026.3300
1/1/2017 Mode 11427.05a
1/2/2017 Std. Deviation 940.17371
1/3/2017 Variance 883926.605
1/4/2017 Range 4440.38
1/5/2017 Minimum 11427.05
1/6/2017 Maximum 15867.43
1/7/2017 Sum 1488864.69
1/8/2017 Percentile 25 13311.1850
s
Percentile
s 50 14026.3300
1/9/2017
1/10/2017 75 14386.7925
1/11/2017 a. Multiple modes exist. The
smallest value is shown
1/12/2017
1/1/2018
1/2/2018
1/3/2018
1/4/2018
1/5/2018
1/6/2018
1/7/2018
1/8/2018
1/9/2018
1/10/2018
1/11/2018
1/12/2018
1/1/2019
1/2/2019
1/3/2019
1/4/2019
1/5/2019
1/6/2019
1/7/2019
1/8/2019
1/9/2019
1/10/2019
1/11/2019
1/12/2019
1/1/2020
1/2/2020
1/3/2020
1/4/2020
1/5/2020
1/6/2020
1/7/2020
1/8/2020
1/9/2020
1/10/2020
1/11/2020
1/12/2020
1/1/2021
1/2/2021
1/3/2021
1/4/2021
1/5/2021
1/6/2021
1/7/2021
1/8/2021
1/9/2021
1/10/2021
1/11/2021
1/12/2021
1/1/2022
1/2/2022
7 21 25 29 33 37 41 45 49 53 57 611/3/2022
65 69 73 77 81 85 89 93 97 101 105
Periode (Bulan ke) 1/4/2022
1/5/2022
Nilai Tukar USD-IDR 1/6/2022
1/7/2022
1/8/2022
1/9/2022
1/10/2022
1/11/2022
1/12/2022
Descriptive Statistics
Valid N
Nilai_Tukar (listwise)
N Statistic 108 108
Range Statistic 4440.38
Minimum Statistic 11427.05
Maximum Statistic 15867.43
Mean Statistic 13785.7842
Std. Error 90.46826
Std. Statistic 940.17371
Deviation
Variance Statistic 883926.605
Median 14026.3300

Column D
18000

16000

14000

12000
Kurs Nilai USD-IDR

10000

8000

6000
Statistics 4000
Nilai_Tukar
2000
N Valid 108
Missing 0 0
1 7 13 19 25 31 37 43 49 55 61 67 73 79 85 91 97 103
Mean 13785.7842
Std. Error of Mean 90.46826
Median 14026.3300
Mode 11427.05a
Std. Deviation 940.17371
Variance 883926.605
Range 4440.38
Minimum 11427.05
Maximum 15867.43
Sum 1488864.69
79 85 91 97 103
Bulan Sum of Nilai USD-IDR
1 121679.38
2 121336.05
3 122962.4
4 123609.64
5 123699.36
6 123344.59
7 124061.16
8 124769.99
9 125765.11 Total
10 126145.48
1600000
11 125593.35
1400000
12 125898.18
Total Result 1488864.69 1200000
1000000
800000 Sum of Nila
121679.38
600000
400000
200000
0
2 3 4 5 6 7 8 9 10 11 12 ult
s
l Re
ta
To
al

Sum of Nilai USD-IDR


121679.38

12 sult
Re
tal
o
Sum of Nilai USD-IDR Tahun
Bulan 2022 2021 2020 2019 2018 2017 2016
1 14335.24 14061.9 13732.23 14163.14 13380.36 13358.71 13889.05
2 14351.06 14042.1 13776.15 14035.21 13590.05 13340.84 13515.7
3 14348.64 14417.39 15194.57 14211 13758.29 13345.5 13193.14
4 14368.74 14558.18 15867.43 14142.58 13802.95 13306.39 13179.86
5 14608 14323.19 14906.19 14392.81 14059.7 13323.35 13419.65
6 14688.57 14338.23 14195.96 14226.53 14036.14 13298.25 13355.05
7 14984.38 14511.19 14582.41 14043.91 14414.5 13342.1 13118.82
8 14850.64 14397.7 14724.5 14242.05 14559.86 13341.82 13165
9 14971.77 14256.96 14847.96 14111.1 14868.74 13303.47 13118.24
10 15417.48 14198.45 14749.14 14117.57 15178.87 13526 13017.24
11 15658.73 14263.5 14236.81 14068.72 14696.86 13527.36 13310.5
12 15615 14328.92 14173.09 14017.45 14496.95 13556.21 13417.67
Total Result 178198.25 171697.71 174986.44 169772.07 170843.27 160570 159699.92

200000
180000
160000
140000
120000 Tahun 2022
Nilasi Kurs USD-IDR

100000 2021
2020
80000 2019
60000 2018
2017
40000 2016
20000 2015
2014
0
1 2 3 4 5 6 7 8 9 10 11 12 sult
Re
t al
To
Bulan
2015 2014 Total Result
12579.1 12179.65 121679.38
12749.84 11935.1 121336.05
13066.82 11427.05 122962.4
12947.76 11435.75 123609.64
13140.53 11525.94 123699.36
13313.24 11892.62 123344.59
13374.79 11689.06 124061.16
13781.75 11706.67 124769.99
14396.1 11890.77 125765.11
13795.86 12144.87 126145.48
13672.57 12158.3 125593.35
13854.6 12438.29 125898.18
160672.96 142424.07 1488864.69

Tahun 2022
2021
2020
2019
2018
2017
2016
2015
2014

12 sult
Re
t al
To
No Bulan Tingkat Inflasi (%)
2014 1 8.22
2014 2 7.75
2014 3 7.32
2014 4 7.25
2014 5 7.32
2014 6 6.70 Descriptive Statistics
7 Valid N
2014 4.53 Inflasi (listwise)
2014 8 3.99 N Statistic 108 108

2014 9 4.53 Range Statistic 7.04

2014 10 4.83 Minimum Statistic 1.32

2014 11 6.23 Maximum Statistic 8.36

2014 12 8.36 Mean Statistic 3.8152

2015 13 6.96 Std. Error 0.17372


Std. Statistic 1.80540
14
2015 6.29 Deviation
2015 15 6.38 Variance Statistic 3.259

2015 16 6.79 Skewness Statistic 0.762

2015 17 7.15 Std. Error 0.233


2015 18 7.26 Kurtosis Statistic -0.200
2015 19 7.26 Std. Error 0.461
2015 20 7.18
2015 21 6.83
2015 22 6.25
2015 23 4.89
2015 24 3.35
2016 25 4.14
2016 26 4.42
2016 27 4.45
2016 28 3.60
2016 29 3.33
2016 30 3.45
2016 31 3.21
2016 32 2.79
2016 33 3.07
2016 34 3.31
2016 35 3.58
2016 36 3.02
2017 37 3.49
2017 38 3.83
2017 39 3.61
2017 40 4.17
2017 41 4.33
2017 42 4.37
2017 43 3.88
2017 44 3.82
2017 45 3.72
2017 46 3.58
2017 47 3.30
2017 48 3.61
2018 49 3.25
2018 50 3.18
2018 51 3.40
2018 52 3.41
2018 53 3.23
2018 54 3.12
2018 55 3.18
2018 56 3.20
2018 57 2.88
2018 58 3.16
2018 59 3.23
2018 60 3.13
2019 61 2.82
2019 62 2.57
2019 63 2.48
2019 64 2.83
2019 65 3.32
2019 66 3.28
2019 67 3.32
2019 68 3.49
2019 69 3.39
2019 70 3.13
2019 71 5.00
2019 72 2.72
2020 73 2.68
2020 74 2.98
2020 75 2.96
2020 76 2.67
2020 77 2.19
2020 78 1.96
2020 79 1.54
2020 80 1.32
2020 81 1.42
2020 82 1.44
2020 83 1.59
2020 84 1.68
2021 85 1.55
2021 86 1.38
2021 87 1.37
2021 88 1.42
2021 89 1.68
2021 90 1.33
2021 91 1.52
2021 92 1.59
2021 93 1.60
2021 94 1.66
2021 95 1.75
2021 96 1.87
2022 97 2.18
2022 98 2.06
2022 99 2.64
2022 100 3.47
2022 101 3.55
2022 102 4.35
2022 103 4.94
2022 104 4.69
2022 105 5.95
2022 106 5.71
2022 107 5.42
2022 108 5.51
Statistics

Inflasi
N Valid 108
Missing 0
Mean 3.8152
Std. Error of Mean 0.17372
Median 3.3700
Mode 1.42a
Std. Deviation 1.80540

Variance 3.259
Range 7.04
Minimum 1.32
Maximum 8.36
Sum 412.04
Percentiles 25 2.6900
50 3.3700
75 4.6500
a. Multiple modes exist. The
smallest value is shown
Sum of Tingkat Inflasi (%) No
Bulan 2022 2021 2020 2019 2018 2017 2016 2015 2014 Total Result
1 2.18 1.55 2.68 2.82 3.25 3.49 4.14 6.96 8.22 35.29
2 2.06 1.38 2.98 2.57 3.18 3.83 4.42 6.29 7.75 34.46
3 2.64 1.37 2.96 2.48 3.4 3.61 4.45 6.38 7.32 34.61
90
4 3.47 1.42 2.67 2.83 3.41 4.17 3.6 6.79 7.25 35.61
80
5 3.55 1.68 2.19 3.32 3.23 4.33 3.33 7.15 7.32 36.1
70
6 4.35 1.33 1.96 3.28 3.12 4.37 3.45 7.26 6.7 35.82
60
7 4.94 1.52 1.54 3.32 3.18 3.88 3.21 7.26 4.53 33.38
50
8 4.69 1.59 1.32 3.49 3.2 3.82 2.79 7.18 3.99 32.07

Inflasi (%)
40
9 5.95 1.6 1.42 3.39 2.88 3.72 3.07 6.83 4.53 33.39
30
10 5.71 1.66 1.44 3.13 3.16 3.58 3.31 6.25 4.83 33.07
20
11 5.42 1.75 1.59 5 3.23 3.3 3.58 4.89 6.23 34.99
10
12 5.51 1.87 1.68 2.72 3.13 3.61 3.02 3.35 8.36 33.25
Total Result 50.47 18.72 24.43 38.35 38.37 45.71 42.37 76.59 77.03 412.04 0
1 2
90
80
70
60
No 2022
50 2021
Inflasi (%)

40 2020
30 2019
2018
20
2017
10 2016
0 2015
1 2 3 4 5 6 7 8 9 10 11 12 sult 2014
Re
tal
To
Periode (Bulan ke)
Bulan Sum of Tingkat Inflasi (%)
1 8.22
2 7.75
3 7.32
4 7.25
5 7.32
6 6.7
7 4.53
8 3.99
9 4.53
10 4.83
11 6.23
12 8.36
13 6.96
14 6.29
15 6.38
16 6.79
17 7.15
18 7.26
19 7.26
20 7.18
21 6.83
22 6.25
23 4.89
24 3.35
25 4.14
26 4.42
27 4.45
28 3.6
29 3.33
30 3.45
31 3.21
32 2.79
33 3.07
34 3.31
35 3.58
36 3.02
37 3.49
38 3.83
39 3.61
40 4.17
41 4.33
42 4.37
43 3.88
44 3.82
45 3.72
46 3.58
47 3.3
48 3.61
49 3.25
50 3.18
51 3.4
52 3.41
53 3.23
54 3.12
55 3.18
56 3.2
57 2.88
58 3.16
59 3.23
60 3.13
61 2.82
62 2.57
63 2.48
64 2.83
65 3.32
66 3.28
67 3.32
68 3.49
69 3.39
70 3.13
71 5
72 2.72
73 2.68
74 2.98
75 2.96
76 2.67
77 2.19 450
78 1.96
400
79 1.54
350
80 1.32
81 1.42 300
Nilai Inflasi (%)

82 1.44 250
83 1.59
200
84 1.68
85 1.55 150

86 1.38 100
87 1.37 50
88 1.42
0
89 1.68 2 7 12 17 22 27 32 37 42 47 52 57 62 67 72 77 82 87 92 97 102107
90 1.33 Periode (bulan ke)
91 1.52
92 1.59
93 1.6
94 1.66
95 1.75
96 1.87
97 2.18
98 2.06
99 2.64
100 3.47
101 3.55
102 4.35
103 4.94
104 4.69
105 5.95
106 5.71
107 5.42
108 5.51
Total Result 412.04
7 72 77 82 87 92 97 102107
Periode Bulan Sum of BI-Rate
1 7.5
2 7.5
3 7.5
4 7.5
5 7.5
6 7.5
7 7.5
8 7.5
9 7.5
10 7.5
11 7.75
12 7.75
13 7.75
14 7.5
15 7.5
16 7.5
17 7.5
18 7.5
19 7.5
20 7.5
21 7.5
22 7.5
23 7.5
24 7.5
25 7.25
26 7
27 6.75
28 5.5
29 5.5
30 5.25
31 5.25
32 5.25
33 5
34 4.75
35 4.75
36 4.75
37 4.75
38 4.75
39 4.75
40 4.75
41 4.75
42 4.75
43 4.75
44 4.5
45 4.25
46 4.25
47 4.25
48 4.25
49 4.25
50 4.25
51 4.25
52 4.25
53 4.75
54 5.25
55 5.25
56 5.5
57 5.75
58 5.75
59 6
60 6
61 6
62 6
63 6
64 6
65 6
66 6
67 5.75
68 5.5
69 5.25
70 5
71 5
72 5
73 5
74 4.75
75 4.5
76 4.5
77 4.5
78 4.25
79 4
80 4
81 4
82 4
83 3.75
84 3.75
85 3.75
86 3.5
87 3.5
88 3.5
89 3.5
90 3.5 700
91 3.5
600
92 3.5
93 3.5 500

400
BI Rate (%)

300
700

600

500
94 3.5
400

BI Rate (%)
95 3.5
96 3.5 300
97 3.5
98 3.5 200
99 3.5
100
100 3.5
101 3.5 0
2 7 12 17 22 27 32 37 42 47 52 57 62 67 72 77 82 87 92 97 102107
102 3.5
103 3.5 Periode (bulan ke)
104 3.75
105 4.25
106 4.75
107 5.25
108 5.5
Total Result 572.5
7 72 77 82 87 92 97 102107
Tahun Bulan BI-Rate Periode Bulan
2014 1 7.50 1 1 0.05 100 5

2014 2
7.50
2 2 0.05 100 5
2014 3 7.50 3 3 0.0525 100 5.25
2014 4 7.50 4 4 0.055 100 5.5
2014 5 7.50 5 5 0.0575 100 5.75
2014 6 7.50 6 6 0.06 100 6
2014 7 7.50 7 7 0.0625 100 6.25
2014 8 7.50 8 8 0.065 100 6.5
2014 9 7.50 9 9 0.0675 100 6.75
2014 10 7.50 10 10 0.07 100 7
2014 11 7.75 11 11 0.0725 100 7.25
2014 12 7.75 12 12 0.075 100 7.5
2015 1 7.75 13 13 0.0775 100 7.75
2015 2 7.50 14 14 0.08 100 8
2015 3 7.50 15 15 0.0825 100 8.25
2015 4 7.50 16 16 0.085 100 8.5
2015 5 7.50 17 17 0.0875 100 8.75
2015 6 7.50 18 18 0.09 100 9
2015 7 7.50 19 19 0.0925 100 9.25
2015 8 7.50 20 20 0.095 100 9.5
2015 9 7.50 21
7.50
2015 10 22
2015 11 7.50 23
2015 12 7.50 24
2016 1 7.25 25
2016 2 7.00 26
2016 3 6.75 27
2016 4 5.50 28

2016 5 5.50 29
2016 6 5.25 30
2016 7 5.25 31
2016 8 5.25 32
2016 9 5.00 33
2016 10 4.75 34
2016 11 4.75 35
2016 12 4.75 36
2017 1 4.75 37
2017 2 4.75 38
2017 3 4.75 39
2017 4 4.75 40
2017 5 4.75 41
2017 6 4.75 42
2017 7 4.75 43
2017 8 4.50 44
2017 9 4.25 45
2017 10 4.25 46
2017 11 4.25 47
2017 12 4.25 48
2018 1 4.25 49
2018 2 4.25 50
2018 3 4.25 51
2018 4 4.25 52
2018 5 4.75 53
2018 6 5.25 54
2018 7 5.25 55
2018 8 5.50 56
2018 9 5.75 57
2018 10 5.75 58
2018 11 6.00 59
2018 12 6.00 60
2019 1 6.00 61
2019 2 6.00 62
2019 3 6.00 63
2019 4 6.00 64
2019 5 6.00 65
2019 6 6.00 66
2019 7 5.75 67
2019 8 5.50 68
2019 9 5.25 69
2019 10 5.00 70
2019 11 5.00 71
2019 12 5.00 72
2020 1 5.00 73
2020 2 4.75 74
2020 3 4.50 75
2020 4 4.50 76
2020 5 4.50 77
2020 6 4.25 78
2020 7 4.00 79
2020 8 4.00 80
2020 9 4.00 81
2020 10 4.00 82
2020 11 3.75 83
2020 12 3.75 84
2021 1 3.75 85
2021 2 3.50 86
2021 3 3.50 87
2021 4 3.50 88
2021 5 3.50 89
2021 6 3.50 90
2021 7 3.50 91
2021 8 3.50 92
2021 9 3.50 93
2021 10 3.50 94
2021 11 3.50 95
2021 12 3.50 96
2022 1 3.50 97
2022 2 3.50 98
2022 3 3.50 99
2022 4 3.50 100
2022 5 3.50 101
2022 6 3.50 102
2022 7 3.50 103
2022 8 3.75 104
2022 9 4.25 105
2022 10 4.75 106
2022 11 5.25 107
2022 12 5.50 108
5 58 BI_Rate
Valid Cumulative
5 0 Frequency Percent Percent Percent
5.25 7 Valid 3.50 18 16.7 16.7 16.7

5.5 5 3.75 4 3.7 3.7 20.4

5.75 3 4.00 4 3.7 3.7 24.1

6 8 4.25 10 9.3 9.3 33.3

6.25 0 4.50 4 3.7 3.7 37.0

6.5 0 4.75 13 12.0 12.0 49.1

6.75 1 5.00 5 4.6 4.6 53.7

7 1 5.25 7 6.5 6.5 60.2

7.25 1 5.50 5 4.6 4.6 64.8

7.5 21 5.75 3 2.8 2.8 67.6

7.75 3 6.00 8 7.4 7.4 75.0

8 0 6.75 1 0.9 0.9 75.9

8.25 0 7.00 1 0.9 0.9 76.9

8.5 0 7.25 1 0.9 0.9 77.8

8.75 0 7.50 21 19.4 19.4 97.2

9 0 7.75 3 2.8 2.8 100.0

9.25 0 Total 108 100.0 100.0

9.5 0
Descriptive Statistics
Valid N
BI_Rate (listwise)
N Statistic 108 108
Range Statistic 4.25
Minimum Statistic 3.50
Maximum Statistic 7.75
Mean Statistic 5.3009
Std. Error 0.13980
Std. Statistic 1.45282
Deviation
Variance Statistic 2.111
Skewness Statistic 0.438
Std. Error 0.233
Kurtosis Statistic -1.162
Std. Error 0.461
BI_Rate
Valid Cumulative
Frequency Percent Percent Percent
Valid 3.50 18 16.7 16.7 16.7 3.50 18
3.75 4 3.7 3.7 20.4 3.75 4
4.00 4 3.7 3.7 24.1 4.00 4
4.25 10 9.3 9.3 33.3 4.25 10
4.50 4 3.7 3.7 37.0 4.50 4
4.75 13 12.0 12.0 49.1 4.75 13
5.00 5 4.6 4.6 53.7 5.00 5
5.25 7 6.5 6.5 60.2 5.25 7
5.50 5 4.6 4.6 64.8 5.50 5
5.75 3 2.8 2.8 67.6 5.75 3
6.00 8 7.4 7.4 75.0 6.00 8
6.75 1 0.9 0.9 75.9 6.75 1
7.00 1 0.9 0.9 76.9 7.00 1
7.25 1 0.9 0.9 77.8 7.25 1
7.50 21 19.4 19.4 97.2 7.50 21
7.75 3 2.8 2.8 100.0 7.75 3
Total 108 100.0 100.0 Total 108
3.50 18 Statistics
3.75 4 BI_Rate BI_Rate
4.00 4 N Valid 108 N

4.25 10 Missing 0

4.50 4 Mean 5.3009 Mean

4.75 13 Std. Error of Mean 0.13980 Std. Error of Mean

5.00 5 Median 5.0000 Median

5.25 7 Mode 7.50 Mode

5.50 5 Std. Deviation 1.45282 Std. Deviation

5.75 3 Variance 2.111 Variance

6.00 8 Range 4.25 Range

6.75 1 Minimum 3.50 Minimum

7.00 1 Maximum 7.75 Maximum

7.25 1 Sum 572.50 Sum

7.50 21 Percentiles 25 4.2500

7.75 3 50 5.0000
108 75 6.5625
BI_Rate
Valid 108
Missing 0
Mean 5.3009
Std. Error of Mean 0.13980
Median 5.0000
Mode 7.50
Std. Deviation 1.45282
Variance 2.111
Range 4.25
Minimum 3.50
Maximum 7.75
Sum 572.50
Sum of BI-Rate Tahun
Bulan 2014 2015 2016 2017 2018 2019 2020 2021 2022
1 7.5 7.75 7.25 4.75 4.25 6 5 3.75 3.5
2 7.5 7.5 7 4.75 4.25 6 4.75 3.5 3.5
3 7.5 7.5 6.75 4.75 4.25 6 4.5 3.5 3.5
4 7.5 7.5 5.5 4.75 4.25 6 4.5 3.5 3.5
5 7.5 7.5 5.5 4.75 4.75 6 4.5 3.5 3.5
6 7.5 7.5 5.25 4.75 5.25 6 1004.25 3.5 3.5
7 7.5 7.5 5.25 4.75 5.25 5.75 90 4 3.5 3.5
8 7.5 7.5 5.25 4.5 5.5 5.5 80 4 3.5 3.75
9 7.5 7.5 5 4.25 5.75 5.25 70 4 3.5 4.25
10 7.5 7.5 4.75 4.25 5.75 5 60 4 3.5 4.75

Nilai BI Rate (%)


11 7.75 7.5 4.75 4.25 6 5 503.75 3.5 5.25
40
12 7.75 7.5 4.75 4.25 6 5 3.75 3.5 5.5
30
Total Result 90.5 90.25 67 54.75 61.25 67.5 51 42.25 48
20
10
0
1 2 3 4 5 6 7 8 9 10

Bulan
Total Result
49.75
48.75
48.25
47
47.5
47.5
47
47
Tahun
47 2014
47 2015
47.75 2016
48 2017
572.5 2018
2019
2020
4 5 6 7 8 9 10 11 12 sult 2021
e
a lR 2022
T ot

Bulan
Data
Bulan Sum of BI-Rate Sum of Tahun
1 49.75 18162
2 48.75 18162 700
3 48.25 18162
600
4 47 18162
5 47.5 18162 500
6 47.5 18162
7 47 18162 400

BI Rate (%)
8 47 18162
300
9 47 18162
10 47 18162 200
11 47.75 18162
12 48 18162 100
Total Result 572.5 217944 0
2 7 12 17 22 27 32 37 42 47 52 57 62
Periode (bulan k
250000

17 22 27 32 37 42 47 52 57 62 67 72 77 82 87 92 97 102107
200000 Data
Periode (bulan ke) Sum of
BI-Rate
150000 Sum of
Nilai BI Rate (%)

Tahun
100000

50000

0
1 2 3 4 5 6 7 8 9 10 11 12 sult
Re
tal
To
Bulan

You might also like