spss.jnl

VB和SQL的应用,VB和数据库的连接,极其相关功能

Tue Jun 10 15:25:14 2008 :journaling started
SAVE OUTFILE='D:\学习\SPSS数据表\单样本假设检验.sav'
 /COMPRESSED.
T-TEST
 /TESTVAL=3.25
 /MISSING=ANALYSIS
 /VARIABLES=jg
 /CRITERIA=CIN (.9) .
GET
 FILE='D:\学习\SPSS数据表\单样本假设检验.sav'.
Tue Jun 10 15:32:23 2008 :journaling started
GET
 FILE='D:\学习\SPSS数据表\单样本假设检验.sav'.
T-TEST
 /TESTVAL=3.25
 /MISSING=ANALYSIS
 /VARIABLES=jg
 /CRITERIA=CIN (.9) .
T-TEST
 GROUPS=学校(1 2)
 /MISSING=ANALYSIS
 /VARIABLES=工资
 /CRITERIA=CIN(.95) .
SAVE OUTFILE='D:\学习\SPSS数据表\独立样本假设检验.sav'
 /COMPRESSED.
T-TEST
 GROUPS=学校(1 2)
 /MISSING=ANALYSIS
 /VARIABLES=工资
 /CRITERIA=CIN(.95) .
SAVE OUTFILE='D:\学习\SPSS数据表\配对样本假设检验.sav'
 /COMPRESSED.
T-TEST
 PAIRS= 平均气温  WITH 地温 (PAIRED)
 /CRITERIA=CIN(.95)
 /MISSING=ANALYSIS.
SAVE OUTFILE='D:\学习\SPSS数据表\单因素方差分析.sav'
 /COMPRESSED.
ONEWAY
 苗高 BY 处理方法
 /STATISTICS DESCRIPTIVES HOMOGENEITY
 /PLOT MEANS
 /MISSING ANALYSIS
 /POSTHOC = LSD ALPHA(.05).
Tue Jun 10 17:36:02 2008 :journaling started
SAVE OUTFILE='D:\学习\SPSS数据表\双因素方差分析.sav'
 /COMPRESSED.
UNIANOVA
 生长量  BY 施氮肥 施钾肥
 /METHOD = SSTYPE(3)
 /INTERCEPT = INCLUDE
 /EMMEANS = TABLES(施氮肥) COMPARE ADJ(LSD)
 /CRITERIA = ALPHA(.05)
 /DESIGN = 施氮肥 施钾肥 施氮肥*施钾肥 .
UNIANOVA
 生长量  BY 施氮肥 施钾肥
 /METHOD = SSTYPE(3)
 /INTERCEPT = INCLUDE
 /POSTHOC = 施钾肥 ( LSD )
 /EMMEANS = TABLES(施氮肥) COMPARE ADJ(LSD)
 /CRITERIA = ALPHA(.05)
 /DESIGN = 施氮肥 施钾肥 施氮肥*施钾肥 .
UNIANOVA
 生长量  BY 施氮肥 施钾肥
 /METHOD = SSTYPE(3)
 /INTERCEPT = INCLUDE
 /POSTHOC = 施钾肥 ( LSD )
 /EMMEANS = TABLES(施氮肥) COMPARE ADJ(LSD)
 /CRITERIA = ALPHA(.05)
 /DESIGN = 施氮肥 施钾肥 施氮肥*施钾肥 .
Wed Jun 18 09:10:00 2008 :journaling started
GET
 FILE='D:\学习\空间统计\SPSS数据表\独立样本假设检验.sav'.
Wed Jun 18 09:16:26 2008 :journaling started
GET
 FILE='D:\学习\空间统计\SPSS数据表\单样本假设检验.sav'.
T-TEST
 /TESTVAL=3.25
 /MISSING=ANALYSIS
 /VARIABLES=jg
 /CRITERIA=CIN (.9) .
GET
 FILE='D:\学习\空间统计\SPSS数据表\独立样本假设检验.sav'.
