{"id":1057,"date":"2023-07-27T20:04:47","date_gmt":"2023-07-27T20:04:47","guid":{"rendered":"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/"},"modified":"2023-07-27T20:04:47","modified_gmt":"2023-07-27T20:04:47","slug":"rentang-interkuartil-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/","title":{"rendered":"Cara menghitung rentang interkuartil di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Rentang<\/strong> <strong>interkuartil<\/strong> , sering disebut IQR, adalah cara untuk mengukur distribusi 50% tengah kumpulan data. Ini dihitung sebagai selisih antara kuartil pertama (Q1) dan kuartil ketiga (Q3) dari kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <em>kuartil<\/em> hanyalah nilai yang membagi kumpulan data menjadi empat bagian yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">IQR sering digunakan untuk mengukur sebaran nilai dalam suatu kumpulan data, karena dikenal<a href=\"https:\/\/statorials.org\/id\/outlier-antarkuartil\/\" target=\"_blank\" rel=\"noopener noreferrer\">tahan terhadap outlier<\/a> . Karena hanya menunjukkan distribusi pada 50% tengah kumpulan data, maka tidak terpengaruh oleh outlier yang sangat kecil atau luar biasa besar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini menjadikannya cara yang lebih baik untuk mengukur dispersi dibandingkan dengan rentang seperti metrik, yang hanya memberi tahu kita perbedaan antara nilai terbesar dan terkecil dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung IQR untuk kumpulan data tertentu di Google Spreadsheet.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menghitung IQR di Google Sheets<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk menghitung rentang interkuartil (IQR) kumpulan data di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan semua nilai dari kumpulan data ke dalam satu kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10897 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iqrfeuilles1.png\" alt=\"\" width=\"384\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung kuartil pertama dan ketiga.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>QUARTILE()<\/strong> untuk menghitung kuartil pertama (Q1) dan ketiga (Q3) dari kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi ini menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>QUARTILE(data, angka_kuartil)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>data:<\/strong> array nilai data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>quartile_number:<\/strong> Kuartil yang akan dihitung<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan rumus yang digunakan untuk menghitung Q1 dan Q3 untuk kumpulan data ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10898 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iqrfeuilles2.png\" alt=\"Kuartil di Google Spreadsheet\" width=\"534\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung IQR.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat mengurangkan kuartil pertama (Q1) dari kuartil ketiga (Q3) untuk memperoleh rentang antarkuartil:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10899 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iqrfeuilles3.png\" alt=\"Rentang interkuartil (IQR) di Google Spreadsheet\" width=\"541\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rentang interkuartilnya adalah <strong>16<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberi tahu kita distribusi 50% tengah dari nilai dalam kumpulan data kita.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/\">Cara Menghitung Deviasi Standar di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghitung ringkasan lima digit di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Membuat Plot Kotak di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rentang interkuartil , sering disebut IQR, adalah cara untuk mengukur distribusi 50% tengah kumpulan data. Ini dihitung sebagai selisih antara kuartil pertama (Q1) dan kuartil ketiga (Q3) dari kumpulan data. Perhatikan bahwa kuartil hanyalah nilai yang membagi kumpulan data menjadi empat bagian yang sama. IQR sering digunakan untuk mengukur sebaran nilai dalam suatu kumpulan 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 Rentang Interkuartil di Google Spreadsheet<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung rentang interkuartil (IQR) di Google Sheets, 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\/rentang-interkuartil-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rentang Interkuartil di Google Spreadsheet\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung rentang interkuartil (IQR) di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T20:04:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iqrfeuilles1.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\/rentang-interkuartil-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\",\"name\":\"Cara Menghitung Rentang Interkuartil di Google Spreadsheet\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T20:04:47+00:00\",\"dateModified\":\"2023-07-27T20:04:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung rentang interkuartil (IQR) di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rentang interkuartil di google spreadsheet\"}]},{\"@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 Rentang Interkuartil di Google Spreadsheet","description":"Penjelasan sederhana cara menghitung rentang interkuartil (IQR) di Google Sheets, 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\/rentang-interkuartil-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rentang Interkuartil di Google Spreadsheet","og_description":"Penjelasan sederhana cara menghitung rentang interkuartil (IQR) di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T20:04:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iqrfeuilles1.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\/rentang-interkuartil-google-sheet\/","url":"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/","name":"Cara Menghitung Rentang Interkuartil di Google Spreadsheet","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T20:04:47+00:00","dateModified":"2023-07-27T20:04:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung rentang interkuartil (IQR) di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rentang interkuartil di google spreadsheet"}]},{"@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\/1057"}],"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=1057"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1057\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}