數(shù)據(jù)挖掘成績預測試驗過程

1、1.4班前13個做數(shù)據(jù)集，最后10個做測試集，建立Y關于X1,X2的線性回歸方程scorescoreX1X2Y1 9897872 9492723 9190784 8788815 8282766 8372807 9782808 8377649 83796010 86815511 88847012 85826413 848166 lm.sol lm.solCall:lm(formula=Y1+X1+X2,data=score)Coefficients:(Intercept)X1X2-12.38550.82080.1448summary(lm.sol)Call:lm(formula=Y1+X1+X2

2、,data=score)Residuals:Min1QMedian3QMax-14.938-5.262-2.0144.89413.828Coefficients:EstimateStd.ErrortvaluePr(|t|)(Intercept)-12.385539.8844-0.3110.763X10.82080.67911.2090.255X20.14480.56400.2570.803Residualstandarderror:8.661on10degreesoffreedomMultipleR-squared:0.3094,AdjustedR-squared:0.1713F-statis

3、tic:2.24on2and10DF,p-value:0.157做測試：x-c(75,74,88,83,95,84,88,97,87,97);y0.8208*x+0.1448*y-12.38551 59.600159.068971.139367.469777.464169.014572.587379.829770.897779.5401而實際715684827083828581902.猜測結果不是很滿意的理由是數(shù)據(jù)集太少，因為將4班成績做數(shù)據(jù)集，5班成績做測試。scorescoreX1X2Y1 9897872 9492723 9190784 87888158282766837280797828

4、0883776498379601086815511888470128582641384816614848475157368891680775817838081187974691978727220807174218472872287737623757271247474562588788426838182279582702884868329888882309787853187828132978590 Im.sol lm.solCall:lm(formula=Y1+X1+X2,data=score)Coefficients:(Intercept)X1X232.92170.6823-0.2033 su

5、mmary(lm.sol)Call:lm(formula=Y1+X1+X2,data=score)Residuals:Min1QMedian3QMax-20.137-6.7121.4106.89720.091Coefficients:EstimateStd.ErrortvaluePr(|t|)(Intercept)32.921722.24071.4800.1496X10.68230.38091.7910.0837.X2-0.20330.3724-0.5460.5893Signif.codes:0*0.001*0.01*0.05.0.11Residualstandarderror:9.343on

6、29degreesoffreedomMultipleR-squared:0.139,AdjustedR-squared:0.07958F-statistic:2.34on2and29DF,p-value:0.1142x-c(76,85,88,80,80,86,80,85,85,86,87,80,76,79,78,77,82,75,75,73,80,75,80,79,82,71,71,77,84,83,84,80);y0.6823*x-0.2033*y+32.9217170.138974.449977.513372.664873.274777.775173.478075.466476.48297

7、5.742176.831072.258269.732371.98251571.706871.227873.826169.050069.456667.888772.868169.050073.274771.575974.639367.134066.727470.82122975.800671.255673.564372.05493.非線性 x x1 Y summary(lm.sol summary(lm.sol 20.191-6.9301.4016.60720.368Coefficients:EstimateStd.ErrortvaluePr(|t|)(Intercept)26.28689362

8、3.59280431.1140.274x0.63591010.37992841.6740.105I(x1)A2)-0.00088160.0022831-0.3860.702Residualstandarderror:9.367on29degreesoffreedomMultipleR-squared:0.1346,AdjustedR-squared:0.07488F-statistic:2.255on2and29DF,p-value:0.123ab26.2868936+0.6359101*a-0.0008816*b*b170.0458574.5550777.1548672.4616672.83

9、98676.8986472.9624075.24713975.8951175.6115176.5189572.2007069.7884271.8257571.4437470.932131773.6038869.1525169.4099468.0102872.5894969.1525172.8398671.564792574.1116867.1166766.8663070.6817675.2592071.9264773.7754672.06758變換變量位置ab26.2868936+0.6359101*a-0.0008816*b*b170.0458574.5550777.1548672.4616

10、672.8398676.8986472.9624075.24713975.8951175.6115176.5189572.2007069.7884271.8257571.4437470.932131773.6038869.1525169.4099468.0102872.5894969.1525172.8398671.564792574.1116867.1166766.8663070.6817675.2592071.9264773.7754672.06758x1Ysummary(lm.sol|t|)(Intercept)62.16716920.6683683.0080.00539*x1-0.20

11、93230.367815-0.5690.57367I(xA2)0.0040230.0021761.8490.07471.Signif.codes:0*0.001*0.01*0.05.0.11Residualstandarderror:9.313on29degreesoffreedomMultipleR-squared:0.1445,AdjustedR-squared:0.0855F-statistic:2.449on2and29DF,p-value:0.104ab62.167169-0.209323*a+0.004023*b*b167.1138570.7696266.9835966.85990

12、65.1340362.7677464.5748367.6115664.6546668.6413267.1929268.0507068.2885767.0692266.1199265.7620067.0326368.497891967.3231868.3251666.2765668.4978965.1340368.2600364.7153867.0179468.1604766.9045364.8639877.3796671.6346968.658184平時成績與實驗成績的關系scorescorexy1 97982 92943 90914 88875 82826 72837 82978 77839

13、7983108186118488128285138184148484156873167780178083187479197278207180217284227387237275247474257888268183278295288684298888308797318287328597 Im.sol lm.solCall:lm(formula=y1+x,data=score)Coefficients:(Intercept)x26.46100.7346 summary(lm.sol)Call:lm(formula=y1+x,data=score)Residuals:Min1QMedian3QMax

14、 6.825-3.049-1.4271.94510.298Coefficients:EstimateStd.ErrortvaluePr(|t|)(Intercept)26.46109.50372.7840.0092*x0.73460.11786.2377.2e-07*Signif.codes:0*0.001*0.01*0.05.0.11Residualstandarderror:4.478on30degreesoffreedomMultipleR-squared:0.5646,AdjustedR-squared:0.5501F-statistic:38.9on1and30DF,p-value:

15、7.198e-07a0.7346*a+26.4610179.352285.963682.290680.086877.883076.413877.148482.290678.617610 83.759882.290681.556080.821480.086878.617677.883080.821480.821419 79.352280.086879.352280.821477.883081.556077.883077.883079.352228 79.352278.617692.575086.698282.29065.期末成績與最后成績datadataxy1 8792.22 7282.43 7

16、884.24 8184.35 7679.06 8078.27 8084.08 6471.79 6070.310 5569.011 7077.812 6473.613 6674.114 7579.515 8979.516 5868.117 8181.1186972.5197273.2207474.3218781.9227677.3237172.1245665.0258483.0268281.9277078.6288384.1298285.0308588.0318182.5329089.9 Im.sol lm.solCall:lm(formula=y1+x,data=data)Coefficients:(Intercept)x34.22710.5934summary(lm.sol)Call:lm(formula=y1+x,data=data)Residuals:Min1QMedian3QMax-7.5419-2.13530.33642.11776.3449Coefficients:EstimateStd.Err