Eddy

1
DOE EXCEL, SPSS application

• ???
• Eddy

2
????

• ?????,????
• ?????????????????
• ???????????????
• ?????Excel ,SPSS????????
• ??????????????

3
????

• 1.?????????,????,???????,2008
• 2.Excel 2007 ?????????,?????,???????,2008
• 3. ?????SPSS??,????,???????,2006
• 4??????????(?2?)????,???????,2006?
• 5??????SPSS???,????,?????????,2001?
• 6?SPSS??????,??????,???????,2003?

4
SPSS????????

• 1.  SPSS??   http//www.spss.com 2.  SPSS????
• http//www.spssgz.com.cn    
   http//www.spss.com.cn  
• 4.  SPSS FOR WINDOWS??????    http//www.fjmu.edu
  .cn/news/spss/doc3/index.htm   (??????????,?????) 
  
• 5.  SPSS for Windows 10.0???http//www.medstatstar
  .myetang.com/spss/coach.htm (???????? ????? )

5
??????

• ???(statistics)???????,????????????????????????

6
????

• SPSS??????????????????,????,????,???????????????
  ?????
• SAS?????????????????,???????????????????????????
  ????????????,??????????????????????????????
• STATA ??????????????????????????,???????????????
  ?????????????????????????????????,????,???????????
  ??????,???????????
• ?????????????????????

7
????

• Excel????????????,?????????,?????????????????Micr
  osoft Office????,??????Excel?????,????Office??????
  ?????,???????????,????????????????,Excel????,?????
  ???,Excel??????,??????,?????????????????????????
  ?????????????????

8
????

• S-plus?????????????????????,????????????,????????
  ????????????????????????????????????????????????
  
• R?????????,????????????????S-plus????S????,??????
  ??????????????????????????????????????????????????
  ?????,???????????????????????????????????????,????
  ????????

9
????

• Minitab????????????????????,??????,???????SPSS?
  SAS?????
• Statistica????????????????,????????SAS?SPSS????
  ?
• Eviews???????????????????
• GAUSS????????????,???????????????????????????????
  ??
• FORTRAN????????????????????????,????,????????????
  ???????????????????????????????
• MATLAB???????????????????,??????????????S?R??????
  ????

10
????
11
SPSS??
12
SPSS??
SPSS?Statistical Program for Social Sciences
???,?????????,???SPSS??1970????,?????30???????????
????????????(SAS?SPSS?Statis)?????????SPSS for
Windows 13.0??
????????,?????????,?????????????????????????
?? ????,????(SAS???)?excel???????????
13
SPSS????????
1 SPSS?3????? 1-1 ???????(SPSS Data
Editor)????????????????????. sav? 1-2
?????????( SPSS Syntax Editor)??????????????????
?. sps? 1-3 ??????( SPSS Viewer)???????????????
????. spo?
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
2 SPSS ?????????? 2-1 File ??????
NewOpenSaveSave asExit? 2-2 Edit ????
UndoCutCopyPasteClear Find 2-3 View????
FontsGrid linesValue labels?
18
2-4 Data?????? define variablesInsert
variablesInsert case go to casesort
caseselect case? 2-5 Transform?????? recodecom
putecount? 2-6 Analyze???? 2-7
Graphs????? 2-8 Utilities?????? 2-9
Windows???? 2-10 Help????
19
???

• 1?File??????,?????????????????
• 2?Edit????,??????????????????????
• 3?View??
• 4?Data??????,????????????????????????????????????
  ????????
• 5?Transform????????,???????????????????
• 6?Analyze????,????????????
• 7?Graphs????,??????????
• 8?Utilities??????,?????????????????????????????
• 9?Windows??????,??????????????
• 10?Help????,?????????????????

20
??????SPSS????
???
???
???
???
????????????????????????
21
????? (SPSS Viewer)
?????(Data Editor)
SPSS ??
Text
22
?????(Data Editor)

• Data Editor?????

Data View???????????????????????????
?????
?????
Variable View?????????????????
??????????????????Data View?Variable
View???,??????????????
23

• ???????(Data View??)
• ??????????????,?????????????????,???????????????
• ???????????,?????????,???????????,?????????,??????
  ?????

24

• ????????(Variable View??)
• ?Variable View???,??????????????????????????????
  ?????????(???????????????????)?
• ???SPSS???,?????????????,??????????????

25

26
???????????

• Name ???
• Type ????
• Width ????
• Decimals ???
• Label ????
• Values ?????
• Missing ???
• Columns ??????
• Align ??????

27

• ???????Name???????,????????????????????
• ????????Type?,??????,??????,???????????????????
  ?????????????????????????????????????Numeric?
• ???????????Decimal,??????????

28

• ????
• ???????8???
• ??????????
• ????????,-,,/????????????
• ??????????????????,??????
• W02 8 W03 9 W04 10.??? W02 to W04 8-10.
• ????????,?????(a)?
• W7 12(a)
• ?????????,?????(n),n?????????446.79,???????
• 44679,????W12 12-16(2)

