{"id":1280,"date":"2023-07-27T01:03:13","date_gmt":"2023-07-27T01:03:13","guid":{"rendered":"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/"},"modified":"2023-07-27T01:03:13","modified_gmt":"2023-07-27T01:03:13","slug":"stdevp-vs-stdevs-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/","title":{"rendered":"Stdev.p vs stdev.s di excel: apa bedanya?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ada tiga fungsi berbeda yang dapat Anda gunakan untuk menghitung deviasi standar di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. STDEV.P:<\/strong> Fungsi ini menghitung deviasi standar populasi. Gunakan fungsi ini bila rentang nilai mewakili seluruh populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan rumus berikut:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\">Simpangan baku populasi = \u221a\u03a3 ( <sub>xi<\/sub> \u2013 \u03bc) <sup>2<\/sup> \/ N<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3:<\/strong> Simbol Yunani yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> nilai <sup>ke-i<\/sup> dari kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03bc:<\/strong> Rata-rata populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>N :<\/strong> Jumlah total observasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>2. STDEV.S:<\/strong> Fungsi ini menghitung deviasi standar sampel. Gunakan fungsi ini ketika rentang nilai mewakili sampel nilai, bukan keseluruhan populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan rumus berikut:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\">Simpangan baku sampel = \u221a\u03a3 ( <sub>xi<\/sub> \u2013 <span style=\"text-decoration: overline;\">x<\/span> ) <sup>2<\/sup> \/ (n-1)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3:<\/strong> Simbol Yunani yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> nilai <sup>ke-i<\/sup> dari kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"text-decoration: overline;\">x<\/span> :<\/strong> Maksud sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>N :<\/strong> Jumlah total observasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>3. STDEV:<\/strong> Fungsi ini juga menghitung deviasi standar sampel. Ini akan mengembalikan nilai yang persis sama dengan fungsi <strong>STDEV.S<\/strong> .<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Catatan teknis:<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena rumus simpangan baku populasi dibagi dengan <em>N<\/em> dan bukan <em>n-1<\/em> , simpangan baku populasi akan selalu lebih kecil dari simpangan baku sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Alasan simpangan baku populasi akan semakin kecil adalah karena jika kita mengetahui setiap nilai populasi, maka kita mengetahui simpangan baku pastinya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, jika kita hanya memiliki sampel dari populasi, kita mempunyai lebih banyak ketidakpastian seputar deviasi standar pasti dari keseluruhan populasi, sehingga perkiraan deviasi standar kita harus lebih besar.<\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi-fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <strong>Contoh: STDEV.P vs STDEV.S di Excel<\/strong><\/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-12574 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd_formules1.png\" alt=\"\" width=\"395\" height=\"536\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung simpangan baku kumpulan data menggunakan tiga rumus simpangan baku yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12575 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd_formules2.png\" alt=\"STDEV.P vs STDEV.S di Excel\" width=\"502\" height=\"546\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Simpangan baku sampel menjadi <strong>9,127<\/strong> dan simpangan baku populasi menjadi <strong>8,896<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seperti disebutkan sebelumnya, simpangan baku populasi akan selalu lebih kecil dari simpangan baku sampel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Kapan menggunakan STDEV.P vs STDEV.S<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Dalam kebanyakan kasus, kami tidak dapat mengumpulkan data untuk seluruh populasi. Oleh karena itu kami mengumpulkan data hanya untuk <a href=\"https:\/\/statorials.org\/id\/populasi-vs.-sampel\/\" target=\"_blank\" rel=\"noopener\">sampel<\/a> dari populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, kami hampir selalu menggunakan <strong>STDEV.S<\/strong> untuk menghitung deviasi standar suatu kumpulan data, karena kumpulan data kami umumnya mewakili sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>STDEV<\/strong> dan <strong>STDEV.S<\/strong> mengembalikan nilai yang persis sama, sehingga kita dapat menggunakan fungsi mana pun untuk menghitung deviasi standar sampel dari kumpulan data tertentu.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada tiga fungsi berbeda yang dapat Anda gunakan untuk menghitung deviasi standar di Excel: 1. STDEV.P: Fungsi ini menghitung deviasi standar populasi. Gunakan fungsi ini bila rentang nilai mewakili seluruh populasi. Fungsi ini menggunakan rumus berikut: Simpangan baku populasi = \u221a\u03a3 ( xi \u2013 \u03bc) 2 \/ N Emas: \u03a3: Simbol Yunani yang berarti \u201cjumlah\u201d [&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>STDEV.P vs STDEV.S di Excel: Apa bedanya?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan fungsi STDEV.P dan STDEV.S di Excel, beserta 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\/stdevp-vs-stdevs-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"STDEV.P vs STDEV.S di Excel: Apa bedanya?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan fungsi STDEV.P dan STDEV.S di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T01:03:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd_formules1.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\/stdevp-vs-stdevs-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/\",\"name\":\"STDEV.P vs STDEV.S di Excel: Apa bedanya?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T01:03:13+00:00\",\"dateModified\":\"2023-07-27T01:03:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan fungsi STDEV.P dan STDEV.S di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stdev.p vs stdev.s di excel: apa bedanya?\"}]},{\"@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":"STDEV.P vs STDEV.S di Excel: Apa bedanya?","description":"Tutorial ini menjelaskan perbedaan fungsi STDEV.P dan STDEV.S di Excel, beserta 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\/stdevp-vs-stdevs-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"STDEV.P vs STDEV.S di Excel: Apa bedanya?","og_description":"Tutorial ini menjelaskan perbedaan fungsi STDEV.P dan STDEV.S di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T01:03:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd_formules1.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\/stdevp-vs-stdevs-di-excel\/","url":"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/","name":"STDEV.P vs STDEV.S di Excel: Apa bedanya?","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T01:03:13+00:00","dateModified":"2023-07-27T01:03:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan fungsi STDEV.P dan STDEV.S di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Stdev.p vs stdev.s di excel: apa bedanya?"}]},{"@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\/1280"}],"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=1280"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1280\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}