{"id":1493,"date":"2023-07-26T04:22:36","date_gmt":"2023-07-26T04:22:36","guid":{"rendered":"https:\/\/statorials.org\/id\/uji-normalitas-excel\/"},"modified":"2023-07-26T04:22:36","modified_gmt":"2023-07-26T04:22:36","slug":"uji-normalitas-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/uji-normalitas-excel\/","title":{"rendered":"Cara melakukan uji normalitas di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Banyak uji statistik yang berasumsi bahwa nilai-nilai dalam suatu kumpulan data terdistribusi normal .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Salah satu cara paling sederhana untuk menguji hipotesis ini adalah dengan melakukan <strong>uji Jarque-Bera<\/strong> , yaitu uji goodness-of-fit yang menentukan apakah data sampel menunjukkan skewness dan kurtosis yang konsisten dengan distribusi normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pengujian ini menggunakan asumsi berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">H <sub>0<\/sub> : Data berdistribusi normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">H <sub>A<\/sub> : Data <em>tidak<\/em> berdistribusi normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Statistik uji <em><strong>JB<\/strong><\/em> didefinisikan sebagai:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><em><strong>JB<\/strong><\/em> =(n\/6) * (S <sup>2<\/sup> + (C <sup>2<\/sup> \/4))<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>n :<\/strong> jumlah <a href=\"https:\/\/statorials.org\/id\/pengamatan-dalam-statistik\/\" target=\"_blank\" rel=\"noopener\">observasi<\/a> dalam sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>S:<\/strong> asimetri sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>C:<\/strong> sampel yang bagus<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Berdasarkan hipotesis normalitas nol, <em>JB ~<\/em> X <sup>2<\/sup> (2).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">p-value<\/a> yang sesuai dengan statistik uji berada di bawah tingkat signifikansi tertentu (misalnya \u03b1 = 0,05), maka kita dapat menolak hipotesis nol dan menyimpulkan bahwa data tidak berdistribusi normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan pengujian Jarque-Bera untuk kumpulan data tertentu di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/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=\"wp-image-14778 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel2.png\" alt=\"\" width=\"410\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung statistik pengujian<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya menghitung statistik uji JB. Kolom E menunjukkan rumus yang digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14787 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliteexcel1.png\" alt=\"\" width=\"562\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Statistik pengujiannya ternyata <strong>1,0175<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung nilai P<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Berdasarkan hipotesis normalitas nol, statistik uji JB mengikuti distribusi Chi-kuadrat dengan 2 derajat kebebasan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, untuk mencari nilai p untuk pengujian tersebut, kita akan menggunakan fungsi berikut di Excel:<\/span> <span style=\"color: #000000;\"><strong>=CHISQ.DIST.RT(Statistik pengujian JB, 2)<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14788 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliteexcel2.png\" alt=\"Uji normalitas di Excel\" width=\"492\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai p dari tes ini adalah <strong>0,601244<\/strong> . Karena nilai p ini tidak kurang dari 0,05, kita gagal menolak hipotesis nol. Kami tidak memiliki cukup bukti untuk mengatakan bahwa kumpulan data tidak terdistribusi secara normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan kata lain, data dapat diasumsikan berdistribusi normal.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/beberapa-plot-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot QQ di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/uji-kecocokan-kualitas-chi-kuadrat-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Uji Kesesuaian Chi Kuadrat di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Banyak uji statistik yang berasumsi bahwa nilai-nilai dalam suatu kumpulan data terdistribusi normal . Salah satu cara paling sederhana untuk menguji hipotesis ini adalah dengan melakukan uji Jarque-Bera , yaitu uji goodness-of-fit yang menentukan apakah data sampel menunjukkan skewness dan kurtosis yang konsisten dengan distribusi normal. Pengujian ini menggunakan asumsi berikut: H 0 : Data [&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 Melakukan Uji Normalitas di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan uji normalitas 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\/uji-normalitas-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Uji Normalitas di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan uji normalitas di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/uji-normalitas-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T04:22:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel2.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\/uji-normalitas-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/uji-normalitas-excel\/\",\"name\":\"Cara Melakukan Uji Normalitas di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T04:22:36+00:00\",\"dateModified\":\"2023-07-26T04:22:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan uji normalitas di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/uji-normalitas-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/uji-normalitas-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/uji-normalitas-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan uji normalitas 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 Melakukan Uji Normalitas di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara melakukan uji normalitas 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\/uji-normalitas-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Uji Normalitas di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara melakukan uji normalitas di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/uji-normalitas-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T04:22:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel2.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\/uji-normalitas-excel\/","url":"https:\/\/statorials.org\/id\/uji-normalitas-excel\/","name":"Cara Melakukan Uji Normalitas di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T04:22:36+00:00","dateModified":"2023-07-26T04:22:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan uji normalitas di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/uji-normalitas-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/uji-normalitas-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/uji-normalitas-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan uji normalitas 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\/1493"}],"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=1493"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1493\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}