latihan regresi pasca

41
DATA SLIDE BAPA Obs. X1 X2 X3 Y X1^2 1 2 5 1 2 4 2 2 4 2 1 4 3 1 5 4 1 1 4 1 3 4 1 1 5 3 6 5 5 9 6 4 4 6 4 16 7 5 6 3 7 25 8 5 4 3 6 25 9 7 3 7 7 49 10 6 3 7 8 36 11 4 3 8 3 16 12 3 6 9 3 9 13 6 9 5 6 36 14 6 8 4 6 36 15 8 9 5 10 64 16 9 6 5 9 81 17 10 4 7 6 100 18 9 5 8 6 81 19 4 8 8 9 16 20 4 9 7 10 16 99 110 108 110 625 2.6651 2.1151 2.2100 2.9469 5.50 Cara 2 kalau ga tau formula , Cuma tau persamaan nya aja, ga masalah. Bisa itung (X‘X)b = X’Y dari sini di dapat 1 2 5 1 2 1 2 4 2 1 1 1 5 4 1 1 1 3 4 1 1 3 6 5 5

Upload: sarahsuciar

Post on 25-Sep-2015

253 views

Category:

Documents


5 download

DESCRIPTION

statistika

TRANSCRIPT

data slide bapa1. Mencari Nilai b dan persamaan regresiDATA SLIDE BAPACARA 1Obs.X1X2X3YX1^2X2^2X3^2Y^2X1X2X1X3X2X3X1YX2YX3YY KUADRumus Persamaan matriks (XX)b = XY12512425141025410242242141641848242131541125161542015414134119161341213415365593625251815301530252564464161636161624241616241675637253694930151835422149854362516936201512302418362099110108bo1109737749949492149214921494999625560574b1=645106378369496418422148245664110560690596b2668114383169649123224129249108574596676b363712369393681918275491827913695636812536543045365430361468463664163648243236482436(XX)bX'Y1589510648125100724045809050100yang pengen dicari1696598136258154453081544581b = (XX)-1XY1710476100164936407028602442361895868125643645724054304836maka cari dulu invers (X'X)194889166464813232643672728120497101681491003628634090701000.7312144546-0.0149437128-0.0607917971-0.050534850599110108110625690676770560574596645668637770-0.01494371280.0086433835-0.0014905561-0.00363758832.66512.11512.21002.9469-0.0607917971-0.00149055610.0120277220.00037362575.50-0.0505348505-0.00363758830.00037362570.0123122169Cara 2 kalau ga tau formula , Cuma tau persamaan nya aja, ga masalah. Bisa itung sendiri gampang ko..(XX)-1(XX)b = XYdari sini di dapatb = (XX)-1XYjadi b b = (XX)-1XY1251212421bo0.7312144546-0.0149437128-0.0607917971-0.050534850511011541b1=-0.01494371280.0086433835-0.0014905561-0.003637588364511341b2-0.0607917971-0.00149055610.0120277220.000373625766813655b3-0.0505348505-0.00363758830.00037362570.0123122169637144641563715436b(XX)-1X'Y17377163781438313693bo-2.004724918116956b1=0.618338707516846b20.6240115035189510b30.18738611981965911047619586b14889149710X20X4Y20X1111111111111111111112211345576436689109445453646433369896458912445633778954557887X'4x20MAKA

20991101080.7312-0.0149-0.0608-0.050599625560574-0.01490.0086-0.0015-0.0036110560690596-0.0608-0.00150.01200.0004108574596676-0.0505-0.00360.00040.0123 X'X(X'X)-14x44x4MENCARI X'Y4x2020X1MAKA X'Y DIMENSI 3X1110645668637persamaan regresiY = -2.00472 + 0.61834 X1 + 0.62401 X2 + 0.18739 X3X'Y4x1MAKA b = (XX)-1XY4x44x1bo-2.00472b10.61834b20.62401b30.18739

