{"id":653,"date":"2023-07-29T05:08:54","date_gmt":"2023-07-29T05:08:54","guid":{"rendered":"https:\/\/statorials.org\/id\/normalisasi-data-excel\/"},"modified":"2023-07-29T05:08:54","modified_gmt":"2023-07-29T05:08:54","slug":"normalisasi-data-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/normalisasi-data-excel\/","title":{"rendered":"Cara normalisasi data di excel"},"content":{"rendered":"

<\/p>\n

\n

Untuk \u201cmenormalkan\u201d sekumpulan nilai data berarti menskalakan nilai sedemikian rupa sehingga rata-rata semua nilai adalah 0 dan simpangan bakunya adalah 1.<\/span><\/p>\n

Tutorial ini menjelaskan cara normalisasi data di Excel.<\/span><\/p>\n

Contoh : Cara normalisasi data di excel<\/strong><\/span><\/h3>\n

Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n

\"Data<\/p>\n

Selesaikan langkah-langkah berikut untuk menormalkan kumpulan nilai data ini.<\/span><\/p>\n

Langkah 1: Temukan meannya.<\/strong><\/span><\/p>\n

Pertama, kita akan menggunakan fungsi =AVERAGE(range of value)<\/strong> untuk mencari rata-rata kumpulan data.<\/span> <\/p>\n

\"Fungsi<\/p>\n

Langkah 2: Temukan deviasi standar.<\/strong><\/span><\/p>\n

Selanjutnya, kita akan menggunakan fungsi =STDEV (rentang nilai)<\/strong> untuk mencari simpangan baku dari kumpulan data.<\/span> <\/p>\n

\"Fungsi<\/p>\n

Langkah 3: Normalisasikan nilainya.<\/strong><\/span><\/p>\n

Terakhir, kita akan menggunakan fungsi STANDARDIZE(x, Mean, standard_dev)<\/strong> untuk menormalkan setiap nilai dalam dataset.<\/span><\/p>\n

\n

CATATAN:<\/strong><\/span><\/p>\n

Fungsi STANDARDIZE<\/strong> menggunakan rumus berikut untuk menormalkan nilai data tertentu:<\/span><\/p>\n

Nilai yang dinormalisasi = (x \u2013 x<\/span> ) \/ s<\/span><\/p>\n

Emas:<\/span><\/p>\n

    \n
  • x = nilai data<\/span><\/li>\n
  • x<\/span> = rata-rata kumpulan data<\/span><\/li>\n
  • s = deviasi standar kumpulan data<\/span><\/li>\n<\/ul>\n<\/blockquote>\n

    Gambar berikut menunjukkan rumus yang digunakan untuk menormalkan nilai pertama dalam kumpulan data:<\/span> <\/p>\n

    \"Normalisasi<\/p>\n

    Setelah kita menormalkan nilai pertama di sel B2, kita dapat mengarahkan kursor ke sudut kanan bawah sel B2 hingga tanda +<\/strong> kecil muncul. Klik dua kali tanda +<\/strong> untuk menyalin rumus ke sel yang tersisa:<\/span> <\/p>\n

    \"Data<\/p>\n

    Sekarang setiap nilai dalam kumpulan data telah dinormalisasi.<\/span><\/p>\n

    Bagaimana menafsirkan data yang dinormalisasi<\/strong><\/span><\/h3>\n

    Rumus yang kami gunakan untuk menormalkan nilai data tertentu, x, adalah:<\/span><\/p>\n

    Nilai yang dinormalisasi = (x \u2013 x<\/span> ) \/ s<\/span><\/p>\n

    Emas:<\/span><\/p>\n

      \n
    • x = nilai data<\/span><\/li>\n
    • x<\/span> = rata-rata kumpulan data<\/span><\/li>\n
    • s = deviasi standar kumpulan data<\/span><\/li>\n<\/ul>\n

      Jika suatu titik data tertentu memiliki nilai normalisasi lebih besar dari 0, hal ini menunjukkan bahwa titik data tersebut berada di atas rata-rata. Sebaliknya, nilai normalisasi yang kurang dari 0 menunjukkan bahwa titik data berada di bawah rata-rata.<\/span><\/p>\n

      Secara khusus, nilai yang dinormalisasi memberi tahu kita berapa banyak standar deviasi titik data asli dari mean. Misalnya, pertimbangkan titik data \u201c12\u201d dalam kumpulan data asli kami:<\/span> <\/p>\n

      \"Rumus<\/p>\n

      Nilai normalisasi untuk “12” ternyata -1,288, dihitung sebagai berikut:<\/span><\/p>\n

      Nilai normalisasi = (x \u2013 x<\/span> ) \/ s = (12 \u2013 22.267) \/ 7.968 = -1.288<\/strong><\/span><\/p>\n

      Hal ini menunjukkan bahwa nilai \u201c12\u201d adalah 1,288 standar deviasi lebih rendah dari rata-rata<\/strong> kumpulan data asli.<\/span><\/p>\n

      Setiap nilai yang dinormalisasi dalam kumpulan data dapat membantu kita memahami seberapa dekat atau jauh nilai data tertentu dari mean. Nilai ternormalisasi yang kecil menunjukkan bahwa suatu nilai mendekati mean, sedangkan nilai ternormalisasi yang besar menunjukkan bahwa suatu nilai jauh dari mean.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      Untuk \u201cmenormalkan\u201d sekumpulan nilai data berarti menskalakan nilai sedemikian rupa sehingga rata-rata semua nilai adalah 0 dan simpangan bakunya adalah 1. Tutorial ini menjelaskan cara normalisasi data di Excel. Contoh : Cara normalisasi data di excel Misalkan kita memiliki kumpulan data berikut di Excel: Selesaikan langkah-langkah berikut untuk menormalkan kumpulan nilai data ini. Langkah 1: […]<\/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 normalisasi data di excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara normalisasi 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\/normalisasi-data-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara normalisasi data di excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara normalisasi data di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/normalisasi-data-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T05:08:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserexcel1.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\/normalisasi-data-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/normalisasi-data-excel\/\",\"name\":\"Cara normalisasi data di excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T05:08:54+00:00\",\"dateModified\":\"2023-07-29T05:08:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara normalisasi data di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/normalisasi-data-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/normalisasi-data-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/normalisasi-data-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara normalisasi 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 normalisasi data di excel - Statorials","description":"Penjelasan sederhana tentang cara normalisasi 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\/normalisasi-data-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara normalisasi data di excel - Statorials","og_description":"Penjelasan sederhana tentang cara normalisasi data di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/normalisasi-data-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T05:08:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserexcel1.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\/normalisasi-data-excel\/","url":"https:\/\/statorials.org\/id\/normalisasi-data-excel\/","name":"Cara normalisasi data di excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T05:08:54+00:00","dateModified":"2023-07-29T05:08:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara normalisasi data di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/normalisasi-data-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/normalisasi-data-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/normalisasi-data-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara normalisasi 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\/653"}],"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=653"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/653\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}