{"id":1053,"date":"2023-07-27T20:22:41","date_gmt":"2023-07-27T20:22:41","guid":{"rendered":"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/"},"modified":"2023-07-27T20:22:41","modified_gmt":"2023-07-27T20:22:41","slug":"titik-korelasi-biserial-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/","title":{"rendered":"Cara menghitung korelasi titik-biserial di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Korelasi titik-biserial<\/strong> digunakan untuk mengukur hubungan antara variabel biner, x, dan variabel kontinu, y.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Mirip dengan<\/span> <a href=\"https:\/\/statorials.org\/id\/koefisien-korelasi-pearson-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">koefisien korelasi Pearson<\/a> <span style=\"color: #000000;\">, koefisien korelasi titik-biserial mengambil nilai antara -1 dan 1 dimana:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">-1 menunjukkan korelasi negatif sempurna antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\">0 menunjukkan tidak ada korelasi antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\">1 menunjukkan korelasi positif sempurna antara dua variabel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung korelasi titik-biserial antara dua variabel di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Korelasi titik-biserial di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai variabel biner berikut, x, dan variabel kontinu, y:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10848 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointbiexcel1.png\" alt=\"\" width=\"431\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung <strong>korelasi titik-biserial<\/strong> antara x dan y, kita cukup menggunakan fungsi <strong>=CORREL()<\/strong> sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10849 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointbiexcel2.png\" alt=\"Korelasi titik-biserial di Excel\" width=\"444\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Korelasi titik-biserial antara x dan y adalah <strong>0,218163<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena bilangan tersebut positif, hal ini menunjukkan bahwa ketika variabel x bernilai \u201c1\u201d, maka variabel y cenderung bernilai lebih tinggi dibandingkan jika variabel x bernilai \u201c0\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat dengan mudah memeriksanya dengan menghitung nilai rata-rata y ketika x adalah 0 dan ketika x adalah 1:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10850 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointbiexcel3.png\" alt=\"Contoh korelasi titik-biserial di excel\" width=\"535\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ketika x = 0, nilai rata-rata y adalah <strong>14,2<\/strong> . Jika x = 1, nilai rata-rata y adalah <strong>16,2<\/strong> . Hal ini menegaskan fakta bahwa korelasi point-biserial antara kedua variabel seharusnya positif.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggunakan rumus berikut untuk menghitung nilai p untuk koefisien korelasi ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10851 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointbiexcel4.png\" alt=\"Nilai P untuk korelasi titik-biserial di Excel\" width=\"576\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai pnya ternyata <strong>0,5193<\/strong> . Jadi, meskipun koefisien korelasi kedua variabel tersebut sedikit positif, namun ternyata korelasi tersebut tidak signifikan secara statistik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Korelasi Rank Spearman di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghitung korelasi parsial di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara mencari nilai P untuk koefisien korelasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Korelasi titik-biserial digunakan untuk mengukur hubungan antara variabel biner, x, dan variabel kontinu, y. Mirip dengan koefisien korelasi Pearson , koefisien korelasi titik-biserial mengambil nilai antara -1 dan 1 dimana: -1 menunjukkan korelasi negatif sempurna antara dua variabel 0 menunjukkan tidak ada korelasi antara dua variabel 1 menunjukkan korelasi positif sempurna antara dua variabel Tutorial [&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 menghitung korelasi titik-biserial di Excel<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung korelasi titik-biserial di Excel, beserta contohnya.\" \/>\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\/titik-korelasi-biserial-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung korelasi titik-biserial di Excel\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung korelasi titik-biserial di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T20:22:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointbiexcel1.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\/titik-korelasi-biserial-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/\",\"name\":\"Cara menghitung korelasi titik-biserial di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T20:22:41+00:00\",\"dateModified\":\"2023-07-27T20:22:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung korelasi titik-biserial di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung korelasi titik-biserial 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 menghitung korelasi titik-biserial di Excel","description":"Penjelasan sederhana cara menghitung korelasi titik-biserial di Excel, beserta contohnya.","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\/titik-korelasi-biserial-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung korelasi titik-biserial di Excel","og_description":"Penjelasan sederhana cara menghitung korelasi titik-biserial di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-27T20:22:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointbiexcel1.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\/titik-korelasi-biserial-unggul\/","url":"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/","name":"Cara menghitung korelasi titik-biserial di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T20:22:41+00:00","dateModified":"2023-07-27T20:22:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung korelasi titik-biserial di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung korelasi titik-biserial 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\/1053"}],"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=1053"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1053\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}