{"id":3485,"date":"2023-07-17T06:01:43","date_gmt":"2023-07-17T06:01:43","guid":{"rendered":"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/"},"modified":"2023-07-17T06:01:43","modified_gmt":"2023-07-17T06:01:43","slug":"persentil-jika-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/","title":{"rendered":"Cara menggunakan rumus if persentil di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut untuk menjalankan fungsi IF Persentil<\/strong> di Excel:<\/span><\/p>\n

 =PERCENTILE(IF( GROUP_RANGE<\/span> = GROUP<\/span> , VALUES_RANGE<\/span> ), k)\n<\/strong><\/pre>\n
 Rumus ini mencari persentil ke-k dari semua nilai yang termasuk dalam kelompok tertentu.<\/span><\/p>\n
 Saat Anda mengetik rumus ini di sel di Google Sheets, Anda perlu menekan Ctrl + Shift + Enter<\/strong> karena ini adalah rumus array.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Fungsi persentil IF di Google Sheets<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki dataset berikut yang menunjukkan nilai ujian yang diperoleh 20 siswa kelas A atau kelas B:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang misalkan kita ingin mencari persentil ke-90 dari nilai ujian hanya pada siswa Kelas A.<\/span><\/p>\n
 Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel F2:<\/span><\/p>\n
 =PERCENTILE(IF( B2:B21<\/span> = E2<\/span> , C2:C21<\/span> ), 0.9<\/span> )<\/strong><\/span><\/pre>\n
 Setelah kita menekan Ctrl<\/strong> + Shift<\/strong> + Enter<\/strong> , persentil ke-90 nilai ujian siswa Kelas A akan ditampilkan:<\/span> <\/p>\n
\"Rumus<\/p>\n
 Dari hasil tersebut terlihat nilai persentil ke 90 nilai ujian Kelas A adalah 93,2<\/strong> .<\/span><\/p>\n
 Untuk menghitung persentil ke-90 nilai ujian Kelas B, kita cukup mengubah nilainya di sel E2.<\/span><\/p>\n
 Rumusnya secara otomatis akan menghitung persentil ke-90 nilai ujian siswa Kelas B:<\/span> <\/p>\n
\"\"<\/p>\n
 Terlihat nilai persentil ke 90 nilai ujian Kelas B adalah 89,8<\/strong> .<\/span><\/p>\n
 Perhatikan bahwa dalam contoh ini kami telah memilih untuk menghitung persentil ke-90, namun Anda dapat menghitung persentil mana pun yang Anda inginkan.<\/span><\/p>\n
 Misalnya, untuk menghitung persentil ke-75 nilai ujian setiap kelas, Anda dapat mengganti 0,9<\/strong> dengan 0,75<\/strong> dalam rumusnya.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menghitung ringkasan lima digit di Google Sheets<\/a>
 Cara Menghitung Mean dan Deviasi Standar di Google Sheets<\/a>
 Cara menghitung desil di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
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 mengetik rumus ini di sel di Google Sheets, Anda perlu menekan Ctrl + Shift + Enter karena ini adalah rumus […]<\/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":"\nCara menggunakan rumus IF persentil di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF persentil di Google Sheets, beserta contoh lengkapnya.\" \/>\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-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan rumus IF persentil di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF persentil di Google Sheets, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T06:01:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/percentileif1.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=\"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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/\",\"name\":\"Cara menggunakan rumus IF persentil di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T06:01:43+00:00\",\"dateModified\":\"2023-07-17T06:01:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi IF persentil di Google Sheets, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan rumus if 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 menggunakan rumus IF persentil di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi IF persentil di Google Sheets, beserta contoh lengkapnya.","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-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan rumus IF persentil di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi IF persentil di Google Sheets, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-17T06:01:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/percentileif1.jpg"}],"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-google-sheet\/","url":"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/","name":"Cara menggunakan rumus IF persentil di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T06:01:43+00:00","dateModified":"2023-07-17T06:01:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi IF persentil di Google Sheets, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentil-jika-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan rumus if 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\/3485"}],"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=3485"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3485\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}