{"id":597,"date":"2023-07-29T09:27:50","date_gmt":"2023-07-29T09:27:50","guid":{"rendered":"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/"},"modified":"2023-07-29T09:27:50","modified_gmt":"2023-07-29T09:27:50","slug":"lima-digit-resume-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/","title":{"rendered":"Cara menghitung rangkuman lima angka di excel"},"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> <span style=\"color: #000000;\">Ini memberi tahu kita di mana <a href=\"https:\/\/statorials.org\/id\/mengukur-tendensi-sentral\/\" target=\"_blank\" rel=\"noopener noreferrer\">nilai median<\/a> berada, dengan menggunakan median.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ini memberitahu kita distribusi 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<h2> <span style=\"color: #000000;\"><strong>Cara menemukan ringkasan lima digit di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menemukan ringkasan lima digit kumpulan data di Excel dengan mengikuti langkah-langkah berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai data dalam kolom.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5492 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum1.png\" alt=\"Cara Menghitung Rangkuman Lima Angka di Excel\" width=\"393\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan ringkasan 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-5493 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum2.png\" alt=\"Ringkasan lima angka dalam perhitungan Excel\" width=\"481\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jadi, ringkasan lima angka dari data ini adalah sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Minimal:<\/strong> 4<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Kuartil pertama:<\/strong> 7,5<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Median:<\/strong> 17<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Kuartil ke-3:<\/strong> 22<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Maksimum:<\/strong> 28<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Catatan teknis:<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara teknis ada dua fungsi kuartil di Excel:<\/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<h2> <span style=\"color: #000000;\"><strong>Visualisasikan ringkasan lima angka menggunakan plot kotak<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Salah satu cara paling sederhana untuk memvisualisasikan ringkasan lima angka adalah dengan membuat <a href=\"https:\/\/statorials.org\/id\/kumis-kotak\/\" target=\"_blank\" rel=\"noopener noreferrer\">plot kotak<\/a> , terkadang disebut plot kotak dan kumis, yang menggunakan kotak dengan garis di tengahnya bersama dengan &#8220;kumis&#8221; yang memanjang di setiap ujungnya.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-573 size-full\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boite-a-moustaches.png\" alt=\"Plot Kotak Dijelaskan\" width=\"401\" height=\"115\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat melakukan langkah-langkah berikut untuk membuat plot kotak di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Sorot nilai data.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5494 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum3.png\" alt=\"Plot kotak untuk ringkasan lima angka di Excel\" width=\"442\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Pada tab <em>Sisipkan<\/em> di grup <em>Bagan<\/em> di sepanjang pita atas, klik panah kecil di sudut kiri bawah untuk &#8220;Lihat Semua Bagan&#8221;.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5495 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum4.png\" alt=\"Bagan di Excel\" width=\"556\" height=\"322\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Pilih \u201cKotak &amp; Kumis\u201d dan klik OK.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5496 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsomme5.png\" alt=\"Plot kotak di Excel\" width=\"524\" height=\"494\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Plot kotak dan kumis akan otomatis ditampilkan.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5497 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum6.png\" alt=\"Plot kotak di Excel\" width=\"528\" height=\"513\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis tengah di kotak melambangkan nilai maksimum, bagian atas kotak melambangkan kuartil ke-3, garis tengah dalam kotak melambangkan median, tanda &#8220;x&#8221; kecil di dalam kotak melambangkan mean, bagian bawah kotak melambangkan kuartil ke-1, dan garis tengah melambangkan median. kumis bawah mewakili nilai minimum:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5498 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum7.png\" alt=\"Plot Kotak Ringkasan Lima Angka di Excel\" width=\"393\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat mengubah warna latar belakang dan judul bagan agar lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5500 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum8.png\" alt=\"Ringkasan lima angka menggunakan diagram kotak di Excel\" width=\"422\" height=\"578\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <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\/lima-nomor-melanjutkan-spss\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghitung ringkasan lima digit di SPSS<\/a><\/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, dengan 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 Rangkuman Lima Angka di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung ringkasan lima angka di Excel, termasuk contoh langkah demi langkah.\" \/>\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-resume-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rangkuman Lima Angka di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung ringkasan lima angka di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T09:27:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum1.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=\"2 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-resume-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\",\"name\":\"Cara Menghitung Rangkuman Lima Angka di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T09:27:50+00:00\",\"dateModified\":\"2023-07-29T09:27:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung ringkasan lima angka di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rangkuman lima angka di 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 Menghitung Rangkuman Lima Angka di Excel \u2013 Statologi","description":"Penjelasan sederhana cara menghitung ringkasan lima angka di Excel, termasuk contoh langkah demi langkah.","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-resume-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rangkuman Lima Angka di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara menghitung ringkasan lima angka di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T09:27:50+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cinqnumsum1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/","url":"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/","name":"Cara Menghitung Rangkuman Lima Angka di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T09:27:50+00:00","dateModified":"2023-07-29T09:27:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung ringkasan lima angka di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lima-digit-resume-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rangkuman lima angka di 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\/597"}],"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=597"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/597\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}