{"id":3704,"date":"2023-07-16T01:09:38","date_gmt":"2023-07-16T01:09:38","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/"},"modified":"2023-07-16T01:09:38","modified_gmt":"2023-07-16T01:09:38","slug":"rata-rata-grafik-excel-dan-deviasi-standar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/","title":{"rendered":"Cara membuat plot mean dan deviasi standar di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin memplot mean dan deviasi standar dari berbagai kelompok data di Excel, seperti pada bagan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30243\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intrigue-moyenne8.jpg\" alt=\"plot mean dan deviasi standar di Excel\" width=\"586\" height=\"371\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut yang menunjukkan poin yang dicetak oleh pemain bola basket berbeda di tiga tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30235 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne-de-lintrigue1.jpg\" alt=\"\" width=\"537\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung mean dan deviasi standar untuk setiap kelompok<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya kita akan menghitung rata-rata dan deviasi standar masing-masing tim:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30236 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne-de-lintrigue2.jpg\" alt=\"\" width=\"636\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut rumus yang kami gunakan untuk menghitung mean dan deviasi standar di setiap baris:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sel H2: <strong>= RATA-RATA (B2: F2)<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Sel I2: <strong>=STDEV(B2:F2)<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami kemudian menyalin dan menempelkan rumus ini ke setiap sel di kolom H dan I untuk menghitung rata-rata dan deviasi standar masing-masing tim.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Gambarkan<\/strong><\/span> <span style=\"color: #000000;\"><strong>mean dan deviasi standar untuk setiap kelompok<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Berikutnya, sorot rentang sel <strong>H2:H4<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu klik ikon <strong>Kolom Tergugus<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-a-bandes.jpg\" alt=\"\" width=\"591\" height=\"141\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Akan muncul grafik batang berikut yang menunjukkan rata-rata jumlah poin yang dicetak masing-masing tim:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30238 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne-de-lintrigue3.jpg\" alt=\"\" width=\"506\" height=\"309\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menambahkan nilai standar deviasi pada setiap batang, klik di mana saja pada grafik, lalu klik tanda plus (+) berwarna hijau di pojok kanan atas, lalu klik <strong>Error Bars<\/strong> , lalu klik <strong>opsi Plus<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30239 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne-de-lintrigue4.jpg\" alt=\"\" width=\"626\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel baru yang muncul di sisi kanan layar, klik ikon bernama <strong>Error Bar Options<\/strong> , lalu klik tombol <strong>Custom<\/strong> di bawah <strong>Error Amount<\/strong> , lalu klik tombol <strong>Specify Value<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30240 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne-de-lintrigue5.jpg\" alt=\"\" width=\"324\" height=\"590\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pada jendela baru yang muncul, pilih cell range <strong>I2:I4<\/strong> untuk <strong>nilai error positif<\/strong> dan <strong>nilai error negatif<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30241 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne-de-lintrigue6.jpg\" alt=\"\" width=\"513\" height=\"534\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , garis deviasi standar akan secara otomatis ditambahkan ke setiap batang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30242 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne-de-lintrigue7.jpg\" alt=\"\" width=\"551\" height=\"365\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagian atas setiap bilah biru mewakili rata-rata poin yang dicetak oleh masing-masing tim dan garis hitam mewakili deviasi standar poin yang dicetak oleh masing-masing tim.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Sesuaikan bagan (opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, silakan tambahkan judul, sesuaikan warna, dan tambahkan label sumbu agar bagan lebih mudah dibaca:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30243 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intrigue-moyenne8.jpg\" alt=\"\" width=\"586\" height=\"371\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menggambar-banyak-garis-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Scatter Plot dengan Beberapa Seri di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin memplot mean dan deviasi standar dari berbagai kelompok data di Excel, seperti pada bagan di bawah ini: Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan data berikut yang menunjukkan poin yang dicetak oleh pemain bola basket berbeda di tiga tim berbeda: [&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 Membuat Plot Mean dan Deviasi Standar di Excel (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memplot mean dan deviasi standar grup di Excel, 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\/rata-rata-grafik-excel-dan-deviasi-standar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Mean dan Deviasi Standar di Excel (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memplot mean dan deviasi standar grup di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T01:09:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intrigue-moyenne8.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\/rata-rata-grafik-excel-dan-deviasi-standar\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/\",\"name\":\"Cara Membuat Plot Mean dan Deviasi Standar di Excel (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T01:09:38+00:00\",\"dateModified\":\"2023-07-16T01:09:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memplot mean dan deviasi standar grup di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot mean dan deviasi standar di excel (dengan contoh)\"}]},{\"@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 Membuat Plot Mean dan Deviasi Standar di Excel (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara memplot mean dan deviasi standar grup di Excel, 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\/rata-rata-grafik-excel-dan-deviasi-standar\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Mean dan Deviasi Standar di Excel (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara memplot mean dan deviasi standar grup di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/","og_site_name":"Statorials","article_published_time":"2023-07-16T01:09:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intrigue-moyenne8.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\/rata-rata-grafik-excel-dan-deviasi-standar\/","url":"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/","name":"Cara Membuat Plot Mean dan Deviasi Standar di Excel (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T01:09:38+00:00","dateModified":"2023-07-16T01:09:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memplot mean dan deviasi standar grup di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot mean dan deviasi standar di excel (dengan contoh)"}]},{"@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\/3704"}],"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=3704"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3704\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}