{"id":718,"date":"2023-07-29T00:07:32","date_gmt":"2023-07-29T00:07:32","guid":{"rendered":"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/"},"modified":"2023-07-29T00:07:32","modified_gmt":"2023-07-29T00:07:32","slug":"nilai-p-statistik-f-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/","title":{"rendered":"Cara menghitung nilai p dari statistik f di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Uji F menghasilkan statistik F. Untuk menemukan nilai p yang terkait dengan statistik F di Excel, Anda bisa menggunakan perintah berikut:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>=F.DIST.RT(x, derajat_kebebasan1, derajat_kebebasan2)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x :<\/strong> nilai statistik F<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Derajat_kebebasan1:<\/strong> derajat kebebasan pada pembilangnya<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Degree_freedom2:<\/strong> derajat kebebasan penyebut<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Misalnya, berikut cara mencari nilai p yang terkait dengan statistik F 5,4, dengan derajat kebebasan pembilang = 2 dan derajat kebebasan penyebut = 9:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7195 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fstat_p1.png\" alt=\"Nilai P statistik F di Excel\" width=\"428\" height=\"342\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai p-nya adalah <strong>0,02878<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Salah satu kegunaan uji F yang paling umum adalah untuk <a href=\"https:\/\/statorials.org\/id\/panduan-sederhana-untuk-memahami-uji-f-untuk-signifikansi-keseluruhan-dalam-regresi\/\" target=\"_blank\" rel=\"noopener\">menguji signifikansi model regresi secara keseluruhan<\/a> . Pada contoh berikut, kami menunjukkan cara menghitung nilai p dari statistik F untuk model regresi.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: Menghitung nilai p dari statistik F<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data yang menunjukkan jumlah jam belajar, jumlah ujian persiapan yang diambil, dan nilai ujian akhir untuk 12 siswa berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7199 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fstat_p2.png\" alt=\"Data mentah di Excel\" width=\"306\" height=\"307\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita menyesuaikan model regresi linier dengan data ini menggunakan <strong>jam_belajar<\/strong> dan <strong>ujian_persiapan <i>&nbsp;<\/i><\/strong> sebagai variabel penjelas dan <strong>skor<\/strong> sebagai variabel respon, maka diperoleh hasil sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7201 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fstat_p3-1.png\" alt=\"Statistik F untuk Regresi Global di Excel\" width=\"668\" height=\"325\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Statistik F untuk model regresi keseluruhan adalah <strong>5,0905<\/strong> . Statistik F ini mempunyai 2 derajat kebebasan untuk pembilangnya dan 9 derajat kebebasan untuk penyebutnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Excel secara otomatis menghitung bahwa nilai p untuk statistik F ini adalah <strong>0,0332<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7202 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fstat_p4.png\" alt=\"Nilai P statistik F di Excel\" width=\"674\" height=\"327\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung sendiri nilai p ini, kita dapat menggunakan kode berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7203 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fstat_p5.png\" alt=\"Nilai P menghitung statistik F di Excel\" width=\"669\" height=\"324\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita mendapatkan nilai p yang sama dengan keluaran regresi linier.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uji F menghasilkan statistik F. Untuk menemukan nilai p yang terkait dengan statistik F di Excel, Anda bisa menggunakan perintah berikut: =F.DIST.RT(x, derajat_kebebasan1, derajat_kebebasan2) Emas: x : nilai statistik F Derajat_kebebasan1: derajat kebebasan pada pembilangnya Degree_freedom2: derajat kebebasan penyebut Misalnya, berikut cara mencari nilai p yang terkait dengan statistik F 5,4, dengan derajat kebebasan pembilang [&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 P dari statistik F di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung nilai p dari f-statistik di Excel\" \/>\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-p-statistik-f-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung nilai P dari statistik F di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung nilai p dari f-statistik di Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T00:07:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fstat_p1.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\/nilai-p-statistik-f-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/\",\"name\":\"Cara menghitung nilai P dari statistik F di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T00:07:32+00:00\",\"dateModified\":\"2023-07-29T00:07:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung nilai p dari f-statistik di Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung nilai p dari statistik f 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 menghitung nilai P dari statistik F di Excel - Statorials","description":"Penjelasan sederhana tentang cara menghitung nilai p dari f-statistik di Excel","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-p-statistik-f-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung nilai P dari statistik F di Excel - Statorials","og_description":"Penjelasan sederhana tentang cara menghitung nilai p dari f-statistik di Excel","og_url":"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T00:07:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fstat_p1.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\/nilai-p-statistik-f-di-excel\/","url":"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/","name":"Cara menghitung nilai P dari statistik F di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T00:07:32+00:00","dateModified":"2023-07-29T00:07:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung nilai p dari f-statistik di Excel","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nilai-p-statistik-f-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung nilai p dari statistik f 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\/718"}],"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=718"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/718\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}