回归分析例题SPSS求解过程

1、回归分析例题SPSS求解过程1、一元线性回归例仇2.1 为研究家庭收人与家庭俟品支出的关系，随机抽取r w 个家庭为得到衣的数搐试根据这些数据：1）建立家庭食品支出对家庭收人的样本回归直线*2）硕测当家庭收人为4 200元时家庭的乎均食品支出及其直倍度 为於簡的预测区间.* 4.2.1CAlt入号債昂支出曲91单佗t百元12345678910寂联收人203033401513263R3543食品支出79S1154810910SPSS求解过程:10 j爲題 311J21007.0930.009.09333.00B.00dfllOD11.00515.005.002B.004.0072600BOOB3

2、3001D00J35.00900W4)00| IOO9|13IB19：oWLS毗出De6Linear RegressionSWisto Plot.escriCzelldstr-V EJinaleib C on 1 dcrcc rtsrvd3_ Coic-crccnwKP M:dcKlr Rjqumd changeQccc诒心Pari ard padoaralcre一 CjInesiJy JagoMiw| 5讼Car:elHdp厂 jtr WifeonCsswsedijixto“ Q伽砒曲CosHicients3ModelJnstandrciiied efficientsStandardsdCo

3、 eflic ids95% Mdenc?lntervalfur3Bsw. ErrorBetaLower BounilUpuer Bound1呦 starfl2.173.7201017.Oil.5123.833SfflU.202023肿3.692.000J 43256a De卩endent临曲履破出判别：？ ？0 ? 2.173 0.202x，且x与 y的线性相关系数为r=0.951，回归方程的F检验值为75.559，对应F值的显著性概率是0.0000.05,表示回归方程不具 有显著性。每个系数的t检验值分别是3.017与8.692，对应的检验显著性概率 分别为：0.017(0.05 )和0.0

