{"id":1072,"date":"2023-07-27T18:44:10","date_gmt":"2023-07-27T18:44:10","guid":{"rendered":"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/"},"modified":"2023-07-27T18:44:10","modified_gmt":"2023-07-27T18:44:10","slug":"korelasi-peringkat-spearman-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/","title":{"rendered":"Cara menghitung korelasi rank spearman di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, <strong>korelasi<\/strong> mengacu pada kekuatan dan arah hubungan antara dua variabel. Nilai koefisien korelasi dapat berkisar antara -1 hingga 1, dengan interpretasi sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>-1 :<\/strong> hubungan negatif sempurna antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>0:<\/strong> tidak ada hubungan antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1:<\/strong> hubungan positif sempurna antara dua variabel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jenis korelasi khusus disebut <strong>korelasi peringkat Spearman<\/strong> , yang digunakan untuk mengukur korelasi antara dua variabel peringkat. (misalnya, peringkat nilai ujian matematika siswa relatif terhadap peringkat nilai ujian sains di suatu kelas).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung korelasi peringkat Spearman antara dua variabel di Google Sheets.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Korelasi Peringkat Spearman di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Lakukan langkah-langkah berikut untuk menghitung korelasi rank spearman antara nilai ujian matematika dengan nilai ujian sains 10 siswa pada suatu kelas tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Masukkan hasil ujian setiap siswa dalam dua kolom terpisah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11009 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierfeuilles1.png\" alt=\"\" width=\"442\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung peringkat untuk setiap nilai ujian.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menghitung rangking setiap nilai ujian. Gunakan rumus berikut di sel D2 dan E2 untuk menghitung peringkat matematika dan sains siswa pertama:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Sel D2:<\/strong> =RANK.AVG(B2, $B$2:$B$11, 0)<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Sel E2:<\/strong> =RANK.AVG(C2, $C$2:$C$11, 0)<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11010 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierfeuilles2.png\" alt=\"\" width=\"540\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel yang tersisa untuk diisi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11011 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierfeuilles3.png\" alt=\"\" width=\"560\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik Ctrl+D untuk memasukkan peringkat setiap siswa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11012 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierfeuilles4.png\" alt=\"\" width=\"554\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung koefisien korelasi peringkat Spearman.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan menghitung koefisien korelasi peringkat Spearman antara nilai matematika dan nilai sains menggunakan fungsi <strong>CORREL()<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11013 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierfeuilles5.png\" alt=\"Korelasi Peringkat Spearman di Google Spreadsheet\" width=\"564\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Korelasi peringkat Spearman ternyata <strong>-0,41818<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4 (Opsional): Tentukan apakah korelasi peringkat Spearman signifikan secara statistik.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada langkah sebelumnya, kami menemukan bahwa korelasi peringkat Spearman antara nilai ujian matematika dan sains adalah <strong>-0,41818<\/strong> , yang menunjukkan korelasi negatif antara kedua variabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, untuk menentukan apakah korelasi ini signifikan secara statistik, kita perlu mengacu pada tabel korelasi nilai kritis peringkat Spearman, yang menunjukkan nilai kritis yang terkait dengan ukuran sampel (n) dan tingkat signifikansi (\u03b1) yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai absolut koefisien korelasi kita lebih besar dari nilai kritis pada tabel, maka korelasi kedua variabel tersebut signifikan secara statistik.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6207 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierexcel7-1.png\" alt=\"Tabel Korelasi Rank Spearman Nilai Kritis\" width=\"401\" height=\"526\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, ukuran sampel kita adalah n = 10 siswa. Dengan menggunakan tingkat signifikansi 0,05, kami menemukan bahwa nilai kritisnya adalah <strong>0,564<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena nilai absolut koefisien korelasi peringkat Spearman yang kami hitung ( <strong>0,41818<\/strong> ) tidak lebih besar dari nilai kritis ini, ini berarti korelasi antara nilai matematika dan sains tidak signifikan secara statistik.<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Terkait:<\/span><\/strong> <a href=\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Korelasi Rank Spearman di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, korelasi mengacu pada kekuatan dan arah hubungan antara dua variabel. Nilai koefisien korelasi dapat berkisar antara -1 hingga 1, dengan interpretasi sebagai berikut: -1 : hubungan negatif sempurna antara dua variabel 0: tidak ada hubungan antara dua variabel 1: hubungan positif sempurna antara dua variabel Jenis korelasi khusus disebut korelasi peringkat Spearman , [&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 Rank Spearman di Google Sheets<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung Korelasi Rank Spearman di Google Sheets, 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\/korelasi-peringkat-spearman-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Korelasi Rank Spearman di Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung Korelasi Rank Spearman di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T18:44:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierfeuilles1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/\",\"name\":\"Cara Menghitung Korelasi Rank Spearman di Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T18:44:10+00:00\",\"dateModified\":\"2023-07-27T18:44:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung Korelasi Rank Spearman di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung korelasi rank spearman di google sheets\"}]},{\"@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 Rank Spearman di Google Sheets","description":"Penjelasan sederhana cara menghitung Korelasi Rank Spearman di Google Sheets, 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\/korelasi-peringkat-spearman-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Korelasi Rank Spearman di Google Sheets","og_description":"Penjelasan sederhana cara menghitung Korelasi Rank Spearman di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T18:44:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lancierfeuilles1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/","url":"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/","name":"Cara Menghitung Korelasi Rank Spearman di Google Sheets","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T18:44:10+00:00","dateModified":"2023-07-27T18:44:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung Korelasi Rank Spearman di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung korelasi rank spearman di google sheets"}]},{"@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\/1072"}],"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=1072"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1072\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}