]] XL-mania [[ ask: program exel untuk least square

 

terimakasih kepada para master2 mohon pencerahanagar excel saya bisa mengerjakan untuk least square apa perlu maxro ato addins lgi yaks? bentuk nya outputnya seperti dibawah ini gan

Dependent Variable: OMZET
Method : Least Squares
Date : 01/21/05 Time: 09:46
Sample : 1 42
Included observations: 42
Variable Coefficient Std. Error t-Statistic Prob.
C 0.231929 0.823178 0.281749 0.7797
JK -1.555667 0.399939 -3.889758 0.0004
LU 0.222618 0.090091 2.471022 0.0182
MODAL 0.226232 0.046541 4.860961 0.0000
USIA 0.010289 0.011927 0.862665 0.3939
R-squared 0.806458
Mean dependent var 4.521429
Adjusted R-squared 0.785534
S.D. dependent var 2.098610
S.E. of regression 0.971876
Akaike info criterion 2.892166
Sum squared resid 34.94807
Schwarz criterion 3.099031
Log likelihood -55.73548
F-statistic 38.54317
Durbin-Watson stat 1.390431
Prob(F-statistic) 0.000000

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 73

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| tiap tanggal gajian, order buku "mengapa boss benci chart anda    |
| membludak :) ayo2 pesan yang belum punya....                      |
| www.facebook.com/pages/XL-mania/104233892978057                   |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___