Cara Menjalankan Beberapa Analisis Regresi di Excel

Anda bisa menjalankan beberapa analisis regresi dengan mudah menggunakan Excel ketika tidak memiliki peranti lunak statistik yang mutakhir. Proses analisis ini cepat dan mudah dipelajari.

Langkah

Unduh PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/71\/Run-a-Multiple-Regression-in-Excel-Step-1-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-1-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/71\/Run-a-Multiple-Regression-in-Excel-Step-1-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-1-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/51\/Addin0.jpg\/460px-Addin0.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/51\/Addin0.jpg\/728px-Addin0.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":412,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Run-a-Multiple-Regression-in-Excel-Step-2-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-2-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Run-a-Multiple-Regression-in-Excel-Step-2-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-2-Version-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f4\/Addin1.jpg\/460px-Addin1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f4\/Addin1.jpg\/728px-Addin1.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":412,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

2
Periksa apakah ToolPak “ Data Analysis ” sudah aktif dengan mengeklik label “Data”. Jika Anda tidak melihat opsi ini, lakukan langkah-langkah berikut untuk mengaktifkan add-in :
- Buka menu " File " (atau tekan Alt+F) dan pilih " Options "
- Klik " Add-Ins " di sisi kiri jendela.
- Klik " Go " di sebelah opsi " Manage: Add-ins " di bagian bawah jendela.
- {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1f\/Addin2.jpg\/460px-Addin2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1f\/Addin2.jpg\/728px-Addin2.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":412,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  
  Centang kotak di sebelah " Analysis ToolPak " di jendela baru, lalu klik "OK".
  
  {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/26\/Addin3.jpg\/460px-Addin3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/26\/Addin3.jpg\/728px-Addin3.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":412,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
- {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/27\/Addin4.jpg\/460px-Addin4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/27\/Addin4.jpg\/728px-Addin4.jpg","smallWidth":460,"smallHeight":261,"bigWidth":728,"bigHeight":413,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  
  {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/85\/Addin5.jpg\/460px-Addin5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/85\/Addin5.jpg\/728px-Addin5.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":412,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  
  Sekarang, add-in Anda sudah aktif.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a7\/Run-a-Multiple-Regression-in-Excel-Step-3-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-3-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Run-a-Multiple-Regression-in-Excel-Step-3-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-3-Version-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Data harus disusun dalam kolom-kolom yang saling bersebelahan dan label/judulnya berada di baris pertama di setiap kolom.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/33\/Run-a-Multiple-Regression-in-Excel-Step-4-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-4-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Run-a-Multiple-Regression-in-Excel-Step-4-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-4-Version-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Pilih label "Data", lalu klik " Data Analysis " dalam kelompok " Analysis " (kemungkinan berada di atau dekat ujung kanan label opsi Data).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3a\/Addin6.jpg\/460px-Addin6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3a\/Addin6.jpg\/728px-Addin6.jpg","smallWidth":460,"smallHeight":297,"bigWidth":728,"bigHeight":470,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b1\/Run-a-Multiple-Regression-in-Excel-Step-5-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-5-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b1\/Run-a-Multiple-Regression-in-Excel-Step-5-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-5-Version-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Masukkan data variabel dependen (Y) dengan meletakkan kursor di kotak " Input Y-Range ", lalu sorot kolom data terkait di dalam buku kerja ( workbook ).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3a\/Addin6.jpg\/460px-Addin6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3a\/Addin6.jpg\/728px-Addin6.jpg","smallWidth":460,"smallHeight":297,"bigWidth":728,"bigHeight":470,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/10\/Run-a-Multiple-Regression-in-Excel-Step-6-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-6-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/10\/Run-a-Multiple-Regression-in-Excel-Step-6-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-6-Version-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

6
Masukkan data variabel independen dengan meletakkan kursor di kotak " Input X-Range ", lalu sorot beberapa kolom data terkait di buku kerja (misalnya $C$1: $E$53 ).
- Catatan: kolom data variabel independen HARUS saling bersebelahan supaya masukan dapat dianalisis dengan benar.
- Jika Anda menggunakan label atau judul (sekali lagi, judul berada di baris pertama setiap kolom), klik kotak di sebelah " Labels ".
- Tingkat keyakinan awal ( default confidence level ) adalah 95%. Jika Anda ingin mengubahnya, klik kotak di sebelah " Confidence Level " dan ubah nilainya.
- Di bawah " Output Options ", masukkan nama di dalam kotak " New Worksheet Ply ".
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ac\/Run-a-Multiple-Regression-in-Excel-Step-7-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-7-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ac\/Run-a-Multiple-Regression-in-Excel-Step-7-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-7-Version-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Keluaran residual grafis dibuat dengan opsi " Residual Plots " dan " Line Fit Plots ".
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3e\/Run-a-Multiple-Regression-in-Excel-Step-8-Version-5.jpg\/v4-460px-Run-a-Multiple-Regression-in-Excel-Step-8-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3e\/Run-a-Multiple-Regression-in-Excel-Step-8-Version-5.jpg\/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-8-Version-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Iklan

Masuk

Cara Menjalankan Beberapa Analisis Regresi di Excel

Langkah

wikiHow Terkait

Tentang wikiHow ini

Apakah artikel ini membantu Anda?

Artikel Terkait

Ikuti kami

Bagikan

Explore Categories