{"id":2858,"date":"2023-07-20T09:20:16","date_gmt":"2023-07-20T09:20:16","guid":{"rendered":"https:\/\/statorials.org\/id\/daun-google-kuintil\/"},"modified":"2023-07-20T09:20:16","modified_gmt":"2023-07-20T09:20:16","slug":"daun-google-kuintil","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/daun-google-kuintil\/","title":{"rendered":"Cara menghitung kuintil di google sheets"},"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<ul>\n<li> <span style=\"color: #000000;\">Kuintil pertama adalah titik di mana 20% dari seluruh nilai data berada di bawahnya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuintil kedua adalah titik di mana 40% dari seluruh nilai data berada di bawah.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuintil ketiga adalah titik di mana 60% dari seluruh nilai data berada di bawah.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuintil keempat adalah titik di mana 80% dari seluruh nilai data berada di bawah.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus dasar berikut untuk menghitung kuintil suatu kumpulan data di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=PERCENTILE( <span style=\"color: #ff6600;\">CELL RANGE<\/span> , <span style=\"color: #3366ff;\">QUINTILE<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan rumus berikut untuk menghitung kuantil pertama dari rentang <strong>A1:A10<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=PERCENTILE( <span style=\"color: #ff6600;\">A1:A10<\/span> , <span style=\"color: #3366ff;\">0.2<\/span> )<\/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 Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet dengan 20 nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25020 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintile1.jpg\" alt=\"\" width=\"538\" height=\"506\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung kuintil untuk kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25021\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintile2.jpg\" alt=\"kuintil di Google Spreadsheet\" width=\"546\" height=\"509\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan nilai kuintil:<\/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>= <span class=\" default-formula-text-color\" dir=\"auto\">ArrayFormula<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> PERCENTILE( <span style=\"color: #ff6600;\">$A$2:$A$21<\/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-25022 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintile3.jpg\" alt=\"\" width=\"624\" height=\"504\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai kuintil ini sesuai dengan yang kami hitung sebelumnya.<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung ringkasan lima digit di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/desil-di-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung desil di Google Sheets<\/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. Kuintil ketiga adalah titik di mana 60% dari seluruh nilai data [&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 Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung kuintil 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\/daun-google-kuintil\/\" \/>\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 Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung kuintil di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/daun-google-kuintil\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T09:20:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintile1.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\/daun-google-kuintil\/\",\"url\":\"https:\/\/statorials.org\/id\/daun-google-kuintil\/\",\"name\":\"Cara menghitung kuintil di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T09:20:16+00:00\",\"dateModified\":\"2023-07-20T09:20:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung kuintil di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/daun-google-kuintil\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/daun-google-kuintil\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/daun-google-kuintil\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kuintil 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 kuintil di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung kuintil 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\/daun-google-kuintil\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung kuintil di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung kuintil di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/daun-google-kuintil\/","og_site_name":"Statorials","article_published_time":"2023-07-20T09:20:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quintile1.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\/daun-google-kuintil\/","url":"https:\/\/statorials.org\/id\/daun-google-kuintil\/","name":"Cara menghitung kuintil di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T09:20:16+00:00","dateModified":"2023-07-20T09:20:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung kuintil di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/daun-google-kuintil\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/daun-google-kuintil\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/daun-google-kuintil\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kuintil 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\/2858"}],"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=2858"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2858\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}