{"id":3501,"date":"2023-07-17T03:55:36","date_gmt":"2023-07-17T03:55:36","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/"},"modified":"2023-07-17T03:55:36","modified_gmt":"2023-07-17T03:55:36","slug":"rata-rata-bersyarat-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/","title":{"rendered":"Cara menghitung rata-rata bersyarat di excel: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>AVERAGEIF<\/strong> di Excel untuk menghitung rata-rata bersyarat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIF( <span style=\"color: #3366ff;\">A2:A7<\/span> , \"some value\", <span style=\"color: #ff0000;\">B2:B7<\/span> )<\/strong>\n<\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung nilai rata-rata dalam rentang <strong>B2:B7<\/strong> di mana nilai terkait dalam rentang <strong>A2:A7<\/strong> sama dengan &#8220;nilai tertentu&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi ini untuk menghitung rata-rata bersyarat menggunakan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29136 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel1.jpg\" alt=\"\" width=\"501\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung Rata-Rata Bersyarat untuk Data Kategorikal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung rata-rata kolom <strong>Poin<\/strong> hanya untuk baris yang kolom <strong>Timnya<\/strong> bernilai &#8220;A&#8221;.<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIF( <span style=\"color: #3366ff;\">A2:A7<\/span> , \"A\", <span style=\"color: #ff0000;\">B2:B7<\/span> )<\/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=\"aligncenter wp-image-29137\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel2.jpg\" alt=\"rata-rata bersyarat di Excel\" width=\"539\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata pada kolom Poin untuk garis yang tim sama dengan \u201cA\u201d adalah <strong>94<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan merata-ratakan nilai poin hanya untuk garis yang timnya sama dengan &#8220;A&#8221;:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Poin rata-rata: (99 + 90 + 93) \/ 3 = <strong>94<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung dengan fungsi AVERAGEIF.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung Rata-Rata Bersyarat untuk Data Numerik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung rata-rata kolom <strong>Assist<\/strong> hanya untuk baris yang kolom <strong>Poinnya<\/strong> memiliki nilai lebih besar atau sama dengan 90:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIF( <span style=\"color: #3366ff;\">B2:B7<\/span> , \"&gt;=90\", <span style=\"color: #ff0000;\">C2:C7<\/span> )<\/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-29140 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel3.jpg\" alt=\"\" width=\"539\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata pada kolom Assists untuk baris yang poinnya lebih besar atau sama dengan 90 adalah <strong>30.66667<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan merata-ratakan nilai bantuan hanya untuk baris yang poinnya lebih besar atau sama dengan 90:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rata-rata assist: (33 + 28 + 31) \/ 3 = <strong>30,66667<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung dengan fungsi AVERAGEIF.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<br \/><\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/\" target=\"_blank\" rel=\"noopener\">Cara Mencari Mean, Median dan Modus di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Standard Error Mean di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean Square Error (MSE) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi AVERAGEIF di Excel untuk menghitung rata-rata bersyarat. Fungsi ini menggunakan sintaks dasar berikut: =AVERAGEIF( A2:A7 , &#8220;some value&#8221;, B2:B7 ) Rumus khusus ini menghitung nilai rata-rata dalam rentang B2:B7 di mana nilai terkait dalam rentang A2:A7 sama dengan &#8220;nilai tertentu&#8221;. Contoh berikut memperlihatkan cara menggunakan fungsi ini untuk menghitung rata-rata bersyarat [&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 Rata-Rata Bersyarat di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata bersyarat di Excel, dengan beberapa contoh.\" \/>\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-bersyarat-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rata-Rata Bersyarat di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata bersyarat di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T03:55:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel1.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-bersyarat-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/\",\"name\":\"Cara Menghitung Rata-Rata Bersyarat di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T03:55:36+00:00\",\"dateModified\":\"2023-07-17T03:55:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata bersyarat di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata bersyarat 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 Menghitung Rata-Rata Bersyarat di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung rata-rata bersyarat di Excel, dengan beberapa contoh.","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-bersyarat-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-Rata Bersyarat di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata bersyarat di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-17T03:55:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/conditionnel1.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-bersyarat-di-excel\/","url":"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/","name":"Cara Menghitung Rata-Rata Bersyarat di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T03:55:36+00:00","dateModified":"2023-07-17T03:55:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata bersyarat di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata bersyarat 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\/3501"}],"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=3501"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3501\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}