{"id":3144,"date":"2023-07-19T00:17:54","date_gmt":"2023-07-19T00:17:54","guid":{"rendered":"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/"},"modified":"2023-07-19T00:17:54","modified_gmt":"2023-07-19T00:17:54","slug":"jejak-log-distribusi-normal-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/","title":{"rendered":"Cara memplot distribusi log-normal di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial langkah demi langkah ini menjelaskan cara memplot distribusi log-normal berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26752 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lognormalexcel4.jpg\" alt=\"\" width=\"538\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Tetapkan Nilai X<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita tentukan rentang nilai X yang akan digunakan untuk plot kita.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26749 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lognormalexcel1.jpg\" alt=\"\" width=\"427\" height=\"495\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung Nilai Y<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Nilai y pada plot akan mewakili nilai PDF yang terkait dengan distribusi lognormal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghitung PDF distribusi lognormal yang terkait dengan nilai x 0,01, nilai rata-rata 1, dan deviasi standar 1:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LOGNORM.DIST( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$E$1<\/span> , <span style=\"color: #800080;\">$E$2<\/span> , FALSE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26750 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lognormalexcel2.jpg\" alt=\"\" width=\"558\" height=\"534\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Plot distribusi log-normal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot cell range <strong>A2:B22<\/strong> , lalu klik tab <strong>Insert<\/strong> di sepanjang pita atas, lalu klik opsi <strong>Scatter<\/strong> di grup <strong>Charts<\/strong> dan klik <strong>Scatter with Smooth Lines<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25974 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/scattersmoothexcel.jpg\" alt=\"\" width=\"519\" height=\"274\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26751 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lognormalexcel3.jpg\" alt=\"\" width=\"623\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menunjukkan nilai variabel acak yang mengikuti distribusi log-normal dengan nilai rata-rata 1 dan simpangan baku 1, dan sumbu y menunjukkan nilai PDF yang sesuai dari distribusi log-normal .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda mengubah nilai mean atau deviasi standar masing-masing di sel <strong>E1<\/strong> dan <strong>E2<\/strong> , plot akan diperbarui secara otomatis.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Ubah Tampilan Jalur<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan judul, label sumbu, dan menghapus garis kisi untuk membuat plot lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26752 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lognormalexcel4.jpg\" alt=\"\" width=\"538\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara memplot distribusi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana Menggambar Kurva Lonceng di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Distribusi Binomial di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/\" target=\"_blank\" rel=\"noopener\">Cara memplot distribusi Poisson di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial langkah demi langkah ini menjelaskan cara memplot distribusi log-normal berikut di Excel: Langkah 1: Tetapkan Nilai X Pertama, mari kita tentukan rentang nilai X yang akan digunakan untuk plot kita. Langkah 2: Hitung Nilai Y Nilai y pada plot akan mewakili nilai PDF yang terkait dengan distribusi lognormal. Kita dapat mengetikkan rumus berikut di [&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 Distribusi Log-Normal di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memplot distribusi log-normal di Excel, termasuk contoh langkah demi langkah.\" \/>\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\/jejak-log-distribusi-normal-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Distribusi Log-Normal di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memplot distribusi log-normal di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T00:17:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lognormalexcel4.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/\",\"name\":\"Cara Membuat Plot Distribusi Log-Normal di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T00:17:54+00:00\",\"dateModified\":\"2023-07-19T00:17:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memplot distribusi log-normal di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memplot distribusi log-normal 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 Membuat Plot Distribusi Log-Normal di Excel - Statorials","description":"Tutorial ini menjelaskan cara memplot distribusi log-normal di Excel, termasuk contoh langkah demi langkah.","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\/jejak-log-distribusi-normal-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Distribusi Log-Normal di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara memplot distribusi log-normal di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T00:17:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lognormalexcel4.jpg"}],"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\/jejak-log-distribusi-normal-excel\/","url":"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/","name":"Cara Membuat Plot Distribusi Log-Normal di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T00:17:54+00:00","dateModified":"2023-07-19T00:17:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memplot distribusi log-normal di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jejak-log-distribusi-normal-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memplot distribusi log-normal 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\/3144"}],"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=3144"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3144\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}