DONE IN EXCEL You are trying to determine the reliability of a given product. Yo
ID: 3225994 • Letter: D
Question
DONE IN EXCEL
You are trying to determine the reliability of a given product. You place 100 on a test stand and collect 24 data point, one every 8 hours. The results are shown in the Problem 5 worksheet of the Test 4 Data file. Determine the parameters for a Weibull reliability distribution from this data (report results using the text definition for beta).
i Hour # Remaining 0 0 100 1 8 99 2 16 97 3 24 94 4 32 90 5 40 85 6 48 79 7 56 73 8 64 66 9 72 60 10 80 53 11 88 46 12 96 40 13 104 34 14 112 29 15 120 24 16 128 19 17 136 16 18 144 13 19 152 10 20 160 8 21 168 6 22 176 5 23 184 3 24 192 3Explanation / Answer
This can easily determine by R software but I have not solve by excel
x=c(100,99,97,94,90,85,79,73,66,60,53,46,
40,34,29,24,19,16,13,10,8,6,5,3,3)
n=length(x)
######################### WD ####################
LogL1=function(bt){
z1=n*log(bt)+(bt-1)*sum(log(x))-sum(x^(bt))
return(-z1)
}
M1=nlm(LogL1, 3, hessian=T)
Mbt1=M1$estimate[1]
Mbt1
0.2220319
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.