{"id":1074,"date":"2023-07-27T18:34:25","date_gmt":"2023-07-27T18:34:25","guid":{"rendered":"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/"},"modified":"2023-07-27T18:34:25","modified_gmt":"2023-07-27T18:34:25","slug":"frekuensi-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/","title":{"rendered":"Cara menghitung frekuensi di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><strong><span style=\"color: #000000;\">Frekuensi<\/span><\/strong> <span style=\"color: #000000;\">memberi tahu kita seberapa sering nilai yang berbeda muncul dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat dengan mudah menghitung frekuensi di Google Sheets menggunakan fungsi <strong>FREQUENCY()<\/strong> , yang memiliki sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>FREKUENSI (data, kelas)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>data:<\/strong> array yang berisi nilai data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kelas:<\/strong> array yang berisi sekumpulan kelas<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung frekuensi dan frekuensi relatif di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Menghitung frekuensi di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut dengan 15 nilai di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11028 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles1-1.png\" alt=\"\" width=\"432\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung frekuensi masing-masing nilai individu (misalnya menghitung berapa banyak angka 12 yang muncul, berapa banyak angka 13 yang muncul, dan seterusnya), pertama-tama kita perlu mendefinisikan kelas-kelas di kolom B. Kita dapat melakukannya dengan mudah dengan mengetikkan rumus berikut di sel B2:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>= <span class=\" default-formula-text-color\" dir=\"auto\">MANFAAT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">TUNGGAL<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">A2:A16<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Ini menghasilkan hasil sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11029 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles2.png\" alt=\"\" width=\"445\" height=\"508\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita bisa mengetikkan rumus berikut di sel C2:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=FREKUENSI<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">A2:A16<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">B2:B7<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Ini menghasilkan hasil sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11030 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles3.png\" alt=\"Frekuensi di Google Spreadsheet\" width=\"446\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cara menafsirkan keluaran ini adalah:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai <strong>12<\/strong> muncul <strong>2<\/strong> kali pada dataset asli.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>13<\/strong> muncul di kumpulan data asli <strong>3<\/strong> <strong>&nbsp;<\/strong> waktu.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>14<\/strong> muncul <strong>2<\/strong> kali pada dataset asli.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>15<\/strong> muncul <strong>4<\/strong> kali pada dataset asli.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>16<\/strong> muncul <strong>1<\/strong> kali pada dataset asli.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>17<\/strong> muncul <strong>3<\/strong> kali pada dataset asli.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Menghitung Frekuensi Relatif di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Setelah kita menghitung frekuensi setiap nilai data individual, kita kemudian dapat menghitung frekuensi relatif setiap nilai dengan mengetikkan rumus berikut ke dalam sel D2:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">C2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">\/<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">AKUN<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">$A$2:$A$16<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung frekuensi relatif dari nilai <strong>12<\/strong> dalam kumpulan data asli:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11031 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles5.png\" alt=\"\" width=\"521\" height=\"521\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita menghitung frekuensi relatif ini, kita dapat mengarahkan kursor ke sudut kanan bawah sel D2 hingga tanda <strong>+<\/strong> kecil muncul. Klik dua kali tanda <strong>+<\/strong> untuk menyalin rumus ke sel yang tersisa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11032 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles4.png\" alt=\"Frekuensi relatif di Google Spreadsheet\" width=\"493\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cara menafsirkan keluaran ini adalah:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai <strong>12<\/strong> mewakili <strong>0,133<\/strong> (atau 13,3%) dari seluruh nilai dalam dataset.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>13<\/strong> mewakili <strong>0,200<\/strong> (atau 20,0%) dari seluruh nilai dalam dataset.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda akan melihat bahwa jumlah semua frekuensi relatif sama dengan <strong>1<\/strong> (yaitu 100%).<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Lihat frekuensi relatif di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat memvisualisasikan frekuensi relatif dengan membuat histogram.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, sorot tabel frekuensi relatif:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11034 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles6.png\" alt=\"Menghitung Frekuensi Relatif di Google Spreadsheet\" width=\"463\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Bagan<\/strong> . Google Sheets secara otomatis akan menghasilkan histogram frekuensi relatif berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11035 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles7.png\" alt=\"Histogram frekuensi relatif di Google Spreadsheet\" width=\"501\" height=\"299\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat dengan mudah menambahkan label pada sumbu X dengan mengklik tombol masukan <strong>sumbu X<\/strong> di <strong>Editor Bagan<\/strong> dan menentukan sel <strong>B2:B7<\/strong> sebagai label. Ini menghasilkan hasil sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11036 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles8.png\" alt=\"Frekuensi relatif Google Spreadsheet\" width=\"516\" height=\"310\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik sederhana ini membantu kita dengan cepat memahami seberapa sering setiap nilai muncul dalam kumpulan data asli.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Frekuensi memberi tahu kita seberapa sering nilai yang berbeda muncul dalam kumpulan data. Kita dapat dengan mudah menghitung frekuensi di Google Sheets menggunakan fungsi FREQUENCY() , yang memiliki sintaks berikut: FREKUENSI (data, kelas) Emas: data: array yang berisi nilai data kelas: array yang berisi sekumpulan kelas Contoh berikut menunjukkan cara menghitung frekuensi dan frekuensi relatif [&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 menghitung frekuensi di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung frekuensi di Google Sheets, beserta beberapa contohnya.\" \/>\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-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung frekuensi di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung frekuensi di Google Sheets, beserta beberapa contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T18:34:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles1-1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/\",\"name\":\"Cara menghitung frekuensi di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T18:34:25+00:00\",\"dateModified\":\"2023-07-27T18:34:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung frekuensi di Google Sheets, beserta beberapa contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung frekuensi di google sheets\"}]},{\"@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 di Google Sheets \u2013 Statorials","description":"Penjelasan sederhana cara menghitung frekuensi di Google Sheets, beserta beberapa contohnya.","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-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung frekuensi di Google Sheets \u2013 Statorials","og_description":"Penjelasan sederhana cara menghitung frekuensi di Google Sheets, beserta beberapa contohnya.","og_url":"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T18:34:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequencefeuilles1-1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/","url":"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/","name":"Cara menghitung frekuensi di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T18:34:25+00:00","dateModified":"2023-07-27T18:34:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung frekuensi di Google Sheets, beserta beberapa contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/frekuensi-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung frekuensi di google sheets"}]},{"@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\/1074"}],"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=1074"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1074\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}