{"id":1989,"date":"2023-07-24T04:38:09","date_gmt":"2023-07-24T04:38:09","guid":{"rendered":"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/"},"modified":"2023-07-24T04:38:09","modified_gmt":"2023-07-24T04:38:09","slug":"perkiraan-poin-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/","title":{"rendered":"Cara menghitung estimasi poin di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/perkiraan-poin-1\/\" target=\"_blank\" rel=\"noopener\">Estimasi titik<\/a> mewakili angka yang kami hitung dari data sampel untuk memperkirakan parameter populasi. Ini adalah perkiraan terbaik kami mengenai parameter populasi sebenarnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tabel berikut menunjukkan estimasi titik yang kami gunakan untuk memperkirakan parameter populasi:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<th style=\"text-align: left;\"> <span style=\"color: #000000;\"><strong>Ukurannya<\/strong><\/span><\/th>\n<th> <span style=\"color: #000000;\"><strong>Parameter populasi<\/strong><\/span><\/th>\n<th> <span style=\"color: #000000;\"><strong>Perkiraan poin<\/strong><\/span><\/th>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"> <span style=\"color: #000000;\">Berarti<\/span><\/td>\n<td style=\"text-align: left;\"> <span style=\"color: #000000;\">\u03bc (rata-rata populasi)<\/span><\/td>\n<td style=\"text-align: left;\"> <span style=\"color: #000000;\"><span style=\"text-decoration: overline;\">x<\/span> (rata-rata sampel)<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"> <span style=\"color: #000000;\">Proporsi<\/span><\/td>\n<td style=\"text-align: left;\"> <span style=\"color: #000000;\">\u03c0 (proporsi populasi)<\/span><\/td>\n<td style=\"text-align: left;\"> <span style=\"color: #000000;\">p (proporsi sampel)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <span style=\"color: #000000;\">Meskipun pendugaan titik mewakili pendugaan terbaik kami terhadap suatu parameter populasi, pendugaan titik tersebut tidak menjamin bahwa pendugaan tersebut akan sama persis dengan parameter populasi sebenarnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Oleh karena itu, kita juga sering menghitung interval kepercayaan, yaitu interval yang kemungkinan memuat parameter populasi dengan tingkat kepercayaan tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung estimasi titik dan interval kepercayaan di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Estimasi titik rata-rata populasi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung rata-rata berat suatu populasi penyu. Untuk melakukan ini, kami mengumpulkan sampel acak sebanyak 20 penyu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18738 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/point1.png\" alt=\"\" width=\"477\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Perkiraan titik<\/strong> rata-rata populasi kami hanyalah rata-rata sampel, yang berjumlah <strong>300,3<\/strong> buku:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18739 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/point2.png\" alt=\"\" width=\"473\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan rumus berikut untuk menghitung interval kepercayaan 95% untuk rata-rata populasi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18740\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/point3.png\" alt=\"estimasi titik dan interval kepercayaan di Excel\" width=\"669\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami yakin 95% bahwa berat rata-rata sebenarnya penyu dalam populasi ini berada dalam kisaran <strong>[296.96, 303.64]<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat mengonfirmasi hasil ini menggunakan <a href=\"https:\/\/statorials.org\/id\/berarti-kalkulator-interval-kepercayaan\/\" target=\"_blank\" rel=\"noopener\">kalkulator interval kepercayaan<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Estimasi titik proporsi populasi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung proporsi penyu dalam suatu populasi yang memiliki bintik-bintik pada cangkangnya. Untuk melakukan hal ini, kami mengumpulkan sampel acak sebanyak 20 penyu dan menemukan bahwa 13 di antaranya mempunyai bintik-bintik.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Perkiraan<\/strong> kami untuk proporsi penyu yang memiliki bintik adalah <strong>0,65<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18741 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/point4.png\" alt=\"\" width=\"559\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan rumus berikut untuk menghitung interval kepercayaan 95% untuk proporsi populasi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18744 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/point5.png\" alt=\"\" width=\"677\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami yakin 95% bahwa proporsi sebenarnya penyu dalam populasi ini yang memiliki bintik-bintik berada pada kisaran <strong>[0.44, 0.86]<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat memastikan hasil ini dengan menggunakan <a href=\"https:\/\/statorials.org\/id\/kalkulator-proporsi-interval-kepercayaan\/\" target=\"_blank\" rel=\"noopener\">interval kepercayaan untuk kalkulator proporsi<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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-prediksi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung interval prediksi di Excel<\/a><br \/> Cara menghitung margin of error di excel<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Estimasi titik mewakili angka yang kami hitung dari data sampel untuk memperkirakan parameter populasi. Ini adalah perkiraan terbaik kami mengenai parameter populasi sebenarnya. Tabel berikut menunjukkan estimasi titik yang kami gunakan untuk memperkirakan parameter populasi: Ukurannya Parameter populasi Perkiraan poin Berarti \u03bc (rata-rata populasi) x (rata-rata sampel) Proporsi \u03c0 (proporsi populasi) p (proporsi sampel) Meskipun [&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 Perkiraan Poin di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung estimasi titik di Excel, 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\/perkiraan-poin-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Perkiraan Poin di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung estimasi titik di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T04:38:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/point1.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\/perkiraan-poin-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/\",\"name\":\"Cara Menghitung Perkiraan Poin di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T04:38:09+00:00\",\"dateModified\":\"2023-07-24T04:38:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung estimasi titik di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung estimasi poin di excel (dengan contoh)\"}]},{\"@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 Perkiraan Poin di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung estimasi titik di Excel, 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\/perkiraan-poin-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Perkiraan Poin di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung estimasi titik di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-24T04:38:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/point1.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\/perkiraan-poin-excel\/","url":"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/","name":"Cara Menghitung Perkiraan Poin di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T04:38:09+00:00","dateModified":"2023-07-24T04:38:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung estimasi titik di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/perkiraan-poin-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/perkiraan-poin-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung estimasi poin di excel (dengan contoh)"}]},{"@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\/1989"}],"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=1989"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1989\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}