线性分析数据表1

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.995000,0.950000

,线性分析数据表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.002500,0.025000

,样本号,1,2,3,4,5,,结论：,该系统不可接受，因为偏倚=0线不在置信区间内！,,,,,,,,,,,,,,,,1,2.00,0.70,,,,,,

,参考值,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,2,2.00,0.50,,,,2,14.089047,4.302653

,测量值,2.70,5.10,5.80,7.60,9.10,,注：图表和计算仅针对5个参考值和12次试验进行设置，仅当数据录入区域(C4:G16)全部输入后方可进行评价。,,,,,,,,,,,,,,,,,3,2.00,0.40,,,,3,7.453319,3.182446

,,2.50,3.90,5.70,7.70,9.30,,,,,,,,,,,,,,,,,,,4,2.00,0.50,,,,4,5.597568,2.776445

,,2.40,4.20,5.90,7.80,9.50,,Sumy*y,11.8200,"""=totalsumofsquares(uncorrected)",,,,,,g=,5,,,,,,,,5,2.00,0.70,,,,5,4.773341,2.570582

,,2.50,5.00,5.90,7.70,9.30,,Sumy,-3.2000,,,,,,,m=,12,,,,,,,,6,2.00,0.30,,,,6,4.316827,2.446912

,,2.70,3.80,6.00,7.80,9.40,,Sumxy,-82.4000,,,,,,,gm,60,,,,,,,,7,2.00,0.50,,,,7,4.029337,2.364624

,,2.30,3.90,6.10,7.80,9.50,,Sumx,360.0000,,,,,,,gm-2,58,,,,,,,,8,2.00,0.50,,,,8,3.832519,2.306004

,,2.50,3.90,6.00,7.80,9.50,,Sumx**2,2640.0000,,,TotalSScorrected,,11.6493,,1/gm,0.0167,,,,,,,,9,2.00,0.40,,,,9,3.689662,2.262157

,,2.50,3.90,6.10,7.70,9.50,,,,,,SSregr,,8.3213,,risk,0.050,,,,,,,,10,2.00,0.40,,,,10,3.581406,2.228139

,,2.40,3.90,6.40,7.80,9.60,,slope-num,-63.20000,,,,,,,confidence,0.950,twotails,,,,,,,11,2.00,0.60,,,,11,3.496614,2.200985

,,2.40,4.00,6.30,7.50,9.20,,slope-denom,480.00000,,,R-squared,,0.7143,,1-risk/2,0.975,onetail,,,,,,,12,4.00,0.40,,,,12,3.428444,2.178813

,,2.60,4.10,6.00,7.60,9.30,,slope=a,-0.1317,,,,,,,,,,,,,,,,1,4.00,1.10,,,,13,3.372468,2.160369

,,2.40,3.80,6.10,7.70,9.40,,intercept=b,0.73667,,,,,,,,,,,,,,,,2,4.00,-0.10,,,,14,3.325696,2.144787

,平均值,2.4917,4.1250,6.0250,7.7083,9.3833,,,,,,,,,,,,,,,,,,,3,4.00,0.20,,,,15,3.286039,2.131450

,偏差值,0.700,1.100,-0.200,-0.400,-0.900,,,,,,,,residual,,,,,,,,,,,4,4.00,1.00,,,,16,3.251993,2.119905

,,0.500,-0.100,-0.300,-0.300,-0.700,,s,0.2395,,11.8200,2.357,-10.849,3.328,,,,,,,,,,,5,4.00,-0.20,,,,17,3.222450,2.109816

,,0.400,0.200,-0.100,-0.200,-0.500,,,,,,,,,,,,,,,,,,,6,4.00,-0.10,,,,18,3.196574,2.100922

,,0.500,1.000,-0.100,-0.300,-0.700,,,,,,,,,,,,,,,,,,,7,4.00,-0.10,,,,19,3.173725,2.093024

,,0.700,-0.200,0.000,-0.200,-0.600,,,,,,,,tvalue,2.0017,,,,,,,,,,8,4.00,-0.10,,,,20,3.153401,2.085963

,,0.300,-0.100,0.100,-0.200,-0.500,,,,,,,,,,,,,,,,,,,9,4.00,-0.10,,,,21,3.135206,2.079614

,,0.500,-0.100,0.000,-0.200,-0.500,,,,,,,,,,,,,,,,,,,10,4.00,0.00,,,,22,3.118824,2.073873

,,0.500,-0.100,0.100,-0.300,-0.500,,Refvalue=x0,x0-xbar,(x0-xbar)2,ratio,sum,sqrt,cbv,cbl,line,cbu,Bias=0,N=,4,,,,,11,4.00,0.10,,,,23,3.103997,2.068658

,,0.400,-0.100,0.400,-0.200,-0.400,,2,-4,16.00,0.0333,0.0500,0.2236,0.1072,0.3661,0.47333,0.5806,0,N,,,,,,12,4.00,-0.20,,,,24,3.090514,2.063899

,,0.400,0.000,0.300,-0.500,-0.800,,4,-2,4.00,0.0083,0.0250,0.1581,0.0758,0.1342,0.21000,0.2858,0,N,,,,,,1,6.00,-0.20,,,,25,3.078199,2.059539

,,0.600,0.100,0.000,-0.400,-0.700,,6,0,0.00,0.0000,0.0167,0.1291,0.0619,-0.1152,-0.05333,0.0086,0,,,,,,,2,6.00,-0.30,,,,26,3.066909,2.055529

,,0.400,-0.200,0.100,-0.300,-0.600,,8,2,4.00,0.0083,0.0250,0.1581,0.0758,-0.3925,-0.31667,-0.2409,0,,N,,,,,3,6.00,-0.10,,,,27,3.056520,2.051831

,平均偏倚,0.4917,0.1250,0.0250,-0.2917,-0.6167,,10,4,16.00,0.0333,0.0500,0.2236,0.1072,-0.6872,-0.58000,-0.4728,0,,N,,,,,4,6.00,-0.10,,,,28,3.046929,2.048407

,参考值均值,6.000,平均偏倚均值,,-0.0533,,,,,,,,,,,,,,,,,,,,5,6.00,0.00,,,,29,3.038047,2.045230

,,,,,,,,,sumsq-all,480,,,,,,,,,,,,,,,6,6.00,0.10,,,,30,3.029798,2.042272

,,,,,,,,,,,,,,,,,,,,,,,,,7,6.00,0.00,,,,35,2.996047,2.030108

,1,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,8,6.00,0.10,,,,40,2.971171,2.021075

,2,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,9,6.00,0.40,,,,45,2.952079,2.014103

,3,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,10,6.00,0.30,,,,50,2.936964,2.008559

,4,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,11,6.00,0.00,,,,60,2.914553,2.000298

,5,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,12,6.00,0.10,,,,70,2.898734,1.994437

,6,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,1,8.00,-0.40,,,,80,2.886972,1.990063

,7,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,2,8.00,-0.30,,,,90,2.877884,1.986675

,8,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,3,8.00,-0.20,,,,100,2.870652,1.983972

,9,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,4,8.00,-0.30,,,,150,2.849152,1.975905

,10,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,5,8.00,-0.20,,,,200,2.838514,1.971896

,11,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,6,8.00,-0.20,,,,,,

,12,2.0,4.0,6.0,8.0,10.0,,,,,,,,,,,,,,,,,,,7,8.00,-0.20,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,8,8.00,-0.30,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,9,8.00,-0.20,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,10,8.00,-0.50,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,11,8.00,-0.40,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,12,8.00,-0.30,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,1,10.00,-0.90,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,2,10.00,-0.70,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,3,10.00,-0.50,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,4,10.00,-0.70,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,5,10.00,-0.60,,,,,,

,,,,,,,,,Numericallythiscanbeanalyzedbylookingattheslopeandintercept,,,,,,,,,,,,,,,,6,10.00,-0.50,,,,,,

,,,,,,,,,从数值上看，这可以通过观察斜率和截距来分析,,,,,,,,,,,,,,,,7,10.00,-0.50,,,,,,

,,,,,,,,,Analysisofslope斜率分析:,,,,,,,,,,,,,,,,8,10.00,-0.50,,,,,,

,,,,,,,,,denom,0.0109,,,,,,,,,,,,,,,9,10.00,-0.40,,,,,,

,,,,,,,,,t-calc,12.0426,<--comparethisvaluetothetabledt-value;ift-calcislessthanthetabledvaluethentheslopeiszero,,,,,,,,,,,,,,10,10.00,-0.80,,,,,,

,,,,,,,,,,,Ifslope=0continueotherwiselinearityisunacceptable,,,,,,,,,,,,,,11,10.00,-0.70,,,,,,

,,,,,,,,,Analysisoftheintercept截距分析,,,,,,,,,,,,,,,,12,10.00,-0.60,,,,,,

,,,,,,,,,ratio,0.0750,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,sum,0.0917,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,sqrt,0.3028,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,denom,0.0725,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,t-calc,10.1575,<--comparethisvaluetothetabledt-value;ift-calcislessthanthetabledvaluethentheinterceptiszero,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,Iftheslopeandinterceptarebothnotdifferentfromzerothenthelinearityisacceptable(I.e.bias=zerooverthesystem'srange),,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,如果斜率和截距均与0相同，则线性度是可接受的（即系统范围内的偏倚=0）,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,Uncertainty,ifbias=0,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,不确定度,fromexternallab来自外部实验室,,0.5000,(informationenteredbytheuser用户输入信息),,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,ofbiascalc=s偏差计算值=s,,0.2395,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,totalvariance总方差,,0.7395,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,TotalUncertainty(95%)总不确定度,,1.7199,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,Uncertainty,ifbias<>0,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,不确定度,biaseffect偏倚效应,,0.0028,,,,,