{"id":2298,"date":"2023-07-22T21:28:24","date_gmt":"2023-07-22T21:28:24","guid":{"rendered":"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/"},"modified":"2023-07-22T21:28:24","modified_gmt":"2023-07-22T21:28:24","slug":"interval-kepercayaan-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/","title":{"rendered":"Cara menghitung interval keyakinan di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Interval kepercayaan suatu mean<\/strong> adalah rentang nilai yang kemungkinan mengandung mean populasi dengan tingkat kepercayaan tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Interval kepercayaan =<\/strong> <strong><span style=\"text-decoration: overline;\">x<\/span> +\/- t*(s\/\u221a <span style=\"border-top: 1px solid black;\">n<\/span> )<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong><span style=\"text-decoration: overline;\">x<\/span> :<\/strong> mean sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>t :<\/strong> nilai t yang sesuai dengan tingkat kepercayaan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>s:<\/strong> deviasi standar sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> ukuran sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung interval kepercayaan di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Interval kepercayaan menggunakan distribusi t<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jika kita bekerja dengan sampel kecil (n &lt;30), kita dapat menggunakan distribusi t untuk menghitung interval kepercayaan untuk rata-rata populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita ingin menghitung interval kepercayaan untuk rata-rata tinggi populasi sebenarnya (dalam inci) suatu spesies tumbuhan tertentu, dengan menggunakan sampel 15 tumbuhan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20895 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confgoogle1.png\" alt=\"\" width=\"557\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita dapat menghitung mean sampel, deviasi standar sampel, dan ukuran sampel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20896 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confgoogle2.png\" alt=\"\" width=\"573\" height=\"445\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian kita dapat menggunakan rumus berikut untuk menghitung batas bawah dan atas selang kepercayaan 95%:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-20897\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confgoogle3.png\" alt=\"interval kepercayaan di Google Spreadsheet\" width=\"673\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Interval kepercayaan 95% untuk ukuran populasi rata-rata sebenarnya adalah <strong>(13.877, 19.457)<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Interval kepercayaan menggunakan distribusi normal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jika kita bekerja dengan sampel yang lebih besar (n\u226530), kita dapat berasumsi bahwa distribusi sampling dari mean sampel terdistribusi normal berkat <a href=\"https:\/\/statorials.org\/id\/teorema-limit-pusat\/\" target=\"_blank\" rel=\"noopener\">teorema limit pusat<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya kita bisa menggunakan fungsi <strong>NORM.S.INV()<\/strong> untuk menghitung nilai kritis yang akan digunakan untuk interval kepercayaan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung interval kepercayaan untuk rata-rata tinggi populasi sebenarnya (dalam inci) suatu spesies tumbuhan tertentu, dengan menggunakan sampel 30 tumbuhan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20898 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confgoogle4.png\" alt=\"\" width=\"671\" height=\"632\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Interval kepercayaan 95% untuk rata-rata ukuran populasi sebenarnya adalah <strong>(20.571, 26.429)<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tingkat kepercayaan yang lebih tinggi menyebabkan interval kepercayaan yang lebih luas. Misalnya, berikut cara menghitung CI 99% untuk data yang sama persis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20899 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confgoogle5.png\" alt=\"\" width=\"662\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Interval kepercayaan 99% untuk ukuran populasi rata-rata sebenarnya adalah <strong>(19.650, 27.350)<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa interval kepercayaan 99% ini lebih lebar dari interval kepercayaan 95% yang kami hitung sebelumnya.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong><\/span> <a href=\"https:\/\/statorials.org\/id\/tingkat-kepercayaan-vs-interval-kepercayaan\/\" target=\"_blank\" rel=\"noopener\">Tingkat Keyakinan vs. Interval Keyakinan: Apa Bedanya?<\/a><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menghitung interval kepercayaan menggunakan software statistik lainnya:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/interval-kepercayaan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Interval Keyakinan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/interval-kepercayaan-di-r\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung interval kepercayaan di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/interval-kepercayaan-python\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung interval kepercayaan dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Interval kepercayaan suatu mean adalah rentang nilai yang kemungkinan mengandung mean populasi dengan tingkat kepercayaan tertentu. Ini dihitung sebagai berikut: Interval kepercayaan = x +\/- t*(s\/\u221a n ) Emas: x : mean sampel t : nilai t yang sesuai dengan tingkat kepercayaan s: deviasi standar sampel n: ukuran sampel Tutorial ini menjelaskan cara menghitung interval [&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 Interval Keyakinan di Google Spreadsheet \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung interval kepercayaan 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\/interval-kepercayaan-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 Interval Keyakinan di Google Spreadsheet \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung interval kepercayaan di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T21:28:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confgoogle1.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\/interval-kepercayaan-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/\",\"name\":\"Cara Menghitung Interval Keyakinan di Google Spreadsheet \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T21:28:24+00:00\",\"dateModified\":\"2023-07-22T21:28:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung interval kepercayaan di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung interval keyakinan di google spreadsheet\"}]},{\"@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 Interval Keyakinan di Google Spreadsheet \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung interval kepercayaan 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\/interval-kepercayaan-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Interval Keyakinan di Google Spreadsheet \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung interval kepercayaan di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-22T21:28:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confgoogle1.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\/interval-kepercayaan-lembar-google\/","url":"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/","name":"Cara Menghitung Interval Keyakinan di Google Spreadsheet \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T21:28:24+00:00","dateModified":"2023-07-22T21:28:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung interval kepercayaan di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/interval-kepercayaan-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung interval keyakinan di google spreadsheet"}]},{"@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\/2298"}],"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=2298"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2298\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}