{"id":1561,"date":"2023-07-25T21:26:14","date_gmt":"2023-07-25T21:26:14","guid":{"rendered":"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/"},"modified":"2023-07-25T21:26:14","modified_gmt":"2023-07-25T21:26:14","slug":"distribusi-segitiga-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/","title":{"rendered":"Cara menggunakan distribusi segitiga di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-segitiga\/\" target=\"_blank\" rel=\"noopener\">Distribusi segitiga<\/a> merupakan distribusi probabilitas kontinu dengan fungsi kepadatan probabilitas berbentuk segitiga.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini ditentukan oleh tiga nilai:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai minimumnya <em>adalah<\/em><\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <em>maksimumb<\/em><\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai maksimum <em>c<\/em><\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13844 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangulaire1-1.png\" alt=\"Distribusi segitiga\" width=\"450\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nama distribusinya berasal dari fakta bahwa fungsi kepadatan probabilitas berbentuk segitiga.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Distribusi segitiga memiliki <a href=\"https:\/\/statorials.org\/id\/cdf-vs-pdf\/\" target=\"_blank\" rel=\"noopener\">PDF dan CDF<\/a> berikut :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>PDF:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13846 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangulaire3.png\" alt=\"PDF untuk distribusi segitiga\" width=\"315\" height=\"244\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>CDF:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15449 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangulaire4.png\" alt=\"\" width=\"322\" height=\"179\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan distribusi segitiga untuk menghitung probabilitas di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Penjualan restoran<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah sebuah restoran memperkirakan total penjualannya untuk minggu mendatang adalah minimal $10.000, maksimal $30.000, dan kemungkinan besar $25.000.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-13845 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangulaire2.png\" alt=\"\" width=\"385\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Berapa probabilitas restoran tersebut mempunyai total penjualan kurang dari $20.000?<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Menurut CDF, kita dapat menggunakan rumus berikut untuk mencari probabilitas total penjualan kurang dari $20.000:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">P(X &lt; x) = (xa) <sup>2<\/sup> \/ ((ba)(ca))<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Berikut cara menghitung probabilitas ini di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15452 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangleexcel1.png\" alt=\"Distribusi Segitiga di Excel\" width=\"481\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang restoran tersebut mempunyai total penjualan kurang dari $20.000 adalah <strong>0,333<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Jumlah pelanggan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah sebuah toko memperkirakan jumlah pelanggan yang akan datang pada minggu tertentu adalah minimal 500, maksimal 2.000, dan kemungkinan besar 1.200.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15453 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangleexcel2.png\" alt=\"\" width=\"394\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Berapa probabilitas lebih dari 1.500 pelanggan memasuki toko pada minggu tertentu?<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Menurut CDF, kita dapat menggunakan rumus berikut untuk mencari probabilitas jumlah total pelanggan lebih besar dari 1.500:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">P(X &gt; x) = 1 \u2013 [1 \u2013 (bx) <sup>2<\/sup> \/ ((ba)(bc))]<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Berikut cara menghitung probabilitas ini di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15454\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangleexcel3.png\" alt=\"\" width=\"505\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang lebih dari 1.500 pelanggan memasuki toko adalah <strong>0,208.<\/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 menggunakan distribusi probabilitas lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/distribusi-binomial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan distribusi binomial di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/distribusi-ikan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan distribusi Poisson di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/distribusi-seragam-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan distribusi seragam di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi segitiga merupakan distribusi probabilitas kontinu dengan fungsi kepadatan probabilitas berbentuk segitiga. Ini ditentukan oleh tiga nilai: Nilai minimumnya adalah Nilai maksimumb Nilai maksimum c Nama distribusinya berasal dari fakta bahwa fungsi kepadatan probabilitas berbentuk segitiga. Distribusi segitiga memiliki PDF dan CDF berikut : PDF: CDF: Contoh berikut memperlihatkan cara menggunakan distribusi segitiga untuk menghitung [&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 Menggunakan Distribusi Segitiga di Excel (Dengan Contoh)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan distribusi segitiga di Excel, dengan beberapa 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-segitiga-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Distribusi Segitiga di Excel (Dengan Contoh)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan distribusi segitiga di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T21:26:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangulaire1-1.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\/distribusi-segitiga-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/\",\"name\":\"Cara Menggunakan Distribusi Segitiga di Excel (Dengan Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T21:26:14+00:00\",\"dateModified\":\"2023-07-25T21:26:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan distribusi segitiga di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan distribusi segitiga 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 Menggunakan Distribusi Segitiga di Excel (Dengan Contoh)","description":"Tutorial ini menjelaskan cara menggunakan distribusi segitiga di Excel, dengan beberapa 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-segitiga-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Distribusi Segitiga di Excel (Dengan Contoh)","og_description":"Tutorial ini menjelaskan cara menggunakan distribusi segitiga di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T21:26:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triangulaire1-1.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\/distribusi-segitiga-excel\/","url":"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/","name":"Cara Menggunakan Distribusi Segitiga di Excel (Dengan Contoh)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T21:26:14+00:00","dateModified":"2023-07-25T21:26:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan distribusi segitiga di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/distribusi-segitiga-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan distribusi segitiga 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\/1561"}],"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=1561"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1561\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}