{"id":1974,"date":"2023-07-24T06:00:32","date_gmt":"2023-07-24T06:00:32","guid":{"rendered":"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/"},"modified":"2023-07-24T06:00:32","modified_gmt":"2023-07-24T06:00:32","slug":"statistik-kontrol-proses-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/","title":{"rendered":"Cara membuat bagan kendali proses statistik di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan kendali proses statistik<\/strong> adalah jenis bagan yang digunakan untuk memvisualisasikan evolusi suatu proses dari waktu ke waktu dan untuk menentukan apakah suatu proses tetap berada dalam keadaan terkendali atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara membuat bagan kendali proses statistik di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai untuk data sampel kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18662 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spc1.png\" alt=\"\" width=\"462\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung rata-ratanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk menghitung nilai rata-rata dari dataset:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #3366ff;\">$A$2:$A$21<\/span> )\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18663 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spc2.png\" alt=\"\" width=\"494\" height=\"502\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung batas atas dan bawah<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita dapat menggunakan rumus berikut untuk menghitung batas atas dan bawah grafik:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#Upper limit calculation<\/span>\n= <span style=\"color: #3366ff;\">$B$2<\/span> +3*STDEV.S( <span style=\"color: #ff0000;\">$A$2:$A$21<\/span> )\n\n<span style=\"color: #008080;\">#Lower limit calculation<\/span>\n= <span style=\"color: #3366ff;\">$B$2<\/span> -3*STDEV.S( <span style=\"color: #ff0000;\">$A$2:$A$21<\/span> )\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18664 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spc3.png\" alt=\"\" width=\"509\" height=\"504\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Buat Bagan Kendali Proses Statistik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita bisa menyorot setiap nilai dalam rentang sel <strong>A1:D21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Sisipkan Bagan Garis<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tabel pengendalian proses statistik berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18665 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spc4.png\" alt=\"Bagan Kontrol Proses Statistik di Excel\" width=\"670\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan garis pada grafik:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Garis biru:<\/strong> Data mentah<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Garis oranye:<\/strong> Nilai rata-rata data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Garis abu-abu:<\/strong> batas atas proses<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Garis kuning:<\/strong> batas bawah proses<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Karena garis biru (data mentah) tidak pernah melewati batas atas atau bawah grafik, kita dapat mengatakan bahwa proses tetap terkendali sepanjang durasi pengumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam istilah yang lebih teknis, kita dapat mengatakan bahwa nilai data tidak pernah melebihi 3 standar deviasi di atas atau di bawah nilai rata-rata kumpulan data.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara membuat bagan umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menggambar-banyak-garis-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Ogive di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Kurva Lonceng di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan kendali proses statistik adalah jenis bagan yang digunakan untuk memvisualisasikan evolusi suatu proses dari waktu ke waktu dan untuk menentukan apakah suatu proses tetap berada dalam keadaan terkendali atau tidak. Contoh langkah demi langkah berikut ini memperlihatkan cara membuat bagan kendali proses statistik di Excel. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan [&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 Kendali Proses Statistik di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram kendali proses statistik di Excel, 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\/statistik-kontrol-proses-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bagan Kendali Proses Statistik di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram kendali proses statistik di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T06:00:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spc1.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\/statistik-kontrol-proses-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/\",\"name\":\"Cara Membuat Bagan Kendali Proses Statistik di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T06:00:32+00:00\",\"dateModified\":\"2023-07-24T06:00:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram kendali proses statistik di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan kendali proses statistik di excel\"}]},{\"@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 Kendali Proses Statistik di Excel - Statorials","description":"Tutorial ini menjelaskan cara membuat diagram kendali proses statistik di Excel, 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\/statistik-kontrol-proses-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Kendali Proses Statistik di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara membuat diagram kendali proses statistik di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-24T06:00:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spc1.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\/statistik-kontrol-proses-excel\/","url":"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/","name":"Cara Membuat Bagan Kendali Proses Statistik di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T06:00:32+00:00","dateModified":"2023-07-24T06:00:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram kendali proses statistik di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan kendali proses statistik di excel"}]},{"@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\/1974"}],"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=1974"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1974\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}