statistika excel

121
No Nama alamat Jenis Kelamin Umur Pendidikan Pekerjaan 1 ZULKIFLI LK 34 S1 PNS 2 MAWAN LK 30 SMA PEDAGANG 3 RIAN LK 29 SMA BURUH 4 FEBRI LK 30 S1 PNS 5 YANTO LK 35 SMA BURUH 6 NAHWAN LK 52 SD WIRASWASTA 7 PAISAL LK 40 SMA PEDAGANG 8 AL SAFFAT GHAZALI LK 33 SMA WIRAUASAHA 9 SYAMSUL RIZAL LK 53 SMA KARYAWAN PTBA 10 NOVAL ARDIAN PRATAMA LK 34 S1 KARYAWAN PERTAMINA 11 M.IQBAL LK 43 SMA WIRAUASAHA 12 FERDI MELSON R LK 42 S1 KARYAWAN PT.PUSRI 13 MARJUNI HARUN LK 55 SMA BURUH 14 SUMIYO LK 48 SMA KARYAWAN BUMN 15 ISMET NUR HUSNI LK 45 S1 WIRASWASTA 16 ADI CHANDRA LK 32 SLTA WIRASWASTA 17 SAHRI SANDI WINATA LK 39 SLTP BURUH 18 RUDI HARTONO LK 31 SD BURUH 19 IR.FIRMANSYAH LK 53 D4 KARYAWAN SWASTA 20 EDI NELSON LK 48 SMA GOJEK 21 AMIR HUSIN LK 28 SMA KARYAWAN SWASTA 22 FATIR RIZKI LK 40 D3 KARYAWAN SWASTA 23 SARLAN PERKASA LK 35 S1 DISHUB 24 RUSDAN LK 42 S1 GURU 25 RUDI PERKASA LK 29 SMA OFFICE BOY 26 S. HABNIN LK 55 SMA PDIKREKTORAT PAJAK 27 M. AKBAR LK 33 S1 POLISI

Upload: ahmad

Post on 10-Jul-2016

240 views

Category:

Documents


3 download

DESCRIPTION

z

TRANSCRIPT

Page 1: Statistika Excel

No Nama alamat Jenis Kelamin Umur Pendidikan Pekerjaan1 ZULKIFLI LK 34 S1 PNS2 MAWAN LK 30 SMA PEDAGANG3 RIAN LK 29 SMA BURUH4 FEBRI LK 30 S1 PNS5 YANTO LK 35 SMA BURUH6 NAHWAN LK 52 SD WIRASWASTA7 PAISAL LK 40 SMA PEDAGANG8 AL SAFFAT GHAZALI LK 33 SMA WIRAUASAHA9 SYAMSUL RIZAL LK 53 SMA KARYAWAN PTBA

10 NOVAL ARDIAN PRATAMA LK 34 S1 KARYAWAN PERTAMINA11 M.IQBAL LK 43 SMA WIRAUASAHA12 FERDI MELSON R LK 42 S1 KARYAWAN PT.PUSRI13 MARJUNI HARUN LK 55 SMA BURUH14 SUMIYO LK 48 SMA KARYAWAN BUMN15 ISMET NUR HUSNI LK 45 S1 WIRASWASTA16 ADI CHANDRA LK 32 SLTA WIRASWASTA17 SAHRI SANDI WINATA LK 39 SLTP BURUH18 RUDI HARTONO LK 31 SD BURUH19 IR.FIRMANSYAH LK 53 D4 KARYAWAN SWASTA20 EDI NELSON LK 48 SMA GOJEK 21 AMIR HUSIN LK 28 SMA KARYAWAN SWASTA22 FATIR RIZKI LK 40 D3 KARYAWAN SWASTA 23 SARLAN PERKASA LK 35 S1 DISHUB 24 RUSDAN LK 42 S1 GURU25 RUDI PERKASA LK 29 SMA OFFICE BOY 26 S. HABNIN LK 55 SMA PDIKREKTORAT PAJAK27 M. AKBAR LK 33 S1 POLISI

Page 2: Statistika Excel

28 Riduan LK 49 S1 PNS29 RIO FEBRIANTO LK 26 S1 POLISI30 DANNY PRADANA LK 27 S1 POLISI31 SALAMAT PURBA LK 55 S2 PNS32 PADRIZAL LK 52 SD WIRAUSAHA33 HAMIDIN SULISTHIO LK 46 D4 WIRASWASTA34 AZHARI BSC LK 53 D3 KARYAWAN SWASTA35 MARDIANTO LK 29 SLTP PNS36 LUKMAN ULHAKIM LK 31 D3 BURUH37 MUHAMAD TOHA ARAFAT,SE,AK LK 44 D4 PNS38 YAN ALBERTHO LK 34 SLTA KARYAWAN SWASTA39 KMS.TAUFI OURRAHMAN,SH LK 47 D4 KARYAWAN SWASTA40 HERMAN LK 25 S1 TNI41 DANIEL LK 30 S1 WIRAUSAHA42 RICO HANIF LK 28 S1 PNS43 BENI PRAKOSO LK 28 SMA BURUH44 SUSANTO LK 35 SLTA BURUH45 ANDIAN LK 30 STM WIRAUSAHA46 YOGI PUTRA LK 40 S1 DISPENDA47 DIDI SAPUTRA LK 34 SLTA WIRAUSAHA48 RUSLAN EFFENDI LK 55 SLTA KARYAWAN SWASTA49 ISHAK HABIBI LK 47 S1 PJKA50 BOBBI LK 52 D4 PLN51 VIVID ARDIANSYAH LK 37 SLTA BURUH52 ARIANTO LK 51 S2 PDAM53 NURALI LK 29 SMA GO JEK54 FEBRI WIJAYA LK 39 SMA PDAM55 BAGUS RAMAHNA LK 28 D4 BURUH56 RAHMAT PURWANTO LK 41 S1 PNS57 ERWIN GUNAWAN LK 36 S1 POLISI58 H.SENEN LK 50 S1 TNI59 ANDIKA KUSUMA LK 43 SMA KARYAWAN SWASTA

Page 3: Statistika Excel

60 DIDI KUSUMA WIJAYA LK 27 D3 PNSTotal 2346rata-rata 39.10nilai Maksimum 55Nilai Minimum 25Median 38Modus 34Mean 39.10Range 30Deviasi Rata-rata 8.21Variasi 88.33Standar Deviasi 9.40

Page 4: Statistika Excel

Jumlah Anak

Penghasilan

Gaji (Pokok) insentif bonus dagang1 Rp 3,500,000.00 Rp 1,000,000.00 1 Rp 4,000,000.00 Rp 2,500,000.00 2 Rp 2,500,000.00 Rp 200,000.00 2 Rp 5,000,000.00 Rp 1,400,000.00 2 Rp 2,800,000.00 Rp 28,000,000.00 2 Rp 12,000,000.00 Rp 6,000,000.00 3 Rp 4,000,000.00 Rp 40,000,000.00 1 Rp 10,000,000.00 Rp 33,000,000.00 2 Rp 18,000,000.00 Rp 30,000,000.00 2 Rp 20,000,000.00 Rp 48,000,000.00 2 Rp 8,000,000.00 Rp 16,000,000.00 3 Rp 15,000,000.00 Rp 25,000,000.00 6 Rp 2,000,000.00 Rp 500,000.00 3 Rp 4,500,000.00 Rp 500,000.00 3 Rp 5,000,000.00 Rp 500,000.00 3 Rp 3,000,000.00 Rp 300,000.00 1 Rp 2,500,000.00 Rp 500,000.00 2 Rp 2,000,000.00 Rp 200,000.00 2 Rp 5,000,000.00 Rp 500,000.00 3 Rp 3,000,000.00 Rp 500,000.00 1 Rp 2,500,000.00 Rp 5,000,000.00 2 Rp 15,000,000.00 Rp 10,000,000.00 2 Rp 4,000,000.00 Rp 27,000,000.00 2 Rp 4,500,000.00 1 Rp 700,000.00 4 Rp 17,000,000.00 2 Rp 4,000,000.00 Rp 2,000,000.00

Page 5: Statistika Excel

3 Rp 10,000,000.00 1 Rp 7,000,000.00 Rp 10,000,000.00 1 Rp 7,000,000.00 Rp 12,000,000.00 4 Rp 9,000,000.00 Rp 7,000,000.00 3 Rp 2,500,000.00 2 Rp 5,500,000.00 Rp 500,000.00 2 Rp 5,000,000.00 Rp 300,000.00 1 Rp 6,000,000.00 Rp 1,000,000.00 2 Rp 3,000,000.00 Rp 50,000.00 1 Rp 7,500,000.00 Rp 500,000.00 2 Rp 4,500,000.00 Rp 400,000.00 3 Rp 5,000,000.00 Rp 3,000,000.00 2 Rp 5,000,000.00 2 Rp 10,000,000.00 2 Rp 2,800,000.00 1 Rp 2,700,000.00 Rp 200,000.00 2 Rp 2,600,000.00 3 Rp 28,000,000.00 2 Rp 5,000,000.00 Rp 500,000.00 2 Rp 15,000,000.00 3 Rp 2,000,000.00 Rp 500,000.00 2 Rp 6,000,000.00 Rp 1,500,000.00 3 Rp 4,500,000.00 Rp 1,000,000.00 2 Rp 2,500,000.00 4 Rp 16,000,000.00 Rp 10,000,000.00 1 Rp 3,000,000.00 2 Rp 2,800,000.00 Rp 500,000.00 1 Rp 2,500,000.00 Rp 200,000.00 2 Rp 3,500,000.00 3 Rp 5,000,000.00 Rp 1,500,000.00 2 Rp 4,500,000.00 Rp 2,000,000.00 2 Rp 3,400,000.00 Rp 500,000.00

Page 6: Statistika Excel

1 Rp 3,000,000.00 129 Rp 381,300,000.00 Rp 331,750,000.00

2.15 Rp 6,355,000.00 Rp 7,372,222.22 6 Rp 28,000,000.00 Rp 48,000,000.00 1 Rp 700,000.00 Rp 50,000.00 2 Rp 4,500,000.00 Rp 1,000,000.00 2 Rp 5,000,000.00 Rp 500,000.00

2.15 Rp 6,355,000.00 Rp 7,372,222.22 5 Rp 27,300,000.00 Rp 47,950,000.00

0.68 Rp 3,882,166.67 Rp 8,912,592.59 0.91 Rp 28,545,906,779,661.00 Rp 146,169,949,494,950.00 0.95 Rp 5,342,836.96 Rp 12,090,076.49

Page 7: Statistika Excel

Total Pengeluran

RpKonsumsi Makanan

Beras Gula Minyak Sayur Rp 4,500,000.00 Rp 350,000.00 Rp 38,000.00 Rp 33,000.00 Rp 6,500,000.00 Rp 300,000.00 Rp 20,000.00 Rp 22,000.00 Rp 2,700,000.00 Rp 250,000.00 Rp 20,000.00 Rp 22,000.00 Rp 6,400,000.00 Rp 340,000.00 Rp 30,000.00 Rp 28,000.00 Rp 30,800,000.00 Rp 267,000.00 Rp 22,000.00 Rp 15,000.00 Rp 18,000,000.00 Rp 400,000.00 Rp 25,000.00 Rp 33,000.00 Rp 44,000,000.00 Rp 420,000.00 Rp 43,000.00 Rp 40,000.00 Rp 43,000,000.00 Rp 85,000.00 Rp 7,500.00 Rp 50,000.00 Rp 48,000,000.00 Rp 220,000.00 Rp 12,200.00 Rp 840,000.00 Rp 68,000,000.00 Rp 350,000.00 Rp 20,000.00 Rp 75,000.00 Rp 24,000,000.00 Rp 98,000.00 Rp 8,000.00 Rp 45,000.00 Rp 40,000,000.00 Rp 289,000.00 Rp 79,000.00 Rp 2,500,000.00 Rp 150,000.00 Rp 50,000.00 Rp 44,000.00 Rp 5,000,000.00 Rp 220,000.00 Rp 32,000.00 Rp 44,000.00 Rp 5,500,000.00 Rp 220,000.00 Rp 100,000.00 Rp 88,000.00 Rp 3,300,000.00 Rp 120,000.00 Rp 25,000.00 Rp 22,000.00 Rp 3,000,000.00 Rp 110,000.00 Rp 28,000.00 Rp 33,000.00 Rp 2,200,000.00 Rp 130,000.00 Rp 25,000.00 Rp 22,000.00 Rp 5,500,000.00 Rp 220,000.00 Rp 45,000.00 Rp 44,000.00 Rp 3,500,000.00 Rp 500,000.00 Rp 10,000.00 Rp 40,000.00 Rp 7,500,000.00 Rp 80,000.00 Rp 40,000.00 Rp 60,000.00 Rp 25,000,000.00 Rp 65,000.00 Rp 12,000.00 Rp 45,000.00 Rp 31,000,000.00 Rp 400,000.00 Rp 300,000.00 Rp 200,000.00 Rp 4,500,000.00 Rp 200,000.00 Rp 40,000.00 Rp 80,000.00 Rp 700,000.00 Rp 60,000.00 Rp 20,000.00 Rp 30,000.00 Rp 17,000,000.00 Rp 1,500,000.00 Rp 150,000.00 Rp 300,000.00 Rp 6,000,000.00 Rp 80,000.00 Rp 25,000.00 Rp 32,000.00

Page 8: Statistika Excel

Rp 10,000,000.00 Rp 400,000.00 Rp 100,000.00 Rp 66,000.00 Rp 17,000,000.00 Rp 250,000.00 Rp 15,000.00 Rp 22,000.00 Rp 19,000,000.00 Rp 250,000.00 Rp 15,000.00 Rp 11,000.00 Rp 16,000,000.00 Rp 250,000.00 Rp 11,000.00 Rp 22,000.00 Rp 2,500,000.00 Rp 300,000.00 Rp 22,000.00 Rp 22,000.00 Rp 6,000,000.00 Rp 220,000.00 Rp 15,000.00 Rp 44,000.00 Rp 5,300,000.00 Rp 150,000.00 Rp 15,000.00 Rp 44,000.00 Rp 7,000,000.00 Rp 150,000.00 Rp 10,000.00 Rp 22,000.00 Rp 3,050,000.00 Rp 220,000.00 Rp 20,000.00 Rp 44,000.00 Rp 8,000,000.00 Rp 150,000.00 Rp 10,000.00 Rp 22,000.00 Rp 4,900,000.00 Rp 220,000.00 Rp 15,000.00 Rp 44,000.00 Rp 8,000,000.00 Rp 300,000.00 Rp 20,000.00 Rp 55,000.00 Rp 5,000,000.00 Rp 200,000.00 Rp 11,000.00 Rp 22,000.00 Rp 10,000,000.00 Rp 250,000.00 Rp 22,000.00 Rp 11,000.00 Rp 2,800,000.00 Rp 300,000.00 Rp 16,000.00 Rp 22,000.00 Rp 2,900,000.00 Rp 240,000.00 Rp 35,000.00 Rp 30,000.00 Rp 2,600,000.00 Rp 350,000.00 Rp 30,000.00 Rp 33,000.00 Rp 28,000,000.00 Rp 250,000.00 Rp 20,000.00 Rp 11,000.00 Rp 5,500,000.00 Rp 350,000.00 Rp 22,000.00 Rp 26,000.00 Rp 15,000,000.00 Rp 260,000.00 Rp 33,000.00 Rp 22,000.00 Rp 2,500,000.00 Rp 400,000.00 Rp 40,000.00 Rp 30,000.00 Rp 7,500,000.00 Rp 300,000.00 Rp 22,000.00 Rp 33,000.00 Rp 5,500,000.00 Rp 340,000.00 Rp 33,000.00 Rp 22,000.00 Rp 2,500,000.00 Rp 300,000.00 Rp 22,000.00 Rp 25,000.00 Rp 26,000,000.00 Rp 400,000.00 Rp 35,000.00 Rp 22,000.00 Rp 3,000,000.00 Rp 200,000.00 Rp 11,000.00 Rp 15,000.00 Rp 3,300,000.00 Rp 300,000.00 Rp 22,000.00 Rp 25,000.00 Rp 2,700,000.00 Rp 250,000.00 Rp 22,000.00 Rp 30,000.00 Rp 3,500,000.00 Rp 320,000.00 Rp 22,000.00 Rp 22,000.00 Rp 6,500,000.00 Rp 380,000.00 Rp 11,000.00 Rp 11,000.00 Rp 6,500,000.00 Rp 320,000.00 Rp 22,000.00 Rp 25,000.00 Rp 3,900,000.00 Rp 300,000.00 Rp 25,000.00 Rp 22,000.00

Page 9: Statistika Excel

Rp 3,000,000.00 Rp 250,000.00 Rp 30,000.00 Rp 33,000.00 Rp 713,050,000.00 Rp 16,544,000.00 Rp 1,921,700.00 Rp 3,276,000.00 Rp 11,884,166.67 Rp 275,733.33 Rp 32,571.19 Rp 54,600.00 Rp 68,000,000.00 Rp 1,500,000.00 Rp 300,000.00 Rp 840,000.00 Rp 700,000.00 Rp 60,000.00 Rp 7,500.00 Rp 11,000.00 Rp 5,750,000.00 Rp 250,000.00 Rp 22,000.00 Rp 30,000.00 Rp 2,500,000.00 Rp 300,000.00 Rp 22,000.00 Rp 22,000.00 Rp 11,884,166.67 Rp 275,733.33 Rp 32,571.19 Rp 54,600.00 Rp 67,300,000.00 Rp 1,440,000.00 Rp 292,500.00 Rp 829,000.00 Rp 10,258,972.22 Rp 101,331.11 Rp 20,116.35 Rp 43,233.33 Rp 191,731,482,344,633.00 Rp 35,842,910,734.46 Rp 1,810,431,741.67 Rp 12,545,667,796.61 Rp 13,846,713.77 Rp 189,322.24 Rp 42,549.17 Rp 112,007.45

Page 10: Statistika Excel

PengeluranKonsumsi Makanan Total Belanja Sandang

Kopi Tehh Rp Baju Rp 25,000.00 Rp 446,000.00 Rp 1,500,000.00 Rp 20,000.00 Rp 362,000.00 Rp 850,000.00 Rp 28,000.00 Rp 320,000.00 Rp 700,000.00 Rp 30,000.00 Rp 10,000.00 Rp 438,000.00 Rp 2,000,000.00 Rp 14,000.00 Rp 23,000.00 Rp 341,000.00 Rp 1,000,000.00

Rp 24,000.00 Rp 482,000.00 Rp 4,000,000.00 Rp 25,000.00 Rp 24,000.00 Rp 552,000.00 Rp 1,300,000.00 Rp 18,000.00 Rp 160,500.00 Rp 1,000,000.00 Rp 13,000.00 Rp 10,000.00 Rp 1,095,200.00 Rp 10,000,000.00

Rp 17,000.00 Rp 462,000.00 Rp 8,000,000.00 Rp 5,000.00 Rp 156,000.00 Rp 800,000.00 Rp 11,000.00 Rp 379,000.00 Rp 6,000,000.00

Rp 20,000.00 Rp 7,000.00 Rp 271,000.00 Rp 1,000,000.00 Rp 10,000.00 Rp 306,000.00 Rp 1,000,000.00

Rp 42,000.00 Rp 21,000.00 Rp 471,000.00 Rp 2,000,000.00 Rp 10,000.00 Rp 177,000.00 Rp 500,000.00 Rp 24,000.00 Rp 195,000.00 Rp 600,000.00 Rp 10,000.00 Rp 187,000.00 Rp 400,000.00

Rp 5,000.00 Rp 314,000.00 Rp 500,000.00 Rp 10,000.00 Rp 10,000.00 Rp 570,000.00 Rp 200,000.00

Rp 20,000.00 Rp 200,000.00 Rp 100,000.00 Rp 12,000.00 Rp 134,000.00 Rp 1,000,000.00

Rp 300,000.00 Rp 250,000.00 Rp 1,450,000.00 Rp 700,000.00 Rp 50,000.00 Rp 40,000.00 Rp 410,000.00 Rp 400,000.00 Rp 30,000.00 Rp 25,000.00 Rp 165,000.00 Rp 200,000.00

Rp 100,000.00 Rp 2,050,000.00 Rp 3,000,000.00 Rp 8,000.00 Rp 145,000.00 Rp 250,000.00

Page 11: Statistika Excel

Rp 10,000.00 Rp 576,000.00 Rp 1,000,000.00 Rp 15,000.00 Rp 302,000.00 Rp 4,000,000.00

Rp 15,000.00 Rp 291,000.00 Rp 4,000,000.00 Rp 15,000.00 Rp 298,000.00 Rp 5,000,000.00 Rp 10,000.00 Rp 354,000.00 Rp 2,000,000.00

Rp 10,000.00 Rp 289,000.00 Rp 1,600,000.00 Rp 20,000.00 Rp 229,000.00 Rp 2,000,000.00 Rp 10,000.00 Rp 192,000.00 Rp 3,000,000.00 Rp 32,000.00 Rp 316,000.00 Rp 2,000,000.00 Rp 30,000.00 Rp 212,000.00 Rp 3,000,000.00 Rp 20,000.00 Rp 20,000.00 Rp 319,000.00 Rp 5,000,000.00 Rp 40,000.00 Rp 15,000.00 Rp 430,000.00 Rp 3,500,000.00

Rp 12,000.00 Rp 245,000.00 Rp 2,300,000.00 Rp 10,000.00 Rp 20,000.00 Rp 313,000.00 Rp 4,000,000.00

Rp 15,000.00 Rp 353,000.00 Rp 3,500,000.00 Rp 20,000.00 Rp 325,000.00 Rp 2,000,000.00 Rp 10,000.00 Rp 423,000.00 Rp 1,500,000.00 Rp 15,000.00 Rp 296,000.00 Rp 5,000,000.00 Rp 20,000.00 Rp 418,000.00 Rp 2,300,000.00

Rp 15,000.00 Rp 330,000.00 Rp 4,500,000.00 Rp 10,000.00 Rp 10,000.00 Rp 490,000.00 Rp 1,000,000.00 Rp 22,000.00 Rp 377,000.00 Rp 800,000.00

Rp 20,000.00 Rp 415,000.00 Rp 2,300,000.00 Rp 15,000.00 Rp 12,000.00 Rp 374,000.00 Rp 1,500,000.00 Rp 20,000.00 Rp 477,000.00 Rp 2,000,000.00 Rp 20,000.00 Rp 246,000.00 Rp 1,300,000.00 Rp 12,000.00 Rp 20,000.00 Rp 379,000.00 Rp 2,200,000.00 Rp 15,000.00 Rp 317,000.00 Rp 1,200,000.00

Rp 20,000.00 Rp 384,000.00 Rp 2,800,000.00 Rp 15,000.00 Rp 417,000.00 Rp 3,000,000.00

Rp 15,000.00 Rp 18,000.00 Rp 400,000.00 Rp 2,000,000.00 Rp 20,000.00 Rp 367,000.00 Rp 2,500,000.00

Page 12: Statistika Excel

Rp 15,000.00 Rp 328,000.00 Rp 2,000,000.00 Rp 1,065,000.00 Rp 914,000.00 Rp 23,720,700.00 Rp 134,800,000.00 Rp 27,307.69 Rp 24,052.63 Rp 395,345.00 Rp 2,246,666.67 Rp 300,000.00 Rp 250,000.00 Rp 2,050,000.00 Rp 10,000,000.00 Rp 10,000.00 Rp 5,000.00 Rp 134,000.00 Rp 100,000.00 Rp 20,000.00 Rp 15,000.00 Rp 335,500.00 Rp 2,000,000.00 Rp 20,000.00 Rp 10,000.00 Rp 379,000.00 Rp 2,000,000.00 Rp 27,307.69 Rp 24,052.63 Rp 395,345.00 Rp 2,246,666.67 Rp 290,000.00 Rp 245,000.00 Rp 1,916,000.00 Rp 9,900,000.00 Rp 17,242.60 Rp 16,778.39 Rp 152,176.67 Rp 1,375,777.78 Rp 2,099,534,412.96 Rp 1,649,780,938.83 Rp 88,422,510,991.53 Rp 3,612,615,819,209.04 Rp 45,820.68 Rp 40,617.50 Rp 297,359.23 Rp 1,900,688.25

