SOP(用spss检验F值的过程)

一．Excle 数据 先排好序 导入Excel文档 打开SPSS软件，从“文件”→“数据”→文件类型选择“Excle(*.xls...)”,即导入数据了。见下。 注：也可以选择手工输入，或从Excel文档中复制，粘贴过来。 三．计算结果 在SPSS 软件工具栏中， 点“”→“比较均值”→单因素方差分析ANOVA ，选择元素组分到因变量列表，选择样品原号为因子，点“确定”后即得如下结果。 四．转换文档格式 右键，导出为word ，选择好保存路径后，确定即可。 五．数据结果示例 GET DATA /TYPE=XLS /FILE='E:\部公益性项目\均匀性稳定性项目\重排 STANDARD1(原稿数据).xls' /SHEET=name 'Sheet1' /CELLRANGE=full /READNAMES=on /ASSUMEDSTRWIDTH=32767. ONEWAY @59Co @60Ni @65Cu @66Zn @85Rb @88Sr @95Mo @137Ba @182W @208Pb BY V1 /MISSING ANALYSIS. Oneway Notes Output Created 17-三月-2011 08时36分59秒 Comments Input Active Dataset 数据集1 Filter Weight Split File N of Rows in Working Data File 60 Missing Value Handling Definition of Missing User-defined missing values are treated as missing. Cases Used Statistics for each analysis are based on cases with no missing data for any variable in the analysis. Syntax ONEWAY @59Co @60Ni @65Cu @66Zn @85Rb @88Sr @95Mo @137Ba @182W @208Pb BY V1 /MISSING ANALYSIS. Resources Processor Time 0:00:00.016 Elapsed Time 0:00:00.046 [数据集1] ANOVA Sum of Squares df Mean Square F Sig. 59Co Between Groups 111.086 29 3.831 1.047 .450 Within Groups 109.764 30 3.659 Total 220.850 59 60Ni Between Groups 13.050 29 .450 .573 .931 Within Groups 23.565 30 .785 Total 36.615 59 65Cu Between Groups 254.816 29 8.787 .914 .595 Within Groups 288.470 30 9.616 Total 543.286 59 66Zn Between Groups 1247.717 29 43.025 .768 .760 Within Groups 1680.985 30 56.033 Total 2928.702 59 85Rb Between Groups 1114.297 29 38.424 1.816 .055 Within Groups 634.845 30 21.161 Total 1749.142 59 88Sr Between Groups 3.870 29 .133 1.305 .237 Within Groups 3.069 30 .102 Total 6.939 59 95Mo Between Groups .657 29 .023 .773 .754 Within Groups .878 30 .029 Total 1.535 59 137Ba Between Groups 4945.007 29 170.517 .820 .702 Within Groups 6235.615 30 207.854 Total 11180.622 59 182W Between Groups 1.129 29 .039 .779 .748 Within Groups 1.500 30 .050 Total 2.629 59 208Pb Between Groups 1028.607 29 35.469 1.416 .174 Within Groups 751.235 30 25.041 Total 1779.842 59