{"id":678,"date":"2023-07-29T03:13:51","date_gmt":"2023-07-29T03:13:51","guid":{"rendered":"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/"},"modified":"2023-07-29T03:13:51","modified_gmt":"2023-07-29T03:13:51","slug":"z-nilai-kritis-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/","title":{"rendered":"Cara mencari nilai z kritis di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Setiap kali Anda melakukan uji hipotesis, Anda mendapatkan statistik uji. Untuk menentukan apakah hasil uji hipotesis signifikan secara statistik, Anda dapat membandingkan statistik uji tersebut dengan <strong>nilai Z kritis<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai absolut statistik uji lebih besar dari nilai Z kritis, maka hasil pengujian signifikan secara statistik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, Excel memudahkan untuk menemukan nilai Z kritis menggunakan fungsi berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>NORM.S.INV (probabilitas)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>probabilitas:<\/strong> tingkat signifikansi untuk digunakan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Fungsi ini mengembalikan nilai Z kritis, berdasarkan tingkat signifikansi yang Anda pilih.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan tiga contoh penggunaan fungsi ini untuk mencari nilai Z kritis.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh 1: uji dua sisi<\/span><\/strong><\/h3>\n<p> <strong><span style=\"color: #000000;\">Temukan nilai Z kritis untuk uji dua sisi, menggunakan \u03b1 = 0,10.<\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Untuk pengujian dua sisi, akan ada dua nilai kritis:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>STANDAR.INV(\u03b1\/2)<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>STANDAR.INV(1-\u03b1\/2)<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan fungsi berikut di Excel untuk menghitung nilai kritis ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6513 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/z_crit1-1.png\" alt=\"Menghitung nilai Z kritis untuk pengujian dua sisi di Excel\" width=\"500\" height=\"317\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jadi dua nilai kritis pengujian ini adalah <strong>-1.645<\/strong> dan <strong>1.645<\/strong> . Artinya apabila statistik uji lebih kecil dari -1,645 atau lebih besar dari 1,645, maka hasil uji hipotesis signifikan secara statistik.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh 2: Uji Ekor Lurus<\/span><\/strong><\/h3>\n<p> <strong><span style=\"color: #000000;\">Carilah nilai Z kritis untuk tes tangan kanan, dengan menggunakan \u03b1 = 0,05.<\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Untuk tes tangan kanan, akan ada nilai kritis: <strong>NORM.S.INV(1-\u03b1)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi berikut di Excel untuk menghitung nilai kritis ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6514 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/z_crit2.png\" alt=\"Menghitung Nilai Z Kritis untuk Uji Sisi Kanan di Excel\" width=\"501\" height=\"317\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jadi, nilai kritis pengujian ini adalah <strong>1,645<\/strong> . Artinya jika statistik uji lebih besar dari 1,645 maka hasil uji hipotesis signifikan secara statistik.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh 3: Tes kiri<\/span><\/strong><\/h3>\n<p> <strong><span style=\"color: #000000;\">Carilah nilai Z kritis untuk pengujian kiri, dengan menggunakan \u03b1 = 0,01.<\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Untuk pengujian sebelah kiri, akan terdapat nilai kritis: <strong>NORM.S.INV(\u03b1)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi berikut di Excel untuk menghitung nilai kritis ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6515 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/z_crit3.png\" alt=\"Nilai Z kritis untuk pengujian kiri di Excel\" width=\"502\" height=\"318\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jadi, nilai kritis pengujian ini adalah <strong>-2.326<\/strong> . Artinya apabila statistik uji lebih kecil dari -2,326 maka hasil uji hipotesis signifikan secara statistik.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Setiap kali Anda melakukan uji hipotesis, Anda mendapatkan statistik uji. Untuk menentukan apakah hasil uji hipotesis signifikan secara statistik, Anda dapat membandingkan statistik uji tersebut dengan nilai Z kritis . Jika nilai absolut statistik uji lebih besar dari nilai Z kritis, maka hasil pengujian signifikan secara statistik. Untungnya, Excel memudahkan untuk menemukan nilai Z kritis [&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 Mencari Nilai Z Kritis di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung nilai Z kritis di Excel, disertai 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\/z-nilai-kritis-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mencari Nilai Z Kritis di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung nilai Z kritis di Excel, disertai beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T03:13:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/z_crit1-1.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\/z-nilai-kritis-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/\",\"name\":\"Cara Mencari Nilai Z Kritis di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T03:13:51+00:00\",\"dateModified\":\"2023-07-29T03:13:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung nilai Z kritis di Excel, disertai beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencari nilai z kritis 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 Mencari Nilai Z Kritis di Excel \u2013 Statologi","description":"Penjelasan sederhana cara menghitung nilai Z kritis di Excel, disertai 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\/z-nilai-kritis-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mencari Nilai Z Kritis di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara menghitung nilai Z kritis di Excel, disertai beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-29T03:13:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/z_crit1-1.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\/z-nilai-kritis-unggul\/","url":"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/","name":"Cara Mencari Nilai Z Kritis di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T03:13:51+00:00","dateModified":"2023-07-29T03:13:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung nilai Z kritis di Excel, disertai beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/z-nilai-kritis-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencari nilai z kritis 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\/678"}],"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=678"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/678\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}