2. uji keseluruhan / overall testsebelum menguji overall test kita harus mengetahui nilai - nilai berikutDerajat Bebas Regresi (DBReg) = banyaknya Independent Variabel k = 3Jumlah Kuadrat, JKReg = b(XX) n()2 = b0Y + b1X1Y + b2X2Y + b3X3Y n()2109.513368Derajat Bebas Total (DBTot)= n 1 = 20 1 = 19JKTot = YY n(Y)2 = Y2 n()2 = 770 20(5,5)2 = 165Derajat Bebas Residual (DBRes) = n k 1 = 20 3 1 = 16JKRes = JKTot JKReg = 165 109.5133680 = 55.486632RJKReg = JKReg/DBReg = 109.5133680/3 = 36.504456RJKRes = JKSis/DBRes = 3.46791R2 = JKReg/JKTot =0.663717F = RJKReg/RJKRes = 10.526343

ANOVASumber Variasi (Souces of Variation)Jumlah Kuadrat, JK (Sum of Squares)Derajat Bebas, DB Rata-rata Jumlah Kuadrat, RJK (Mean Square)FF TABELKET(Degree of Freedom)Regression109.5134336.504510.52633.24Residual55.4866163.4679Total16519

KRITERIA UJI : HO DITOLAK JIKA F HITUNG > F TABEL --> SIGNIFIKAN ( MINIMAL ADA 1 VARIABEL INDEPENDEN YANG MEMPENGARUHI VARIABEL DEPENDEN)kesimpulankarena nilai F hitung > f tabel maka terdapat minimal 1 varibel independen yang mempengaruhi variabel dependen

