{"id":5080,"date":"2023-07-04T01:14:02","date_gmt":"2023-07-04T01:14:02","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/"},"modified":"2023-07-04T01:14:02","modified_gmt":"2023-07-04T01:14:02","slug":"persentase-kesalahan-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/","title":{"rendered":"Cara menghitung persentase kesalahan di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Persentase kesalahan<\/strong> adalah perbedaan antara nilai yang diukur dan nilai yang diketahui atau diterima.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghitung persentase kesalahan:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Persentase kesalahan = |(nilai diketahui \u2013 nilai terukur) \/ nilai diketahui| *100<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Semakin besar persentase kesalahannya, semakin besar perbedaan antara nilai terukur dan nilai yang diketahui.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebagai contoh, misalkan tinggi sebuah pohon tepat <strong>30<\/strong> kaki, namun Anda mengukurnya sendiri dan melaporkan bahwa tingginya <strong>29,4<\/strong> kaki.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Persentase kesalahan pengukuran Anda akan dihitung sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Persentase kesalahan = |(nilai diketahui \u2013 nilai terukur) \/ nilai diketahui| *100<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase kesalahan = |(30 \u2013 29,4) \/ 30| *100<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase kesalahan = 0,02 * 100<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase kesalahan = <strong>2%<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Persentase kesalahan antara tinggi pohon yang diketahui dan tinggi pohon yang diukur adalah <strong>2%<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan rumus di Excel untuk menghitung persentase kesalahan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Persentase Kesalahan di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung persentase kesalahan di Excel, Anda harus memasukkan nilai yang diketahui di satu sel dan nilai terukur di sel lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita akan mengetikkan tinggi badan kita yang diketahui yaitu <strong>30<\/strong> ke dalam sel <strong>A2<\/strong> dan tinggi badan terukur kita sebesar <strong>29,4<\/strong> ke dalam sel <strong>B2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39584 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perror1.png\" alt=\"\" width=\"458\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengetikkan rumus berikut ke dalam sel <strong>C2<\/strong> untuk menghitung persentase kesalahan pengukuran kita:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ABS(( <span style=\"color: #3366ff;\">A2<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )\/ <span style=\"color: #3366ff;\">A2<\/span> )*100<\/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-39585\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perror2.png\" alt=\"Rumus Persentase Kesalahan Excel\" width=\"450\" height=\"358\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan <strong>2<\/strong> , yang memberi tahu kita bahwa persentase kesalahan antara nilai yang diketahui dan nilai yang diukur adalah <strong>2%<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menampilkan simbol persentase pada hasilnya, Anda bisa memasukkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ABS(( <span style=\"color: #3366ff;\">A2<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )\/ <span style=\"color: #3366ff;\">A2<\/span> )*100<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengembalikan <strong>0,02<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39586 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perror3.png\" alt=\"\" width=\"467\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat memilih sel <strong>C2<\/strong> , lalu klik menu tarik-turun <strong>Format Angka<\/strong> di grup <strong>Angka<\/strong> pada tab <strong>Beranda<\/strong> di sepanjang pita atas, lalu klik <strong>Persentase<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30965 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp3.jpg\" alt=\"\" width=\"436\" height=\"603\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menampilkan hasil rumus sebagai persentase:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39587 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perror4.png\" alt=\"\" width=\"462\" height=\"376\" srcset=\"\" sizes=\"\"><\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10% nilai teratas di kolom Excel<\/a><br \/> Cara Menghitung Persentase Kumulatif di Excel<br \/> <a href=\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan persentase di excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Persentase kesalahan adalah perbedaan antara nilai yang diukur dan nilai yang diketahui atau diterima. Anda dapat menggunakan rumus berikut untuk menghitung persentase kesalahan: Persentase kesalahan = |(nilai diketahui \u2013 nilai terukur) \/ nilai diketahui| *100 Semakin besar persentase kesalahannya, semakin besar perbedaan antara nilai terukur dan nilai yang diketahui. Sebagai contoh, misalkan tinggi sebuah pohon [&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 Kesalahan di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus untuk menghitung persentase kesalahan di Excel, beserta 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\/persentase-kesalahan-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Persentase Kesalahan di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus untuk menghitung persentase kesalahan di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T01:14:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perror1.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\/persentase-kesalahan-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/\",\"name\":\"Cara Menghitung Persentase Kesalahan di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T01:14:02+00:00\",\"dateModified\":\"2023-07-04T01:14:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus untuk menghitung persentase kesalahan di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase kesalahan 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 Persentase Kesalahan di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan rumus untuk menghitung persentase kesalahan di Excel, beserta 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\/persentase-kesalahan-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Kesalahan di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan rumus untuk menghitung persentase kesalahan di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-04T01:14:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perror1.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\/persentase-kesalahan-excel\/","url":"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/","name":"Cara Menghitung Persentase Kesalahan di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T01:14:02+00:00","dateModified":"2023-07-04T01:14:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus untuk menghitung persentase kesalahan di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-kesalahan-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase kesalahan 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\/5080"}],"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=5080"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5080\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}