{"id":578,"date":"2023-07-29T10:57:35","date_gmt":"2023-07-29T10:57:35","guid":{"rendered":"https:\/\/statorials.org\/id\/asimetri-unggul\/"},"modified":"2023-07-29T10:57:35","modified_gmt":"2023-07-29T10:57:35","slug":"asimetri-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/asimetri-unggul\/","title":{"rendered":"Cara menghitung kemiringan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Skewness<\/strong> adalah ukuran kemiringan suatu kumpulan data atau distribusi. Nilai ini bisa positif atau negatif. Hal ini berguna untuk diketahui karena membantu kita memahami bentuk suatu distribusi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemiringan negatif menunjukkan bahwa ekornya berada di sisi kiri distribusi, yang mengarah ke nilai yang lebih negatif.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemiringan positif menunjukkan bahwa ekornya berada di sisi kanan distribusi, yang mengarah ke nilai yang lebih positif.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai nol menunjukkan tidak adanya asimetri dalam distribusi, artinya distribusi tersebut simetris sempurna. Hal ini tidak biasa dan jarang terjadi dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Cara Menghitung Kemiringan di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel menyediakan fungsi bawaan berikut untuk menghitung kemiringan distribusi:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\"><strong>=SKEW (array nilai)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan rumus berikut untuk menghitung kemiringan:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Asimetri = [n\/(n-1)(n-2)] * \u03a3[(x <sub>i<\/sub> \u2013 <span style=\"text-decoration: overline;\">x<\/span> )\/s] <sup>3<\/sup><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<p> <span style=\"color: #000000;\">n = ukuran sampel<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u03a3 = simbol mewah yang berarti \u201cjumlah\u201d<\/span><\/p>\n<p> <span style=\"color: #000000;\">x <sub>i<\/sub> = nilai nilai <sup>ke-i<\/sup> pada dataset<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"text-decoration: overline;\">x<\/span> = rata-rata<\/span><\/p>\n<p> <span style=\"color: #000000;\">s = simpangan baku<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya agak rumit, tapi untungnya Excel melakukan penghitungan ini untuk Anda sehingga Anda tidak perlu melakukannya secara manual.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: menghitung asimetri di Excel<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dataset berikut yang berisi hasil ujian 20 siswa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5233 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel0.png\" alt=\"Contoh tabel nilai di excel\" width=\"545\" height=\"569\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menghitung kemiringan distribusi menggunakan <strong>=SKEW(A2:A21)<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5234 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel1.png\" alt=\"Cara Menghitung Kemiringan di Excel\" width=\"560\" height=\"609\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hal ini memberitahu kita bahwa kemiringan kumpulan data ini adalah <strong>-0.1849<\/strong> . Karena nilai ini negatif, kita mengetahui bahwa ekor distribusinya memanjang ke kiri.<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Catatan teknis:<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi SKEW() akan mengembalikan kesalahan #DIV\/0! dalam dua skenario berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jika ada kurang dari tiga titik data<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jika simpangan baku sampel adalah nol<\/span><\/li>\n<\/ul>\n<\/blockquote>\n<h2> <span style=\"color: #000000;\"><strong>Sumber Tambahan: Kalkulator Skewness dan Kurtosis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Anda juga dapat menghitung kemiringan untuk kumpulan data tertentu menggunakan <a href=\"https:\/\/statorials.org\/id\" target=\"_blank\" rel=\"noopener\">Kalkulator Skewness dan Kurtosis Statistik<\/a> , yang secara otomatis menghitung kemiringan dan kurtosis untuk kumpulan data tertentu. Anda cukup memasukkan nilai data mentah untuk dataset Anda ke dalam kotak input, lalu klik \u201cHitung\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebagai contoh, berikut cara menghitung skewness dataset dari contoh di atas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5236 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel2.png\" alt=\"Contoh kalkulator asimetri\" width=\"500\" height=\"707\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai skewness dari kalkulator cocok dengan nilai skewness yang kami temukan di Excel.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Skewness adalah ukuran kemiringan suatu kumpulan data atau distribusi. Nilai ini bisa positif atau negatif. Hal ini berguna untuk diketahui karena membantu kita memahami bentuk suatu distribusi. Kemiringan negatif menunjukkan bahwa ekornya berada di sisi kiri distribusi, yang mengarah ke nilai yang lebih negatif. Kemiringan positif menunjukkan bahwa ekornya berada di sisi kanan distribusi, yang [&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 Menghitung Asimetri di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung skewness suatu kumpulan data tertentu di Excel, beserta contohnya.\" \/>\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\/asimetri-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Asimetri di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung skewness suatu kumpulan data tertentu di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/asimetri-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T10:57:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel0.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/asimetri-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/asimetri-unggul\/\",\"name\":\"Cara Menghitung Asimetri di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T10:57:35+00:00\",\"dateModified\":\"2023-07-29T10:57:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung skewness suatu kumpulan data tertentu di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/asimetri-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/asimetri-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/asimetri-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kemiringan 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 Menghitung Asimetri di Excel - Statologi","description":"Penjelasan sederhana tentang cara menghitung skewness suatu kumpulan data tertentu di Excel, beserta contohnya.","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\/asimetri-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Asimetri di Excel - Statologi","og_description":"Penjelasan sederhana tentang cara menghitung skewness suatu kumpulan data tertentu di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/asimetri-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-29T10:57:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel0.png"}],"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\/asimetri-unggul\/","url":"https:\/\/statorials.org\/id\/asimetri-unggul\/","name":"Cara Menghitung Asimetri di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T10:57:35+00:00","dateModified":"2023-07-29T10:57:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung skewness suatu kumpulan data tertentu di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/asimetri-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/asimetri-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/asimetri-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kemiringan 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\/578"}],"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=578"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/578\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}