{"id":4348,"date":"2023-07-11T19:41:36","date_gmt":"2023-07-11T19:41:36","guid":{"rendered":"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/"},"modified":"2023-07-11T19:41:36","modified_gmt":"2023-07-11T19:41:36","slug":"deviasi-standar-vba-dari-jangkauan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/","title":{"rendered":"Vba: cara menghitung deviasi standar rentang"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menghitung standar deviasi<\/a> nilai dalam suatu rentang menggunakan VBA:<\/span><\/p>\n

 SubStDevRange<\/span> ()\n    Range(\" D2<\/span> \") = WorksheetFunction.StDev(Range(\" B2:B11<\/span> \"))\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini menghitung deviasi standar nilai dalam rentang B2:B11<\/strong> dan menetapkan hasilnya ke sel D2<\/strong> .<\/span><\/p>\n
 Jika Anda ingin menampilkan deviasi standar nilai dalam kotak pesan, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n
 SubStDevRange<\/span> ()\n    'Create variable to store standard deviation of values<\/span>\n    Dim<\/span> stdev As<\/span> Single\n    \n    'Calculate standard deviation of values in range<\/span>\n    stdev = WorksheetFunction.StDev(Range(\" B2:B11<\/span> \"))\n    \n    'Display the result<\/span>\n    MsgBox \" Standard Deviation of Values in Range:<\/span> \" & stdev \nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Contoh berikut memperlihatkan cara menggunakan masing-masing metode ini dalam praktik dengan himpunan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: Hitung simpangan baku rentang menggunakan VBA dan tampilkan hasilnya dalam sel<\/strong><\/span><\/h2>\n
 Misalkan kita ingin menghitung simpangan baku dari nilai pada kolom poin dan menampilkan hasilnya pada sel tertentu.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubStDevRange<\/span> ()\n    Range(\" D2<\/span> \") = WorksheetFunction.StDev(Range(\" B2:B11<\/span> \"))\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa sel D2<\/b> berisi nilai 11.93734<\/strong> .<\/span><\/p>\n
 Artinya simpangan baku nilai pada kolom poin adalah 245.<\/span><\/p>\n
 Contoh 2: Hitung deviasi standar rentang menggunakan VBA dan tampilkan hasilnya di kotak pesan<\/strong><\/span><\/h2>\n
 Misalkan kita ingin menghitung deviasi standar dari nilai di kolom poin dan menampilkan hasilnya di kotak pesan.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubStDevRange<\/span> ()\n    'Create variable to store standard deviation of values<\/span>\n    Dim<\/span> stdev As<\/span> Single\n    \n    'Calculate standard deviation of values in range<\/span>\n    stdev = WorksheetFunction.StDev(Range(\" B2:B11<\/span> \"))\n    \n    'Display the result<\/span>\n    MsgBox \" Standard Deviation of Values in Range:<\/span> \" & stdev \nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"Nilai<\/p>\n
 Kotak pesan memberitahu kita bahwa standar deviasi dari nilai dalam rentang B2:B11<\/strong> adalah 11.937<\/strong> .<\/span><\/p>\n
 Perhatikan bahwa dalam contoh ini, kami menghitung deviasi standar nilai dalam rentang B2:B11<\/strong> .<\/span><\/p>\n
 Namun, jika Anda ingin menghitung standar deviasi nilai di seluruh kolom, Anda dapat mengetikkan B:B<\/strong> .<\/span><\/p>\n
 Ini akan menghitung jumlah nilai untuk setiap sel di kolom B.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap metode StDev<\/strong> VBA di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menghitung nilai rata-rata rentang<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a>
 VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menghitung standar deviasi nilai dalam suatu rentang menggunakan VBA: SubStDevRange () Range(” D2 “) = WorksheetFunction.StDev(Range(” B2:B11 “)) End Sub Contoh khusus ini menghitung deviasi standar nilai dalam rentang B2:B11 dan menetapkan hasilnya ke sel D2 . Jika Anda ingin menampilkan deviasi standar nilai dalam kotak pesan, Anda […]<\/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":"\nVBA: Cara menghitung deviasi standar rentang - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung deviasi standar suatu rentang menggunakan VBA, 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-vba-dari-jangkauan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghitung deviasi standar rentang - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung deviasi standar suatu rentang menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T19:41:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage-de-somme1.jpg\" \/>\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\/deviasi-standar-vba-dari-jangkauan\/\",\"url\":\"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/\",\"name\":\"VBA: Cara menghitung deviasi standar rentang - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T19:41:36+00:00\",\"dateModified\":\"2023-07-11T19:41:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung deviasi standar suatu rentang menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghitung deviasi standar rentang\"}]},{\"@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":"VBA: Cara menghitung deviasi standar rentang - Statorials","description":"Tutorial ini menjelaskan cara menghitung deviasi standar suatu rentang menggunakan VBA, 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-vba-dari-jangkauan\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghitung deviasi standar rentang - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung deviasi standar suatu rentang menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/","og_site_name":"Statorials","article_published_time":"2023-07-11T19:41:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage-de-somme1.jpg"}],"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\/deviasi-standar-vba-dari-jangkauan\/","url":"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/","name":"VBA: Cara menghitung deviasi standar rentang - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T19:41:36+00:00","dateModified":"2023-07-11T19:41:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung deviasi standar suatu rentang menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghitung deviasi standar rentang"}]},{"@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\/4348"}],"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=4348"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4348\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}