{"id":4831,"date":"2023-07-07T11:16:56","date_gmt":"2023-07-07T11:16:56","guid":{"rendered":"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/"},"modified":"2023-07-07T11:16:56","modified_gmt":"2023-07-07T11:16:56","slug":"selisih-rata-rata-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/","title":{"rendered":"Cara menghitung selisih rata-rata di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut di Excel untuk menghitung selisih rata-rata antara dua kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #3366ff;\">B2:B11<\/span> - <span style=\"color: #ff0000;\">C2:C11<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung perbedaan rata-rata antara nilai dalam rentang <strong>B2:B11<\/strong> dan <strong>C2:C11<\/strong> .<\/span><\/p>\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: Cara Menghitung Selisih Rata-rata di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah poin yang dicetak dan jumlah poin yang diperbolehkan dalam berbagai permainan oleh tim bola basket:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37724 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/adiff1.png\" alt=\"\" width=\"521\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung selisih rata-rata antara nilai pada kolom <strong>Poin yang Diperbolehkan<\/strong> dan <strong>kolom Poin yang Diizinkan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #3366ff;\">B2:B11<\/span> - <span style=\"color: #ff0000;\">C2:C11<\/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-37725\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/adiff2.png\" alt=\"Selisih Rata-Rata Excel\" width=\"520\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat rata-rata selisih nilai pada kolom <strong>Points Scored<\/strong> dengan kolom <strong>Points Allowed<\/strong> adalah <strong>3,3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan kata lain, tim ini rata-rata mencetak <strong>3,3<\/strong> poin lebih banyak dari yang mereka izinkan per game.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Bagaimana cara kerja rumus ini?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Ingat rumus yang kita gunakan untuk menghitung selisih rata-rata antara dua kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGE( <span style=\"color: #3366ff;\">B2:B11<\/span> - <span style=\"color: #ff0000;\">C2:C11<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini bekerja dengan terlebih dahulu menghitung selisih antara nilai terkait dalam rentang <strong>B2:B11<\/strong> dan <strong>C2:C11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, ini menghitung:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Baris 1: 100 \u2013 90 = <strong>10<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 2: 104 \u2013 99 = <strong>5<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 3: 98 \u2013 102= <strong>-4<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 4: 105 \u2013 104 = <strong>1<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 5: 110 \u2013 112 = <strong>-2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 6: 113 \u2013 109 = <strong>4<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 7: 121 \u2013 108 = <strong>13<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 8: 108 \u2013 100 = <strong>8<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 9: 99 \u2013 104 = <strong>-5<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris 10: 93 \u2013 90 = <strong>3<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kemudian menggunakan fungsi <strong>AVERAGE<\/strong> untuk menghitung rata-rata dari semua perbedaan ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selisih rata-rata = (10+5-4+1-2+4+13+8-5+3) \/ 10 = <strong>3,3<\/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\/rata-rata-excel-berdasarkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Berdasarkan Tanggal 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-excel-abaikan-nol-dan-kosong\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata dan Mengabaikan Sel Null dan Kosong di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut di Excel untuk menghitung selisih rata-rata antara dua kolom: =AVERAGE( B2:B11 &#8211; C2:C11 ) Rumus khusus ini menghitung perbedaan rata-rata antara nilai dalam rentang B2:B11 dan C2:C11 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Cara Menghitung Selisih Rata-rata di Excel Misalkan kita memiliki kumpulan data 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 Selisih Rata-rata di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung selisih rata-rata antara dua kolom di Excel, dengan sebuah 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\/selisih-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 Selisih Rata-rata di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung selisih rata-rata antara dua kolom di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T11:16:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/adiff1.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\/selisih-rata-rata-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/\",\"name\":\"Cara Menghitung Selisih Rata-rata di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T11:16:56+00:00\",\"dateModified\":\"2023-07-07T11:16:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung selisih rata-rata antara dua kolom di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung selisih rata-rata 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 Selisih Rata-rata di Excel - Statorials","description":"Tutorial ini menjelaskan cara menghitung selisih rata-rata antara dua kolom di Excel, dengan sebuah 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\/selisih-rata-rata-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Selisih Rata-rata di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung selisih rata-rata antara dua kolom di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T11:16:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/adiff1.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\/selisih-rata-rata-excel\/","url":"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/","name":"Cara Menghitung Selisih Rata-rata di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T11:16:56+00:00","dateModified":"2023-07-07T11:16:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung selisih rata-rata antara dua kolom di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/selisih-rata-rata-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung selisih rata-rata 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\/4831"}],"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=4831"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4831\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}