{"id":722,"date":"2023-07-28T23:48:31","date_gmt":"2023-07-28T23:48:31","guid":{"rendered":"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/"},"modified":"2023-07-28T23:48:31","modified_gmt":"2023-07-28T23:48:31","slug":"frekuensi-poligon-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/","title":{"rendered":"Cara membuat poligon frekuensi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Poligon frekuensi<\/strong> adalah jenis grafik yang membantu kita memvisualisasikan distribusi nilai.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7263 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly7.png\" alt=\"Poligon frekuensi di Excel\" width=\"452\" height=\"308\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara membuat poligon frekuensi di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Poligon frekuensi di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gunakan langkah-langkah berikut untuk membuat poligon frekuensi.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan data untuk tabel frekuensi.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Masukkan data berikut untuk tabel frekuensi yang memperlihatkan jumlah siswa yang memperoleh nilai tertentu pada suatu ujian:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7256 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly1-1.png\" alt=\"Tabel frekuensi di Excel\" width=\"381\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan titik tengah setiap kelas.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, gunakan fungsi <strong>=<\/strong> <b>AVERAGE()<\/b> di Excel untuk mencari <a href=\"https:\/\/statorials.org\/id\/tengah-kelas\/\" target=\"_blank\" rel=\"noopener\">titik tengah<\/a> setiap kelas, yang mewakili angka tengah di setiap kelas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7257 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly2.png\" alt=\"Tabel frekuensi median\" width=\"475\" height=\"353\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Buat poligon frekuensi.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat poligon frekuensi. Sorot nilai frekuensi di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7258 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly3.png\" alt=\"Tabel frekuensi di Excel\" width=\"402\" height=\"375\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu masuk ke grup <strong>Charts<\/strong> pada tab <strong>Insert<\/strong> dan klik tipe chart pertama di <strong>Insert Line or Area Chart<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7259 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly4.png\" alt=\"Poligon frekuensi di Excel\" width=\"657\" height=\"220\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Poligon frekuensi secara otomatis akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7260 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly5.png\" alt=\"Poligon frekuensi di Excel\" width=\"531\" height=\"501\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubah label sumbu X, klik kanan di mana saja pada grafik dan klik <strong>Pilih Data<\/strong> . Jendela baru akan muncul. Di bawah <strong>Label Sumbu Horizontal (Kategori),<\/strong> klik <strong>Edit<\/strong> dan masukkan rentang sel yang berisi nilai titik tengah. Klik <strong>OK<\/strong> dan label sumbu baru akan otomatis muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7261\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly6.png\" alt=\"Poligon frekuensi dengan titik tengah di Excel\" width=\"468\" height=\"277\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengedit judul bagan, menambahkan label sumbu, dan mengubah warna plot agar lebih estetis.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7263 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly7.png\" alt=\"Poligon frekuensi di Excel\" width=\"456\" height=\"311\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari poligon frekuensi kita dapat dengan mudah melihat bahwa sebagian besar siswa mendapat nilai di tahun 70an dan 80an, dan hanya sedikit yang mendapat nilai di tahun 60an dan bahkan lebih sedikit lagi di tahun 50an dan 90an.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Poligon frekuensi adalah jenis grafik yang membantu kita memvisualisasikan distribusi nilai. Tutorial ini menjelaskan cara membuat poligon frekuensi di Excel. Contoh: Poligon frekuensi di Excel Gunakan langkah-langkah berikut untuk membuat poligon frekuensi. Langkah 1: Masukkan data untuk tabel frekuensi. Masukkan data berikut untuk tabel frekuensi yang memperlihatkan jumlah siswa yang memperoleh nilai tertentu pada suatu [&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 Poligon Frekuensi di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat poligon frekuensi 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\/frekuensi-poligon-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Poligon Frekuensi di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat poligon frekuensi di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T23:48:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly7.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\/frekuensi-poligon-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/\",\"name\":\"Cara Membuat Poligon Frekuensi di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T23:48:31+00:00\",\"dateModified\":\"2023-07-28T23:48:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat poligon frekuensi di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat poligon frekuensi 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 Poligon Frekuensi di Excel \u2013 Statorials","description":"Penjelasan sederhana cara membuat poligon frekuensi 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\/frekuensi-poligon-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Poligon Frekuensi di Excel \u2013 Statorials","og_description":"Penjelasan sederhana cara membuat poligon frekuensi di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T23:48:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencepoly7.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\/frekuensi-poligon-excel\/","url":"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/","name":"Cara Membuat Poligon Frekuensi di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T23:48:31+00:00","dateModified":"2023-07-28T23:48:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat poligon frekuensi di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat poligon frekuensi 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\/722"}],"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=722"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/722\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}