{"id":1073,"date":"2023-07-27T18:39:07","date_gmt":"2023-07-27T18:39:07","guid":{"rendered":"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/"},"modified":"2023-07-27T18:39:07","modified_gmt":"2023-07-27T18:39:07","slug":"normalisasi-data-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/","title":{"rendered":"Cara menormalkan data di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Menormalkan<\/strong> sekumpulan nilai data berarti menskalakan nilai sedemikian rupa sehingga rata-rata semua nilai adalah 0 dan simpangan bakunya adalah 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menormalkan data di Google Sheets.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cara normalisasi data di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11018 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles1.png\" alt=\"\" width=\"413\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Gunakan langkah-langkah berikut untuk menormalkan kumpulan nilai data ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Hitung rata-ratanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita akan menggunakan fungsi <strong>=AVERAGE(range of value)<\/strong> untuk mencari rata-rata kumpulan data.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11019 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles2.png\" alt=\"\" width=\"665\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan deviasi standar.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>=STDEV (rentang nilai)<\/strong> untuk mencari simpangan baku dari kumpulan data.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11020 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles3.png\" alt=\"\" width=\"672\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Normalisasikan nilainya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan menggunakan fungsi <strong>STANDARDIZE(x, Mean, standard_dev)<\/strong> untuk menormalkan setiap nilai dalam dataset.<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>CATATAN:<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>STANDARDIZE<\/strong> menggunakan rumus berikut untuk menormalkan nilai data tertentu:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai yang dinormalisasi = (x \u2013 <span style=\"text-decoration: overline;\">x<\/span> ) \/ s<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">x = nilai data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><span style=\"text-decoration: overline;\">x<\/span> = rata-rata kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\">s = deviasi standar kumpulan data<\/span><\/li>\n<\/ul>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan rumus yang digunakan untuk menormalkan nilai pertama dalam kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11021\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles4-1.png\" alt=\"Data dinormalisasi di Google Spreadsheet\" width=\"667\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita menormalkan nilai pertama di sel B2, kita dapat mengarahkan kursor ke sudut kanan bawah sel B2 hingga tanda <strong>+<\/strong> kecil muncul. Klik dua kali tanda <strong>+<\/strong> untuk menyalin rumus ke sel yang tersisa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11022 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles5.png\" alt=\"Kumpulan data yang dinormalisasi di Google Spreadsheet\" width=\"462\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang setiap nilai dalam kumpulan data telah dinormalisasi.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Bagaimana menafsirkan data yang dinormalisasi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Rumus yang kami gunakan untuk menormalkan nilai data tertentu, x, adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai yang dinormalisasi = (x \u2013 <span style=\"text-decoration: overline;\">x<\/span> ) \/ s<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">x = nilai data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><span style=\"text-decoration: overline;\">x<\/span> = rata-rata kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\">s = deviasi standar kumpulan data<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jika suatu titik data tertentu memiliki nilai normalisasi lebih besar dari 0, berarti 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<p> <span style=\"color: #000000;\">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<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11022 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles5.png\" alt=\"Kumpulan data yang dinormalisasi di Google Spreadsheet\" width=\"462\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai normalisasi untuk &#8220;12&#8221; ternyata -1,288, dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai normalisasi = (x \u2013 <span style=\"text-decoration: overline;\">x<\/span> ) \/ s = (12 \u2013 22.267) \/ 7.968 = <strong>-1.288<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini menunjukkan bahwa nilai \u201c12\u201d adalah <strong>1,288 standar deviasi lebih rendah dari rata-rata<\/strong> kumpulan data asli.<\/span><\/p>\n<p> <span style=\"color: #000000;\">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<h3> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><b>Sumber daya tambahan<\/b><\/span><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/normalisasi-data-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara normalisasi data di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/cara-menormalkan-data-di-r\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menormalkan data di R<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Menormalkan sekumpulan nilai data berarti menskalakan nilai sedemikian rupa sehingga rata-rata semua nilai adalah 0 dan simpangan bakunya adalah 1. Tutorial ini menjelaskan cara menormalkan data di Google Sheets. Contoh: Cara normalisasi data di Google Sheets Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet: Gunakan langkah-langkah berikut untuk menormalkan kumpulan nilai data ini. Langkah [&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 menormalkan data di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menormalkan data di Google Sheets, dengan sebuah 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\/normalisasi-data-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menormalkan data di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menormalkan data di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T18:39:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles1.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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/\",\"name\":\"Cara menormalkan data di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T18:39:07+00:00\",\"dateModified\":\"2023-07-27T18:39:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menormalkan data di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menormalkan data di google sheets\"}]},{\"@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 menormalkan data di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menormalkan data di Google Sheets, dengan sebuah 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\/normalisasi-data-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menormalkan data di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menormalkan data di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T18:39:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliserfeuilles1.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-google-sheet\/","url":"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/","name":"Cara menormalkan data di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T18:39:07+00:00","dateModified":"2023-07-27T18:39:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menormalkan data di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/normalisasi-data-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menormalkan data di google sheets"}]},{"@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\/1073"}],"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=1073"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1073\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}