T-TEST
 GROUPS=学校(1 2)
 /MISSING=ANALYSIS
 /VARIABLES=工资
 /CRITERIA=CIN(.95) .
GET
 FILE='D:\学习\空间统计\SPSS数据表\配对样本假设检验.sav'.
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\配对样本假设检验.sav'
 /COMPRESSED.
T-TEST
 PAIRS= 平均气温  WITH 地温 (PAIRED)
 /CRITERIA=CIN(.95)
 /MISSING=ANALYSIS.
GET
 FILE='D:\学习\空间统计\SPSS数据表\单因素方差分析.sav'.
ONEWAY
 苗高 BY 处理方法
 /STATISTICS DESCRIPTIVES HOMOGENEITY
 /PLOT MEANS
 /MISSING ANALYSIS .
ONEWAY
 苗高 BY 处理方法
 /MISSING ANALYSIS
 /POSTHOC = LSD ALPHA(.05).
GET
 FILE='D:\学习\空间统计\SPSS数据表\双因素方差分析.sav'.
UNIANOVA
 生长量  BY 施氮肥 施钾肥
 /METHOD = SSTYPE(3)
 /INTERCEPT = INCLUDE
 /CRITERIA = ALPHA(.05)
 /DESIGN = 施氮肥 施钾肥 施氮肥*施钾肥 .
UNIANOVA
 生长量  BY 施氮肥 施钾肥
 /METHOD = SSTYPE(3)
 /INTERCEPT = INCLUDE
 /POSTHOC = 施钾肥 ( LSD )
 /CRITERIA = ALPHA(.05)
 /DESIGN = 施氮肥 施钾肥 施氮肥*施钾肥 .
Wed Jun 18 22:09:55 2008 :journaling started
GET
 FILE='D:\学习\空间统计\SPSS数据表\配对样本假设检验.sav'.
T-TEST
 PAIRS= 平均气温  WITH 地温 (PAIRED)
 /CRITERIA=CIN(.95)
 /MISSING=ANALYSIS.
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\Pearson相关分析操作.sav'
 /COMPRESSED.
Thu Jun 19 11:37:43 2008 :journaling started
GET
 FILE='D:\学习\空间统计\SPSS数据表\Pearson相关分析操作.sav'.
CORRELATIONS
 /VARIABLES=x1 x2 x3 x4 x5 x6
 /PRINT=TWOTAIL NOSIG
 /MISSING=PAIRWISE .
CORRELATIONS
 /VARIABLES=x1 x2
 /PRINT=TWOTAIL NOSIG
 /MISSING=PAIRWISE .
NONPAR CORR
 /VARIABLES=x1 x2
 /PRINT=SPEARMAN TWOTAIL NOSIG
 /MISSING=PAIRWISE .
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\Spearman等级相关分析操作.sav'
 /COMPRESSED.
GET
 FILE='D:\学习\空间统计\SPSS数据表\Pearson相关分析操作.sav'.
PARTIAL CORR
 /VARIABLES= x1 x2 BY x3 x4 x5 x6
 /SIGNIFICANCE=TWOTAIL
 /MISSING=LISTWISE .
PARTIAL CORR
 /VARIABLES= x1 x3 BY x4 x5 x6 x2
 /SIGNIFICANCE=TWOTAIL
 /MISSING=LISTWISE .
Fri Jun 20 09:05:21 2008 :journaling started
GET
 FILE='D:\学习\空间统计\SPSS数据表\Pearson相关分析操作.sav'.
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\一元线性回归分析操作.sav'
 /COMPRESSED.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x
 /SCATTERPLOT=(y ,*ZPRED ) .
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\多元线性回归分析操作.sav'
 /COMPRESSED.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x1 x2  .
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\曲线回归的操作.sav'
 /COMPRESSED.
GRAPH
 /SCATTERPLOT(BIVAR)=x WITH y
 /MISSING=LISTWISE .
GRAPH
 /SCATTERPLOT(BIVAR)=x WITH y
 /MISSING=LISTWISE .
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y  WITH x
 /CONSTANT
 /MODEL=LINEAR QUADRATIC CUBIC EXPONENTIAL
 /PLOT FIT.
