{"id":1450,"date":"2023-07-26T08:33:42","date_gmt":"2023-07-26T08:33:42","guid":{"rendered":"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/"},"modified":"2023-07-26T08:33:42","modified_gmt":"2023-07-26T08:33:42","slug":"deviasi-standar-tertimbang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/","title":{"rendered":"Cara menghitung deviasi standar tertimbang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Deviasi standar tertimbang<\/strong> adalah cara yang berguna untuk mengukur sebaran nilai dalam suatu kumpulan data ketika beberapa nilai dalam kumpulan data memiliki bobot lebih tinggi daripada nilai lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung simpangan baku tertimbang adalah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14345 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere_sd1.png\" alt=\"\" width=\"218\" height=\"92\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>N :<\/strong> Jumlah total <a href=\"https:\/\/statorials.org\/id\/pengamatan-dalam-statistik\/\" target=\"_blank\" rel=\"noopener\">observasi<\/a><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>M:<\/strong> Jumlah bobot bukan nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>w <sub>i<\/sub> :<\/strong> Vektor bobot<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> Vektor nilai data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">x<\/span> :<\/strong> Rata-rata tertimbang<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut memperlihatkan cara menghitung deviasi standar tertimbang di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita buat kolom nilai data beserta bobotnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-14346 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere_sd_excel1.png\" alt=\"\" width=\"433\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung rata-rata tertimbang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk menghitung rata-rata tertimbang:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT( <span style=\"color: #3366ff;\">A2:A11<\/span> , <span style=\"color: #ff0000;\">B2:B11<\/span> ) \/ SUM( <span style=\"color: #ff0000;\">B2:B11<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rata-rata tertimbangnya ternyata <strong>31.147<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14347 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere_sd_excel2.png\" alt=\"\" width=\"611\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung deviasi standar tertimbang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita dapat menggunakan rumus berikut untuk menghitung simpangan baku tertimbang:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SQRT(SUMPRODUCT(( <span style=\"color: #3366ff;\">A2:A11 <span style=\"color: #000000;\">- <span style=\"color: #ff0000;\">E2<\/span><\/span><\/span> )^2, <span style=\"color: #800080;\">B2:B11<\/span> ) \/ SUM( <span style=\"color: #800080;\">B2:B11<\/span> , -1))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Simpangan baku tertimbang ternyata <strong>8,570<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14348 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere_sd_excel3.png\" alt=\"Rumus Deviasi Standar Tertimbang di Excel\" width=\"670\" height=\"283\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan jika ingin menghitung varian tertimbang cukup 8.570 <sup>2<\/sup> = <strong>73.44<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung MAPE Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-bergerak-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Rata-Rata Pergerakan Tertimbang di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Deviasi standar tertimbang adalah cara yang berguna untuk mengukur sebaran nilai dalam suatu kumpulan data ketika beberapa nilai dalam kumpulan data memiliki bobot lebih tinggi daripada nilai lainnya. Rumus untuk menghitung simpangan baku tertimbang adalah: Emas: N : Jumlah total observasi M: Jumlah bobot bukan nol w i : Vektor bobot x i : Vektor [&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 Deviasi Standar Tertimbang di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung standar deviasi tertimbang 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\/deviasi-standar-tertimbang-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Deviasi Standar Tertimbang di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung standar deviasi tertimbang di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T08:33:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere_sd1.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\/deviasi-standar-tertimbang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/\",\"name\":\"Cara Menghitung Deviasi Standar Tertimbang di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T08:33:42+00:00\",\"dateModified\":\"2023-07-26T08:33:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung standar deviasi tertimbang di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung deviasi standar tertimbang 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 Deviasi Standar Tertimbang di Excel","description":"Tutorial ini menjelaskan cara menghitung standar deviasi tertimbang 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\/deviasi-standar-tertimbang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Deviasi Standar Tertimbang di Excel","og_description":"Tutorial ini menjelaskan cara menghitung standar deviasi tertimbang di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T08:33:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere_sd1.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\/deviasi-standar-tertimbang-excel\/","url":"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/","name":"Cara Menghitung Deviasi Standar Tertimbang di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T08:33:42+00:00","dateModified":"2023-07-26T08:33:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung standar deviasi tertimbang di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung deviasi standar tertimbang 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\/1450"}],"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=1450"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1450\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}