Grubbs' test for outliers allows checking if the maximum or minimum of a sample is an outlier. It is available in Excel using the XLSTAT software.
Tutorial on how to identify outliers using Grubbs' test and its extensions (i.e. the ESD test) in Excel. Software and examples.
on);set(Excel,Visible,1);Workbooks=Excel.Workbo 126,0127)subplot(2,5,6)plot(X6,Y6,title(subplot 321c3);r4322c3:r5761c3);r5762c3:r7201c3);r72 ?￥°?)r+)01263y?|)subplot(2,5,5)plot(X,Y5,titl Grubbs检验法程序: function[b,idx,outliers]=deleteoutliers(a,alpha,rep); ...
% Computes the critical z value for rejecting outliers (GRUBBS TEST) tcrit = tinv(alpha/(2*n),n-2); zcrit = (n-1)/sqrt(n)*(sqrt(tcrit^2/(n-2+tcrit^2))); 绘图程序之一: Excel = actxserver('Excel.Application'); set(Excel,'Visible', 1); ...
selected and adopted table-by-table elimination method based on Grubbs rule (method one), Excel software elimination method based on Grubbs rule (method two) and automatic cyclic outliers elimination method based on Grubbs rule and MATLAB language (method three) to judge and eliminate the outliers...
Five researchers were selected and adoptedtable-by-table elimination method based on Grubbs rule(method one),Excel software elimination method based onGrubbs rule (method two) and automatic cyclic outlierselimination method based on Grubbs rule and MATLABΔ 基金项目:国家自然科学基金资助项目(No.81774452...
以上述试验所得的苦度评价数据(口尝试验为苦度值,电子舌测试为传感器响应值)为数据源,选择5名研究者,采用基于Grubbs规则的查表逐一剔除法(方法一)、基于Grubbs规则的Excel软件剔除法(方法二)、基于Grubbs规则和MATLAB语言的异常值自动循环剔除法(方法三)进行异常值的判定及剔除;以异常值剔除时间和错误概率为指标,...
数据源异常值的剔除情况 ( 方法三) Fig 5 Elimination of outliers in data source of elec- tronic tongue test bitterness evaluation(me- thod three) Grubbs 规则和 MATLAB 语言的异常值自动循环剔除 法;以剔除时间和错误概率为指标,对上述方法与基于 Grubbs 规则的查表逐一剔除法和 Excel 软件剔除法的应 用...