用Excel解決農業研究資料統計分析的方法(一)－敘述統計量

(1)

2005 9 63 33 SAS(Statistical Analysis System)

SPSS(Statistical Package for the Social Sciences) Excel Microsoft Office Excel Excel Excel Excel Excel t F X2 _(CRD RCBD)

Excel

Excel 3 A1:A5 5 ( ) ( ) ( ) (/) (^) (()) =(A1+A2+A3+A4+A5)/5 Exce1 2003 80 (ABS) (SQRT) 04-23302301-125

Excel

(

)

(2)

2005 9 63 34 (COUNT) (FREQUENCY) (SUM) (AVERAGE) (GEOMEAN) (MAX) (MIN) (MEDIAN) ( M O D E ) ( D E V S Q )

(STDEV) (VAR) (KURT)

(SKEW) 5

AVERAGE =AVERAGE(A1:A5)

(standard error of mean, SE or SEM) (coefficient of variation, CV) Excel Excel Excel Microsoft Office ( A ) V ( B) ( C) Excel (descriptive statistics) 8 (cm) (g) ( A ) ( A) (1) A1:B9 ( $A$1:$B$9) (2) (3) ( ) (4)

(3)

2005 9 63 35 (5) (6) k k 95% (7) B Excel Excel ( ) ( , SEM SE) ( ) ( SD) ( ) B ( ) E x c e l #N/A Excel (CV) CV 100 CV ( B) CV =E7/E3 100 (E7, E3 ) =G7/G3 100 (G7, G3 ) CV

CV

SD

SE

CV Excel A. B. C.

A

B

C

(4)

2005 9 63 36 CV ( B) ( C V = 4 4 % ) (CV=28%) CV (CV ) (SD) (SE or SEM) SD standard deviation ( : ; s) SE

standard error of mean ( standard deviation of mean)

(s) ( n ) s/ n SEM SE of mean ( mean ) S_X SD=s SD SEM SD mean SD (mean SD) 1 SD 66% 2 SD 95% 3 SD 99% SEM mean SEM A B 100 2.5 120 1.2 ( ) A B SEM CV CV 2004 Excel 2003 2003 Excel 51(3,4):63-70 Excel A. B.