Page 13: Statistika Excel

PengeluranBelanja Sandang

Sepatu/Sandal Perhiasan Jam Tangan Celana/Rok Rp 500,000.00 Rp 700,000.00 Rp 420,000.00 Rp 1,000,000.00 Rp 450,000.00 Rp 1,400,000.00 Rp 500,000.00 Rp 680,000.00 Rp 300,000.00 Rp 2,800,000.00 Rp 350,000.00 Rp 700,000.00 Rp 1,200,000.00 Rp 3,000,000.00 Rp 1,000,000.00 Rp 1,800,000.00 Rp 278,000.00 Rp 1,400,000.00 Rp 56,000.00 Rp 855,000.00 Rp 1,000,000.00 Rp 6,200,000.00 Rp 2,500,000.00 Rp 2,500,000.00 Rp 450,000.00 Rp 1,600,000.00 Rp 475,000.00 Rp 920,000.00 Rp 450,000.00 Rp 1,500,000.00 Rp 200,000.00 Rp 1,000,000.00 Rp 430,000.00 Rp 5,000,000.00 Rp 1,000,000.00 Rp 10,000,000.00 Rp 550,000.00 Rp 2,500,000.00 Rp 1,000,000.00 Rp 8,000,000.00 Rp 250,000.00 Rp 1,200,000.00 Rp 150,000.00 Rp 800,000.00 Rp 600,000.00 Rp 1,500,000.00 Rp 200,000.00 Rp 6,000,000.00 Rp 600,000.00 Rp 1,500,000.00 Rp 45,000.00 Rp 350,000.00 Rp 500,000.00 Rp 1,500,000.00 Rp 250,000.00 Rp 500,000.00 Rp 1,000,000.00 Rp 3,000,000.00 Rp 245,000.00 Rp 500,000.00 Rp 300,000.00 Rp 750,000.00 Rp 70,000.00 Rp 300,000.00

### Rp 150,000.00 Rp 90,000.00 Rp 350,000.00 Rp 150,000.00 Rp 75,000.00 Rp 70,000.00 Rp 300,000.00 Rp 200,000.00 Rp 150,000.00 Rp 90,000.00 Rp 600,000.00 Rp 180,000.00 Rp 400,000.00 Rp 200,000.00 Rp 20,000.00 Rp 150,000.00 Rp 80,000.00 Rp 30,000.00 Rp 1,000,000.00 Rp 700,000.00 Rp 2,000,000.00 Rp 600,000.00 Rp 400,000.00

### Rp 500,000.00 Rp 50,000.00 Rp 250,000.00 Rp 30,000.00 Rp 150,000.00 Rp 1,200,000.00 Rp 1,000,000.00 Rp 400,000.00 Rp 2,800,000.00 Rp 192,000.00 Rp 65,000.00 Rp 165,000.00

Page 14: Statistika Excel

Rp 1,000,000.00 Rp 3,000,000.00 Rp 250,000.00 Rp 400,000.00 Rp 1,250,000.00 Rp 6,500,000.00 Rp 1,000,000.00 Rp 3,900,000.00 Rp 2,300,000.00 Rp 6,000,000.00 Rp 1,500,000.00 Rp 3,800,000.00 Rp 1,500,000.00 Rp 50,000,000.00 Rp 2,500,000.00 Rp 800,000.00 Rp 1,000,000.00 Rp 2,000,000.00 Rp 400,000.00 Rp 1,500,000.00 Rp 90,000.00 Rp 4,000,000.00 Rp 500,000.00 Rp 3,000,000.00 Rp 100,000.00 Rp 3,500,000.00 Rp 300,000.00 Rp 150,000.00 ### Rp 3,000,000.00 Rp 400,000.00 Rp 2,500,000.00 Rp 50,000.00 Rp 2,500,000.00 Rp 350,000.00 Rp 3,000,000.00 Rp 200,000.00 Rp 1,000,000.00 Rp 450,000.00 Rp 1,500,000.00 Rp 150,000.00 Rp 1,500,000.00 Rp 500,000.00 Rp 3,000,000.00 Rp 250,000.00 Rp 2,000,000.00 Rp 800,000.00 Rp 1,000,000.00 Rp 1,100,000.00 Rp 2,500,000.00 Rp 2,200,000.00 Rp 400,000.00 Rp 3,000,000.00 Rp 1,200,000.00 Rp 500,000.00 Rp 2,200,000.00 Rp 1,000,000.00 Rp 1,500,000.00 Rp 200,000.00 Rp 2,500,000.00 Rp 2,300,000.00 Rp 2,000,000.00 Rp 1,800,000.00 Rp 1,500,000.00 Rp 1,000,000.00 ### Rp 500,000.00 Rp 600,000.00 Rp 300,000.00 Rp 1,500,000.00 Rp 2,500,000.00 Rp 6,000,000.00 Rp 2,000,000.00 Rp 4,000,000.00 Rp 400,000.00 Rp 400,000.00 ### Rp 1,200,000.00 Rp 1,500,000.00 Rp 3,000,000.00 ### Rp 1,000,000.00 Rp 1,500,000.00 Rp 2,200,000.00 Rp 1,500,000.00 Rp 800,000.00 Rp 200,000.00 Rp 8,000,000.00 Rp 5,000,000.00 Rp 9,000,000.00 Rp 3,500,000.00 Rp 4,500,000.00 Rp 2,000,000.00 Rp 500,000.00 Rp 600,000.00 Rp 1,500,000.00 Rp 1,000,000.00 Rp 50,000.00 Rp 1,200,000.00 Rp 2,200,000.00 Rp 200,000.00 Rp 100,000.00 Rp 2,000,000.00 Rp 1,200,000.00 Rp 200,000.00 Rp 1,800,000.00 Rp 500,000.00 Rp 300,000.00 Rp 1,000,000.00 Rp 600,000.00 Rp 1,000,000.00 Rp 300,000.00 Rp 2,500,000.00 Rp 1,000,000.00 Rp 500,000.00 Rp 200,000.00 Rp 1,500,000.00

Page 15: Statistika Excel

Rp 1,800,000.00 Rp 600,000.00 Rp 2,100,000.00 Rp 54,010,000.00 Rp 153,425,000.00 Rp 22,316,000.00 Rp 121,900,000.00 Rp 900,166.67 Rp 2,841,203.70 Rp 474,808.51 Rp 2,031,666.67 Rp 5,000,000.00 Rp 50,000,000.00 Rp 3,500,000.00 Rp 10,000,000.00 Rp 20,000.00 Rp 75,000.00 Rp 45,000.00 Rp 80,000.00 Rp 575,000.00 Rp 1,500,000.00 Rp 245,000.00 Rp 1,500,000.00 Rp 1,000,000.00 Rp 1,500,000.00 Rp 200,000.00 Rp 1,000,000.00 Rp 900,166.67 Rp 2,841,203.70 Rp 474,808.51 Rp 2,031,666.67 Rp 4,980,000.00 Rp 49,925,000.00 Rp 3,455,000.00 Rp 9,920,000.00 Rp 601,533.33 Rp 2,589,746.23 Rp 424,565.87 Rp 1,393,444.44 Rp 710,307,564,971.75 Rp 46,297,102,769,042.60 Rp 457,928,462,534.69 Rp 4,007,004,802,259.89 Rp 842,797.46 Rp 6,804,197.44 Rp 676,704.12 Rp 2,001,750.43

Page 16: Statistika Excel

PengeluranBelanja Sandang Total Energi & Komunikasi

Jilbab Rp Listrik PDAM Rp 267,000.00 Rp 4,387,000.00 Rp 100,000.00 Rp 90,000.00

Rp 3,880,000.00 Rp 100,000.00 Rp 80,000.00 Rp 150,000.00 Rp 5,000,000.00 Rp 80,000.00 Rp 60,000.00

Rp 9,000,000.00 Rp 120,000.00 Rp 75,000.00 Rp 3,589,000.00 Rp 200,000.00 Rp 95,000.00

Rp 500,000.00 Rp 16,700,000.00 Rp 150,000.00 Rp 300,000.00 Rp 185,000.00 Rp 4,930,000.00 Rp 170,000.00 Rp 100,000.00

Rp 4,150,000.00 Rp 85,000.00 Rp 100,000.00 Rp 26,430,000.00 Rp 600,000.00 Rp 200,000.00 Rp 20,050,000.00 Rp 200,000.00 ###

Rp 65,000.00 Rp 3,265,000.00 Rp 200,000.00 ### Rp 14,300,000.00 Rp 150,000.00 Rp 100,000.00

Rp 100,000.00 Rp 3,595,000.00 Rp 125,000.00 Rp 200,000.00 Rp 150,000.00 Rp 3,900,000.00 Rp 300,000.00 Rp 200,000.00 Rp 300,000.00 Rp 7,045,000.00 Rp 400,000.00 Rp 300,000.00 Rp 50,000.00 Rp 1,970,000.00 Rp 200,000.00 Rp 150,000.00 Rp 100,000.00 Rp 1,590,000.00 Rp 150,000.00 Rp 100,000.00 Rp 100,000.00 Rp 1,095,000.00 Rp 125,000.00 Rp 75,000.00 Rp 200,000.00 Rp 1,740,000.00 Rp 200,000.00 ### Rp 100,000.00 Rp 1,080,000.00 Rp 100,000.00 Rp 120,000.00 Rp 30,000.00 Rp 380,000.00 Rp 40,000.00 Rp 35,000.00

Rp 2,030,000.00 Rp 100,000.00 Rp 65,000.00 Rp 200,000.00 Rp 4,600,000.00 Rp 300,000.00 Rp 320,000.00

Rp 1,600,000.00 Rp 250,000.00 Rp 230,000.00 Rp 40,000.00 Rp 420,000.00 Rp 50,000.00 Rp 55,000.00 Rp 400,000.00 Rp 8,800,000.00 Rp 400,000.00 ###

Rp 672,000.00 Rp 250,000.00 Rp 125,000.00

Page 17: Statistika Excel

Rp 5,650,000.00 Rp 200,000.00 Rp 100,000.00 Rp 400,000.00 Rp 17,050,000.00 Rp 90,000.00 ### Rp 750,000.00 Rp 18,350,000.00 Rp 100,000.00 ###

Rp 59,000,000.00 Rp 120,000.00 Rp 300,000.00 Rp 200,000.00 Rp 6,000,000.00 Rp 100,000.00 Rp 250,000.00 Rp 150,000.00 Rp 7,740,000.00 Rp 200,000.00 Rp 125,000.00 Rp 200,000.00 Rp 9,300,000.00 Rp 300,000.00 Rp 200,000.00 Rp 500,000.00 Rp 7,100,000.00 Rp 250,000.00 Rp 150,000.00 Rp 120,000.00 Rp 7,570,000.00 Rp 200,000.00 ### Rp 100,000.00 Rp 7,650,000.00 Rp 300,000.00 Rp 150,000.00 Rp 150,000.00 Rp 8,750,000.00 Rp 150,000.00 Rp 250,000.00 Rp 250,000.00 Rp 9,500,000.00 Rp 400,000.00 Rp 300,000.00 Rp 200,000.00 Rp 5,400,000.00 Rp 100,000.00 Rp 250,000.00 Rp 300,000.00 Rp 12,400,000.00 Rp 150,000.00 Rp 110,000.00 Rp 220,000.00 Rp 7,620,000.00 Rp 200,000.00 Rp 280,000.00 Rp 100,000.00 Rp 7,300,000.00 Rp 250,000.00 Rp 150,000.00 Rp 80,000.00 Rp 7,680,000.00 Rp 240,000.00 Rp 100,000.00 Rp 200,000.00 Rp 8,700,000.00 Rp 210,000.00 Rp 300,000.00 Rp 230,000.00 Rp 5,430,000.00 Rp 100,000.00 Rp 98,000.00 Rp 150,000.00 Rp 19,150,000.00 Rp 150,000.00 Rp 72,000.00 Rp 250,000.00 Rp 3,650,000.00 Rp 220,000.00 Rp 87,000.00 Rp 140,000.00 Rp 8,440,000.00 Rp 90,000.00 Rp 100,000.00 Rp 150,000.00 Rp 7,150,000.00 Rp 200,000.00 Rp 98,000.00 Rp 200,000.00 Rp 12,200,000.00 Rp 150,000.00 Rp 250,000.00 Rp 250,000.00 Rp 24,250,000.00 Rp 230,000.00 Rp 178,000.00 Rp 300,000.00 Rp 6,200,000.00 Rp 100,000.00 Rp 300,000.00 Rp 180,000.00 Rp 4,630,000.00 Rp 200,000.00 Rp 89,000.00 Rp 250,000.00 Rp 5,950,000.00 Rp 120,000.00 Rp 55,000.00 Rp 150,000.00 Rp 6,150,000.00 Rp 80,000.00 Rp 83,000.00 Rp 250,000.00 Rp 5,050,000.00 Rp 100,000.00 Rp 76,000.00 Rp 300,000.00 Rp 6,700,000.00 Rp 150,000.00 Rp 100,000.00 Rp 200,000.00 Rp 5,900,000.00 Rp 120,000.00 Rp 55,000.00

Page 18: Statistika Excel

Rp 180,000.00 Rp 6,680,000.00 Rp 100,000.00 Rp 120,000.00 Rp 10,037,000.00 Rp 496,488,000.00 Rp 10,815,000.00 Rp 9,341,000.00 Rp 209,104.17 Rp 8,274,800.00 Rp 180,250.00 Rp 155,683.33 Rp 750,000.00 Rp 59,000,000.00 Rp 600,000.00 Rp 400,000.00 Rp 30,000.00 Rp 380,000.00 Rp 40,000.00 Rp 35,000.00 Rp 200,000.00 Rp 6,175,000.00 Rp 150,000.00 Rp 120,000.00 Rp 200,000.00 Rp 100,000.00 Rp 100,000.00 Rp 209,104.17 Rp 8,274,800.00 Rp 180,250.00 Rp 155,683.33 Rp 720,000.00 Rp 58,620,000.00 Rp 560,000.00 Rp 365,000.00 Rp 90,092.88 Rp 5,114,120.00 Rp 74,441.67 Rp 74,242.78 Rp 17,339,584,663.12 Rp 76,492,130,027,118.60 Rp 10,028,326,271.19 Rp 7,573,609,887.01 Rp 131,679.86 Rp 8,745,977.93 Rp 100,141.53 Rp 87,026.49

Page 19: Statistika Excel

PengeluranEnergi & Komunikasi Total

Gas M. Tanah Telp Pulsa Rp Rp 42,000.00 Rp 64,000.00 Rp 150,000.00 Rp 446,000.00 Rp 38,000.00 Rp 100,000.00 Rp 318,000.00 Rp 38,000.00 Rp 80,000.00 Rp 258,000.00 Rp 42,000.00 Rp 50,000.00 Rp 200,000.00 Rp 487,000.00 Rp 38,000.00 Rp 210,000.00 Rp 543,000.00 Rp 60,000.00 Rp 300,000.00 Rp 810,000.00 Rp 74,000.00 Rp 240,000.00 Rp 584,000.00 Rp 74,000.00 Rp 100,000.00 Rp 359,000.00 Rp 185,000.00 Rp 200,000.00 Rp 300,000.00 Rp 1,485,000.00 Rp 160,000.00 Rp 100,000.00 Rp 100,000.00 Rp 760,000.00 Rp 42,000.00 Rp 100,000.00 Rp 542,000.00 Rp 74,000.00 Rp 85,000.00 Rp 150,000.00 Rp 559,000.00 Rp 72,000.00 Rp 80,000.00 Rp 477,000.00 Rp 36,000.00 Rp 100,000.00 Rp 636,000.00 Rp 144,000.00 Rp 200,000.00 Rp 1,044,000.00 Rp 72,000.00 Rp 120,000.00 Rp 542,000.00 Rp 36,000.00 Rp 80,000.00 Rp 366,000.00 Rp 36,000.00 Rp 60,000.00 Rp 296,000.00 Rp 72,000.00 Rp 120,000.00 Rp 592,000.00 Rp 60,000.00 Rp 50,000.00 Rp 330,000.00 Rp 24,000.00 Rp 99,000.00 Rp 24,000.00 Rp 100,000.00 Rp 289,000.00 Rp 80,000.00 Rp 100,000.00 Rp 800,000.00 Rp 80,000.00 Rp 70,000.00 Rp 630,000.00 Rp 40,000.00 Rp 20,000.00 Rp 165,000.00 Rp 400,000.00 Rp 150,000.00 Rp 170,000.00 Rp 1,520,000.00 Rp 29,000.00 Rp 100,000.00 Rp 504,000.00

Page 20: Statistika Excel

Rp 72,000.00 Rp 350,000.00 Rp 51,487,000.00 Rp 50,000.00 Rp 300,000.00 Rp 530,000.00 Rp 66,000.00 Rp 200,000.00 Rp 466,000.00 Rp 660,000.00 Rp 250,000.00 Rp 1,330,000.00 Rp 700,000.00 Rp 100,000.00 Rp 1,150,000.00 Rp 72,000.00 Rp 80,000.00 Rp 477,000.00 Rp 56,000.00 Rp 100,000.00 Rp 656,000.00 Rp 36,000.00 Rp 120,000.00 Rp 556,000.00 Rp 72,000.00 Rp 100,000.00 Rp 572,000.00 Rp 36,000.00 Rp 300,000.00 Rp 786,000.00 Rp 56,000.00 Rp 100,000.00 Rp 556,000.00 Rp 72,000.00 Rp 500,000.00 Rp 1,272,000.00 Rp 65,000.00 Rp 100,000.00 Rp 515,000.00 Rp 120,000.00 Rp 50,000.00 Rp 430,000.00 Rp 89,000.00 Rp 25,000.00 Rp 594,000.00 Rp 45,000.00 Rp 25,000.00 Rp 470,000.00 Rp 133,000.00 Rp 50,000.00 Rp 523,000.00 Rp 89,000.00 Rp 100,000.00 Rp 699,000.00 Rp 190,000.00 Rp 50,000.00 Rp 438,000.00 Rp 55,000.00 Rp 10,000.00 Rp 287,000.00 Rp 67,000.00 Rp 12,000.00 Rp 386,000.00 Rp 68,000.00 Rp 5,000.00 Rp 263,000.00 Rp 94,000.00 Rp 50,000.00 Rp 442,000.00 Rp 54,000.00 Rp 10,000.00 Rp 464,000.00 Rp 167,000.00 Rp 12,000.00 Rp 587,000.00 Rp 67,000.00 Rp 25,000.00 Rp 492,000.00 Rp 89,000.00 Rp 50,000.00 Rp 428,000.00 Rp 45,000.00 Rp 100,000.00 Rp 320,000.00 Rp 36,000.00 Rp 50,000.00 Rp 249,000.00 Rp 56,000.00 Rp 25,000.00 Rp 257,000.00 Rp 88,000.00 Rp 50,000.00 Rp 388,000.00 Rp 120,000.00 Rp 25,000.00 Rp 320,000.00

Page 21: Statistika Excel

Rp 78,000.00 Rp 100,000.00 Rp 398,000.00 Rp 5,835,000.00 Rp 220,000.00 Rp 839,000.00 Rp 6,414,000.00 Rp 84,229,000.00 Rp 97,250.00 Rp 73,333.33 Rp 104,875.00 Rp 118,777.78 Rp 1,403,816.67 Rp 700,000.00 Rp 150,000.00 Rp 200,000.00 Rp 500,000.00 Rp 51,487,000.00 Rp 24,000.00 Rp 20,000.00 Rp 50,000.00 Rp 5,000.00 Rp 99,000.00 Rp 67,500.00 Rp 50,000.00 Rp 92,500.00 Rp 100,000.00 Rp 498,000.00 Rp 72,000.00 Rp 100,000.00 Rp 100,000.00 Rp 542,000.00 Rp 97,250.00 Rp 73,333.33 Rp 104,875.00 Rp 118,777.78 Rp 1,403,816.67 Rp 676,000.00 Rp 130,000.00 Rp 150,000.00 Rp 505,000.00 Rp 51,388,000.00 Rp 63,641.67 Rp 51,111.11 Rp 40,062.50 Rp 73,732.51 Rp 1,676,018.33 Rp 15,142,427,966.10 Rp 4,633,333,333.33 Rp 2,804,410,714.29 Rp 10,252,779,874.21 Rp 43,322,551,677,683.60 Rp 123,054.57 Rp 68,068.59 Rp 52,956.69 Rp 101,256.01 Rp 6,581,986.91

Page 22: Statistika Excel

PengeluranKesehatan & Kecantikan Total

Vitamin Pijat Obat dll Rp Rp 11,000.00 Rp 150,000.00 Rp 50,000.00 Rp 45,000.00 Rp 256,000.00 Rp 50,000.00 Rp 500,000.00 Rp 113,500.00 Rp 663,500.00

Rp 25,000.00 Rp 55,000.00 Rp 100,000.00 Rp 180,000.00 Rp 23,000.00 Rp 250,000.00 Rp 100,000.00 Rp 245,000.00 Rp 618,000.00

Rp 30,000.00 Rp 300,000.00 Rp 125,000.00 Rp 455,000.00 Rp 30,000.00 Rp 100,000.00 Rp 200,000.00 Rp 72,000.00 Rp 305,000.00

Rp 25,000.00 Rp 210,000.00 Rp 70,000.00 Rp 305,000.00 Rp 68,000.00 Rp 68,000.00

Rp 12,000.00 Rp 150,000.00 Rp 162,000.00 Rp 50,000.00 Rp 60,000.00 Rp 150,000.00 Rp 260,000.00

Rp 8,000.00 Rp 50,000.00 Rp 58,000.00 Rp 150,000.00 Rp 150,000.00 Rp 50,000.00 Rp 96,000.00 Rp 146,000.00 Rp 100,000.00 Rp 70,000.00 Rp 170,000.00

Rp 100,000.00 Rp 200,000.00 Rp 220,000.00 Rp 520,000.00 Rp 25,000.00 Rp 50,000.00 Rp 150,000.00 Rp 100,000.00 Rp 325,000.00

Rp 100,000.00 Rp 150,000.00 Rp 250,000.00 Rp 150,000.00 Rp 75,000.00 Rp 225,000.00 Rp 300,000.00 Rp 200,000.00 Rp 500,000.00 Rp 50,000.00 Rp 50,000.00

Rp 30,000.00 Rp 88,000.00 Rp 118,000.00 Rp 78,000.00 Rp 99,000.00 Rp 177,000.00

Rp 400,000.00 Rp 500,000.00 ### Rp 1,400,000.00 Rp 300,000.00 Rp 550,000.00 Rp 850,000.00

Rp 155,000.00 Rp 155,000.00 Rp 50,000.00 Rp 300,000.00 Rp 370,000.00 Rp 720,000.00

Rp 57,000.00 Rp 41,000.00 Rp 98,000.00

Page 23: Statistika Excel

