{"id":1317,"date":"2023-07-26T21:47:23","date_gmt":"2023-07-26T21:47:23","guid":{"rendered":"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/"},"modified":"2023-07-26T21:47:23","modified_gmt":"2023-07-26T21:47:23","slug":"frekuensi-kumulatif-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/","title":{"rendered":"Cara menghitung frekuensi kumulatif 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, tabel berikut menunjukkan jumlah barang yang dijual oleh sebuah toko dalam rentang harga yang berbeda pada 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 kumulatif<\/strong> untuk setiap kelas, yang merupakan jumlah frekuensi hingga kelas tertentu.<\/span><\/p>\n\n\n\n\n\n\n\n\n
Harga barang<\/strong><\/span><\/th>\n Frekuensi<\/strong><\/span><\/th>\n Frekuensi kumulatif<\/strong><\/span><\/th>\n<\/tr>\n
$1 \u2013 $10<\/span><\/td>\n 20<\/span><\/td>\n 20<\/span><\/td>\n<\/tr>\n
$11 \u2013 $20<\/span><\/td>\n 21<\/span><\/td>\n 41<\/span><\/td>\n<\/tr>\n
$21 \u2013 $30<\/span><\/td>\n 13<\/span><\/td>\n 54<\/span><\/td>\n<\/tr>\n
$31 \u2013 $40<\/span><\/td>\n 8<\/span><\/td>\n 62<\/span><\/td>\n<\/tr>\n
$41 \u2013 $50<\/span><\/td>\n 4<\/span><\/td>\n 66<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Misalnya, frekuensi kumulatif pertama sama dengan frekuensi pertama 20<\/strong> .<\/span><\/p>\n

Frekuensi kumulatif kedua adalah jumlah dua frekuensi pertama: 20 + 21 = 41<\/strong> .<\/span><\/p>\n

Frekuensi kumulatif ketiga adalah jumlah dari tiga frekuensi pertama: 20 + 21 + 13 = 54<\/strong> .<\/span><\/p>\n

Dan seterusnya.<\/span><\/p>\n

Contoh berikut menunjukkan cara menemukan frekuensi kumulatif di Excel.<\/span><\/p>\n

Contoh: frekuensi kumulatif 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 hitung frekuensi kumulatif tiap kelas pada kolom C.<\/span><\/p>\n

Pada gambar di bawah, kolom D menunjukkan rumus yang kami gunakan:<\/span> <\/p>\n

\"Frekuensi<\/p>\n

Anda juga dapat membuat grafik ogive<\/a> untuk memvisualisasikan frekuensi kumulatif.<\/span><\/p>\n

Untuk membuat diagram peluru, tahan CTRL dan sorot kolom A dan C.<\/span> <\/p>\n

\"\"<\/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

Di pita atas Excel, buka tab Sisipkan<\/strong> , lalu grup Bagan<\/strong> . Klik Scatter Cloud<\/strong> , lalu Scatter Cloud dengan Garis Lurus dan Marker<\/strong> .<\/span> <\/p>\n

\"\"<\/p>\n

Ini secara otomatis akan menghasilkan grafik ogive berikut:<\/span> <\/p>\n

\"Bagan<\/p>\n

Jangan ragu untuk memodifikasi sumbu dan judulnya agar grafiknya lebih estetis:<\/span> <\/p>\n

\"Kurva<\/p>\n

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

Kalkulator Frekuensi Kumulatif<\/a>
Cara Menghitung Frekuensi Relatif di Excel<\/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 jumlah barang yang dijual oleh sebuah toko dalam rentang harga yang berbeda pada minggu tertentu: Harga barang Frekuensi $1 \u2013 $10 20 $11 \u2013 $20 21 $21 \u2013 $30 13 […]<\/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 Kumulatif di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung frekuensi kumulatif di Excel, dengan sebuah contoh.\" \/>\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-kumulatif-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 Kumulatif di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung frekuensi kumulatif di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T21:47:23+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-kumulatif-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\",\"name\":\"Cara Menghitung Frekuensi Kumulatif di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T21:47:23+00:00\",\"dateModified\":\"2023-07-26T21:47:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung frekuensi kumulatif di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung frekuensi kumulatif 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 Kumulatif di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung frekuensi kumulatif di Excel, dengan sebuah contoh.","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-kumulatif-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Frekuensi Kumulatif di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung frekuensi kumulatif di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-26T21:47:23+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-kumulatif-unggul\/","url":"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/","name":"Cara Menghitung Frekuensi Kumulatif di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T21:47:23+00:00","dateModified":"2023-07-26T21:47:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung frekuensi kumulatif di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung frekuensi kumulatif 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\/1317"}],"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=1317"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1317\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}