{"id":1648,"date":"2023-07-25T12:56:56","date_gmt":"2023-07-25T12:56:56","guid":{"rendered":"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/"},"modified":"2023-07-25T12:56:56","modified_gmt":"2023-07-25T12:56:56","slug":"transformasi-box-cox-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/","title":{"rendered":"Transformasi box-cox di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Transformasi box-cox<\/strong> adalah metode yang umum digunakan untuk mengubah kumpulan data yang tidak terdistribusi normal menjadi kumpulan data yang lebih terdistribusi normal .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ide dasarnya adalah mencari nilai \u03bb sedemikian rupa sehingga data yang ditransformasikan sedekat mungkin dengan distribusi normal, dengan menggunakan rumus berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">y(\u03bb) = (y <sup>\u03bb<\/sup> \u2013 1) \/ \u03bb jika y \u2260 0<\/span><\/li>\n<li> <span style=\"color: #000000;\">y(\u03bb) = log(y) jika y = 0<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara melakukan transformasi box-cox pada kumpulan data di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai dari kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16242 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel1.png\" alt=\"\" width=\"432\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Urutkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian buat kolom indeks dan kolom data yang diurutkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16244 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel2.png\" alt=\"\" width=\"457\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Pilih nilai arbitrer untuk Lambda<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan memilih nilai sembarang 1 untuk lambda dan menerapkan transformasi box-cox sementara ke data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16245 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel3.png\" alt=\"\" width=\"533\" height=\"345\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung Skor Z<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menghitung z-score untuk setiap nilai indeks:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16246 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel4.png\" alt=\"\" width=\"567\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menghitung korelasi antara nilai transformasi box-cox dan skor-z:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16247 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel5.png\" alt=\"\" width=\"648\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 5: Temukan Nilai Lambda yang Optimal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan Goal Seek untuk menemukan nilai lambda optimal untuk digunakan dalam transformasi box-cox.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, klik pada tab <strong>Data<\/strong> di sepanjang pita atas. Lalu klik <strong>Analisis Bagaimana-Jika<\/strong> di grup <strong>Prakiraan<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16248 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel6.png\" alt=\"\" width=\"578\" height=\"106\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di menu tarik-turun, klik <strong>Penelusuran Sasaran<\/strong> dan isi nilai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16249\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel7.png\" alt=\"Transformasi Box-Cox di Excel\" width=\"564\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , Goal Seek akan secara otomatis menemukan nilai lambda optimal yaitu <strong>-0.5225<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16250 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel8.png\" alt=\"\" width=\"365\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 6: Lakukan Transformasi Box-Cox<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan menerapkan transformasi box-cox ke data asli, menggunakan nilai lambda -0,5225:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16251 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel9.png\" alt=\"\" width=\"601\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Bonus:<\/strong> Kami dapat mengonfirmasi bahwa data yang diubah terdistribusi secara normal dengan melakukan <a href=\"https:\/\/statorials.org\/id\/uji-normalitas-excel\/\" target=\"_blank\" rel=\"noopener\">uji Jarque-Bera di Excel<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/mengubah-data-menjadi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Mentransformasi Data di Excel (Log, Akar Kuadrat, Akar Kubus)<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/skor-z-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Z Score di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transformasi box-cox adalah metode yang umum digunakan untuk mengubah kumpulan data yang tidak terdistribusi normal menjadi kumpulan data yang lebih terdistribusi normal . Ide dasarnya adalah mencari nilai \u03bb sedemikian rupa sehingga data yang ditransformasikan sedekat mungkin dengan distribusi normal, dengan menggunakan rumus berikut: y(\u03bb) = (y \u03bb \u2013 1) \/ \u03bb jika y \u2260 [&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>Transformasi Box-Cox di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan transformasi box-cox 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\/transformasi-box-cox-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transformasi Box-Cox di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan transformasi box-cox di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T12:56:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel1.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\/transformasi-box-cox-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/\",\"name\":\"Transformasi Box-Cox di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T12:56:56+00:00\",\"dateModified\":\"2023-07-25T12:56:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan transformasi box-cox di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transformasi box-cox 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":"Transformasi Box-Cox di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara melakukan transformasi box-cox 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\/transformasi-box-cox-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Transformasi Box-Cox di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara melakukan transformasi box-cox di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T12:56:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boiteexcel1.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\/transformasi-box-cox-excel\/","url":"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/","name":"Transformasi Box-Cox di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T12:56:56+00:00","dateModified":"2023-07-25T12:56:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan transformasi box-cox di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Transformasi box-cox 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\/1648"}],"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=1648"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1648\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}