店鋪租金的確定模型

1、店鋪租金的確定模型某商人欲在某火車站附近經(jīng)營一店鋪，委托本小組對相關(guān)情況進行調(diào)查。經(jīng)過數(shù)月的資料收集和整理，我們的調(diào)查成果如下：進出車站的乘客為主要服務(wù)對象的10家便利店的數(shù)據(jù)。y是日均銷售額，x1為店鋪面積，x2是店鋪距車站的距離，x3為店員人數(shù)，x4為店鋪日租金。具體數(shù)據(jù)如下表：店鋪代碼日均銷售額（元）y店鋪面積（m2）x1離車站距離（100m）x2店員人數(shù)（人）x3店鋪日租金（元）x4abcdefghij400045008000600050002000150090003000700060100855075557095456535213461325753545644600600102075

2、07504402801425450780數(shù)據(jù)來源：為了考察店鋪面積、離車站距離、店員人數(shù)和日租金對日銷售額的影響，我們首先做y關(guān)于x1、x2、x3、x4的回歸，即建立如下回歸模型：y=c+1 x1+2 x2+3 x3+4 x4得回歸結(jié)果如下表：dependent variable: ymethod: least squaresdate: 12/14/03 time: 17:51sample: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c4815.267153

3、6.4183.1340870.0258x1128.193039.797963.2210960.0234x2-1494.966513.4078-2.9118480.0333x3-619.1674472.6664-1.3099460.2472x4-1.8772082.938471-0.6388380.5510r-squared0.970270 mean dependent var5000.000adjusted r-squared0.946486 s.d. dependent var2505.549s.e. of regression579.6124 akaike info criterion15

4、.86945sum squared resid1679752. schwarz criterion16.02074log likelihood-74.34724 f-statistic40.79489durbin-watson stat1.407218 prob(f-statistic)0.000522從回歸結(jié)果來看， r2接近于1，整個方程的擬合優(yōu)度很高，ff0.05(4，5)5.19，變量x3、x4對應的偏回歸系數(shù)之t值小于2，而且x3、x4的符號與經(jīng)濟意義相悖，該模型明顯存在多重共線性，回歸結(jié)果不顯著，回歸方程不能投入使用。由于變量較多，采用逐步回歸法來修正模型。用y對各個變量單獨進行回

5、歸：對x1，有：dependent variable: ymethod: least squaresdate: 12/14/03 time: 20:17sample: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c444.44442988.5550.1487160.8855x165.0793741.384151.5725670.1545r-squared0.236129 mean dependent var5000.000adjusted r-squared0.140645 s.d. de

6、pendent var2505.549s.e. of regression2322.680 akaike info criterion18.51569sum squared resid43158730 schwarz criterion18.57620log likelihood-90.57844 f-statistic2.472968durbin-watson stat1.988381 prob(f-statistic)0.154464對x2，有：dependent variable: ymethod: least squaresdate: 12/14/03 time: 20:20sampl

7、e: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c8687.5001096.2327.9248710.0000x2-1229.167324.6760-3.7858260.0053r-squared0.641777 mean dependent var5000.000adjusted r-squared0.596999 s.d. dependent var2505.549s.e. of regression1590.581 akaike info criterion17.75844sum

8、squared resid20239583 schwarz criterion17.81896log likelihood-86.79221 f-statistic14.33248durbin-watson stat2.488527 prob(f-statistic)0.005344對x3，有：dependent variable: ymethod: least squaresdate: 12/14/03 time: 20:28sample: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c

9、3344.8283791.3250.8822320.4034x3344.8276770.69640.4474230.6664r-squared0.024413 mean dependent var5000.000adjusted r-squared-0.097536 s.d. dependent var2505.549s.e. of regression2624.897 akaike info criterion18.76033sum squared resid55120690 schwarz criterion18.82084log likelihood-91.80164 f-statist

10、ic0.200188durbin-watson stat2.273575 prob(f-statistic)0.666436對x4，有：dependent variable: ymethod: least squaresdate: 12/14/03 time: 20:30sample: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c-124.4556691.7552-0.1799130.8617x47.2226300.8931328.0868540.0000r-squared0.89100

11、4 mean dependent var5000.000adjusted r-squared0.877380 s.d. dependent var2505.549s.e. of regression877.3734 akaike info criterion16.56860sum squared resid6158272. schwarz criterion16.62912log likelihood-80.84299 f-statistic65.39721durbin-watson stat1.099477 prob(f-statistic)0.000040從上面的回歸結(jié)果可以看到，y對x2

12、的回歸擬合最好，故選擇該回歸式為基本回歸表達式?，F(xiàn)在分別加入x1、x3、x4回歸結(jié)果如下：加入x1，有：dependent variable: ymethod: least squaresdate: 12/14/03 time: 21:21sample: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c3641.214817.19384.4557530.0030x175.4584910.588697.1263260.0002x2-1307.769121.3087-10.780500.0000

13、r-squared0.956605 mean dependent var5000.000adjusted r-squared0.944206 s.d. dependent var2505.549s.e. of regression591.8273 akaike info criterion15.84763sum squared resid2451817. schwarz criterion15.93841log likelihood-76.23816 f-statistic77.15446durbin-watson stat1.809788 prob(f-statistic)0.000017可

14、見，加入x1效果較好，這樣回歸式中就有x1、x2兩個變量了。在此基礎(chǔ)上繼續(xù)加入其他變量。加入x3，有：dependent variable: ymethod: least squaresdate: 12/14/03 time: 21:26sample: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c3993.580797.84105.0054840.0024x1109.374725.406914.3049200.0051x2-1181.338142.6370-8.2821300.0002x

15、3-647.0407446.8316-1.4480640.1978r-squared0.967843 mean dependent var5000.000adjusted r-squared0.951765 s.d. dependent var2505.549s.e. of regression550.2815 akaike info criterion15.74791sum squared resid1816859. schwarz criterion15.86895log likelihood-74.73956 f-statistic60.19526durbin-watson stat1.

16、281362 prob(f-statistic)0.000072可以看出，加入了x3以后引起了多重共線性，故剔除。現(xiàn)在加入x4，回歸結(jié)果如下：dependent variable: ymethod: least squaresdate: 12/14/03 time: 21:29sample: 1 10included observations: 10variablecoefficientstd. errort-statisticprob. c4636.4821619.0772.8636580.0287x199.5763235.195072.8292690.0300x2-1674.283523.

17、5131-3.1981670.0186x4-2.2325263.095576-0.7211990.4979r-squared0.960067 mean dependent var5000.000adjusted r-squared0.940100 s.d. dependent var2505.549s.e. of regression613.2195 akaike info criterion15.96450sum squared resid2256229. schwarz criterion16.08553log likelihood-75.82249 f-statistic48.08356durbin-watson stat1.907328 prob(f-