{"id":1379,"date":"2023-07-26T15:24:06","date_gmt":"2023-07-26T15:24:06","guid":{"rendered":"https:\/\/statorials.org\/id\/menangkan-data-excel\/"},"modified":"2023-07-26T15:24:06","modified_gmt":"2023-07-26T15:24:06","slug":"menangkan-data-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menangkan-data-excel\/","title":{"rendered":"Cara melakukan winorisasi data di excel"},"content":{"rendered":"

<\/p>\n

\n

Memperoleh<\/strong> data berarti menetapkan outlier ekstrem sama dengan persentil data tertentu.<\/span><\/p>\n

Misalnya, winorisasi 90% menetapkan semua pengamatan<\/a> di atas persentil ke-95 sama dengan nilai pada persentil ke-95 dan semua pengamatan di bawah persentil ke-5 sama dengan nilai pada persentil ke-5.<\/span><\/p>\n

Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan winorisasi kumpulan data di Excel.<\/span><\/p>\n

Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n

Pertama, kita akan membuat dataset berikut:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Hitung persentil atas dan bawah<\/strong><\/span><\/h3>\n

Untuk contoh ini, kami akan melakukan winorisasi 90%. Artinya kita akan menetapkan semua nilai di atas persentil ke-95 sama dengan persentil ke-95 dan semua nilai di bawah persentil ke-5 sama dengan persentil ke-5.<\/span><\/p>\n

Rumus berikut menunjukkan cara mencari persentil ke-5 dan ke-95:<\/span> <\/p>\n

\"Contoh<\/p>\n

Persentil ke-5 menjadi 12,35<\/strong> dan persentil ke-95 menjadi 92,05<\/strong> .<\/span><\/p>\n

Langkah 3: Winsorisasikan data<\/strong><\/span><\/h3>\n

Terakhir, kita akan menggunakan rumus berikut untuk melakukan winorisasi data:<\/span> <\/p>\n

\"Winsorisasi<\/p>\n

Perhatikan bahwa kita hanya menyalin dan menempelkan rumus dari sel F2 ke sel lainnya di kolom F.<\/span><\/p>\n

Dalam hal ini, nilai 3<\/strong> menjadi 12.35<\/strong> dan nilai 98<\/strong> menjadi 92.05<\/strong> .<\/span><\/p>\n

Perhatikan bahwa dalam contoh ini kita telah melakukan winorisasi 90%, namun dimungkinkan juga untuk melakukan winorisasi 80%, winorisasi 95%, winorisasi 99%, dan seterusnya. hanya dengan menghitung persentil atas dan bawah yang berbeda.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Memperoleh data berarti menetapkan outlier ekstrem sama dengan persentil data tertentu. Misalnya, winorisasi 90% menetapkan semua pengamatan di atas persentil ke-95 sama dengan nilai pada persentil ke-95 dan semua pengamatan di bawah persentil ke-5 sama dengan nilai pada persentil ke-5. Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan winorisasi kumpulan data di Excel. […]<\/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":"\nCara melakukan winorisasi data di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan winorize data 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\/menangkan-data-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan winorisasi data di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan winorize data di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menangkan-data-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T15:24:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/winsorize1.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\/menangkan-data-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/menangkan-data-excel\/\",\"name\":\"Cara melakukan winorisasi data di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T15:24:06+00:00\",\"dateModified\":\"2023-07-26T15:24:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan winorize data di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menangkan-data-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menangkan-data-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menangkan-data-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan winorisasi data 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 winorisasi data di Excel - Statorials","description":"Tutorial ini menjelaskan cara melakukan winorize data 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\/menangkan-data-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan winorisasi data di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan winorize data di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/menangkan-data-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T15:24:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/winsorize1.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\/menangkan-data-excel\/","url":"https:\/\/statorials.org\/id\/menangkan-data-excel\/","name":"Cara melakukan winorisasi data di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T15:24:06+00:00","dateModified":"2023-07-26T15:24:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan winorize data di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menangkan-data-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menangkan-data-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menangkan-data-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan winorisasi data 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\/1379"}],"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=1379"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1379\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}