{"id":1226,"date":"2023-07-27T05:33:05","date_gmt":"2023-07-27T05:33:05","guid":{"rendered":"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/"},"modified":"2023-07-27T05:33:05","modified_gmt":"2023-07-27T05:33:05","slug":"distribusi-sampel-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/","title":{"rendered":"Cara menghitung distribusi sampling di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-pengambilan-sampel-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">Distribusi sampling<\/a> adalah distribusi probabilitas suatu <a href=\"https:\/\/statorials.org\/id\/statistik-vs-parameter\/\" target=\"_blank\" rel=\"noopener noreferrer\">statistik<\/a> tertentu berdasarkan banyak sampel acak dari satu <a href=\"https:\/\/statorials.org\/id\/populasi-vs.-sampel\/\" target=\"_blank\" rel=\"noopener\">populasi<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukan hal berikut dengan distribusi sampling di Excel:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Hasilkan distribusi pengambilan sampel.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Visualisasikan distribusi pengambilan sampel.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Hitung mean dan deviasi standar distribusi sampling.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Hitung probabilitas mengenai distribusi sampling.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Hasilkan distribusi pengambilan sampel di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghasilkan distribusi sampling yang terdiri dari <strong>1.000<\/strong> sampel yang masing-masing ukuran sampelnya adalah <strong>20<\/strong> dan berasal dari distribusi normal dengan mean <strong>5,3<\/strong> dan standar deviasi <strong>9<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat dengan mudah melakukan ini dengan mengetikkan rumus berikut ke dalam sel A2 spreadsheet kita:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>= <span style=\"color: #3366ff;\">NORM<\/span> . <span style=\"color: #3366ff;\">INV<\/span> ( <span style=\"color: #3366ff;\">RAND<\/span> (), 5.3, 9)<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengarahkan kursor ke sudut kanan bawah sel hingga tanda <strong>+<\/strong> kecil muncul dan menyeret rumus ke kanan sebanyak 20 sel dan ke bawah 1000 sel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12150 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenneexcel4.png\" alt=\"Rata-rata Pengambilan Sampel di Excel\" width=\"673\" height=\"236\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Setiap baris mewakili sampel berukuran 20 yang setiap nilainya berasal dari distribusi normal dengan mean 5,3 dan standar deviasi 9.<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Temukan mean dan deviasi standar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mencari mean dan deviasi standar dari distribusi sampling mean sampel ini, pertama-tama kita dapat mencari mean setiap sampel dengan mengetikkan rumus berikut ke dalam sel U2 pada lembar kerja kita:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>= <span style=\"color: #3366ff;\">AVERAGE<\/span> (A2:T2)<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengarahkan kursor ke sudut kanan bawah sel hingga tanda <strong>+<\/strong> kecil muncul dan klik dua kali untuk menyalin rumus ini ke semua sel lain di kolom U:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12151 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenneexcel5.png\" alt=\"\" width=\"412\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat sampel pertama mempunyai mean 7,563684, sampel kedua mempunyai mean 10,97299, dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan rumus berikut untuk menghitung mean dan deviasi standar mean sampel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12152 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenneexcel6.png\" alt=\"\" width=\"359\" height=\"294\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara teoritis, rata-rata distribusi sampling harusnya 5,3. Kita dapat melihat bahwa rata-rata sampel sebenarnya dalam contoh ini adalah <strong>5.367869<\/strong> , yang mendekati 5.3.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dan secara teori, simpangan baku distribusi sampling harus sama dengan s\/\u221an, yaitu 9 \/ \u221a20 = 2,012. Kita dapat melihat bahwa simpangan baku sebenarnya dari distribusi sampling adalah <strong>2,075396<\/strong> , yang mendekati 2,012.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Visualisasikan distribusi pengambilan sampel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita juga dapat membuat histogram sederhana untuk memvisualisasikan distribusi sampling dari rata-rata sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, cukup sorot semua mean sampel di kolom U, klik tab <strong>Sisipkan<\/strong> , lalu klik opsi <strong>Histogram<\/strong> di bawah bagian <strong>Bagan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberikan histogram berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12149 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenneexcel3.png\" alt=\"Pengambilan Sampel Histogram Distribusi di Excel\" width=\"506\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat distribusi samplingnya berbentuk lonceng dengan puncak mendekati nilai 5.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun dari ekor distribusinya kita dapat melihat bahwa beberapa sampel memiliki mean lebih besar dari 10 dan sampel lainnya memiliki mean kurang dari 0.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Hitung probabilitasnya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita juga dapat menghitung probabilitas memperoleh nilai rata-rata sampel tertentu, berdasarkan rata-rata populasi, deviasi standar populasi, dan ukuran sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan rumus berikut untuk mencari probabilitas bahwa mean sampel kurang dari atau sama dengan 6, jika mean populasi adalah 5,3, deviasi standar populasi adalah 9, dan ukuran sampel adalah:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>= <span style=\"color: #3366ff;\">COUNTIF<\/span> (U2:U1001, \" <span style=\"color: #008000;\">&lt;=6<\/span> \")\/ <span style=\"color: #3366ff;\">COUNT<\/span> (U2:U1001)\n<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12153 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenneexcel7.png\" alt=\"Contoh Distribusi Sampling di Excel\" width=\"488\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita melihat bahwa probabilitas mean sampel kurang dari atau sama dengan 6 adalah <strong>0,638.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sangat dekat dengan probabilitas yang dihitung oleh <a href=\"https:\/\/statorials.org\/id\/kalkulator-distribusi-sampling\/\" target=\"_blank\" rel=\"noopener noreferrer\">Kalkulator Distribusi Sampling<\/a> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12123 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenne2.png\" alt=\"Perhitungan distribusi sampling\" width=\"358\" height=\"550\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/distribusi-pengambilan-sampel-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pengantar Distribusi Sampling<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kalkulator-distribusi-sampling\/\" target=\"_blank\" rel=\"noopener noreferrer\">Kalkulator Distribusi Sampling<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/teorema-limit-pusat\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pengantar Teorema Limit Pusat<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi sampling adalah distribusi probabilitas suatu statistik tertentu berdasarkan banyak sampel acak dari satu populasi . Tutorial ini menjelaskan cara melakukan hal berikut dengan distribusi sampling di Excel: Hasilkan distribusi pengambilan sampel. Visualisasikan distribusi pengambilan sampel. Hitung mean dan deviasi standar distribusi sampling. Hitung probabilitas mengenai distribusi sampling. Hasilkan distribusi pengambilan sampel di Excel Misalkan [&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 Distribusi Sampling di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung distribusi sampling 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\/distribusi-sampel-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 Distribusi Sampling di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung distribusi sampling di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T05:33:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenneexcel4.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\/distribusi-sampel-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/\",\"name\":\"Cara Menghitung Distribusi Sampling di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T05:33:05+00:00\",\"dateModified\":\"2023-07-27T05:33:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung distribusi sampling di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung distribusi sampling 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 Distribusi Sampling di Excel","description":"Tutorial ini menjelaskan cara menghitung distribusi sampling 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\/distribusi-sampel-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Distribusi Sampling di Excel","og_description":"Tutorial ini menjelaskan cara menghitung distribusi sampling di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T05:33:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillonnagemoyenneexcel4.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\/distribusi-sampel-di-excel\/","url":"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/","name":"Cara Menghitung Distribusi Sampling di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T05:33:05+00:00","dateModified":"2023-07-27T05:33:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung distribusi sampling di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/distribusi-sampel-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung distribusi sampling 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\/1226"}],"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=1226"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1226\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}