Data Penjualan [PDF]

Citation preview

Column1 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count



86,332,727 49,278,316 12,960,000 #N/A 163,437,685 26,711,876,881,818,200 3 2 464,360,000 1,140,000 465,500,000 949,660,000 11



Nama Produk Bata Merah Besi 10 Inchi Cat Dinding 5kg Genteng Biasa Kabel Listrik Kaca Keramik Pasir Semen Gersik Seng Triplek 5mm Total Result



Sum - Total Penjualan 24,120,000 6,720,000 8,140,000 465,500,000 1,140,000 360,270,000 10,950,000 28,000,000 29,100,000 2,760,000 12,960,000 949,660,000



ID Transaksi



Nama Marketing 1 Hamitz Nurul Alam 2 Hamitz Nurul Alam 6 Hamitz Nurul Alam 11 Hamitz Nurul Alam 17 Hamitz Nurul Alam 20 Hamitz Nurul Alam 25 Hamitz Nurul Alam 26 Hamitz Nurul Alam 29 Hamitz Nurul Alam 30 Hamitz Nurul Alam 35 Hamitz Nurul Alam 42 Hamitz Nurul Alam 46 Hamitz Nurul Alam 48 Hamitz Nurul Alam 55 Hamitz Nurul Alam 58 Hamitz Nurul Alam 61 Hamitz Nurul Alam 71 Hamitz Nurul Alam 72 Hamitz Nurul Alam 74 Hamitz Nurul Alam 80 Hamitz Nurul Alam 81 Hamitz Nurul Alam 87 Hamitz Nurul Alam 95 Hamitz Nurul Alam 3 Syafil Hafitz 8 Syafil Hafitz 13 Syafil Hafitz 18 Syafil Hafitz 22 Syafil Hafitz 27 Syafil Hafitz 37 Syafil Hafitz 41 Syafil Hafitz 50 Syafil Hafitz 63 Syafil Hafitz 73 Syafil Hafitz 76 Syafil Hafitz 83 Syafil Hafitz 89 Syafil Hafitz 97 Syafil Hafitz 4 Marsari Astuti 10 Marsari Astuti 15 Marsari Astuti 19 Marsari Astuti 28 Marsari Astuti



Tanggal No. Faktur 02/01/2017 Sales-01 04/01/2017 Sales-02 12/01/2017 Sales-06 22/01/2017 Sales-11 03/02/2017 Sales-17 09/02/2017 Sales-20 19/02/2017 Sales-25 21/02/2017 Sales-26 27/02/2017 Sales-29 01/03/2017 Sales-30 11/03/2017 Sales-35 25/03/2017 Sales-42 02/04/2017 Sales-46 06/04/2017 Sales-48 02/05/2017 22/05/2017 Sales-58 24/05/2017 Sales-61 22/05/2017 Sales-71 24/05/2017 Sales-72 28/05/2017 Sales-74 09/06/2017 Sales-80 11/06/2017 Sales-81 23/06/2017 Sales-87 09/07/2017 06/07/2017 Sales-03 16/01/2017 Sales-08 26/01/2017 Sales-13 05/02/2017 Sales-18 13/02/2017 Sales-22 23/02/2017 Sales-27 15/03/2017 Sales-37 23/03/2017 Sales-41 10/04/2017 Sales-50 06/05/2017 Sales-63 26/05/2017 Sales-73 01/06/2017 Sales-76 15/06/2017 Sales-83 27/06/2017 Sales-89 13/07/2017 Sales-97 08/01/2017 Sales-04 20/01/2017 Sales-10 30/01/2017 Sales-15 07/02/2017 25/02/2017 Sales-28



Nama Produk Jumlah Satuan Semen Gersik 10 Sak Pasir 5 Truk Engkel Besi 10 Inchi 10 Batang Triplek 5mm 10 Lembar Pasir 3 Truk Engkel Semen Gersik 50 Sak Kabel Listrik 20 Meter Semen Gersik 100 Sak Keramik 20 Boks Kabel Listrik 15 Meter Genteng Biasa 7500 Biji Pasir 4 Truk Engkel Keramik 20 Boks Besi 10 Inchi 20 Batang Genteng Biasa 8000 Biji Semen Gersik 20 Sak Pasir Truk Engkel Cat Dinding 5kg 20 Kaleng Genteng Biasa 2500 Biji Bata Merah 1000 Biji Cat Dinding 5kg 8 Kaleng Besi 10 Inchi Batang Bata Merah 1200 Biji Semen Gersik 9 Sak Bata Merah 1000 Biji Semen Gersik 5 Sak Genteng Biasa 12000 Biji Besi 10 Inchi 20 Batang Seng 10 Lembar Semen Gersik 30 Sak Cat Dinding 5kg 15 Kaleng Semen Gersik 65 Sak Semen Gersik 10 Sak Keramik 10 Boks Triplek 5mm 65 Lembar Kaca 8 Meter Semen Gersik 10 Sak Kabel Listrik 23 Meter Bata Merah 4500 Biji Keramik 10 Boks Genteng Biasa 5000 Biji Bata Merah 2000 Biji Bata Merah 5000 Biji Bata Merah 2000 Biji



32 Marsari Astuti 39 Marsari Astuti 52 Marsari Astuti 65 Marsari Astuti 66 Marsari Astuti 70 Marsari Astuti 78 Marsari Astuti 85 Marsari Astuti 91 Marsari Astuti 94 Marsari Astuti 99 Marsari Astuti 7 Kartika Siana 9 Kartika Siana 14 Kartika Siana 21 Kartika Siana 23 Kartika Siana 34 Kartika Siana 38 Kartika Siana 43 Kartika Siana 45 Kartika Siana 47 Kartika Siana 49 Kartika Siana 51 Kartika Siana 54 Kartika Siana 56 Kartika Siana 57 Kartika Siana 59 Kartika Siana 64 Kartika Siana 67 Kartika Siana 69 Kartika Siana 75 Kartika Siana 77 Kartika Siana 82 Kartika Siana 84 Kartika Siana 86 Kartika Siana 88 Kartika Siana 96 Kartika Siana 100 Kartika Siana 5 Fahmi Darmawan 33 Fahmi Darmawan 40 Fahmi Darmawan 44 Fahmi Darmawan 53 Fahmi Darmawan 60 Fahmi Darmawan 68 Fahmi Darmawan



