Hitung Manual RegresiTabel untuk menghitug regresi linear berganda secara manualNoYX1X2X3X1YX2YX3YX1.X2X2.X3X1.X3Y2(X1)2(X2)2(X3)211530558145082512151650445524302259003025656122025497450098014801225362618504006252401547634990202604410980127401800520023400240181004006760041225597930070894814754661197514462534816241530454014013501200420018005600630090020251600196006265043145130011183770215062357250676250018492102571322586928675489712764002151816948433644761830654217019501260510027307140110509004225176428900949100232674900112713083230061412670024011000052971289101534541005108101500183654003400225115629161000011254944150122511003750215666007350625240119362250012448529250374012761100024657250212501936722584162500133670332002520118872002310660014000129649001089400001422402311588050625309202645460048416005291322515183520100630360180070020003500324122540010000162043241188604802360103228325074400184957613924172369242101587552483016565040144905294761576441001839803823031201482897030408740184001521640014445290019152923754353451125667172521752258415295625204995402704655196013230380010800256502401902516007290021418520241348582098811700482020485168172254005808122327041200224013126400287082001400010244900168140000232745451301215121535102025585058507292025202516900241633549052886414401782486029702561089291681002538803823030401444874030408740184001444640014445290026236649165151811273795323480851089052943562401272252714295170406714980147935702030196841260149002840782320031209208000179446001560016006084529400002923502914011506673220145040607000529250084119600301224607828872093614404680187214457636006084313485342102890115671402890714017850115672251156441003213254885325624110512004080212516962523047225333270322402240102476802240768016800102449001024576003441842824334441148996323526804204121681705678459049352960411671740118948432460684710020841360016812788936214051130840107127302040663052004411600260116900371120607022066077012004200140012140036004900382039241687804803360936403265524001521576282243915292097435300145558019402813225841400940940209540250190080050003800100002375040090251600625004115305780450855120017104560240022590032496400422549451501225112537502205675073506252401202522500433369342002277112266002346680013800108947611156400004425804721020001175525037609870168006256400220944100451430531004207421400159053003000196900280910000461635511005608161600178551003500256122526011000047214022150840462315088033006000441160048422500482590402002250100050003600800018000625810016004000049387528200285010647600210056001500014445625784400005034652520022108506800162550001300011564225625400005124302010072048024006002000300057690040010000522140221508404623150880330060004411600484225005334652524722108508398162561751605511564225625610095420392220078044040008584400780040015214844000055112560692756607591500414017251216253600476156255544180137511004500242079209900625302519363240057214040100840840210016004000400044116001600100005820755115015001020300038257650112504005625260122500593269371802208118457602553666012420102447611369324006021804825016801008525038401200020000441640023046250061163454905448641440183648603060256115629168100623057411001710123030002337410057009003249168110000634589262104005117094502314546018690202579216764410064428028275336011761155022407700220001764640078475625652245501129901100246422505600504048420252500125446638753120028501178760023256200150001444562596140000674080272703200108010800216072902160016006400729729006842852820035701176840023805600170001764722578440000691635539556084815201855503533252561225280990257012205915024070818001180885030001444003481225007111246017026466018701440102004080121576360028900721735468959578215131610409431152891225211679217313255385325689110513254505212516962528097225741520459030067513509004050180022540020258100752025505050010001000125025001250400625250025001,9063,9982,95111,709117,93568,857339,205146,204428,079726,16656,920255,152128,3292,133,723

Data diatas dapat diringkas menjadi: Y= 1,906X1.X2= 146,204X1= 3,998X2.X3= 428,079X2= 2,951X1.X3= 726,166X3= 11,709Y2= 56,920X1Y= 117,935(X1)2= 255,152X2Y= 68,857(X2)2= 128,329X3Y= 339,205(X3)2= 2,133,723Persamaan regresi dengan 3 (tiga) prediktor yaitu:Y = a + b1X1 + b2X2 + b3X3 + eY = an + b1X1 + b2X2 + b3X3X1Y = aX1 + b1X12 + b2X1X2 + b3X1X3X2Y = aX2 + b1X1X2 + b2X22 + b3X2X3X3Y = aX3 + b1X1X3 + b2X2X3 + b3X32

Hasil SUMMARY OUTPUT

Regression StatisticsMultiple R0.8900069829R Square0.7921124296Adjusted R Square0.7833284477Standard Error4.9835520706Observations75ANOVAdfSSMSFSignificance FRegression36718.84548858082239.615162860390.17692012140Residual711763.341178085824.8357912406Total748482.1866666667

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept14.22424692053.35457137814.24025764170.00006620127.535421658920.91307218217.535421658920.9130721821X Variable 10.29985241430.05573203315.3802525660.00000090810.18872589790.41097893070.18872589790.4109789307X Variable 2-0.18641110190.0533430797-3.49456954610.0008221637-0.2927741805-0.0800480233-0.2927741805-0.0800480233X Variable 30.01626703310.02130525680.7635220380.4476818684-0.02621444180.0587485079-0.02621444180.0587485079Persamaan regresi dengan 3 (tiga) prediktor yaitu:Y = a + b1X1 + b2X2 + b3X3 + eBerdasarkan hasil pengolahan data menggunakan Excel, maka:a. Persamaan Regresi Linear Berganda Y = a + b1X1 + b2X2 + b3X3 Sehingga berdasarkan hasil perhitungan menggunakan Excel, persamaan regresi menjadi:Y = 14,2242 + 0,2998X1 0,1864 X2 + 0,0162 X3b. Nilai R2 dan R Nilai R2 = 0,7921 atau dibulatkan menjadi 0,79, sedangkan Nilai R = 0,89c. Standart Error (SE) Nilai Standar Error = 4,98 Nilai Standar Error (SE) untuk masing-masing variabel, yaitu:- Variabel X1 = 0.056- Variabel X2 = 0.053- Variabel X3 = 0.021d. Nilai t hitung untuk masing-masing variabel (uji secara parsial), yaitu:- Variabel X1 = 5.38- Variabel X2 = -3.49- Variabel X3 = 0.76e. Nilai F untuk untuk secara Simultan, yaitu Nilai F untuk untuk secara Simultan yaitu sebesar 90,17

