Scribd Logo
Upload

Welcome to Scribd!

  • 282 views

    Weibull Analysis in Excel

    Uploaded by

    marquitosperu13
    This document provides information about performing Weibull analysis in Excel. It discusses the Weibull distribution functions for cumulative distribution function (CDF) and probability density function (PDF) available in Excel. It also explains that the Weibull function in Excel requires the shape (slope) and scale (characteristic life) parameters and will not calculate them from the data. The document gives the equations for the Weibull CDF and PDF and how to calculate reliability and instantaneous failure rate from the distribution.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Weibull Analysis in Excel

    Uploaded by

    marquitosperu13
    282 views2 pages
    This document provides information about performing Weibull analysis in Excel. It discusses the Weibull distribution functions for cumulative distribution function (CDF) and probability density function (PDF) available in Excel. It also explains that the Weibull function in Excel requires the shape (slope) and scale (characteristic life) parameters and will not calculate them from the data. The document gives the equations for the Weibull CDF and PDF and how to calculate reliability and instantaneous failure rate from the distribution.

    Original Description:

    example of the method of Weibull

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides information about performing Weibull analysis in Excel. It discusses the Weibull distribution functions for cumulative distribution function (CDF) and probability density function (PDF) available in Excel. It also explains that the Weibull function in Excel requires the shape (slope) and scale (characteristic life) parameters and will not calculate them from the data. The document gives the equations for the Weibull CDF and PDF and how to calculate reliability and instantaneous failure rate from the distribution.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    282 views2 pages

    Weibull Analysis in Excel

    Uploaded by

    marquitosperu13
    This document provides information about performing Weibull analysis in Excel. It discusses the Weibull distribution functions for cumulative distribution function (CDF) and probability density function (PDF) available in Excel. It also explains that the Weibull function in Excel requires the shape (slope) and scale (characteristic life) parameters and will not calculate them from the data. The document gives the equations for the Weibull CDF and PDF and how to calculate reliability and instantaneous failure rate from the distribution.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 2

    Weibull Analysis In Excel

    Refer to The New Weibull Handbook, 5th edition, by Dr. Robert B. Abernethy for nomenclature
    Also refer to International Standard IEC 61649 Edition 2.0 2008-08 for the same nomeclature as The New Weibull Handbook
    i-values
    X-age to
    failure
    sorted
    Y-plot
    position
    Use This
    Date For
    X-axis
    Use This
    Date For
    Y-axis
    1 37 0.109375 -2.15561601 3.610918 A Weibull function is provided in Excel for the CDF and PDF values
    2 63 0.265625 -1.17527042 4.143135 Weibull(x,alpha,beta,true) <--provides the cumulative distribution function, CDF, at the value of x
    3 69 0.421875 -0.60154355 4.234107 Weibull(x,alpha,beta,false) <--provides the probablity density function, PDF, at the value for x
    4 73 0.578125 -0.14728704 4.290459 note x must be greater than zero
    5 108 0.734375 0.2819178 4.682131 note alpha in Excel is the Weibull slope b
    6 140 0.890625 0.79433683 4.941642
    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=
    2.361 0.632121
    <--Using the Excel Weibull function for X-age to failure @ 92.672 we get the expected CDF
    h=
    92.672 0.009373
    <--Using the Excel Weibull function for X-age to failure @ 92.672 we get the expected PDF
    R
    2
    = 0.9508 The Weibull CDF = 1-exp(-(x/h)^(1/b))
    The Weibull PDF = (b/(h^b))*(x^(b-1))*exp(-1*(x/h)^b)
    SuperSMITH Weibull Stats Given (change any value in the yellow boxes):
    b=
    2.361 b h
    h=
    92.672 2.361 92.672
    R
    2
    = 0.9500
    The Facts For A Weibull Plot
    Data To Use For
    Excel Regression
    Refer to The New Weibull Handbook, 5th edition, by Dr. Robert B. Abernethy for nomenclature
    Also refer to International Standard IEC 61649 Edition 2.0 2008-08 for the same nomeclature as The New Weibull Handbook
    A Weibull function is provided in Excel for the CDF and PDF values
    Weibull(x,alpha,beta,true) <--provides the cumulative distribution function, CDF, at the value of x
    Weibull(x,alpha,beta,false) <--provides the probablity density function, PDF, at the value for x
    note x must be greater than zero
    note alpha in Excel is the Weibull slope b
    note beta in Excel is the Weibull characteristic value h
    The Weibull function in Excel will not take a data set and return the b and h values!
    <--Using the Excel Weibull function for X-age to failure @ 92.672 we get the expected CDF
    <--Using the Excel Weibull function for X-age to failure @ 92.672 we get the expected PDF
    The Weibull CDF = 1-exp(-(x/h)^(1/b)) Weibull reliability R = 1-CDF
    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)
    Given (change any value in the yellow boxes):
    x CDF PDF R H(t)
    92.672 ----------> 0.632121 0.009372 0.367879 0.025477

    You might also like