{"id":4999,"date":"2023-07-05T08:31:31","date_gmt":"2023-07-05T08:31:31","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/"},"modified":"2023-07-05T08:31:31","modified_gmt":"2023-07-05T08:31:31","slug":"rata-rata-excel-vs-rata-rata","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/","title":{"rendered":"Excel: perbedaan antara fungsi average dan average"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Fungsi <strong>AVERAGE<\/strong> dan <strong>AVERAGE<\/strong> di Excel menghitung nilai rata-rata dalam suatu rentang, namun melakukannya sedikit berbeda:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>AVERAGE<\/strong> menghitung rata-rata semua <em>angka<\/em> dalam kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>AVERAGE<\/strong> menghitung rata-rata semua <em>nilai<\/em> dalam suatu kolom.<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Fungsi ini menghitung nilai <strong>TRUE<\/strong> dan <strong>FALSE<\/strong> masing-masing sebagai <strong>1<\/strong> dan <strong>0<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Fungsi ini menghitung bahwa semua nilai teks adalah <strong>0<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap fungsi dalam praktik dengan<\/span><\/span> <span style=\"color: #000000;\">himpunan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39001 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agea1.png\" alt=\"\" width=\"471\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Fungsi AVERAGE dan AVERAGE dengan nilai teks<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> dan <strong>F2<\/strong> untuk menggunakan fungsi <strong>AVERAGE<\/strong> dan <strong>AVERAGE<\/strong> untuk menghitung nilai rata-rata di kolom <strong>Poin<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>E2<\/strong> : =RATA-RATA(B2:B8)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>F2<\/strong> : =RATA-RATA(B2:B8)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan setiap fungsi dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39002\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agea2.png\" alt=\"Excel RATA-RATA vs RATA-RATA\" width=\"550\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>AVERAGE<\/strong> hanya menggunakan nilai numerik di kolom untuk menghitung rata-rata:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">RATA-RATA: (15+16+14+12+10+29) \/ 6 = <strong>16<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Sedangkan fungsi <strong>AVERAGE<\/strong> menggunakan semua nilai pada kolom untuk menghitung rata-rata, menggunakan 0 untuk semua nilai teks:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">RATA-RATA: (15+16+14+12+0+10+29) \/ 7 = <strong>13,71428571<\/strong><\/span><\/li>\n<\/ul>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Fungsi AVERAGE dan AVERAGE dengan nilai Boolean<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> dan <strong>F2<\/strong> untuk menggunakan fungsi <strong>AVERAGE<\/strong> dan <strong>AVERAGE<\/strong> untuk menghitung nilai rata-rata di kolom <b>All-Star<\/b> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>E2<\/strong> : =RATA-RATA(C2:C8)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>F2<\/strong> : = RATA-RATA(C2:C8)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan setiap fungsi dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39003 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agea3.png\" alt=\"\" width=\"566\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>AVERAGE<\/strong> mengembalikan <strong>#DIV\/0!<\/strong> error karena tidak mampu menghitung rata-rata nilai boolean (TRUE dan FALSE).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sedangkan fungsi <strong>AVERAGE<\/strong> menghitung nilai TRUE sebagai 1 dan nilai FALSE sebagai 0, serta menghitung rata-ratanya sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">RATA-RATA: (1+0+0+0+1+0+1) \/ 7 = <strong>0,42857<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa persentase nilai pada kolom <strong>All-Star<\/strong> yang sama dengan TRUE adalah <strong>42.857%<\/strong> .<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-sel-berisi-angka\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika sel berisi angka di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan AVERAGEIF dengan beberapa rentang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-tidak-termasuk-outlier\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung mean tidak termasuk outlier di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi AVERAGE dan AVERAGE di Excel menghitung nilai rata-rata dalam suatu rentang, namun melakukannya sedikit berbeda: Fungsi AVERAGE menghitung rata-rata semua angka dalam kolom. Fungsi AVERAGE menghitung rata-rata semua nilai dalam suatu kolom. Fungsi ini menghitung nilai TRUE dan FALSE masing-masing sebagai 1 dan 0 . Fungsi ini menghitung bahwa semua nilai teks adalah 0 [&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>Excel: Perbedaan fungsi AVERAGE dan AVERAGE - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan fungsi AVERAGE dan AVERAGE di Excel, termasuk 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\/rata-rata-excel-vs-rata-rata\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Perbedaan fungsi AVERAGE dan AVERAGE - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan fungsi AVERAGE dan AVERAGE di Excel, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T08:31:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agea1.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\/rata-rata-excel-vs-rata-rata\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/\",\"name\":\"Excel: Perbedaan fungsi AVERAGE dan AVERAGE - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T08:31:31+00:00\",\"dateModified\":\"2023-07-05T08:31:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan fungsi AVERAGE dan AVERAGE di Excel, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: perbedaan antara fungsi average dan average\"}]},{\"@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":"Excel: Perbedaan fungsi AVERAGE dan AVERAGE - Statologi","description":"Tutorial ini menjelaskan perbedaan fungsi AVERAGE dan AVERAGE di Excel, termasuk 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\/rata-rata-excel-vs-rata-rata\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Perbedaan fungsi AVERAGE dan AVERAGE - Statologi","og_description":"Tutorial ini menjelaskan perbedaan fungsi AVERAGE dan AVERAGE di Excel, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/","og_site_name":"Statorials","article_published_time":"2023-07-05T08:31:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agea1.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\/rata-rata-excel-vs-rata-rata\/","url":"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/","name":"Excel: Perbedaan fungsi AVERAGE dan AVERAGE - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T08:31:31+00:00","dateModified":"2023-07-05T08:31:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan fungsi AVERAGE dan AVERAGE di Excel, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-excel-vs-rata-rata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: perbedaan antara fungsi average dan average"}]},{"@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\/4999"}],"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=4999"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4999\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}