Rp 50,000.00 ### Rp 500,000.00 Rp 40,000.00 Rp 640,000.00 Rp 100,000.00 Rp 20,000.00 Rp 800,000.00 Rp 920,000.00 Rp 100,000.00 Rp 60,000.00 Rp 1,140,000.00 Rp 1,300,000.00 Rp 50,000.00 Rp 60,000.00 Rp 110,000.00 Rp 20,000.00 ### Rp 20,000.00 Rp 60,000.00 Rp 25,000.00 Rp 100,000.00 ### Rp 225,000.00 Rp 20,000.00 Rp 150,000.00 Rp 80,000.00 Rp 250,000.00 Rp 10,000.00 Rp 50,000.00 Rp 20,000.00 Rp 80,000.00 Rp 15,000.00 Rp 250,000.00 Rp 40,000.00 Rp 305,000.00 Rp 10,000.00 Rp 50,000.00 Rp 100,000.00 Rp 20,000.00 Rp 180,000.00 Rp 15,000.00 Rp 150,000.00 Rp 40,000.00 Rp 205,000.00 Rp 30,000.00 Rp 200,000.00 Rp 60,000.00 Rp 290,000.00

Rp 50,000.00 Rp 50,000.00 Rp 230,000.00 Rp 230,000.00

Rp 50,000.00 Rp 25,000.00 Rp 12,000.00 Rp 87,000.00 Rp 20,000.00 Rp 34,000.00 Rp 240,000.00 Rp 294,000.00 Rp 15,000.00 Rp 23,000.00 Rp 340,000.00 Rp 378,000.00 Rp 54,000.00 Rp 78,000.00 Rp 250,000.00 Rp 382,000.00 Rp 32,000.00 Rp 45,000.00 Rp 360,000.00 Rp 437,000.00

Rp 234,000.00 Rp 234,000.00 Rp 20,000.00 Rp 260,000.00 Rp 280,000.00 Rp 12,000.00 Rp 122,000.00 Rp 134,000.00

Rp 220,000.00 Rp 220,000.00 Rp 210,000.00 Rp 210,000.00 Rp 156,000.00 Rp 156,000.00

Rp 12,000.00 Rp 137,000.00 Rp 149,000.00 Rp 233,000.00 Rp 160,000.00 Rp 393,000.00 Rp 34,000.00 Rp 214,000.00 Rp 248,000.00

Rp 12,000.00 Rp 260,000.00 Rp 272,000.00 Rp 5,000.00 Rp 133,000.00 Rp 138,000.00 Rp 12,000.00 Rp 310,000.00 Rp 322,000.00 Rp 23,000.00 Rp 210,000.00 Rp 233,000.00

Page 24: Statistika Excel

Rp 189,000.00 Rp 189,000.00 Rp 1,557,000.00 Rp 1,062,000.00 Rp 5,912,000.00 Rp 10,351,500.00 Rp 18,785,500.00 Rp 50,225.81 Rp 62,470.59 Rp 147,800.00 Rp 188,209.09 Rp 313,091.67 Rp 400,000.00 Rp 250,000.00 Rp 500,000.00 Rp 1,140,000.00 Rp 1,400,000.00 Rp 5,000.00 Rp 12,000.00 Rp 12,000.00 Rp 12,000.00 Rp 50,000.00 Rp 23,000.00 Rp 50,000.00 Rp 100,000.00 Rp 137,000.00 Rp 233,500.00 Rp 50,000.00 Rp 50,000.00 Rp 150,000.00 Rp 100,000.00 Rp 305,000.00 Rp 50,225.81 Rp 62,470.59 Rp 147,800.00 Rp 188,209.09 Rp 313,091.67 Rp 395,000.00 Rp 262,000.00 Rp 488,000.00 Rp 1,128,000.00 Rp 1,350,000.00 Rp 45,346.51 Rp 41,190.31 Rp 96,630.00 Rp 124,050.91 Rp 183,364.72 Rp 7,115,447,311.83 Rp 3,640,639,705.88 Rp 16,843,497,435.90 Rp 38,031,145,286.20 Rp 74,277,029,590.40 Rp 84,353.11 Rp 60,337.71 Rp 129,782.50 Rp 195,015.76 Rp 272,538.13

Page 25: Statistika Excel

PengeluranTransportasi

Bensin Solar Gas Angkot dll Rp 355,000.00 Rp 78,000.00 Rp 100,000.00 Rp 180,000.00 Rp 32,000.00 Rp 91,000.00 Rp 80,000.00 Rp 800,000.00 Rp 75,000.00 Rp 400,000.00 Rp 230,000.00 Rp 420,000.00 Rp 80,000.00 Rp 200,000.00 Rp 315,000.00 Rp 515,000.00 Rp 50,000.00 Rp 160,000.00 Rp 100,000.00 Rp 150,000.00 Rp 300,000.00 Rp 300,000.00 Rp 155,000.00 Rp 175,000.00 Rp 250,000.00 Rp 200,000.00 Rp 72,000.00 Rp 54,000.00 Rp 72,000.00 Rp 300,000.00 Rp 72,000.00 Rp 63,000.00 Rp 250,000.00 Rp 36,000.00 Rp 500,000.00 Rp 50,000.00

Rp 20,000.00 Rp 20,000.00 Rp 100,000.00 Rp 300,000.00 Rp 500,000.00 Rp 100,000.00 Rp 150,000.00 Rp 490,000.00 Rp 30,000.00 Rp 10,000.00 Rp 600,000.00 Rp 590,000.00 Rp 200,000.00

Page 26: Statistika Excel

Rp 360,000.00 Rp 91,500.00 Rp 50,000.00 Rp 690,000.00 Rp 600,000.00 Rp 552,000.00 Rp 400,000.00

### Rp 50,000.00 Rp 300,000.00 Rp 150,000.00 Rp 40,000.00 Rp 360,000.00 Rp 180,000.00 Rp 90,000.00 Rp 300,000.00 Rp 500,000.00 Rp 300,000.00 Rp 400,000.00 Rp 200,000.00 Rp 600,000.00 Rp 25,000.00 Rp 15,000.00 Rp 600,000.00 Rp 88,000.00 Rp 22,000.00 Rp 56,000.00 Rp 34,000.00 Rp 24,000.00 Rp 120,000.00 Rp 178,000.00 Rp 900,000.00 Rp 678,000.00 Rp 28,000.00 Rp 67,000.00 Rp 56,000.00 Rp 100,000.00 Rp 66,000.00 Rp 600,000.00 Rp 89,000.00 Rp 56,000.00 Rp 25,000.00 Rp 76,000.00 Rp 20,000.00 Rp 55,000.00 Rp 15,000.00 Rp 140,000.00 Rp 21,000.00 Rp 57,000.00 Rp 300,000.00 Rp 78,000.00

Page 27: Statistika Excel

Rp 34,000.00 Rp 11,942,000.00 Rp 491,500.00 Rp 598,000.00 Rp 8,575,000.00 Rp 202,406.78 Rp 245,750.00 Rp 39,866.67 Rp 343,000.00 Rp 690,000.00 Rp 400,000.00 Rp 80,000.00 Rp 900,000.00 Rp 24,000.00 Rp 91,500.00 Rp 15,000.00 Rp 10,000.00 Rp 100,000.00 Rp 245,750.00 Rp 32,000.00 Rp 300,000.00 Rp 100,000.00 Rp 50,000.00 Rp 300,000.00 Rp 202,406.78 Rp 245,750.00 Rp 39,866.67 Rp 343,000.00 Rp 666,000.00 Rp 308,500.00 Rp 65,000.00 Rp 890,000.00 Rp 154,294.17 Rp 154,250.00 Rp 19,857.78 Rp 183,440.00 Rp 35,808,935,125.66 Rp 47,586,125,000.00 Rp 569,123,809.52 Rp 53,816,666,666.67 Rp 189,232.49 Rp 218,142.44 Rp 23,856.32 Rp 231,984.19

Page 28: Statistika Excel

PengeluranTotal Pendidikan(SPP+Ongkos) TotalRp SD SMP SMA Rp

Rp 533,000.00 Rp 175,000.00 Rp 175,000.00 Rp 212,000.00 Rp 200,000.00 Rp 200,000.00 Rp 971,000.00 Rp 130,000.00 Rp 130,000.00 Rp 705,000.00 Rp 200,000.00 Rp 340,000.00 Rp 540,000.00 Rp 700,000.00 Rp 200,000.00 Rp 340,000.00 Rp 540,000.00 Rp 315,000.00 Rp 250,000.00 Rp 250,000.00 Rp 725,000.00 Rp 150,000.00 Rp 250,000.00 Rp 300,000.00 Rp 700,000.00 Rp 250,000.00 Rp 150,000.00 Rp 220,000.00 Rp 370,000.00 Rp 600,000.00 Rp 150,000.00 Rp 250,000.00 Rp 350,000.00 Rp 750,000.00 Rp 330,000.00 Rp 145,000.00 Rp 233,000.00 Rp 378,000.00 Rp 250,000.00 Rp 280,000.00 Rp 300,000.00 Rp 580,000.00 Rp 200,000.00 Rp 225,000.00 Rp 385,000.00 Rp 610,000.00 Rp 72,000.00 Rp 80,000.00 Rp 80,000.00 Rp 54,000.00 Rp 200,000.00 Rp 350,000.00 Rp 550,000.00 Rp 372,000.00 Rp 200,000.00 Rp 400,000.00 Rp 600,000.00 Rp 72,000.00 Rp 200,000.00 Rp 200,000.00 Rp 313,000.00 Rp 2,000,000.00 Rp 2,000,000.00 Rp 36,000.00 Rp 100,000.00 Rp 100,000.00 Rp 500,000.00 Rp 20,000.00 Rp 50,000.00 Rp 70,000.00 Rp 50,000.00 Rp 150,000.00 Rp 150,000.00 Rp 40,000.00 Rp 250,000.00 Rp 250,000.00 Rp 400,000.00 Rp 330,000.00 Rp 330,000.00 Rp 600,000.00 Rp 50,000.00 Rp 50,000.00 Rp 640,000.00 Rp 50,000.00 Rp 300,000.00 Rp 350,000.00 Rp 40,000.00 Rp 200,000.00 Rp 200,000.00 Rp 1,190,000.00 Rp 300,000.00 Rp 300,000.00 Rp 200,000.00 Rp 50,000.00 Rp 50,000.00

Page 29: Statistika Excel

Rp 501,500.00 Rp 50,000.00 Rp 150,000.00 Rp 200,000.00 Rp 400,000.00 Rp 1,290,000.00 Rp 150,000.00 Rp 150,000.00 Rp 952,000.00 Rp 175,000.00 Rp 175,000.00 Rp 750,000.00 Rp 150,000.00 Rp 300,000.00 Rp 450,000.00 Rp 190,000.00 Rp 250,000.00 Rp 500,000.00 Rp 750,000.00 Rp 360,000.00 Rp 200,000.00 Rp 200,000.00 Rp 180,000.00 Rp 250,000.00 Rp 250,000.00 Rp 390,000.00 Rp 175,000.00 Rp 175,000.00 Rp 500,000.00 Rp 200,000.00 Rp 200,000.00 Rp 700,000.00 Rp 300,000.00 Rp 300,000.00 Rp 200,000.00 Rp 100,000.00 Rp 100,000.00 Rp 600,000.00 Rp 200,000.00 Rp 200,000.00 Rp 640,000.00 Rp 350,000.00 Rp 350,000.00 Rp 110,000.00 Rp 100,000.00 Rp 100,000.00 Rp 56,000.00 Rp 300,000.00 Rp 300,000.00 Rp 34,000.00 Rp 150,000.00 Rp 200,000.00 Rp 350,000.00 Rp 24,000.00 Rp 300,000.00 Rp 300,000.00 Rp 120,000.00 Rp 100,000.00 Rp 100,000.00 Rp 1,078,000.00 Rp 400,000.00 Rp 400,000.00 Rp 678,000.00 Rp 200,000.00 Rp 200,000.00 Rp 28,000.00 Rp 350,000.00 Rp 350,000.00 Rp 67,000.00 Rp 300,000.00 Rp 300,000.00 Rp 56,000.00 Rp 150,000.00 Rp 250,000.00 Rp 400,000.00 Rp 100,000.00 Rp 100,000.00 Rp 100,000.00 Rp 666,000.00 Rp 200,000.00 Rp 200,000.00 Rp 89,000.00 Rp 175,000.00 Rp 175,000.00 Rp 81,000.00 Rp 55,000.00 Rp 55,000.00 Rp 96,000.00 Rp 89,000.00 Rp 89,000.00 Rp 70,000.00 Rp 45,000.00 Rp 45,000.00 Rp 161,000.00 Rp 55,000.00 Rp 55,000.00 Rp 357,000.00 Rp 67,000.00 Rp 67,000.00 Rp 78,000.00 Rp 45,000.00 Rp 45,000.00

Page 30: Statistika Excel

Rp 34,000.00 Rp 100,000.00 Rp 100,000.00 Rp 21,606,500.00 Rp 3,795,000.00 Rp 7,884,000.00 Rp 6,255,000.00 Rp 17,934,000.00 Rp 360,108.33 Rp 130,862.07 Rp 254,322.58 Rp 312,750.00 Rp 298,900.00 Rp 1,290,000.00 Rp 200,000.00 Rp 2,000,000.00 Rp 500,000.00 Rp 2,000,000.00 Rp 24,000.00 Rp 20,000.00 Rp 45,000.00 Rp 50,000.00 Rp 45,000.00 Rp 250,000.00 Rp 150,000.00 Rp 200,000.00 Rp 300,000.00 Rp 200,000.00 Rp 600,000.00 Rp 150,000.00 Rp 200,000.00 Rp 300,000.00 Rp 200,000.00 Rp 360,108.33 Rp 130,862.07 Rp 254,322.58 Rp 312,750.00 Rp 298,900.00 Rp 1,266,000.00 Rp 180,000.00 Rp 1,955,000.00 Rp 450,000.00 Rp 1,955,000.00 Rp 267,963.33 Rp 42,782.40 Rp 132,154.01 Rp 54,025.00 Rp 182,553.33 Rp 105,386,721,115.82 Rp 2,650,123,152.71 Rp 112,621,492,473.12 Rp 7,445,986,842.11 Rp 84,925,786,440.68 Rp 324,633.21 Rp 51,479.35 Rp 335,591.26 Rp 86,290.13 Rp 291,420.29

Page 31: Statistika Excel

PengeluranBelanja Lain Lain

PT Rumah Kredit Rokok dll Rp 450,000.00 Rp 185,000.00 Rp 94,000.00 Rp 300,000.00 Rp 224,000.00 Rp 80,000.00 Rp 300,000.00 Rp 1,000,000.00 Rp 150,000.00 Rp 80,000.00 Rp 800,000.00 Rp 200,000.00 Rp 110,000.00

Rp 3,000,000.00 Rp 2,700,000.00 Rp 160,000.00 Rp 30,000.00 Rp 600,000.00 Rp 125,000.00 Rp 130,000.00

Rp 65,000.00 Rp 1,000,000.00 Rp 400,000.00 Rp 250,000.00 Rp 50,000.00

Rp 20,000.00 Rp 300,000.00 Rp 78,000.00

Rp 150,000.00 Rp 35,000.00 Rp 40,000.00

Rp 500,000.00 Rp 600,000.00 Rp 40,000.00 Rp 300,000.00 Rp 100,000.00 Rp 20,000.00

Rp 20,000.00 Rp 20,000.00

Rp 200,000.00 Rp 60,000.00 Rp 50,000.00 Rp 40,000.00

Rp 200,000.00 Rp 120,000.00 Rp 1,000,000.00 Rp 50,000.00

Rp 1,000,000.00 Rp 200,000.00 Rp 50,000.00 Rp 100,000.00

Rp 100,000.00 Rp 20,000.00 Rp 50,000.00 Rp 2,000,000.00 Rp 200,000.00 Rp 2,000,000.00 Rp 12,000.00 Rp 50,000.00

Page 32: Statistika Excel

Rp 500,000.00 Rp 40,000.00 Rp 150,000.00 Rp 500,000.00 Rp 192,000.00 Rp 100,000.00 Rp 175,000.00 Rp 225,000.00 Rp 80,000.00 Rp 450,000.00 Rp 150,000.00 Rp 750,000.00 Rp 200,000.00 Rp 200,000.00 Rp 150,000.00 Rp 40,000.00 Rp 250,000.00 Rp 100,000.00 Rp 40,000.00 Rp 175,000.00 Rp 120,000.00 Rp 20,000.00 Rp 200,000.00 Rp 100,000.00 Rp 40,000.00 Rp 300,000.00 Rp 20,000.00 Rp 100,000.00 Rp 120,000.00 Rp 40,000.00 Rp 200,000.00 Rp 150,000.00 Rp 60,000.00 Rp 350,000.00 Rp 67,000.00 Rp 50,000.00 Rp 100,000.00 Rp 120,000.00 Rp 56,000.00 Rp 300,000.00 Rp 100,000.00 Rp 78,000.00 Rp 350,000.00 Rp 89,000.00 Rp 22,000.00 Rp 300,000.00 Rp 55,000.00 Rp 45,000.00 Rp 100,000.00 Rp 67,000.00 Rp 89,000.00 Rp 400,000.00 Rp 123,000.00 Rp 120,000.00 Rp 200,000.00 Rp 88,000.00 Rp 80,000.00 Rp 350,000.00 Rp 260,000.00 Rp 23,000.00 Rp 60,000.00 Rp 300,000.00 Rp 47,000.00 Rp 59,000.00 Rp 50,000.00 Rp 400,000.00 Rp 33,000.00 Rp 123,000.00 Rp 20,000.00 Rp 100,000.00 Rp 77,000.00 Rp 80,000.00 Rp 650,000.00 Rp 87,000.00 Rp 120,000.00 Rp 175,000.00 Rp 89,000.00 Rp 40,000.00 Rp 55,000.00 Rp 127,000.00 Rp 34,000.00 Rp 89,000.00 Rp 210,000.00 Rp 67,000.00 Rp 45,000.00 Rp 58,000.00 Rp 86,000.00 Rp 55,000.00 Rp 44,000.00 Rp 67,000.00 Rp 66,000.00 Rp 220,000.00 Rp 45,000.00 Rp 890,000.00 Rp 68,000.00

Page 33: Statistika Excel

Rp 100,000.00 Rp 50,000.00 Rp 98,000.00 Rp 16,181,000.00 Rp 12,355,000.00 Rp 4,036,000.00 Rp 4,539,000.00 Rp 425,815.79 Rp 411,833.33 Rp 134,533.33 Rp 76,932.20 Rp 3,000,000.00 Rp 2,700,000.00 Rp 600,000.00 Rp 400,000.00 Rp 45,000.00 Rp 33,000.00 Rp 12,000.00 Rp 20,000.00 Rp 200,000.00 Rp 255,000.00 Rp 121,500.00 Rp 60,000.00 Rp 200,000.00 Rp 300,000.00 Rp 150,000.00 Rp 40,000.00 Rp 425,815.79 Rp 411,833.33 Rp 134,533.33 Rp 76,932.20 Rp 2,955,000.00 Rp 2,667,000.00 Rp 588,000.00 Rp 380,000.00 Rp 365,445.98 Rp 354,777.78 Rp 65,440.00 Rp 42,258.55 Rp 379,574,586,770.98 Rp 286,684,488,505.75 Rp 11,332,188,505.75 Rp 4,121,202,220.92 Rp 616,096.25 Rp 535,429.26 Rp 106,452.75 Rp 64,196.59

Page 34: Statistika Excel

PengeluranTotalTotal

Rp Rp Rp 729,000.00 Rp 4,278,000.00 Rp 604,000.00 Rp 1,797,500.00 Rp 300,000.00 Rp 3,378,000.00 Rp 1,230,000.00 Rp 7,160,000.00 Rp 1,110,000.00 Rp 6,696,000.00 Rp 5,890,000.00 Rp 15,237,000.00 Rp 855,000.00 Rp 6,338,000.00 Rp 65,000.00 Rp 2,224,000.00 Rp 1,400,000.00 Rp 8,794,000.00 Rp 300,000.00 Rp 4,056,000.00 Rp 20,000.00 Rp 1,430,000.00 Rp 378,000.00 Rp 3,794,000.00 Rp 185,000.00 Rp 1,920,000.00 Rp 40,000.00 Rp 2,900,000.00 Rp 1,140,000.00 Rp 7,352,000.00 Rp 420,000.00 Rp 3,118,000.00 Rp 20,000.00 Rp 5,898,000.00 Rp 20,000.00 Rp 1,354,000.00 Rp 260,000.00 Rp 3,844,000.00 Rp 90,000.00 Rp 1,340,000.00 Rp 320,000.00 Rp 1,654,000.00 Rp 1,050,000.00 Rp 4,492,000.00 Rp 1,200,000.00 Rp 8,100,000.00 Rp 150,000.00 Rp 5,240,000.00 Rp 170,000.00 Rp 1,460,000.00 Rp 2,200,000.00 Rp 11,860,000.00 Rp 2,062,000.00 Rp 2,914,000.00

Page 35: Statistika Excel

Rp 540,000.00 Rp 56,372,000.00 Rp 792,000.00 Rp 41,426,000.00 Rp 305,000.00 Rp 43,548,000.00 Rp 150,000.00 Rp 124,476,000.00 Rp 200,000.00 Rp 17,958,000.00 Rp 190,000.00 Rp 18,972,000.00 Rp 140,000.00 Rp 22,120,000.00 Rp 140,000.00 Rp 17,301,000.00 Rp 140,000.00 Rp 19,266,000.00 Rp 20,000.00 Rp 19,976,000.00 Rp 160,000.00 Rp 20,520,000.00 Rp 210,000.00 Rp 24,994,000.00 Rp 117,000.00 Rp 14,867,000.00 Rp 176,000.00 Rp 27,442,000.00 Rp 178,000.00 Rp 18,498,000.00 Rp 111,000.00 Rp 18,007,000.00 Rp 100,000.00 Rp 19,056,000.00 Rp 156,000.00 Rp 20,850,000.00 Rp 243,000.00 Rp 17,045,000.00 Rp 168,000.00 Rp 42,126,000.00 Rp 343,000.00 Rp 11,061,000.00 Rp 156,000.00 Rp 19,618,000.00 Rp 176,000.00 Rp 17,942,000.00 Rp 157,000.00 Rp 27,153,000.00 Rp 207,000.00 Rp 53,529,000.00 Rp 129,000.00 Rp 15,006,000.00 Rp 161,000.00 Rp 12,148,000.00 Rp 277,000.00 Rp 14,406,000.00 Rp 144,000.00 Rp 14,529,000.00 Rp 44,000.00 Rp 12,255,000.00 Rp 286,000.00 Rp 16,821,000.00 Rp 958,000.00 Rp 14,889,000.00

Page 36: Statistika Excel

Rp 148,000.00 Rp 15,706,000.00 Rp 29,630,000.00 Rp 978,511,500.00 Rp 493,833.33 Rp 16,308,525.00 Rp 5,890,000.00 Rp 124,476,000.00 Rp 20,000.00 Rp 1,340,000.00 Rp 187,500.00 Rp 14,467,500.00 Rp 20,000.00 Rp 493,833.33 Rp 16,308,525.00 Rp 5,870,000.00 Rp 123,136,000.00 Rp 478,416.67 Rp 11,120,380.00 Rp 727,959,870,056.50 Rp 358,552,452,300,212.00 Rp 853,205.64 Rp 18,935,481.31

Page 37: Statistika Excel

ANGKA INDEKS HARGA RELATIF SEDERHANAIndeks Harga Beras Indeks Harga Gula

Tahun Harga per kg INDEKS Tahun Harga per Kg Indeks2010 6000 100 2010 7000 1002011 6500 108.33 2011 7400 105.712012 7000 116.67 2012 8000 114.292013 7500 125 2013 9200 121.432014 8000 133.33 2014 10500 135.712015 9000 150 2015 11000 142.862016 10000 166.67 2016 12000 142.86

Dari indeks harga sejak 2010 Dari indeks harga sejak 2010sampai 2016 telah naik 66,67% sampai 2016 telah naik 42,86%(166,67-100). (142,86-100).

