Excel Thesis
Excel Thesis
Excel Thesis
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
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
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
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
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
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
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