{"id":929,"date":"2023-07-28T07:03:04","date_gmt":"2023-07-28T07:03:04","guid":{"rendered":"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/"},"modified":"2023-07-28T07:03:04","modified_gmt":"2023-07-28T07:03:04","slug":"kesalahan-standar-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/","title":{"rendered":"Cara menghitung standard error mean di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Kesalahan standar mean<\/strong> adalah cara mengukur sebaran nilai dalam suatu kumpulan data. Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Kesalahan standar = s \/ \u221an<\/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>n<\/strong> : ukuran sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Anda dapat menghitung kesalahan standar rata-rata kumpulan data apa pun di Excel menggunakan rumus berikut:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>= <span style=\"color: #3366ff;\">STDEV<\/span> (rentang nilai) \/ <span style=\"color: #3366ff;\">SQRT<\/span> ( <span style=\"color: #3366ff;\">COUNT<\/span> (rentang nilai))<\/strong><\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: kesalahan standar di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9840 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreur_standard_excel1.png\" alt=\"\" width=\"451\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung kesalahan standar rata-rata untuk kumpulan data ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9841 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel2.png\" alt=\"Kesalahan standar rata-rata di Excel\" width=\"480\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kesalahan standarnya ternyata <strong>2.0014<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>=STDEV()<\/strong> menghitung mean sampel, yang setara dengan fungsi <strong>=STDEV.S()<\/strong> di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, kita bisa menggunakan rumus berikut untuk mendapatkan hasil yang sama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9843 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel3.png\" alt=\"Kesalahan standar mean di Excel menggunakan standar deviasi sampel\" width=\"501\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekali lagi, kesalahan standarnya adalah <strong>2.0014<\/strong> .<\/span><\/p>\n<h3> <strong>Bagaimana menafsirkan kesalahan standar dari mean<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Kesalahan standar mean hanyalah ukuran penyebaran nilai di sekitar mean. Ada dua hal yang perlu diingat ketika menafsirkan kesalahan standar mean:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Semakin besar kesalahan standar mean, maka nilai-nilai tersebut semakin tersebar di sekitar mean dalam suatu kumpulan data.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengilustrasikannya, pertimbangkan jika kita mengubah nilai terakhir dari kumpulan data sebelumnya dengan angka yang jauh lebih besar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9844 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel4.png\" alt=\"\" width=\"489\" height=\"499\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bagaimana kesalahan standar meningkat dari <strong>2.0014<\/strong> menjadi <strong>6.9783<\/strong> . Hal ini menunjukkan bahwa nilai-nilai pada dataset ini lebih tersebar disekitar mean dibandingkan dengan dataset sebelumnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2. Dengan bertambahnya ukuran sampel, kesalahan standar mean cenderung menurun.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengilustrasikannya, pertimbangkan kesalahan standar dari mean untuk dua kumpulan data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9845 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel5.png\" alt=\"\" width=\"427\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kumpulan data kedua hanyalah kumpulan data pertama yang diulang dua kali. Jadi kedua kumpulan data memiliki mean yang sama tetapi kumpulan data kedua memiliki ukuran sampel yang lebih besar sehingga memiliki kesalahan standar yang lebih kecil.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kesalahan standar mean adalah cara mengukur sebaran nilai dalam suatu kumpulan data. Ini dihitung sebagai berikut: Kesalahan standar = s \/ \u221an Emas: s : deviasi standar sampel n : ukuran sampel Anda dapat menghitung kesalahan standar rata-rata kumpulan data apa pun di Excel menggunakan rumus berikut: = STDEV (rentang nilai) \/ SQRT ( COUNT [&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 Standard Error Mean di Excel<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung standard error mean 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\/kesalahan-standar-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Standard Error Mean di Excel\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung standard error mean di excel beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T07:03:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreur_standard_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\/kesalahan-standar-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/\",\"name\":\"Cara Menghitung Standard Error Mean di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T07:03:04+00:00\",\"dateModified\":\"2023-07-28T07:03:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung standard error mean di excel beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung standard error mean 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 Standard Error Mean di Excel","description":"Penjelasan sederhana cara menghitung standard error mean 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\/kesalahan-standar-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Standard Error Mean di Excel","og_description":"Penjelasan sederhana cara menghitung standard error mean di excel beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T07:03:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreur_standard_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\/kesalahan-standar-excel\/","url":"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/","name":"Cara Menghitung Standard Error Mean di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T07:03:04+00:00","dateModified":"2023-07-28T07:03:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung standard error mean di excel beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kesalahan-standar-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung standard error mean 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\/929"}],"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=929"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/929\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}