{"id":1078,"date":"2023-07-27T18:14:13","date_gmt":"2023-07-27T18:14:13","guid":{"rendered":"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/"},"modified":"2023-07-27T18:14:13","modified_gmt":"2023-07-27T18:14:13","slug":"z-mencetak-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/","title":{"rendered":"Cara menghitung z score di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, <strong>skor-z<\/strong> memberi tahu kita berapa banyak standar deviasi suatu nilai dari<\/span> <a href=\"https:\/\/statorials.org\/id\/mengukur-tendensi-sentral\/\" target=\"_blank\" rel=\"noopener noreferrer\">mean<\/a> <span style=\"color: #000000;\">. Kami menggunakan rumus berikut untuk menghitung skor-z:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>z<\/strong> = (X \u2013 \u03bc) \/ \u03c3<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">X adalah nilai data mentah tunggal<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u03bc adalah rata-rata kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u03c3 adalah deviasi standar kumpulan data<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung z-score untuk nilai data mentah di Google Sheets.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: skor-z di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut dan ingin mencari skor-z untuk setiap nilai data mentah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11064 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscoresheets1.png\" alt=\"\" width=\"395\" height=\"507\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melakukan langkah-langkah berikut untuk melakukan ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Temukan mean dan deviasi standar dari kumpulan data.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita perlu mencari mean dan deviasi standar dari kumpulan data tersebut. Rumus berikut menunjukkan cara melakukan ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11065 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscoresheets2.png\" alt=\"\" width=\"620\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-ratanya adalah <strong>14,375<\/strong> dan standar deviasinya adalah <strong>4,998<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan skor-z untuk nilai data mentah pertama.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan mencari z-score untuk nilai data mentah pertama dengan mengetikkan rumus berikut di sel B2:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">A2<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">\u2013<\/span> <span dir=\"auto\" style=\"color: #800080;\">$E$2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">\/<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">$E$3<\/span><\/strong><\/span> <\/p>\n<\/blockquote>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11066 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscoresheets3.png\" alt=\"Skor Z di Google Spreadsheet\" width=\"618\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan skor-z untuk semua nilai yang tersisa.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita menghitung skor-z pertama, kita dapat menyorot sisa kolom B yang dimulai dengan sel B2 dan tekan <strong>Ctrl+D<\/strong> untuk menyalin rumus dari sel B2 ke setiap sel di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11067 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscoresheets4.png\" alt=\"Hitung skor z di Google Spreadsheet\" width=\"608\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami sekarang telah menemukan skor-z untuk setiap nilai data mentah.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Bagaimana menafsirkan skor Z<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><strong>Skor-z<\/strong> hanya memberi tahu kita berapa banyak standar deviasi suatu nilai dari mean.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita menemukan bahwa meannya adalah <strong>14,375<\/strong> dan deviasi standarnya adalah <strong>4,998<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi nilai pertama di dataset kita adalah 7, yang memiliki z-score (7-14.375) \/ 4.998 = <strong>-1.47546<\/strong> . Artinya nilai \u201c7\u201d standar deviasi -1,47545 <em>lebih rendah<\/em> dari mean.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai berikutnya dalam data kami, 12, memiliki skor-z (12-14.375) \/ 4.998 = <strong>-0.47515<\/strong> . Artinya nilai \u201c12\u201d adalah -0,47515 standar deviasi <em>lebih rendah<\/em> dari mean.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11067 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscoresheets4.png\" alt=\"Hitung skor z di Google Spreadsheet\" width=\"608\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semakin jauh suatu nilai dari mean, semakin tinggi nilai absolut skor-z untuk nilai tersebut.<\/span> <span style=\"color: #000000;\">Misalnya, nilai 7 lebih jauh dari mean (14,375) dibandingkan nilai 12, yang menjelaskan mengapa 7 memiliki skor-z dengan nilai absolut lebih besar.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/skor-z-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Z Score di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/skor-zr\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghitung skor Z di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/z-skor-ti-84-kalkulator\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Z Score pada Kalkulator TI-84<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, skor-z memberi tahu kita berapa banyak standar deviasi suatu nilai dari mean . Kami menggunakan rumus berikut untuk menghitung skor-z: z = (X \u2013 \u03bc) \/ \u03c3 Emas: X adalah nilai data mentah tunggal \u03bc adalah rata-rata kumpulan data \u03c3 adalah deviasi standar kumpulan data Tutorial ini menjelaskan cara menghitung z-score untuk nilai [&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 Z Score di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung z-score di Google Sheets, 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\/z-mencetak-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Z Score di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung z-score di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T18:14:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscoresheets1.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\/z-mencetak-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/\",\"name\":\"Cara Menghitung Z Score di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T18:14:13+00:00\",\"dateModified\":\"2023-07-27T18:14:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung z-score di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung z score 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 Menghitung Z Score di Google Sheets \u2013 Statologi","description":"Penjelasan sederhana cara menghitung z-score di Google Sheets, 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\/z-mencetak-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Z Score di Google Sheets \u2013 Statologi","og_description":"Penjelasan sederhana cara menghitung z-score di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-27T18:14:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscoresheets1.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\/z-mencetak-lembar-google\/","url":"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/","name":"Cara Menghitung Z Score di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T18:14:13+00:00","dateModified":"2023-07-27T18:14:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung z-score di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/z-mencetak-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung z score 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\/1078"}],"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=1078"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1078\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}