{"id":3082,"date":"2023-07-19T07:29:01","date_gmt":"2023-07-19T07:29:01","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/"},"modified":"2023-07-19T07:29:01","modified_gmt":"2023-07-19T07:29:01","slug":"plot-sebar-matriks-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/","title":{"rendered":"Cara membuat matriks scatterplot di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Matriks scatterplot<\/strong> adalah matriks scatterplot yang memungkinkan Anda memahami hubungan berpasangan antara variabel berbeda dalam suatu kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara membuat matriks scatterplot berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26375\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel6.jpg\" alt=\"matriks scatterplot di Excel\" width=\"659\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/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 berikut untuk kumpulan data yang berisi tiga variabel: poin, assist, dan rebound.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26370 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel1.jpg\" alt=\"\" width=\"466\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat titik awan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari kita sorot rentang sel <strong>A2:B9<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu klik tombol <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=\"550\" height=\"226\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Plot sebar poin versus assist berikut akan dibuat secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26371 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel2.jpg\" alt=\"\" width=\"630\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian, lakukan langkah-langkah berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik nilai pada sumbu x dan ubah batas minimum sumbu menjadi 80.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik pada sumbu Y dan ubah batas sumbu minimum menjadi 20.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik judul bagan dan hapus.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik kisi grafik dan hapus.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terakhir, ubah ukuran grafik menjadi lebih kecil.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Hasil akhirnya akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26372 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel3.jpg\" alt=\"\" width=\"595\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, ulangi langkah yang sama persis untuk variabel titik dan pantulan, lalu tempatkan diagram sebar di bawah diagram sebar yang ada:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26373 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel4.jpg\" alt=\"\" width=\"594\" height=\"520\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, ulangi langkah-langkah berikut untuk variabel assist dan rebound dan tempatkan plot pencar di sudut kanan bawah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26374 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel5.jpg\" alt=\"\" width=\"557\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Beri label pada plot sebar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, ketikkan nama variabel di sebelah diagram sebar sehingga mudah untuk memahami diagram sebar mana yang mewakili variabel mana:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26375\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel6.jpg\" alt=\"matriks scatterplot di Excel\" width=\"659\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan plotnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Plot sebar di sudut kiri atas mewakili hubungan antara poin dan assist.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Plot sebar di sudut kiri bawah mewakili hubungan antara poin dan rebound.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Plot pencar di pojok kanan bawah mewakili hubungan antara assist dan rebound.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jangan ragu untuk mengubah warna dan ukuran titik di plot sebar agar terlihat sesuai keinginan Anda.<\/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 melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Scatter Plot dengan Beberapa Seri di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/matriks-korelasi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Matriks Korelasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tes-korelasi-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan tes korelasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Matriks scatterplot adalah matriks scatterplot yang memungkinkan Anda memahami hubungan berpasangan antara variabel berbeda dalam suatu kumpulan data. Tutorial ini menjelaskan cara membuat matriks scatterplot berikut di Excel: Ayo pergi! Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan nilai berikut untuk kumpulan data yang berisi tiga variabel: poin, assist, dan rebound. Langkah 2: Buat [&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 Matriks Scatterplot di Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat matriks scatterplot di Excel, beserta contoh lengkapnya.\" \/>\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\/plot-sebar-matriks-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Matriks Scatterplot di Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat matriks scatterplot di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T07:29:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel6.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/\",\"name\":\"Cara Membuat Matriks Scatterplot di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T07:29:01+00:00\",\"dateModified\":\"2023-07-19T07:29:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat matriks scatterplot di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat matriks scatterplot di excel (dengan contoh)\"}]},{\"@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 Matriks Scatterplot di Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara membuat matriks scatterplot di Excel, beserta contoh lengkapnya.","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\/plot-sebar-matriks-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Matriks Scatterplot di Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara membuat matriks scatterplot di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T07:29:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matrice-de-dispersionexcel6.jpg"}],"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\/plot-sebar-matriks-excel\/","url":"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/","name":"Cara Membuat Matriks Scatterplot di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T07:29:01+00:00","dateModified":"2023-07-19T07:29:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat matriks scatterplot di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-sebar-matriks-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat matriks scatterplot di excel (dengan contoh)"}]},{"@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\/3082"}],"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=3082"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3082\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}