Indeks Harga Susu Indeks Harga Minyak SayurTahun Harga per kg Indeks Tahun harga per kg Indeks

2010 80000 100 2010 9000 1002011 82000 102.5 2011 9000 1002012 82000 102.5 2012 9700 107.782013 85000 106.25 2013 10000 111.112014 90000 112.5 2014 10000 116.672015 94000 117.5 2015 11000 122.222016 95000 118.75 2016 11000 122.22

Dari indeks harga sejak 2010 Dari indeks harga sejak 2010sampai 2016 telah naik 18,75% sampai 2016 telah naik 22,22%(118,75-100). (122,22-100).

Page 38: Statistika Excel

Indeks Harga Kopi Indeks Harga TheTahun Harga per kg Indeks Tahun

2010 8000 100 20102011 8000 100 20112012 8500 106.25 20122013 8700 108.75 20132014 9000 112.5 20142015 9500 118.75 20152016 12000 137.5 2016

Dari indeks harga sejak 2010 Dari indeks harga sejak 2010sampai 2016 telah naik 37,5% sampai 2016 telah naik 50%(137,5-100). (150-100).

Indeks Harga Mie Indeks harga air mineralTahun harga per unit Indeks Tahun

2010 1000 100 20102011 1500 150 20112012 1500 150 20122013 1500 150 20132014 2000 200 20142015 2000 200 20152016 2500 250 2016

Dari indeks harga sejak 2010 Dari Indeks Harga sejak 2010sampai 2016 telah naik 150% sampai 2016 telah naik 46,67%(250-100). (146,67-100).

Page 39: Statistika Excel

Indeks Harga The Indeks Harga Ayam Harga per kg Indeks Tahun Harga per kg Indeks

10000 100 2010 20000 10010000 100 2011 22500 112.510000 100 2012 25000 12511000 110 2013 28000 14012000 120 2014 30000 15012000 120 2015 35000 17515000 150 2016 40000 200

Dari indeks harga sejak 2010 Dari indeks harga sejak 2010 sampai 2016 telah naik 50% sampai 2016 telah naik 100% (150-100). (200-100).

Indeks harga air mineralharga per galon Indeks

15000 10015000 10017000 113.333318000 12019000 126.666720000 133.333322000 146.6667

Dari Indeks Harga sejak 2010sampai 2016 telah naik 46,67%(146,67-100).

Page 40: Statistika Excel

DERET BERKALA

Harga BerasTahun Harga per kg Ket X Semi Total Semi Average2011 6500 -12012 7000 I 0 21000 70002013 7500 1

2014 8000 22015 9000 II 3 27000 90002016 10000 4

Rumus :Untuk kelompok 1Semi Total 21000Semi Average 7000Untuk Kelompok 2Semi Total 27000Semi Average 9000 (a)

