{"id":655,"date":"2023-07-29T04:58:58","date_gmt":"2023-07-29T04:58:58","guid":{"rendered":"https:\/\/statorials.org\/id\/cohens-d-unggul\/"},"modified":"2023-07-29T04:58:58","modified_gmt":"2023-07-29T04:58:58","slug":"cohens-d-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cohens-d-unggul\/","title":{"rendered":"Cara menghitung d cohen di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, ketika kita ingin menentukan ada atau tidaknya perbedaan yang signifikan antara dua kelompok, sering kali kita melakukan uji hipotesis yang menghasilkan <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">nilai p<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai p ini berada di bawah tingkat signifikansi tertentu (pilihan umum adalah 0,10, 0,05, dan 0,01), kami menyimpulkan bahwa terdapat perbedaan yang signifikan secara statistik antara kedua kelompok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, meskipun nilai p dapat memberi tahu kita apakah terdapat perbedaan yang signifikan secara statistik antara dua kelompok, <a href=\"https:\/\/statorials.org\/id\/ukuran-efek\/\" target=\"_blank\" rel=\"noopener noreferrer\">ukuran efek<\/a> dapat memberi tahu kita seberapa besar perbedaan tersebut sebenarnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Salah satu ukuran ukuran efek yang paling umum adalah <strong>Cohen&#8217;s d<\/strong> , yang dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cohen&#8217;s d = ( <span style=\"text-decoration: overline;\">x<\/span> <sub>1<\/sub> \u2013 <span style=\"text-decoration: overline;\">x<\/span> <sub>2<\/sub> ) \/ Gabungan SD<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><span style=\"text-decoration: overline;\">x<\/span> <sub>1<\/sub> = rata-rata kelompok 1<\/span><\/li>\n<li> <span style=\"color: #000000;\"><span style=\"text-decoration: overline;\">x<\/span> <sub>2<\/sub> = rata-rata kelompok 2<\/span><\/li>\n<li> <span style=\"color: #000000;\">SD yang dikelompokkan = \u221a <span style=\"border-top: 1px solid black;\">(s <sub>1<\/sub> <sup>2<\/sup> + s <sub>2<\/sub> <sup>2<\/sup> ) \/ 2<\/span><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung d Cohen di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cohen&#8217;s d di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selesaikan langkah-langkah berikut untuk menghitung Cohen&#8217;s d di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan nilai mean, deviasi standar, dan ukuran sampel (n) untuk dua kelompok.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6254 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohendexcel1.png\" alt=\"Ringkasan data di Excel\" width=\"384\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung selisih mean.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menghitung selisih rata-rata kelompok.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6255 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohendexcel2.png\" alt=\"Menghitung Selisih Rata-rata di Excel\" width=\"555\" height=\"292\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung simpangan baku gabungan.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menghitung simpangan baku gabungan.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15198 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohendexcel5.png\" alt=\"\" width=\"603\" height=\"280\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung Cohen d.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan menghitung d Cohen.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15199 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohendexcel6.png\" alt=\"D Cohen di Excel\" width=\"560\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">D Cohen ternyata <strong>0,29851<\/strong> untuk contoh ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Bagaimana menafsirkan Cohen d<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sebagai aturan umum, berikut cara menafsirkan d Cohen:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>0,2<\/strong> = Ukuran efek kecil<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>0,5<\/strong> = ukuran efek sedang<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>0,8<\/strong> = Ukuran efek besar<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, ukuran efek sebesar <strong>0,29851<\/strong> kemungkinan akan dianggap sebagai ukuran efek yang kecil.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya, meskipun perbedaan rata-rata kedua kelompok berbeda signifikan secara statistik, perbedaan sebenarnya antara rata-rata kedua kelompok tidaklah signifikan.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, ketika kita ingin menentukan ada atau tidaknya perbedaan yang signifikan antara dua kelompok, sering kali kita melakukan uji hipotesis yang menghasilkan nilai p . Jika nilai p ini berada di bawah tingkat signifikansi tertentu (pilihan umum adalah 0,10, 0,05, dan 0,01), kami menyimpulkan bahwa terdapat perbedaan yang signifikan secara statistik antara kedua kelompok. [&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 Cohen&#039;s d di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung Cohen&#039;s D di Excel, termasuk 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\/cohens-d-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung Cohen&#039;s d di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung Cohen&#039;s D di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cohens-d-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T04:58:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohendexcel1.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\/cohens-d-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/cohens-d-unggul\/\",\"name\":\"Cara menghitung Cohen&#39;s d di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T04:58:58+00:00\",\"dateModified\":\"2023-07-29T04:58:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung Cohen&#39;s D di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cohens-d-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cohens-d-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cohens-d-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung d cohen 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 Cohen&#39;s d di Excel \u2013 Statologi","description":"Penjelasan sederhana cara menghitung Cohen&#39;s D di Excel, termasuk 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\/cohens-d-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung Cohen&#39;s d di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara menghitung Cohen&#39;s D di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/cohens-d-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-29T04:58:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohendexcel1.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\/cohens-d-unggul\/","url":"https:\/\/statorials.org\/id\/cohens-d-unggul\/","name":"Cara menghitung Cohen&#39;s d di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T04:58:58+00:00","dateModified":"2023-07-29T04:58:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung Cohen&#39;s D di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cohens-d-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cohens-d-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cohens-d-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung d cohen 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\/655"}],"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=655"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/655\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}