{"id":2507,"date":"2023-07-21T23:36:52","date_gmt":"2023-07-21T23:36:52","guid":{"rendered":"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/"},"modified":"2023-07-21T23:36:52","modified_gmt":"2023-07-21T23:36:52","slug":"tes-excel-kolmogorov-smirnov","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/","title":{"rendered":"Cara melakukan tes kolmogorov-smirnov di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Uji Kolmogorov-Smirnov<\/strong> digunakan untuk mengetahui apakah suatu sampel berdistribusi normal atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Uji ini banyak digunakan karena banyak uji dan prosedur statistik <a href=\"https:\/\/statorials.org\/id\/hipotesis-normalitas\/\" target=\"_blank\" rel=\"noopener\">yang mengasumsikan<\/a> bahwa data berdistribusi normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut memperlihatkan cara melakukan pengujian Kolmogorov-Smirnov pada kumpulan data sampel di Excel.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan datanya<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai dari kumpulan data dengan ukuran sampel n = 20:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22350 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ks1.jpg\" alt=\"\" width=\"414\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong><span style=\"color: #000000;\">Langkah 2: Hitung nilai aktual dan yang diharapkan dari distribusi normal<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menghitung nilai aktual versus nilai yang diharapkan dari distribusi normal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-22351\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ks2.jpg\" alt=\"Tes Kolmogorov-Smirnov di Excel\" width=\"665\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah rumus yang kami gunakan di sel yang berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>B2<\/strong> : =GARIS() \u2013 1<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>C2<\/strong> : = <span style=\"color: #0000ff;\">B2<\/span> \/JUMLAH( <span style=\"color: #ff0000;\">$A$2:$A$21<\/span> )<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>D2<\/strong> : =( <span style=\"color: #3366ff;\">B2<\/span> -1)\/JUMLAH( <span style=\"color: #ff0000;\">$A$2:$A$21<\/span> )<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>E2<\/strong> : =IF( <span style=\"color: #3366ff;\">C2<\/span> &lt;1, NORM.S.INV( <span style=\"color: #3366ff;\">C2<\/span> ),\u201d)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>F2<\/strong> : =NORM.DIST( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$J$1<\/span> , <span style=\"color: #800080;\">$J$2<\/span> , BENAR)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>G2<\/strong> : =ABS( <span style=\"color: #3366ff;\">F2<\/span> \u2013 <span style=\"color: #ff0000;\">D2<\/span> )<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>D1<\/strong> : =RATA-RATA( <span style=\"color: #3366ff;\">A2:A21<\/span> )<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>J2<\/strong> : =ETDEV.S( <span style=\"color: #3366ff;\">A2:A21<\/span> )<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>J4<\/strong> : =MAX( <span style=\"color: #3366ff;\">G2:G21<\/span> )<\/span><\/li>\n<\/ul>\n<h3> <strong><span style=\"color: #000000;\">Langkah 3: Interpretasikan hasilnya<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tes Kolmogorov-Smirnov menggunakan hipotesis nol dan alternatif 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>A<\/sub><\/strong> : Data tidak berdistribusi normal.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menentukan apakah kita harus menolak hipotesis nol atau tidak, kita perlu mengacu pada nilai <strong>maksimum<\/strong> pada output, yaitu <strong>0,10983<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini mewakili perbedaan absolut maksimum antara nilai aktual sampel kami dan nilai yang diharapkan dari distribusi normal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menentukan apakah nilai maksimum ini signifikan secara statistik, kita harus mengacu pada tabel nilai kritis Kolmogorov-Smirnov dan menemukan angka yang sama dengan n = 20 dan \u03b1 = 0,05.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai kritisnya ternyata <strong>0,190<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena nilai maksimum kita tidak lebih besar dari nilai kritis ini, kita gagal menolak hipotesis nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya kita dapat berasumsi bahwa data sampel kita 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 uji statistik umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tes-korelasi-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan tes korelasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tes-durbin-watson-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Tes Durbin-Watson di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jarque-akan-menjadi-tes-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Tes Jarque-Bera di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tes-excel-tingkat\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan tes Levene di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uji Kolmogorov-Smirnov digunakan untuk mengetahui apakah suatu sampel berdistribusi normal atau tidak. Uji ini banyak digunakan karena banyak uji dan prosedur statistik yang mengasumsikan bahwa data berdistribusi normal. Contoh langkah demi langkah berikut memperlihatkan cara melakukan pengujian Kolmogorov-Smirnov pada kumpulan data sampel di Excel. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan nilai dari [&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 Kolmogorov-Smirnov di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan uji normalitas Kolmogorov-Smirnov di Excel, 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\/tes-excel-kolmogorov-smirnov\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Tes Kolmogorov-Smirnov di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan uji normalitas Kolmogorov-Smirnov di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T23:36:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ks1.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\/tes-excel-kolmogorov-smirnov\/\",\"url\":\"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/\",\"name\":\"Cara Melakukan Tes Kolmogorov-Smirnov di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T23:36:52+00:00\",\"dateModified\":\"2023-07-21T23:36:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan uji normalitas Kolmogorov-Smirnov di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan tes kolmogorov-smirnov 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 Kolmogorov-Smirnov di Excel - Statologi","description":"Tutorial ini menjelaskan cara melakukan uji normalitas Kolmogorov-Smirnov di Excel, 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\/tes-excel-kolmogorov-smirnov\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Tes Kolmogorov-Smirnov di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan uji normalitas Kolmogorov-Smirnov di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/","og_site_name":"Statorials","article_published_time":"2023-07-21T23:36:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ks1.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\/tes-excel-kolmogorov-smirnov\/","url":"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/","name":"Cara Melakukan Tes Kolmogorov-Smirnov di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T23:36:52+00:00","dateModified":"2023-07-21T23:36:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan uji normalitas Kolmogorov-Smirnov di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan tes kolmogorov-smirnov 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\/2507"}],"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=2507"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2507\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}