WEIBULL Function to help determine the life of the machine.

Fin Fang Foom

Well-known Member
Joined
Mar 20, 2005
Messages
598
Hi everyone,

I would like an estimate that the probability of the machine will work without failing between a certain time.

The machine should run 7.67 everyday. But the machine breaks down time to time. I would like to know if I schedule a Product to run say at 3.17 hours on that machine or if I schedule a product to run 7.67 hours what are the percentages of the machine will work without failing in the 3.17 hours or at 7.67 hours?

I know in excel there is a function call WEIBULL to help modeling machine lifetimes but I do not know where to start.

Here is my data below.

Column-A
Machine Name
Cast machine-1
Cast machine-1
Cast machine-1
Cast machine-1
Cast machine-1
Cast machine-1
Cast machine-1
Cast machine-1

Column B is the data for the last 2 weeks of the number of hours it ran until hitting downtime.

Column-B
Life of the Machine
7.01
4.16
7.67
5
2.12
1.2
6.01
7.2
3.01
1.99
7.20
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Hi everyone,



Here is the table below. Say if I schedule a paticular product to run on the machine for 7.67 hours. What is the probabilty rate that it will fail between 1 to 7.67? I know I need to get the ALPHA anf the BETA to complete my calculations But I don't know how to get it. I know you could use solver but I never used it before. Also I cannot post the expected results because I just don't know what they are. Here is the WEILBULL formula I'm using in cell E8:

=WEIBULL(7.67,E2,E3,TRUE)-WEIBULL(1,E2,E3,TRUE)


Does anyone know how to use solver to get the ALPHA and the BETA?


Column A10:A18 is the history of the machine of hours ran.
Weibullesttemp.xlsx
ABCDE
1
2mean5.5957143alpha
3sigma1.9809497beta
4
5
6
7Probablity between 1 to 7.67 hrs.
8#NUM!
9
10History of theHours
11MachineRan
12Machine 17.01
13Machine 14.16
14Machine 17.67
15Machine 15
16Machine 12.12
17Machine 16.01
18Machine 17.2
19
Sheet1
 
Upvote 0

Forum statistics

Threads
1,215,909
Messages
6,127,670
Members
449,397
Latest member
Bastbog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top