{"id":1492,"date":"2023-07-26T04:28:53","date_gmt":"2023-07-26T04:28:53","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/"},"modified":"2023-07-26T04:28:53","modified_gmt":"2023-07-26T04:28:53","slug":"plot-probabilitas-normal-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/","title":{"rendered":"Cara membuat plot probabilitas normal di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Plot probabilitas normal<\/strong> dapat digunakan untuk menentukan apakah nilai-nilai dalam suatu kumpulan data mendekati distribusi normal .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14777 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel1.png\" alt=\"\" width=\"489\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat plot probabilitas normal untuk kumpulan data tertentu di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat kumpulan data<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data palsu dengan 15 nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14778 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel2.png\" alt=\"\" width=\"393\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung Nilai Z<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menggunakan rumus berikut untuk menghitung nilai z yang sesuai dengan nilai data pertama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NORM.S.INV((RANK( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$A$2:$A$16<\/span> , 1)-0.5)\/COUNT( <span style=\"color: #800080;\">A:A<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan menyalin rumus ini ke setiap sel di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14779 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel3.png\" alt=\"\" width=\"519\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Buat plot probabilitas normal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat plot probabilitas normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, sorot cell range A2:B16 sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di pita atas, klik tab <strong>Sisipkan<\/strong> . Di bagian <strong>Charts<\/strong> , klik opsi pertama di bawah <strong>Scatter<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14358 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/courbeexcel3.png\" alt=\"\" width=\"485\" height=\"373\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini secara otomatis menghasilkan grafik berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14781 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel5.png\" alt=\"\" width=\"479\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menampilkan nilai data yang diurutkan, dan sumbu y menampilkan nilai z yang sesuai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Silakan memodifikasi judul, sumbu, dan label untuk membuat plot lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14777\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel1.png\" alt=\"Bagan Probabilitas Normal di Excel\" width=\"489\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Bagaimana menafsirkan plot probabilitas normal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Cara menafsirkan plot probabilitas normal sederhana saja: jika nilai data mengikuti garis kira-kira lurus dengan sudut 45 derajat, maka data tersebut terdistribusi normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada grafik di atas terlihat bahwa nilai cenderung menyimpang dari garis lurus dengan sudut 45 derajat, terutama pada bagian ujungnya. Hal ini kemungkinan besar menunjukkan bahwa data tidak terdistribusi secara normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Meskipun plot probabilitas normal bukan merupakan uji statistik formal, plot ini memberikan cara sederhana untuk memeriksa secara visual apakah sekumpulan data terdistribusi normal atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda mencari uji normalitas formal, baca <a href=\"https:\/\/statorials.org\/id\/uji-normalitas-excel\/\" target=\"_blank\" rel=\"noopener\">tutorial<\/a> tentang cara melakukan uji normalitas di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Kurva Lonceng di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Poligon Frekuensi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/log-plot-log-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Log-Log di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plot probabilitas normal dapat digunakan untuk menentukan apakah nilai-nilai dalam suatu kumpulan data mendekati distribusi normal . Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat plot probabilitas normal untuk kumpulan data tertentu di Excel. Langkah 1: Buat kumpulan data Pertama, mari buat kumpulan data palsu dengan 15 nilai: Langkah 2: Hitung Nilai Z [&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 Probabilitas Normal di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat plot probabilitas normal di Excel, dengan 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\/plot-probabilitas-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 Probabilitas Normal di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat plot probabilitas normal di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T04:28:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel1.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\/plot-probabilitas-normal-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/\",\"name\":\"Cara Membuat Plot Probabilitas Normal di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T04:28:53+00:00\",\"dateModified\":\"2023-07-26T04:28:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat plot probabilitas normal di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot probabilitas normal di excel (langkah demi langkah)\"}]},{\"@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 Probabilitas Normal di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara membuat plot probabilitas normal di Excel, dengan 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\/plot-probabilitas-normal-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Probabilitas Normal di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara membuat plot probabilitas normal di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T04:28:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel1.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\/plot-probabilitas-normal-excel\/","url":"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/","name":"Cara Membuat Plot Probabilitas Normal di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T04:28:53+00:00","dateModified":"2023-07-26T04:28:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat plot probabilitas normal di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-probabilitas-normal-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot probabilitas normal di excel (langkah demi langkah)"}]},{"@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\/1492"}],"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=1492"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1492\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}