3. UJI INDIVIDUALhasil hitung tt tabel2.119t b13.571t b23.055t b30.907krieria ujiHO DITOLAK JIKA t HITUNG > t TABEL --> SIGNIFIKAN ( variabel independen tersebut berpengaruh terhadap variabel dependenkesimpulan karena nilai t hitung pada variabel 1 dan 2 lebih besar dari nilai t tabel maka dapat disimpulkan variabel x1 dan x2 berpengaruh teradap y . Sedangkan x3 tidak berpengaruh.

4. mencari koefisien regresi standardizedimana maka B10.559B20.448B30.141

5. PERSAMAAN REGRESIUNSTANDARDIZEDY = -2.00472 + 0.61834 X1 + 0.62401 X2 + 0.18739 X3STANDARDIZEDY = -2.00472 + 0.559 X1 + 0.448 X2 + 0.141 X3

PENGUJIAN ASUMSIPAKAI SPSS

Bk = koefisein regresi unstandardized IVk SXk = simpangan baku IVk SY = simpangan baku DV

DATA KOMPOSITNOkpkokkkinerjax1x2x3yX1^2X2^2X3^2Y^2X1X2X1X3X2X3X1YX2YX3Y11.11372.6122.162.1991.240327696.8225444.66564.8356012.90898442.4055925.641922.44902635.7437884.7498421.9172.8722.3553.0363.6748898.2483845.5460259.2172965.5056244.5145356.763565.8200128.7193927.1497831.86661.4362.963.1933.484195562.0620968.761610.1952492.68043765.5251364.250565.96005384.5851489.4512842.81552.2841.0832.1267.927040255.2166561.1728894.5198766.4306023.04918652.4735725.9857534.8557842.30245852.06692.4143.9253.224.272075615.82739615.40562510.36844.98949668.11258259.474956.6554187.7730812.638562.82732.2841.574.0437.993625295.2166562.464916.3458496.45755324.4388613.5858811.43077399.2342126.3475171.38331.4362.2372.5281.913518892.0620965.0041696.3907841.98641883.09444213.2123323.49698243.6302085.65513681.41671.6962.5762.4242.007038892.8764166.6357765.8757762.40272323.64941924.3688963.43408084.1111046.24422491.85952.0241.8523.0583.457740254.0965763.4299049.3513643.7636283.4437943.7484485.6863516.1893925.663416NOkpkokkkinerja102.78441.6963.3763.0587.752883362.87641611.3973769.3513644.72234249.40013445.7256968.51469525.18636810.323808x1x2x3yX1^2X2^2X3^2Y^2X1X2X1X3X2X3X1YX2YX3Y111.56332.2842.4732.7172.443906895.2166566.1157297.3820893.57057723.86604095.6483324.24748616.2056286.71914111.11372.6122.162.1991.240327696.8225444.66564.8356012.90898442.4055925.641922.44902635.7437884.74984122.74372.1543.9252.8467.527889694.63971615.4056258.0997165.909929810.76902258.454457.80857026.13028411.1705521.9172.8722.3553.0363.6748898.2483845.5460259.2172965.5056244.5145356.763565.8200128.7193927.14978131.56331.9051.571.8592.443906893.6290252.46493.4558812.97808652.4543812.990852.90617473.5413952.9186331.86661.4362.963.1933.484195562.0620968.761610.1952492.68043765.5251364.250565.96005384.5851489.45128141.49151.9822.2372.7972.224572253.9283245.0041697.8232092.9561533.33648554.4337344.17172555.5436546.256889153.06181.6513.3762.9829.374619242.72580111.3973768.8923245.055031810.33663685.5737769.13028764.92328210.0672321693.09972.213.0222.8169.608140094.88419.1324847.9298566.8503379.36729346.678628.72875526.223368.509952161.20232.9112.2372.3671.445525298.4739215.0041695.6026893.49989532.68954516.5119072.84584416.8903375.2949791702.0412.1122.341.5184.1656814.4605445.47562.3043244.3105924.775944.942083.0982383.2060163.55212171.5442.3212.4733.0582.3839365.3870416.1157299.3513643.5836243.8183125.7398334.7215527.0976187.562434182.73172.5813.141.497.462184896.6615619.85962.22017.05051778.5775388.104344.0702333.845694.6786191.23342.3121.1853.5071.521275565.3453441.40422512.2990492.85162081.4615792.739724.32553388.1081844.155795202.83691.2521.0671.6748.048001611.5675041.1384892.8022763.55179883.02697231.3358844.74897062.0958481.786158211.57511.8263.3761.8252.480940013.33427611.3973763.3306252.87613265.31753766.1645762.87455753.332456.1612221.72552.4282.5912.792.977350255.8951846.7132817.78414.1895144.47077056.2909484.8141456.774127.22889232.28712.7282.4732.5285.230826417.4419846.1157296.3907846.23920885.65599836.7463445.78178886.8963846.251744242.42340.9782.0881.7525.872867560.9564844.3597443.0695042.37008525.06005922.0420644.24579681.7134563.658176251.02050.7180.7852.2821.041420250.5155240.6162255.2075240.7327190.80109250.563632.3287811.6384761.79137260.97012.183.4941.780.941094014.752412.2080363.16842.1148183.38952947.616921.7267783.88046.21932270.86512.8862.7713.5070.748398018.3289967.67844112.2990492.49667862.39719217.9971063.033905710.1212029.717897281.28591.1222.2061.1691.653538811.2588844.8664361.3665611.44277982.83669542.4751321.50321711.3116182.578814292.8681.6063.2272.0738.2254242.57923610.4135294.2973294.6060089.2550365.1825625.9453643.3292386.689571301.28592.1542.162.8461.653538814.6397164.66568.0997162.76982862.7775444.652643.65967146.1302846.14736311.30970.9921.3032.3411.715314090.9840641.6978095.4802811.29922241.70653911.2925763.06600772.3222723.050323320.86510.9921.7812.8740.748398010.9840643.1719618.2598760.85817921.54074311.7667522.48629742.8510085.118594332.92051.9112.7243.2428.529320253.6519217.42017610.5105645.58107557.9554425.2055649.4682616.1954628.831208341.29792.140.9340.8511.684544414.57960.8723560.7242012.7775061.21223861.998761.10451291.821140.794834351.07531.9052.2374.0431.156270093.6290255.00416916.3458492.04844652.40544614.2614854.34743797.7019159.044191362.29711.662.562.0485.276668412.75566.55364.1943043.8131865.8805764.24964.70446083.399685.24288373.5853.482.6532.09512.85222512.11047.0384094.38902512.47589.5110059.232447.5105757.29065.558035381.11643.3753.0063.3791.2463489611.3906259.03603611.4176413.767853.355898410.145253.772315611.40412510.157274392.7513.1552.0172.1457.5680019.9540254.0682894.6010258.6794055.5487676.3636355.9008956.7674754.326465403.4681.8293.1243.15612.0270243.3452419.7593769.9603366.34297210.8340325.71379610.9450085.7723249.859344410.98213.052.6064.0110.964520419.30256.79123616.0881212.9954052.55935267.94833.939203112.2335510.452666421.18031.0433.4072.9721.393108091.08784911.6076498.8327841.23105294.02128213.5535013.50785163.09979610.125604431.39091.7611.1853.1841.934602813.1011211.40422510.1378562.44937491.64821652.0867854.42862565.6070243.77304441.06331.7611.9712.9721.130606893.1011213.8848418.8327841.87247132.09576433.4709313.16012765.2336925.857812451.03462.1593.4223.4041.070397164.66128111.71008411.5872162.23370143.54040127.3880983.52177847.34923611.648488461.38592.2692.6063.1921.920718815.1483616.79123610.1888643.14460713.61165545.9130144.42379287.2426488.318352472.71992.942.2533.1927.397856018.64365.07600910.1888647.9965066.12793476.623828.68192089.384487.191576482.6461.3262.6072.7737.0013161.7582766.7964497.6895293.5085966.8981223.4568827.3373583.6769987.229211493.53252.3743.1241.92212.478556255.6358769.7593763.6940848.38615511.035537.4163766.7894654.5628286.004328501.67351.3261.571.0712.800602251.7582762.46491.1470412.2190612.6273952.081821.79231851.4201461.68147513.19292.4373.4222.77310.194610415.93896911.7100847.6895297.781097310.92610388.3394148.85391176.7578019.489206521.53172.4031.2882.5892.346104895.7744091.6589446.7029213.68067511.97282963.0950643.96557136.2213673.334632532.17491.8693.542.7734.730190013.49316112.53167.6895294.06488817.6991466.616266.03099775.1827379.81642542.39971.9193.4072.7735.758560093.68256111.6076497.6895294.60502438.17577796.5380336.65436815.3213879.447611551.21411.4361.4521.5181.474038812.0620962.1083042.3043241.74344761.76287322.0850721.84300382.1798482.204136561.19210.7182.3862.9851.421102410.5155245.6929968.9102250.85592782.84435061.7131483.55841852.143237.12221572.80352.1543.9252.7737.859612254.63971615.4056257.6895296.03873911.00373758.454457.77410555.97304210.884025581.43611.4361.571.0712.062383212.0620962.46491.1470412.06223962.2546772.254521.53806311.5379561.68147591.49543.591.4522.9852.2362211612.88812.1083048.9102255.3684862.17132085.212684.46376910.716154.33422601.85252.3741.1851.5183.431756255.6358761.4042252.3043244.3978352.19521252.813192.8120953.6037321.79883613.43692.8722.8582.54511.812281618.2483848.1681646.4770259.87077689.82266028.2081768.74691057.309247.27361621.19270.7183.4072.3331.422533290.51552411.6076495.4428890.85635864.06352892.4462262.78256911.6750947.948531632.60083.593.6892.6636.7641606412.888113.6087217.0915699.3368729.594351213.243516.92593049.560179.823807643.13312.1542.742.3979.816315614.6397167.50765.7456096.74869748.5846945.901967.51004075.1631386.56778651.18032.8723.0684.2551.393108098.2483849.41262418.1050253.38982163.62116048.8112965.022176512.2203613.05434662.82212.8721.573.4047.964248418.2483842.464911.5872168.10507124.4306974.509049.60642849.7762885.34428670.94632.8723.3043.4040.895483698.24838410.91641611.5872162.71777363.12657529.4890883.22120529.77628811.246816681.63963.593.142.5072.6882881612.88819.85966.2850495.8861645.14834411.27264.11047729.000137.87198691.31253.593.1252.9761.7226562512.88819.7656258.8565764.7118754.101562511.218753.90610.683849.3701.45791.713.3044.0442.125472412.924110.91641616.3539362.4930094.81690165.649845.89574766.9152413.361376712.44251.1383.9250.8515.965806251.29504415.4056250.7242012.7795659.58681254.466652.07856750.9684383.340175723.38442.6163.0532.94911.454163366.8434569.3208098.6966018.853590410.33257327.9866489.98059567.7145849.003297731.09712.1541.172.4551.203628414.6397161.36896.0270252.36315341.2836072.520182.69338055.288072.87235743.07341.2673.8072.2319.445787561.60528914.4932494.9773613.893997811.70043384.8234696.85675542.8266778.493417751.40042.5983.5712.1071.961120166.74960412.7520414.4394493.63823925.00082849.2774582.95064285.4739867.524097762.95163.593.5251.7028.7119425612.888112.4256252.89680410.59624410.4043912.654755.02362326.110185.99955772.73622.8723.2583.6487.486790448.24838410.61456413.3079047.85836648.91453969.3569769.981657610.47705611.885184782.83463.593.142.4978.0349571612.88819.85966.23500910.1762148.90064411.27267.07799628.964237.84058793.5853.593.8072.79712.85222512.888114.4932497.82320912.8701513.64809513.6671310.02724510.0412310.648179802.71052.8723.143.6487.346810258.2483849.859613.3079047.7845568.510979.018089.88790410.47705611.45472812.54313.593.4222.5866.4673576112.888111.7100846.6873969.1297298.702488212.284986.57645669.283748.849292823.06862.8723.0533.8329.416305968.2483849.32080914.6842248.81301929.36843588.76821611.758875211.00550411.699096831.02031.4361.2162.9811.041012092.0620961.4786568.8863611.46515081.24068481.7461763.04151434.2807163.624896841.09210.7183.8072.9811.192682410.51552414.4932498.8863610.78412784.15762472.7334263.25555012.14035811.348667853.06862.8723.9254.0449.416305968.24838415.40562516.3539368.813019212.04425511.272612.409418411.61436815.8727860.84132.8723.143.4040.707785698.2483849.859611.5872162.41621362.6416829.018082.86378529.77628810.68856872.93981.9342.2680.8518.642424043.7403565.1438240.7242015.68557326.66746644.3863122.50176981.6458341.930068881.37160.7182.9042.5531.881286560.5155248.4332166.5178090.98480883.98312642.0850723.50169481.8330547.413912892.64813.592.7863.4047.0124336112.88817.76179611.5872169.5066797.377606610.001749.014132412.220369.483544902.88731.5160.7850.8518.336501292.2982560.6162250.7242014.37714682.26653051.190062.45709231.2901160.668035911.77363.593.8073.4043.1456569612.888114.49324911.5872166.3672246.752095213.667136.037334412.2203612.959028923.11171.1633.6890.8519.682676891.35256913.6087210.7242013.618907111.47906134.2903072.64805670.9897133.139339932.77210.9533.143.2147.684538410.9082099.859610.3297962.64181138.7043942.992428.90952943.06294210.09196942.18392.4691.4522.8144.769419216.0959612.1083047.9185965.39204913.17102283.5849886.14549466.9477664.085928952.41161.663.143.2185.815814562.75569.859610.3555244.0032567.5724245.21247.76052885.3418810.10452961.02283.2313.8073.5071.0461198410.43936114.49324912.2990493.30466683.893799612.3004173.586959611.33111713.351149971.81662.9572.1193.2743.300035568.7438494.49016110.7190765.37168623.84937546.2658835.94754849.6812186.937606982.59562.4883.4223.1126.737139366.19014411.7100849.6845446.45785288.88214328.5139368.07750727.74265610.649264992.7512.0253.0223.7197.5680014.1006259.13248413.8309615.5707758.3135226.1195510.2309697.53097511.2388181001.03462.052.7861.4251.070397164.20257.7617962.0306252.120932.88239565.71131.4743052.921253.970051012.45681.6643.1090.9616.035866242.7688969.6658810.9235214.08811527.63819125.1733762.36098481.5991042.9877491021.27862.1680.9341.8531.634817964.7002240.8723563.4336092.77200481.19421242.0249122.36924584.0173041.7307021031.16163.590.7853.2051.3493145612.88810.61622510.2720254.1701440.9118562.818153.72292811.505952.5159251042.6343.593.542.576.93795612.888112.53166.60499.456069.3243612.70866.769389.22639.09781051.16162.6123.2891.6361.349314566.82254410.8175212.6764963.03409923.82050248.5908681.90037764.2732325.3808041063.41553.463.6892.14911.6656402511.971613.6087214.61820111.8176312.599779512.763947.33990957.435547.9276611071.03462.8723.0223.431.070397168.2483849.13248411.76492.97137123.12656128.6791843.5486789.8509610.365461081.03461.6962.4012.4141.070397162.8764165.7648015.8273961.75468162.48407464.0720962.49752444.0941445.7960141093.50143.0022.6372.67912.259801969.0120046.9537697.17704110.51120289.23319187.9162749.38025068.0423587.0645231103.5853.0023.8072.96612.8522259.01200414.4932498.79715610.7621713.64809511.42861410.633118.90393211.2915621113.33192.8922.161.35611.101557618.3636644.66561.8387369.63585487.1969046.246724.51805643.9215522.928961123.39623.592.5143.11211.5341744412.88816.3201969.68454412.1923588.53804689.0252610.568974411.172087.8235681131.16162.1541.0212.7971.349314564.6397161.0424417.8232092.50208641.18599362.1992343.24899526.0247382.8557371142.67922.7823.8073.2057.178112647.73952414.49324910.2720257.453534410.199714410.5910748.5868368.9163112.2014351152.60742.7821.1393.6166.798534767.7395241.29732113.0754567.25378682.96982863.1686989.428358410.0597124.1186241163.05683.351.172.3699.3440262411.22251.36895.61216110.240283.5764563.91957.24155927.936152.771731171.09462.7821.8063.8231.198149167.7395243.26163614.6153293.04517721.97684765.0242924.184655810.6355866.9043381182.71992.9721.1851.8637.397856018.8327841.4042253.4707698.08354283.22308153.521825.06717375.5368362.2076551190.90582.9122.9044.2550.820473648.4797448.43321618.1050252.63768962.63044328.4564483.85417912.3905612.356521200.98940.8620.9342.980.978912360.7430440.8723568.88040.85286280.92409960.8051082.9484122.568762.783321213.5852.9431.4521.18112.8522258.6612492.1083041.39476110.5506555.205424.2732364.2338853.4756831.7148121221.74932.213.0223.0363.060050494.88419.1324849.2172963.8659535.28638466.678625.31087486.709569.1747921232.0412.1122.341.7384.1656814.4605445.47563.0206444.3105924.775944.942083.5472583.6706564.066921241.82113.1263.0532.7723.316405219.7718769.3208097.6839845.69275865.55981839.5436785.04808928.6652728.4629161251.66153.0872.743.2942.760582259.5295697.507610.8504365.12905054.552518.458385.47298110.1685789.025561261.39332.4743.4223.531.941284896.12067611.71008412.46093.44702424.76787268.4660284.9183498.7332212.079661271.86452.2093.0222.6633.476360254.8796819.1324847.0915694.11868055.6345196.6755984.96516355.8825678.0475861282.96162.4363.2584.0438.771074565.93409610.61456416.3458497.21445769.64889287.93648811.97374889.84874813.1720941293.5852.6682.4324.25512.8522257.1182245.91462418.1050259.564788.718726.48857615.25417511.3523410.348161303.5852.3032.552.81612.8522255.3038096.50257.9298568.2562559.141755.8726510.095366.4852487.18081312.92052.9361.4521.2468.529320258.6200962.1083041.5525168.5745884.2405664.2630723.6389433.6582561.8091921322.5292.0362.6374.0716.3958414.1452966.95376916.5730415.1490446.6689735.36893210.2955598.28855610.7352271333.5852.472.6223.2212.8522256.10096.87488410.36848.854959.399876.4763411.54377.95348.442841340.78883.3022.9762.8990.6222054410.9032048.8565768.4042012.60461762.34746889.8267522.28673129.5724988.6274241351.7882.1981.9241.7113.1969444.8312043.7017762.9275213.9300243.4401124.2289523.0592683.7607783.2919641363.31263.0143.6433.19310.973318769.08419613.27144910.1952499.984176412.067801810.98000210.57713189.62370211.6320991373.41551.4751.3342.12611.665640252.1756251.7795564.5198765.03786254.5562771.967657.2613533.135852.8360841381.81361.5523.142.7963.289144962.4087049.85967.8176162.81470725.6947044.873285.07082564.3393928.779441391.04192.2343.0223.0931.085555614.9907569.1324849.5666492.32760463.14862186.7511483.22259676.9097629.3470461400.8343.4853.142.8730.69555612.1452259.85968.2541292.906492.6187610.94292.39608210.0124059.021221412.69123.593.8072.8497.2425574412.888114.4932498.1168019.66140810.245398413.667137.667228810.2279110.8461431420.7171.3212.5192.480.5140891.7450416.3453616.15040.9471571.8061233.3275991.778163.276086.247121432.49793.1653.142.9026.2395044110.0172259.85968.4216047.90585357.8434069.93817.24890589.184839.112281441.11640.7181.1853.0081.246348960.5155241.4042259.0480640.80157521.3229340.850833.35813122.1597443.564481451.22322.0363.5713.4641.496218244.14529612.75204111.9992962.49043524.36804727.2705564.23716487.05270412.3699441461.06332.3883.2583.2211.130606895.70254410.61456410.3748412.53916043.46423147.7801043.42488937.69174810.4940181472.60292.2512.9043.6156.775088415.0670018.43321613.0682255.85912797.55882166.5369049.40948358.13736510.497961481.26452.0353.2582.1261.598960254.14122510.6145644.5198762.57325754.1197416.630032.6883274.326416.9265081492.10012.5873.2583.044.410420016.69256910.6145649.24165.43295876.84212588.4284466.3843047.864489.904321502.41232.5442.8584.0715.819191296.4719368.16816416.5730416.13689126.89435347.2707529.820473310.35662411.6349181512.96570.7181.4524.0718.795376490.5155242.10830416.5730412.12937264.30619641.04253612.07336472.9229785.9110921521.08992.8723.0683.221.187882018.2483849.41262410.36843.13019283.34381328.8112963.5094789.247849.878961531.23340.7181.573.4641.521275560.5155242.464911.9992960.88558121.9364381.127264.27249762.4871525.438481541.31253.592.8893.6431.7226562512.88818.34632113.2714494.7118753.791812510.371514.781437513.0783710.5246271551.45791.923.4222.7982.125472413.686411.7100847.8288042.7991684.98893386.570244.07920425.372169.5747561561.00851.1381.4521.1731.017072251.2950442.1083041.3759291.1476731.4643421.6523761.18297051.3348741.7031961573.38442.6163.1713.9111.454163366.84345610.05524115.28818.853590410.73193248.29533613.23300410.2285612.398611581.05390.7181.173.221.110705210.5155241.368910.36840.75670021.2330630.840063.3935582.311963.76741593.07341.6973.9252.8389.445787562.87980915.4056258.0542445.215559812.0630956.6607258.72230924.81608611.139151601.40042.6083.6892.7711.961120166.80166413.6087217.6784413.65224325.16607569.6209123.88050847.22676810.2222191610.7172.3742.740.8510.5140895.6358767.50760.7242011.7021581.964586.504760.6101672.0202742.331741621.16163.351.0213.1991.3493145611.22251.04244110.2336013.891361.18599363.420353.715958410.716653.2661791632.67923.0023.8073.4737.178112649.01200414.49324912.0617298.042958410.199714411.4286149.304861610.42594613.2217111643.32443.0023.143.61611.051635369.0120049.859613.0754569.979848810.4386169.4262812.021030410.85523211.354241652.71992.9721.1851.1967.397856018.8327841.4042251.4304168.08354283.22308153.521823.25300043.5545121.417261660.90582.4922.9044.2550.820473646.2100648.43321618.1050252.25725362.63044327.2367683.85417910.6034612.356521671.10641.8680.9342.981.224120963.4894240.8723568.88042.06675521.03337761.7447123.2970725.566642.783321681.13752.6283.0220.9611.293906256.9063849.1324840.9235212.989353.4375257.9418161.09313752.5255082.9041421693.09972.213.0222.8169.608140094.88419.1324847.9298566.8503379.36729346.678628.72875526.223368.5099521702.0412.1122.341.5184.1656814.4605445.47562.3043244.3105924.775944.942083.0982383.2060163.55212346.8535392.592442.671463.341838.535735951013.1065261286.2650231382.528153826.0997307930.22219231049.42825939.6538841093.1530031233.678946x1x2x3yX1^2X2^2X3^2Y^2X1X2X1X3X2X3X1YX2YX3Y2.7255352941ykuad7.4285426395simpangan baku0.87990531740.79371949420.88902970350.84151140541. Mencari Nilai b dan persamaan regresiCARA 1Rumus Persamaan matriks (XX)b = XY

170346.8535392.592442.671bo463.341346.8535838.53573595826.0997307930.2221923b1=Matriks 939.653884392.592826.09973071013.1065261049.42825b2X'Y1093.153003442.671930.22219231049.428251286.265023b31233.678946

(XX)bX'Y4x4yang pengen dicarib = (XX)-1XY

maka cari dulu invers (X'X)

0.0992565555-0.0096054241-0.0157702027-0.0143462843Matriks -0.00960542410.0082256891-0.0015966468-0.0013403999-0.0157702027-0.00159664680.0102153983-0.0017524225-0.0143462843-0.0013403999-0.00175242250.0081138765

(XX)-1

jadi b b = (XX)-1XY

bo0.0992565555-0.0096054241-0.0157702027-0.0143462843463.341b1=-0.00960542410.0082256891-0.0015966468-0.0013403999939.653884b2-0.0157702027-0.00159664680.0102153983-0.00175242251093.153003b3-0.0143462843-0.0013403999-0.00175242250.00811387651233.678946

b(XX)-1X'Y4x44x1

bo2.0259041988b1=-0.1202885666b20.1977896212b30.1875188877

persamaan regresiY = 2.02590 - 0.12029 X1 + 0.19779 X2 + 0.187519 X3

2. uji keseluruhan / overall testsebelum menguji overall test kita harus mengetahui nilai - nilai berikutDerajat Bebas Regresi (DBReg) = banyaknya Independent Variabel k = 3Jumlah Kuadrat, JKReg = b(XX) n()2 = b0Y + b1X1Y + b2X2Y + b3X3Y n()210.3550320668Derajat Bebas Total (DBTot)= n 1 = 170-1=169JKTot = YY n(Y)2 = Y2 n()2 = 119.6759042882Derajat Bebas Residual (DBRes) = n k 1 =166JKRes = JKTot JKReg = 109.3208722214RJKReg = JKReg/DBReg =3.4516773556RJKRes = JKSis/DBRes = 0.6585594712R2 = JKReg/JKTot =0.0865256221F = RJKReg/RJKRes = 5.2412538373

ANOVASumber Variasi (Souces of Variation)Jumlah Kuadrat, JK (Sum of Squares)Derajat Bebas, DB Rata-rata Jumlah Kuadrat, RJK (Mean Square)FF TABELKET(Degree of Freedom)Regression10.355033.45175.24132.80ho ditolakResidual109.32091660.6586Total119.676169

KRITERIA UJI : HO DITOLAK JIKA F HITUNG > F TABEL --> SIGNIFIKAN ( MINIMAL ADA 1 VARIABEL INDEPENDEN YANG MEMPENGARUHI VARIABEL DEPENDEN)

kesimpulankarena nilai F hitung > f tabel maka terdapat minimal 1 varibel independen yang mempengaruhi variabel dependen, dilakukan uji individual

3. UJI INDIVIDUAL

hasil hitung tt tabel1.96t b1-1.634t b22.411t b32.565

krieria ujiHO DITOLAK JIKA t HITUNG > t TABEL --> SIGNIFIKAN ( variabel independen tersebut berpengaruh terhadap variabel dependen

kesimpulan karena nilai t hitung pada variabel 2 dan 3 lebih besar dari nilai t tabel maka dapat disimpulkan variabel x2 dan x3 berpengaruh teradap y . Sedangkan x1 tidak berpengaruh.

4. mencari koefisien regresi standardize

dimana

maka B1-0.126B20.187B30.198

5. PERSAMAAN REGRESI

UNSTANDARDIZED

Y = 2.02590 - 0.12029 X1 + 0.19779 X2 + 0.187519 X3

STANDARDIZED

Y = 2.02590 - 0.126 X1 + 0.187 X2 + 0.198 X3

PENGUJIAN ASUMSI

PAKAI SPSS

Bk = koefisein regresi unstandardized IVk SXk = simpangan baku IVk SY = simpangan baku DV