Column 列
Set as X 设为X ..................................................................................................................... 72 Set as Label 设为标记符号 ................................................................................................... 72 Disregard Column 忽略此列 ................................................................................................. 73 Set as Y Error 设为Y的误差 ............................................................................................... 73 Set as Categorical 设为分类数据 .......................................................................................... 73 Setting Column Values 设定列数值 ...................................................................................... 74 Fill Column with 填充列 ....................................................................................................... 74 Add New Columns 添加新列 ................................................................................................ 75 Set Sampling Interval 设置采样间隔 .................................................................................... 76 Move Columns 移动列 .......................................................................................................... 76 Show X Column 显示X列 ................................................................................................... 77 Slide Show of Dependent Graphs 幻灯放映 ......................................................................... 77 Swap Columns 交换列 .......................................................................................................... 77 Add Sparklines 添加拆线图 .................................................................................................. 79
Worksheet 工作表
Sort Range 排序范围 ............................................................................................................. 80 Sort Columns列排序 .............................................................................................................. 81 Sort Worksheet 工作表排序 .................................................................................................. 81 Clear Worksheet 清除工作表 ................................................................................................ 81 Worksheet Script 工作表脚本 ............................................................................................... 81 Worksheet Query 工作表查询 ............................................................................................... 82 Reset Column Short Names 重置列短名 .............................................................................. 83 Split Worksheet 拆分工作表 ................................................................................................. 84 Split Workbooks 拆分工作簿 ................................................................................................ 84 Pivot Table 数据透视表....................................................................................................... 84 Stack Column 堆列 ................................................................................................................ 85 Unstack Column 拆堆列 ........................................................................................................ 87 Remove Duplicated rows 删除重复行 .................................................................................. 87 Reduce Rows 减少行 ............................................................................................................. 88 Transpose 转置 ...................................................................................................................... 89 Convert to XYZ 转换为XYZ ............................................................................................... 90 Convert to Matrix转换为矩阵 ............................................................................................... 93
Analysis 分析
Mathematics 数学运算 .......................................................................................................... 97 Interpolate/Extrapolate Y from X 由X内插/外推求Y .............................................. 98
Trace Interpolate 迹线外推 ........................................................................................... 98 Interpolate/Extrapolate 内插/外推 ................................................................................. 99 3D Interpolation 三维内插 .......................................................................................... 100 XYZ Trace Interpolation XYZ 迹线内插 .................................................................... 101 XYZ Surface Area XYZ表面积 ................................................................................... 102
Set Column Values 设置列值 .................................................................................... 102 Normalize Column. 归一化列 ..................................................................................... 102
Simple Math 简单数学运算 ........................................................................................ 103 Differetiate 微分 .......................................................................................................... 104 Integrate 积分 .............................................................................................................. 105 Polygon Area 多边形面积 ........................................................................................... 105 Average Multiple Curves 多曲线平均......................................................................... 106
Data Manipulation 数据处理 ............................................................................................... 106 Subtract Reference Data 与参考值相减 ...................................................................... 107 Reduce Duplicate X data 归纳重复的X数据 ............................................................ 108 Reduce by Group 按组归纳 ......................................................................................... 108 Reduce to Evenly Spaced X 归纳为均匀间隔的X .................................................... 110
Fitting 拟合 .......................................................................................................................... 111 Linear Fit 线性拟合 ..................................................................................................... 112
Fit Linear with X Error 带X误差的线性拟合 ........................................................... 114 Polynomial Fit 多项式拟合 ......................................................................................... 115 Multiple Linear Regression所谓多元线性回归 .......................................................... 115 Nonlinear Curve Fit 非线性曲线拟合 ......................................................................... 117 Nonlinear Surface Fit 非线性表面拟合 ...................................................................... 118 Simulate Curve 模拟曲线 ............................................................................................ 118
Simulate Surface 模拟表面 ......................................................................................... Exponential Fit 指数拟合 ............................................................................................ Sigmoidal Fit 反曲拟合 ............................................................................................... Compare Datasets 比较数据集 .................................................................................... Compare Models 比较模型 ......................................................................................... 123 Signal Processing 信号处理 ................................................................................................ Smooth 平滑 ................................................................................................................ 125 FFT Filters FFT滤波 .................................................................................................... FFT ................................................................................................................................ 127 Wavelet 小波分析 ........................................................................................................ Convolution 卷积 ......................................................................................................... Deconvolution 反卷积 ................................................................................................. Coherence 相干性 ........................................................................................................ Correlation 相关性 ...................................................................................................... 135 Hibert Transform希尔伯特变换 .................................................................................. Envelope 包络线 .......................................................................................................... Decimation 抽取 .......................................................................................................... 136 Peaks and Baseline 峰和基线 .............................................................................................. Multiple Peak Fit 多重峰拟合 ..................................................................................... 138 Single Peak Fit 单峰拟合 ............................................................................................ 141 Peak Analyzer 峰分析器.............................................................................................. 141 Batch Peak Analysis Using Theme 使用主题批量分析.............................................. 147
119 121 122 122 125 126 129 132 133 134 135 136 137
Statistics 统计分析
Descriptive Statistics 描述统计 ........................................................................................... 149 Correlations Coefficient 相关系数 .............................................................................. 149 Statistics on Columns 列统计 ...................................................................................... 151 Statistics on Rows 和统计 ........................................................................................... 152
Discrete Frequency 离散频率 ...................................................................................... 154 Frequency Counts 频率计数 ........................................................................................ 155 Normality Test 正态性检验 ......................................................................................... 157
2D Frequency Counts/Binning 二维频率计数/分区 ................................................... 159 Hypothesis Testing 假设检验 .............................................................................................. 160 One-Sample t-Test 单样本 t-检验 .............................................................................. 161 Pair-Sample t-Test 配对样本t-检验 ............................................................................ 162 Two-Sample t-Test 双样本t-检验 ............................................................................... 164 One-Sample Test for Variances 单样本方差检验 ....................................................... 167 Two-Sample Test for Variances 双样本方差检验 ....................................................... 169 ANOVA 方差分析 ............................................................................................................... 170 One-Way ANOVA 单因素方差分析 ........................................................................... 170 Two-Way ANOVA 双因素方差分析 ........................................................................... 172 One-Way Repeated Measures ANOVA 单因素重复测量方差分析 ........................... 174 Two-Way Repeated Measures ANOVA 双因素重复测量方差分析 ........................... 176 NonParametric Tests 非参数检验 ....................................................................................... 178 One-Sample Wilcoxon Signed Rank Test单样本Wilcoxon符号秩检验 ................... 179 Paired Sample Sign Test 配对样本符号检验 .............................................................. 180
Paired Sample Wilcoxon Signed Rank Test配对样本Wilcoxon符号秩检验 ............ 181 Two-Sample Kolmogorov-Smirnov Test 双样本KS检验 ......................................... 183 Mann-Whitney Test Mann-Whitney检验 .................................................................... 185 Kruskal-Wallis ANOVAKruskal-Wallis方差分析 ....................................................... 187
Moods Median Test 中位数检验 ................................................................................. 188