Weibull-Analysis-In-Excel

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Sheet1
	Weibull Analysis In Excel							Refer to The New Weibull Handbook, 5th edition, by Dr. Robert B. Abernethy for nomenclature
					Data To Use For Excel Regression			Also refer to International Standard IEC 61649 Edition 2.0 2008-08 for the same nomeclature as The New Weibull Handbook
	The Facts For A Weibull Plot
	i-values	X-age to failure sorted	Y-plot position		Use This Date For X-axis	Use This Date For Y-axis
	1	45	0.109375	10.9375	-2.1556160061	3.8066624898		A Weibull function is provided in Excel for the CDF and PDF values
	2	60	0.265625	26.5625	-1.1752704151	4.0943445622		Weibull(x,alpha,beta,true) <--provides the cumulative distribution function, CDF, at the value of x
	3	74	0.421875	42.1875	-0.6015435511	4.3040650932		Weibull(x,alpha,beta,false) <--provides the probablity density function, PDF, at the value for x
	4	41	0.578125	57.8125	-0.147287035	3.7135720667		note x must be greater than zero
	5	99	0.734375	73.4375	0.2819177954	4.5951198501		note alpha in Excel is the Weibull slope b
	6	129	0.890625	89.0625	0.7943368307	4.8598124044		note beta in Excel is the Weibull characteristic value h
				Excel Regression Stats				The Weibull function in Excel will not take a data set and return the b and h values!
				b=	3.298		0.6321205588	<--Using the Excel Weibull function for X-age to failure @ 92.672 we get the expected CDF
	45	10.9375		h=	79.894		0.0151868568	<--Using the Excel Weibull function for X-age to failure @ 92.672 we get the expected PDF
	60	26.5625		R2 =	0.5166			The Weibull CDF = 1-exp(-(x/h)^(1/b))					Weibull reliability R = 1-CDF
	74	42.1875						The Weibull PDF = (b/(h^b))*(x^(b-1))*exp(-1*(x/h)^b)					Instanteous failure rate = H(t)=(b/h)*(x/h)^(b-1)
	41	57.8125		SuperSMITH Weibull Stats				Given (change any value in the yellow boxes):
	99	73.4375		b=	2.361			b	h	x		CDF	PDF	R	H(t)
	129	89.0625		h=	92.672			2.361	92.672	92.672	---------->	0.6321205588	0.0093724465	0.3678794412	0.025476951
				R2 =	0.9500
						0.7251105794
Sheet1
	
Sheet2
	
Sheet3