{"id":3729,"date":"2023-07-15T21:40:53","date_gmt":"2023-07-15T21:40:53","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/"},"modified":"2023-07-15T21:40:53","modified_gmt":"2023-07-15T21:40:53","slug":"persentase-rata-rata-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/","title":{"rendered":"Cara menghitung persentase rata-rata di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung persentase rata-rata kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan berkat fungsi bawaan Google Sheets.<\/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;\">Katakanlah kita memiliki daftar persentase berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30392 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc11.jpg\" alt=\"\" width=\"508\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung persentase rata-rata, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #ff6600;\">A2:A9<\/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=\"aligncenter wp-image-30393\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc12.jpg\" alt=\"persentase rata-rata di Google Spreadsheet\" width=\"557\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami melihat persentase rata-ratanya adalah <strong>82%<\/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-30394 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc13.jpg\" alt=\"\" width=\"563\" height=\"455\" 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: #ff6600;\">B2:B4<\/span> , <span style=\"color: #800080;\">C2:C4<\/span> )\/SUM( <span style=\"color: #ff6600;\">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-30395\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc14.jpg\" alt=\"persentase rata-rata di Google Spreadsheet dengan hitungan\" width=\"537\" height=\"500\" 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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/persentase-kumulatif-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Kumulatif di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-tertimbang-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung persentase tertimbang di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan persentase di Google Sheets<\/a><\/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 Google Sheets. Tutorial ini memberikan dua contoh penghitungan persentase rata-rata dalam skenario yang berbeda. Contoh 1: Hitung Rata-Rata Persentase dengan Persentase Saja Katakanlah kita memiliki daftar persentase berikut di Google Spreadsheet: Untuk menghitung persentase rata-rata, kita bisa mengetikkan [&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 Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Google Sheets, 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-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 Persentase Rata-Rata di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T21:40:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc11.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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/\",\"name\":\"Cara Menghitung Persentase Rata-Rata di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T21:40:53+00:00\",\"dateModified\":\"2023-07-15T21:40:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase rata-rata 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 Persentase Rata-Rata di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Google Sheets, 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-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Rata-Rata di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-15T21:40:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc11.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-google-sheet\/","url":"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/","name":"Cara Menghitung Persentase Rata-Rata di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T21:40:53+00:00","dateModified":"2023-07-15T21:40:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persentase rata-rata di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-rata-rata-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase rata-rata 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\/3729"}],"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=3729"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3729\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}