DataPerhitungan Menggunakan Progran ExcelJumlah Konsumsi/BlnPendapatanUmur Jumlah KekayaanYX1X2X3153055812025497449902026012255979304540140265043145132258693065421704910023267153454100254944150448529250367033200224023115183520100204324118236924210398038230152923754995402704185202413270412002745451301633549038803823023664916514295170407823200235029140122460783485342101325488532703224041842824329604116721405113011206070203924168152920972095402501530578025494515033693420025804721014305310016355110021402215025904020038752820034652520024302010021402215034652524720392220011256069255544180214040100207551150326937180218048250163454903057411004589262104280282752245501123875312004080272704285282001635539512205915011246017017354689132553851520459020255050Y = Jumlah Konsumsi per bulan (Rp. 100.000)X1 = Pendapatan (Rp. 100.000)X2 = Umur (Tahun)X3 = Jumlah Kekayaan (Rp. 100.000)

Sheet2460.331 = -832.798 b1 916.274 b2 2.447.334 b3

168,429,96077,533,531,916,760140,268,133,828,080154,327,993,169,040412,204,367,726,640122,308,110,333,360

72.735.899 = 168.429.960 b1 81.611.338 b2 + 431.456.024b3

832,79860,574,311,215,402140,268,133,828,08067,965,759,063,724359,315,713,875,152356,503,335,04216,959,220,701,3580.086,362,234,105,31652,888,653,851,488121,951,606,998,318

1.906 = 75a + b1 3.998 + b2. 2.951 + b3. 11.709

3,9987,620,188299,85015,984,00411,798,0982,903,211,66846,812,582

117.935 = 3.998a + b1.255.152 + b2.146.204 + b3.726.166

758,845,125299,85019,136,40010,965,30032,105,92554,462,450(1,224,937)0.0(3,152,396)832,7982,871,105,743(7,649,868)

339.205 = 11.709a + b1. 726.166 + b2. 428.079 + b3.2.133.723

3,9981,356,141,59046,812,5822,903,211,6681,711,459,8422,903,211,6688,530,624,554

117.935 = 3.998a + b1.255.152 + b2.146.204 + b3.726.166

11,7091,380,900,91546,812,5822,987,574,7681,711,902,6365,012,377,0118,502,677,694(24,759,325)0.0(84,363,100)(442,794)(2,109,165,343)27,946,860

832,798168,429,960

16.959.220.701.358 = -86.362.234.105.316 b2 + 52.888.653.851.488 b3

71,653,282,988,2241,215,183,840,174,151,500,000,000,0006,188,137,599,843,457,000,000,000,0003,789,645,681,286,893,000,000,000,000548,138,156,626,559,200,00052,032,177,894,426,700,000

-25.288.285.532.000 = 71.653.282.988.224 b2 733.466.148.747.360 b3

86,362,234,105,3162,183,952,835,236,659,500,000,000,0006,188,137,599,843,457,000,000,000,00063,343,775,246,444,030,000,000,000,0002,413,553,265,828,491,700,00036,969,858,813,569,600,000(968,768,995,062,508,000,000,000,000)0.0(59,554,129,565,157,140,000,000,000,000)2,961,691,422,455,051,000,00015,062,319,080,857,100,000+0.0162670860,341,481,204-138.107.843.132.162 = 222.293.752.232.764 b2 + 52.888.653.851.488 b316,959,220,701,358-25.288.285.532.000 = 71.653.282.988.224 b2 733.466.148.747.360 b3 968,768,995,062,508(16,098,879,220,154)59,554,129,565,157,100(0.18641110)0.0162670222,293,752,232,764250889,175,008,931.063,998.000071,653,282,988,224250286,613,131,952.900.29983.1023526482282403.10241,198.600432,951.0000222,293,752,232,764222,293,562,478,5170.1860(0.0313)189,754,247548.886011,709.000015928077135248390000000000000.000.0160187.34401,906.000837.058401,068.941614.2526

(14.2200)1,906.00001,906.0000(27,103.3200)

(0.3000)56,920.0000117,935.00004,269,000.0000(35,380.5000)636,164.0000

0.1864(12.2117)68,857.00001,776.003812,834.944825.0141

(0.0162)1,776.0038339,205.000025.0141(5,495.1210)(55,143.9962)(4,135,799.7150)3,632,836.0000(7,768,635.7150)