{"id":882,"date":"2023-07-28T10:53:18","date_gmt":"2023-07-28T10:53:18","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-titik-excel\/"},"modified":"2023-07-28T10:53:18","modified_gmt":"2023-07-28T10:53:18","slug":"grafik-titik-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-titik-excel\/","title":{"rendered":"Cara membuat plot titik di excel"},"content":{"rendered":"

<\/p>\n

\n

Plot titik<\/strong> adalah jenis plot yang menampilkan frekuensi menggunakan titik.<\/span><\/p>\n

Tutorial ini menjelaskan cara membuat plot titik berikut di Excel:<\/span> <\/p>\n

\"Plot<\/p>\n

Contoh: merencanakan titik-titik di Excel<\/strong><\/span><\/h3>\n

Misalkan kita memiliki tabel frekuensi berikut di Excel:<\/span> <\/p>\n

\"\"<\/p>\n

Ikuti langkah-langkah berikut untuk membuat plot titik untuk tabel frekuensi ini.<\/span><\/p>\n

Langkah 1: Atur ulang data.<\/strong><\/span><\/p>\n

Pertama, kita perlu mengatur ulang data ke dalam format “panjang”:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Buat plot sebar menggunakan opsi \u201csebar\u201d.<\/strong><\/span><\/p>\n

Sorot sel D2:E17. Di pita atas, klik Sisipkan<\/strong> . Di grup Charts<\/strong> , pilih grafik pertama di grup Scatter<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Akan muncul plot berikut:<\/span> <\/p>\n

\"Plot<\/p>\n

Langkah 3: Sesuaikan grafik.<\/strong><\/span><\/p>\n

Terakhir, kita dapat menyesuaikan grafik agar lebih menarik secara visual. Untuk mengetahui:<\/span><\/p>\n

    \n
  • Hapus garis kisi.<\/span><\/li>\n
  • Hapus judulnya.<\/span><\/li>\n
  • Tingkatkan ukuran poin individual.<\/span><\/li>\n
  • Ubah sumbu X sehingga hanya memanjang dari 1 hingga 7.<\/span><\/li>\n<\/ul>\n

    Ini akan meninggalkan kita dengan plot poin yang terlihat seperti ini:<\/span> <\/p>\n

    \"Plot<\/p>\n

    Nilai individual ditampilkan di sepanjang sumbu x dan frekuensi nilai ini diwakili oleh jumlah titik.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    Plot titik adalah jenis plot yang menampilkan frekuensi menggunakan titik. Tutorial ini menjelaskan cara membuat plot titik berikut di Excel: Contoh: merencanakan titik-titik di Excel Misalkan kita memiliki tabel frekuensi berikut di Excel: Ikuti langkah-langkah berikut untuk membuat plot titik untuk tabel frekuensi ini. Langkah 1: Atur ulang data. Pertama, kita perlu mengatur ulang data […]<\/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":"\nCara Membuat Dot Plot di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat dot plot di Excel.\" \/>\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\/grafik-titik-excel\/\" \/>\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 Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat dot plot di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-titik-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T10:53:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dotplotexcel5.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\/grafik-titik-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-titik-excel\/\",\"name\":\"Cara Membuat Dot Plot di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T10:53:18+00:00\",\"dateModified\":\"2023-07-28T10:53:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat dot plot di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-titik-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-titik-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-titik-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot titik 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 Membuat Dot Plot di Excel \u2013 Statologi","description":"Penjelasan sederhana cara membuat dot plot di Excel.","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\/grafik-titik-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Dot Plot di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara membuat dot plot di Excel.","og_url":"https:\/\/statorials.org\/id\/grafik-titik-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T10:53:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dotplotexcel5.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\/grafik-titik-excel\/","url":"https:\/\/statorials.org\/id\/grafik-titik-excel\/","name":"Cara Membuat Dot Plot di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T10:53:18+00:00","dateModified":"2023-07-28T10:53:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat dot plot di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-titik-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-titik-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-titik-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot titik 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\/882"}],"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=882"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/882\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}