{"id":715,"date":"2023-07-29T00:20:10","date_gmt":"2023-07-29T00:20:10","guid":{"rendered":"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/"},"modified":"2023-07-29T00:20:10","modified_gmt":"2023-07-29T00:20:10","slug":"jarque-akan-menjadi-tes-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/","title":{"rendered":"Cara melakukan tes jarque-bera di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Uji Jarque-Bera<\/strong> merupakan uji goodness-of-fit yang menentukan apakah data sampel menunjukkan skewness dan kurtosis yang sesuai dengan distribusi normal .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Statistik uji Jarque-Bera selalu bernilai positif dan jika jauh dari nol berarti data sampel tidak 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 observasi 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;\">Di bawah hipotesis <sup>normalitas<\/sup> nol, <em>JB ~<\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukan tes Jarque-Bera di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Tes Jarque-Bera di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Gunakan langkah-langkah berikut untuk melakukan tes Jarque-Bera untuk kumpulan data tertentu di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan dataset ke dalam kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7094 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jarqueberaexcel1.png\" alt=\"Data mentah di Excel\" width=\"396\" height=\"341\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung statistik uji Jarque-Bera.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya menghitung statistik uji JB. Kolom F menunjukkan rumus yang digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7095 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jarqueberaexcel2.png\" alt=\"Tes Jarque Bera di Excel\" width=\"638\" height=\"372\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung nilai p tes tersebut.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ingatlah bahwa berdasarkan hipotesis normalitas nol, statistik uji JB mengikuti distribusi Chi-kuadrat dengan 2 derajat kebebasan. Jadi, untuk mencari nilai p pengujian, 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-7096 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jarqueberaexcel3.png\" alt=\"Contoh tes Jarque Bera di Excel\" width=\"637\" height=\"331\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai p dari tes ini adalah<\/span> <strong style=\"color: #000000;\">0,5921<\/strong> <span style=\"color: #000000;\">. 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","protected":false},"excerpt":{"rendered":"<p>Uji Jarque-Bera merupakan uji goodness-of-fit yang menentukan apakah data sampel menunjukkan skewness dan kurtosis yang sesuai dengan distribusi normal . Statistik uji Jarque-Bera selalu bernilai positif dan jika jauh dari nol berarti data sampel tidak berdistribusi normal. Statistik uji JB didefinisikan sebagai: JB =(n\/6) * (S 2 + (C 2 \/4)) Emas: n : jumlah [&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 Tes Jarque-Bera di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara melakukan tes Jarque-Bera 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\/jarque-akan-menjadi-tes-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Tes Jarque-Bera di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara melakukan tes Jarque-Bera di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T00:20:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jarqueberaexcel1.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\/jarque-akan-menjadi-tes-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/\",\"name\":\"Cara Melakukan Tes Jarque-Bera di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T00:20:10+00:00\",\"dateModified\":\"2023-07-29T00:20:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara melakukan tes Jarque-Bera di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan tes jarque-bera 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 Melakukan Tes Jarque-Bera di Excel - Statologi","description":"Penjelasan sederhana tentang cara melakukan tes Jarque-Bera 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\/jarque-akan-menjadi-tes-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Tes Jarque-Bera di Excel - Statologi","og_description":"Penjelasan sederhana tentang cara melakukan tes Jarque-Bera di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T00:20:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jarqueberaexcel1.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\/jarque-akan-menjadi-tes-excel\/","url":"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/","name":"Cara Melakukan Tes Jarque-Bera di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T00:20:10+00:00","dateModified":"2023-07-29T00:20:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara melakukan tes Jarque-Bera di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan tes jarque-bera 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\/715"}],"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=715"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/715\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}