{"id":5104,"date":"2023-07-03T13:57:20","date_gmt":"2023-07-03T13:57:20","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/"},"modified":"2023-07-03T13:57:20","modified_gmt":"2023-07-03T13:57:20","slug":"rata-rata-excel-setiap-baris-ke-n","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/","title":{"rendered":"Cara menghitung rata-rata setiap baris ke-n di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus dasar berikut untuk menghitung rata-rata setiap baris ke-n di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE(IF(MOD(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )-MIN(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )),n)=0, <span style=\"color: #3366ff;\">A2:A21<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung rata-rata setiap nilai ke-n dalam rentang <strong>A2:A21<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cukup ubah nilai <strong>n<\/strong> dalam rumus menjadi rata-rata baris tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat menggunakan rumus berikut untuk menghitung rata-rata setiap <b>4<\/b> baris:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE(IF(MOD(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )-MIN(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )),4)=0, <span style=\"color: #3366ff;\">A2:A21<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: rata-rata setiap n baris di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kolom nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39782 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avy1.png\" alt=\"\" width=\"441\" height=\"468\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung rata-rata setiap baris <b>keempat<\/b> di kolom A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE(IF(MOD(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )-MIN(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )),4)=0, <span style=\"color: #3366ff;\">A2:A21<\/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-39783\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avy2.png\" alt=\"Rata-rata Excel setiap n baris\" width=\"679\" height=\"513\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya menunjukkan bahwa rata-rata setiap baris keempat dalam rentang <strong>A2:A21<\/strong> adalah <strong>18<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan mengidentifikasi setiap nilai keempat dalam rentang secara manual:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39784 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avy3.png\" alt=\"\" width=\"447\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata dari nilai-nilai tersebut dapat dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata = (4 + 10 + 17 + 29 + 30) \/ 5 = <strong>18<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mengubah nilai <strong>n<\/strong> dalam rumus, kita dapat memilih nilai ke-n yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan rumus berikut untuk menghitung rata-rata setiap baris <b>keenam<\/b> dalam rentang tersebut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE(IF(MOD(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )-MIN(ROW( <span style=\"color: #3366ff;\">A2:A21<\/span> )),6)=0, <span style=\"color: #3366ff;\">A2:A21<\/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-39785 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avy4.png\" alt=\"\" width=\"645\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya menunjukkan bahwa rata-rata setiap baris keenam dalam rentang <strong>A2:A21<\/strong> adalah <strong>18.25<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan mengidentifikasi secara manual setiap nilai keenam dalam rentang tersebut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39786 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avy5.png\" alt=\"\" width=\"444\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata dari nilai-nilai tersebut dapat dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata = (4 + 15 + 29 + 25) \/ 4 = <strong>18,25<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung dengan rumus kami.<\/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\/excel-pilih-setiap-baris-ke-n\/\" target=\"_blank\" rel=\"noopener\">Cara memilih setiap baris ke-N di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-setiap-baris-ke-n\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan setiap baris ke-N di Excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/excel-pilih-semua-kolom-lainnya\/\" target=\"_blank\" rel=\"noopener\">Cara memilih semua kolom lainnya di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus dasar berikut untuk menghitung rata-rata setiap baris ke-n di Excel: =AVERAGE(IF(MOD(ROW( A2:A21 )-MIN(ROW( A2:A21 )),n)=0, A2:A21 )) Rumus ini menghitung rata-rata setiap nilai ke-n dalam rentang A2:A21 . Cukup ubah nilai n dalam rumus menjadi rata-rata baris tertentu. Misalnya, Anda dapat menggunakan rumus berikut untuk menghitung rata-rata setiap 4 baris: =AVERAGE(IF(MOD(ROW( [&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 Setiap Baris ke-N di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata baris ke-th di Excel, termasuk contoh lengkapnya.\" \/>\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-setiap-baris-ke-n\/\" \/>\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 Setiap Baris ke-N di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata baris ke-th di Excel, termasuk contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T13:57:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avy1.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-setiap-baris-ke-n\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/\",\"name\":\"Cara Menghitung Rata-rata Setiap Baris ke-N di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T13:57:20+00:00\",\"dateModified\":\"2023-07-03T13:57:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata baris ke-th di Excel, termasuk contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata setiap baris ke-n 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 Setiap Baris ke-N di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung rata-rata baris ke-th di Excel, termasuk contoh lengkapnya.","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-setiap-baris-ke-n\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-rata Setiap Baris ke-N di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata baris ke-th di Excel, termasuk contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/","og_site_name":"Statorials","article_published_time":"2023-07-03T13:57:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avy1.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-setiap-baris-ke-n\/","url":"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/","name":"Cara Menghitung Rata-rata Setiap Baris ke-N di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T13:57:20+00:00","dateModified":"2023-07-03T13:57:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata baris ke-th di Excel, termasuk contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-excel-setiap-baris-ke-n\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata setiap baris ke-n 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\/5104"}],"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=5104"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5104\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}