{"id":3210,"date":"2023-07-18T16:21:23","date_gmt":"2023-07-18T16:21:23","guid":{"rendered":"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/"},"modified":"2023-07-18T16:21:23","modified_gmt":"2023-07-18T16:21:23","slug":"uji-normalitas-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/","title":{"rendered":"Cara melakukan uji normalitas di google sheets"},"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<ul>\n<li> <span style=\"color: #000000;\"><strong>H <sub>0<\/sub><\/strong> : Data berdistribusi normal.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>H <sub style=\"color: #000000;\">A<\/sub><\/strong> : Data <em>tidak<\/em> berdistribusi normal.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Statistik uji <em><strong>JB<\/strong><\/em> didefinisikan sebagai:<\/span><\/p>\n<p style=\"text-align: left;\"> <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 Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan 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-27246 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-normalite1.jpg\" alt=\"\" width=\"466\" height=\"450\" 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 kita akan menghitung statistik uji JB.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kolom <strong>E<\/strong> menunjukkan rumus yang digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27247 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-normalite2.jpg\" alt=\"\" width=\"617\" height=\"460\" 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 <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">nilai p<\/a> tes tersebut, kita akan menggunakan rumus berikut:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>=CHISQ.DIST.RT(statistik uji JB, 2)<\/strong><\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-27248 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-normalite3.jpg\" alt=\"uji normalitas di Google Sheets\" width=\"648\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai p dari tes ini adalah <strong>0,601244<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ingatlah bahwa uji normalitas Jarque-Bera ini menggunakan hipotesis berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>H <sub>0<\/sub><\/strong> : Data berdistribusi normal.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>H <sub style=\"color: #000000;\">A<\/sub><\/strong> : Data <em>tidak<\/em> berdistribusi normal.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Karena nilai p ini tidak kurang dari 0,05, kita gagal menolak hipotesis nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya kita tidak memiliki cukup bukti untuk mengatakan bahwa kumpulan data tersebut 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> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tidak-menguji-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan uji-t di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan tes F di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Interval Keyakinan di Google Spreadsheet<\/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 Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan uji normalitas di Google Sheets, dengan sebuah 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\/uji-normalitas-google-sheet\/\" \/>\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 Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan uji normalitas di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T16:21:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-normalite1.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=\"2 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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/\",\"name\":\"Cara Melakukan Uji Normalitas di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T16:21:23+00:00\",\"dateModified\":\"2023-07-18T16:21:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan uji normalitas di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan uji normalitas di google sheets\"}]},{\"@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 Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara melakukan uji normalitas di Google Sheets, dengan sebuah 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\/uji-normalitas-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Uji Normalitas di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara melakukan uji normalitas di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-18T16:21:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-normalite1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/","url":"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/","name":"Cara Melakukan Uji Normalitas di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T16:21:23+00:00","dateModified":"2023-07-18T16:21:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan uji normalitas di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/uji-normalitas-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan uji normalitas di google sheets"}]},{"@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\/3210"}],"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=3210"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3210\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}