{"id":1279,"date":"2023-07-27T01:05:06","date_gmt":"2023-07-27T01:05:06","guid":{"rendered":"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/"},"modified":"2023-07-27T01:05:06","modified_gmt":"2023-07-27T01:05:06","slug":"mean-dan-deviasi-standar-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/","title":{"rendered":"Cara menghitung mean dan deviasi standar di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/mengukur-tendensi-sentral\/\" target=\"_blank\" rel=\"noopener\">Mean<\/a> mewakili nilai rata-rata dalam sekumpulan data. Ini memberi kita gambaran bagus tentang di mana pusat kumpulan data berada.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Deviasi standar mewakili distribusi nilai dalam kumpulan data. Ini memberi kita gambaran tentang seberapa dekat observasi dikelompokkan di sekitar mean.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan hanya menggunakan kedua nilai ini, kita dapat memahami banyak hal tentang distribusi nilai dalam suatu kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung <strong>rata-rata<\/strong> suatu kumpulan data di Excel, kita dapat menggunakan fungsi <strong>=AVERAGE(Range)<\/strong> dimana <em>Range<\/em> adalah rentang nilai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung <strong>simpangan baku<\/strong> suatu kumpulan data, kita dapat menggunakan fungsi <strong>=STDEV.S(Range)<\/strong> , dimana <em>Range<\/em> adalah rentang nilai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menggunakan fungsi-fungsi ini dalam praktik.<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Catatan teknis<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>STDEV()<\/strong> dan <strong>STDEV.S()<\/strong> menghitung deviasi standar <em>sampel<\/em> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan fungsi STDEV.P() untuk menghitung deviasi standar <em>populasi<\/em> jika kumpulan data Anda mewakili seluruh nilai populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, dalam kebanyakan kasus, kami bekerja dengan sampel data, bukan seluruh populasi, jadi kami menggunakan fungsi STDEV.S().<\/span><\/p>\n<\/blockquote>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Rata-rata dan deviasi standar dari satu kumpulan data<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut<\/span> <span style=\"color: #000000;\">memperlihatkan cara menghitung mean dan deviasi standar satu kumpulan data di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12564 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel1.png\" alt=\"mean dan deviasi standar di Excel\" width=\"523\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata kumpulan data adalah <strong>16,4<\/strong> dan deviasi standarnya adalah <strong>9,13<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Rata-rata dan deviasi standar dari beberapa kumpulan data<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki beberapa kumpulan data di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12566 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel2.png\" alt=\"\" width=\"414\" height=\"477\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung mean dan deviasi standar kumpulan data pertama, kita dapat menggunakan dua rumus berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Rata-rata:<\/strong> = RATA-RATA (B2:B21)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Simpangan baku:<\/strong> =STDEV.S(B2:B21)<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12567 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel3.png\" alt=\"\" width=\"370\" height=\"512\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita dapat menyorot sel B22:B23 dan mengarahkan kursor ke sudut kanan bawah sel B23 hingga muncul tanda <strong>+<\/strong> kecil. Kita kemudian dapat mengklik dan menyeret rumus ke dua kolom berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12568 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel4.png\" alt=\"Rata-rata dan deviasi standar beberapa kumpulan data di Excel\" width=\"426\" height=\"501\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rangkuman Lima Angka di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Standard Error Mean di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mean mewakili nilai rata-rata dalam sekumpulan data. Ini memberi kita gambaran bagus tentang di mana pusat kumpulan data berada. Deviasi standar mewakili distribusi nilai dalam kumpulan data. Ini memberi kita gambaran tentang seberapa dekat observasi dikelompokkan di sekitar mean. Dengan hanya menggunakan kedua nilai ini, kita dapat memahami banyak hal tentang distribusi nilai dalam suatu [&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 Mean dan Deviasi Standar di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar suatu kumpulan data 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\/mean-dan-deviasi-standar-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Mean dan Deviasi Standar di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar suatu kumpulan data di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T01:05:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel1.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\/mean-dan-deviasi-standar-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/\",\"name\":\"Cara Menghitung Mean dan Deviasi Standar di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T01:05:06+00:00\",\"dateModified\":\"2023-07-27T01:05:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar suatu kumpulan data di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung mean dan deviasi standar 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 Mean dan Deviasi Standar di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar suatu kumpulan data 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\/mean-dan-deviasi-standar-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Mean dan Deviasi Standar di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar suatu kumpulan data di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T01:05:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel1.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\/mean-dan-deviasi-standar-di-excel\/","url":"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/","name":"Cara Menghitung Mean dan Deviasi Standar di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T01:05:06+00:00","dateModified":"2023-07-27T01:05:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar suatu kumpulan data di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung mean dan deviasi standar 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\/1279"}],"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=1279"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1279\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}