{"id":720,"date":"2023-07-28T23:57:58","date_gmt":"2023-07-28T23:57:58","guid":{"rendered":"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/"},"modified":"2023-07-28T23:57:58","modified_gmt":"2023-07-28T23:57:58","slug":"frekuensi-relatif-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/","title":{"rendered":"Cara menghitung frekuensi relatif di excel"},"content":{"rendered":"

<\/p>\n

\n

Tabel frekuensi<\/strong> adalah tabel yang menampilkan informasi tentang frekuensi. Frekuensi hanya memberi tahu kita berapa kali suatu peristiwa tertentu telah terjadi.<\/span><\/p>\n

Misalnya<\/span> , tabel berikut menunjukkan berapa banyak item yang dijual toko dalam rentang harga berbeda dalam minggu tertentu:<\/span><\/p>\n\n\n\n\n\n\n\n\n
Harga barang<\/strong><\/span><\/th>\n Frekuensi<\/strong><\/span><\/th>\n<\/tr>\n
$1 \u2013 $10<\/span><\/td>\n 20<\/span><\/td>\n<\/tr>\n
$11 \u2013 $20<\/span><\/td>\n 21<\/span><\/td>\n<\/tr>\n
$21 \u2013 $30<\/span><\/td>\n 13<\/span><\/td>\n<\/tr>\n
$31 \u2013 $40<\/span><\/td>\n 8<\/span><\/td>\n<\/tr>\n
$41 \u2013 $50<\/span><\/td>\n 4<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Kolom pertama menampilkan kelas harga dan kolom kedua menampilkan frekuensi kelas tersebut.<\/span><\/p>\n

Dimungkinkan juga untuk menghitung frekuensi relatif<\/strong> untuk setiap kelas, yang merupakan frekuensi setiap kelas sebagai persentase dari keseluruhan.<\/span><\/p>\n\n\n\n\n\n\n\n\n
Harga barang<\/strong><\/span><\/th>\n Frekuensi<\/strong><\/span><\/th>\n Frekuensi relatif<\/strong><\/span><\/th>\n<\/tr>\n
$1 \u2013 $10<\/span><\/td>\n 20<\/span><\/td>\n 0,303<\/span><\/td>\n<\/tr>\n
$11 \u2013 $20<\/span><\/td>\n 21<\/span><\/td>\n 0,318<\/span><\/td>\n<\/tr>\n
$21 \u2013 $30<\/span><\/td>\n 13<\/span><\/td>\n 0,197<\/span><\/td>\n<\/tr>\n
$31 \u2013 $40<\/span><\/td>\n 8<\/span><\/td>\n 0,121<\/span><\/td>\n<\/tr>\n
$41 \u2013 $50<\/span><\/td>\n 4<\/span><\/td>\n 0,061<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Sebanyak 66 item terjual. Jadi, kami mencari frekuensi relatif setiap kelas dengan mengambil frekuensi setiap kelas dan membaginya dengan jumlah total barang yang terjual.<\/span><\/p>\n

Misalnya, 20 item dijual dalam kisaran harga $1 hingga $10. Jadi, frekuensi relatif kelas $1 \u2013 $10 adalah 20 \/ 66 = 0,303<\/strong> .<\/span><\/p>\n

Kemudian, 21 item dijual dengan kisaran harga $11 hingga $20. Jadi frekuensi relatif kelas $11 \u2013 $20 adalah 21 \/ 66 = 0,318<\/strong> .<\/span><\/p>\n

Contoh berikut mengilustrasikan cara menemukan frekuensi relatif di Excel.<\/span><\/p>\n

Contoh: frekuensi relatif di Excel<\/strong><\/span><\/h3>\n

Pertama, kita akan memasukkan kelas dan frekuensi pada kolom A dan B:<\/span> <\/p>\n

\"Tabel<\/p>\n

Selanjutnya kita akan menghitung frekuensi relatif masing-masing kelas pada kolom C. Kolom D menunjukkan rumus yang kita gunakan:<\/span> <\/p>\n

\"Perhitungan<\/p>\n

Kami dapat memverifikasi kebenaran perhitungan kami dengan memastikan bahwa jumlah frekuensi relatif berjumlah 1:<\/span> <\/p>\n

\"Perhitungan<\/p>\n

Kita juga dapat membuat histogram frekuensi relatif untuk memvisualisasikan frekuensi relatif.<\/span><\/p>\n

Cukup sorot frekuensi relatifnya:<\/span> <\/p>\n

\"Histogram<\/p>\n

Lalu pergi ke grup Charts<\/strong> pada tab Insert<\/strong> dan klik pada tipe chart pertama di Insert Column atau Bar Chart<\/strong> :<\/span> <\/p>\n

\"Histogram<\/p>\n

Histogram frekuensi relatif akan otomatis muncul:<\/span> <\/p>\n

\"Frekuensi<\/p>\n

Ubah label sumbu X dengan mengklik kanan diagram dan mengklik Pilih Data<\/strong> . Di bawah Label Sumbu Horizontal (Kategori),<\/strong> klik Edit<\/strong> dan masukkan rentang sel yang berisi harga barang. Klik OK<\/strong> dan label sumbu baru akan otomatis muncul:<\/span> <\/p>\n

\"Histogram<\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Kalkulator frekuensi relatif<\/a>
Histogram frekuensi relatif: definisi + contoh<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Tabel frekuensi adalah tabel yang menampilkan informasi tentang frekuensi. Frekuensi hanya memberi tahu kita berapa kali suatu peristiwa tertentu telah terjadi. Misalnya , tabel berikut menunjukkan berapa banyak item yang dijual toko dalam rentang harga berbeda dalam minggu tertentu: Harga barang Frekuensi $1 \u2013 $10 20 $11 \u2013 $20 21 $21 \u2013 $30 13 $31 […]<\/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 Menghitung Frekuensi Relatif di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung frekuensi relatif 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-relatif-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Frekuensi Relatif di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung frekuensi relatif di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T23:57:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/relfreqexcel1.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-relatif-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/\",\"name\":\"Cara Menghitung Frekuensi Relatif di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T23:57:58+00:00\",\"dateModified\":\"2023-07-28T23:57:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung frekuensi relatif di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung frekuensi relatif 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 Menghitung Frekuensi Relatif di Excel \u2013 Statologi","description":"Penjelasan sederhana tentang cara menghitung frekuensi relatif 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-relatif-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Frekuensi Relatif di Excel \u2013 Statologi","og_description":"Penjelasan sederhana tentang cara menghitung frekuensi relatif di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T23:57:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/relfreqexcel1.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-relatif-unggul\/","url":"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/","name":"Cara Menghitung Frekuensi Relatif di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T23:57:58+00:00","dateModified":"2023-07-28T23:57:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung frekuensi relatif di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung frekuensi relatif 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\/720"}],"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=720"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/720\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}