{"id":4844,"date":"2023-07-07T07:45:59","date_gmt":"2023-07-07T07:45:59","guid":{"rendered":"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/"},"modified":"2023-07-07T07:45:59","modified_gmt":"2023-07-07T07:45:59","slug":"simpangan-baku-distribusi-frekuensi-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/","title":{"rendered":"Excel: menghitung simpangan baku distribusi frekuensi"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung deviasi standar distribusi frekuensi di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda memiliki distribusi frekuensi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37845 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fre1.png\" alt=\"\" width=\"459\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh langkah demi langkah berikut memperlihatkan cara menghitung deviasi standar distribusi frekuensi ini di Excel.<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai untuk distribusi frekuensi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan batasan kelas dan nilai frekuensi untuk distribusi frekuensi kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37845 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fre1.png\" alt=\"\" width=\"459\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung rata-rata distribusi frekuensi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memperkirakan rata-rata distribusi frekuensi kita:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rata-rata:<\/strong> \u03a3m <sub>i<\/sub> n <sub>i<\/sub> \/ N<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong><sub>mi<\/sub> :<\/strong> Bagian tengah dari grup ke <sup>&#8211;<\/sup> i<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n <sub>i<\/sub> :<\/strong> Frekuensi <sup>grup<\/sup> ke-i<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>N:<\/strong> Total ukuran sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menerapkan rumus ini di Excel, kita akan mengetikkan rumus berikut di sel <strong>D2<\/strong> , <strong>E2<\/strong> dan <strong>F2<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>D2<\/strong> : =RATA-RATA(A2:B2)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>E2<\/strong> : =D2*C2<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>F2<\/strong> : =JUMLAH($E$2:$E$6)\/JUMLAH($C$2:$C$6)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami kemudian akan mengklik dan menyeret rumus ini ke setiap sel yang tersisa di setiap kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37847 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fre2-1.png\" alt=\"\" width=\"652\" height=\"257\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung simpangan baku distribusi frekuensi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memperkirakan deviasi standar distribusi frekuensi kita:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Simpangan baku:<\/strong> \u221a <span style=\"border-top: 1px solid black;\">\u03a3n <sub>i<\/sub> (mi <sub>-\u03bc<\/sub> ) <sup>2<\/sup> \/ (N-1)<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>n <sub>i<\/sub> :<\/strong> Frekuensi <sup>grup<\/sup> ke-i<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><sub>mi<\/sub> :<\/strong> Bagian tengah dari grup ke <sup>&#8211;<\/sup> i<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03bc<\/strong> : Rata-rata<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>N:<\/strong> Total ukuran sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menerapkan rumus ini di Excel, kita akan mengetikkan rumus berikut di sel <strong>G2<\/strong> , <strong>H2<\/strong> dan <strong>I2<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>G2<\/strong> : =D2-F2<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>H2<\/strong> : =G2^2<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>I2<\/strong> : =C2*H2<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami kemudian akan mengklik dan menyeret rumus ini ke setiap sel yang tersisa di setiap kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37848 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fre3.png\" alt=\"\" width=\"665\" height=\"228\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat mengetikkan rumus berikut di sel <strong>B8<\/strong> untuk menghitung simpangan baku distribusi frekuensi ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SQRT(SUM( <span style=\"color: #3366ff;\">I2:I6<\/span> )\/(SUM( <span style=\"color: #ff0000;\">C2:C6<\/span> )-1))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37849\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fre4.png\" alt=\"Deviasi standar Excel distribusi frekuensi\" width=\"669\" height=\"272\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Simpangan baku distribusi frekuensi ini adalah <strong>9,6377<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Distribusi Frekuensi Berkelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Distribusi Frekuensi Persentase di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Kumulatif di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menghitung deviasi standar distribusi frekuensi di Excel. Misalnya, Anda memiliki distribusi frekuensi berikut: Contoh langkah demi langkah berikut memperlihatkan cara menghitung deviasi standar distribusi frekuensi ini di Excel. Langkah 1: Masukkan nilai untuk distribusi frekuensi Pertama, kita akan memasukkan batasan kelas dan nilai frekuensi untuk distribusi frekuensi kita: Langkah 2: Hitung [&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>Excel: Hitung simpangan baku distribusi frekuensi - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung simpangan baku suatu distribusi frekuensi di Excel, beserta 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\/simpangan-baku-distribusi-frekuensi-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Hitung simpangan baku distribusi frekuensi - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung simpangan baku suatu distribusi frekuensi di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T07:45:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fre1.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\/simpangan-baku-distribusi-frekuensi-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/\",\"name\":\"Excel: Hitung simpangan baku distribusi frekuensi - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T07:45:59+00:00\",\"dateModified\":\"2023-07-07T07:45:59+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung simpangan baku suatu distribusi frekuensi di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: menghitung simpangan baku distribusi frekuensi\"}]},{\"@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":"Excel: Hitung simpangan baku distribusi frekuensi - Statologi","description":"Tutorial ini menjelaskan cara menghitung simpangan baku suatu distribusi frekuensi di Excel, beserta 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\/simpangan-baku-distribusi-frekuensi-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Hitung simpangan baku distribusi frekuensi - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung simpangan baku suatu distribusi frekuensi di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T07:45:59+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fre1.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\/simpangan-baku-distribusi-frekuensi-di-excel\/","url":"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/","name":"Excel: Hitung simpangan baku distribusi frekuensi - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T07:45:59+00:00","dateModified":"2023-07-07T07:45:59+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung simpangan baku suatu distribusi frekuensi di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/simpangan-baku-distribusi-frekuensi-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: menghitung simpangan baku distribusi frekuensi"}]},{"@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\/4844"}],"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=4844"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4844\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}