Using Microsoft Excel for Weibull Analysis

Fri, 01/01/1999 - 10:34

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.
By logging in you agree to receive communication from Quality Digest. Privacy Policy.

Comments

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

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

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

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

                              

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

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

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

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;

Add new comment