{"id":2687,"date":"2023-07-21T04:28:15","date_gmt":"2023-07-21T04:28:15","guid":{"rendered":"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/"},"modified":"2023-07-21T04:28:15","modified_gmt":"2023-07-21T04:28:15","slug":"berarti-mode-median-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/","title":{"rendered":"Cara menghitung mean, median &amp; mode di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk mencari mean, median, dan modus kumpulan data di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #ff6600;\">A1:A10<\/span> )\n\n=MEDIAN( <span style=\"color: #ff6600;\">A1:A10<\/span> ) \n\n=MODE.MULT( <span style=\"color: #ff6600;\">A1:A10<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Masing-masing rumus ini akan mengabaikan nilai non-numerik atau kosong saat menghitung metrik ini untuk rentang sel di Google Spreadsheet.<\/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-23653 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/meanmed1.jpg\" alt=\"\" width=\"469\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Menghitung rata-rata di Google Sheets<\/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 menunjukkan cara menghitung rata-rata kumpulan data di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23654 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/signifie-med2.jpg\" alt=\"\" width=\"465\" height=\"488\" 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: Menghitung Median di Google Sheets<\/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 menunjukkan cara menghitung median kumpulan data di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23655 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/meanmed3.jpg\" alt=\"\" width=\"464\" height=\"472\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Mediannya ternyata <strong>20<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: mode penghitungan di Google Sheets<\/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 menunjukkan cara menghitung mode kumpulan data di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23656 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/meanmed4.jpg\" alt=\"\" width=\"469\" height=\"483\" 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;\">Perhatikan bahwa jika Anda menggunakan fungsi <strong>=MODE()<\/strong> , ini hanya akan mengembalikan mode pertama. Untuk kumpulan data ini, hanya nilai 7 yang akan dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Inilah sebabnya mengapa sebaiknya menggunakan fungsi <strong>=MODE.MULT()<\/strong> jika ada lebih dari satu mode dalam kumpulan data.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menghitung metrik umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Kelas Menengah di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Deviasi Standar di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mencari mean, median, dan modus kumpulan data di Google Spreadsheet: =AVERAGE( A1:A10 ) =MEDIAN( A1:A10 ) =MODE.MULT( A1:A10 ) Catatan : Masing-masing rumus ini akan mengabaikan nilai non-numerik atau kosong saat menghitung metrik ini untuk rentang sel di Google Spreadsheet. Contoh berikut memperlihatkan cara menggunakan rumus ini dalam praktik [&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 Mean, Median, dan Mode di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung mean, median, dan mode di Google Sheets, 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\/berarti-mode-median-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Mean, Median, dan Mode di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung mean, median, dan mode di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T04:28:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/meanmed1.jpg\" \/>\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\/berarti-mode-median-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/\",\"name\":\"Cara Menghitung Mean, Median, dan Mode di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T04:28:15+00:00\",\"dateModified\":\"2023-07-21T04:28:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung mean, median, dan mode di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung mean, median &amp; mode di google sheets\"}]},{\"@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 Mean, Median, dan Mode di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung mean, median, dan mode di Google Sheets, 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\/berarti-mode-median-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Mean, Median, dan Mode di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung mean, median, dan mode di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-21T04:28:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/meanmed1.jpg"}],"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\/berarti-mode-median-google-sheet\/","url":"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/","name":"Cara Menghitung Mean, Median, dan Mode di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T04:28:15+00:00","dateModified":"2023-07-21T04:28:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung mean, median, dan mode di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung mean, median &amp; mode di google sheets"}]},{"@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\/2687"}],"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=2687"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2687\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}