{"id":2799,"date":"2023-07-20T15:51:05","date_gmt":"2023-07-20T15:51:05","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/"},"modified":"2023-07-20T15:51:05","modified_gmt":"2023-07-20T15:51:05","slug":"grafik-kuadran-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/","title":{"rendered":"Cara membuat bagan kuadran di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan kuadran<\/strong> adalah jenis bagan yang memungkinkan Anda memvisualisasikan titik-titik pada plot sebar di empat kuadran berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan kuadran berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24581\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel11.jpg\" alt=\"Bagan kuadran Excel\" width=\"554\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data nilai x dan y berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24571 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel1.jpg\" alt=\"\" width=\"458\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat diagram sebar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel dalam rentang <strong>A2:B9<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu klik opsi <strong>Sebar<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"515\" height=\"212\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Excel secara otomatis akan menyisipkan scatterplot berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24572 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel2.jpg\" alt=\"\" width=\"505\" height=\"353\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Buat Bagan Kuadran<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk mengubah plot sebar ini menjadi bagan kuadran, pertama-tama kita klik garis kisi horizontal dan vertikal, lalu hapus keduanya:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24573 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel3.jpg\" alt=\"\" width=\"518\" height=\"361\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita perlu menambahkan garis vertikal di tengah rentang sumbu x dan garis horizontal di tengah rentang sumbu y.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menghitung nilai <strong>garis horizontal<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>nilai x<\/strong> : Nilai min dan maks dari sumbu x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>nilai y<\/strong> : rata-rata nilai min dan maks sumbu y<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Berikut cara menghitung nilai <strong>garis vertikal<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>nilai x<\/strong> : Rata-rata nilai min dan maks sumbu x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>nilai y<\/strong> : nilai min dan maks dari sumbu y<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung nilai garis horizontal dan vertikal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24574 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel4.jpg\" alt=\"\" width=\"671\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada diagram sebar dan klik <strong>Pilih Data<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24575 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel5.jpg\" alt=\"\" width=\"505\" height=\"390\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Tambah<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24576 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel6.jpg\" alt=\"\" width=\"616\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, ketikkan nama yang Anda inginkan pada kotak Series Name, lalu pilih <strong>B12:B13<\/strong> pada kotak <strong>Series X Values<\/strong> , lalu ketikkan <strong>C12:C13<\/strong> pada kotak <strong>Series Y Values<\/strong> , lalu ketikkan klik <strong>oke<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24577 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel7.jpg\" alt=\"\" width=\"612\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dua titik oranye akan ditambahkan ke jalur. Klik salah satu titik untuk menampilkan panel <strong>Format Seri Data<\/strong> di sisi kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik ikon <strong>Garis<\/strong> , lalu klik <strong>Garis Berkelanjutan<\/strong> dan pilih Hitam sebagai <strong>warnanya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24578 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel8.jpg\" alt=\"\" width=\"274\" height=\"494\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik ikon <strong>Penanda<\/strong> , lalu klik <strong>Tidak Ada:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24579 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel9.jpg\" alt=\"\" width=\"304\" height=\"551\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis horizontal berikut secara otomatis akan ditambahkan ke grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24580 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel10.jpg\" alt=\"\" width=\"488\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses yang sama untuk menambahkan garis vertikal ke grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah grafik kuadran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24581\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel11.jpg\" alt=\"Bagan kuadran Excel\" width=\"554\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang ada empat kuadran berbeda dalam grafik dan setiap titik pada grafik termasuk dalam salah satu dari empat kuadran.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara membuat visualisasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Gantt Chart di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Donat Ganda di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan kuadran adalah jenis bagan yang memungkinkan Anda memvisualisasikan titik-titik pada plot sebar di empat kuadran berbeda. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan kuadran berikut di Excel: Langkah 1: Masukkan datanya Pertama, masukkan kumpulan data nilai x dan y berikut ke dalam Excel: Langkah 2: Buat diagram sebar Selanjutnya, sorot [&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 Kuadran di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat bagan kuadran 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\/grafik-kuadran-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 Kuadran di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat bagan kuadran di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T15:51:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel11.jpg\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/\",\"name\":\"Cara Membuat Bagan Kuadran di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T15:51:05+00:00\",\"dateModified\":\"2023-07-20T15:51:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat bagan kuadran di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan kuadran di excel (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 Kuadran di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara membuat bagan kuadran 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\/grafik-kuadran-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Kuadran di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat bagan kuadran di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T15:51:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quadrantexcel11.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/","url":"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/","name":"Cara Membuat Bagan Kuadran di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T15:51:05+00:00","dateModified":"2023-07-20T15:51:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat bagan kuadran di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-kuadran-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan kuadran di excel (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\/2799"}],"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=2799"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2799\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}