05/03/2017 Sales-32 19/03/2017 Sales-39 14/04/2017 Sales-52 10/05/2017 Sales-65 12/05/2017 Sales-66 20/05/2017 Sales-70 05/06/2017 Sales-78 19/06/2017 Sales-85 01/07/2017 Sales-91 07/07/2017 Sales-94 17/07/2017 Sales-99 14/01/2017 Sales-07 18/01/2017 28/01/2017 Sales-14 11/02/2017 Sales-21 15/02/2017 Sales-23 09/03/2017 Sales-34 17/03/2017 Sales-38 27/03/2017 Sales-43 31/03/2017 Sales-45 04/04/2017 Sales-47 08/04/2017 Sales-49 12/04/2017 Sales-51 18/04/2017 Sales-54 22/04/2017 Sales-56 24/04/2017 Sales-57 28/04/2017 Sales-59 08/05/2017 Sales-64 14/05/2017 Sales-67 18/05/2017 Sales-69 30/05/2017 Sales-75 03/06/2017 Sales-77 13/06/2017 Sales-82 17/06/2017 Sales-84 21/06/2017 Sales-86 25/06/2017 Sales-88 11/07/2017 Sales-96 19/07/2017 Sales-100 10/01/2017 Sales-05 07/03/2017 Sales-33 21/03/2017 Sales-40 29/03/2017 Sales-44 16/04/2017 Sales-53 30/04/2017 Sales-60 16/05/2017 Sales-68



Kaca Triplek 5mm Genteng Biasa Triplek 5mm Semen Gersik Kabel Listrik Semen Gersik Genteng Biasa Cat Dinding 5kg Semen Gersik Kabel Listrik Pasir Keramik Triplek 5mm Triplek 5mm Genteng Biasa Keramik Kaca Besi 10 Inchi Bata Merah Seng Pasir Keramik Cat Dinding 5kg Triplek 5mm Bata Merah Pasir Genteng Biasa Semen Gersik Keramik Semen Gersik Besi 10 Inchi Pasir Keramik Triplek 5mm Keramik Semen Gersik Triplek 5mm Kabel Listrik Semen Gersik Bata Merah Semen Gersik Triplek 5mm Seng Bata Merah



10 Meter 12 Lembar 5000 Biji 9 Lembar 12 Sak 16 Meter 20 Sak 10000 Biji 19 Kaleng 18 Sak 30 Meter 2 Truk Engkel 5 Boks 5 Lembar 10 Lembar 9000 Biji 15 Boks 12000 Meter 15 Batang Biji 20 Lembar 5 Truk Engkel 16 Boks 12 Kaleng 18 Lembar 800 Biji 10 Truk Engkel 7500 Biji Sak 5 Boks 32 Sak 10 Batang 6 Truk Engkel 20 Boks 50 Lembar 25 Boks 7 Sak 100 Lembar 10 Meter 79 Sak 3000 Biji 55 Sak 9 Lembar 16 Lembar 2000 Biji



92 Fahmi Darmawan 93 Fahmi Darmawan



03/07/2017 Sales-92 05/07/2017 Sales-93



Besi 10 Inchi Pasir



50 Batang Truk Engkel



Harga 50,000 800,000 48,000 45,000 800,000 50,000 10,000 50,000 75,000 10,000 7,000 800,000 75,000 48,000 7,000 50,000 800,000 110,000 7,000 600 110,000 48,000 600 50,000 600 50,000 7,000 48,000 60,000 50,000 110,000 50,000 50,000 75,000 45,000 30,000 50,000 10,000 600 75,000 7,000 600 600 600



Total Penjualan 500,000 4,000,000 480,000 450,000 2,400,000 2,500,000 200,000 5,000,000 1,500,000 150,000 52,500,000 3,200,000 1,500,000 960,000 56,000,000 1,000,000 2,200,000 17,500,000 600,000 880,000 720,000 450,000 600,000 250,000 84,000,000 960,000 600,000 1,500,000 1,650,000 3,250,000 500,000 750,000 2,925,000 240,000 500,000 230,000 2,700,000 750,000 35,000,000 1,200,000 3,000,000 1,200,000



Marsuri Astuti



17



3,000 45,000 7,000 45,000 50,000 10,000 50,000 7,000 110,000 50,000 10,000 800,000 75,000 45,000 45,000 7,000 75,000 30,000 48,000 600 60,000 800,000 75,000 110,000 45,000 600 800,000 7,000 50,000 75,000 50,000 48,000 800,000 75,000 45,000 75,000 50,000 45,000 10,000 50,000 600 50,000 45,000 60,000 600



30,000 540,000 35,000,000 405,000 600,000 160,000 1,000,000 70,000,000 2,090,000 900,000 300,000 1,600,000 375,000 225,000 450,000 63,000,000 1,125,000 360,000,000 720,000 1,200,000 4,000,000 1,200,000 1,320,000 810,000 480,000 8,000,000 52,500,000 375,000 1,600,000 480,000 4,800,000 1,500,000 2,250,000 1,875,000 350,000 4,500,000 100,000 3,950,000 1,800,000 2,750,000 405,000 960,000 1,200,000



48,000 800,000



2,400,000 -