{"id":5111,"date":"2023-07-03T10:50:16","date_gmt":"2023-07-03T10:50:16","guid":{"rendered":"https:\/\/statorials.org\/id\/menara-sedang-excel\/"},"modified":"2023-07-03T10:50:16","modified_gmt":"2023-07-03T10:50:16","slug":"menara-sedang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menara-sedang-excel\/","title":{"rendered":"Cara menghitung rata-rata dengan pembulatan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung nilai rata-rata suatu rentang di Excel dan membulatkan hasilnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada dua cara umum untuk melakukan ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Bulatkan rata-rata ke sejumlah tempat desimal tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=ROUND(AVERAGE( <span style=\"color: #3366ff;\">A2:A14<\/span> ), 3)\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung nilai rata-rata sel dalam rentang <strong>A2:A14<\/strong> dan kemudian membulatkan hasilnya menjadi 3 tempat desimal.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Bulatkan rata-rata ke bilangan bulat terdekat<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=ROUND(AVERAGE( <span style=\"color: #3366ff;\">A2:A14<\/span> ), 0)<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung nilai rata-rata sel dalam rentang <strong>A2:A14<\/strong> dan kemudian membulatkan hasilnya ke bilangan bulat terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik dengan kolom nilai berikut di Excel, yang memiliki nilai rata-rata <strong>25.3077<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39836 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autour1.png\" alt=\"\" width=\"428\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Membulatkan mean ke sejumlah tempat desimal tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung rata-rata nilai dalam rentang <strong>A2:A14<\/strong> , lalu membulatkan hasilnya menjadi 3 desimal:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=ROUND(AVERAGE( <span style=\"color: #3366ff;\">A2:A14<\/span> ), 3)<\/strong><\/span><\/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-39837\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autour2.png\" alt=\"Excel membulatkan rata-rata ke sejumlah tempat desimal tertentu\" width=\"542\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai rata-rata sel dalam rentang <strong>A2:A14<\/strong> yang dibulatkan menjadi 3 tempat desimal, yang hasilnya adalah <strong>25.231<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Untuk membulatkan ke angka desimal yang berbeda, cukup ganti angka <strong>3<\/strong> pada fungsi <strong>ROUND<\/strong> dengan angka lain.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Bulatkan rata-rata ke bilangan bulat terdekat<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung rata-rata nilai dalam rentang <strong>A2:A14<\/strong> , lalu membulatkan hasilnya ke bilangan bulat terdekat:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=ROUND(AVERAGE( <span style=\"color: #3366ff;\">A2:A14<\/span> ), 0)<\/strong><\/span><\/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-39838\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autour3.png\" alt=\"Excel membulatkan rata-rata ke bilangan bulat terdekat\" width=\"527\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai rata-rata sel dalam rentang <strong>A2:A14<\/strong> yang dibulatkan ke bilangan bulat terdekat, yang hasilnya adalah <strong>25<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda ingin membulatkan hasilnya <em>ke atas<\/em> atau <em>ke bawah<\/em> ke bilangan bulat terdekat, cukup ganti fungsi <strong>ROUND<\/strong> dengan fungsi <strong>ROUNDUP<\/strong> atau <strong>ROUNDDOWN<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/angka-penting-unggul\/\" target=\"_blank\" rel=\"noopener\">Excel: cara membulatkan ke angka penting<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-bawah\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan MROUND agar selalu membulatkan ke bawah<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/unggul\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan MROUND agar selalu membulat<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menghitung nilai rata-rata suatu rentang di Excel dan membulatkan hasilnya. Ada dua cara umum untuk melakukan ini: Metode 1: Bulatkan rata-rata ke sejumlah tempat desimal tertentu =ROUND(AVERAGE( A2:A14 ), 3) Contoh khusus ini menghitung nilai rata-rata sel dalam rentang A2:A14 dan kemudian membulatkan hasilnya menjadi 3 tempat desimal. Metode 2: Bulatkan [&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 dengan pembulatan di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata suatu rentang di Excel dan membulatkannya, 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\/menara-sedang-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 dengan pembulatan di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata suatu rentang di Excel dan membulatkannya, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menara-sedang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T10:50:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autour1.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\/menara-sedang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/menara-sedang-excel\/\",\"name\":\"Cara menghitung rata-rata dengan pembulatan di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T10:50:16+00:00\",\"dateModified\":\"2023-07-03T10:50:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai rata-rata suatu rentang di Excel dan membulatkannya, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menara-sedang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menara-sedang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menara-sedang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata dengan pembulatan di excel\"}]},{\"@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 dengan pembulatan di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata suatu rentang di Excel dan membulatkannya, 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\/menara-sedang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung rata-rata dengan pembulatan di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata suatu rentang di Excel dan membulatkannya, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/menara-sedang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-03T10:50:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autour1.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\/menara-sedang-excel\/","url":"https:\/\/statorials.org\/id\/menara-sedang-excel\/","name":"Cara menghitung rata-rata dengan pembulatan di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T10:50:16+00:00","dateModified":"2023-07-03T10:50:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata suatu rentang di Excel dan membulatkannya, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menara-sedang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menara-sedang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menara-sedang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata dengan pembulatan di excel"}]},{"@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\/5111"}],"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=5111"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5111\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}