{"id":2993,"date":"2023-07-19T17:54:29","date_gmt":"2023-07-19T17:54:29","guid":{"rendered":"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/"},"modified":"2023-07-19T17:54:29","modified_gmt":"2023-07-19T17:54:29","slug":"peringkat-persentil-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/","title":{"rendered":"Cara menghitung peringkat persentil di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>PERCENTRANK<\/strong> di Excel untuk menghitung peringkat nilai dalam kumpulan data sebagai persentase dari total kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=PERCENTRANK( <span style=\"color: #3366ff;\">A2:A16<\/span> , <span style=\"color: #ff0000;\">A2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung peringkat persentil nilai <strong>A2<\/strong> dalam rentang <strong>A2:A16<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada juga dua fungsi peringkat persentil lainnya di Excel:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>PERCENTRANK.INC<\/strong> : Menghitung peringkat persentil suatu nilai, termasuk nilai terkecil dan terbesar.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>PERCENTRANK.EXC<\/strong> : Menghitung peringkat persentil suatu nilai, tidak termasuk nilai terkecil dan terbesar.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi-fungsi ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Peringkat Persentil di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dataset berikut yang menunjukkan nilai ujian yang diperoleh 15 siswa di kelas tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25850 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rang-centile1.jpg\" alt=\"\" width=\"459\" height=\"443\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menghitung peringkat persentil nilai setiap siswa.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel B2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=PERCENTRANK( <span style=\"color: #3366ff;\">$A$2:$A$16<\/span> , <span style=\"color: #ff0000;\">A2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25851\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rang-centile2.jpg\" alt=\"peringkat persentil di Excel\" width=\"474\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menginterpretasikan masing-masing nilai peringkat persentil:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Siswa yang mendapat nilai 2 ditempatkan pada persentil <strong>0<\/strong> (atau 0%) di kelas.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Siswa yang mendapat nilai 5 berada pada peringkat persentil <strong>0,071<\/strong> (atau 7,1%) di kelas.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Siswa yang mendapat nilai 7 ditempatkan pada persentil <strong>0,214<\/strong> (atau 21,4%) di kelas.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa ketika kita menggunakan fungsi <strong>PERCENTRANK<\/strong> , nilai terkecil dalam kumpulan data akan selalu memiliki peringkat persentil 0 dan nilai terbesar dalam kumpulan data akan selalu memiliki peringkat persentil 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Tangkapan layar berikut juga menunjukkan cara menggunakan fungsi <strong>PERCENTRANK.INC<\/strong> dan <strong>PERCENTRANK.EXC<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25852 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rang-centile3.jpg\" alt=\"\" width=\"505\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ada dua hal yang perlu diperhatikan di sini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Fungsi <strong>PERCENTILE.INC<\/strong> mengembalikan nilai yang sama persis dengan fungsi <strong>PERCENTRANK<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Fungsi <strong>PERCENTILE.EXC<\/strong> tidak mengembalikan nilai 0 dan 1 untuk nilai terkecil dan terbesar dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan dokumentasi lengkap fungsi <strong>PERCENTRANK<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/percentrank-function-f1b5836c-9619-4847-9fc9-080ec9024442\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/mengkonversi-persentil-z-skor-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengkonversi antara skor Z dan persentil 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 di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi PERCENTRANK di Excel untuk menghitung peringkat nilai dalam kumpulan data sebagai persentase dari total kumpulan data. Fungsi ini menggunakan sintaks dasar berikut: =PERCENTRANK( A2:A16 , A2 ) Contoh khusus ini menghitung peringkat persentil nilai A2 dalam rentang A2:A16 . Ada juga dua fungsi peringkat persentil lainnya di Excel: PERCENTRANK.INC : Menghitung [&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 Peringkat Persentil di Excel (beserta Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung peringkat persentil di Excel, beserta contohnya.\" \/>\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\/peringkat-persentil-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Peringkat Persentil di Excel (beserta Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung peringkat persentil di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T17:54:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rang-centile1.jpg\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/\",\"name\":\"Cara Menghitung Peringkat Persentil di Excel (beserta Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T17:54:29+00:00\",\"dateModified\":\"2023-07-19T17:54:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung peringkat persentil di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung peringkat persentil 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 Peringkat Persentil di Excel (beserta Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung peringkat persentil di Excel, beserta contohnya.","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\/peringkat-persentil-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Peringkat Persentil di Excel (beserta Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung peringkat persentil di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T17:54:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rang-centile1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/","url":"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/","name":"Cara Menghitung Peringkat Persentil di Excel (beserta Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T17:54:29+00:00","dateModified":"2023-07-19T17:54:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung peringkat persentil di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/peringkat-persentil-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung peringkat persentil 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\/2993"}],"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=2993"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2993\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}