Please solve in excel. provide the functions and the steps how to solve it on ex

Question

Please solve in excel. provide the functions and the steps how to solve it on excel. please do not upload any kind of paper work. The answers are provided just need it in excel.

6. 10/10 points revious AnswersDevoreStat9 4.E.504.XP Let X - the time (in 10- weeks) from shipment of a defective product until the customer returns the product. Suppose that the minimum return time is ?-4.5 and that the excess X-4.5 over the minimum has a weibull distribution with parameters ?-2 and (a) What is the cdf of x? 0 $$ 1-e-((x-4.5 1.5))2 x 6). (Round your answer to four decimal places.) 3679 (d) Compute P(6 s x S 7.5). (Round your answer to four decimal places.) 3496

Explanation / Answer

formulas used

in Excel, the mean of the Weibull(alpha,beta) distribution is given by =beta*EXP(GAMMALN(1+1/alpha)) and the standard deviation is given by =beta*SQRT(EXP(GAMMALN(1+2/alpha))-EXP(GAMMALN(1+1/alpha))^2)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---