{"id":4000,"date":"2023-07-14T06:10:25","date_gmt":"2023-07-14T06:10:25","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/"},"modified":"2023-07-14T06:10:25","modified_gmt":"2023-07-14T06:10:25","slug":"grafik-korelasi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/","title":{"rendered":"Cara membuat bagan korelasi di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat bagan di Excel yang memungkinkan Anda memvisualisasikan <a href=\"https:\/\/statorials.org\/id\/koefisien-korelasi-pearson-1\/\" target=\"_blank\" rel=\"noopener\">korelasi<\/a> antara dua variabel.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan korelasi jenis ini di Excel.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Buat datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data dengan dua variabel di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31998 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph1.jpg\" alt=\"\" width=\"441\" height=\"468\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat diagram sebar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A2:B21<\/strong> .<\/span><\/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> dan klik opsi pertama untuk membuat plot sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13892 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg2.png\" alt=\"\" width=\"455\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31999 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph2.jpg\" alt=\"\" width=\"659\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan koefisien korelasi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung koefisien korelasi kedua variabel, ketikkan rumus berikut pada sel <strong>A23<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=CORREL( <span style=\"color: #3366ff;\">A2:A21<\/span> , <span style=\"color: #ff0000;\">B2:B21<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32001 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph4.jpg\" alt=\"\" width=\"411\" height=\"501\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Koefisien korelasi kedua variabel ini sebesar <strong>0,9835<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan nilai ini pada judul plot sebar jika Anda ingin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32002\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph5.jpg\" alt=\"grafik korelasi di Excel\" width=\"543\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa korelasi antara dua variabel bisa antara -1 dan 1 dimana:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>-1<\/strong> menunjukkan korelasi linier negatif sempurna<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>0<\/strong> menunjukkan tidak ada korelasi linier<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> menunjukkan korelasi linier positif sempurna<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, korelasi sebesar <strong>0,9835<\/strong> menunjukkan korelasi positif yang kuat antara kedua variabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini sesuai dengan pola yang kita lihat di diagram sebar: seiring dengan meningkatnya nilai x, nilai y juga meningkat dengan cara yang sangat dapat diprediksi.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\" target=\"_blank\" rel=\"noopener\">Apa yang dianggap sebagai korelasi \u201ckuat\u201d?<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\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\/plot-sebar-matriks-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Matriks Scatterplot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/label-plot-sebar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Label ke Scatterplot Point 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><br \/> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat bagan di Excel yang memungkinkan Anda memvisualisasikan korelasi antara dua variabel. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan korelasi jenis ini di Excel. Langkah 1: Buat datanya Pertama, mari buat kumpulan data dengan dua variabel di Excel: Langkah 2: Buat diagram sebar Selanjutnya, sorot rentang sel [&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 Korelasi di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik korelasi 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-korelasi-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 Korelasi di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik korelasi di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T06:10:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph1.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\/grafik-korelasi-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/\",\"name\":\"Cara Membuat Bagan Korelasi di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T06:10:25+00:00\",\"dateModified\":\"2023-07-14T06:10:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik korelasi di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan korelasi 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 Bagan Korelasi di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membuat grafik korelasi 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-korelasi-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Korelasi di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat grafik korelasi di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-14T06:10:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph1.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\/grafik-korelasi-excel\/","url":"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/","name":"Cara Membuat Bagan Korelasi di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T06:10:25+00:00","dateModified":"2023-07-14T06:10:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik korelasi di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-korelasi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-korelasi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan korelasi 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\/4000"}],"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=4000"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4000\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}