{"id":1882,"date":"2023-07-24T14:53:56","date_gmt":"2023-07-24T14:53:56","guid":{"rendered":"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/"},"modified":"2023-07-24T14:53:56","modified_gmt":"2023-07-24T14:53:56","slug":"mode-excel-rata-rata-median","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/","title":{"rendered":"Cara mencari mean, median &amp; modus di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk mencari mean, median, dan modus kumpulan data di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #3366ff;\">A1:A10<\/span> )\n\n=MEDIAN( <span style=\"color: #3366ff;\">A1:A10<\/span> ) \n\n=MODE.MULT( <span style=\"color: #3366ff;\">A1:A10<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perlu dicatat bahwa masing-masing rumus ini akan mengabaikan nilai non-numerik atau kosong saat menghitung pengukuran ini untuk rentang sel di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan rumus ini dalam praktik dengan kumpulan data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18031 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenmedmode1.png\" alt=\"\" width=\"540\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: mencari rata-rata di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><strong>Mean<\/strong> mewakili nilai rata-rata dalam sekumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menghitung rata-rata kumpulan data di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18032 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenmedmode2.png\" alt=\"\" width=\"540\" height=\"494\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-ratanya adalah <strong>19:11<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Mencari Median di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><strong>Median<\/strong> mewakili nilai tengah suatu kumpulan data, ketika semua nilai diurutkan dari terkecil hingga terbesar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menghitung median kumpulan data di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18033 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenmedmode3.png\" alt=\"\" width=\"547\" height=\"524\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Mediannya ternyata <strong>20<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Temukan Mode di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><strong>Modus<\/strong> mewakili nilai yang paling sering muncul dalam kumpulan data. Perhatikan bahwa kumpulan data tidak boleh memiliki mode, mode tunggal, atau beberapa mode.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menghitung mode kumpulan data di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18034 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenmedmode4.png\" alt=\"\" width=\"560\" height=\"528\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Modenya menjadi <strong>7<\/strong> dan <strong>25<\/strong> . Masing-masing nilai ini muncul dua kali dalam kumpulan data, yang lebih sering terjadi dibandingkan nilai lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan:<\/strong> Jika Anda menggunakan fungsi <strong>=MODE()<\/strong> , ini hanya akan mengembalikan mode pertama. Untuk kumpulan data ini, hanya nilai 7 yang akan dikembalikan. Oleh karena itu, sebaiknya gunakan fungsi <strong>=MODE.MULT()<\/strong> jika terdapat lebih dari satu mode dalam kumpulan data.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Midrange di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Standar Deviasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk mencari mean, median, dan modus kumpulan data di Excel: =AVERAGE( A1:A10 ) =MEDIAN( A1:A10 ) =MODE.MULT( A1:A10 ) Perlu dicatat bahwa masing-masing rumus ini akan mengabaikan nilai non-numerik atau kosong saat menghitung pengukuran ini untuk rentang sel di Excel. Contoh berikut memperlihatkan cara menggunakan rumus ini dalam praktik dengan [&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 Mencari Mean, Median, dan Modus di Excel (Dengan Contoh)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari mean, median, dan modus suatu kumpulan data di Excel, 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\/mode-excel-rata-rata-median\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mencari Mean, Median, dan Modus di Excel (Dengan Contoh)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari mean, median, dan modus suatu kumpulan data di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T14:53:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenmedmode1.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\/mode-excel-rata-rata-median\/\",\"url\":\"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/\",\"name\":\"Cara Mencari Mean, Median, dan Modus di Excel (Dengan Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T14:53:56+00:00\",\"dateModified\":\"2023-07-24T14:53:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari mean, median, dan modus suatu kumpulan data di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencari mean, median &amp; modus di excel (dengan contoh)\"}]},{\"@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 Mencari Mean, Median, dan Modus di Excel (Dengan Contoh)","description":"Tutorial ini menjelaskan cara mencari mean, median, dan modus suatu kumpulan data di Excel, 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\/mode-excel-rata-rata-median\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mencari Mean, Median, dan Modus di Excel (Dengan Contoh)","og_description":"Tutorial ini menjelaskan cara mencari mean, median, dan modus suatu kumpulan data di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/","og_site_name":"Statorials","article_published_time":"2023-07-24T14:53:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenmedmode1.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\/mode-excel-rata-rata-median\/","url":"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/","name":"Cara Mencari Mean, Median, dan Modus di Excel (Dengan Contoh)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T14:53:56+00:00","dateModified":"2023-07-24T14:53:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari mean, median, dan modus suatu kumpulan data di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencari mean, median &amp; modus di excel (dengan contoh)"}]},{"@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\/1882"}],"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=1882"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1882\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}