Excel??????

1
?????
Excel????? ???????
?????????? ???
2
???????
??13851528207 ??57713643(Home) E-mail
gggyyyhhh_at_hotmail.com ?
gyhstudent_at_126.com ?????http//www.njcdtjx.com/
3
Excel??????
??????????
??Excel ????? ??Excel ????? ????????
4
????????
Office XP ?? Word  Excel  PowerPoint  Access Outlo
ok FrontPage
??????? SAS SPSS Statistics Package for Social
Science Statistical Product Service
Solutions ??????????? STATISTICA / STATA/ SYSTAT
????? Share Point Team Services
5
??????
SAS??? SAS SPSS?? SPSS StatSoft?? S
TATISTICA
6
SAS??
??http//www.sas.com/
7
SPSS??
??http//www.spss.com/
8
StatSoft??
??http//www.statsoft.com/
9
SAS
SAS?????Statistics Analysis System,???????????????
????????,??1976????SAS?????,?????SAS???SAS????????
?????????,????????????????????
SAS??????9.0?,????1G?
10
SAS
SAS????120??????,???????????,?????????????????????
??????????????,?????SAS???????????????????????????
?????????,SAS???????????????,????????????
11
SAS
SAS???????????,????????BASE
SAS??,????????????,?????????,?????????,????SAS????
??SAS?????????????????????,????? SAS/STAT(??????
) SAS/GRAPH(????) SAS/QC(??????) SAS/ETS(?????
?????????) SAS/OR(?????) SAS/IML(?????????????)
12
SPSS
SPSS?????????????????Statistical Package for
the Social Sciences,???????????
SPSS???2000???????????Statistical Product and
Service Solutions,?????????????,???SPSS?????????
??
13
SPSS
SPSS????????? ??SPSS Base?????? ??????Adv
anced Models??Regression Models?
?Tables??Trends?
?Categories? ?Conjoint?
?Exact Tests??Missing Value Analysis??Maps?
14
SPSS
SPSS????????????????,????????(???????),???????????
???????????,?????????????,???????Windows????,?????
???,???????????????????????????????????
15
SPSS

• ????
• ????1999??200????????70?
• NASDAQ???????22?
• RealWare 1999???????????
• DM Review 1999???????14?
• Softletter 2000?100??16?
• 1999????????100??23?
• ???????500??97?

16
STATISTICA
StatSoft ??1984????????????????,??????????
??????????????1993????Windows???STATISTICA????????
??????????????? ?????STATISTICA  6.0??????????????
 
17
STATISTICA
STATISTICA????????????  ?????????/????????????????
??????   ???? STATISTICA?????6????? ??????????????
? STATISTICA?????? ???????????????????????????????
? SPC??
18
Excel ?????
???????????,???????????,???????????????
??????????????????????????????????????????
19
??????
?????? 1. ???????????? ??? ???? 2.
?????????????? ?????? 1. ??????????????? 2.
????????? 3. ??????
20
Excel ?????
???Excel????????,???????????????,???????????
?????Excel???435????????????????????????????? SU
M(A1A5,C1C3)
21
??????
1. ????????? 2. ????? 3. ???? ??????
22
?????
????????????? ???? ???? ????
23
????????????
????????????????????????????????????????????
????????????????,?????????,???????????????????????
???,??????????
24
?????
????????????????????????????????AVERAGE??,??
? AVERAGE(NUMBER1,NUMBER2,) NUMBER????????,????
??????????
25
?????
????? (???????)????????????????????,????????
???????????????,??????????????????????HARMEAN??,??
? HARMEAN(NUMBER1,NUMBER2,)
26
?????
????? ?N???????,??N???,???????????????????
????,?????????????????????????????????????GEOMEAN?
?,??? GEOMEAN(NUMBER1,NUMBER2,)
27
???
???????????????????????????????,????????????
?,????????,????????? ???????MEDIAN??,??? MEDIAN(N
UMBER1,NUMBER2,)
28
??
?????????????????????? ??????MODE??,??? M
ODE(NUMBER1,NUMBER2,)
29
????????????
???????????????(??????)?????????????(??)?????
??????????????,?????????,??????????????????,??????
???????????,???????????????????????????
30
??
??(????)??????????,?MAX(ARRAY)MIN(ARRAY)??
?ARRAY???????????,???????????????????????????,????
??????????????,?????????????
31
???
??????????????????????????? ???????AVEDEV??,
???AVEDEV(NUMBER1,NUMBER2,) NUMBER????????,???
??????????? ?AVEDEV(4, 5, 6, 7, 5, 4, 3)
1.020408
32
???
????????????????????????????????,??STDEV??,
??STDEVP??????????????,?????????????? ??? STDEV
(NUMBER1,NUMBER2,) STDEVP(NUMBER1,NUMBER2,)
33
??
?????????,????????????????????????,????????
??,?????????????? VAR (NUMBER1,NUMBER2,) VARP(N
UMBER1,NUMBER2,)?
34
????????????
?????????????????? ??? ??
35
???
????????????????????? ? ???????SKEW??,???
SKEW(NUMBER1,NUMBER2,) NUMBER????????,??????????
??????????????????????????????????????????
36
??
???????????????????????? ??????KURT??,???K
URT(NUMBER1,NUMBER2,) NUMBER????????,???????????
???????????????????????????????
37
??????
??????110??????????(????)????,??????????
38
????
?????????? ????????(??????) ???????? ????? ??
?????????? ?????????????
39
????
???????????????????????????????????????????
?????????????????????????????????????????,????????
???????????
40
????
?????????FREQENCY??,???FREQUENCY(ARRAY,
BINS) FREQENCY??????????ARRAY???????????,BINS????
?????????????? ???FREQENCY???????????,??????
?,??????????,???????????,
41
????
???? FREQUENCY????????,?????????????????,????????9
0,????????90?,??90??????,?????????????,???????
?????90???Excel???????????????,???????,???????????
???
42
???????????
???? ?????????(MDETERM) ??????(MMULT) ??????(TR
ANSPOSE) ?????(MINVERSE)
?????? ???????? ???????? ?????????????
43
??????
??????????(??)??,???19???????????
??????????????????????????????????,??????????
44
??????
???????????,????????????????,?????????
??????????????????,????????,??????????????
?????? - VBA???????????????,????Excel?,??????
???????
45
??????
1??????? 2????? 3????? 4????? (???????)
46
?????
???????????? ?????????????????????? ???????????
???????????? ??????????
???????????? ??????
47
??????
????????????????????????????????????????,?
??????????????????
48
??????
?????????????????????????
?????????????????????????10?? ??????????????????
??????????????? ????????????????????3???
49
????
1.???????????? 2.??????? 3.??????? 4. ??
???????? 5. ?? ????????
50
???????
??????????????????????????,???????????????
????????????????????????????
?????????????????
?? ?? ?? ??? ??
1 26.5 31.2 27.9 30.8
2 28.7 28.3 25.1 29.6
3 25.1 30.8 28.5 32.4
4 29.1 27.9 24.2 31.7
5 27.2 29.6 26.5 32.8
51
???????
??????????????,????????????? ?????????,?????? (1)
??????????????????? ??????????????????
? ??????????????,??????,??MSA? (2)???????????
?????????? ???????????????????????
??????????????,??????,??MSE?
52
?????
53
????
??????
?????????????
????
??????
???? ????t ??????x
54
???????????
m??????t ??? (????????????)
?????????????????????? ????????????????F??? ???
?????????????D-W?
55
?????