{"id":1621,"date":"2023-07-25T15:22:00","date_gmt":"2023-07-25T15:22:00","guid":{"rendered":"https:\/\/statorials.org\/id\/kuintil-excel\/"},"modified":"2023-07-25T15:22:00","modified_gmt":"2023-07-25T15:22:00","slug":"kuintil-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kuintil-excel\/","title":{"rendered":"Cara menghitung kuintil di excel: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, <strong>kuintil<\/strong> adalah angka yang membagi kumpulan data menjadi lima kelompok dengan frekuensi yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kuintil pertama adalah titik di mana 20% dari seluruh nilai data berada di bawahnya. Kuintil kedua adalah titik di mana 40% dari seluruh nilai data berada di bawah, dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi berikut untuk menghitung kuintil kumpulan data di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=PERCENTILE( <span style=\"color: #993300;\">CELL RANGE<\/span> , <span style=\"color: #3366ff;\">QUINTILE<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: menghitung kuintil di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut dengan 20 nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16053 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintileexcel1.png\" alt=\"\" width=\"491\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara menghitung kuintil untuk kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16054 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintileexcel2.png\" alt=\"\" width=\"578\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cara menafsirkan kuintil adalah sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">20% dari seluruh nilai data kurang dari <strong>6,8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">40% dari seluruh nilai data kurang dari <strong>14<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">60% dari seluruh nilai data kurang dari <strong>20,8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">80% dari seluruh nilai data kurang dari <strong>26,2<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggunakan rumus berikut untuk menghitung setiap kuintil secara bersamaan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=PERCENTILE( <span style=\"color: #993300;\">CELL RANGE<\/span> , { <span style=\"color: #3366ff;\">0.2, 0.4, 0.6, 0.8<\/span> })\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara melakukan ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16055 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintileexcel3.png\" alt=\"\" width=\"538\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kuintil yang dihitung di sini sesuai dengan kuintil yang kita hitung sebelumnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/desil-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung desil di excel<\/a><br \/> <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\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, kuintil adalah angka yang membagi kumpulan data menjadi lima kelompok dengan frekuensi yang sama. Kuintil pertama adalah titik di mana 20% dari seluruh nilai data berada di bawahnya. Kuintil kedua adalah titik di mana 40% dari seluruh nilai data berada di bawah, dan seterusnya. Kita dapat menggunakan fungsi berikut untuk menghitung kuintil kumpulan [&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 Kuintil di Excel: Dengan Contoh<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung kuintil di Excel, dengan beberapa 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\/kuintil-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Kuintil di Excel: Dengan Contoh\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung kuintil di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kuintil-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T15:22:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintileexcel1.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\/kuintil-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kuintil-excel\/\",\"name\":\"Cara Menghitung Kuintil di Excel: Dengan Contoh\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T15:22:00+00:00\",\"dateModified\":\"2023-07-25T15:22:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung kuintil di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kuintil-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kuintil-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kuintil-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kuintil 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 Kuintil di Excel: Dengan Contoh","description":"Tutorial ini menjelaskan cara menghitung kuintil di Excel, dengan beberapa 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\/kuintil-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Kuintil di Excel: Dengan Contoh","og_description":"Tutorial ini menjelaskan cara menghitung kuintil di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kuintil-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T15:22:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintileexcel1.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\/kuintil-excel\/","url":"https:\/\/statorials.org\/id\/kuintil-excel\/","name":"Cara Menghitung Kuintil di Excel: Dengan Contoh","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T15:22:00+00:00","dateModified":"2023-07-25T15:22:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung kuintil di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kuintil-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kuintil-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kuintil-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kuintil 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\/1621"}],"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=1621"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1621\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}