{"id":2674,"date":"2023-07-21T05:45:05","date_gmt":"2023-07-21T05:45:05","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/"},"modified":"2023-07-21T05:45:05","modified_gmt":"2023-07-21T05:45:05","slug":"rata-rata-excel-jika-antara-dua-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/","title":{"rendered":"Excel: cara menghitung rata-rata antara dua nilai"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung rata-rata nilai rentang di Excel hanya untuk nilai antara dua nilai tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIFS( <span style=\"color: #3366ff;\">B:B<\/span> , <span style=\"color: #3366ff;\">B:B<\/span> ,\"&gt;=90\", <span style=\"color: #3366ff;\">B:B<\/span> ,\"&lt;=95\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini hanya akan menghitung rata-rata nilai antara 90 dan 95 pada kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung rata-rata antara dua nilai di Excel (menggunakan rentang)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dataset berikut yang menunjukkan nilai ujian yang diperoleh 15 siswa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23548 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenneentre2-1.jpg\" alt=\"\" width=\"492\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung rata-rata nilai ujian hanya untuk siswa yang mendapat nilai antara 90 dan 95:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIFS( <span style=\"color: #3366ff;\">A:A<\/span> , <span style=\"color: #3366ff;\">A:A<\/span> ,\"&gt;=90\", <span style=\"color: #3366ff;\">A:A<\/span> ,\"&lt;=95\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23553 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenneentre5.jpg\" alt=\"\" width=\"557\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai ujian rata-rata hanya untuk siswa yang mendapat nilai antara 90 dan 95 adalah <strong>92,4.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai ujian rata-rata = (90 + 92 + 92 + 93 + 95) \/ 5 = <strong>92,4<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung rata-rata antara dua nilai di Excel (menggunakan beberapa rentang)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut yang menunjukkan tinggi badan (dalam inci) dan perolehan poin dari 15 pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23550 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenneentre3.jpg\" alt=\"\" width=\"458\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung rata-rata poin ulasan yang diperoleh hanya untuk pemain dengan tinggi antara 70 dan 75 inci:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIFS( <span style=\"color: #3366ff;\">B:B<\/span> , <span style=\"color: #3366ff;\">A:A<\/span> ,\"&gt;=70\", <span style=\"color: #3366ff;\">A:A<\/span> ,\"&lt;=75\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23554 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenneentre6.jpg\" alt=\"\" width=\"515\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Poin rata-rata yang dicetak untuk pemain dengan tinggi antara 70 dan 75 inci adalah <strong>17,833<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata poin yang dicetak = (14 + 14 + 16 + 19 +20 + 24\/6 = <strong>17.833<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <b>AVERAGEIFS<\/b> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rata-rata-kumulatif-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Kumulatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-bergerak-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Rata-Rata Pergerakan Tertimbang di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghitung rata-rata nilai rentang di Excel hanya untuk nilai antara dua nilai tertentu: =AVERAGEIFS( B:B , B:B ,&#8221;&gt;=90&#8243;, B:B ,&#8221;&lt;=95&#8243;) Rumus khusus ini hanya akan menghitung rata-rata nilai antara 90 dan 95 pada kolom B. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh 1: Hitung rata-rata antara [&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: Cara menghitung rata-rata antara dua nilai - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang di Excel hanya untuk sel di antara dua nilai.\" \/>\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-jika-antara-dua-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung rata-rata antara dua nilai - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang di Excel hanya untuk sel di antara dua nilai.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T05:45:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenneentre2-1.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\/rata-rata-excel-jika-antara-dua-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/\",\"name\":\"Excel: Cara menghitung rata-rata antara dua nilai - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T05:45:05+00:00\",\"dateModified\":\"2023-07-21T05:45:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang di Excel hanya untuk sel di antara dua nilai.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung rata-rata antara dua nilai\"}]},{\"@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: Cara menghitung rata-rata antara dua nilai - Statologi","description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang di Excel hanya untuk sel di antara dua nilai.","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-jika-antara-dua-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung rata-rata antara dua nilai - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang di Excel hanya untuk sel di antara dua nilai.","og_url":"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-21T05:45:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenneentre2-1.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\/rata-rata-excel-jika-antara-dua-nilai\/","url":"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/","name":"Excel: Cara menghitung rata-rata antara dua nilai - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T05:45:05+00:00","dateModified":"2023-07-21T05:45:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang di Excel hanya untuk sel di antara dua nilai.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-excel-jika-antara-dua-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung rata-rata antara dua nilai"}]},{"@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\/2674"}],"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=2674"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2674\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}