{"id":2301,"date":"2023-07-22T21:08:04","date_gmt":"2023-07-22T21:08:04","guid":{"rendered":"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/"},"modified":"2023-07-22T21:08:04","modified_gmt":"2023-07-22T21:08:04","slug":"standar-deviasi-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/","title":{"rendered":"Deviasi standar di google spreadsheet (sampel dan populasi)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Deviasi standar<\/strong> adalah salah satu cara paling umum untuk mengukur distribusi nilai dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada dua jenis simpangan baku yang dapat Anda hitung, bergantung pada jenis data yang Anda gunakan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Simpangan baku populasi<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda harus menghitung deviasi standar populasi ketika kumpulan data yang Anda gunakan mewakili seluruh populasi, yaitu setiap nilai yang Anda minati.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung simpangan baku populasi yang dilambangkan dengan \u03c3 adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>\u03c3 = \u221a <span style=\"border-top: 1px solid black;\">\u03a3( <sub>xi<\/sub> \u2013 \u03bc) <sup>2<\/sup> \/ N<\/span><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3<\/strong> : Simbol yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub><\/strong> : Nilai <sup>ke<\/sup> -i dalam 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> : Ukuran populasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>2. Contoh simpangan baku<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda harus menghitung deviasi standar sampel ketika kumpulan data yang Anda gunakan mewakili sampel yang diambil dari populasi yang lebih besar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung simpangan baku sampel, dilambangkan dengan <em>s<\/em> , adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>s = \u221a <span style=\"border-top: 1px solid black;\">\u03a3( <sub>xi<\/sub> \u2013 x\u0304) <sup>2<\/sup> \/ (n \u2013 1)<\/span><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3<\/strong> : Simbol yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub><\/strong> : Nilai <sup>ke<\/sup> -i dalam kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x\u0304<\/strong> : Rata-rata sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> : Ukuran sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung deviasi standar sampel dan populasi di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Menghitung contoh deviasi standar di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan seorang ahli biologi ingin merangkum standar deviasi berat spesies penyu tertentu, sehingga ia mengambil <a href=\"https:\/\/statorials.org\/id\/metode-pengambilan-sampel\/\" target=\"_blank\" rel=\"noopener\">sampel acak sederhana<\/a> sebanyak 20 penyu dari populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena menggunakan sampel untuk memperkirakan simpangan baku populasi, maka dapat menghitung simpangan baku sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>STDEV.S()<\/strong> untuk menghitung deviasi standar sampel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20922 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/st2.png\" alt=\"\" width=\"565\" height=\"523\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Deviasi standar sampel ternyata menjadi <strong>11,91<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>STDEV()<\/strong> juga akan mengembalikan deviasi standar sampel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menghitung Deviasi Standar Populasi di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan seorang pelatih bola basket ingin merangkum standar deviasi poin yang dicetak oleh 12 pemain di timnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena dia hanya tertarik pada poin yang dicetak oleh pemainnya dan bukan pemain lain di tim lain, dia dapat menghitung deviasi standar populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>STDEV.P()<\/strong> untuk menghitung deviasi standar populasi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20921 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/st1.png\" alt=\"\" width=\"505\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Simpangan baku populasi ternyata <strong>7.331<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut memberikan informasi tambahan tentang deviasi standar:<\/span><\/p>\n<ul>\n<li> <a href=\"https:\/\/statorials.org\/id\" target=\"_blank\" rel=\"noopener\">Populasi vs. Contoh Deviasi Standar: Kapan Menggunakan Masing-masing<\/a><\/li>\n<li> <a href=\"https:\/\/statorials.org\/id\/koefisien-variasi-relatif-terhadap-standar-deviasi\/\" target=\"_blank\" rel=\"noopener\">Koefisien variasi versus deviasi standar: perbedaan<\/a><\/li>\n<li> <a href=\"https:\/\/statorials.org\/id\/mengapa-standar-deviasi-itu-penting\/\" target=\"_blank\" rel=\"noopener\">Mengapa deviasi standar penting?<\/a><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menghitung metrik penyebaran lainnya di Google Spreadsheet:<\/span><\/p>\n<ul>\n<li> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil di Google Spreadsheet<\/a><\/li>\n<li><a href=\"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Koefisien Variasi di Google Sheets<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Deviasi standar adalah salah satu cara paling umum untuk mengukur distribusi nilai dalam kumpulan data. Ada dua jenis simpangan baku yang dapat Anda hitung, bergantung pada jenis data yang Anda gunakan. 1. Simpangan baku populasi Anda harus menghitung deviasi standar populasi ketika kumpulan data yang Anda gunakan mewakili seluruh populasi, yaitu setiap nilai yang Anda [&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>Deviasi standar di Google Spreadsheet (sampel dan populasi) \u2013 Statistik<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung deviasi standar sampel dan populasi di Google Spreadsheet, 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\/standar-deviasi-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Deviasi standar di Google Spreadsheet (sampel dan populasi) \u2013 Statistik\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung deviasi standar sampel dan populasi di Google Spreadsheet, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T21:08:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/st2.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\/standar-deviasi-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/\",\"name\":\"Deviasi standar di Google Spreadsheet (sampel dan populasi) \u2013 Statistik\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T21:08:04+00:00\",\"dateModified\":\"2023-07-22T21:08:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung deviasi standar sampel dan populasi di Google Spreadsheet, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deviasi standar di google spreadsheet (sampel dan populasi)\"}]},{\"@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":"Deviasi standar di Google Spreadsheet (sampel dan populasi) \u2013 Statistik","description":"Tutorial ini menjelaskan cara menghitung deviasi standar sampel dan populasi di Google Spreadsheet, 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\/standar-deviasi-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Deviasi standar di Google Spreadsheet (sampel dan populasi) \u2013 Statistik","og_description":"Tutorial ini menjelaskan cara menghitung deviasi standar sampel dan populasi di Google Spreadsheet, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T21:08:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/st2.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\/standar-deviasi-google-sheet\/","url":"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/","name":"Deviasi standar di Google Spreadsheet (sampel dan populasi) \u2013 Statistik","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T21:08:04+00:00","dateModified":"2023-07-22T21:08:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung deviasi standar sampel dan populasi di Google Spreadsheet, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Deviasi standar di google spreadsheet (sampel dan populasi)"}]},{"@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\/2301"}],"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=2301"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2301\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}