{"id":4796,"date":"2023-07-07T20:41:46","date_gmt":"2023-07-07T20:41:46","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/"},"modified":"2023-07-07T20:41:46","modified_gmt":"2023-07-07T20:41:46","slug":"persentase-kemenangan-perhitungan-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/","title":{"rendered":"Cara menghitung persentase kemenangan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Persentase kemenangan<\/strong> adalah metrik yang memberi tahu Anda persentase permainan atau permainan yang dimenangkan oleh suatu tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Persentase kemenangan = Menang \/ (Menang + Kalah)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika sebuah tim memenangkan 40 pertandingan dan kalah 10 pertandingan, persentase kemenangannya dihitung sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Persentase kemenangan = Menang \/ (Menang + Kalah)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase kemenangan = 40 \/ (40 + 10)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase kemenangan = 40\/50<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase kemenangan = 80%<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung persentase kemenangan di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Menghitung Persentase Kemenangan di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah pertandingan yang dimenangkan dan dikalahkan oleh tim bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37432 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wp1.png\" alt=\"\" width=\"502\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghitung persentase kemenangan setiap tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #3366ff;\">B2<\/span> \/( <span style=\"color: #3366ff;\">B2<\/span> + <span style=\"color: #ff0000;\">C2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret nilai ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37433 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wp2.png\" alt=\"\" width=\"502\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, sorot rentang <strong>D2:D11<\/strong> , lalu klik menu tarik-turun <strong>Format Angka<\/strong> di grup <strong>Angka<\/strong> pada tab <strong>Beranda<\/strong> dan 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;\">Nilai di kolom D sekarang akan diformat sebagai persentase:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37434 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wp3.png\" alt=\"\" width=\"505\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom D menunjukkan persentase kemenangan setiap tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Mavs telah memenangkan <strong>51,22%<\/strong> dari total pertandingan mereka.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Spurs telah memenangkan <strong>60,98%<\/strong> dari total pertandingan mereka.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rockets telah memenangkan <strong>74,39%<\/strong> dari total pertandingan mereka.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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-menghitung-persentase-presisi\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Akurasi Persentase di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Terbalik di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengkonversi persentase ke rasio di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Persentase kemenangan adalah metrik yang memberi tahu Anda persentase permainan atau permainan yang dimenangkan oleh suatu tim. Ini dihitung sebagai berikut: Persentase kemenangan = Menang \/ (Menang + Kalah) Misalnya, jika sebuah tim memenangkan 40 pertandingan dan kalah 10 pertandingan, persentase kemenangannya dihitung sebagai berikut: Persentase kemenangan = Menang \/ (Menang + Kalah) Persentase kemenangan [&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 Kemenangan di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persentase kemenangan 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\/persentase-kemenangan-perhitungan-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 Kemenangan di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persentase kemenangan di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T20:41:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wp1.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-kemenangan-perhitungan-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/\",\"name\":\"Cara Menghitung Persentase Kemenangan di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T20:41:46+00:00\",\"dateModified\":\"2023-07-07T20:41:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persentase kemenangan di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase kemenangan 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 Persentase Kemenangan di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung persentase kemenangan 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\/persentase-kemenangan-perhitungan-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Kemenangan di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung persentase kemenangan di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T20:41:46+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wp1.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-kemenangan-perhitungan-excel\/","url":"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/","name":"Cara Menghitung Persentase Kemenangan di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T20:41:46+00:00","dateModified":"2023-07-07T20:41:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persentase kemenangan di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-kemenangan-perhitungan-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase kemenangan 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\/4796"}],"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=4796"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4796\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}