{"id":3455,"date":"2023-07-17T09:49:43","date_gmt":"2023-07-17T09:49:43","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/"},"modified":"2023-07-17T09:49:43","modified_gmt":"2023-07-17T09:49:43","slug":"persentase-rata-rata-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/","title":{"rendered":"Cara menghitung persentase rata-rata di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung persentase rata-rata kumpulan data. Untungnya, hal ini mudah dilakukan berkat fungsi bawaan Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan dua contoh penghitungan persentase rata-rata dalam skenario yang berbeda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung Rata-Rata Persentase dengan Persentase Saja<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar persentase berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28863 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-moyen1-1.jpg\" alt=\"\" width=\"485\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung persentase rata-rata, kita bisa mengetikkan rumus berikut di sel <strong>B11<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #3366ff;\">B2:B9<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>Enter<\/strong> , persentase rata-rata akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28864 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-moyen2.jpg\" alt=\"\" width=\"447\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita melihat persentase rata-ratanya adalah <strong>81,94%<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung Persentase Rata-Rata dengan Angka dan Persentase<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita melakukan survei kepada orang tua, siswa, dan guru di sekolah tertentu dan menanyakan apakah mereka akan mendukung peraturan sekolah yang baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kumpulan data berikut menunjukkan jumlah orang yang merespons survei di masing-masing tiga kelompok serta persentase individu di setiap kelompok yang mendukung aturan baru tersebut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28867 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-moyen4.jpg\" alt=\"\" width=\"416\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung persentase rata-rata individu yang mendukung aturan baru di ketiga kelompok:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT( <span style=\"color: #3366ff;\">B2:B4<\/span> , <span style=\"color: #ff0000;\">C2:C4<\/span> )\/SUM( <span style=\"color: #3366ff;\">B2:B4<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28868\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-moyen5.jpg\" alt=\"persentase rata-rata di Excel\" width=\"587\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami melihat bahwa <strong>58,33%<\/strong> dari total masyarakat mendukung aturan baru ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat memverifikasi kebenarannya dengan menghitung secara manual jumlah orang yang mendukung aturan di setiap grup, lalu membaginya dengan jumlah total orang:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">% mendukung siswa = 400 * 30% = 120.<\/span><\/li>\n<li> <span style=\"color: #000000;\">% mendukung orang tua = 300 * 90% = 270.<\/span><\/li>\n<li> <span style=\"color: #000000;\">% mendukung guru = 50 * 95% = 47,5.<\/span><\/li>\n<li> <span style=\"color: #000000;\">% Semua individu mendukung = (120+270+47.5) \/ 750 = <strong>0.5833<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini adalah persentase rata-rata yang kami hitung menggunakan rumus <strong>SUMPRODUK<\/strong> .<\/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:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara mencari persentase dua angka di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Tertimbang di Excel<\/a><br \/> Cara Menghitung Persentase Kumulatif di Excel<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menghitung persentase rata-rata kumpulan data. Untungnya, hal ini mudah dilakukan berkat fungsi bawaan Excel. Tutorial ini memberikan dua contoh penghitungan persentase rata-rata dalam skenario yang berbeda. Contoh 1: Hitung Rata-Rata Persentase dengan Persentase Saja Misalkan kita memiliki daftar persentase berikut di Excel: Untuk menghitung persentase rata-rata, kita bisa mengetikkan rumus berikut [&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 Persentase Rata-Rata di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persentase rata-rata 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\/persentase-rata-rata-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Persentase Rata-Rata di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T09:49:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-moyen1-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\/persentase-rata-rata-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/\",\"name\":\"Cara Menghitung Persentase Rata-Rata di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T09:49:43+00:00\",\"dateModified\":\"2023-07-17T09:49:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase rata-rata 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 Persentase Rata-Rata di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung persentase rata-rata 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\/persentase-rata-rata-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Rata-Rata di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-17T09:49:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-moyen1-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\/persentase-rata-rata-excel\/","url":"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/","name":"Cara Menghitung Persentase Rata-Rata di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T09:49:43+00:00","dateModified":"2023-07-17T09:49:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase rata-rata 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\/3455"}],"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=3455"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3455\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}