{"id":2314,"date":"2023-07-22T19:44:25","date_gmt":"2023-07-22T19:44:25","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/"},"modified":"2023-07-22T19:44:25","modified_gmt":"2023-07-22T19:44:25","slug":"plot-titik-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/","title":{"rendered":"Cara membuat dot plot di google sheets (metode paling mudah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Plot titik<\/strong> adalah jenis plot yang menampilkan frekuensi menggunakan titik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat plot titik berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-21043\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle7.png\" alt=\"Merencanakan poin di Google Sheets\" width=\"544\" height=\"269\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki tabel frekuensi berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21037 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle1.png\" alt=\"\" width=\"463\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sebelum membuat plot titik, pertama-tama kita perlu mengatur ulang data ke dalam format &#8220;panjang&#8221;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21038 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle2.png\" alt=\"\" width=\"614\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Plot Titik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sorot sel <strong>E2:F17<\/strong> . Lalu klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Bagan<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21039 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle3.png\" alt=\"\" width=\"531\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Google Sheets akan menyisipkan histogram secara default. Untuk mengubahnya menjadi plot titik, klik di mana saja pada grafik, lalu klik tiga titik vertikal di sudut kanan atas, lalu klik <strong>Edit Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21040 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle4.png\" alt=\"\" width=\"585\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, klik opsi <strong>Chart Type<\/strong> lalu klik <strong>Scatter Plot<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21041 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle5.png\" alt=\"\" width=\"345\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21042 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle6.png\" alt=\"\" width=\"531\" height=\"337\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini adalah versi kasar dari plot titik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan Plot Titik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Lakukan perubahan berikut untuk membuat plot titik lebih estetis:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik dua kali label sumbu Y dan hapus.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik dua kali nilai pada sumbu y dan ubah nilai minimum menjadi 0,75 dan nilai maksimum menjadi 5.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik dua kali garis kisi mayor dan minor lalu hapus keduanya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik dua kali salah satu titik pada jalur dan ubah ukuran titik menjadi 14 piksel.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik dua kali judulnya dan ganti dengan nama yang Anda inginkan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Setelah kita melakukan setiap perubahan ini, seperti inilah diagram jahitan terakhir kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-21043\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle7.png\" alt=\"Merencanakan poin di Google Sheets\" width=\"544\" height=\"269\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai individual ditampilkan di sepanjang sumbu x dan frekuensi nilai ini diwakili oleh jumlah titik.<\/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 membuat visualisasi umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak di Google Sheets<\/a><br \/><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\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plot titik adalah jenis plot yang menampilkan frekuensi menggunakan titik. Contoh langkah demi langkah berikut menunjukkan cara membuat plot titik berikut di Google Spreadsheet: Langkah 1: Masukkan datanya Katakanlah kita memiliki tabel frekuensi berikut di Google Spreadsheet: Sebelum membuat plot titik, pertama-tama kita perlu mengatur ulang data ke dalam format &#8220;panjang&#8221;: Langkah 2: Buat Plot [&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 Dot Plot di Google Sheets (Metode Paling Mudah) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat plot titik di Google Sheets, dengan 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\/plot-titik-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 Dot Plot di Google Sheets (Metode Paling Mudah) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat plot titik di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T19:44:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle7.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-titik-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/\",\"name\":\"Cara Membuat Dot Plot di Google Sheets (Metode Paling Mudah) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T19:44:25+00:00\",\"dateModified\":\"2023-07-22T19:44:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat plot titik di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat dot plot di google sheets (metode paling mudah)\"}]},{\"@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 Dot Plot di Google Sheets (Metode Paling Mudah) \u2013 Statologi","description":"Tutorial ini menjelaskan cara membuat plot titik di Google Sheets, dengan 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\/plot-titik-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Dot Plot di Google Sheets (Metode Paling Mudah) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara membuat plot titik di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-22T19:44:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pointgoogle7.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-titik-lembar-google\/","url":"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/","name":"Cara Membuat Dot Plot di Google Sheets (Metode Paling Mudah) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T19:44:25+00:00","dateModified":"2023-07-22T19:44:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat plot titik di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-titik-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-titik-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat dot plot di google sheets (metode paling mudah)"}]},{"@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\/2314"}],"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=2314"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2314\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}