{"id":1771,"date":"2023-07-25T01:35:28","date_gmt":"2023-07-25T01:35:28","guid":{"rendered":"https:\/\/statorials.org\/id\/persentil-jika-excel\/"},"modified":"2023-07-25T01:35:28","modified_gmt":"2023-07-25T01:35:28","slug":"persentil-jika-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentil-jika-excel\/","title":{"rendered":"Cara menjalankan fungsi persentil if di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menjalankan fungsi IF Persentil di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>=PERCENTILE(IF( <span style=\"color: #3366ff;\">GROUP_RANGE<\/span> = <span style=\"color: #ff0000;\">GROUP<\/span> , <span style=\"color: #800080;\">VALUES_RANGE<\/span> ), k)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mencari persentil ke-k dari semua nilai yang termasuk dalam kelompok tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Saat Anda mengetikkan rumus ini ke dalam sel di Excel, Anda perlu menekan <strong>Ctrl + Shift + Enter<\/strong> karena ini adalah rumus array.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Fungsi persentil IF di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dataset berikut yang menunjukkan nilai ujian yang diperoleh 20 siswa kelas A atau kelas B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-17297 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/percentileif1.png\" alt=\"\" width=\"522\" height=\"509\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mencari persentil ke-90 dari nilai ujian untuk setiap kelas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan hal ini, kita dapat menggunakan fungsi <strong>=UNIQUE()<\/strong> untuk terlebih dahulu membuat daftar nama kelas yang unik. Kami akan mengetikkan rumus berikut di sel F2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>= <span style=\"color: #000000;\">SINGLE<\/span> ( <span style=\"color: #3366ff;\">B2:B21<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Setelah kita menekan Enter, daftar nama kelas unik akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-17298 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/centileif.png\" alt=\"\" width=\"549\" height=\"507\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita dapat menggunakan fungsi <strong>=PERCENTILE()<\/strong> untuk mencari persentil ke-90 nilai ujian di setiap kelas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita akan mengetikkan rumus berikut di sel G2 dan tekan <strong>Ctrl + Shift + Enter<\/strong> sehingga Excel mengetahui bahwa itu adalah rumus array:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>=PERCENTILE(IF( <span style=\"color: #3366ff;\">B2:B21<\/span> = <span style=\"color: #ff0000;\">F2<\/span> , <span style=\"color: #800080;\">C2:C21<\/span> ), 0.9)<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-17299\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/centileif2.png\" alt=\"Persentil SI di Excel\" width=\"637\" height=\"498\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyalin dan menempelkan rumus ini ke sel yang tersisa di kolom G:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-17300 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/centileif3.png\" alt=\"\" width=\"595\" height=\"530\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai persentil ke-90 nilai ujian Kelas A sebesar <strong>93,2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai persentil ke-90 nilai ujian Kelas B adalah <strong>89,8<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Catatan:<\/strong> Kami memilih untuk menghitung persentil ke-90, namun Anda dapat menghitung persentil mana pun yang Anda inginkan. Misalnya, untuk menghitung persentil ke-75 nilai ujian setiap kelas, Anda dapat mengganti <strong>0,9<\/strong> dengan <strong>0,75<\/strong> dalam rumusnya.<\/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> <a href=\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rangkuman Lima Angka di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean dan Deviasi Standar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menjalankan fungsi IF Persentil di Excel: =PERCENTILE(IF( GROUP_RANGE = GROUP , VALUES_RANGE ), k) Rumus ini mencari persentil ke-k dari semua nilai yang termasuk dalam kelompok tertentu. Saat Anda mengetikkan rumus ini ke dalam sel di Excel, Anda perlu menekan Ctrl + Shift + Enter karena ini adalah rumus [&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 Menjalankan Fungsi Persentil IF di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menjalankan fungsi IF Persentil di Excel, termasuk contoh langkah demi langkah.\" \/>\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\/persentil-jika-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menjalankan Fungsi Persentil IF di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menjalankan fungsi IF Persentil di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentil-jika-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T01:35:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/percentileif1.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\/persentil-jika-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/persentil-jika-excel\/\",\"name\":\"Cara Menjalankan Fungsi Persentil IF di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T01:35:28+00:00\",\"dateModified\":\"2023-07-25T01:35:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menjalankan fungsi IF Persentil di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentil-jika-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentil-jika-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentil-jika-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menjalankan fungsi persentil if 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 Menjalankan Fungsi Persentil IF di Excel","description":"Tutorial ini menjelaskan cara menjalankan fungsi IF Persentil di Excel, termasuk contoh langkah demi langkah.","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\/persentil-jika-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menjalankan Fungsi Persentil IF di Excel","og_description":"Tutorial ini menjelaskan cara menjalankan fungsi IF Persentil di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/persentil-jika-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T01:35:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/percentileif1.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\/persentil-jika-excel\/","url":"https:\/\/statorials.org\/id\/persentil-jika-excel\/","name":"Cara Menjalankan Fungsi Persentil IF di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T01:35:28+00:00","dateModified":"2023-07-25T01:35:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menjalankan fungsi IF Persentil di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentil-jika-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentil-jika-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentil-jika-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menjalankan fungsi persentil if 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\/1771"}],"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=1771"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1771\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}