* Curve Estimation.
PREDICT THRU END.
CURVEFIT /VARIABLES=y
 /CONSTANT
 /MODEL=LINEAR QUADRATIC CUBIC EXPONENTIAL
 /PLOT FIT
 /SAVE=PRED .
* Curve Estimation.
PREDICT THRU END.
CURVEFIT /VARIABLES=y
 /CONSTANT
 /MODEL=QUADRATIC CUBIC EXPONENTIAL
 /PLOT FIT
 /SAVE=PRED .
* Curve Estimation.
CURVEFIT /VARIABLES=y  WITH x
 /CONSTANT
 /MODEL=QUADRATIC CUBIC EXPONENTIAL
 /PLOT FIT
 /SAVE=PRED .
Fri Jun 20 10:00:18 2008 :journaling started
GET
 FILE='D:\学习\空间统计\SPSS数据表\曲线回归的操作.sav'.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y  WITH x
 /CONSTANT
 /MODEL=LINEAR LOGARITHMIC INVERSE QUADRATIC CUBIC COMPOUND POWER S GROWTH
 EXPONENTIAL LGSTIC
 /PLOT FIT.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y
 /CONSTANT
 /MODEL=LINEAR LOGARITHMIC INVERSE QUADRATIC CUBIC COMPOUND POWER S GROWTH
 EXPONENTIAL LGSTIC
 /PLOT FIT.
* Curve Estimation.
PREDICT THRU END.
CURVEFIT /VARIABLES=y
 /CONSTANT
 /MODEL=LINEAR LOGARITHMIC INVERSE QUADRATIC CUBIC COMPOUND POWER S GROWTH
 EXPONENTIAL LGSTIC
 /PLOT FIT
 /SAVE=PRED .
GET
 FILE='D:\学习\空间统计\SPSS数据表\曲线回归的操作.sav'.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y
 /CONSTANT
 /MODEL=LINEAR
 /PLOT FIT.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y
 /CONSTANT
 /MODEL=LINEAR LOGARITHMIC INVERSE QUADRATIC CUBIC COMPOUND POWER S GROWTH
 EXPONENTIAL LGSTIC
 /PRINT ANOVA
 /PLOT FIT.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y  WITH x
 /CONSTANT
 /MODEL=LINEAR LOGARITHMIC INVERSE QUADRATIC CUBIC COMPOUND POWER S GROWTH
 EXPONENTIAL LGSTIC
 /PRINT ANOVA
 /PLOT FIT.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y  WITH x
 /CONSTANT
 /MODEL=LINEAR
 /PRINT ANOVA
 /PLOT FIT.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y
 /CONSTANT
 /MODEL=LINEAR
 /PRINT ANOVA
 /PLOT FIT.
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\趋势面分析操作.sav'
 /COMPRESSED.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT z
 /METHOD=ENTER x y x2 xy y2  .
Wed Jul 09 19:19:09 2008 :journaling started
GET
 FILE='D:\学习\空间统计\SPSS数据表\独立样本假设检验.sav'.
T-TEST
 GROUPS=学校(1 2)
 /MISSING=ANALYSIS
 /VARIABLES=工资
 /CRITERIA=CIN(.95) .
GET
 FILE='D:\学习\空间统计\SPSS数据表\配对样本假设检验.sav'.
T-TEST
 PAIRS= 平均气温  WITH 地温 (PAIRED)
 /CRITERIA=CIN(.95)
 /MISSING=ANALYSIS.
GET
 FILE='D:\学习\空间统计\SPSS数据表\单因素方差分析.sav'.
ONEWAY
 苗高 BY 处理方法
 /STATISTICS DESCRIPTIVES HOMOGENEITY
 /PLOT MEANS
 /MISSING ANALYSIS
 /POSTHOC = LSD ALPHA(.05).
ONEWAY
 苗高 BY 处理方法
 /STATISTICS DESCRIPTIVES HOMOGENEITY
 /PLOT MEANS
 /MISSING ANALYSIS .
