{"id":1537,"date":"2023-07-25T23:39:04","date_gmt":"2023-07-25T23:39:04","guid":{"rendered":"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/"},"modified":"2023-07-25T23:39:04","modified_gmt":"2023-07-25T23:39:04","slug":"koefisien-korelasi-intrakelas-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/","title":{"rendered":"Cara menghitung koefisien korelasi intrakelas di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas\/\" target=\"_blank\" rel=\"noopener\">Koefisien korelasi intrakelas<\/a> (ICC) digunakan untuk menentukan apakah item (atau topik) dapat dinilai secara andal oleh penilai yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai ICC dapat berkisar dari 0 hingga 1, dengan 0 menunjukkan tidak ada <a href=\"https:\/\/statorials.org\/id\/analisis-keandalan\/\" target=\"_blank\" rel=\"noopener\">reliabilitas<\/a> di antara penilai dan 1 menunjukkan reliabilitas sempurna.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah cara menghitung ICC di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan empat juri berbeda diminta untuk mengevaluasi kualitas 10 ujian masuk perguruan tinggi yang berbeda. Hasilnya ditunjukkan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15250 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iccexcel1.png\" alt=\"\" width=\"475\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Pasang ANOVA<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menghitung ICC untuk peringkat ini, pertama-tama kita perlu memasang <strong>Anova: Dua Faktor Tanpa Replikasi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, sorot sel A1:E11 sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15251 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iccexcel2.png\" alt=\"\" width=\"425\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik tab <strong>Data<\/strong> di pita atas, lalu klik opsi <strong>Analisis Data<\/strong> di bawah grup <b>Analisis<\/b> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-5292 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deuxsampexcel3.png\" alt=\"\" width=\"459\" height=\"175\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika opsi ini tidak tersedia, Anda harus <a href=\"https:\/\/statorials.org\/id\/cara-memuat-toolpak-analisis-di-excel\/\" target=\"_blank\" rel=\"noopener\">memuat Analysis ToolPak<\/a> terlebih dahulu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di menu drop-down yang muncul, klik <strong>Anova: Dua Faktor Tanpa Replikasi<\/strong> lalu klik <strong>OK<\/strong> . Pada jendela baru yang muncul, berikan informasi berikut lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15252 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iccexcel3.png\" alt=\"\" width=\"403\" height=\"445\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul hasil sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15253 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iccexcel4.png\" alt=\"\" width=\"518\" height=\"477\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung koefisien korelasi intrakelas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung ICC di antara penilai:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15254 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iccexcel5.png\" alt=\"Koefisien Korelasi Intrakelas di Excel\" width=\"587\" height=\"570\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Koefisien korelasi intrakelas (ICC) ditemukan sebesar <strong>0,782<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara mengartikan nilai koefisien korelasi intrakelas menurut <a href=\"https:\/\/pubmed.ncbi.nlm.nih.gov\/27330520\/\" target=\"_blank\" rel=\"noopener\">Koo &amp; Li<\/a> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Kurang dari 0,50:<\/strong> keandalan buruk<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Antara 0,5 dan 0,75:<\/strong> Keandalan sedang<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Antara 0,75 dan 0,9:<\/strong> Keandalan yang baik<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Lebih besar dari 0,9:<\/strong> Keandalan luar biasa<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Oleh karena itu, kita dapat menyimpulkan bahwa ICC sebesar <strong>0,782<\/strong> menunjukkan bahwa ujian dapat dinilai dengan reliabilitas \u201cbaik\u201d oleh penilai yang berbeda.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Catatan tentang penghitungan ICC<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ada beberapa versi berbeda dari ICC yang dapat dihitung, bergantung pada tiga faktor berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Model:<\/strong> efek acak satu arah, efek acak dua arah, atau efek campuran dua arah<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jenis hubungan:<\/strong> konsistensi atau kesepakatan mutlak<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Unit:<\/strong> penilai tunggal atau rata-rata penilai<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Pada contoh sebelumnya, ICC yang kami hitung menggunakan asumsi berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Model:<\/strong> efek acak dua arah<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jenis hubungan:<\/strong> Kesepakatan mutlak<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Satuan :<\/strong> Asesor Tunggal<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk penjelasan rinci mengenai asumsi tersebut, silakan merujuk ke <a href=\"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas\/\" target=\"_blank\" rel=\"noopener\">artikel ini<\/a> .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Koefisien korelasi intrakelas (ICC) digunakan untuk menentukan apakah item (atau topik) dapat dinilai secara andal oleh penilai yang berbeda. Nilai ICC dapat berkisar dari 0 hingga 1, dengan 0 menunjukkan tidak ada reliabilitas di antara penilai dan 1 menunjukkan reliabilitas sempurna. Tutorial ini memberikan contoh langkah demi langkah cara menghitung ICC di Excel. Langkah 1: [&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 Koefisien Korelasi Intrakelas di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung koefisien korelasi intrakelas 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\/koefisien-korelasi-intrakelas-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Koefisien Korelasi Intrakelas di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung koefisien korelasi intrakelas di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T23:39:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iccexcel1.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\/koefisien-korelasi-intrakelas-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/\",\"name\":\"Cara Menghitung Koefisien Korelasi Intrakelas di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T23:39:04+00:00\",\"dateModified\":\"2023-07-25T23:39:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung koefisien korelasi intrakelas di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung koefisien korelasi intrakelas 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 Koefisien Korelasi Intrakelas di Excel","description":"Tutorial ini menjelaskan cara menghitung koefisien korelasi intrakelas 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\/koefisien-korelasi-intrakelas-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Koefisien Korelasi Intrakelas di Excel","og_description":"Tutorial ini menjelaskan cara menghitung koefisien korelasi intrakelas di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-25T23:39:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iccexcel1.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\/koefisien-korelasi-intrakelas-unggul\/","url":"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/","name":"Cara Menghitung Koefisien Korelasi Intrakelas di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T23:39:04+00:00","dateModified":"2023-07-25T23:39:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung koefisien korelasi intrakelas di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/koefisien-korelasi-intrakelas-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung koefisien korelasi intrakelas 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\/1537"}],"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=1537"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1537\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}