short 6 minute step by step tutorial for using excel to determine weibull modulus for test data.
Жүктеу.....
Пікірлер: 82
@Pandamex1875 ай бұрын
6 years later and you still saved my life with this. Might actually pass this lab
@TheSiimh6 жыл бұрын
Fast and clear. You know that he knows what he is talking about.
@leahoscar14 жыл бұрын
Very helpful, thank you for making this video! You mentioned that 'charts don't need titles', when they literally ALWAYS do. It's a habit that should be hammered into people in all scientific fields.
@TaylorSparks
4 жыл бұрын
Oof. I'll have to disagree. Captions, axes labels, legends yes, but titles certainly not. Here is the resource that I share with all my students www.mrl.ucsb.edu/~seshadri/PreparingFigures-February2020.pdf
@ernestkonadu-yiadom19236 ай бұрын
You just helped me understand Weibull distribution in your video. I am grateful
@TaylorSparks
6 ай бұрын
My pleasure!
@HamzaNajahOfficial4 жыл бұрын
Well explained, Thanks so much.
@gerhardcoetzee50083 жыл бұрын
First of all. Thank you for the videos, very helpful. I was wondering how you would go about performing a Weibull analysis were the failure is time-based and not based on stress. Lets say you have a 100 samples that you tested cyclicly to determine the endurance limit. Only 20 samples failed and the other samples did not fail after 1E6 cycles. How do you go about saying something about the reliability of XXX cycles? I have calculated it too and would like to see your reasoning. Kind regards Gerhard
@balajisriram63635 жыл бұрын
very helpful thanks!!!!
@anaidas6763 жыл бұрын
Dear Taylor, thanks for the video. However, could you plz explain the QQ plot for weibull distribution.
@samettelstein5649 Жыл бұрын
This saved me for my ceramics final thank you!
@TaylorSparks
Жыл бұрын
Super glad to help!
@alaaisraa94593 жыл бұрын
Thank you for this video, please I have a question, how do we estimate the failure function, if I have the number of data exactly 20
@Dasha-ct8ru2 жыл бұрын
Thanksss! Very well explained, clear and easy (L)
@corinnishimoto83806 жыл бұрын
Wow thank you so much for saving my grade
@TaylorSparks
6 жыл бұрын
Corin N Let me know what else I can help with!
@juniorkingshabi
3 жыл бұрын
@@TaylorSparks Hey Taylor, Thanks for the nice video. So, If I have to use the weibull.dist formula in excel, will the alpha be 2.8941 and beta be 17.047?
@shubhamambekar80663 жыл бұрын
Nice video, could you please help me to know how we can find Beta and theta value using MLE method in excel?
@georgekarafyllias70185 жыл бұрын
Thank you for your video mate. Can I apply this approach for sand size distribution problems? For example, I plotted the cumulative mass % against the size of the particles. Am I able to see if my curve falls to Weibull distribution?
@TaylorSparks
5 жыл бұрын
absolutely. A Weibull analysis simply assumes your data can be fit by a curve and then allows you to define that distribution with parameters that represent tightness of distribution (weibull modulus) and characteristic values etc.
@georgekarafyllias7018
5 жыл бұрын
I think I got the logic - I ranked the sieve size according to the cumulative percentage (the highest stress in your case is the sieve size with the highest cumulative percentage in my case) and then followed your steps. Many thanks for your help Taylor!
@alioaaeekk87924 жыл бұрын
thank you
@raydelcampo4 жыл бұрын
Excellent video nice explained
@TaylorSparks
4 жыл бұрын
glad to help! like, sub, and share to help me grow the channel ;)
@MrKidcurry135 жыл бұрын
is it possible to use this method to determine the time at which something will fail rather than the stress it fails at. Say i have multiple identical machines that runs for 24 hours and I have data on the number of hours it runs before failing can I use Weibull?
@TaylorSparks
5 жыл бұрын
absolutely. The steps are the exact same. Instead of ranking your samples by the strength that which they fail, you will rank them by the time at which they fail. All the steps that follow are the exact same
@Softskincare.bolivia2 жыл бұрын
Thank u so much, I have a question about "y" I saw there are different equations and it depends the number of data, I was reading a book that the equation it was y=(i-0.3) /(n-0.4) and gave me a different result from y=(i-0, 5) /n, I wish to know which is the best, my n=3
@juniorkingshabi3 жыл бұрын
Hey Taylor, Thanks for the nice video. So, If I have to use the weibull.dist formula in excel, will the alpha be 2.8941 and beta be 17.047?
@David-jr9gx
2 жыл бұрын
Same question
@ajaypal-xo2ce3 жыл бұрын
hello, very nice explanation. can you help me to teach about inverse weibull distribution function plzz
@tajammulhusainm13853 жыл бұрын
Thank you so much sir
@MrMec094 жыл бұрын
First of all, thanks for the video, excellent work. At the beginning you say to use at least 20 (experimental/observed values), is there any work that recommends this value? I read the original article and there, Weibull presents example with 10 values. Some articles that I have read in Elsevier show results with 5/8/10 values. So, I was left with this question. Thank you again Professor.
@TaylorSparks
4 жыл бұрын
This is a good article on the topic. Essentially, more samples is greater confidence. www.researchgate.net/publication/259388853_Influence_of_Sample_Size_on_Strength_Distribution_of_Advanced_Ceramics
@MrMec09
4 жыл бұрын
@@TaylorSparks Thank you!
@sight_ent Жыл бұрын
Bonjour. Svp j'ai un problème sur Excel. La distribution ne semble pas reconnaitre les facteurs K et C comme paramètres (alpha et béta), mais comme valeurs normales, d'où elle les rejettent.
@mikej23386 жыл бұрын
Thank you so much. This video is so helpful. What is the Characteristic Strength value? Is it -17.047?
@TaylorSparks
6 жыл бұрын
Mike J close. Not quite. -17.04 I'd equal to modulus*ln(characteristic strength)
@mihotsubaki8892
5 жыл бұрын
@@TaylorSparks so in that case would the characteristic strength be .00276? to find the characteristic strength, I did -17.047 = 2.8941*ln(characteristic strength), would that be correct?
@TaylorSparks
5 жыл бұрын
@@mihotsubaki8892 correct.
@amrounesalah87062 жыл бұрын
Thanks a lot
@olgameshch3724 жыл бұрын
so good and simple explanation , thank you so much... how to do t test for weibull test , will appreciate if you can give a tutorial for that
@TaylorSparks
4 жыл бұрын
sorry, what's a "t test"?
@olgameshch372
4 жыл бұрын
I need a two tailed t-test with p
@TaylorSparks
4 жыл бұрын
@@olgameshch372 sorry! I'm unsure how to help with this. If you find a good resource post it here!
@olgameshch372
4 жыл бұрын
No worries 👍 thanks
@samanthafranco45383 жыл бұрын
Is characteristic strength the same as characteristic life when doing a weibull using failure to time?
@TaylorSparks
3 жыл бұрын
Yes
@sjkpia5 жыл бұрын
Thanks
@haasoc27166 ай бұрын
could you please show me how could I show different group's Weibull in a single graphs.
@blitzhunter934 жыл бұрын
Is this the cumulative distribution function?
@TaylorSparks
4 жыл бұрын
Plotting failure probability, F vs stress will give you that cumulative distribution.
@3006spikespiegel5 жыл бұрын
Hello there. thanks for the tutorial...very helpful..but why did you chose 0.5 to estimate the failure (column F)... i found another website that suggested another formula F=(rank-0.3)/(population+0.4) and he calls it MEDIAN RANK...the latter method makes even less sense...do you have a way to optimize this calculation of this median rank? Nevertheless, you method is easier than the other tutorial i found Looking forward for your reply
@TaylorSparks
5 жыл бұрын
Hello, both my method and the median rank method are both used to fix a problem with estimating failure rates. For example, if I left out my 0.5 term and I just used a rank divided by population then if I have 30 samples and I take my 30th sample and divide by 30 this would predict 100% failure. This is fine with my small sample set, but it's a big problem with reality. In reality, if I tested, say 1 million samples, the odds of having samples which fail above the stress of #30 are very high! Therefore, predicting failure rate of 100% at the stress of sample 30 was not reasonable. For that reason failure rank is modified to allow for realistic cases where more samples might be tested.
@3006spikespiegel
5 жыл бұрын
Hello again and thank you for the explanation. I totally understand the reason to modify failure rank. However, i still do not know how to chose that factor 0.5 used in the example...nor the 0.3 and 0.4 factors chosen elsewhere... are these factors still work for any size of tested population? in my case I have different populations with different sizes.. shall I get a factor for each? same for all?
@TaylorSparks
5 жыл бұрын
@@3006spikespiegel to my knowledge you don't have to choose the factor 0.5, 0.3, or 0.4. you just select a rank formula. I think median rank is more realistic so it should probably be used but you don't need to modify your 0.3 or 0.4 values.
@3006spikespiegel
5 жыл бұрын
gotcha... and I realized why your method still works: if you sum the modified ranking in column F you get population/2...in the same way as ranked median (when summed it gives population/2)... i am not really sure why these parameters has to be population/2..i need to dig it further... but probably it has to do with this page where they estimate ranked median using Inverse Beta function at probability = 50% anyway, thank you very much for the videos ...your latter videos sent me back when i was student in metallurgy! keep on good job man!
@TaylorSparks
5 жыл бұрын
@@3006spikespiegel glad it was helpful!
@blitzhunter934 жыл бұрын
How to determine the shape parameter and scale parameter using excel?
@TaylorSparks
4 жыл бұрын
the shape parameter is the same thing as the weibull modulus. I describe it in this video ;) The scale parameter is typically defined by where the line intersects the x axis. Sometimes called the characteristic strength.
@Hanna-cn2gj5 жыл бұрын
How about the effect of volume?
@TaylorSparks
5 жыл бұрын
kzread.info/dash/bejne/gn2M0dGMnLzKYNI.html
@mariafernandadornelleshowe33224 жыл бұрын
Hi! i'm a brazilian studant and i'm researching about geopolymer materials behavior. I'd like to understand more deeply the weibull distribuition. Can i contact you for e-mail?
@TaylorSparks
4 жыл бұрын
Sure thing. I've worked on geoploymers before. Sparks@eng.utah.edu
@ketakikamath93393 жыл бұрын
hi. how do we apply this for 5 sample groups?
@TaylorSparks
3 жыл бұрын
hmmm... I am not sure. You could combine the data from the sets or you could average weibull from the five sets I suppose?
@ketakikamath9339
3 жыл бұрын
@@TaylorSparks ahh. I am getting the #NUM! error after the y axis column gave 3 values.
@gaurangthanki2 жыл бұрын
I want to find out if a equipment failed x time within Y hours OF OPERATIONS what is potential probability of that equipment lasting z hours ? Example if Engine failed 14 times within 30000 Hours of operations, what is probabilities of engine lasting for 50000 Hours or at which hours it will fail ?
@TaylorSparks
2 жыл бұрын
Do you have more than one data point? If you only have the one data point then I don't know how to solve this problem. If you have a large set of data then you would apply waibel probabilistics the same way that I have here
@gaurangthanki
2 жыл бұрын
@@TaylorSparks can you please explain what you mean two data point ? Please let me know what exactly we need to put something together
@user-bz7nc6ep4o4 жыл бұрын
merci infinement ,plz comment on va trouver les parametres de wiebell sur excel,et merci d'avance j'attends votre reponse
@ayoubainouz7187
4 жыл бұрын
je suis interesse aussi
@user-bz7nc6ep4o
4 жыл бұрын
@@ayoubainouz7187 Cette vidéo explique comment on peut les trouver:voilà le lien de vidéo kzread.info/dash/bejne/mJia1LeNfsTgorA.html
@ayoubainouz7187
4 жыл бұрын
بسمة العلمي merci beaucoup basma ,j’ai arriver a determiner les parametre de Weibull .
@user-bz7nc6ep4o
4 жыл бұрын
@@ayoubainouz7187 Je vous en prie
@TkTronixYt Жыл бұрын
Why is there an Airplane starting in the Background?
@TaylorSparks
Жыл бұрын
Lol. My old laptop had some heat management problems and I wasn't using an external mic that day. I've gotten better since :)
@anisnezzar52383 жыл бұрын
You are les ZHOMMES Habibi!
@TaylorSparks
3 жыл бұрын
👊🏻💪🏻👍🏻
@arifurmollah43866 ай бұрын
I have a question for you 🙋♂️ , in colleges and universities, which courses talk about Weibull Distribution? Which courses talk about that? Which courses? I would like to know this because I don’t know which courses talk about Weibull Distribution in colleges and universities. Please tell me which courses talk about Weibull Distribution in colleges and universities. Please tell me. Please make sure that you read my email and send a reply to me. Have a very nice day! 🙂
Пікірлер: 82
6 years later and you still saved my life with this. Might actually pass this lab
Fast and clear. You know that he knows what he is talking about.
Very helpful, thank you for making this video! You mentioned that 'charts don't need titles', when they literally ALWAYS do. It's a habit that should be hammered into people in all scientific fields.
@TaylorSparks
4 жыл бұрын
Oof. I'll have to disagree. Captions, axes labels, legends yes, but titles certainly not. Here is the resource that I share with all my students www.mrl.ucsb.edu/~seshadri/PreparingFigures-February2020.pdf
You just helped me understand Weibull distribution in your video. I am grateful
@TaylorSparks
6 ай бұрын
My pleasure!
Well explained, Thanks so much.
First of all. Thank you for the videos, very helpful. I was wondering how you would go about performing a Weibull analysis were the failure is time-based and not based on stress. Lets say you have a 100 samples that you tested cyclicly to determine the endurance limit. Only 20 samples failed and the other samples did not fail after 1E6 cycles. How do you go about saying something about the reliability of XXX cycles? I have calculated it too and would like to see your reasoning. Kind regards Gerhard
very helpful thanks!!!!
Dear Taylor, thanks for the video. However, could you plz explain the QQ plot for weibull distribution.
This saved me for my ceramics final thank you!
@TaylorSparks
Жыл бұрын
Super glad to help!
Thank you for this video, please I have a question, how do we estimate the failure function, if I have the number of data exactly 20
Thanksss! Very well explained, clear and easy (L)
Wow thank you so much for saving my grade
@TaylorSparks
6 жыл бұрын
Corin N Let me know what else I can help with!
@juniorkingshabi
3 жыл бұрын
@@TaylorSparks Hey Taylor, Thanks for the nice video. So, If I have to use the weibull.dist formula in excel, will the alpha be 2.8941 and beta be 17.047?
Nice video, could you please help me to know how we can find Beta and theta value using MLE method in excel?
Thank you for your video mate. Can I apply this approach for sand size distribution problems? For example, I plotted the cumulative mass % against the size of the particles. Am I able to see if my curve falls to Weibull distribution?
@TaylorSparks
5 жыл бұрын
absolutely. A Weibull analysis simply assumes your data can be fit by a curve and then allows you to define that distribution with parameters that represent tightness of distribution (weibull modulus) and characteristic values etc.
@georgekarafyllias7018
5 жыл бұрын
I think I got the logic - I ranked the sieve size according to the cumulative percentage (the highest stress in your case is the sieve size with the highest cumulative percentage in my case) and then followed your steps. Many thanks for your help Taylor!
thank you
Excellent video nice explained
@TaylorSparks
4 жыл бұрын
glad to help! like, sub, and share to help me grow the channel ;)
is it possible to use this method to determine the time at which something will fail rather than the stress it fails at. Say i have multiple identical machines that runs for 24 hours and I have data on the number of hours it runs before failing can I use Weibull?
@TaylorSparks
5 жыл бұрын
absolutely. The steps are the exact same. Instead of ranking your samples by the strength that which they fail, you will rank them by the time at which they fail. All the steps that follow are the exact same
Thank u so much, I have a question about "y" I saw there are different equations and it depends the number of data, I was reading a book that the equation it was y=(i-0.3) /(n-0.4) and gave me a different result from y=(i-0, 5) /n, I wish to know which is the best, my n=3
Hey Taylor, Thanks for the nice video. So, If I have to use the weibull.dist formula in excel, will the alpha be 2.8941 and beta be 17.047?
@David-jr9gx
2 жыл бұрын
Same question
hello, very nice explanation. can you help me to teach about inverse weibull distribution function plzz
Thank you so much sir
First of all, thanks for the video, excellent work. At the beginning you say to use at least 20 (experimental/observed values), is there any work that recommends this value? I read the original article and there, Weibull presents example with 10 values. Some articles that I have read in Elsevier show results with 5/8/10 values. So, I was left with this question. Thank you again Professor.
@TaylorSparks
4 жыл бұрын
This is a good article on the topic. Essentially, more samples is greater confidence. www.researchgate.net/publication/259388853_Influence_of_Sample_Size_on_Strength_Distribution_of_Advanced_Ceramics
@MrMec09
4 жыл бұрын
@@TaylorSparks Thank you!
Bonjour. Svp j'ai un problème sur Excel. La distribution ne semble pas reconnaitre les facteurs K et C comme paramètres (alpha et béta), mais comme valeurs normales, d'où elle les rejettent.
Thank you so much. This video is so helpful. What is the Characteristic Strength value? Is it -17.047?
@TaylorSparks
6 жыл бұрын
Mike J close. Not quite. -17.04 I'd equal to modulus*ln(characteristic strength)
@mihotsubaki8892
5 жыл бұрын
@@TaylorSparks so in that case would the characteristic strength be .00276? to find the characteristic strength, I did -17.047 = 2.8941*ln(characteristic strength), would that be correct?
@TaylorSparks
5 жыл бұрын
@@mihotsubaki8892 correct.
Thanks a lot
so good and simple explanation , thank you so much... how to do t test for weibull test , will appreciate if you can give a tutorial for that
@TaylorSparks
4 жыл бұрын
sorry, what's a "t test"?
@olgameshch372
4 жыл бұрын
I need a two tailed t-test with p
@TaylorSparks
4 жыл бұрын
@@olgameshch372 sorry! I'm unsure how to help with this. If you find a good resource post it here!
@olgameshch372
4 жыл бұрын
No worries 👍 thanks
Is characteristic strength the same as characteristic life when doing a weibull using failure to time?
@TaylorSparks
3 жыл бұрын
Yes
Thanks
could you please show me how could I show different group's Weibull in a single graphs.
Is this the cumulative distribution function?
@TaylorSparks
4 жыл бұрын
Plotting failure probability, F vs stress will give you that cumulative distribution.
Hello there. thanks for the tutorial...very helpful..but why did you chose 0.5 to estimate the failure (column F)... i found another website that suggested another formula F=(rank-0.3)/(population+0.4) and he calls it MEDIAN RANK...the latter method makes even less sense...do you have a way to optimize this calculation of this median rank? Nevertheless, you method is easier than the other tutorial i found Looking forward for your reply
@TaylorSparks
5 жыл бұрын
Hello, both my method and the median rank method are both used to fix a problem with estimating failure rates. For example, if I left out my 0.5 term and I just used a rank divided by population then if I have 30 samples and I take my 30th sample and divide by 30 this would predict 100% failure. This is fine with my small sample set, but it's a big problem with reality. In reality, if I tested, say 1 million samples, the odds of having samples which fail above the stress of #30 are very high! Therefore, predicting failure rate of 100% at the stress of sample 30 was not reasonable. For that reason failure rank is modified to allow for realistic cases where more samples might be tested.
@3006spikespiegel
5 жыл бұрын
Hello again and thank you for the explanation. I totally understand the reason to modify failure rank. However, i still do not know how to chose that factor 0.5 used in the example...nor the 0.3 and 0.4 factors chosen elsewhere... are these factors still work for any size of tested population? in my case I have different populations with different sizes.. shall I get a factor for each? same for all?
@TaylorSparks
5 жыл бұрын
@@3006spikespiegel to my knowledge you don't have to choose the factor 0.5, 0.3, or 0.4. you just select a rank formula. I think median rank is more realistic so it should probably be used but you don't need to modify your 0.3 or 0.4 values.
@3006spikespiegel
5 жыл бұрын
gotcha... and I realized why your method still works: if you sum the modified ranking in column F you get population/2...in the same way as ranked median (when summed it gives population/2)... i am not really sure why these parameters has to be population/2..i need to dig it further... but probably it has to do with this page where they estimate ranked median using Inverse Beta function at probability = 50% anyway, thank you very much for the videos ...your latter videos sent me back when i was student in metallurgy! keep on good job man!
@TaylorSparks
5 жыл бұрын
@@3006spikespiegel glad it was helpful!
How to determine the shape parameter and scale parameter using excel?
@TaylorSparks
4 жыл бұрын
the shape parameter is the same thing as the weibull modulus. I describe it in this video ;) The scale parameter is typically defined by where the line intersects the x axis. Sometimes called the characteristic strength.
How about the effect of volume?
@TaylorSparks
5 жыл бұрын
kzread.info/dash/bejne/gn2M0dGMnLzKYNI.html
Hi! i'm a brazilian studant and i'm researching about geopolymer materials behavior. I'd like to understand more deeply the weibull distribuition. Can i contact you for e-mail?
@TaylorSparks
4 жыл бұрын
Sure thing. I've worked on geoploymers before. Sparks@eng.utah.edu
hi. how do we apply this for 5 sample groups?
@TaylorSparks
3 жыл бұрын
hmmm... I am not sure. You could combine the data from the sets or you could average weibull from the five sets I suppose?
@ketakikamath9339
3 жыл бұрын
@@TaylorSparks ahh. I am getting the #NUM! error after the y axis column gave 3 values.
I want to find out if a equipment failed x time within Y hours OF OPERATIONS what is potential probability of that equipment lasting z hours ? Example if Engine failed 14 times within 30000 Hours of operations, what is probabilities of engine lasting for 50000 Hours or at which hours it will fail ?
@TaylorSparks
2 жыл бұрын
Do you have more than one data point? If you only have the one data point then I don't know how to solve this problem. If you have a large set of data then you would apply waibel probabilistics the same way that I have here
@gaurangthanki
2 жыл бұрын
@@TaylorSparks can you please explain what you mean two data point ? Please let me know what exactly we need to put something together
merci infinement ,plz comment on va trouver les parametres de wiebell sur excel,et merci d'avance j'attends votre reponse
@ayoubainouz7187
4 жыл бұрын
je suis interesse aussi
@user-bz7nc6ep4o
4 жыл бұрын
@@ayoubainouz7187 Cette vidéo explique comment on peut les trouver:voilà le lien de vidéo kzread.info/dash/bejne/mJia1LeNfsTgorA.html
@ayoubainouz7187
4 жыл бұрын
بسمة العلمي merci beaucoup basma ,j’ai arriver a determiner les parametre de Weibull .
@user-bz7nc6ep4o
4 жыл бұрын
@@ayoubainouz7187 Je vous en prie
Why is there an Airplane starting in the Background?
@TaylorSparks
Жыл бұрын
Lol. My old laptop had some heat management problems and I wasn't using an external mic that day. I've gotten better since :)
You are les ZHOMMES Habibi!
@TaylorSparks
3 жыл бұрын
👊🏻💪🏻👍🏻
I have a question for you 🙋♂️ , in colleges and universities, which courses talk about Weibull Distribution? Which courses talk about that? Which courses? I would like to know this because I don’t know which courses talk about Weibull Distribution in colleges and universities. Please tell me which courses talk about Weibull Distribution in colleges and universities. Please tell me. Please make sure that you read my email and send a reply to me. Have a very nice day! 🙂
@TaylorSparks
6 ай бұрын
Ceramics, processing statistics, possibly fracture mechanics?