{"id":1272,"date":"2023-07-27T01:40:09","date_gmt":"2023-07-27T01:40:09","guid":{"rendered":"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/"},"modified":"2023-07-27T01:40:09","modified_gmt":"2023-07-27T01:40:09","slug":"deviasi-standar-relatif-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/","title":{"rendered":"Cara menghitung deviasi standar relatif di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Deviasi standar relatif<\/strong> adalah ukuran deviasi standar sampel dari <a href=\"https:\/\/statorials.org\/id\/rata-rata-sampel-dibandingkan-dengan-rata-rata-populasi\/\" target=\"_blank\" rel=\"noopener\">mean sampel<\/a> untuk kumpulan data tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Deviasi standar relatif = s\/ <span style=\"text-decoration: overline;\">x<\/span> * 100%<\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>s:<\/strong> deviasi standar sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"text-decoration: overline;\">x<\/span> :<\/strong> mean sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Metrik ini memberi kita gambaran tentang seberapa dekat <a href=\"https:\/\/statorials.org\/id\/pengamatan-dalam-statistik\/\" target=\"_blank\" rel=\"noopener\">observasi<\/a> dikelompokkan di sekitar mean.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, simpangan baku suatu kumpulan data adalah 4. Jika rata-ratanya adalah 400, maka simpangan baku relatifnya adalah 4\/400 * 100% = 1%. Ini berarti bahwa observasi-observasinya mengelompok erat di sekitar mean.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, kumpulan data dengan deviasi standar 40 dan rata-rata 400 akan memiliki deviasi standar relatif sebesar 10%. Artinya observasi lebih terdistribusi di sekitar mean dibandingkan dengan dataset sebelumnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh penghitungan deviasi standar relatif di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: deviasi standar relatif di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12524 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsd1.png\" alt=\"\" width=\"373\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus berikut menunjukkan cara menghitung mean sampel, deviasi standar sampel, dan deviasi standar relatif sampel dari kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12525 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsd2.png\" alt=\"Deviasi standar relatif di Excel\" width=\"480\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Deviasi standar relatifnya adalah <strong>0,59<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini menunjukkan bahwa deviasi standar kumpulan data adalah 59% dari ukuran rata-rata kumpulan data. Angka tersebut cukup besar, menunjukkan bahwa nilai-nilai tersebut tersebar cukup luas di sekitar mean sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita memiliki beberapa kumpulan data, kita dapat menggunakan rumus yang sama untuk menghitung deviasi standar relatif (RSD) untuk setiap kumpulan data dan membandingkan RSD antar kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12526 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsd3.png\" alt=\"Deviasi standar relatif dari beberapa kumpulan data di Excel\" width=\"367\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat bahwa dataset 3 memiliki simpangan baku relatif terbesar yang menunjukkan bahwa nilai-nilai pada dataset ini paling tersebar dari mean dataset.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebaliknya, kita dapat melihat bahwa Kumpulan Data 2 memiliki simpangan baku relatif terkecil, yang menunjukkan bahwa nilai-nilai dalam kumpulan data ini memiliki penyebaran paling kecil dari rata-rata kumpulan data tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em><span style=\"color: #000000;\">Anda dapat menemukan<\/span> lebih banyak tutorial Excel di sini .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Deviasi standar relatif adalah ukuran deviasi standar sampel dari mean sampel untuk kumpulan data tertentu. Ini dihitung sebagai berikut: Deviasi standar relatif = s\/ x * 100% Emas: s: deviasi standar sampel x : mean sampel Metrik ini memberi kita gambaran tentang seberapa dekat observasi dikelompokkan di sekitar mean. Misalnya, simpangan baku suatu kumpulan data [&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 Relatif di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung deviasi standar relatif di Excel, dengan beberapa 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-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 Deviasi Standar Relatif di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung deviasi standar relatif di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T01:40:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsd1.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-relatif-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/\",\"name\":\"Cara Menghitung Deviasi Standar Relatif di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T01:40:09+00:00\",\"dateModified\":\"2023-07-27T01:40:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung deviasi standar relatif di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung deviasi standar 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 Deviasi Standar Relatif di Excel","description":"Tutorial ini menjelaskan cara menghitung deviasi standar relatif di Excel, dengan beberapa 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-relatif-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Deviasi Standar Relatif di Excel","og_description":"Tutorial ini menjelaskan cara menghitung deviasi standar relatif di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-27T01:40:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsd1.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-relatif-unggul\/","url":"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/","name":"Cara Menghitung Deviasi Standar Relatif di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T01:40:09+00:00","dateModified":"2023-07-27T01:40:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung deviasi standar relatif di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/deviasi-standar-relatif-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung deviasi standar 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\/1272"}],"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=1272"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1272\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}