0% found this document useful (0 votes)
8 views10 pages

Yearly Data Analysis and Trends

The document contains several tables and charts showing trends over time, with columns labeled with years from 2012 to 2018 and values that generally increase each year. The charts show linear regressions fitted to different columns of data with equations and R-squared values provided. The tables and charts contain various numerical data that trends upward annually for the most part.

Uploaded by

fadillah
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views10 pages

Yearly Data Analysis and Trends

The document contains several tables and charts showing trends over time, with columns labeled with years from 2012 to 2018 and values that generally increase each year. The charts show linear regressions fitted to different columns of data with equations and R-squared values provided. The tables and charts contain various numerical data that trends upward annually for the most part.

Uploaded by

fadillah
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

2013 3157 1038 270

2014 3268 1347 183


2015 3425 1430 130
2016 3579 2058 364
2017 3714 3095 366
3082 368
2957 310
3666 269

5566

450.452
Chart T
400
350
f(x) = 0.052046209x + 161.01764
300 R² = 0.3362029839
250

Axis Title
200
150
100
50
0
500 1000 1500 2000 2500 3000
Axis Title
Chart Title
3800
3700
f(x) = 142.5x - 283708.899999975
3600 R² = 0.9971386509
3500
3400
Axis Title

3300 Col umn C


3200 Li near (Col umn C)
3100
3000
2900
2800
2012 2013 2014 2015 2016 2017 2018
Axis Title

Chart Title

f(x) = 0.052046209x + 161.0176423799


R² = 0.3362029839

Col umn G
Li near (Col umn G)

0 1500 2000 2500 3000 3500 4000


Axis Title
2013 3867 930 270
2014 3989 1294 183 4600
2015 4102 1563 149
4400 f(x) = 163.6x -
2016 4301 1996 329 R² = 0.9751606
2017 4529 2839 388 4200
3069 295

Axis Title
4000
2968 310
3597 269 3800

3600
6612
3400
451.732 2012 2013 2014 2
Axis T

Chart Title
450
400
350
300 f(x) = 0.0409670857x + 180.6381103492
R² = 0.2628728395
250
Axis Title

Col umn G
200 Li near (Col umn G)
150
100
50
0
500 1000 1500 2000 2500 3000 3500 4000
Axis Title
Chart Title
4600

4400 f(x) = 163.6x - 325496.399999969


R² = 0.9751606021
4200

4000 Col umn C


Li nea r (Col umn C)
3800

3600

3400
2012 2013 2014 2015 2016 2017 2018
Axis Title

Col umn G
Li near (Col umn G)
2013 2110 1038 180
2014 2323 1347 207 3000

2015 2512 1430 149 f(x) = 178x


2500 R² = 0.989
2016 2699 2058 Chart
329 Title
2017 2812 450 3095 388 2000

Axis Title
400
3082 295 1500
350
2957 398
3666 159 1000
300 f(x) = 0.0456061349x + 156.674580392
R² = 0.1949393776
250 500
5161 Axis Title Col umn G
200 Li nea r (Col um
392.0116 0
150 2012 2013 2014
100
A
50
0
500 1000 1500 2000 2500 3000 3500 4000
Axis Title
Chart Title
3000
f(x) = 178x - 356178.799999972
2500 R² = 0.9897204518

2000
Axis Title

1500 Col umn D


Li near (Col umn D)
1000

500
Col umn G
0 Li nea r (Col umn G)
2012 2013 2014 2015 2016 2017 2018
Axis Title

00
450
2013 1632 1038 180 400
2014 1894 1347 207 350
2015 2056 1430 130 300 f(x) = 0.04
2016 2235 2058 364 250 R² = 0.147

Axis Title
2017 2376 3095 266 200
3082 366 150
2957 398 100
3666 159 50
0
500 1000 1500
4782

Ch
358.8638 2500
f(x) = 182.9x - 366504.89
R² = 0.9869504749
2000

1500

Axis Title
1000

500

0
2012 2013 2014 2015 2
Axis Title
Chart Title
450
400
350
300 f(x) = 0.0409021488x + 163.2792718309
250 R² = 0.147965126
Axis Title

Col umn G
200 Li near (Col umn G)
150
100
50
0
500 1000 1500 2000 2500 3000 3500 4000
Axis Title

Chart Title

f(x) = 182.9x - 366504.899999972


R² = 0.9869504749

Col umn C
Li nea r (Col umn C)

2013 2014 2015 2016 2017 2018


Axis Title
4500
4000
tahun (x) kepadatan (y) x.y x^2 3500 f(x) = 178.5x - 356173.8
R² = 0.9900913952
2013 3119 6278547 4052169 3000
2014 3347 6740858 4056196 2500

Axis Title
2015 3511 7074665 4060225 2000
2016 3712 7483392 4064256
1500
2017 3829 7723093 4068289
1000
10075 17518 35300555 20301135
500
0
2012.5 2013 2013.5 2014 2014.5 2
Axis
6472 kepadatan
445.992 bangkit

tarikan (x) Kepadatan x.y x^2


Data Tarikan d
297 1100 326700 88209 4000
f(x) = 15.0247200
310 1232 381920 96100 3500 R² = 0.819163143
301 1786 537586 90601 3000

Tarikan Pergerakan
2500
398 2145 853710 158404
2000
367 2350 862450 134689
1500
425 3347 1422475 180625
1000
387 3498 1353726 149769
500
478 3989 1906742 228484 0
2963 19447 7645309 1126881 250 300 350
Jumlah Sara
297 1100
310 1232
301 1786
398 2145 8791701 -1.1159925
367 2350 -7877921
425 3347 a 2844.2107
387 3498
478 3989
Chart Title
00
00
00 f(x) = 178.5x - 356173.899999972
R² = 0.9900913952
00
00
Col umn B
00 Li nea r (Col umn B)
00
00
00
0
2012.5 2013 2013.5 2014 2014.5 2015 2015.5 2016 2016.5 2017 2017.5
Axis Title

Data Tarikan dan Jumlah Hiburan Tahun 2016


00
f(x) = 15.0247200642x - 3133.9056937614
00 R² = 0.8191631435
00
00
00 Col umn B
00 Li nea r (Col umn B)

00
00
0
250 300 350 400 450 500
Jumlah Sarana Hiburan

You might also like