{"id":4832,"date":"2023-07-07T10:58:55","date_gmt":"2023-07-07T10:58:55","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/"},"modified":"2023-07-07T10:58:55","modified_gmt":"2023-07-07T10:58:55","slug":"rata-rata-excel-per-hari-dalam-seminggu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/","title":{"rendered":"Cara menghitung rata-rata berdasarkan hari dalam seminggu di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menghitung nilai rata-rata yang dikelompokkan berdasarkan hari dalam seminggu di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki kumpulan data berikut dan ingin menghitung rata-rata penjualan berdasarkan hari dalam seminggu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37730 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/une-semaine1.png\" alt=\"\" width=\"481\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai data ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37730 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/une-semaine1.png\" alt=\"\" width=\"481\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Ekstrak hari dalam seminggu dari tanggal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, ketik rumus berikut di sel <strong>C2<\/strong> untuk mengekstrak hari dalam seminggu untuk tanggal di sel <strong>A2<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A2<\/span> , \"dddd\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37731 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/une-semaine2.png\" alt=\"\" width=\"515\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat daftar hari dalam seminggu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, buat daftar hari dalam seminggu di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37732 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/une-semaine3.png\" alt=\"\" width=\"564\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung rata-rata per hari dalam seminggu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan rumus berikut pada sel <strong>F2<\/strong> untuk menghitung rata-rata nilai penjualan berdasarkan hari dalam seminggu.<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIF( <span style=\"color: #3366ff;\">$C$2:$C$15<\/span> , <span style=\"color: #ff0000;\">E2<\/span> , <span style=\"color: #800080;\">$B$2:$B$15<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Klik dan seret rumus ini ke setiap sel yang tersisa di kolom F:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37733\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/une-semaine4.png\" alt=\"Rata-rata Excel berdasarkan hari dalam seminggu\" width=\"632\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rata-rata penjualan pada hari Senin adalah <strong>11,5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan rata-rata pada hari Selasa adalah <strong>30<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata penjualan pada hari Rabu adalah <strong>12<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata penjualan pada hari Kamis adalah <strong>15<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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\/rata-rata-excel-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata per bulan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata berdasarkan kelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata pergerakan 7 hari di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menghitung nilai rata-rata yang dikelompokkan berdasarkan hari dalam seminggu di Excel. Misalnya, kita memiliki kumpulan data berikut dan ingin menghitung rata-rata penjualan berdasarkan hari dalam seminggu: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan nilai data ke dalam Excel: Langkah 2: Ekstrak hari [&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 Hari dalam Seminggu di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata hari dalam seminggu di Excel, dengan contoh lengkap\" \/>\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-per-hari-dalam-seminggu\/\" \/>\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 Hari dalam Seminggu di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata hari dalam seminggu di Excel, dengan contoh lengkap\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T10:58:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/une-semaine1.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-per-hari-dalam-seminggu\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/\",\"name\":\"Cara Menghitung Rata-Rata Hari dalam Seminggu di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T10:58:55+00:00\",\"dateModified\":\"2023-07-07T10:58:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata hari dalam seminggu di Excel, dengan contoh lengkap\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata berdasarkan hari dalam seminggu 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 Hari dalam Seminggu di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung rata-rata hari dalam seminggu di Excel, dengan contoh lengkap","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-per-hari-dalam-seminggu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-Rata Hari dalam Seminggu di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata hari dalam seminggu di Excel, dengan contoh lengkap","og_url":"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/","og_site_name":"Statorials","article_published_time":"2023-07-07T10:58:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/une-semaine1.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-per-hari-dalam-seminggu\/","url":"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/","name":"Cara Menghitung Rata-Rata Hari dalam Seminggu di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T10:58:55+00:00","dateModified":"2023-07-07T10:58:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata hari dalam seminggu di Excel, dengan contoh lengkap","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-excel-per-hari-dalam-seminggu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata berdasarkan hari dalam seminggu 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\/4832"}],"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=4832"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4832\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}