{"id":2547,"date":"2023-07-21T19:30:39","date_gmt":"2023-07-21T19:30:39","guid":{"rendered":"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/"},"modified":"2023-07-21T19:30:39","modified_gmt":"2023-07-21T19:30:39","slug":"fungsi-sigmoid-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/","title":{"rendered":"Cara menghitung fungsi sigmoid di excel"},"content":{"rendered":"

<\/p>\n

\n

Fungsi sigmoid<\/a> adalah fungsi matematika yang memperlihatkan kurva berbentuk “S” ketika diplot.<\/span><\/p>\n

Contoh fungsi sigmoid yang paling umum adalah fungsi sigmoid logistik, yang dihitung sebagai berikut:<\/span><\/p>\n

F(x) = 1 \/ (1 + e -x<\/sup> )<\/strong><\/span><\/p>\n

Untuk menghitung nilai fungsi sigmoid untuk nilai x tertentu di Excel, kita bisa menggunakan rumus berikut:<\/span><\/p>\n

 =1\/(1+EXP(- A1<\/span> ))\n<\/strong><\/pre>\n
 Rumus ini mengasumsikan nilai x ada di sel A1<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Menghitung Fungsi Sigmoid di Excel<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki daftar nilai x berikut dalam sebuah kolom di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk menghitung nilai fungsi sigmoid setiap nilai x, saya dapat mengetikkan rumus berikut pada sel B2<\/strong> :<\/span><\/p>\n
 =1\/(1+EXP(- A2<\/span> ))<\/strong><\/pre>\n
 Saya kemudian dapat menyeret rumus ini ke setiap sel yang tersisa di kolom B untuk menghitung nilai fungsi sigmoid untuk setiap nilai x:<\/span> <\/p>\n
\"fungsi<\/p>\n
 Kita kemudian dapat membuat plot garis untuk memvisualisasikan nilai fungsi sigmoid.<\/span><\/p>\n
 Pertama, sorot setiap nilai di kolom A dan B:<\/span> <\/p>\n
\"\"<\/p>\n
 Kemudian klik tab Sisipkan<\/strong> di sepanjang pita atas. Kemudian klik pada grup Charts<\/strong> dan klik pada grafik yang berjudul Scatter with Smooth Lines and Markers<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Setelah Anda mengkliknya, grafik garis berikut akan muncul:<\/span> <\/p>\n
\"\"<\/p>\n
 Sumbu x menampilkan nilai x dan sumbu y menampilkan nilai fungsi sigmoid untuk setiap nilai x.<\/span><\/p>\n
 Perhatikan bahwa plot menunjukkan karakteristik kurva berbentuk \u201cS\u201d dari fungsi sigmoid.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n
 Cara Melakukan Curve Fit di Excel<\/a>
 Cara menyesuaikan kurva polinomial di Excel<\/a>
 Cara Membuat Kurva Lonceng di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Fungsi sigmoid adalah fungsi matematika yang memperlihatkan kurva berbentuk “S” ketika diplot. Contoh fungsi sigmoid yang paling umum adalah fungsi sigmoid logistik, yang dihitung sebagai berikut: F(x) = 1 \/ (1 + e -x ) Untuk menghitung nilai fungsi sigmoid untuk nilai x tertentu di Excel, kita bisa menggunakan rumus berikut: =1\/(1+EXP(- A1 )) Rumus […]<\/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":"\nCara Menghitung Fungsi Sigmoid di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung dan memplot fungsi sigmoid di Excel, dengan contoh lengkap.\" \/>\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\/fungsi-sigmoid-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Fungsi Sigmoid di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung dan memplot fungsi sigmoid di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T19:30:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sig1.jpg\" \/>\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\/fungsi-sigmoid-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/\",\"name\":\"Cara Menghitung Fungsi Sigmoid di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T19:30:39+00:00\",\"dateModified\":\"2023-07-21T19:30:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung dan memplot fungsi sigmoid di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung fungsi sigmoid 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 Fungsi Sigmoid di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung dan memplot fungsi sigmoid di Excel, dengan contoh lengkap.","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\/fungsi-sigmoid-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Fungsi Sigmoid di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung dan memplot fungsi sigmoid di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-21T19:30:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sig1.jpg"}],"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\/fungsi-sigmoid-unggul\/","url":"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/","name":"Cara Menghitung Fungsi Sigmoid di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T19:30:39+00:00","dateModified":"2023-07-21T19:30:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung dan memplot fungsi sigmoid di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/fungsi-sigmoid-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung fungsi sigmoid 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\/2547"}],"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=2547"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2547\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}