{"id":930,"date":"2023-07-28T06:59:12","date_gmt":"2023-07-28T06:59:12","guid":{"rendered":"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/"},"modified":"2023-07-28T06:59:12","modified_gmt":"2023-07-28T06:59:12","slug":"distribusi-frekuensi-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/","title":{"rendered":"Cara membuat distribusi frekuensi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Distribusi frekuensi<\/strong> menggambarkan seberapa sering nilai yang berbeda muncul dalam suatu kumpulan data. Ini adalah cara yang berguna untuk memahami bagaimana nilai data didistribusikan dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, mudah untuk membuat dan memvisualisasikan distribusi frekuensi di Excel menggunakan fungsi berikut:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>= FREKUENSI (data_array, bins_array)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>data_array<\/strong> : array nilai data mentah<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>bins_array:<\/strong> array batas atas untuk bin<\/span><\/li>\n<\/ul>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Contoh berikut mengilustrasikan cara menggunakan fungsi ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: distribusi frekuensi di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data 20 nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9851 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencedistexcel1.png\" alt=\"\" width=\"435\" height=\"494\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memberitahu Excel batas atas apa yang ingin kita gunakan pada bin distribusi frekuensi kita. Untuk contoh ini, kita akan memilih 10, 20 dan 30. Dengan kata lain, kita akan mencari frekuensi dari kelompok berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>0 hingga 10<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>11 hingga 20<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>21 hingga 30<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>30+<\/strong><\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9852 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencedistexcel2.png\" alt=\"\" width=\"377\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>=FREQUENCY()<\/strong> berikut untuk menghitung frekuensi setiap grup:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\">=FREKUENSI ( <span style=\"color: #0000ff;\">A2:A21<\/span> , <span style=\"color: #ff0000;\">C2:C4<\/span> )<\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Berikut hasilnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9853 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencedistexcel3.png\" alt=\"Distribusi frekuensi di Excel\" width=\"487\" height=\"542\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya menunjukkan bahwa:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>6<\/strong> nilai dalam dataset berada antara 0 dan 10.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>7<\/strong> nilai dalam kumpulan data berada di antara 11 dan 20.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>5<\/strong> nilai dalam kumpulan data berada di antara 21 dan 30.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> nilai dalam kumpulan data lebih besar dari 30.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan langkah-langkah berikut untuk memvisualisasikan distribusi frekuensi ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sorot jumlah frekuensi dalam rentang <strong>D2:D5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik tab <strong>Sisipkan<\/strong> , lalu klik bagan berlabel <strong>Kolom 2D<\/strong> di grup <strong>Bagan<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tabel berikut akan muncul dan menampilkan frekuensi untuk setiap bin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9854 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencedistexcel4.png\" alt=\"Visualisasikan distribusi frekuensi di Excel\" width=\"573\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk memodifikasi label sumbu dan lebar batang untuk membuat grafik lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9855 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencedistexcel5.png\" alt=\"Distribusi frekuensi di Excel\" width=\"453\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan lebih banyak tutorial Excel di sini .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi frekuensi menggambarkan seberapa sering nilai yang berbeda muncul dalam suatu kumpulan data. Ini adalah cara yang berguna untuk memahami bagaimana nilai data didistribusikan dalam kumpulan data. Untungnya, mudah untuk membuat dan memvisualisasikan distribusi frekuensi di Excel menggunakan fungsi berikut: = FREKUENSI (data_array, bins_array) Emas: data_array : array nilai data mentah bins_array: array batas atas [&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 Distribusi Frekuensi di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat dan memvisualisasikan distribusi frekuensi 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\/distribusi-frekuensi-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Distribusi Frekuensi di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat dan memvisualisasikan distribusi frekuensi di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T06:59:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencedistexcel1.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\/distribusi-frekuensi-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/\",\"name\":\"Cara Membuat Distribusi Frekuensi di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T06:59:12+00:00\",\"dateModified\":\"2023-07-28T06:59:12+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat dan memvisualisasikan distribusi frekuensi di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat distribusi 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 Distribusi Frekuensi di Excel \u2013 Statologi","description":"Penjelasan sederhana cara membuat dan memvisualisasikan distribusi frekuensi 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\/distribusi-frekuensi-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Distribusi Frekuensi di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara membuat dan memvisualisasikan distribusi frekuensi di Excel.","og_url":"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T06:59:12+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencedistexcel1.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\/distribusi-frekuensi-unggul\/","url":"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/","name":"Cara Membuat Distribusi Frekuensi di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T06:59:12+00:00","dateModified":"2023-07-28T06:59:12+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat dan memvisualisasikan distribusi frekuensi di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat distribusi 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\/930"}],"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=930"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/930\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}