{"id":2012,"date":"2023-07-24T02:31:46","date_gmt":"2023-07-24T02:31:46","guid":{"rendered":"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/"},"modified":"2023-07-24T02:31:46","modified_gmt":"2023-07-24T02:31:46","slug":"nilai-yang-diharapkan-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/","title":{"rendered":"Cara menghitung nilai yang diharapkan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Distribusi probabilitas memberi tahu kita probabilitas suatu variabel acak mengambil nilai tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, distribusi probabilitas berikut memberi tahu kita probabilitas bahwa tim sepak bola tertentu akan mencetak sejumlah gol dalam pertandingan tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14093 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennedist1.png\" alt=\"\" width=\"261\" height=\"185\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari <strong>nilai ekspektasi<\/strong> dari suatu distribusi probabilitas, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u03bc = \u03a3x * P(x)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">x: nilai data<\/span><\/li>\n<li> <span style=\"color: #000000;\">P(x): Probabilitas nilai<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Misalnya, jumlah gol yang diharapkan untuk tim sepak bola akan dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u03bc = 0*0,18 + 1*0,34 + 2*0,35 + 3*0,11 + 4*0,02 = <strong>1,45<\/strong> gol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memberikan contoh langkah demi langkah tentang cara menghitung nilai yang diharapkan dari distribusi probabilitas di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai data dan probabilitas yang sesuai untuk distribusi probabilitas tertentu:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18875 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/attendu1.png\" alt=\"\" width=\"525\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong><span style=\"color: #000000;\">Langkah 2: Kalikan nilai dan probabilitas<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, kita mengalikan angka pertama pada kolom \u201cNilai\u201d dengan angka pertama pada kolom \u201cProbabilitas\u201d:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18876 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/attendu2.png\" alt=\"\" width=\"566\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyalin dan menempelkan rumus ini ke setiap sel di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18877 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/attendu3.png\" alt=\"\" width=\"573\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung nilai yang diharapkan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Terakhir, kita dapat menghitung nilai yang diharapkan dari distribusi probabilitas menggunakan <strong>SUM(C2:C10)<\/strong> untuk menjumlahkan semua nilai di kolom C:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18878 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/attendu4.png\" alt=\"Nilai yang diharapkan di Excel\" width=\"553\" height=\"553\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai yang diharapkan untuk distribusi probabilitas ini adalah <strong>3.3<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menghitung statistik deskriptif lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/mode-excel-rata-rata-median\/\" target=\"_blank\" rel=\"noopener\">Cara Mencari Mean, Median dan Modus di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Koefisien Variasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi probabilitas memberi tahu kita probabilitas suatu variabel acak mengambil nilai tertentu. Misalnya, distribusi probabilitas berikut memberi tahu kita probabilitas bahwa tim sepak bola tertentu akan mencetak sejumlah gol dalam pertandingan tertentu: Untuk mencari nilai ekspektasi dari suatu distribusi probabilitas, kita dapat menggunakan rumus berikut: \u03bc = \u03a3x * P(x) Emas: x: nilai data P(x): [&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 Nilai yang Diharapkan di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai yang diharapkan dari distribusi probabilitas 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\/nilai-yang-diharapkan-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Nilai yang Diharapkan di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai yang diharapkan dari distribusi probabilitas di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T02:31:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennedist1.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\/nilai-yang-diharapkan-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/\",\"name\":\"Cara Menghitung Nilai yang Diharapkan di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T02:31:46+00:00\",\"dateModified\":\"2023-07-24T02:31:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai yang diharapkan dari distribusi probabilitas di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung nilai yang diharapkan 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 Nilai yang Diharapkan di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung nilai yang diharapkan dari distribusi probabilitas 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\/nilai-yang-diharapkan-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Nilai yang Diharapkan di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung nilai yang diharapkan dari distribusi probabilitas di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-24T02:31:46+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennedist1.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\/nilai-yang-diharapkan-unggul\/","url":"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/","name":"Cara Menghitung Nilai yang Diharapkan di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T02:31:46+00:00","dateModified":"2023-07-24T02:31:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai yang diharapkan dari distribusi probabilitas di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nilai-yang-diharapkan-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung nilai yang diharapkan 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\/2012"}],"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=2012"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2012\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}