{"id":880,"date":"2023-07-28T11:05:51","date_gmt":"2023-07-28T11:05:51","guid":{"rendered":"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/"},"modified":"2023-07-28T11:05:51","modified_gmt":"2023-07-28T11:05:51","slug":"korelasi-nilai-p-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/","title":{"rendered":"Cara mencari nilai p untuk koefisien korelasi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Salah satu cara untuk mengukur hubungan antara dua variabel adalah dengan menggunakan <a href=\"https:\/\/statorials.org\/id\/koefisien-korelasi-pearson-1\/\" target=\"_blank\" rel=\"noopener\">koefisien korelasi Pearson<\/a> , yang merupakan ukuran hubungan linier antara dua variabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Itu selalu mengambil nilai antara -1 dan 1 di mana:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">-1 menunjukkan korelasi linier negatif sempurna antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\">0 menunjukkan tidak ada korelasi linier antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\">Angka 1 menunjukkan korelasi linier positif sempurna antara dua variabel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menentukan apakah koefisien korelasi signifikan secara statistik, Anda dapat menghitung skor-t dan nilai-p yang sesuai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung t-score suatu koefisien korelasi (r) adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>t<\/strong> = r\u221a(n-2) \/ \u221a(1-r <sup>2<\/sup> )<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai p dihitung sebagai nilai p dua sisi yang sesuai untuk distribusi t dengan n-2 derajat kebebasan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menghitung nilai p untuk koefisien korelasi di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Nilai P untuk koefisien korelasi di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Rumus berikut memperlihatkan cara menghitung nilai p untuk koefisien korelasi dan ukuran sampel tertentu di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9488\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pvaluecorrexcel1.png\" alt=\"Nilai P untuk koefisien korelasi di Excel\" width=\"569\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk koefisien korelasi r = 0,56 dan ukuran sampel n = 14, kita melihat bahwa:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Skor-T:<\/strong> 2,341478<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>nilai p:<\/strong> 0,037285<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ingatlah bahwa untuk uji korelasi kita memiliki hipotesis nol dan hipotesis alternatif berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Hipotesis nol (H <sub>0<\/sub> ):<\/strong> Korelasi kedua variabel adalah nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Hipotesis alternatif: (Ha):<\/strong> Korelasi kedua variabel <em>tidak<\/em> nol, misalnya terdapat korelasi yang signifikan secara statistik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita menggunakan tingkat signifikansi \u03b1 = 0,05, maka hipotesis nol dalam kasus ini akan ditolak karena <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">nilai p<\/a> (0,037285) kurang dari 0,05.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami menyimpulkan bahwa koefisien korelasi signifikan secara statistik.<\/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\/korelasi-bergulir-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Korelasi Bergulir 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\/korelasi-peringkat-spearman-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Korelasi Rank Spearman di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Salah satu cara untuk mengukur hubungan antara dua variabel adalah dengan menggunakan koefisien korelasi Pearson , yang merupakan ukuran hubungan linier antara dua variabel. Itu selalu mengambil nilai antara -1 dan 1 di mana: -1 menunjukkan korelasi linier negatif sempurna antara dua variabel 0 menunjukkan tidak ada korelasi linier antara dua variabel Angka 1 menunjukkan [&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 mencari nilai P koefisien korelasi di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara mencari nilai p untuk koefisien korelasi di Excel.\" \/>\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\/korelasi-nilai-p-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mencari nilai P koefisien korelasi di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara mencari nilai p untuk koefisien korelasi di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T11:05:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pvaluecorrexcel1.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\/korelasi-nilai-p-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/\",\"name\":\"Cara mencari nilai P koefisien korelasi di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T11:05:51+00:00\",\"dateModified\":\"2023-07-28T11:05:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara mencari nilai p untuk koefisien korelasi di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencari nilai p untuk koefisien korelasi 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 mencari nilai P koefisien korelasi di Excel - Statorials","description":"Penjelasan sederhana tentang cara mencari nilai p untuk koefisien korelasi di Excel.","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\/korelasi-nilai-p-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mencari nilai P koefisien korelasi di Excel - Statorials","og_description":"Penjelasan sederhana tentang cara mencari nilai p untuk koefisien korelasi di Excel.","og_url":"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T11:05:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pvaluecorrexcel1.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\/korelasi-nilai-p-unggul\/","url":"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/","name":"Cara mencari nilai P koefisien korelasi di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T11:05:51+00:00","dateModified":"2023-07-28T11:05:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara mencari nilai p untuk koefisien korelasi di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencari nilai p untuk koefisien korelasi 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\/880"}],"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=880"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/880\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}