{"id":1644,"date":"2023-07-25T13:16:19","date_gmt":"2023-07-25T13:16:19","guid":{"rendered":"https:\/\/statorials.org\/id\/cramers-v-di-excel\/"},"modified":"2023-07-25T13:16:19","modified_gmt":"2023-07-25T13:16:19","slug":"cramers-v-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cramers-v-di-excel\/","title":{"rendered":"Cara menghitung v cramer di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Cramer&#8217;s V<\/strong> adalah ukuran kekuatan hubungan antara dua variabel nominal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Mulai dari 0 hingga 1 dimana:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>0<\/strong> menunjukkan tidak ada hubungan antara kedua variabel.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Angka 1<\/strong> menunjukkan hubungan yang kuat antara kedua variabel.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">V Cramer = \u221a <span style=\"border-top: 1px solid black;\">(X <sup>2<\/sup> \/n) \/ menit(c-1, r-1)<\/span><\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>X <sup>2<\/sup> :<\/strong> Statistik Chi kuadrat<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> ukuran sampel total<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>r:<\/strong> Jumlah baris<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>c:<\/strong> Jumlah kolom<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan dua contoh penghitungan Cramer&#8217;s V untuk tabel kontingensi di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Cramer&#8217;s V di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin memahami apakah ada hubungan antara dua metode persiapan ujian dan tingkat kelulusan siswa.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tabel berikut menunjukkan jumlah siswa yang lulus dan gagal dalam ujian, berdasarkan metode persiapan ujian yang digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16212 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cramerexcel2.png\" alt=\"\" width=\"455\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan rumus pasti yang dapat kita gunakan untuk menghitung V Cramer untuk tabel 2 \u00d7 2 yang berisi data untuk 36 siswa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16213 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cramerexcel3.png\" alt=\"V Cramer di Excel\" width=\"548\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">V Cramer ternyata <strong>0,1617<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan tabel berikut untuk menentukan apakah Cramer&#8217;s V harus dianggap sebagai ukuran efek kecil, sedang, atau besar tergantung pada derajat kebebasan yang digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16211 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cramerexcel1.png\" alt=\"\" width=\"310\" height=\"171\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, derajat kebebasannya sama dengan 1. Jadi, Cramer&#8217;s V sebesar 0,1617 akan dianggap sebagai ukuran efek yang kecil.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan kata lain, terdapat hubungan yang cukup lemah antara metode persiapan ujian yang digunakan dan tingkat keberhasilan siswa.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/cramer-v-di-sungai\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung V Cramer di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/cramers-v-dengan-python\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung V Cramer dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cramer&#8217;s V adalah ukuran kekuatan hubungan antara dua variabel nominal. Mulai dari 0 hingga 1 dimana: 0 menunjukkan tidak ada hubungan antara kedua variabel. Angka 1 menunjukkan hubungan yang kuat antara kedua variabel. Ini dihitung sebagai berikut: V Cramer = \u221a (X 2 \/n) \/ menit(c-1, r-1) Emas: X 2 : Statistik Chi kuadrat n: [&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 Cramer&#039;s V di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung Cramer&#039;s V di Excel, dengan beberapa contoh.\" \/>\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\/cramers-v-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung Cramer&#039;s V di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung Cramer&#039;s V di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cramers-v-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T13:16:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cramerexcel2.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\/cramers-v-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cramers-v-di-excel\/\",\"name\":\"Cara menghitung Cramer&#39;s V di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T13:16:19+00:00\",\"dateModified\":\"2023-07-25T13:16:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung Cramer&#39;s V di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cramers-v-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cramers-v-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cramers-v-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung v cramer 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 Cramer&#39;s V di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung Cramer&#39;s V di Excel, dengan beberapa contoh.","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\/cramers-v-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung Cramer&#39;s V di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung Cramer&#39;s V di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/cramers-v-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T13:16:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cramerexcel2.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\/cramers-v-di-excel\/","url":"https:\/\/statorials.org\/id\/cramers-v-di-excel\/","name":"Cara menghitung Cramer&#39;s V di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T13:16:19+00:00","dateModified":"2023-07-25T13:16:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung Cramer&#39;s V di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cramers-v-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cramers-v-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cramers-v-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung v cramer 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\/1644"}],"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=1644"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1644\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}