{"id":1681,"date":"2023-07-25T10:01:19","date_gmt":"2023-07-25T10:01:19","guid":{"rendered":"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/"},"modified":"2023-07-25T10:01:19","modified_gmt":"2023-07-25T10:01:19","slug":"nilai-kritis-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/","title":{"rendered":"Cara menghitung nilai kritis di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Setiap kali Anda melakukan <a href=\"https:\/\/statorials.org\/id\/pengujian-hipotesis-1\/\" target=\"_blank\" rel=\"noopener\">uji hipotesis<\/a> , Anda akan mendapatkan statistik uji. Untuk menentukan apakah hasil pengujian signifikan secara statistik, Anda dapat membandingkan statistik pengujian dengan <strong>nilai kritis<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai absolut statistik uji lebih besar dari nilai kritis, maka hasil pengujian signifikan secara statistik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari <strong>nilai t-kritis<\/strong> di Google Sheets, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>T.INV<\/strong> (probabilitas, deg_freedom) \u2013 Mengembalikan nilai t-kritis untuk uji-t satu sisi.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>T.INV.2T<\/strong> (probabilitas, deg_freedom) \u2013 Mengembalikan nilai t-kritis untuk uji-t dua sisi.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menemukan <strong>nilai z-kritis<\/strong> di Google Sheets, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>NORM.S.INV<\/strong> (probabilitas) \u2013 Mengembalikan nilai kritis untuk uji z satu sisi.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>NORM.S.INV<\/strong> (probabilitas\/2) \u2013 Mengembalikan nilai kritis untuk uji z dua sisi.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Nilai kritis uji T satu sisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mencari nilai kritis t uji kiri dengan tingkat signifikansi 0,05 dan derajat kebebasan = 11, kita dapat mengetikkan rumus berikut ke dalam Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16565 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/critique1.png\" alt=\"t nilai penting di Google Spreadsheet\" width=\"460\" height=\"384\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai kritisnya adalah <strong>-1.79588<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Nilai kritis uji T dua sisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mencari nilai t-kritis uji dua sisi dengan tingkat signifikansi 0,05 dan derajat kebebasan = 11, kita dapat mengetikkan rumus berikut ke dalam Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16566 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/critique2.png\" alt=\"\" width=\"459\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai kritisnya adalah <strong>2.200985<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Nilai kritis uji Z satu sisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mencari nilai kritis z uji kiri dengan tingkat signifikansi 0,05, kita dapat memasukkan rumus berikut ke dalam Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16567\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/critique3.png\" alt=\"z nilai penting di Google Spreadsheet\" width=\"456\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai kritisnya adalah <strong>-1.64485<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 4: Nilai kritis uji Z dua sisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mencari nilai kritis z pada uji dua sisi dengan tingkat signifikansi 0,05, kita dapat memasukkan rumus berikut ke dalam Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16568 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/critique4.png\" alt=\"\" width=\"451\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai kritisnya adalah <strong>-1.96<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Peringatan tentang menemukan nilai penting di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>T.INV<\/strong> (), <strong>T.INV.2T<\/strong> (), dan <strong>NORM.S.INV<\/strong> () menghasilkan kesalahan jika salah satu kejadian berikut ini terjadi:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jika argumen bukan numerik.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jika nilai <em>probabilitasnya<\/em> kurang dari nol atau lebih besar dari 1.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jika nilai <em>deg_freedom<\/em> <em>&nbsp;<\/em> kurang dari 1.<\/span><\/li>\n<\/ul>\n<hr>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan tutorial Google Sheets lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Setiap kali Anda melakukan uji hipotesis , Anda akan mendapatkan statistik uji. Untuk menentukan apakah hasil pengujian signifikan secara statistik, Anda dapat membandingkan statistik pengujian dengan nilai kritis . Jika nilai absolut statistik uji lebih besar dari nilai kritis, maka hasil pengujian signifikan secara statistik. Untuk mencari nilai t-kritis di Google Sheets, Anda dapat menggunakan [&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 nilai kritis di Google Sheets<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai kritis di Google Sheets, dengan 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\/nilai-kritis-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 nilai kritis di Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai kritis di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T10:01:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/critique1.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\/nilai-kritis-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/\",\"name\":\"Cara menghitung nilai kritis di Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T10:01:19+00:00\",\"dateModified\":\"2023-07-25T10:01:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai kritis di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung nilai kritis 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 nilai kritis di Google Sheets","description":"Tutorial ini menjelaskan cara menghitung nilai kritis di Google Sheets, dengan 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\/nilai-kritis-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung nilai kritis di Google Sheets","og_description":"Tutorial ini menjelaskan cara menghitung nilai kritis di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-25T10:01:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/critique1.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\/nilai-kritis-lembar-google\/","url":"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/","name":"Cara menghitung nilai kritis di Google Sheets","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T10:01:19+00:00","dateModified":"2023-07-25T10:01:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai kritis di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung nilai kritis 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\/1681"}],"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=1681"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1681\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}