{"id":1055,"date":"2023-07-27T20:11:56","date_gmt":"2023-07-27T20:11:56","guid":{"rendered":"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/"},"modified":"2023-07-27T20:11:56","modified_gmt":"2023-07-27T20:11:56","slug":"lima-digit-melanjutkan-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/","title":{"rendered":"Cara menghitung ringkasan lima digit di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Ringkasan lima digit<\/strong> adalah cara meringkas sekumpulan data menggunakan lima nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Minimum<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuartil pertama<\/span><\/li>\n<li> <span style=\"color: #000000;\">median<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuartil ketiga<\/span><\/li>\n<li> <span style=\"color: #000000;\">Maksimal<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ringkasan lima angka berguna karena memberikan ringkasan singkat tentang distribusi data sebagai berikut:<\/span><\/p>\n<ul>\n<li> Ini memberi tahu kita di mana <a href=\"https:\/\/statorials.org\/id\/mengukur-tendensi-sentral\/\" target=\"_blank\" rel=\"noopener noreferrer\">nilai median<\/a> <span style=\"color: #000000;\">berada<\/span> <span style=\"color: #000000;\">, menggunakan median.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ini memberitahu kita<\/span> distribusi <span style=\"color: #000000;\">data, menggunakan kuartil pertama dan ketiga.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ini memberi tahu kita rentang data, menggunakan minimum dan maksimum.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Hanya dengan mengetahui kelima nilai ini, kita dapat belajar banyak tentang suatu kumpulan data.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Cara menemukan ringkasan lima digit di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan langkah-langkah berikut untuk menemukan ringkasan lima digit kumpulan data di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan semua nilai data dalam satu kolom.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai dataset dalam kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10868 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsumfeuilles1.png\" alt=\"\" width=\"391\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung ringkasan dalam lima angka.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Lima nilai dari ringkasan lima angka ditampilkan di kolom D, dan rumus yang digunakan untuk mencari nilai ini ditampilkan di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10869 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsumfeuilles2.png\" alt=\"Ringkasan Lima Angka di Google Spreadsheet\" width=\"555\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jadi, ringkasan lima angka dari kumpulan data ini adalah:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Minimal: <strong>4<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuartil pertama: <strong>7,5<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Median: <strong>17<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuartil ke-3: <strong>22<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Maksimum: <strong>28<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dari kelima angka tersebut, kita dapat mengetahui di mana letak pusat kumpulan data, sebaran nilai, dan rentang nilai.<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Catatan teknis:<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada dua fungsi kuartil di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>QUARTILE.INC()<\/strong> \u2013 Menghitung persentil menggunakan \u201clebih besar dari atau sama dengan\u201d dengan cara yang \u201cinklusif\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>QUARTILE.EXC()<\/strong> \u2013 Menghitung persentil menggunakan \u201clebih besar dari\u201d \u201csecara eksklusif\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>QUARTILE()<\/strong> default menggunakan metode <strong>QUARTILE.INC()<\/strong> .<\/span><\/p>\n<\/blockquote>\n<h3> <span style=\"color: #000000;\"><strong>Visualisasikan ringkasan lima angka<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Salah satu cara paling sederhana untuk memvisualisasikan ringkasan lima digit adalah dengan membuat<\/span> <a href=\"https:\/\/statorials.org\/id\/kumis-kotak\/\" target=\"_blank\" rel=\"noopener noreferrer\">plot kotak<\/a> <span style=\"color: #000000;\">, yang menggunakan kotak dengan garis di tengahnya bersama dengan &#8220;kumis&#8221; yang memanjang dari setiap ujungnya untuk mewakili nilai minimum dan maksimum.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-573 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boite-a-moustaches.png\" alt=\"\" width=\"373\" height=\"107\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menggunakan <a href=\"https:\/\/statorials.org\/id\/pembuat-plot-kotak\/\" target=\"_blank\" rel=\"noopener noreferrer\">Statistical Boxplot Generator<\/a> untuk secara otomatis membuat boxplot untuk kumpulan data tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat mengikuti <a href=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener noreferrer\">tutorial ini<\/a> untuk mempelajari cara membuat plot kotak di Google Spreadsheet untuk kumpulan data tertentu.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ringkasan lima digit adalah cara meringkas sekumpulan data menggunakan lima nilai berikut: Minimum Kuartil pertama median Kuartil ketiga Maksimal Ringkasan lima angka berguna karena memberikan ringkasan singkat tentang distribusi data sebagai berikut: Ini memberi tahu kita di mana nilai median berada , menggunakan median. Ini memberitahu kita distribusi data, menggunakan kuartil pertama dan ketiga. Ini [&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 ringkasan lima digit di Google Sheets<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung ringkasan lima angka 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\/lima-digit-melanjutkan-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung ringkasan lima digit di Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung ringkasan lima angka di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T20:11:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsumfeuilles1.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\/lima-digit-melanjutkan-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\",\"name\":\"Cara menghitung ringkasan lima digit di Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T20:11:56+00:00\",\"dateModified\":\"2023-07-27T20:11:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung ringkasan lima angka di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung ringkasan lima digit 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 ringkasan lima digit di Google Sheets","description":"Penjelasan sederhana cara menghitung ringkasan lima angka 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\/lima-digit-melanjutkan-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung ringkasan lima digit di Google Sheets","og_description":"Penjelasan sederhana cara menghitung ringkasan lima angka di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-27T20:11:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsumfeuilles1.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\/lima-digit-melanjutkan-lembar-google\/","url":"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/","name":"Cara menghitung ringkasan lima digit di Google Sheets","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T20:11:56+00:00","dateModified":"2023-07-27T20:11:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung ringkasan lima angka di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung ringkasan lima digit 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\/1055"}],"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=1055"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1055\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}