{"id":1056,"date":"2023-07-27T20:09:16","date_gmt":"2023-07-27T20:09:16","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/"},"modified":"2023-07-27T20:09:16","modified_gmt":"2023-07-27T20:09:16","slug":"plot-kotak-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/","title":{"rendered":"Cara membuat plot kotak di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Plot<\/strong> <strong>kotak<\/strong> adalah jenis bagan yang dapat kita gunakan untuk memvisualisasikan <a href=\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\" target=\"_blank\" rel=\"noopener noreferrer\">ringkasan lima digit<\/a> kumpulan data, yang meliputi:<\/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;\">Tutorial ini menjelaskan cara membuat plot kotak di Google Sheets.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: Boxplot di Google Sheets<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk membuat plot kotak 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 nilai kumpulan data Anda di 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=\"425\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung ringkasan lima angka<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Biasanya, kita perlu mengetahui nilai median kumpulan data untuk membuat plot kotak, namun seperti yang akan kita lihat di langkah berikutnya, kita akan menggunakan diagram kandil untuk membuat sesuatu yang tampak seperti plot kotak, karena Google Spreadsheet tidak memilikinya. opsi bagan kotak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk membuat grafik candlestick, kita hanya perlu mengetahui nilai minimum, kuartil ke-1, kuartil ke-3, dan nilai maksimum dari suatu kumpulan data. Gambar berikut menunjukkan rumus yang digunakan untuk menghitung angka-angka ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10873 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boxplotfeuilles1.png\" alt=\"\" width=\"569\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Buat plot kotak.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai di kolom <em>A<\/em> hingga <em>E<\/em> pada baris pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-10874 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boxplotfeuilles2.png\" alt=\"\" width=\"568\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Bagan<\/strong> di menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10875 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boxplotfeuilles3.png\" alt=\"\" width=\"437\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, klik menu drop-down <strong>Chart Type<\/strong> , lalu klik jenis grafik berlabel <strong>Candlestick Chart<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10876 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boxplotfeuilles4.png\" alt=\"\" width=\"275\" height=\"587\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengkliknya, grafik berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10877 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boxplotfeuilles5.png\" alt=\"Boxplot di Google Spreadsheet\" width=\"505\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cara menginterpretasikan grafik tersebut adalah sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Baris teratas meluas ke nilai maksimum kumpulan data ( <strong>28<\/strong> )<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bagian atas kotak melambangkan nilai kuartil ketiga ( <strong>22<\/strong> )<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bagian bawah kotak mewakili nilai kuartil pertama ( <strong>7.5<\/strong> )<\/span><\/li>\n<li> <span style=\"color: #000000;\">Intinya meluas ke nilai minimum kumpulan data ( <strong>4<\/strong> )<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Di subbagian <strong>Sesuaikan<\/strong> pada jendela <strong>Editor Bagan<\/strong> di sisi kanan layar, Anda juga dapat mengedit plot untuk menyertakan judul, menyesuaikan garis kisi, dan mengubah label sumbu.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara membuat bagan umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/diagram-lingkaran-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Diagram Lingkaran di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Titik di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plot kotak adalah jenis bagan yang dapat kita gunakan untuk memvisualisasikan ringkasan lima digit kumpulan data, yang meliputi: Minimum Kuartil pertama median Kuartil ketiga Maksimal Tutorial ini menjelaskan cara membuat plot kotak di Google Sheets. Contoh: Boxplot di Google Sheets Ikuti langkah-langkah berikut untuk membuat plot kotak di Google Spreadsheet. Langkah 1: Masukkan datanya. Pertama [&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 Membuat Plot Kotak di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat box plot 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\/plot-kotak-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Kotak di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat box plot di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T20:09:16+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\/plot-kotak-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\",\"name\":\"Cara Membuat Plot Kotak di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T20:09:16+00:00\",\"dateModified\":\"2023-07-27T20:09:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat box plot di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot kotak 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 Membuat Plot Kotak di Google Sheets \u2013 Statologi","description":"Penjelasan sederhana cara membuat box plot 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\/plot-kotak-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Kotak di Google Sheets \u2013 Statologi","og_description":"Penjelasan sederhana cara membuat box plot di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-27T20:09:16+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\/plot-kotak-lembar-google\/","url":"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/","name":"Cara Membuat Plot Kotak di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T20:09:16+00:00","dateModified":"2023-07-27T20:09:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat box plot di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot kotak 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\/1056"}],"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=1056"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1056\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}