{"id":1563,"date":"2023-07-25T21:19:49","date_gmt":"2023-07-25T21:19:49","guid":{"rendered":"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/"},"modified":"2023-07-25T21:19:49","modified_gmt":"2023-07-25T21:19:49","slug":"cronbachs-alpha-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/","title":{"rendered":"Cara menghitung cronbach's alpha di excel"},"content":{"rendered":"

<\/p>\n

\n

Chronbach’s Alpha<\/strong> adalah cara untuk mengukur konsistensi internal<\/a> suatu kuesioner atau survei.<\/span><\/p>\n

Alfa Cronbach berkisar antara 0 hingga 1, dengan nilai yang lebih tinggi menunjukkan bahwa survei atau kuesioner tersebut lebih dapat diandalkan.<\/span><\/p>\n

Contoh langkah demi langkah berikut menjelaskan cara menghitung Cronbach’s Alpha di Excel.<\/span><\/p>\n

Langkah 1: Masukkan datanya<\/span><\/strong><\/span><\/h3>\n

Misalkan seorang manajer restoran ingin mengukur kepuasan pelanggan secara keseluruhan. Dia memutuskan untuk mengirimkan survei kepada 10 pelanggan yang akan dapat menilai restoran tersebut dalam skala 1 hingga 3 untuk berbagai kategori.<\/span><\/p>\n

Mari kita mulai dengan memasukkan data yang berisi tanggapan survei untuk masing-masing dari 10 pelanggan:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Lakukan ANOVA dua arah tanpa replikasi<\/strong><\/span><\/h3>\n

Selanjutnya kita akan melakukan ANOVA dua arah tanpa replikasi.<\/span><\/p>\n

Untuk melakukannya, klik tab Data<\/strong> di pita atas, lalu klik opsi Analisis Data<\/strong> di bawah grup Analisis<\/b> :<\/span> <\/p>\n

\"\"<\/p>\n

Jika opsi ini tidak tersedia, Anda harus memuat Analysis ToolPak<\/a> terlebih dahulu.<\/span><\/p>\n

Di menu drop-down yang muncul, klik Anova: Dua Faktor Tanpa Replikasi<\/strong> lalu klik OK<\/strong> . Pada jendela baru yang muncul, berikan informasi berikut lalu klik OK<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Akan muncul hasil sebagai berikut:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 3: Hitung Alpha Cronbach<\/strong><\/span><\/h3>\n

Selanjutnya kita akan menggunakan rumus berikut untuk menghitung Cronbach’s Alpha:<\/span> <\/p>\n

\"Alfa<\/p>\n

Alpha Cronbach ternyata 0,773<\/strong> .<\/span><\/p>\n

Tabel berikut menjelaskan bagaimana nilai-nilai Cronbach’s Alpha yang berbeda diinterpretasikan secara umum:<\/span><\/p>\n\n\n\n\n\n\n\n\n\n
Alfa Cronbach<\/span><\/strong><\/th>\n Konsistensi internal<\/span><\/strong><\/th>\n<\/tr>\n
0,9 \u2264 \u03b1<\/span><\/td>\n Bagus sekali<\/span><\/td>\n<\/tr>\n
0,8 \u2264\u03b1 < 0,9<\/span><\/td>\n BAGUS<\/span><\/td>\n<\/tr>\n
0,7 \u2264\u03b1 < 0,8<\/span><\/td>\n Dapat diterima<\/span><\/td>\n<\/tr>\n
0,6 \u2264\u03b1 < 0,7<\/span><\/td>\n Dipertanyakan<\/span><\/td>\n<\/tr>\n
0,5 \u2264\u03b1 < 0,6<\/span><\/td>\n Miskin<\/span><\/td>\n<\/tr>\n
<0,5<\/span><\/td>\n Tidak dapat diterima<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Karena kami menghitung alpha Cronbach sebesar 0,773<\/strong> , kami dapat mengatakan bahwa konsistensi internal survei ini adalah \u201cDapat Diterima\u201d.<\/span><\/p>\n

Bonus:<\/strong> Jangan ragu untuk menggunakan kalkulator Cronbach Alpha ini untuk secara otomatis menemukan Cronbach Alpha untuk kumpulan data tertentu.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Chronbach’s Alpha adalah cara untuk mengukur konsistensi internal suatu kuesioner atau survei. Alfa Cronbach berkisar antara 0 hingga 1, dengan nilai yang lebih tinggi menunjukkan bahwa survei atau kuesioner tersebut lebih dapat diandalkan. Contoh langkah demi langkah berikut menjelaskan cara menghitung Cronbach’s Alpha di Excel. Langkah 1: Masukkan datanya Misalkan seorang manajer restoran ingin mengukur […]<\/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 Cronbach's alpha di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung Cronbach's Alpha di Excel, dengan contoh langkah demi langkah.\" \/>\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\/cronbachs-alpha-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung Cronbach's alpha di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung Cronbach's Alpha di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T21:19:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cronbachexcel1.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\/cronbachs-alpha-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/\",\"name\":\"Cara menghitung Cronbach's alpha di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T21:19:49+00:00\",\"dateModified\":\"2023-07-25T21:19:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung Cronbach's Alpha di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung cronbach's alpha 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 Cronbach's alpha di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung Cronbach's Alpha di Excel, dengan contoh langkah demi langkah.","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\/cronbachs-alpha-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung Cronbach's alpha di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung Cronbach's Alpha di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T21:19:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cronbachexcel1.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\/cronbachs-alpha-excel\/","url":"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/","name":"Cara menghitung Cronbach's alpha di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T21:19:49+00:00","dateModified":"2023-07-25T21:19:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung Cronbach's Alpha di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cronbachs-alpha-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung cronbach's alpha 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\/1563"}],"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=1563"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1563\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}