{"id":1873,"date":"2023-07-24T15:50:43","date_gmt":"2023-07-24T15:50:43","guid":{"rendered":"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/"},"modified":"2023-07-24T15:50:43","modified_gmt":"2023-07-24T15:50:43","slug":"transformasi-arcsinus-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/","title":{"rendered":"Transformasi arcsine di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Transformasi arcsinus<\/strong> dapat digunakan untuk “memperluas” titik data antara nilai 0 dan 1.<\/span><\/p>\n

Jenis transformasi ini biasanya digunakan ketika berhadapan dengan proporsi dan persentase.<\/span><\/p>\n

Kita dapat menggunakan rumus berikut untuk melakukan transformasi arcsine di Excel:<\/span><\/p>\n

 #perform arcsine transformation on value in cell A1<\/span>\n=ASIN(SQRT(A1))\n<\/strong><\/pre>\n
 Contoh berikut memperlihatkan cara melakukan transformasi arcsine pada kumpulan data di Excel.<\/span><\/p>\n
 Contoh 1: Transformasi arcsinus nilai antara 0 dan 1<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk melakukan transformasi arcsinus pada nilai di sel A2:<\/span> <\/p>\n
\"Transformasi<\/p>\n
 Kita kemudian dapat mengarahkan kursor ke sudut kanan bawah sel A2 hingga muncul tanda tambah kecil ” +<\/strong> “, lalu klik dua kali untuk menyalin dan menempelkan rumus arcsinus ke setiap sel di kolom B:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 2: Transformasi arcsinus dari nilai di luar rentang 0 hingga 1<\/strong><\/span><\/h3>\n
 Perhatikan bahwa transformasi arcsinus hanya berfungsi pada nilai antara 0 dan 1. Jadi jika kita memiliki vektor dengan nilai di luar rentang tersebut, kita harus terlebih dahulu mengonversi setiap nilai menjadi antara 0 dan 1.<\/span><\/p>\n
 Misalnya, kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Sebelum melakukan transformasi arcsinus pada nilai, terlebih dahulu kita harus membagi setiap nilai dengan nilai maksimum pada dataset:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang setiap nilai dalam dataset adalah antara 0 dan 1. Selanjutnya kita dapat melakukan transformasi arcsinus pada nilai di kolom B:<\/span> <\/p>\n
\"\"<\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Cara Mentransformasi Data di Excel (Log, Akar Kuadrat, Akar Kubus)<\/a>
 Bagaimana melakukan transformasi Box-Cox di Excel<\/a>
 Cara menemukan antilog nilai di Excel<\/p>\n","protected":false},"excerpt":{"rendered":"
Transformasi arcsinus dapat digunakan untuk “memperluas” titik data antara nilai 0 dan 1. Jenis transformasi ini biasanya digunakan ketika berhadapan dengan proporsi dan persentase. Kita dapat menggunakan rumus berikut untuk melakukan transformasi arcsine di Excel: #perform arcsine transformation on value in cell A1 =ASIN(SQRT(A1)) Contoh berikut memperlihatkan cara melakukan transformasi arcsine pada kumpulan data di […]<\/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":"\nTransformasi Arcsine di Excel (dengan Contoh)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan transformasi arcsine pada kumpulan data di Excel, dengan beberapa 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\/transformasi-arcsinus-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transformasi Arcsine di Excel (dengan Contoh)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan transformasi arcsine pada kumpulan data di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T15:50:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/arc1.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-arcsinus-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/\",\"name\":\"Transformasi Arcsine di Excel (dengan Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T15:50:43+00:00\",\"dateModified\":\"2023-07-24T15:50:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan transformasi arcsine pada kumpulan data di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transformasi arcsine di excel (dengan contoh)\"}]},{\"@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 Arcsine di Excel (dengan Contoh)","description":"Tutorial ini menjelaskan cara melakukan transformasi arcsine pada kumpulan data di Excel, dengan beberapa 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\/transformasi-arcsinus-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Transformasi Arcsine di Excel (dengan Contoh)","og_description":"Tutorial ini menjelaskan cara melakukan transformasi arcsine pada kumpulan data di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-24T15:50:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/arc1.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-arcsinus-excel\/","url":"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/","name":"Transformasi Arcsine di Excel (dengan Contoh)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T15:50:43+00:00","dateModified":"2023-07-24T15:50:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan transformasi arcsine pada kumpulan data di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/transformasi-arcsinus-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Transformasi arcsine di excel (dengan contoh)"}]},{"@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\/1873"}],"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=1873"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1873\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}