{"id":643,"date":"2023-07-29T05:53:31","date_gmt":"2023-07-29T05:53:31","guid":{"rendered":"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/"},"modified":"2023-07-29T05:53:31","modified_gmt":"2023-07-29T05:53:31","slug":"cara-melakukan-tes-mann-whitney-u-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/","title":{"rendered":"Cara melakukan tes mann-whitney u di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Uji Mann-Whitney U<\/strong> (terkadang disebut uji jumlah peringkat Wilcoxon) digunakan untuk membandingkan perbedaan antara dua sampel ketika distribusi sampel tidak terdistribusi normal dan ukuran sampel kecil (n &lt;30).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini dianggap setara nonparametrik dari <a href=\"https:\/\/statorials.org\/id\/uji-dua-sampel-anda\/\" target=\"_blank\" rel=\"noopener\">uji t dua sampel<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukan tes Mann-Whitney U di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Tes Mann-Whitney U di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Peneliti ingin mengetahui apakah perlakuan bahan bakar menyebabkan perubahan rata-rata mpg mobil. Untuk mengujinya, mereka melakukan percobaan di mana mereka mengukur mpg dari 12 mobil dengan perawatan bahan bakar dan 12 mobil tanpa perawatan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena ukuran sampelnya kecil dan mereka menduga distribusi sampel tidak terdistribusi normal, mereka memutuskan untuk melakukan uji Mann-Whitney U untuk menentukan apakah ada perbedaan mpg yang signifikan secara statistik antara kedua kelompok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selesaikan langkah-langkah berikut untuk melakukan tes Mann-Whitney U di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Masukkan data sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6091 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mannwhitneyexcel1.png\" alt=\"Data dipecah menjadi dua kolom di Excel\" width=\"393\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung peringkat kedua grup.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menghitung rangking masing-masing grup. Gambar berikut menunjukkan rumus yang digunakan untuk menghitung peringkat nilai pertama dalam grup Diproses:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6093 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mannwhitneyexcel2.png\" alt=\"Rumus Uji Mann Whitney U di Excel\" width=\"670\" height=\"297\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Walaupun rumus ini cukup rumit, namun Anda hanya perlu memasukkannya satu kali saja. Kemudian Anda cukup menyeret rumus ke semua sel lain untuk mengisi baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6094 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mannwhitneyexcel3.png\" alt=\"Peringkat Tes Mann Whitney U di Excel\" width=\"462\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung nilai yang diperlukan untuk statistik uji.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan rumus berikut untuk menghitung jumlah peringkat setiap kelompok, ukuran sampel setiap kelompok, statistik uji U setiap kelompok, dan statistik uji U keseluruhan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6095 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mannwhitneyexcel4.png\" alt=\"Menghitung Tes Mann Whitney U di Excel\" width=\"595\" height=\"502\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung statistik uji-z dan nilai p yang sesuai.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan menggunakan rumus berikut untuk menghitung statistik uji-z dan <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">nilai p<\/a> yang sesuai untuk menentukan apakah kita harus menolak hipotesis nol atau tidak:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6096 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mannwhitneyexcel5.png\" alt=\"Mann Whitney U Uji Nilai-P di Excel\" width=\"606\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hipotesis nol dari pengujian tersebut menyatakan bahwa kedua kelompok memiliki rata-rata mpg yang sama. Karena nilai p uji ( <strong>0,20402387<\/strong> ) tidak kurang dari tingkat signifikansi kami sebesar 0,05, kami gagal menolak hipotesis nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami tidak memiliki cukup bukti untuk mengatakan bahwa rata-rata mpg sebenarnya berbeda antara kedua kelompok.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uji Mann-Whitney U (terkadang disebut uji jumlah peringkat Wilcoxon) digunakan untuk membandingkan perbedaan antara dua sampel ketika distribusi sampel tidak terdistribusi normal dan ukuran sampel kecil (n &lt;30). Ini dianggap setara nonparametrik dari uji t dua sampel . Tutorial ini menjelaskan cara melakukan tes Mann-Whitney U di Excel. Contoh: Tes Mann-Whitney U di Excel Peneliti [&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 Melakukan Tes Mann-Whitney U di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara melakukan tes Mann-Whitney U 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\/cara-melakukan-tes-mann-whitney-u-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Tes Mann-Whitney U di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara melakukan tes Mann-Whitney U di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T05:53:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mannwhitneyexcel1.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\/cara-melakukan-tes-mann-whitney-u-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/\",\"name\":\"Cara Melakukan Tes Mann-Whitney U di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T05:53:31+00:00\",\"dateModified\":\"2023-07-29T05:53:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara melakukan tes Mann-Whitney U di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan tes mann-whitney u 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 Melakukan Tes Mann-Whitney U di Excel - Statorials","description":"Penjelasan sederhana tentang cara melakukan tes Mann-Whitney U 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\/cara-melakukan-tes-mann-whitney-u-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Tes Mann-Whitney U di Excel - Statorials","og_description":"Penjelasan sederhana tentang cara melakukan tes Mann-Whitney U di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T05:53:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mannwhitneyexcel1.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\/cara-melakukan-tes-mann-whitney-u-di-excel\/","url":"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/","name":"Cara Melakukan Tes Mann-Whitney U di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T05:53:31+00:00","dateModified":"2023-07-29T05:53:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara melakukan tes Mann-Whitney U di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cara-melakukan-tes-mann-whitney-u-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan tes mann-whitney u 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\/643"}],"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=643"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/643\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}