{"id":1255,"date":"2023-07-27T03:08:15","date_gmt":"2023-07-27T03:08:15","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/"},"modified":"2023-07-27T03:08:15","modified_gmt":"2023-07-27T03:08:15","slug":"excel-menemukan-10-persen-teratas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/","title":{"rendered":"Cara menemukan 10% nilai teratas di kolom excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang, Anda mungkin ingin mencari 10% nilai teratas di kolom Excel. Untungnya, ada dua cara cepat untuk melakukan ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Gunakan Pemformatan Bersyarat &gt; Aturan Atas\/Bawah &gt; 10% Teratas<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2. Filter menggunakan =CELL &gt;=PERCENTILE(CELL RANGE, 0.9)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh penggunaan masing-masing metode ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Temukan 10% Nilai Teratas Menggunakan Pemformatan Bersyarat<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kolom Excel berikut yang berisi 20 nilai berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12396 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_1.png\" alt=\"\" width=\"444\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Salah satu cara mencari 10% nilai teratas di kolom ini adalah dengan menyorot semua nilai di kolom tersebut, lalu klik <strong>Conditional Formatting &gt; Top\/Bottom Rules &gt; Top 10%<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12397 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_2.png\" alt=\"Sorot 10% nilai teratas di Excel\" width=\"493\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul, Anda akan memiliki opsi untuk menyorot 10% nilai teratas menggunakan warna tertentu. Kami akan membiarkannya sebagai opsi default merah muda dengan teks merah tua dan klik OK:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12398 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_3.png\" alt=\"10 persen teratas di Excel\" width=\"406\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai di 10% teratas kolom ini adalah <strong>123<\/strong> dan <strong>143<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12399 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_4.png\" alt=\"Sorot 10 persen nilai teratas di Excel\" width=\"367\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Temukan 10% Nilai Teratas Menggunakan Rumus<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Cara lain untuk menemukan 10% nilai teratas dalam kolom adalah dengan membuat kolom baru berisi nilai TRUE dan FALSE yang menunjukkan apakah sel tertentu memiliki nilai pada persentil ke-90 atau lebih tinggi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12400 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_5.png\" alt=\"Temukan Nilai 10% Teratas di Kolom Excel\" width=\"382\" height=\"469\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik tab <strong>Data<\/strong> di sepanjang pita atas dan klik ikon <strong>Filter<\/strong> . Kita kemudian dapat memfilter kolom <strong>10% Teratas<\/strong> agar hanya menampilkan nilai yang BENAR:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12401 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_6.png\" alt=\"Filter 10 persen nilai teratas di Excel\" width=\"415\" height=\"545\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai di 10% teratas dari seluruh nilai adalah <strong>123<\/strong> dan <strong>143<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12402 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_7.png\" alt=\"Nilai di 10% teratas di Excel\" width=\"352\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan lebih banyak tutorial Excel di sini<\/em> .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Terkadang, Anda mungkin ingin mencari 10% nilai teratas di kolom Excel. Untungnya, ada dua cara cepat untuk melakukan ini: 1. Gunakan Pemformatan Bersyarat &gt; Aturan Atas\/Bawah &gt; 10% Teratas 2. Filter menggunakan =CELL &gt;=PERCENTILE(CELL RANGE, 0.9) Tutorial ini memberikan contoh penggunaan masing-masing metode ini. Contoh 1: Temukan 10% Nilai Teratas Menggunakan Pemformatan Bersyarat Katakanlah kita [&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 menemukan 10% nilai teratas di kolom Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan 10% nilai teratas di kolom 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\/excel-menemukan-10-persen-teratas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menemukan 10% nilai teratas di kolom Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan 10% nilai teratas di kolom Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T03:08:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_1.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\/excel-menemukan-10-persen-teratas\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/\",\"name\":\"Cara menemukan 10% nilai teratas di kolom Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T03:08:15+00:00\",\"dateModified\":\"2023-07-27T03:08:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan 10% nilai teratas di kolom Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menemukan 10% nilai teratas di kolom 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 menemukan 10% nilai teratas di kolom Excel","description":"Tutorial ini menjelaskan cara menemukan 10% nilai teratas di kolom 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\/excel-menemukan-10-persen-teratas\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menemukan 10% nilai teratas di kolom Excel","og_description":"Tutorial ini menjelaskan cara menemukan 10% nilai teratas di kolom Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/","og_site_name":"Statorials","article_published_time":"2023-07-27T03:08:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10_1.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\/excel-menemukan-10-persen-teratas\/","url":"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/","name":"Cara menemukan 10% nilai teratas di kolom Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T03:08:15+00:00","dateModified":"2023-07-27T03:08:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan 10% nilai teratas di kolom Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menemukan 10% nilai teratas di kolom 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\/1255"}],"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=1255"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1255\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}