{"id":2148,"date":"2023-07-23T12:06:36","date_gmt":"2023-07-23T12:06:36","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/"},"modified":"2023-07-23T12:06:36","modified_gmt":"2023-07-23T12:06:36","slug":"excel-scatter-plot-beberapa-seri","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/","title":{"rendered":"Cara membuat scatter plot dengan beberapa seri di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat diagram sebar dengan beberapa rangkaian di Excel, mirip dengan bagan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-19897\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult6.png\" alt=\"Sebarkan plot dengan beberapa seri di Excel\" width=\"571\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini cukup mudah dilakukan di Excel dengan beberapa rumus sederhana. Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/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 (X, Y) berikut untuk empat grup berbeda: A, B, C, dan D.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19892 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult1.png\" alt=\"\" width=\"491\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Format datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sebelum kita dapat membuat plot sebar untuk memvisualisasikan koordinat (X,Y) setiap grup, pertama-tama kita perlu memformat data dengan cara tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita masukkan nilai unik setiap grup di baris atas, lalu masukkan rumus berikut di sel E2:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #3366ff;\">$A2<\/span> = <span style=\"color: #ff0000;\">H$1<\/span> , <span style=\"color: #800080;\">$C2<\/span> , NA())\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19893 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult2.png\" alt=\"\" width=\"567\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret rumus ini ke setiap sel di sebelah kanan sel E2. Kami kemudian akan menyeretnya ke setiap sel di bawah H2 hingga kami memperoleh hasil berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19894 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult3.png\" alt=\"\" width=\"567\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Buat titik cloud<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot setiap nilai di kolom <strong>B.<\/strong> Selanjutnya, tahan <strong>Ctrl<\/strong> dan sorot setiap sel dalam rentang <strong>E1:H17<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19895 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult4.png\" alt=\"\" width=\"606\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di pita atas, klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Sisipkan Plot Sebar (X,Y)<\/strong> di grup <strong>Grafik<\/strong> untuk menghasilkan plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19896 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult5.png\" alt=\"\" width=\"563\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Koordinat (X, Y) tiap grup ditampilkan, dan tiap grup memiliki warna unik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengubah warna, ukuran titik, dan label untuk membuat plot lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19897 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult6.png\" alt=\"\" width=\"571\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menjalankan fungsi umum lainnya dengan plot sebar di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis regresi ke scatterplot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat diagram sebar dengan beberapa rangkaian di Excel, mirip dengan bagan di bawah ini: Untungnya, hal ini cukup mudah dilakukan di Excel dengan beberapa rumus sederhana. Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan nilai (X, Y) berikut [&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 Scatter Plot dengan Beberapa Deret di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat scatterplot di Excel dengan beberapa rangkaian, termasuk 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\/excel-scatter-plot-beberapa-seri\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Scatter Plot dengan Beberapa Deret di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat scatterplot di Excel dengan beberapa rangkaian, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T12:06:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult6.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\/excel-scatter-plot-beberapa-seri\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\",\"name\":\"Cara Membuat Scatter Plot dengan Beberapa Deret di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T12:06:36+00:00\",\"dateModified\":\"2023-07-23T12:06:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat scatterplot di Excel dengan beberapa rangkaian, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat scatter plot dengan beberapa seri 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 Scatter Plot dengan Beberapa Deret di Excel - Statorials","description":"Tutorial ini menjelaskan cara membuat scatterplot di Excel dengan beberapa rangkaian, termasuk 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\/excel-scatter-plot-beberapa-seri\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Scatter Plot dengan Beberapa Deret di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara membuat scatterplot di Excel dengan beberapa rangkaian, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/","og_site_name":"Statorials","article_published_time":"2023-07-23T12:06:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dispersionmult6.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\/excel-scatter-plot-beberapa-seri\/","url":"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/","name":"Cara Membuat Scatter Plot dengan Beberapa Deret di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T12:06:36+00:00","dateModified":"2023-07-23T12:06:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat scatterplot di Excel dengan beberapa rangkaian, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat scatter plot dengan beberapa seri 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\/2148"}],"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=2148"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2148\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}