29
????
??DOS?WPS?CCED???,?ASCII??????????(.dat.txt)???
????????,????????,???????????,???????????????
??SPSS?????(SPSS Data Editor)????????????,????????
?,?????,??????????
30
??SPSS????????
????????
??Analyze????
?????????
?SPSS Viewer?
31
?SPSS?,??????????????????Data?Transform??????,????
????????
Data???
Transform???
32
?????

• ????? FilegtOpengtData/output
• ???????????,insert?cut?clear?copy
• ?????,Sort?????
• ?????,Go to Case?Find
• ?????,Copy?paste
• ?????,???????????????recode?????
• ?????,Compute
• ?????????,Ranks-Mean
• ????? ,Select cases(??) ?split(??) sex
• ????? ,add?Merge
• ???????(?2 ?? )?????,?Weight
• ???????, ????excel???
• ?????????? ??Frequencies?Explore?

33
SPSS Analyze????????

• ???????--Descriptive Statistics??
• ??????--Compare Means??
• ????????General Linear Model??
• ??????Correlate??
• ????????????? Regression??
• ??????Loglinear??
• ?????????Classify??
• ?????????Data Reduction??
• ???????????Scale??
• ???????Nonparametric Tests??
• Survival??

34
????????
??????

• ????
• ?????
• ????? ?SPSS??

????
35
???????????
1
2
3
4
??????,??????,???,???
????????
??????
??????
36
??????????????
????
?
37
????????? ??????SPSS??
????,??????????
38
????????????
?1 ??????????????????,????????????(A)?????(B)????
(C)?????????,???????1,????2
?1
?? ?? 1 2 3
????(A)
????(B)
???(C)
39
?2 ??????
??? ?? ?? ?? ?? ???()
??? A B C D(??) ???()
1 1 1 1 1 31
2 1 2 2 2 54
3 1 3 3 3 38
4 2 1 2 3 53
5 2 2 3 1 49
6 2 3 1 2 42
7 3 1 3 2 57
8 3 2 1 3 62
9 3 3 2 1 64
40

• SPSS??????
• Step1??2????SPSS???????,????Analyze?General
  Linear Model ?Univariate,?????Univariate??????
• Step2????????????Dependent Variable
  (?????),a?b?c????Fixed Factor(s)(???),d????,??
  ???????
• Step3???Model ???,??? Univariate
  Model??????????????Custom(?????),???a?b?c????Mo
  del?,??Continue?????? Univariate??????
• Step3???Post Hoc ????Post Hoc Multiple
  Comparisons for ????,???a?b?c????Post Hoc
  Tests for?,??Duncan,???Continue????
  Univariate??????
• Step4???OK????

41
?????,??A?B?C??3???,?????????
42
?????,??A,F34.333B,F6.333C,F13.000????
A???Sig.???0.05,B?C?Sig.????0.05,??A???????
?????,?B???C???????????????
43
??Duncan???????? ?,A????????Level-1?Level-2?????
Level-1, Level-2?Level-3?????????????sig.
44
??Duncan???????? ?,B?????????????,???????????
45
??Duncan???????? ?,C????????
46

• ??????
• ?????????A3B2C2,??B??????????????,??????????
  ,?????????????????????????????

47
????????????

• ?2 ??????????,???????3??????(A)???(D),??????(B)???
  ????(C)4?????????????,?????3???,??L9(34)
  ???????,??2???????????????????3??,????????????

????????
48
?3 ??????????
??? ?? ?? ?? ?? ???? ????
??? A(????) B(????) C(????) D(????) ???? ????
??? A(????) B(????) C(????) D(????) ? ?
1 1 1 1 1 78.9 78.1
2 1 2 2 2 77.0 77.0
3 1 3 3 3 77.5 78.5
4 2 1 2 3 80.1 80.9
5 2 2 3 1 77.6 78.4
6 2 3 1 2 78 79
7 3 1 3 2 76.7 76.3
8 3 2 1 3 81.3 82.7
9 3 3 2 1 79.5 78.5
49

• SPSS??????
• Step1??2????SPSS???????,????Analyze?General
  Linear Model ?Univariate,?????Univariate??????
• Step2???????????Dependent Variable
  (?????),??????????????????????Fixed
  Factor(s)(????
• Step3???Model ???,??? Univariate
  Model??????????????Custom(?????),???????????
  ?????????????Model?,??Continue??????
  Univariate??????
• Step3???Post Hoc ????Post Hoc Multiple
  Comparisons for ????,????????????????????
  ?????Post Hoc Tests for?,??Duncan,???Continue
  ???? Univariate??????
• Step4???OK????

50
?????,??????????????????????3???,?????2???
,????????????6??
51
?????,?????????????????Sig.????0.05,?????S
ig.???0.05,????????????????????????????,???
?????????????????
52
??Duncan?????????,????????????
53
??Duncan?????????,??????????????????
54
??Duncan?????????,????????????
55
??Duncan?????????,????????????
56

• ??????
• ?????????A3C1D3,????????????????????,???????
  ???,?????????????????????????????

57
???????????????
???????????????????????,??????Step2?Step3,
?Step2??????????????????Fixed Factor (s)??,
?Step3????????????????????Model??
??????,??spss???,????????,?????????????.??????????
?Fixed Factor ??????????,???????????????????,????
??????????,??????.
??????????Data---orthogonal design.
58

• Thank you