{"id":1515,"date":"2023-07-26T01:58:47","date_gmt":"2023-07-26T01:58:47","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/"},"modified":"2023-07-26T01:58:47","modified_gmt":"2023-07-26T01:58:47","slug":"bagan-pareto-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/","title":{"rendered":"Cara membuat bagan pareto di google spreadsheet (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan Pareto<\/strong> adalah jenis bagan yang menggunakan batang untuk menampilkan frekuensi kategori individual dan garis untuk menampilkan frekuensi kumulatif.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15022 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto1.png\" alt=\"Bagan Pareto di Google Spreadsheet\" width=\"587\" height=\"358\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah membuat diagram Pareto di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita buat kumpulan data palsu yang menunjukkan jumlah penjualan per produk untuk sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15023 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto2.png\" alt=\"\" width=\"428\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung frekuensi kumulatif<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan rumus berikut di sel C2 untuk menghitung frekuensi kumulatif:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUM( <span style=\"color: #ff9900;\">$B$2:B2<\/span> )\/SUM( <span style=\"color: #800080;\">$B$2:$B$7<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Salin rumus ini ke setiap sel di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15024 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto3.png\" alt=\"\" width=\"434\" height=\"397\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sisipkan bagan kombo<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot tiga kolom data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15025 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto4.png\" alt=\"\" width=\"431\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Bagan<\/strong> dari opsi tarik-turun. Ini secara otomatis akan memasukkan grafik gabungan berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15026 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto5.png\" alt=\"\" width=\"510\" height=\"359\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Tambahkan Sumbu Y Kanan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan pada salah satu bar pada grafik. Di menu tarik-turun yang muncul, klik <strong>Seri<\/strong> , lalu klik <strong>Kumulatif<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada menu yang muncul di sebelah kanan, pilih <strong>Sumbu Kanan<\/strong> di bawah daftar drop-down <strong>Sumbu<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15027 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto6.png\" alt=\"\" width=\"295\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini secara otomatis akan menambahkan sumbu Y lainnya ke sisi kanan grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15028 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto7.png\" alt=\"\" width=\"449\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan Pareto sekarang sudah selesai. Bilah biru menunjukkan penjualan individual setiap produk dan garis merah menunjukkan penjualan kumulatif produk.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan Pareto adalah jenis bagan yang menggunakan batang untuk menampilkan frekuensi kategori individual dan garis untuk menampilkan frekuensi kumulatif. Tutorial ini memberikan contoh langkah demi langkah membuat diagram Pareto di Google Spreadsheet. Langkah 1: Buat datanya Pertama, mari kita buat kumpulan data palsu yang menunjukkan jumlah penjualan per produk untuk sebuah perusahaan: Langkah 2: Hitung [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat Bagan Pareto di Google Spreadsheet (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram Pareto di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bagan Pareto di Google Spreadsheet (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram Pareto di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T01:58:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\",\"name\":\"Cara Membuat Bagan Pareto di Google Spreadsheet (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T01:58:47+00:00\",\"dateModified\":\"2023-07-26T01:58:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram Pareto di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan pareto di google spreadsheet (langkah demi langkah)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membuat Bagan Pareto di Google Spreadsheet (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara membuat diagram Pareto di Google Sheets, dengan contoh langkah demi langkah.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Pareto di Google Spreadsheet (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara membuat diagram Pareto di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-26T01:58:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pareto1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/","url":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/","name":"Cara Membuat Bagan Pareto di Google Spreadsheet (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T01:58:47+00:00","dateModified":"2023-07-26T01:58:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram Pareto di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan pareto di google spreadsheet (langkah demi langkah)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1515"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=1515"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1515\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}