{"id":4212,"date":"2023-07-12T19:36:32","date_gmt":"2023-07-12T19:36:32","guid":{"rendered":"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/"},"modified":"2023-07-12T19:36:32","modified_gmt":"2023-07-12T19:36:32","slug":"peringkat-persentil-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/","title":{"rendered":"Cara menghitung peringkat persentil di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>PERCENTRANK<\/strong> di Google Spreadsheet untuk menghitung peringkat suatu 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: #ff6600;\">A2:A16<\/span> , <span style=\"color: #800080;\">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 Google Spreadsheet:<\/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<h2> <span style=\"color: #000000;\"><strong>Contoh: Hitung Peringkat Persentil di Google Spreadsheet<\/strong><\/span><\/h2>\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-33325 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc1.jpg\" alt=\"\" width=\"510\" height=\"457\" 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: #ff6600;\">$A$2:$A$16<\/span> , <span style=\"color: #800080;\">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-33327\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc2.jpg\" alt=\"peringkat persentil di Google Spreadsheet\" width=\"499\" height=\"481\" 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;\">Tangkapan layar berikut juga menunjukkan cara menggunakan fungsi <strong>PERCENTRANK.INC<\/strong> dan <strong>PERCENTRANK.EXC<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-33326\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc3.jpg\" alt=\"PERCENTRANK.INC vs. PERCENTRANK.EXC di Google Spreadsheet\" width=\"546\" height=\"484\" 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 untuk fungsi <strong>PERCENTRANK<\/strong> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/3094095?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/persentase-kumulatif-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Kumulatif di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-tertimbang-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung persentase tertimbang di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan rumus IF persentil di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi PERCENTRANK di Google Spreadsheet untuk menghitung peringkat suatu 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 Google Spreadsheet: [&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 Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung peringkat persentil di Google Sheets, 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\/peringkat-persentil-google-sheets\/\" \/>\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 Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung peringkat persentil di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T19:36:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc1.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-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/\",\"name\":\"Cara Menghitung Peringkat Persentil di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T19:36:32+00:00\",\"dateModified\":\"2023-07-12T19:36:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung peringkat persentil di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung peringkat persentil di google sheets\"}]},{\"@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 Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung peringkat persentil di Google Sheets, 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\/peringkat-persentil-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Peringkat Persentil di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung peringkat persentil di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-12T19:36:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/perc1.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-google-sheets\/","url":"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/","name":"Cara Menghitung Peringkat Persentil di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T19:36:32+00:00","dateModified":"2023-07-12T19:36:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung peringkat persentil di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/peringkat-persentil-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung peringkat persentil di google sheets"}]},{"@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\/4212"}],"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=4212"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4212\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}