b 7833.33Maka, rumus peramalan yang digunakan yaituUntuk kelompok 1 dan 2Y' =a + b(x)Y' = 9000 + 7833.33(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 48166.67Peramalan 2Y'2017 = a + b(x)

Y'2017 24666.67Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 24666.67.' sampai Rp 48166.67.'

Harga SusuTahun Harga per kg Ket X Semi Total Semi Average2011 82000 -12012 82000 I 0 249000 830002013 85000 1

2014 90000 22015 94000 II 3 279000 930002016 95000 4

Page 41: Statistika Excel

Rumus :Untuk kelompok 1Semi Total 249000Semi Average 83000Untuk Kelompok 2Semi Total 279000Semi Average 93000 (a)

b 79166.67Maka, rumus peramalan yang digunakan yaituY' =a + b(x)Y' = 93000 + 79166.67(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 488833.33Peramalan 2Y'2017 = a + b(x)

Y'2017 251333.33Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 251333.33.' sampai 488833.33.'

Page 42: Statistika Excel

DERET BERKALA

Harga GulaTrend Awal Tahun Tahun Harga per kg Ket X

2011 7400 -17000 + 7833.33(x) 2012 8000 I 0

2013 9200 1

2014 10500 29000 + 7833.33(x) 2015 11000 II 3

2016 12000 4

Rumus :Untuk kelompok 1Semi Total 24600Semi Average 8200Untuk Kelompok 2Semi Total 33500Semi Average 11166.67 (a)

b 9800Maka, rumus peramalan yang digunakan yaituUntuk kelompok 1 dan 2Y' =a + b(x)Y' = 11166.67 + 9800(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 60166.67Peramalan 2Y'2017 = a + b(x)

Y'2017 30766.67Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 24666.67.' sampai Rp 48166.67.' Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 30766.67.' sampai Rp 60166.67.'

Harga Minyak SayurTrend Awal Tahun Tahun Harga per kg Ket X

2011 9000 -183000 + 79166.67(x) 2012 9700 I 0

2013 10000 1

2014 10000 293000 + 79166.67(x) 2015 11000 II 3

2016 11000 4

Page 43: Statistika Excel

Rumus :Untuk kelompok 1Semi Total 28700Semi Average 9566.67Untuk Kelompok 2Semi Total 32000Semi Average 10666.67 (a)

b 9072.22Maka, rumus peramalan yang digunakan yaituY' =a + b(x)Y' = 10666.67 + 9072.22(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 56027.78Peramalan 2Y'2017 = a + b(x)

Y'2017 28811.11Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 251333.33.' sampai 488833.33.' Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 33347.22

Page 44: Statistika Excel

DERET BERKALA

Harga KopiSemi Total Semi Average Trend Awal Tahun Tahun

201124600 8200 8200 + 9800(x) 2012

2013

201433500 11166.67 11166.67 + 9800(+) 2015

2016

Rumus :Untuk kelompok 1Semi Total Semi Average Untuk Kelompok 2Semi Total Semi Average

b Maka, rumus peramalan yang digunakan yaituUntuk kelompok 1 dan 2Y' =a + b(x)Y' = 10166.67 + 8766.67(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 Peramalan 2Y'2017 = a + b(x)

Y'2017 Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 30766.67.' sampai Rp 60166.67.' Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 27700.' sampai Rp 54000.'

Harga mieSemi Total Semi Average Trend Awal Tahun Tahun

201128700 9566.67 9566.67 + 9072.22 2012

2013

201432000 10666.67 10666.67 + 9072.22 2015

2016

Page 45: Statistika Excel

Rumus :Untuk kelompok 1Semi Total Semi Average Untuk Kelompok 2Semi Total Semi Average

b Maka, rumus peramalan yang digunakan yaituY' =a + b(x)Y' = 2166.67 + 1916.67(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 Peramalan 2Y'2017 = a + b(x)

Y'2017 Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 33347.22 Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 6000.' sampai 11750.'

Page 46: Statistika Excel

DERET BERKALA

Harga per kg Ket X Semi Total Semi Average8000 -18500 I 0 25200 84008700 1

9000 29500 II 3 30500 10166.67

12000 4

Untuk kelompok 125200

8400Untuk Kelompok 2

3050010166.67 (a)

8766.67Maka, rumus peramalan yang digunakan yaituUntuk kelompok 1 dan 2

Y' = 10166.67 + 8766.67(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2

Y'2017 = a + b(x)54000

Y'2017 = a + b(x)27700.00

Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 27700.' sampai Rp 54000.'

Harga per unit Ket X Semi Total Semi Average1500 -11500 I 0 4500 15001500 1

2000 22000 II 3 6500 2166.672500 4

Page 47: Statistika Excel

Untuk kelompok 145001500

Untuk Kelompok 26500

2166.67 (a)1916.67

Maka, rumus peramalan yang digunakan yaitu

Y' = 2166.67 + 1916.67(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2

Y'2017 = a + b(x)11750

Y'2017 = a + b(x)6000

Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 6000.' sampai 11750.'

Page 48: Statistika Excel

DERET BERKALA

Harga theTrend Awal Tahun Tahun Harga per kg Ket X

2011 10000 -18400 + 8766.67(x) 2012 10000 I 0

2013 11000 1

2014 12000 210166.67 + 8766.67(x) 2015 12000 II 3

2016 15000 4

Rumus :Untuk kelompok 1Semi Total 31000Semi Average 10333.33Untuk Kelompok 2Semi Total 39000Semi Average 13000 (a)

b 11277.78Maka, rumus peramalan yang digunakan yaituUntuk kelompok 1 dan 2Y' =a + b(x)Y' = 13000 + 11277.78(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 69388.89Peramalan 2Y'2017 = a + b(x)

Y'2017 35555.56Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 27700.' sampai Rp 54000.' Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 35555.' sampai Rp 69388

Harga air mineralTrend Awal Tahun Tahun Harga per galon Ket X

2011 15000 -11500 + 1916.67(x) 2012 17000 I 0

2013 18000 1

2014 19000 22166.67 + 1916.67(x) 2015 20000 II 3

2016 22000 4

Page 49: Statistika Excel

Rumus :Untuk kelompok 1Semi Total 50000Semi Average 16666.67Untuk Kelompok 2Semi Total 61000Semi Average 20333.33 (a)

b 17555.56Maka, rumus peramalan yang digunakan yaituY' =a + b(x)Y' = 20333.33 + 17555.56(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 108111.11Peramalan 2Y'2017 = a + b(x)

Y'2017 55444.44Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 64222.22

Page 50: Statistika Excel

DERET BERKALA

Harga ayamSemi Total Semi Average Trend Awal Tahun Tahun

201131000 10333.33 10333.33 + 11277.78(x) 2012

2013

201439000 13000 13000 + 11277.78(x) 2015

2016

Rumus :Untuk kelompok 1Semi Total Semi Average Untuk Kelompok 2Semi Total Semi Average

b Maka, rumus peramalan yang digunakan yaituUntuk kelompok 1 dan 2Y' =a + b(x)Y' = 35000 + 30805.56(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2Peramalan 1Y'2017 = a + b(x)

Y'2017 Peramalan 2Y'2017 = a + b(x)

Y'2017 Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 35555.' sampai Rp 69388 Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 96611.11.' sampai Rp 189027.78.'

Semi Total Semi Average Trend Awal Tahun

50000 16666.67 16666.67 + 17555.56(x)

61000 20333.33 20333.33 + 17555.56(x)

Page 51: Statistika Excel

Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 64222.22

Page 52: Statistika Excel

DERET BERKALA

Harga per kg Ket X Semi Total Semi Average22500 -125000 I 0 75500 25166.6728000 1

30000 235000 II 3 105000 3500040000 4

Untuk kelompok 175500

25166.67Untuk Kelompok 2

10500035000

30805.56Maka, rumus peramalan yang digunakan yaituUntuk kelompok 1 dan 2

Y' = 35000 + 30805.56(x)Misalkan untuk meramal pada tahun 2017Maka x : 2012 = 5 2015=2

Y'2017 = a + b(x)189027.78

Y'2017 = a + b(x)96611.11

Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 96611.11.' sampai Rp 189027.78.'

Page 53: Statistika Excel
Page 54: Statistika Excel

DERET BERKALA

Trend Awal Tahun

25166.67 + 30805.56(x)

35000 + 30805.56(x)

Jadi, dapat diramalkan untuk tahun 2017 harga beras yaitu Rp 96611.11.' sampai Rp 189027.78.'

Page 55: Statistika Excel
Page 56: Statistika Excel

REGRESI LINIER SEDERHANAREGRESI KOMSUMSI MAKANAN

NAMA PENDAPATAN (Y) KOMSUMSI MAKANAN (X)ZULKIFLI Rp 4,500,000.00 Rp 446,000.00 MAWAN Rp 6,500,000.00 Rp 362,000.00 RIAN Rp 2,700,000.00 Rp 320,000.00 FEBRI Rp 6,400,000.00 Rp 438,000.00 YANTO Rp 30,800,000.00 Rp 341,000.00 NAHWAN Rp 18,000,000.00 Rp 482,000.00 PAISAL Rp 44,000,000.00 Rp 552,000.00 AL SAFFAT GHAZALI Rp 43,000,000.00 Rp 160,500.00 SYAMSUL RIZAL Rp 48,000,000.00 Rp 1,095,200.00 NOVAL ARDIAN PRATAMA Rp 68,000,000.00 Rp 462,000.00 M.IQBAL Rp 24,000,000.00 Rp 156,000.00 FERDI MELSON R Rp 40,000,000.00 Rp 379,000.00 MARJUNI HARUN Rp 2,500,000.00 Rp 271,000.00 SUMIYO Rp 5,000,000.00 Rp 306,000.00 ISMET NUR HUSNI Rp 5,500,000.00 Rp 471,000.00 ADI CHANDRA Rp 3,300,000.00 Rp 177,000.00 SAHRI SANDI WINATA Rp 3,000,000.00 Rp 195,000.00 RUDI HARTONO Rp 2,200,000.00 Rp 187,000.00 IR.FIRMANSYAH Rp 5,500,000.00 Rp 314,000.00 EDI NELSON Rp 3,500,000.00 Rp 570,000.00 AMIR HUSIN Rp 7,500,000.00 Rp 200,000.00 FATIR RIZKI Rp 25,000,000.00 Rp 134,000.00 SARLAN PERKASA Rp 31,000,000.00 Rp 1,450,000.00 RUSDAN Rp 4,500,000.00 Rp 410,000.00 RUDI PERKASA Rp 700,000.00 Rp 165,000.00 S. HABNIN Rp 17,000,000.00 Rp 2,050,000.00 M. AKBAR Rp 6,000,000.00 Rp 145,000.00 Riduan Rp 10,000,000.00 Rp 576,000.00 RIO FEBRIANTO Rp 17,000,000.00 Rp 302,000.00 DANNY PRADANA Rp 19,000,000.00 Rp 291,000.00 SALAMAT PURBA Rp 16,000,000.00 Rp 298,000.00 PADRIZAL Rp 2,500,000.00 Rp 354,000.00 HAMIDIN SULISTHIO Rp 6,000,000.00 Rp 289,000.00 AZHARI BSC Rp 5,300,000.00 Rp 229,000.00 MARDIANTO Rp 7,000,000.00 Rp 192,000.00 LUKMAN ULHAKIM Rp 3,050,000.00 Rp 316,000.00 MUHAMAD TOHA ARAFAT,SE,AK Rp 8,000,000.00 Rp 212,000.00 YAN ALBERTHO Rp 4,900,000.00 Rp 319,000.00 KMS.TAUFI OURRAHMAN,SH Rp 8,000,000.00 Rp 430,000.00 HERMAN Rp 5,000,000.00 Rp 245,000.00 DANIEL Rp 10,000,000.00 Rp 313,000.00 RICO HANIF Rp 2,800,000.00 Rp 353,000.00 BENI PRAKOSO Rp 2,900,000.00 Rp 325,000.00 SUSANTO Rp 2,600,000.00 Rp 423,000.00 ANDIAN Rp 28,000,000.00 Rp 296,000.00

Page 57: Statistika Excel

YOGI PUTRA Rp 5,500,000.00 Rp 418,000.00 DIDI SAPUTRA Rp 15,000,000.00 Rp 330,000.00 RUSLAN EFFENDI Rp 2,500,000.00 Rp 490,000.00 ISHAK HABIBI Rp 7,500,000.00 Rp 377,000.00 BOBBI Rp 5,500,000.00 Rp 415,000.00 VIVID ARDIANSYAH Rp 2,500,000.00 Rp 374,000.00 ARIANTO Rp 26,000,000.00 Rp 477,000.00 NURALI Rp 3,000,000.00 Rp 246,000.00 FEBRI WIJAYA Rp 3,300,000.00 Rp 379,000.00 BAGUS RAMAHNA Rp 2,700,000.00 Rp 317,000.00 RAHMAT PURWANTO Rp 3,500,000.00 Rp 384,000.00 ERWIN GUNAWAN Rp 6,500,000.00 Rp 417,000.00 H.SENEN Rp 6,500,000.00 Rp 400,000.00 ANDIKA KUSUMA Rp 3,900,000.00 Rp 367,000.00 DIDI KUSUMA WIJAYA Rp 3,000,000.00 Rp 328,000.00

N = 60 Rp 713,050,000.00 Rp 23,720,700.00

Sehingga persamaan persamaan regresi Y = Rp 6,920,116.49 + Rp 12.56 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

22 )( XXn

XYnb YX

2) .0023,720,700 Rp () 0,290,000.014,594,788 Rp (60

) 0.00713,050,00 Rp )( .0023,720,700 Rp () 000,000,000.347,405,80 Rp (60

b

008,910,000.313,015,68 Rp

0.00865,000,003,930,302, Rpb

56.12Rpb

n

b

n

na XY

60

) .0023,720,700 Rp )(56.12(

60

0.00713,050,00 Rp Rpa

60

9.34415,206,98 Rp a

496,920,116. Rp a

bXaY

Page 58: Statistika Excel

B. Koefisien Korelasi Regresi

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar 27%

REGRESI BELANJA SANDANGNAMA PENDAPATAN (Y) BELANJA SANDANG (x)

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp () 00.00,500,000,019,786,162 Rp (60(()) .0023,720,700 Rp () .0088,290,000Rp14,594,7 (60(

) 000.00Rp713,050, )( .0023,720,700 Rp () 0.00800,000,00Rp347,405, (60

r

9.00)823,850,37 Rp ( .40)17,692,249 (Rp

0.00865,000,003,930,302, Rp r

27,0Rpr

00.00,373,552,514,575,766 Rp

0.00865,000,003,930,302, Rp r

2.

2

n

XYbYaYxSy

260

) 000,000,000.347,405,80 Rp 12.56)( (Rp -) 0.00713,050,00 Rp 49)(6,920,116. (Rp - 00.00,500,000,019,786,162 Rp .

xSy

58

,100.0059,781,810Rp10,489,6 . xSy

003,134,657.180,856,20 Rp . xSy

78.80Rp13,448,2 . xSy

Page 59: Statistika Excel

ZULKIFLI Rp 4,500,000.00 Rp 4,387,000.00 MAWAN Rp 6,500,000.00 Rp 3,880,000.00 RIAN Rp 2,700,000.00 Rp 5,000,000.00 FEBRI Rp 6,400,000.00 Rp 9,000,000.00 YANTO Rp 30,800,000.00 Rp 3,589,000.00 NAHWAN Rp 18,000,000.00 Rp 16,700,000.00 PAISAL Rp 44,000,000.00 Rp 4,930,000.00 AL SAFFAT GHAZALI Rp 43,000,000.00 Rp 4,150,000.00 SYAMSUL RIZAL Rp 48,000,000.00 Rp 26,430,000.00 NOVAL ARDIAN PRATAMA Rp 68,000,000.00 Rp 20,050,000.00 M.IQBAL Rp 24,000,000.00 Rp 3,265,000.00 FERDI MELSON R Rp 40,000,000.00 Rp 14,300,000.00 MARJUNI HARUN Rp 2,500,000.00 Rp 3,595,000.00 SUMIYO Rp 5,000,000.00 Rp 3,900,000.00 ISMET NUR HUSNI Rp 5,500,000.00 Rp 7,045,000.00 ADI CHANDRA Rp 3,300,000.00 Rp 1,970,000.00 SAHRI SANDI WINATA Rp 3,000,000.00 Rp 1,590,000.00 RUDI HARTONO Rp 2,200,000.00 Rp 1,095,000.00 IR.FIRMANSYAH Rp 5,500,000.00 Rp 1,740,000.00 EDI NELSON Rp 3,500,000.00 Rp 1,080,000.00 AMIR HUSIN Rp 7,500,000.00 Rp 380,000.00 FATIR RIZKI Rp 25,000,000.00 Rp 2,030,000.00 SARLAN PERKASA Rp 31,000,000.00 Rp 4,600,000.00 RUSDAN Rp 4,500,000.00 Rp 1,600,000.00 RUDI PERKASA Rp 700,000.00 Rp 420,000.00 S. HABNIN Rp 17,000,000.00 Rp 8,800,000.00 M. AKBAR Rp 6,000,000.00 Rp 672,000.00 Riduan Rp 10,000,000.00 Rp 5,650,000.00 RIO FEBRIANTO Rp 17,000,000.00 Rp 17,050,000.00 DANNY PRADANA Rp 19,000,000.00 Rp 18,350,000.00 SALAMAT PURBA Rp 16,000,000.00 Rp 59,000,000.00 PADRIZAL Rp 2,500,000.00 Rp 6,000,000.00 HAMIDIN SULISTHIO Rp 6,000,000.00 Rp 7,740,000.00 AZHARI BSC Rp 5,300,000.00 Rp 9,300,000.00 MARDIANTO Rp 7,000,000.00 Rp 7,100,000.00 LUKMAN ULHAKIM Rp 3,050,000.00 Rp 7,570,000.00 MUHAMAD TOHA ARAFAT,SE,AK Rp 8,000,000.00 Rp 7,650,000.00 YAN ALBERTHO Rp 4,900,000.00 Rp 8,750,000.00 KMS.TAUFI OURRAHMAN,SH Rp 8,000,000.00 Rp 9,500,000.00 HERMAN Rp 5,000,000.00 Rp 5,400,000.00 DANIEL Rp 10,000,000.00 Rp 12,400,000.00 RICO HANIF Rp 2,800,000.00 Rp 7,620,000.00 BENI PRAKOSO Rp 2,900,000.00 Rp 7,300,000.00 SUSANTO Rp 2,600,000.00 Rp 7,680,000.00 ANDIAN Rp 28,000,000.00 Rp 8,700,000.00 YOGI PUTRA Rp 5,500,000.00 Rp 5,430,000.00 DIDI SAPUTRA Rp 15,000,000.00 Rp 19,150,000.00 RUSLAN EFFENDI Rp 2,500,000.00 Rp 3,650,000.00

Page 60: Statistika Excel

ISHAK HABIBI Rp 7,500,000.00 Rp 8,440,000.00 BOBBI Rp 5,500,000.00 Rp 7,150,000.00 VIVID ARDIANSYAH Rp 2,500,000.00 Rp 12,200,000.00 ARIANTO Rp 26,000,000.00 Rp 24,250,000.00 NURALI Rp 3,000,000.00 Rp 6,200,000.00 FEBRI WIJAYA Rp 3,300,000.00 Rp 4,630,000.00 BAGUS RAMAHNA Rp 2,700,000.00 Rp 5,950,000.00 RAHMAT PURWANTO Rp 3,500,000.00 Rp 6,150,000.00 ERWIN GUNAWAN Rp 6,500,000.00 Rp 5,050,000.00 H.SENEN Rp 6,500,000.00 Rp 6,700,000.00 ANDIKA KUSUMA Rp 3,900,000.00 Rp 5,900,000.00 DIDI KUSUMA WIJAYA Rp 3,000,000.00 Rp 6,680,000.00

N = 60 Rp 713,050,000.00 Rp 496,488,000.00

Sehingga persamaan persamaan regresi Y = Rp7,306,487.30 + Rp0.55 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

bXaY

22 )( XXn

XYnb YX

2)000.00Rp496,488,()0.00574,000,008,621,374, Rp(60

) 0.00713,050,00 Rp )(000.00Rp496,488,()000.000,200,000,Rp8,396,99(60

b

0,000.00140,296,00Rp270,782,

0,000.00643,600,00Rp149,798, b

55.0Rpb

n

b

n

na XY

60

)000.00Rp496,488, )(55.0(

60

0.00713,050,00 Rp Rpa

60

8.10438,389,23 Rp a

7.30Rp7,306,48 a

Page 61: Statistika Excel

B. Koefisien Korelasi Regresi

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar 35%

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1(60(())000.00Rp496,488,()000.004,574,000,Rp8,621,37(60(

) 000.00Rp713,050, )(000.00Rp496,488,()000.000,200,000,Rp8,396,99(60

r

379.00)Rp823,850, ( 313.00)Rp520,367, (

0,000.00643,600,00Rp149,798, r

2,000.00808,034,26Rp428,704,

0,000.00643,600,00Rp149,798, r

35,0Rpr

2.

2

n

XYbYaYxSy

260

000.00)0,200,000,Rp8,396,99 (Rp0.55)( -) 0.00713,050,00 Rp 7.30)(Rp7,306,48 ( - ,000.0062,500,000Rp19,786,1 .

xSy

58

320.005,859,820,Rp9,930,99 . xSy

6.00066,548,62Rp171,224, . xSy

61.40Rp13,085,2 . xSy

Page 62: Statistika Excel

X.Y X2 Rp 2,007,000,000,000.00 Rp 198,916,000,000.00 Rp 2,353,000,000,000.00 Rp 131,044,000,000.00 Rp 864,000,000,000.00 Rp 102,400,000,000.00 Rp 2,803,200,000,000.00 Rp 191,844,000,000.00 Rp 10,502,800,000,000.00 Rp 116,281,000,000.00 Rp 8,676,000,000,000.00 Rp 232,324,000,000.00 Rp 24,288,000,000,000.00 Rp 304,704,000,000.00 Rp 6,901,500,000,000.00 Rp 25,760,250,000.00 Rp 52,569,600,000,000.00 Rp 1,199,463,040,000.00 Rp 31,416,000,000,000.00 Rp 213,444,000,000.00 Rp 3,744,000,000,000.00 Rp 24,336,000,000.00 Rp 15,160,000,000,000.00 Rp 143,641,000,000.00 Rp 677,500,000,000.00 Rp 73,441,000,000.00 Rp 1,530,000,000,000.00 Rp 93,636,000,000.00 Rp 2,590,500,000,000.00 Rp 221,841,000,000.00 Rp 584,100,000,000.00 Rp 31,329,000,000.00 Rp 585,000,000,000.00 Rp 38,025,000,000.00 Rp 411,400,000,000.00 Rp 34,969,000,000.00 Rp 1,727,000,000,000.00 Rp 98,596,000,000.00 Rp 1,995,000,000,000.00 Rp 324,900,000,000.00 Rp 1,500,000,000,000.00 Rp 40,000,000,000.00 Rp 3,350,000,000,000.00 Rp 17,956,000,000.00 Rp 44,950,000,000,000.00 Rp 2,102,500,000,000.00 Rp 1,845,000,000,000.00 Rp 168,100,000,000.00 Rp 115,500,000,000.00 Rp 27,225,000,000.00 Rp 34,850,000,000,000.00 Rp 4,202,500,000,000.00 Rp 870,000,000,000.00 Rp 21,025,000,000.00 Rp 5,760,000,000,000.00 Rp 331,776,000,000.00 Rp 5,134,000,000,000.00 Rp 91,204,000,000.00 Rp 5,529,000,000,000.00 Rp 84,681,000,000.00 Rp 4,768,000,000,000.00 Rp 88,804,000,000.00 Rp 885,000,000,000.00 Rp 125,316,000,000.00 Rp 1,734,000,000,000.00 Rp 83,521,000,000.00 Rp 1,213,700,000,000.00 Rp 52,441,000,000.00 Rp 1,344,000,000,000.00 Rp 36,864,000,000.00 Rp 963,800,000,000.00 Rp 99,856,000,000.00 Rp 1,696,000,000,000.00 Rp 44,944,000,000.00 Rp 1,563,100,000,000.00 Rp 101,761,000,000.00 Rp 3,440,000,000,000.00 Rp 184,900,000,000.00 Rp 1,225,000,000,000.00 Rp 60,025,000,000.00 Rp 3,130,000,000,000.00 Rp 97,969,000,000.00 Rp 988,400,000,000.00 Rp 124,609,000,000.00 Rp 942,500,000,000.00 Rp 105,625,000,000.00 Rp 1,099,800,000,000.00 Rp 178,929,000,000.00 Rp 8,288,000,000,000.00 Rp 87,616,000,000.00

Page 63: Statistika Excel

Rp 2,299,000,000,000.00 Rp 174,724,000,000.00 Rp 4,950,000,000,000.00 Rp 108,900,000,000.00 Rp 1,225,000,000,000.00 Rp 240,100,000,000.00 Rp 2,827,500,000,000.00 Rp 142,129,000,000.00 Rp 2,282,500,000,000.00 Rp 172,225,000,000.00 Rp 935,000,000,000.00 Rp 139,876,000,000.00 Rp 12,402,000,000,000.00 Rp 227,529,000,000.00 Rp 738,000,000,000.00 Rp 60,516,000,000.00 Rp 1,250,700,000,000.00 Rp 143,641,000,000.00 Rp 855,900,000,000.00 Rp 100,489,000,000.00 Rp 1,344,000,000,000.00 Rp 147,456,000,000.00 Rp 2,710,500,000,000.00 Rp 173,889,000,000.00 Rp 2,600,000,000,000.00 Rp 160,000,000,000.00 Rp 1,431,300,000,000.00 Rp 134,689,000,000.00 Rp 984,000,000,000.00 Rp 107,584,000,000.00 Rp 347,405,800,000,000.00 Rp 14,594,788,290,000.00

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

2) .0023,720,700 Rp () 0,290,000.014,594,788 Rp (60

) 0.00713,050,00 Rp )( .0023,720,700 Rp () 000,000,000.347,405,80 Rp (60

b

60

) .0023,720,700 Rp )(56.12(

60

0.00713,050,00 Rp Rpa

Page 64: Statistika Excel

X.Y X2

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

22 ) 0.00713,050,00 Rp () 00.00,500,000,019,786,162 Rp (60(()) .0023,720,700 Rp () .0088,290,000Rp14,594,7 (60(

) 000.00Rp713,050, )( .0023,720,700 Rp () 0.00800,000,00Rp347,405, (60

r

260

) 000,000,000.347,405,80 Rp 12.56)( (Rp -) 0.00713,050,00 Rp 49)(6,920,116. (Rp - 00.00,500,000,019,786,162 Rp .

xSy

58

,100.0059,781,810Rp10,489,6 . xSy

Page 65: Statistika Excel

Rp 19,741,500,000,000.00 Rp 19,245,769,000,000.00 Rp 25,220,000,000,000.00 Rp 15,054,400,000,000.00 Rp 13,500,000,000,000.00 Rp 25,000,000,000,000.00 Rp 57,600,000,000,000.00 Rp 81,000,000,000,000.00 Rp 110,541,200,000,000.00 Rp 12,880,921,000,000.00 Rp 300,600,000,000,000.00 Rp 278,890,000,000,000.00 Rp 216,920,000,000,000.00 Rp 24,304,900,000,000.00 Rp 178,450,000,000,000.00 Rp 17,222,500,000,000.00 Rp 1,268,640,000,000,000.00 Rp 698,544,900,000,000.00 Rp 1,363,400,000,000,000.00 Rp 402,002,500,000,000.00 Rp 78,360,000,000,000.00 Rp 10,660,225,000,000.00 Rp 572,000,000,000,000.00 Rp 204,490,000,000,000.00 Rp 8,987,500,000,000.00 Rp 12,924,025,000,000.00 Rp 19,500,000,000,000.00 Rp 15,210,000,000,000.00 Rp 38,747,500,000,000.00 Rp 49,632,025,000,000.00 Rp 6,501,000,000,000.00 Rp 3,880,900,000,000.00 Rp 4,770,000,000,000.00 Rp 2,528,100,000,000.00 Rp 2,409,000,000,000.00 Rp 1,199,025,000,000.00 Rp 9,570,000,000,000.00 Rp 3,027,600,000,000.00 Rp 3,780,000,000,000.00 Rp 1,166,400,000,000.00 Rp 2,850,000,000,000.00 Rp 144,400,000,000.00 Rp 50,750,000,000,000.00 Rp 4,120,900,000,000.00 Rp 142,600,000,000,000.00 Rp 21,160,000,000,000.00 Rp 7,200,000,000,000.00 Rp 2,560,000,000,000.00 Rp 294,000,000,000.00 Rp 176,400,000,000.00 Rp 149,600,000,000,000.00 Rp 77,440,000,000,000.00 Rp 4,032,000,000,000.00 Rp 451,584,000,000.00 Rp 56,500,000,000,000.00 Rp 31,922,500,000,000.00 Rp 289,850,000,000,000.00 Rp 290,702,500,000,000.00 Rp 348,650,000,000,000.00 Rp 336,722,500,000,000.00 Rp 944,000,000,000,000.00 Rp 3,481,000,000,000,000.00 Rp 15,000,000,000,000.00 Rp 36,000,000,000,000.00 Rp 46,440,000,000,000.00 Rp 59,907,600,000,000.00 Rp 49,290,000,000,000.00 Rp 86,490,000,000,000.00 Rp 49,700,000,000,000.00 Rp 50,410,000,000,000.00 Rp 23,088,500,000,000.00 Rp 57,304,900,000,000.00 Rp 61,200,000,000,000.00 Rp 58,522,500,000,000.00 Rp 42,875,000,000,000.00 Rp 76,562,500,000,000.00 Rp 76,000,000,000,000.00 Rp 90,250,000,000,000.00 Rp 27,000,000,000,000.00 Rp 29,160,000,000,000.00 Rp 124,000,000,000,000.00 Rp 153,760,000,000,000.00 Rp 21,336,000,000,000.00 Rp 58,064,400,000,000.00 Rp 21,170,000,000,000.00 Rp 53,290,000,000,000.00 Rp 19,968,000,000,000.00 Rp 58,982,400,000,000.00 Rp 243,600,000,000,000.00 Rp 75,690,000,000,000.00 Rp 29,865,000,000,000.00 Rp 29,484,900,000,000.00 Rp 287,250,000,000,000.00 Rp 366,722,500,000,000.00 Rp 9,125,000,000,000.00 Rp 13,322,500,000,000.00

Page 66: Statistika Excel

Rp 63,300,000,000,000.00 Rp 71,233,600,000,000.00 Rp 39,325,000,000,000.00 Rp 51,122,500,000,000.00 Rp 30,500,000,000,000.00 Rp 148,840,000,000,000.00 Rp 630,500,000,000,000.00 Rp 588,062,500,000,000.00 Rp 18,600,000,000,000.00 Rp 38,440,000,000,000.00 Rp 15,279,000,000,000.00 Rp 21,436,900,000,000.00 Rp 16,065,000,000,000.00 Rp 35,402,500,000,000.00 Rp 21,525,000,000,000.00 Rp 37,822,500,000,000.00 Rp 32,825,000,000,000.00 Rp 25,502,500,000,000.00 Rp 43,550,000,000,000.00 Rp 44,890,000,000,000.00 Rp 23,010,000,000,000.00 Rp 34,810,000,000,000.00 Rp 20,040,000,000,000.00 Rp 44,622,400,000,000.00 Rp 8,396,990,200,000,000.00 Rp 8,621,374,574,000,000.00

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

2)000.00Rp496,488,()0.00574,000,008,621,374, Rp(60

) 0.00713,050,00 Rp )(000.00Rp496,488,()000.000,200,000,Rp8,396,99(60

b

60

)000.00Rp496,488, )(55.0(

60

0.00713,050,00 Rp Rpa

Page 67: Statistika Excel

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1(60(())000.00Rp496,488,()000.004,574,000,Rp8,621,37(60(

) 000.00Rp713,050, )(000.00Rp496,488,()000.000,200,000,Rp8,396,99(60

r

260

000.00)0,200,000,Rp8,396,99 (Rp0.55)( -) 0.00713,050,00 Rp 7.30)(Rp7,306,48 ( - ,000.0062,500,000Rp19,786,1 .

xSy

58

320.005,859,820,Rp9,930,99 . xSy

6.00066,548,62Rp171,224, . xSy

Page 68: Statistika Excel

REGRESI ENERGI DAN KOMUNIKASIY2 NAMA

Rp 20,250,000,000,000.00 ZULKIFLI Rp 42,250,000,000,000.00 MAWAN Rp 7,290,000,000,000.00 RIAN Rp 40,960,000,000,000.00 FEBRI Rp 948,640,000,000,000.00 YANTO Rp 324,000,000,000,000.00 NAHWAN Rp 1,936,000,000,000,000.00 PAISAL Rp 1,849,000,000,000,000.00 AL SAFFAT GHAZALI Rp 2,304,000,000,000,000.00 SYAMSUL RIZAL Rp 4,624,000,000,000,000.00 NOVAL ARDIAN PRATAMA Rp 576,000,000,000,000.00 M.IQBAL Rp 1,600,000,000,000,000.00 FERDI MELSON R Rp 6,250,000,000,000.00 MARJUNI HARUN Rp 25,000,000,000,000.00 SUMIYO Rp 30,250,000,000,000.00 ISMET NUR HUSNI Rp 10,890,000,000,000.00 ADI CHANDRA Rp 9,000,000,000,000.00 SAHRI SANDI WINATA Rp 4,840,000,000,000.00 RUDI HARTONO Rp 30,250,000,000,000.00 IR.FIRMANSYAH Rp 12,250,000,000,000.00 EDI NELSON Rp 56,250,000,000,000.00 AMIR HUSIN Rp 625,000,000,000,000.00 FATIR RIZKI Rp 961,000,000,000,000.00 SARLAN PERKASA Rp 20,250,000,000,000.00 RUSDAN Rp 490,000,000,000.00 RUDI PERKASA Rp 289,000,000,000,000.00 S. HABNIN Rp 36,000,000,000,000.00 M. AKBAR Rp 100,000,000,000,000.00 Riduan Rp 289,000,000,000,000.00 RIO FEBRIANTO Rp 361,000,000,000,000.00 DANNY PRADANA Rp 256,000,000,000,000.00 SALAMAT PURBA Rp 6,250,000,000,000.00 PADRIZAL Rp 36,000,000,000,000.00 HAMIDIN SULISTHIO Rp 28,090,000,000,000.00 AZHARI BSC Rp 49,000,000,000,000.00 MARDIANTO Rp 9,302,500,000,000.00 LUKMAN ULHAKIM Rp 64,000,000,000,000.00 MUHAMAD TOHA ARAFAT,SE,AK Rp 24,010,000,000,000.00 YAN ALBERTHO Rp 64,000,000,000,000.00 KMS.TAUFI OURRAHMAN,SH Rp 25,000,000,000,000.00 HERMAN Rp 100,000,000,000,000.00 DANIEL Rp 7,840,000,000,000.00 RICO HANIF Rp 8,410,000,000,000.00 BENI PRAKOSO Rp 6,760,000,000,000.00 SUSANTO Rp 784,000,000,000,000.00 ANDIAN

Page 69: Statistika Excel

Rp 30,250,000,000,000.00 YOGI PUTRA Rp 225,000,000,000,000.00 DIDI SAPUTRA Rp 6,250,000,000,000.00 RUSLAN EFFENDI Rp 56,250,000,000,000.00 ISHAK HABIBI Rp 30,250,000,000,000.00 BOBBI Rp 6,250,000,000,000.00 VIVID ARDIANSYAH Rp 676,000,000,000,000.00 ARIANTO Rp 9,000,000,000,000.00 NURALI Rp 10,890,000,000,000.00 FEBRI WIJAYA Rp 7,290,000,000,000.00 BAGUS RAMAHNA Rp 12,250,000,000,000.00 RAHMAT PURWANTO Rp 42,250,000,000,000.00 ERWIN GUNAWAN Rp 42,250,000,000,000.00 H.SENEN Rp 15,210,000,000,000.00 ANDIKA KUSUMA Rp 9,000,000,000,000.00 DIDI KUSUMA WIJAYA Rp 19,786,162,500,000,000.00 N = 60

Sehingga persamaan persamaan regresi Y = Rp 11,895,724.77 -0.01 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

bXaY

22 )( XXn

XYnb YX

2)00.00Rp84,229,0()000.002,623,000,Rp2,674,27(60

) 0.00713,050,00 Rp )(00.00Rp84,229,0()0.00800,000,00Rp979,946,(60

b

0,000.00832,939,00Rp153,361,

0.00450,000,001,262,680,- Rp b

01.0Rpb

n

b

n

na XY

60

)00.00Rp84,229,0)(01.0(

60

0.00713,050,00 Rp Rpa

60

486.18Rp713,743, a

24.77Rp11,895,7 a

Page 70: Statistika Excel

B. Koefisien Korelasi Regresi

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar -0391369039%

REGRESI KESEHATAN DAN KECANTIKANY2 NAMA

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp () 00.00,500,000,019,786,162 Rp (60(()) .0023,720,700 Rp () .0088,290,000Rp14,594,7 (60(

) 000.00Rp713,050, )( .0023,720,700 Rp () 0.00800,000,00Rp347,405, (60

r

260

) 000,000,000.347,405,80 Rp 12.56)( (Rp -) 0.00713,050,00 Rp 49)(6,920,116. (Rp - 00.00,500,000,019,786,162 Rp .

xSy

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1(60(())000.00(Rp84,229,)000.002,623,000,Rp2,674,27(60(

) 000.00Rp713,050, )(00.00Rp84,229,0 ()0.00800,000,00Rp979,946,(60

r

379.00)Rp823,850, ( 3.00)391,614,39 Rp (

0.00450,000,001,262,680,- Rp r

000.006,094,905,322,631,66 Rp

0.00450,000,001,262,680,-Rp r

0.00391369-Rpr

2.

2

n

XYbYaYxSy

260

) 000,000,000.979,946,80 Rp 0.01)(- (Rp -) 0.00713,050,00 Rp .77)(11,895,724 Rp ( - 00.00,500,000,019,786,162 Rp .

xSy

58

600.004,190,329,Rp1,311,98 . xSy

6.00210,178,09Rp195,034, . xSy

.9013,965,464 Rp . xSy

Page 71: Statistika Excel

Rp 20,250,000,000,000.00 ZULKIFLI Rp 42,250,000,000,000.00 MAWAN Rp 7,290,000,000,000.00 RIAN Rp 40,960,000,000,000.00 FEBRI Rp 948,640,000,000,000.00 YANTO Rp 324,000,000,000,000.00 NAHWAN Rp 1,936,000,000,000,000.00 PAISAL Rp 1,849,000,000,000,000.00 AL SAFFAT GHAZALI Rp 2,304,000,000,000,000.00 SYAMSUL RIZAL Rp 4,624,000,000,000,000.00 NOVAL ARDIAN PRATAMA Rp 576,000,000,000,000.00 M.IQBAL Rp 1,600,000,000,000,000.00 FERDI MELSON R Rp 6,250,000,000,000.00 MARJUNI HARUN Rp 25,000,000,000,000.00 SUMIYO Rp 30,250,000,000,000.00 ISMET NUR HUSNI Rp 10,890,000,000,000.00 ADI CHANDRA Rp 9,000,000,000,000.00 SAHRI SANDI WINATA Rp 4,840,000,000,000.00 RUDI HARTONO Rp 30,250,000,000,000.00 IR.FIRMANSYAH Rp 12,250,000,000,000.00 EDI NELSON Rp 56,250,000,000,000.00 AMIR HUSIN Rp 625,000,000,000,000.00 FATIR RIZKI Rp 961,000,000,000,000.00 SARLAN PERKASA Rp 20,250,000,000,000.00 RUSDAN Rp 490,000,000,000.00 RUDI PERKASA Rp 289,000,000,000,000.00 S. HABNIN Rp 36,000,000,000,000.00 M. AKBAR Rp 100,000,000,000,000.00 Riduan Rp 289,000,000,000,000.00 RIO FEBRIANTO Rp 361,000,000,000,000.00 DANNY PRADANA Rp 256,000,000,000,000.00 SALAMAT PURBA Rp 6,250,000,000,000.00 PADRIZAL Rp 36,000,000,000,000.00 HAMIDIN SULISTHIO Rp 28,090,000,000,000.00 AZHARI BSC Rp 49,000,000,000,000.00 MARDIANTO Rp 9,302,500,000,000.00 LUKMAN ULHAKIM Rp 64,000,000,000,000.00 MUHAMAD TOHA ARAFAT,SE,AK Rp 24,010,000,000,000.00 YAN ALBERTHO Rp 64,000,000,000,000.00 KMS.TAUFI OURRAHMAN,SH Rp 25,000,000,000,000.00 HERMAN Rp 100,000,000,000,000.00 DANIEL Rp 7,840,000,000,000.00 RICO HANIF Rp 8,410,000,000,000.00 BENI PRAKOSO Rp 6,760,000,000,000.00 SUSANTO Rp 784,000,000,000,000.00 ANDIAN Rp 30,250,000,000,000.00 YOGI PUTRA Rp 225,000,000,000,000.00 DIDI SAPUTRA Rp 6,250,000,000,000.00 RUSLAN EFFENDI

Page 72: Statistika Excel

Rp 56,250,000,000,000.00 ISHAK HABIBI Rp 30,250,000,000,000.00 BOBBI Rp 6,250,000,000,000.00 VIVID ARDIANSYAH Rp 676,000,000,000,000.00 ARIANTO Rp 9,000,000,000,000.00 NURALI Rp 10,890,000,000,000.00 FEBRI WIJAYA Rp 7,290,000,000,000.00 BAGUS RAMAHNA Rp 12,250,000,000,000.00 RAHMAT PURWANTO Rp 42,250,000,000,000.00 ERWIN GUNAWAN Rp 42,250,000,000,000.00 H.SENEN Rp 15,210,000,000,000.00 ANDIKA KUSUMA Rp 9,000,000,000,000.00 DIDI KUSUMA WIJAYA Rp 19,786,162,500,000,000.00 N = 60

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

bXaY

22 )( XXn

XYnb YX

2)00.00Rp18,785,5 ().0028,250,000Rp10,263,9(60

) 0.00713,050,00 Rp )(00.00Rp18,785,5 ()0.00400,000,00Rp247,536,(60

b

0.00684,750,00Rp262,940,

000.003,225,000,Rp1,457,18 b

Rp5.54 b

n

b

n

na XY

60

)00.00Rp18,785,5)(Rp5.54(

60

0.00713,050,00 Rp a

60

191.66Rp608,943, a

53.19Rp10,149,0 a

Page 73: Statistika Excel

Sehingga persamaan persamaan regresi Y = Rp10,149,053.19 + Rp5.54 X

B. Koefisien Korelasi Regresi

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar 11%

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1(60(())000.00Rp496,488,()000.004,574,000,Rp8,621,37(60(

) 000.00Rp713,050, )(000.00Rp496,488,()000.000,200,000,Rp8,396,99(60

r

260

000.00)0,200,000,Rp8,396,99 (Rp0.55)( -) 0.00713,050,00 Rp 7.30)(Rp7,306,48 ( - ,000.0062,500,000Rp19,786,1 .

xSy

22 ) 0.00713,050,00 Rp ()00.00,500,000,019,786,162 Rp (60())00.00Rp18,785,5 ().0028,250,000Rp10,263,9 (60(

) 000.00Rp713,050, )(00.00Rp18,785,5 ()0.00400,000,00Rp247,536, (60

r

00.00,250,369,013,359,101 Rp

000.003,225,000,Rp1,457,18 r

Rp0.11 r

379.00)Rp823,850, ( 45.90)Rp16,215,4 (

000.003,225,000,Rp1,457,18 r

2.

2

n

XYbYaYxSy

260

0.00)400,000,00Rp247,536, )( Rp5.54 ( -000.00)Rp713,050, 53.19)(Rp10,149,0 ( - 00.00,500,000,019,786,162 Rp .

xSy

58

,300.0065,446,118Rp11,177,5 . xSy

0.00645,622,73Rp192,716, . xSy

.1013,882,242 Rp . xSy

Page 74: Statistika Excel

REGRESI ENERGI DAN KOMUNIKASIPENDAPATAN (Y) ENERGI DAN KOMUNIKASI (X)

Rp 4,500,000.00 Rp 446,000.00 Rp 6,500,000.00 Rp 318,000.00 Rp 2,700,000.00 Rp 258,000.00 Rp 6,400,000.00 Rp 487,000.00 Rp 30,800,000.00 Rp 543,000.00 Rp 18,000,000.00 Rp 810,000.00 Rp 44,000,000.00 Rp 584,000.00 Rp 43,000,000.00 Rp 359,000.00 Rp 48,000,000.00 Rp 1,485,000.00 Rp 68,000,000.00 Rp 760,000.00 Rp 24,000,000.00 Rp 542,000.00 Rp 40,000,000.00 Rp 559,000.00 Rp 2,500,000.00 Rp 477,000.00 Rp 5,000,000.00 Rp 636,000.00 Rp 5,500,000.00 Rp 1,044,000.00 Rp 3,300,000.00 Rp 542,000.00 Rp 3,000,000.00 Rp 366,000.00 Rp 2,200,000.00 Rp 296,000.00 Rp 5,500,000.00 Rp 592,000.00 Rp 3,500,000.00 Rp 330,000.00 Rp 7,500,000.00 Rp 99,000.00 Rp 25,000,000.00 Rp 289,000.00 Rp 31,000,000.00 Rp 800,000.00 Rp 4,500,000.00 Rp 630,000.00 Rp 700,000.00 Rp 165,000.00 Rp 17,000,000.00 Rp 1,520,000.00 Rp 6,000,000.00 Rp 504,000.00 Rp 10,000,000.00 Rp 51,487,000.00 Rp 17,000,000.00 Rp 530,000.00 Rp 19,000,000.00 Rp 466,000.00 Rp 16,000,000.00 Rp 1,330,000.00 Rp 2,500,000.00 Rp 1,150,000.00 Rp 6,000,000.00 Rp 477,000.00 Rp 5,300,000.00 Rp 656,000.00 Rp 7,000,000.00 Rp 556,000.00 Rp 3,050,000.00 Rp 572,000.00 Rp 8,000,000.00 Rp 786,000.00 Rp 4,900,000.00 Rp 556,000.00 Rp 8,000,000.00 Rp 1,272,000.00 Rp 5,000,000.00 Rp 515,000.00 Rp 10,000,000.00 Rp 430,000.00 Rp 2,800,000.00 Rp 594,000.00 Rp 2,900,000.00 Rp 470,000.00 Rp 2,600,000.00 Rp 523,000.00 Rp 28,000,000.00 Rp 699,000.00

Page 75: Statistika Excel

Rp 5,500,000.00 Rp 438,000.00 Rp 15,000,000.00 Rp 287,000.00 Rp 2,500,000.00 Rp 386,000.00 Rp 7,500,000.00 Rp 263,000.00 Rp 5,500,000.00 Rp 442,000.00 Rp 2,500,000.00 Rp 464,000.00 Rp 26,000,000.00 Rp 587,000.00 Rp 3,000,000.00 Rp 492,000.00 Rp 3,300,000.00 Rp 428,000.00 Rp 2,700,000.00 Rp 320,000.00 Rp 3,500,000.00 Rp 249,000.00 Rp 6,500,000.00 Rp 257,000.00 Rp 6,500,000.00 Rp 388,000.00 Rp 3,900,000.00 Rp 320,000.00 Rp 3,000,000.00 Rp 398,000.00 Rp 713,050,000.00 Rp 84,229,000.00

Sehingga persamaan persamaan regresi Y = Rp 11,895,724.77 -0.01 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

2)00.00Rp84,229,0()000.002,623,000,Rp2,674,27(60

) 0.00713,050,00 Rp )(00.00Rp84,229,0()0.00800,000,00Rp979,946,(60

b

0,000.00832,939,00Rp153,361,

0.00450,000,001,262,680,- Rp b

01.0Rpb

n

b

n

na XY

60

)00.00Rp84,229,0)(01.0(

60

0.00713,050,00 Rp Rpa

24.77Rp11,895,7 a

Page 76: Statistika Excel

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar -0391369039%

REGRESI KESEHATAN DAN KECANTIKANPENDAPATAN (Y) KESEHATAN DAN KECANTIKAN (X)

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1(60(())000.00(Rp84,229,)000.002,623,000,Rp2,674,27(60(

) 000.00Rp713,050, )(00.00Rp84,229,0 ()0.00800,000,00Rp979,946,(60

r

379.00)Rp823,850, ( 3.00)391,614,39 Rp (

0.00450,000,001,262,680,- Rp r

000.006,094,905,322,631,66 Rp

0.00450,000,001,262,680,-Rp r

0.00391369-Rpr

2.

2

n

XYbYaYxSy

260

) 000,000,000.979,946,80 Rp 0.01)(- (Rp -) 0.00713,050,00 Rp .77)(11,895,724 Rp ( - 00.00,500,000,019,786,162 Rp .

xSy

58

600.004,190,329,Rp1,311,98 . xSy

6.00210,178,09Rp195,034, . xSy

.9013,965,464 Rp . xSy

Page 77: Statistika Excel

Rp 4,500,000.00 Rp 256,000.00 Rp 6,500,000.00 Rp 663,500.00 Rp 2,700,000.00 Rp 180,000.00 Rp 6,400,000.00 Rp 618,000.00 Rp 30,800,000.00 Rp 455,000.00 Rp 18,000,000.00 Rp 305,000.00 Rp 44,000,000.00 Rp 305,000.00 Rp 43,000,000.00 Rp 68,000.00 Rp 48,000,000.00 Rp 162,000.00 Rp 68,000,000.00 Rp 260,000.00 Rp 24,000,000.00 Rp 58,000.00 Rp 40,000,000.00 Rp 150,000.00 Rp 2,500,000.00 Rp 146,000.00 Rp 5,000,000.00 Rp 170,000.00 Rp 5,500,000.00 Rp 520,000.00 Rp 3,300,000.00 Rp 325,000.00 Rp 3,000,000.00 Rp 250,000.00 Rp 2,200,000.00 Rp 225,000.00 Rp 5,500,000.00 Rp 500,000.00 Rp 3,500,000.00 Rp 50,000.00 Rp 7,500,000.00 Rp 118,000.00 Rp 25,000,000.00 Rp 177,000.00 Rp 31,000,000.00 Rp 1,400,000.00 Rp 4,500,000.00 Rp 850,000.00 Rp 700,000.00 Rp 155,000.00 Rp 17,000,000.00 Rp 720,000.00 Rp 6,000,000.00 Rp 98,000.00 Rp 10,000,000.00 Rp 640,000.00 Rp 17,000,000.00 Rp 920,000.00 Rp 19,000,000.00 Rp 1,300,000.00 Rp 16,000,000.00 Rp 110,000.00 Rp 2,500,000.00 Rp 60,000.00 Rp 6,000,000.00 Rp 225,000.00 Rp 5,300,000.00 Rp 250,000.00 Rp 7,000,000.00 Rp 80,000.00 Rp 3,050,000.00 Rp 305,000.00 Rp 8,000,000.00 Rp 180,000.00 Rp 4,900,000.00 Rp 205,000.00 Rp 8,000,000.00 Rp 290,000.00 Rp 5,000,000.00 Rp 50,000.00 Rp 10,000,000.00 Rp 230,000.00 Rp 2,800,000.00 Rp 87,000.00 Rp 2,900,000.00 Rp 294,000.00 Rp 2,600,000.00 Rp 378,000.00 Rp 28,000,000.00 Rp 382,000.00 Rp 5,500,000.00 Rp 437,000.00 Rp 15,000,000.00 Rp 234,000.00 Rp 2,500,000.00 Rp 280,000.00

Page 78: Statistika Excel

Rp 7,500,000.00 Rp 134,000.00 Rp 5,500,000.00 Rp 220,000.00 Rp 2,500,000.00 Rp 210,000.00 Rp 26,000,000.00 Rp 156,000.00 Rp 3,000,000.00 Rp 149,000.00 Rp 3,300,000.00 Rp 393,000.00 Rp 2,700,000.00 Rp 248,000.00 Rp 3,500,000.00 Rp 272,000.00 Rp 6,500,000.00 Rp 138,000.00 Rp 6,500,000.00 Rp 322,000.00 Rp 3,900,000.00 Rp 233,000.00 Rp 3,000,000.00 Rp 189,000.00 Rp 713,050,000.00 Rp 18,785,500.00

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

2)00.00Rp18,785,5 ().0028,250,000Rp10,263,9(60

) 0.00713,050,00 Rp )(00.00Rp18,785,5 ()0.00400,000,00Rp247,536,(60

b

0.00684,750,00Rp262,940,

000.003,225,000,Rp1,457,18 b

Rp5.54 b

60

)00.00Rp18,785,5)(Rp5.54(

60

0.00713,050,00 Rp a

60

191.66Rp608,943, a

53.19Rp10,149,0 a

Page 79: Statistika Excel

Sehingga persamaan persamaan regresi Y = Rp10,149,053.19 + Rp5.54 X

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar 11%

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp ()00.00,500,000,019,786,162 Rp (60())00.00Rp18,785,5 ().0028,250,000Rp10,263,9 (60(

) 000.00Rp713,050, )(00.00Rp18,785,5 ()0.00400,000,00Rp247,536, (60

r

00.00,250,369,013,359,101 Rp

000.003,225,000,Rp1,457,18 r

379.00)Rp823,850, ( 45.90)Rp16,215,4 (

000.003,225,000,Rp1,457,18 r

2.

2

n

XYbYaYxSy

260

0.00)400,000,00Rp247,536, )( Rp5.54 ( -000.00)Rp713,050, 53.19)(Rp10,149,0 ( - 00.00,500,000,019,786,162 Rp .

xSy

58

,300.0065,446,118Rp11,177,5 . xSy

0.00645,622,73Rp192,716, . xSy

Page 80: Statistika Excel

X.Y X2 Rp 2,007,000,000,000.00 Rp 198,916,000,000.00 Rp 2,067,000,000,000.00 Rp 101,124,000,000.00 Rp 696,600,000,000.00 Rp 66,564,000,000.00 Rp 3,116,800,000,000.00 Rp 237,169,000,000.00 Rp 16,724,400,000,000.00 Rp 294,849,000,000.00 Rp 14,580,000,000,000.00 Rp 656,100,000,000.00 Rp 25,696,000,000,000.00 Rp 341,056,000,000.00 Rp 15,437,000,000,000.00 Rp 128,881,000,000.00 Rp 71,280,000,000,000.00 Rp 2,205,225,000,000.00 Rp 51,680,000,000,000.00 Rp 577,600,000,000.00 Rp 13,008,000,000,000.00 Rp 293,764,000,000.00 Rp 22,360,000,000,000.00 Rp 312,481,000,000.00 Rp 1,192,500,000,000.00 Rp 227,529,000,000.00 Rp 3,180,000,000,000.00 Rp 404,496,000,000.00 Rp 5,742,000,000,000.00 Rp 1,089,936,000,000.00 Rp 1,788,600,000,000.00 Rp 293,764,000,000.00 Rp 1,098,000,000,000.00 Rp 133,956,000,000.00 Rp 651,200,000,000.00 Rp 87,616,000,000.00 Rp 3,256,000,000,000.00 Rp 350,464,000,000.00 Rp 1,155,000,000,000.00 Rp 108,900,000,000.00 Rp 742,500,000,000.00 Rp 9,801,000,000.00 Rp 7,225,000,000,000.00 Rp 83,521,000,000.00 Rp 24,800,000,000,000.00 Rp 640,000,000,000.00 Rp 2,835,000,000,000.00 Rp 396,900,000,000.00 Rp 115,500,000,000.00 Rp 27,225,000,000.00 Rp 25,840,000,000,000.00 Rp 2,310,400,000,000.00 Rp 3,024,000,000,000.00 Rp 254,016,000,000.00 Rp 514,870,000,000,000.00 Rp 2,650,911,169,000,000.00 Rp 9,010,000,000,000.00 Rp 280,900,000,000.00 Rp 8,854,000,000,000.00 Rp 217,156,000,000.00 Rp 21,280,000,000,000.00 Rp 1,768,900,000,000.00 Rp 2,875,000,000,000.00 Rp 1,322,500,000,000.00 Rp 2,862,000,000,000.00 Rp 227,529,000,000.00 Rp 3,476,800,000,000.00 Rp 430,336,000,000.00 Rp 3,892,000,000,000.00 Rp 309,136,000,000.00 Rp 1,744,600,000,000.00 Rp 327,184,000,000.00 Rp 6,288,000,000,000.00 Rp 617,796,000,000.00 Rp 2,724,400,000,000.00 Rp 309,136,000,000.00 Rp 10,176,000,000,000.00 Rp 1,617,984,000,000.00 Rp 2,575,000,000,000.00 Rp 265,225,000,000.00 Rp 4,300,000,000,000.00 Rp 184,900,000,000.00 Rp 1,663,200,000,000.00 Rp 352,836,000,000.00 Rp 1,363,000,000,000.00 Rp 220,900,000,000.00 Rp 1,359,800,000,000.00 Rp 273,529,000,000.00 Rp 19,572,000,000,000.00 Rp 488,601,000,000.00

Page 81: Statistika Excel

Rp 2,409,000,000,000.00 Rp 191,844,000,000.00 Rp 4,305,000,000,000.00 Rp 82,369,000,000.00 Rp 965,000,000,000.00 Rp 148,996,000,000.00 Rp 1,972,500,000,000.00 Rp 69,169,000,000.00 Rp 2,431,000,000,000.00 Rp 195,364,000,000.00 Rp 1,160,000,000,000.00 Rp 215,296,000,000.00 Rp 15,262,000,000,000.00 Rp 344,569,000,000.00 Rp 1,476,000,000,000.00 Rp 242,064,000,000.00 Rp 1,412,400,000,000.00 Rp 183,184,000,000.00 Rp 864,000,000,000.00 Rp 102,400,000,000.00 Rp 871,500,000,000.00 Rp 62,001,000,000.00 Rp 1,670,500,000,000.00 Rp 66,049,000,000.00 Rp 2,522,000,000,000.00 Rp 150,544,000,000.00 Rp 1,248,000,000,000.00 Rp 102,400,000,000.00 Rp 1,194,000,000,000.00 Rp 158,404,000,000.00 Rp 979,946,800,000,000.00 Rp 2,674,272,623,000,000.00

2)00.00Rp84,229,0()000.002,623,000,Rp2,674,27(60

) 0.00713,050,00 Rp )(00.00Rp84,229,0()0.00800,000,00Rp979,946,(60

b

60

)00.00Rp84,229,0)(01.0(

60

0.00713,050,00 Rp Rpa

Page 82: Statistika Excel

X.Y X2

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1(60(())000.00(Rp84,229,)000.002,623,000,Rp2,674,27(60(

) 000.00Rp713,050, )(00.00Rp84,229,0 ()0.00800,000,00Rp979,946,(60

r

260

) 000,000,000.979,946,80 Rp 0.01)(- (Rp -) 0.00713,050,00 Rp .77)(11,895,724 Rp ( - 00.00,500,000,019,786,162 Rp .

xSy

Page 83: Statistika Excel

Rp 1,152,000,000,000.00 Rp 65,536,000,000.00 Rp 4,312,750,000,000.00 Rp 440,232,250,000.00 Rp 486,000,000,000.00 Rp 32,400,000,000.00 Rp 3,955,200,000,000.00 Rp 381,924,000,000.00 Rp 14,014,000,000,000.00 Rp 207,025,000,000.00 Rp 5,490,000,000,000.00 Rp 93,025,000,000.00 Rp 13,420,000,000,000.00 Rp 93,025,000,000.00 Rp 2,924,000,000,000.00 Rp 4,624,000,000.00 Rp 7,776,000,000,000.00 Rp 26,244,000,000.00 Rp 17,680,000,000,000.00 Rp 67,600,000,000.00 Rp 1,392,000,000,000.00 Rp 3,364,000,000.00 Rp 6,000,000,000,000.00 Rp 22,500,000,000.00 Rp 365,000,000,000.00 Rp 21,316,000,000.00 Rp 850,000,000,000.00 Rp 28,900,000,000.00 Rp 2,860,000,000,000.00 Rp 270,400,000,000.00 Rp 1,072,500,000,000.00 Rp 105,625,000,000.00 Rp 750,000,000,000.00 Rp 62,500,000,000.00 Rp 495,000,000,000.00 Rp 50,625,000,000.00 Rp 2,750,000,000,000.00 Rp 250,000,000,000.00 Rp 175,000,000,000.00 Rp 2,500,000,000.00 Rp 885,000,000,000.00 Rp 13,924,000,000.00 Rp 4,425,000,000,000.00 Rp 31,329,000,000.00 Rp 43,400,000,000,000.00 Rp 1,960,000,000,000.00 Rp 3,825,000,000,000.00 Rp 722,500,000,000.00 Rp 108,500,000,000.00 Rp 24,025,000,000.00 Rp 12,240,000,000,000.00 Rp 518,400,000,000.00 Rp 588,000,000,000.00 Rp 9,604,000,000.00 Rp 6,400,000,000,000.00 Rp 409,600,000,000.00 Rp 15,640,000,000,000.00 Rp 846,400,000,000.00 Rp 24,700,000,000,000.00 Rp 1,690,000,000,000.00 Rp 1,760,000,000,000.00 Rp 12,100,000,000.00 Rp 150,000,000,000.00 Rp 3,600,000,000.00 Rp 1,350,000,000,000.00 Rp 50,625,000,000.00 Rp 1,325,000,000,000.00 Rp 62,500,000,000.00 Rp 560,000,000,000.00 Rp 6,400,000,000.00 Rp 930,250,000,000.00 Rp 93,025,000,000.00 Rp 1,440,000,000,000.00 Rp 32,400,000,000.00 Rp 1,004,500,000,000.00 Rp 42,025,000,000.00 Rp 2,320,000,000,000.00 Rp 84,100,000,000.00 Rp 250,000,000,000.00 Rp 2,500,000,000.00 Rp 2,300,000,000,000.00 Rp 52,900,000,000.00 Rp 243,600,000,000.00 Rp 7,569,000,000.00 Rp 852,600,000,000.00 Rp 86,436,000,000.00 Rp 982,800,000,000.00 Rp 142,884,000,000.00 Rp 10,696,000,000,000.00 Rp 145,924,000,000.00 Rp 2,403,500,000,000.00 Rp 190,969,000,000.00 Rp 3,510,000,000,000.00 Rp 54,756,000,000.00 Rp 700,000,000,000.00 Rp 78,400,000,000.00

Page 84: Statistika Excel

Rp 1,005,000,000,000.00 Rp 17,956,000,000.00 Rp 1,210,000,000,000.00 Rp 48,400,000,000.00 Rp 525,000,000,000.00 Rp 44,100,000,000.00 Rp 4,056,000,000,000.00 Rp 24,336,000,000.00 Rp 447,000,000,000.00 Rp 22,201,000,000.00 Rp 1,296,900,000,000.00 Rp 154,449,000,000.00 Rp 669,600,000,000.00 Rp 61,504,000,000.00 Rp 952,000,000,000.00 Rp 73,984,000,000.00 Rp 897,000,000,000.00 Rp 19,044,000,000.00 Rp 2,093,000,000,000.00 Rp 103,684,000,000.00 Rp 908,700,000,000.00 Rp 54,289,000,000.00 Rp 567,000,000,000.00 Rp 35,721,000,000.00 Rp 247,536,400,000,000.00 Rp 10,263,928,250,000.00

Page 85: Statistika Excel

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

22 ) 0.00713,050,00 Rp ()00.00,500,000,019,786,162 Rp (60())00.00Rp18,785,5 ().0028,250,000Rp10,263,9 (60(

) 000.00Rp713,050, )(00.00Rp18,785,5 ()0.00400,000,00Rp247,536, (60

r

260

0.00)400,000,00Rp247,536, )( Rp5.54 ( -000.00)Rp713,050, 53.19)(Rp10,149,0 ( - 00.00,500,000,019,786,162 Rp .

xSy

Page 86: Statistika Excel

REGRESI TRANSPORTASIY2 NAMA

Rp 20,250,000,000,000.00 ZULKIFLI Rp 42,250,000,000,000.00 MAWAN Rp 7,290,000,000,000.00 RIAN Rp 40,960,000,000,000.00 FEBRI Rp 948,640,000,000,000.00 YANTO Rp 324,000,000,000,000.00 NAHWAN Rp 1,936,000,000,000,000.00 PAISAL Rp 1,849,000,000,000,000.00 AL SAFFAT GHAZALI Rp 2,304,000,000,000,000.00 SYAMSUL RIZAL Rp 4,624,000,000,000,000.00 NOVAL ARDIAN PRATAMA Rp 576,000,000,000,000.00 M.IQBAL Rp 1,600,000,000,000,000.00 FERDI MELSON R Rp 6,250,000,000,000.00 MARJUNI HARUN Rp 25,000,000,000,000.00 SUMIYO Rp 30,250,000,000,000.00 ISMET NUR HUSNI Rp 10,890,000,000,000.00 ADI CHANDRA Rp 9,000,000,000,000.00 SAHRI SANDI WINATA Rp 4,840,000,000,000.00 RUDI HARTONO Rp 30,250,000,000,000.00 IR.FIRMANSYAH Rp 12,250,000,000,000.00 EDI NELSON Rp 56,250,000,000,000.00 AMIR HUSIN Rp 625,000,000,000,000.00 FATIR RIZKI Rp 961,000,000,000,000.00 SARLAN PERKASA Rp 20,250,000,000,000.00 RUSDAN Rp 490,000,000,000.00 RUDI PERKASA Rp 289,000,000,000,000.00 S. HABNIN Rp 36,000,000,000,000.00 M. AKBAR Rp 100,000,000,000,000.00 Riduan Rp 289,000,000,000,000.00 RIO FEBRIANTO Rp 361,000,000,000,000.00 DANNY PRADANA Rp 256,000,000,000,000.00 SALAMAT PURBA Rp 6,250,000,000,000.00 PADRIZAL Rp 36,000,000,000,000.00 HAMIDIN SULISTHIO Rp 28,090,000,000,000.00 AZHARI BSC Rp 49,000,000,000,000.00 MARDIANTO Rp 9,302,500,000,000.00 LUKMAN ULHAKIM Rp 64,000,000,000,000.00 MUHAMAD TOHA ARAFAT,SE,AK Rp 24,010,000,000,000.00 YAN ALBERTHO Rp 64,000,000,000,000.00 KMS.TAUFI OURRAHMAN,SH Rp 25,000,000,000,000.00 HERMAN Rp 100,000,000,000,000.00 DANIEL Rp 7,840,000,000,000.00 RICO HANIF Rp 8,410,000,000,000.00 BENI PRAKOSO Rp 6,760,000,000,000.00 SUSANTO Rp 784,000,000,000,000.00 ANDIAN

Page 87: Statistika Excel

Rp 30,250,000,000,000.00 YOGI PUTRA Rp 225,000,000,000,000.00 DIDI SAPUTRA Rp 6,250,000,000,000.00 RUSLAN EFFENDI Rp 56,250,000,000,000.00 ISHAK HABIBI Rp 30,250,000,000,000.00 BOBBI Rp 6,250,000,000,000.00 VIVID ARDIANSYAH Rp 676,000,000,000,000.00 ARIANTO Rp 9,000,000,000,000.00 NURALI Rp 10,890,000,000,000.00 FEBRI WIJAYA Rp 7,290,000,000,000.00 BAGUS RAMAHNA Rp 12,250,000,000,000.00 RAHMAT PURWANTO Rp 42,250,000,000,000.00 ERWIN GUNAWAN Rp 42,250,000,000,000.00 H.SENEN Rp 15,210,000,000,000.00 ANDIKA KUSUMA Rp 9,000,000,000,000.00 DIDI KUSUMA WIJAYA Rp 19,786,162,500,000,000.00 N = 60

Sehingga persamaan persamaan regresi Y = Rp 11,895,724.77 -0.01 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

bXaY

22 )( XXn

XYnb YX

2).0021,606,500 Rp().0097,250,000Rp13,998,4(60

) 0.00713,050,00 Rp )(.0021,606,500 Rp()0.00000,000,00Rp329,537,(60

b

0.00992,750,00Rp373,068,

0.00175,000,004,365,705, Rp b

Rp11.70 b

n

b

n

na XY

60

)00.00Rp21,606,5 )(Rp11.70 (

60

0.00713,050,00 Rp a

60

735.71Rp460,207, a

8.93Rp7,670,12 a

Page 88: Statistika Excel

B. Koefisien Korelasi Regresi

REGRESI PENDIDIKANY2 NAMA

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1 (60(()).0021,606,500 (Rp).0097,250,000Rp13,998,4(60(

)000.00Rp713,050,)(.0021,606,500 Rp()0.00000,000,00Rp329,537,(60

r

) 379.00Rp823,850, ( ) 94.00Rp19,314,9 (

000.005,175,000,Rp4,365,70 r

Rp0.27 r 700.005,127,282,Rp5,912,66

000.005,175,000,Rp4,365,70 r

2.

2

n

XYbYaYxSy

260

) 000,000,000.329,537,00 Rp )( Rp11.70 ( -) 0.00713,050,00 Rp )( 8.93Rp7,670,12 ( - ,000.0062,500,000Rp19,786,1 .

xSy

58

,400.0089,318,596Rp10,460,6 . xSy

4.00712,389,59Rp180,356, . xSy

95.20Rp13,429,6 . xSy

Page 89: Statistika Excel

Rp 20,250,000,000,000.00 ZULKIFLI Rp 42,250,000,000,000.00 MAWAN Rp 7,290,000,000,000.00 RIAN Rp 40,960,000,000,000.00 FEBRI Rp 948,640,000,000,000.00 YANTO Rp 324,000,000,000,000.00 NAHWAN Rp 1,936,000,000,000,000.00 PAISAL Rp 1,849,000,000,000,000.00 AL SAFFAT GHAZALI Rp 2,304,000,000,000,000.00 SYAMSUL RIZAL Rp 4,624,000,000,000,000.00 NOVAL ARDIAN PRATAMA Rp 576,000,000,000,000.00 M.IQBAL Rp 1,600,000,000,000,000.00 FERDI MELSON R Rp 6,250,000,000,000.00 MARJUNI HARUN Rp 25,000,000,000,000.00 SUMIYO Rp 30,250,000,000,000.00 ISMET NUR HUSNI Rp 10,890,000,000,000.00 ADI CHANDRA Rp 9,000,000,000,000.00 SAHRI SANDI WINATA Rp 4,840,000,000,000.00 RUDI HARTONO Rp 30,250,000,000,000.00 IR.FIRMANSYAH Rp 12,250,000,000,000.00 EDI NELSON Rp 56,250,000,000,000.00 AMIR HUSIN Rp 625,000,000,000,000.00 FATIR RIZKI Rp 961,000,000,000,000.00 SARLAN PERKASA Rp 20,250,000,000,000.00 RUSDAN Rp 490,000,000,000.00 RUDI PERKASA Rp 289,000,000,000,000.00 S. HABNIN Rp 36,000,000,000,000.00 M. AKBAR Rp 100,000,000,000,000.00 Riduan Rp 289,000,000,000,000.00 RIO FEBRIANTO Rp 361,000,000,000,000.00 DANNY PRADANA Rp 256,000,000,000,000.00 SALAMAT PURBA Rp 6,250,000,000,000.00 PADRIZAL Rp 36,000,000,000,000.00 HAMIDIN SULISTHIO Rp 28,090,000,000,000.00 AZHARI BSC Rp 49,000,000,000,000.00 MARDIANTO Rp 9,302,500,000,000.00 LUKMAN ULHAKIM Rp 64,000,000,000,000.00 MUHAMAD TOHA ARAFAT,SE,AK Rp 24,010,000,000,000.00 YAN ALBERTHO Rp 64,000,000,000,000.00 KMS.TAUFI OURRAHMAN,SH Rp 25,000,000,000,000.00 HERMAN Rp 100,000,000,000,000.00 DANIEL Rp 7,840,000,000,000.00 RICO HANIF Rp 8,410,000,000,000.00 BENI PRAKOSO Rp 6,760,000,000,000.00 SUSANTO Rp 784,000,000,000,000.00 ANDIAN Rp 30,250,000,000,000.00 YOGI PUTRA Rp 225,000,000,000,000.00 DIDI SAPUTRA Rp 6,250,000,000,000.00 RUSLAN EFFENDI

Page 90: Statistika Excel

Rp 56,250,000,000,000.00 ISHAK HABIBI Rp 30,250,000,000,000.00 BOBBI Rp 6,250,000,000,000.00 VIVID ARDIANSYAH Rp 676,000,000,000,000.00 ARIANTO Rp 9,000,000,000,000.00 NURALI Rp 10,890,000,000,000.00 FEBRI WIJAYA Rp 7,290,000,000,000.00 BAGUS RAMAHNA Rp 12,250,000,000,000.00 RAHMAT PURWANTO Rp 42,250,000,000,000.00 ERWIN GUNAWAN Rp 42,250,000,000,000.00 H.SENEN Rp 15,210,000,000,000.00 ANDIKA KUSUMA Rp 9,000,000,000,000.00 DIDI KUSUMA WIJAYA Rp 19,786,162,500,000,000.00 N = 60

Sehingga persamaan persamaan regresi Y = Rp9,033,178.05 + Rp9.54 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

bXaY

22 )( XXn

XYnb YX

2) .0017,934,000 Rp () .0094,000,000Rp10,371,0 (60

) 000.00Rp713,050, )( .0017,934,000 Rp ()000,000,000.260,923,30 Rp(60

b

004,000,000.300,637,28 Rp

0.00300,000,002,867,559, Rp b

9.54 Rp b

n

b

n

na XY

60

) .0017,934,000 Rp )( 9.54 Rp (

60

0.00713,050,00 Rp a

60

2.93541,990,68 Rp a

059,033,178. Rp a

Page 91: Statistika Excel

B. Koefisien Korelasi Regresi

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar 20%

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp () 00.00,500,000,019,786,162 Rp (60()) .0017,934,000 Rp () .0094,000,000Rp10,371,0 (60(

) 0.00713,050,00 Rp )( .0017,934,000 Rp () 000,000,000.260,923,30 Rp (60

r

) 379.00Rp823,850, ( ) 95.10Rp17,338,8 (

000.009,300,000,Rp2,867,55 r

,200.0055,299,576Rp14,284,6

000.009,300,000,Rp2,867,55 r

0.20 Rp r

2.

2

n

XYbYaYxSy

260

) 000,000,000.260,923,30 Rp Rp9.54)( ( -000.00)Rp713,050, )( 8.05Rp9,033,17 ( - 00.00,500,000,019,786,162 Rp .

xSy

58

,700.0098,256,528Rp10,856,2 . xSy

7.00556,147,04Rp187,177, . xSy

84.90Rp13,681,2 . xSy

Page 92: Statistika Excel

PENDAPATAN (Y) TRANSPORTASI (X) X.Y Rp 4,500,000.00 Rp 533,000.00 Rp 2,398,500,000,000.00 Rp 6,500,000.00 Rp 212,000.00 Rp 1,378,000,000,000.00 Rp 2,700,000.00 Rp 971,000.00 Rp 2,621,700,000,000.00 Rp 6,400,000.00 Rp 705,000.00 Rp 4,512,000,000,000.00 Rp 30,800,000.00 Rp 700,000.00 Rp 21,560,000,000,000.00 Rp 18,000,000.00 Rp 315,000.00 Rp 5,670,000,000,000.00 Rp 44,000,000.00 Rp 725,000.00 Rp 31,900,000,000,000.00 Rp 43,000,000.00 Rp 250,000.00 Rp 10,750,000,000,000.00 Rp 48,000,000.00 Rp 600,000.00 Rp 28,800,000,000,000.00 Rp 68,000,000.00 Rp 330,000.00 Rp 22,440,000,000,000.00 Rp 24,000,000.00 Rp 250,000.00 Rp 6,000,000,000,000.00 Rp 40,000,000.00 Rp 200,000.00 Rp 8,000,000,000,000.00 Rp 2,500,000.00 Rp 72,000.00 Rp 180,000,000,000.00 Rp 5,000,000.00 Rp 54,000.00 Rp 270,000,000,000.00 Rp 5,500,000.00 Rp 372,000.00 Rp 2,046,000,000,000.00 Rp 3,300,000.00 Rp 72,000.00 Rp 237,600,000,000.00 Rp 3,000,000.00 Rp 313,000.00 Rp 939,000,000,000.00 Rp 2,200,000.00 Rp 36,000.00 Rp 79,200,000,000.00 Rp 5,500,000.00 Rp 500,000.00 Rp 2,750,000,000,000.00 Rp 3,500,000.00 Rp 50,000.00 Rp 175,000,000,000.00 Rp 7,500,000.00 Rp 40,000.00 Rp 300,000,000,000.00 Rp 25,000,000.00 Rp 400,000.00 Rp 10,000,000,000,000.00 Rp 31,000,000.00 Rp 600,000.00 Rp 18,600,000,000,000.00 Rp 4,500,000.00 Rp 640,000.00 Rp 2,880,000,000,000.00 Rp 700,000.00 Rp 40,000.00 Rp 28,000,000,000.00 Rp 17,000,000.00 Rp 1,190,000.00 Rp 20,230,000,000,000.00 Rp 6,000,000.00 Rp 200,000.00 Rp 1,200,000,000,000.00 Rp 10,000,000.00 Rp 501,500.00 Rp 5,015,000,000,000.00 Rp 17,000,000.00 Rp 1,290,000.00 Rp 21,930,000,000,000.00 Rp 19,000,000.00 Rp 952,000.00 Rp 18,088,000,000,000.00 Rp 16,000,000.00 Rp 750,000.00 Rp 12,000,000,000,000.00 Rp 2,500,000.00 Rp 190,000.00 Rp 475,000,000,000.00 Rp 6,000,000.00 Rp 360,000.00 Rp 2,160,000,000,000.00 Rp 5,300,000.00 Rp 180,000.00 Rp 954,000,000,000.00 Rp 7,000,000.00 Rp 390,000.00 Rp 2,730,000,000,000.00 Rp 3,050,000.00 Rp 500,000.00 Rp 1,525,000,000,000.00 Rp 8,000,000.00 Rp 700,000.00 Rp 5,600,000,000,000.00 Rp 4,900,000.00 Rp 200,000.00 Rp 980,000,000,000.00 Rp 8,000,000.00 Rp 600,000.00 Rp 4,800,000,000,000.00 Rp 5,000,000.00 Rp 640,000.00 Rp 3,200,000,000,000.00 Rp 10,000,000.00 Rp 110,000.00 Rp 1,100,000,000,000.00 Rp 2,800,000.00 Rp 56,000.00 Rp 156,800,000,000.00 Rp 2,900,000.00 Rp 34,000.00 Rp 98,600,000,000.00 Rp 2,600,000.00 Rp 24,000.00 Rp 62,400,000,000.00 Rp 28,000,000.00 Rp 120,000.00 Rp 3,360,000,000,000.00

Page 93: Statistika Excel

Rp 5,500,000.00 Rp 1,078,000.00 Rp 5,929,000,000,000.00 Rp 15,000,000.00 Rp 678,000.00 Rp 10,170,000,000,000.00 Rp 2,500,000.00 Rp 28,000.00 Rp 70,000,000,000.00 Rp 7,500,000.00 Rp 67,000.00 Rp 502,500,000,000.00 Rp 5,500,000.00 Rp 56,000.00 Rp 308,000,000,000.00 Rp 2,500,000.00 Rp 100,000.00 Rp 250,000,000,000.00 Rp 26,000,000.00 Rp 666,000.00 Rp 17,316,000,000,000.00 Rp 3,000,000.00 Rp 89,000.00 Rp 267,000,000,000.00 Rp 3,300,000.00 Rp 81,000.00 Rp 267,300,000,000.00 Rp 2,700,000.00 Rp 96,000.00 Rp 259,200,000,000.00 Rp 3,500,000.00 Rp 70,000.00 Rp 245,000,000,000.00 Rp 6,500,000.00 Rp 161,000.00 Rp 1,046,500,000,000.00 Rp 6,500,000.00 Rp 357,000.00 Rp 2,320,500,000,000.00 Rp 3,900,000.00 Rp 78,000.00 Rp 304,200,000,000.00 Rp 3,000,000.00 Rp 34,000.00 Rp 102,000,000,000.00 Rp 713,050,000.00 Rp 21,606,500.00 Rp 329,537,000,000,000.00

Sehingga persamaan persamaan regresi Y = Rp 11,895,724.77 -0.01 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

22 )( XXn

XYnb YX

2).0021,606,500 Rp().0097,250,000Rp13,998,4(60

) 0.00713,050,00 Rp )(.0021,606,500 Rp()0.00000,000,00Rp329,537,(60

b

0.00992,750,00Rp373,068,

0.00175,000,004,365,705, Rp b

Rp11.70 b

60

)00.00Rp21,606,5 )(Rp11.70 (

60

0.00713,050,00 Rp a

60

735.71Rp460,207, a

Page 94: Statistika Excel

PENDAPATAN (Y) PENDIDIKAN (X) X.Y

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1 (60(()).0021,606,500 (Rp).0097,250,000Rp13,998,4(60(

)000.00Rp713,050,)(.0021,606,500 Rp()0.00000,000,00Rp329,537,(60

r

) 379.00Rp823,850, ( ) 94.00Rp19,314,9 (

000.005,175,000,Rp4,365,70 r

700.005,127,282,Rp5,912,66

000.005,175,000,Rp4,365,70 r

2.

2

n

XYbYaYxSy

260

) 000,000,000.329,537,00 Rp )( Rp11.70 ( -) 0.00713,050,00 Rp )( 8.93Rp7,670,12 ( - ,000.0062,500,000Rp19,786,1 .

xSy

58

,400.0089,318,596Rp10,460,6 . xSy

4.00712,389,59Rp180,356, . xSy

95.20Rp13,429,6 . xSy

Page 95: Statistika Excel

Rp 4,500,000.00 Rp 175,000.00 Rp 787,500,000,000.00 Rp 6,500,000.00 Rp 200,000.00 Rp 1,300,000,000,000.00 Rp 2,700,000.00 Rp 130,000.00 Rp 351,000,000,000.00 Rp 6,400,000.00 Rp 540,000.00 Rp 3,456,000,000,000.00 Rp 30,800,000.00 Rp 540,000.00 Rp 16,632,000,000,000.00 Rp 18,000,000.00 Rp 250,000.00 Rp 4,500,000,000,000.00 Rp 44,000,000.00 Rp 700,000.00 Rp 30,800,000,000,000.00 Rp 43,000,000.00 Rp 370,000.00 Rp 15,910,000,000,000.00 Rp 48,000,000.00 Rp 750,000.00 Rp 36,000,000,000,000.00 Rp 68,000,000.00 Rp 378,000.00 Rp 25,704,000,000,000.00 Rp 24,000,000.00 Rp 580,000.00 Rp 13,920,000,000,000.00 Rp 40,000,000.00 Rp 610,000.00 Rp 24,400,000,000,000.00 Rp 2,500,000.00 Rp 80,000.00 Rp 200,000,000,000.00 Rp 5,000,000.00 Rp 550,000.00 Rp 2,750,000,000,000.00 Rp 5,500,000.00 Rp 600,000.00 Rp 3,300,000,000,000.00 Rp 3,300,000.00 Rp 200,000.00 Rp 660,000,000,000.00 Rp 3,000,000.00 Rp 2,000,000.00 Rp 6,000,000,000,000.00 Rp 2,200,000.00 Rp 100,000.00 Rp 220,000,000,000.00 Rp 5,500,000.00 Rp 70,000.00 Rp 385,000,000,000.00 Rp 3,500,000.00 Rp 150,000.00 Rp 525,000,000,000.00 Rp 7,500,000.00 Rp 250,000.00 Rp 1,875,000,000,000.00 Rp 25,000,000.00 Rp 330,000.00 Rp 8,250,000,000,000.00 Rp 31,000,000.00 Rp 50,000.00 Rp 1,550,000,000,000.00 Rp 4,500,000.00 Rp 350,000.00 Rp 1,575,000,000,000.00 Rp 700,000.00 Rp 200,000.00 Rp 140,000,000,000.00 Rp 17,000,000.00 Rp 300,000.00 Rp 5,100,000,000,000.00 Rp 6,000,000.00 Rp 50,000.00 Rp 300,000,000,000.00 Rp 10,000,000.00 Rp 400,000.00 Rp 4,000,000,000,000.00 Rp 17,000,000.00 Rp 150,000.00 Rp 2,550,000,000,000.00 Rp 19,000,000.00 Rp 175,000.00 Rp 3,325,000,000,000.00 Rp 16,000,000.00 Rp 450,000.00 Rp 7,200,000,000,000.00 Rp 2,500,000.00 Rp 750,000.00 Rp 1,875,000,000,000.00 Rp 6,000,000.00 Rp 200,000.00 Rp 1,200,000,000,000.00 Rp 5,300,000.00 Rp 250,000.00 Rp 1,325,000,000,000.00 Rp 7,000,000.00 Rp 175,000.00 Rp 1,225,000,000,000.00 Rp 3,050,000.00 Rp 200,000.00 Rp 610,000,000,000.00 Rp 8,000,000.00 Rp 300,000.00 Rp 2,400,000,000,000.00 Rp 4,900,000.00 Rp 100,000.00 Rp 490,000,000,000.00 Rp 8,000,000.00 Rp 200,000.00 Rp 1,600,000,000,000.00 Rp 5,000,000.00 Rp 350,000.00 Rp 1,750,000,000,000.00 Rp 10,000,000.00 Rp 100,000.00 Rp 1,000,000,000,000.00 Rp 2,800,000.00 Rp 300,000.00 Rp 840,000,000,000.00 Rp 2,900,000.00 Rp 350,000.00 Rp 1,015,000,000,000.00 Rp 2,600,000.00 Rp 300,000.00 Rp 780,000,000,000.00 Rp 28,000,000.00 Rp 100,000.00 Rp 2,800,000,000,000.00 Rp 5,500,000.00 Rp 400,000.00 Rp 2,200,000,000,000.00 Rp 15,000,000.00 Rp 200,000.00 Rp 3,000,000,000,000.00 Rp 2,500,000.00 Rp 350,000.00 Rp 875,000,000,000.00

Page 96: Statistika Excel

Rp 7,500,000.00 Rp 300,000.00 Rp 2,250,000,000,000.00 Rp 5,500,000.00 Rp 400,000.00 Rp 2,200,000,000,000.00 Rp 2,500,000.00 Rp 100,000.00 Rp 250,000,000,000.00 Rp 26,000,000.00 Rp 200,000.00 Rp 5,200,000,000,000.00 Rp 3,000,000.00 Rp 175,000.00 Rp 525,000,000,000.00 Rp 3,300,000.00 Rp 55,000.00 Rp 181,500,000,000.00 Rp 2,700,000.00 Rp 89,000.00 Rp 240,300,000,000.00 Rp 3,500,000.00 Rp 45,000.00 Rp 157,500,000,000.00 Rp 6,500,000.00 Rp 55,000.00 Rp 357,500,000,000.00 Rp 6,500,000.00 Rp 67,000.00 Rp 435,500,000,000.00 Rp 3,900,000.00 Rp 45,000.00 Rp 175,500,000,000.00 Rp 3,000,000.00 Rp 100,000.00 Rp 300,000,000,000.00 Rp 713,050,000.00 Rp 17,934,000.00 Rp 260,923,300,000,000.00

Sehingga persamaan persamaan regresi Y = Rp9,033,178.05 + Rp9.54 X

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

2) .0017,934,000 Rp () .0094,000,000Rp10,371,0 (60

) 000.00Rp713,050, )( .0017,934,000 Rp ()000,000,000.260,923,30 Rp(60

b

004,000,000.300,637,28 Rp

0.00300,000,002,867,559, Rp b

60

) .0017,934,000 Rp )( 9.54 Rp (

60

0.00713,050,00 Rp a

60

2.93541,990,68 Rp a

059,033,178. Rp a

Page 97: Statistika Excel

Jadi hubungan keeratan antara biaya iklan dan volume penjualan sebesar 20%

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp () 00.00,500,000,019,786,162 Rp (60()) .0017,934,000 Rp () .0094,000,000Rp10,371,0 (60(

) 0.00713,050,00 Rp )( .0017,934,000 Rp () 000,000,000.260,923,30 Rp (60

r

) 379.00Rp823,850, ( ) 95.10Rp17,338,8 (

000.009,300,000,Rp2,867,55 r

,200.0055,299,576Rp14,284,6

000.009,300,000,Rp2,867,55 r

2.

2

n

XYbYaYxSy

260

) 000,000,000.260,923,30 Rp Rp9.54)( ( -000.00)Rp713,050, )( 8.05Rp9,033,17 ( - 00.00,500,000,019,786,162 Rp .

xSy

58

,700.0098,256,528Rp10,856,2 . xSy

7.00556,147,04Rp187,177, . xSy

84.90Rp13,681,2 . xSy

Page 98: Statistika Excel

X2 Y2 Rp 284,089,000,000.00 Rp 20,250,000,000,000.00 Rp 44,944,000,000.00 Rp 42,250,000,000,000.00 Rp 942,841,000,000.00 Rp 7,290,000,000,000.00 Rp 497,025,000,000.00 Rp 40,960,000,000,000.00 Rp 490,000,000,000.00 Rp 948,640,000,000,000.00 Rp 99,225,000,000.00 Rp 324,000,000,000,000.00 Rp 525,625,000,000.00 Rp 1,936,000,000,000,000.00 Rp 62,500,000,000.00 Rp 1,849,000,000,000,000.00 Rp 360,000,000,000.00 Rp 2,304,000,000,000,000.00 Rp 108,900,000,000.00 Rp 4,624,000,000,000,000.00 Rp 62,500,000,000.00 Rp 576,000,000,000,000.00 Rp 40,000,000,000.00 Rp 1,600,000,000,000,000.00 Rp 5,184,000,000.00 Rp 6,250,000,000,000.00 Rp 2,916,000,000.00 Rp 25,000,000,000,000.00 Rp 138,384,000,000.00 Rp 30,250,000,000,000.00 Rp 5,184,000,000.00 Rp 10,890,000,000,000.00 Rp 97,969,000,000.00 Rp 9,000,000,000,000.00 Rp 1,296,000,000.00 Rp 4,840,000,000,000.00 Rp 250,000,000,000.00 Rp 30,250,000,000,000.00 Rp 2,500,000,000.00 Rp 12,250,000,000,000.00 Rp 1,600,000,000.00 Rp 56,250,000,000,000.00 Rp 160,000,000,000.00 Rp 625,000,000,000,000.00 Rp 360,000,000,000.00 Rp 961,000,000,000,000.00 Rp 409,600,000,000.00 Rp 20,250,000,000,000.00 Rp 1,600,000,000.00 Rp 490,000,000,000.00 Rp 1,416,100,000,000.00 Rp 289,000,000,000,000.00 Rp 40,000,000,000.00 Rp 36,000,000,000,000.00 Rp 251,502,250,000.00 Rp 100,000,000,000,000.00 Rp 1,664,100,000,000.00 Rp 289,000,000,000,000.00 Rp 906,304,000,000.00 Rp 361,000,000,000,000.00 Rp 562,500,000,000.00 Rp 256,000,000,000,000.00 Rp 36,100,000,000.00 Rp 6,250,000,000,000.00 Rp 129,600,000,000.00 Rp 36,000,000,000,000.00 Rp 32,400,000,000.00 Rp 28,090,000,000,000.00 Rp 152,100,000,000.00 Rp 49,000,000,000,000.00 Rp 250,000,000,000.00 Rp 9,302,500,000,000.00 Rp 490,000,000,000.00 Rp 64,000,000,000,000.00 Rp 40,000,000,000.00 Rp 24,010,000,000,000.00 Rp 360,000,000,000.00 Rp 64,000,000,000,000.00 Rp 409,600,000,000.00 Rp 25,000,000,000,000.00 Rp 12,100,000,000.00 Rp 100,000,000,000,000.00 Rp 3,136,000,000.00 Rp 7,840,000,000,000.00 Rp 1,156,000,000.00 Rp 8,410,000,000,000.00 Rp 576,000,000.00 Rp 6,760,000,000,000.00 Rp 14,400,000,000.00 Rp 784,000,000,000,000.00

Page 99: Statistika Excel

Rp 1,162,084,000,000.00 Rp 30,250,000,000,000.00 Rp 459,684,000,000.00 Rp 225,000,000,000,000.00 Rp 784,000,000.00 Rp 6,250,000,000,000.00 Rp 4,489,000,000.00 Rp 56,250,000,000,000.00 Rp 3,136,000,000.00 Rp 30,250,000,000,000.00 Rp 10,000,000,000.00 Rp 6,250,000,000,000.00 Rp 443,556,000,000.00 Rp 676,000,000,000,000.00 Rp 7,921,000,000.00 Rp 9,000,000,000,000.00 Rp 6,561,000,000.00 Rp 10,890,000,000,000.00 Rp 9,216,000,000.00 Rp 7,290,000,000,000.00 Rp 4,900,000,000.00 Rp 12,250,000,000,000.00 Rp 25,921,000,000.00 Rp 42,250,000,000,000.00 Rp 127,449,000,000.00 Rp 42,250,000,000,000.00 Rp 6,084,000,000.00 Rp 15,210,000,000,000.00 Rp 1,156,000,000.00 Rp 9,000,000,000,000.00 Rp 13,998,497,250,000.00 Rp 19,786,162,500,000,000.00

60

)00.00Rp21,606,5 )(Rp11.70 (

60

0.00713,050,00 Rp a

bXaY

22 )( XXn

XYnb YX

60

).0029,630,000)(Rp3.18(

60

0.00713,050,00 Rp Rpa

60

4.40618,844,18 Rp a

69.74Rp10,314,0 a

Page 100: Statistika Excel

X2 Y2

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

22 ) 0.00713,050,00 Rp (),000.0062,500,000Rp19,786,1 (60(()).0021,606,500 (Rp).0097,250,000Rp13,998,4(60(

)000.00Rp713,050,)(.0021,606,500 Rp()0.00000,000,00Rp329,537,(60

r

) 379.00Rp823,850, ( ) 43.30Rp50,763,9 (

000.000,500,000,Rp8,193,26 r

,500.0093,927,239Rp41,821,8

000.000,500,000,Rp8,193,26 r

260

00)0,000,000.488,682,20 Rp )( Rp3.18 ( -) 0.00713,050,00 Rp )( 69.74Rp10,314,0 ( - ,000.0062,500,000Rp19,786,1 .

xSy

58

,000.0095,692,214Rp10,877,9 . xSy

Page 101: Statistika Excel

Rp 30,625,000,000.00 Rp 20,250,000,000,000.00 Rp 40,000,000,000.00 Rp 42,250,000,000,000.00 Rp 16,900,000,000.00 Rp 7,290,000,000,000.00 Rp 291,600,000,000.00 Rp 40,960,000,000,000.00 Rp 291,600,000,000.00 Rp 948,640,000,000,000.00 Rp 62,500,000,000.00 Rp 324,000,000,000,000.00 Rp 490,000,000,000.00 Rp 1,936,000,000,000,000.00 Rp 136,900,000,000.00 Rp 1,849,000,000,000,000.00 Rp 562,500,000,000.00 Rp 2,304,000,000,000,000.00 Rp 142,884,000,000.00 Rp 4,624,000,000,000,000.00 Rp 336,400,000,000.00 Rp 576,000,000,000,000.00 Rp 372,100,000,000.00 Rp 1,600,000,000,000,000.00 Rp 6,400,000,000.00 Rp 6,250,000,000,000.00 Rp 302,500,000,000.00 Rp 25,000,000,000,000.00 Rp 360,000,000,000.00 Rp 30,250,000,000,000.00 Rp 40,000,000,000.00 Rp 10,890,000,000,000.00 Rp 4,000,000,000,000.00 Rp 9,000,000,000,000.00 Rp 10,000,000,000.00 Rp 4,840,000,000,000.00 Rp 4,900,000,000.00 Rp 30,250,000,000,000.00 Rp 22,500,000,000.00 Rp 12,250,000,000,000.00 Rp 62,500,000,000.00 Rp 56,250,000,000,000.00 Rp 108,900,000,000.00 Rp 625,000,000,000,000.00 Rp 2,500,000,000.00 Rp 961,000,000,000,000.00 Rp 122,500,000,000.00 Rp 20,250,000,000,000.00 Rp 40,000,000,000.00 Rp 490,000,000,000.00 Rp 90,000,000,000.00 Rp 289,000,000,000,000.00 Rp 2,500,000,000.00 Rp 36,000,000,000,000.00 Rp 160,000,000,000.00 Rp 100,000,000,000,000.00 Rp 22,500,000,000.00 Rp 289,000,000,000,000.00 Rp 30,625,000,000.00 Rp 361,000,000,000,000.00 Rp 202,500,000,000.00 Rp 256,000,000,000,000.00 Rp 562,500,000,000.00 Rp 6,250,000,000,000.00 Rp 40,000,000,000.00 Rp 36,000,000,000,000.00 Rp 62,500,000,000.00 Rp 28,090,000,000,000.00 Rp 30,625,000,000.00 Rp 49,000,000,000,000.00 Rp 40,000,000,000.00 Rp 9,302,500,000,000.00 Rp 90,000,000,000.00 Rp 64,000,000,000,000.00 Rp 10,000,000,000.00 Rp 24,010,000,000,000.00 Rp 40,000,000,000.00 Rp 64,000,000,000,000.00 Rp 122,500,000,000.00 Rp 25,000,000,000,000.00 Rp 10,000,000,000.00 Rp 100,000,000,000,000.00 Rp 90,000,000,000.00 Rp 7,840,000,000,000.00 Rp 122,500,000,000.00 Rp 8,410,000,000,000.00 Rp 90,000,000,000.00 Rp 6,760,000,000,000.00 Rp 10,000,000,000.00 Rp 784,000,000,000,000.00 Rp 160,000,000,000.00 Rp 30,250,000,000,000.00 Rp 40,000,000,000.00 Rp 225,000,000,000,000.00 Rp 122,500,000,000.00 Rp 6,250,000,000,000.00

Page 102: Statistika Excel

Rp 90,000,000,000.00 Rp 56,250,000,000,000.00 Rp 160,000,000,000.00 Rp 30,250,000,000,000.00 Rp 10,000,000,000.00 Rp 6,250,000,000,000.00 Rp 40,000,000,000.00 Rp 676,000,000,000,000.00 Rp 30,625,000,000.00 Rp 9,000,000,000,000.00 Rp 3,025,000,000.00 Rp 10,890,000,000,000.00 Rp 7,921,000,000.00 Rp 7,290,000,000,000.00 Rp 2,025,000,000.00 Rp 12,250,000,000,000.00 Rp 3,025,000,000.00 Rp 42,250,000,000,000.00 Rp 4,489,000,000.00 Rp 42,250,000,000,000.00 Rp 2,025,000,000.00 Rp 15,210,000,000,000.00 Rp 10,000,000,000.00 Rp 9,000,000,000,000.00 Rp 10,371,094,000,000.00 Rp 19,786,162,500,000,000.00

2) .0017,934,000 Rp () .0094,000,000Rp10,371,0 (60

) 000.00Rp713,050, )( .0017,934,000 Rp ()000,000,000.260,923,30 Rp(60

b

Page 103: Statistika Excel

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

22 ) 0.00713,050,00 Rp () 00.00,500,000,019,786,162 Rp (60()) .0017,934,000 Rp () .0094,000,000Rp10,371,0 (60(

) 0.00713,050,00 Rp )( .0017,934,000 Rp () 000,000,000.260,923,30 Rp (60

r

260

) 000,000,000.260,923,30 Rp Rp9.54)( ( -000.00)Rp713,050, )( 8.05Rp9,033,17 ( - 00.00,500,000,019,786,162 Rp .

xSy

Page 104: Statistika Excel

REGRESI BELANJA LAIN-LAINNAMA PENDAPATAN (Y) BELANJA LAIN-LAIN (X)

ZULKIFLI Rp 4,500,000.00 Rp 729,000.00 MAWAN Rp 6,500,000.00 Rp 604,000.00 RIAN Rp 2,700,000.00 Rp 300,000.00 FEBRI Rp 6,400,000.00 Rp 1,230,000.00 YANTO Rp 30,800,000.00 Rp 1,110,000.00 NAHWAN Rp 18,000,000.00 Rp 5,890,000.00 PAISAL Rp 44,000,000.00 Rp 855,000.00 AL SAFFAT GHAZALI Rp 43,000,000.00 Rp 65,000.00 SYAMSUL RIZAL Rp 48,000,000.00 Rp 1,400,000.00 NOVAL ARDIAN PRATAMA Rp 68,000,000.00 Rp 300,000.00 M.IQBAL Rp 24,000,000.00 Rp 20,000.00 FERDI MELSON R Rp 40,000,000.00 Rp 378,000.00 MARJUNI HARUN Rp 2,500,000.00 Rp 185,000.00 SUMIYO Rp 5,000,000.00 Rp 40,000.00 ISMET NUR HUSNI Rp 5,500,000.00 Rp 1,140,000.00 ADI CHANDRA Rp 3,300,000.00 Rp 420,000.00 SAHRI SANDI WINATA Rp 3,000,000.00 Rp 20,000.00 RUDI HARTONO Rp 2,200,000.00 Rp 20,000.00 IR.FIRMANSYAH Rp 5,500,000.00 Rp 260,000.00 EDI NELSON Rp 3,500,000.00 Rp 90,000.00 AMIR HUSIN Rp 7,500,000.00 Rp 320,000.00 FATIR RIZKI Rp 25,000,000.00 Rp 1,050,000.00 SARLAN PERKASA Rp 31,000,000.00 Rp 1,200,000.00 RUSDAN Rp 4,500,000.00 Rp 150,000.00 RUDI PERKASA Rp 700,000.00 Rp 170,000.00 S. HABNIN Rp 17,000,000.00 Rp 2,200,000.00 M. AKBAR Rp 6,000,000.00 Rp 2,062,000.00 Riduan Rp 10,000,000.00 Rp 540,000.00 RIO FEBRIANTO Rp 17,000,000.00 Rp 792,000.00 DANNY PRADANA Rp 19,000,000.00 Rp 305,000.00 SALAMAT PURBA Rp 16,000,000.00 Rp 150,000.00 PADRIZAL Rp 2,500,000.00 Rp 200,000.00 HAMIDIN SULISTHIO Rp 6,000,000.00 Rp 190,000.00 AZHARI BSC Rp 5,300,000.00 Rp 140,000.00 MARDIANTO Rp 7,000,000.00 Rp 140,000.00 LUKMAN ULHAKIM Rp 3,050,000.00 Rp 140,000.00 MUHAMAD TOHA ARAFAT,SE,A Rp 8,000,000.00 Rp 20,000.00 YAN ALBERTHO Rp 4,900,000.00 Rp 160,000.00 KMS.TAUFI OURRAHMAN,SH Rp 8,000,000.00 Rp 210,000.00 HERMAN Rp 5,000,000.00 Rp 117,000.00 DANIEL Rp 10,000,000.00 Rp 176,000.00 RICO HANIF Rp 2,800,000.00 Rp 178,000.00 BENI PRAKOSO Rp 2,900,000.00 Rp 111,000.00 SUSANTO Rp 2,600,000.00 Rp 100,000.00 ANDIAN Rp 28,000,000.00 Rp 156,000.00

Page 105: Statistika Excel

YOGI PUTRA Rp 5,500,000.00 Rp 243,000.00 DIDI SAPUTRA Rp 15,000,000.00 Rp 168,000.00 RUSLAN EFFENDI Rp 2,500,000.00 Rp 343,000.00 ISHAK HABIBI Rp 7,500,000.00 Rp 156,000.00 BOBBI Rp 5,500,000.00 Rp 176,000.00 VIVID ARDIANSYAH Rp 2,500,000.00 Rp 157,000.00 ARIANTO Rp 26,000,000.00 Rp 207,000.00 NURALI Rp 3,000,000.00 Rp 129,000.00 FEBRI WIJAYA Rp 3,300,000.00 Rp 161,000.00 BAGUS RAMAHNA Rp 2,700,000.00 Rp 277,000.00 RAHMAT PURWANTO Rp 3,500,000.00 Rp 144,000.00 ERWIN GUNAWAN Rp 6,500,000.00 Rp 44,000.00 H.SENEN Rp 6,500,000.00 Rp 286,000.00 ANDIKA KUSUMA Rp 3,900,000.00 Rp 958,000.00 DIDI KUSUMA WIJAYA Rp 3,000,000.00 Rp 148,000.00

N = 60 Rp 713,050,000.00 Rp 29,630,000.00

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

bXaY

22 )( XXn

XYnb YX

2) 00.00Rp29,630,0 () .0014,000,000Rp57,581,9 (60

) 0.00713,050,00 Rp )( .0029,630,000 Rp () 000,000,000.488,682,20 Rp (60

b

000.007,940,000,Rp2,576,97

000.000,500,000,Rp8,193,26 b

3.18 Rp b

n

b

n

na XY

60

).0029,630,000)(Rp3.18(

60

0.00713,050,00 Rp Rpa

60

4.40618,844,18 Rp a

69.74Rp10,314,0 a

Page 106: Statistika Excel

Sehingga persamaan persamaan regresi Y = Rp 10,314067.74 + 3.18 X

B. Koefisien Korelasi Regresi

C. Kesalahan Baku Estimasi (Standart error of estimate): mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

2 22 2

n XY X Yr

n X X n Y Y

22 ) 0.00713,050,00 Rp () ,000.0062,500,000Rp19,786,1 (60(()) 00.00Rp29,630,0 () .0014,000,000Rp57,581,9 (60(

)000.00Rp713,050,)( 00.00Rp29,630,0 () 000,000,000.488,682,20 Rp (60

r

) 379.00Rp823,850, ( ) 43.30Rp50,763,9 (

000.000,500,000,Rp8,193,26 r

,500.0093,927,239Rp41,821,8

000.000,500,000,Rp8,193,26 r

Rp0.20 r

2.

2

n

XYbYaYxSy

260

00)0,000,000.488,682,20 Rp )( Rp3.18 ( -) 0.00713,050,00 Rp )( 69.74Rp10,314,0 ( - ,000.0062,500,000Rp19,786,1 .

xSy

58

,000.0095,692,214Rp10,877,9 . xSy

8.00649,865,75Rp187,551, . xSy

49.80Rp13,694,9 . xSy

Page 107: Statistika Excel
Page 108: Statistika Excel
Page 109: Statistika Excel
Page 110: Statistika Excel

X.Y X2 Rp 3,280,500,000,000.00 Rp 531,441,000,000.00 Rp 3,926,000,000,000.00 Rp 364,816,000,000.00 Rp 810,000,000,000.00 Rp 90,000,000,000.00 Rp 7,872,000,000,000.00 Rp 1,512,900,000,000.00 Rp 34,188,000,000,000.00 Rp 1,232,100,000,000.00 Rp 106,020,000,000,000.00 Rp 34,692,100,000,000.00 Rp 37,620,000,000,000.00 Rp 731,025,000,000.00 Rp 2,795,000,000,000.00 Rp 4,225,000,000.00 Rp 67,200,000,000,000.00 Rp 1,960,000,000,000.00 Rp 20,400,000,000,000.00 Rp 90,000,000,000.00 Rp 480,000,000,000.00 Rp 400,000,000.00 Rp 15,120,000,000,000.00 Rp 142,884,000,000.00 Rp 462,500,000,000.00 Rp 34,225,000,000.00 Rp 200,000,000,000.00 Rp 1,600,000,000.00 Rp 6,270,000,000,000.00 Rp 1,299,600,000,000.00 Rp 1,386,000,000,000.00 Rp 176,400,000,000.00 Rp 60,000,000,000.00 Rp 400,000,000.00 Rp 44,000,000,000.00 Rp 400,000,000.00 Rp 1,430,000,000,000.00 Rp 67,600,000,000.00 Rp 315,000,000,000.00 Rp 8,100,000,000.00 Rp 2,400,000,000,000.00 Rp 102,400,000,000.00 Rp 26,250,000,000,000.00 Rp 1,102,500,000,000.00 Rp 37,200,000,000,000.00 Rp 1,440,000,000,000.00 Rp 675,000,000,000.00 Rp 22,500,000,000.00 Rp 119,000,000,000.00 Rp 28,900,000,000.00 Rp 37,400,000,000,000.00 Rp 4,840,000,000,000.00 Rp 12,372,000,000,000.00 Rp 4,251,844,000,000.00 Rp 5,400,000,000,000.00 Rp 291,600,000,000.00 Rp 13,464,000,000,000.00 Rp 627,264,000,000.00 Rp 5,795,000,000,000.00 Rp 93,025,000,000.00 Rp 2,400,000,000,000.00 Rp 22,500,000,000.00 Rp 500,000,000,000.00 Rp 40,000,000,000.00 Rp 1,140,000,000,000.00 Rp 36,100,000,000.00 Rp 742,000,000,000.00 Rp 19,600,000,000.00 Rp 980,000,000,000.00 Rp 19,600,000,000.00 Rp 427,000,000,000.00 Rp 19,600,000,000.00 Rp 160,000,000,000.00 Rp 400,000,000.00 Rp 784,000,000,000.00 Rp 25,600,000,000.00 Rp 1,680,000,000,000.00 Rp 44,100,000,000.00 Rp 585,000,000,000.00 Rp 13,689,000,000.00 Rp 1,760,000,000,000.00 Rp 30,976,000,000.00 Rp 498,400,000,000.00 Rp 31,684,000,000.00 Rp 321,900,000,000.00 Rp 12,321,000,000.00 Rp 260,000,000,000.00 Rp 10,000,000,000.00 Rp 4,368,000,000,000.00 Rp 24,336,000,000.00

Page 111: Statistika Excel

Rp 1,336,500,000,000.00 Rp 59,049,000,000.00 Rp 2,520,000,000,000.00 Rp 28,224,000,000.00 Rp 857,500,000,000.00 Rp 117,649,000,000.00 Rp 1,170,000,000,000.00 Rp 24,336,000,000.00 Rp 968,000,000,000.00 Rp 30,976,000,000.00 Rp 392,500,000,000.00 Rp 24,649,000,000.00 Rp 5,382,000,000,000.00 Rp 42,849,000,000.00 Rp 387,000,000,000.00 Rp 16,641,000,000.00 Rp 531,300,000,000.00 Rp 25,921,000,000.00 Rp 747,900,000,000.00 Rp 76,729,000,000.00 Rp 504,000,000,000.00 Rp 20,736,000,000.00 Rp 286,000,000,000.00 Rp 1,936,000,000.00 Rp 1,859,000,000,000.00 Rp 81,796,000,000.00 Rp 3,736,200,000,000.00 Rp 917,764,000,000.00 Rp 444,000,000,000.00 Rp 21,904,000,000.00 Rp 488,682,200,000,000.00 Rp 57,581,914,000,000.00

#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

Rp 50,763,943.30 #VALUE!

Rp 823,850,379.00 Rp 41,821,893,927,239,500.00

#VALUE!#VALUE!#VALUE!

Rp 13,694,949.80

A. Model regresi linier yang hanya melibatkan satu variabel bebas (X). Model regresinya sbb:

2) 00.00Rp29,630,0 () .0014,000,000Rp57,581,9 (60

) 0.00713,050,00 Rp )( .0029,630,000 Rp () 000,000,000.488,682,20 Rp (60

b

60

).0029,630,000)(Rp3.18(

60

0.00713,050,00 Rp Rpa

Page 112: Statistika Excel

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

22 ) 0.00713,050,00 Rp () ,000.0062,500,000Rp19,786,1 (60(()) 00.00Rp29,630,0 () .0014,000,000Rp57,581,9 (60(

)000.00Rp713,050,)( 00.00Rp29,630,0 () 000,000,000.488,682,20 Rp (60

r

260

00)0,000,000.488,682,20 Rp )( Rp3.18 ( -) 0.00713,050,00 Rp )( 69.74Rp10,314,0 ( - ,000.0062,500,000Rp19,786,1 .

xSy

Page 113: Statistika Excel
Page 114: Statistika Excel
Page 115: Statistika Excel
Page 116: Statistika Excel

Y2 Rp 20,250,000,000,000.00 Rp 42,250,000,000,000.00 Rp 7,290,000,000,000.00 Rp 40,960,000,000,000.00 Rp 948,640,000,000,000.00 Rp 324,000,000,000,000.00 Rp 1,936,000,000,000,000.00 Rp 1,849,000,000,000,000.00 Rp 2,304,000,000,000,000.00 Rp 4,624,000,000,000,000.00 Rp 576,000,000,000,000.00 Rp 1,600,000,000,000,000.00 Rp 6,250,000,000,000.00 Rp 25,000,000,000,000.00 Rp 30,250,000,000,000.00 Rp 10,890,000,000,000.00 Rp 9,000,000,000,000.00 Rp 4,840,000,000,000.00 Rp 30,250,000,000,000.00 Rp 12,250,000,000,000.00 Rp 56,250,000,000,000.00 Rp 625,000,000,000,000.00 Rp 961,000,000,000,000.00 Rp 20,250,000,000,000.00 Rp 490,000,000,000.00 Rp 289,000,000,000,000.00 Rp 36,000,000,000,000.00 Rp 100,000,000,000,000.00 Rp 289,000,000,000,000.00 Rp 361,000,000,000,000.00 Rp 256,000,000,000,000.00 Rp 6,250,000,000,000.00 Rp 36,000,000,000,000.00 Rp 28,090,000,000,000.00 Rp 49,000,000,000,000.00 Rp 9,302,500,000,000.00 Rp 64,000,000,000,000.00 Rp 24,010,000,000,000.00 Rp 64,000,000,000,000.00 Rp 25,000,000,000,000.00 Rp 100,000,000,000,000.00 Rp 7,840,000,000,000.00 Rp 8,410,000,000,000.00 Rp 6,760,000,000,000.00 Rp 784,000,000,000,000.00

Page 117: Statistika Excel

Rp 30,250,000,000,000.00 Rp 225,000,000,000,000.00 Rp 6,250,000,000,000.00 Rp 56,250,000,000,000.00 Rp 30,250,000,000,000.00 Rp 6,250,000,000,000.00 Rp 676,000,000,000,000.00 Rp 9,000,000,000,000.00 Rp 10,890,000,000,000.00 Rp 7,290,000,000,000.00 Rp 12,250,000,000,000.00 Rp 42,250,000,000,000.00 Rp 42,250,000,000,000.00 Rp 15,210,000,000,000.00 Rp 9,000,000,000,000.00 Rp 19,786,162,500,000,000.00

Page 118: Statistika Excel

mengukur besarnya penyimpangan nilai Y dengan nilai estimasi atau (Yr).

Page 119: Statistika Excel
Page 120: Statistika Excel
Page 121: Statistika Excel