ONEWAY
 苗高 BY 处理方法
 /STATISTICS DESCRIPTIVES HOMOGENEITY
 /PLOT MEANS
 /MISSING ANALYSIS
 /POSTHOC = LSD ALPHA(.05).
GET
 FILE='D:\学习\空间统计\SPSS数据表\双因素方差分析.sav'.
UNIANOVA
 生长量  BY 施氮肥 施钾肥
 /METHOD = SSTYPE(3)
 /INTERCEPT = INCLUDE
 /CRITERIA = ALPHA(.05)
 /DESIGN = 施氮肥 施钾肥 施氮肥*施钾肥 .
UNIANOVA
 生长量  BY 施氮肥 施钾肥
 /METHOD = SSTYPE(3)
 /INTERCEPT = INCLUDE
 /POSTHOC = 施钾肥 ( LSD )
 /CRITERIA = ALPHA(.05)
 /DESIGN = 施氮肥 施钾肥 施氮肥*施钾肥 .
GET
 FILE='D:\学习\空间统计\SPSS数据表\Pearson相关分析操作.sav'.
CORRELATIONS
 /VARIABLES=x1 x2 x3 x4 x5 x6
 /PRINT=TWOTAIL NOSIG
 /MISSING=PAIRWISE .
GET
 FILE='D:\学习\空间统计\SPSS数据表\Spearman等级相关分析操作.sav'.
CORRELATIONS
 /VARIABLES=x1 x2
 /PRINT=TWOTAIL NOSIG
 /MISSING=PAIRWISE .
NONPAR CORR
 /VARIABLES=x1 x2
 /PRINT=SPEARMAN TWOTAIL NOSIG
 /MISSING=PAIRWISE .
GET
 FILE='D:\学习\空间统计\SPSS数据表\Pearson相关分析操作.sav'.
PARTIAL CORR
 /VARIABLES= x1 x2 BY x3 x4 x5 x6
 /SIGNIFICANCE=TWOTAIL
 /MISSING=LISTWISE .
GET
 FILE='D:\学习\空间统计\SPSS数据表\一元线性回归分析操作.sav'.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x  .
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x  .
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x
 /SCATTERPLOT=(y ,*ZPRED ) .
GET
 FILE='D:\学习\空间统计\SPSS数据表\多元线性回归分析操作.sav'.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x1 x2  .
GET
 FILE='D:\学习\空间统计\SPSS数据表\曲线回归的操作.sav'.
GET
 FILE='D:\学习\空间统计\SPSS数据表\多元线性回归分析操作.sav'.
GET
 FILE='D:\学习\空间统计\SPSS数据表\多元线性回归分析操作.sav'.
SAVE OUTFILE='D:\学习\空间统计\SPSS数据表\逐步回归操作.sav'
 /COMPRESSED.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.1) POUT(.11)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x1 x2 x3 x4 x5 x6 x7  .
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.10) POUT(.11)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x1 x2 x3 x4 x5 x6 x7  .
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.10) POUT(.11)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=STEPWISE x1 x2 x3 x4 x5 x6 x7  .
GET
 FILE='D:\学习\空间统计\SPSS数据表\多元线性回归分析操作.sav'.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT y
 /METHOD=ENTER x1 x2  .
GET
 FILE='D:\学习\空间统计\SPSS数据表\曲线回归的操作.sav'.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y  WITH x
 /CONSTANT
 /MODEL=LINEAR
 /PLOT FIT.
* Curve Estimation.
TSET NEWVAR=NONE .
CURVEFIT /VARIABLES=y  WITH x
 /CONSTANT
 /MODEL=LINEAR
 /PRINT ANOVA
 /PLOT FIT.
GET
 FILE='D:\学习\空间统计\SPSS数据表\趋势面分析操作.sav'.
REGRESSION
 /MISSING LISTWISE
 /STATISTICS COEFF OUTS R ANOVA
 /CRITERIA=PIN(.05) POUT(.10)
 /NOORIGIN
 /DEPENDENT z
 /METHOD=ENTER y x2 xy y2 x  .