{domain:"www.qualitydigest.com",server:"169.47.211.87"} Skip to main content

User account menu
Main navigation
  • Topics
    • Customer Care
    • FDA Compliance
    • Healthcare
    • Innovation
    • Lean
    • Management
    • Metrology
    • Operations
    • Risk Management
    • Six Sigma
    • Standards
    • Statistics
    • Supply Chain
    • Sustainability
    • Training
  • Videos/Webinars
    • All videos
    • Product Demos
    • Webinars
  • Advertise
    • Advertise
    • Submit B2B Press Release
    • Write for us
  • Metrology Hub
  • Training
  • Subscribe
  • Log in
Mobile Menu
  • Home
  • Topics
    • 3D Metrology-CMSC
    • Customer Care
    • FDA Compliance
    • Healthcare
    • Innovation
    • Lean
    • Management
    • Metrology
    • Operations
    • Risk Management
    • Six Sigma
    • Standards
    • Statistics
    • Supply Chain
    • Sustainability
    • Training
  • Login / Subscribe
  • More...
    • All Features
    • All News
    • All Videos
    • Contact
    • Training

Using Microsoft Excel for Weibull Analysis

William Dorner
Fri, 01/01/1999 - 10:34
  • Comment
  • RSS

Social Sharing block

  • Print
Body

Click here to download the Excel worksheet used in this article.

Many people use Microsoft Excel on a daily basis. Yet few people realize the extent of Excel's analytical capabilities. Fewer still put these capabilities to work for process improvement, product improvement and profit.Most Excel users are aware of the common formulas and charts. But with some creativity, users can produce tools like control charts, Pareto charts and box-and-whisker plots (see "Using Excel for Data Analysis," Quality Digest, October 1997). And with a little guidance, users can employ more advanced statistical methods with Excel. This article presents a how-to approach for one such advanced technique-Weibull analysis.

You haven't turned the page yet? Those of you who remain probably fall under one of two categories: those familiar with reliability data analysis, and Excel enthusiasts who are curious to learn one more way to exploit this versatile software. I predict readers in both groups will be glad they stuck around.

 …

Want to continue?
Log in or create a FREE account.
Enter your username or email address
Enter the password that accompanies your username.
By logging in you agree to receive communication from Quality Digest. Privacy Policy.
Create a FREE account
Forgot My Password

Comments

Submitted by iamanishs on Fri, 03/11/2016 - 02:28

Regarding Basic Data(Design A Cycles)

Sir,

The data u have entered in Design A Cycles is for the no. of cycles the component ran without a failure.

I have a set of data which contains: 1)No. of failures 2)Total working time 3)Period of Failure(time to repair)... But I do not have the Time between failures data... How can I calculate Reliability by Weibull distribution using these available data. Please let me know as I am stuck at this point.

Thanks,

Anish

  • Reply

Submitted by Anonymous (not verified) on Mon, 01/29/2018 - 14:28

In reply to Regarding Basic Data(Design A Cycles) by iamanishs

work with data that includes sets without failures

These data are called censored. Please look at 

http://www.mathpages.com/home/kmath122/kmath122.htm

to understand how to calculate the median ranks in this case - it is quite streight forward. everything else can be just as shown in the example above

  • Reply

Submitted by rogeriojhf on Tue, 09/27/2016 - 10:13

Extrapolating Failure Results

Hi,

Above all, thank you for sharing this tool. But I don't have all the failure times. I just have the hours of the firts failure of a component, and the hours spent in components not failed. How can I introduce this non failure data into the parameters estimation. 

Thank you for your assistance regarding this matter. Rogerio.

Failure Hours First          Last Know Hours5.189,00                         7.656

7.767,00                         12.206

4.045,00                         11.195

5.240,00                          11.460

5.668,00                          9.387

-                                       8.397

-                                       9.873

-                                       11.071

-                                       11.315

-                                       9.386

-                                       10.426

                              

  • Reply

Submitted by mayuri on Tue, 06/19/2018 - 19:58

Combine effect of Different type of failure on particular part

Hello ,

 

 Thank you for sharing great information about field failure analysis.

I wanted know about how to find find combine effect of different type of failure on particular part .I am having Failure data & components time which are still opeating on field.

How can i find shape factore , scale factor & other extimation parameter by using combine effect of all Failure.

 

Time (Hr)                Failure Reason

50                          Scoring Marks

68                         Ports thread damage

150                       Scoring Marks

220                       Rotation of Control valve 

250                       Scoring Marks

390                       Scoring Marks

500                      cracked from threaded insert area

700                      Heavy Chip Off

780                      Scoring Marks

1000                    Scoring Marks

1250                    cracked from threaded insert area

  • Reply

Submitted by Anonymous (not verified) on Mon, 03/25/2019 - 06:56

DESIGN TYPE B BETA AND ALPHA IS DIFFERENT FORM ME

DEAR 

I SEE A HELPFUL EXCEL UASGE AND HERE BELOW ONE QUESTION. 

ALPH AND BETA FROM YOUR CALACULATION GIVEN AS ,2.53,723105. BUT IN MY CALACULATION I FOUND IS THAT BETA, -0.16 ,AND ALPHA, 21977.83394. PLEASE HELP.

KIND REGARDS;

  • Reply

Add new comment

Image CAPTCHA
Enter the characters shown in the image.
Please login to comment.
      

© 2025 Quality Digest. Copyright on content held by Quality Digest or by individual authors. Contact Quality Digest for reprint information.
“Quality Digest" is a trademark owned by Quality Circle Institute Inc.

footer
  • Home
  • Print QD: 1995-2008
  • Print QD: 2008-2009
  • Videos
  • Privacy Policy
  • Write for us
footer second menu
  • Subscribe to Quality Digest
  • About Us
  • Contact Us