4、00 (1 口 1 啦11 社丨 bl 恥1 -rir l 口1 壬% qi13 :卷积YIO. T6秋這frx1Yvarvs rvrI12E.42E38.2034曰日日45日50569 7Q67!.76口去s91O10.49101110.591 t1210.30121310.3013141C.S01416IQ.30151b1U Vb|1 fe1、丫与X的二次及三次多项式拟合:OepuniJent MtliRyq d f.卜 8iy1 bO b1 B2 bBUA .059CUB -9211235.64 .QUO 5.09271 142.84 ,ODD 4.11B3.74D0 -029D1L7O

5、ES -,1534.U4fo OYObservedQLiRdlrsrtlCCubic所以，二次式为：Y6.09270.7408X0.029x223三次式为： Y 4.118 1.7068X 0.1534x20.0046x32、把Y与X的关系用双曲线拟合:作双曲线变换：U次数X |容积Y |V|Uvar|varV126.42.5000.1558238.20 .3330.1220349.58.2500.1040459.50.2000.1053569 70.1667.10316710.00.1420.1000789.93.1250.1007899.99.1110.100191010.49.1000.

6、095310111210.59.0900.09441110.60.0830.0943121310.80.0760.0926131410.60.0714.0943141510.90.0667.0917151610.76.0625.09261617181920 1 .e Edit Viev DataTransforn1 Analyze Graphs Utilities Window HlpI Compute. .In| gRecodeVisual Bander.Cmt, Rank CasesAutomatic Recode.次数X次数XIV1U1varvar121.8594232.104134Cr

7、eate Time SeriesReplace Missing VaRandom Numb er Seed2 259745.,Jlues.2.2513562.272167!2.302678Kun re2.2956899.999.0000.10012.301691010.4910.0000.09532.350410111210.5911.0000.09442.35991110.6012.0000.09432 3609121310.8013.0000.09262.379513141510.6014.0000.09432.36091410.9015.0000.09172 3888151610.761

8、6.0000.09292.375816COal(d&mno 孟S8 _515S &C总 N_syv 、*n_p总 JxNV一 sgy o匸 cqxnj683gLZcoSI8 8 8 & ieo o o o owcm co p s gT TTII JIIalq&TTBA avldnooRcoRegressionVariables EnteredjRemovedbModelVariables EnteredVariables Removed帕 ethod1WEntera All requested variables entered.b. Dependent Variable: UModel Su

9、mmaryModelRR SquareAdjusted R SquareStd. Error of the Estimate1.968.938.933.0042568a Predictors: (Constant), VANOVAbModelSum of SquaresdfMean SquareFSig.1RegressionResidual Total.004 .000 .00411314.004.000196.227.000aa. Predictors: (Constant), Vb. Dependent Variable: UCocfficieiW1/loJeunslandaTdlLze

10、dCoefficientsSlanJardlzEdCoefflciehtetClQ95% Confidence InrteralforDeStd E-io9e:aLower BoundUp 皿汨 LintJjonetantjL紙JffOJM.51 I.OUQJ78JOBSV131J0013.ytia11.00a.000111.151a. Depen de nt Variable: U11判别：U 0.082 0.131V , U 丄,V - , V与U的相关系数为R=0.968，回归 yx方程系数的F检验值为196.227 ,对应F值的显著性概率是0.000 (0.05),表 示线性回归方程具

11、有显著性，每个系数的t检验值分别是440514与14.008，对应的检验显著性概率分别为：0.000 (0.05 )和0.000( J2d71 丄ill r Regression步次BX佔稅丫Dependentn (uiBlock 1 o? 1incependntft)Z1IE niwRegressionVariables EirteredReinoved6ModelVariables E nteredVariables RemovedMetnod1vaEntera. All requested variables entered.D. Dependent Variable: U1Model

12、SummaryModelRR CquorcAdjusted R GquarcStd. Error of the Eotimotc147沪.959.956.0289852Q Predictors: (Constant), VANOVAbMndftlSum of SquarpsrtfMpan SquareFSig.1RegressionResidual Total.255 .011.26611314.255 .031303.190000aa. Predictors: (Constant). V b Dependent Variable: U1Ccefficieiitsrioceii irKtfin

13、dardiid CDifficientsCoeffic-iemtstSiu95% ConffidencB IntervalforlDDStd. EinarBetaLower B 3rcUtiper Boumd(Canislsin2.15E.1315.221joac2.4312 IBS-1.111-.679-17.12.DOC-1.246-.973a. DependritVnitle- IJ1判别：U1 2.458 1.111V , U1 In y,V 1/x , V 与U1 的相关系数为 R=0.979,回归方程的F检验值为303.190，对应F值的显著性概率是0.000 (0.05),表 示

14、线性回归方程具有显著性 ，每个系数的t检验值分别是195.221与-17.412，0.000( 0.05 )和 0.000( X、的线性冋归方稈“检验冋归方程 利冋归系数的显著性如有不显著的变竜，请剔除之并求别除不皿胃的变 量之后的回归方程一k 4,4, I壷户的斗期细.r ir *A a j,J*椀r)c tw)(3CO(l (m 5 rnirt) I)i2304.330 226vg2.亍“在科274032斗呂527125SI5.6J B 4354j4.4M3 02HO1 4 1务曾季NW1 233JS . 541 M1 27475 1 %O 251205 7 O升461?t. 301 O齐

15、312403.11 53 1512X4 433 373t 7空US 232斗1 J畔 15 & S石53. ”芳 y33OSO45斗521 2S3742 OJ4fl Co4-2斗 SOS OIO23S34.&3S173-330 &bl a3I6i64)5.DOfo OJ&IO斗4村A &vy H12.O“5.270 I37斗1 452 asi s13各450戈.2l1 3刍 W74 r14Bt Ci4S5,HO7 b4421 JS54 O2 220OES24.730 64S7SO2 2* 32 t0o40b eso S4&4IO-454 u 7 1 1 322I632：! 127 Z47IOS

16、4 53 1 O2O17472 . 1 O 斗4R鼻1 7(54i5 33 7On-*43,717 44*41 5T2R 077 1工誌左1麻.右194丘G fT) n0m6pID in0 fln0L6 N n KIDPnGpD呂 IDIDs m4)PsN.IDGL代 n N D0sNP8IDPnNnnJN05.01508L1080u(0un p30 pp0舟N n$868LJiLJLa8Du10PN GN nN PV T舟RL0厂T卜TJ 00L0060 0 qL00000otL00卜r-U) DD n0DLDDV D G G L G L DPu :?!: o T LIHMO-IAr二 do

17、l0 5pbs 2II0VU0S0 2SIZ JTQCVXUCH:uo to:nH OA-mu.3C A 3要 - *l1aKc口 *opcCIOE4 S ogLDg LE9Ln 090 卜HUPCT8 m ONLNm 00L9 Z nzcLln 0089 p OOE: 、O8S 06 LNfnOso0 S ug: nfyotr nUBU5S xoHauloCJ llgteAquv onqAuu-KllleME ruodrvpc La; NzXVAF.m订Ml falM cdH I w I I H w I n n aMd %umMJ-ssdHCJ -woxuauuwHutou*H PO5PXI

18、E 7PCZ, ; 7SIIBIW1.4B d uloCJ gm 50二OAtafyfT lljogtfelf 7f xa 占EoID8rupQU1ORR=1NPLnVoo NLOOH-00 6 LIs疋刁 C -D 2;tle:8888SS8、 co ib lS rn k=;JDL 00.9 L ac me aa 8 oo g38Eo co n 8 3 N 10 CM - riYou 町 av-tj 2Poxte52SdocfcnViiu口WLSWedy32Qmear Rrrcsion03 GOD 17 039 004.00 00 9.002 00DependG 丫d4讨8旺如1|?|4K2

19、A二tleihod Ertaivar/arvar?569.001200He04GEUJ 3 12702 61CC3 71703=TMT2 7C0J6 63105 B1S06X05 331044 旳 3?51J60DG036002?:B2930.1. X2ANOVAbWOdClSum of Sauare3OfMoan sauoeF8ig1RoorocGionResidual Total15 23629 67244.M8345&85 079B597702oco* Prodlctorg. (ConctCinO.X3.X1.X2 o DoponconiVariabio:YCoefficiarts5Mo

20、delUmshnclanliiedComciartsSlaridardiiedl Cocflieiointe1El.bi% Conrklsiflco intfiivslfofBDGtl ErrcrDetaLcwerDoindUpper DoLrid；CLdlijnli895SD342ad.Mfl2fi3FX11B1.61726&3Ullmg.282X2109.D57-6722876QOb185X3osa.01134DIODImsoflra DependBirtVariBHe 判别：y 0.695 0.16篦 0.10&2 0.03&3, xi,x2,xs与 y 的复相关系数为R=0.582,回

21、归方程的F检验值为7.702，对应F值的显著性概率是0.000（0.05 ）、0.011（0.05 ）、0.006（ 0.05）和 0.001 （ 0.01）是:L 巧 K211G.COt. i nn n* BCm r M M* 肛5a11IB2?.0D5.0DIZODLUD3.DD3.DD5.0D9.00 a 4.CCI1.002gj；o112.0017.00wdsll 已赳中mMf7 3 A 3 5 1和XI挈X24*I IV0l0C.k F 贸 135JBODii i3.ODD.ODE.DD.003.DDTog1B.ODB.DDOD9 0D4 OD.OD9.002.0012.ODB.DD iOD n- it匚 nn_HDs1 )1 VI rw ,!i H”；IIfci.LUA.QQ14.CO21.CO14.00,00b.LO 6