Tutorial for determining Weibull modulus in excel

short 6 minute step by step tutorial for using excel to determine weibull modulus for test data.

Пікірлер: 82

  • @Pandamex187
    @Pandamex1875 ай бұрын

    6 years later and you still saved my life with this. Might actually pass this lab

  • @TheSiimh
    @TheSiimh6 жыл бұрын

    Fast and clear. You know that he knows what he is talking about.

  • @leahoscar1
    @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

    @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-yiadom1923
    @ernestkonadu-yiadom19236 ай бұрын

    You just helped me understand Weibull distribution in your video. I am grateful

  • @TaylorSparks

    @TaylorSparks

    6 ай бұрын

    My pleasure!

  • @HamzaNajahOfficial
    @HamzaNajahOfficial4 жыл бұрын

    Well explained, Thanks so much.

  • @gerhardcoetzee5008
    @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

  • @balajisriram6363
    @balajisriram63635 жыл бұрын

    very helpful thanks!!!!

  • @anaidas676
    @anaidas6763 жыл бұрын

    Dear Taylor, thanks for the video. However, could you plz explain the QQ plot for weibull distribution.

  • @samettelstein5649
    @samettelstein5649 Жыл бұрын

    This saved me for my ceramics final thank you!

  • @TaylorSparks

    @TaylorSparks

    Жыл бұрын

    Super glad to help!

  • @alaaisraa9459
    @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-ct8ru
    @Dasha-ct8ru2 жыл бұрын

    Thanksss! Very well explained, clear and easy (L)

  • @corinnishimoto8380
    @corinnishimoto83806 жыл бұрын

    Wow thank you so much for saving my grade

  • @TaylorSparks

    @TaylorSparks

    6 жыл бұрын

    Corin N Let me know what else I can help with!

  • @juniorkingshabi

    @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?

  • @shubhamambekar8066
    @shubhamambekar80663 жыл бұрын

    Nice video, could you please help me to know how we can find Beta and theta value using MLE method in excel?

  • @georgekarafyllias7018
    @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

    @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

    @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!

  • @alioaaeekk8792
    @alioaaeekk87924 жыл бұрын

    thank you

  • @raydelcampo
    @raydelcampo4 жыл бұрын

    Excellent video nice explained

  • @TaylorSparks

    @TaylorSparks

    4 жыл бұрын

    glad to help! like, sub, and share to help me grow the channel ;)

  • @MrKidcurry13
    @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

    @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.bolivia
    @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

  • @juniorkingshabi
    @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

    @David-jr9gx

    2 жыл бұрын

    Same question

  • @ajaypal-xo2ce
    @ajaypal-xo2ce3 жыл бұрын

    hello, very nice explanation. can you help me to teach about inverse weibull distribution function plzz

  • @tajammulhusainm1385
    @tajammulhusainm13853 жыл бұрын

    Thank you so much sir

  • @MrMec09
    @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

    @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

    @MrMec09

    4 жыл бұрын

    @@TaylorSparks Thank you!

  • @sight_ent
    @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.

  • @mikej2338
    @mikej23386 жыл бұрын

    Thank you so much. This video is so helpful. What is the Characteristic Strength value? Is it -17.047?

  • @TaylorSparks

    @TaylorSparks

    6 жыл бұрын

    Mike J close. Not quite. -17.04 I'd equal to modulus*ln(characteristic strength)

  • @mihotsubaki8892

    @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

    @TaylorSparks

    5 жыл бұрын

    @@mihotsubaki8892 correct.

  • @amrounesalah8706
    @amrounesalah87062 жыл бұрын

    Thanks a lot

  • @olgameshch372
    @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

    @TaylorSparks

    4 жыл бұрын

    sorry, what's a "t test"?

  • @olgameshch372

    @olgameshch372

    4 жыл бұрын

    I need a two tailed t-test with p

  • @TaylorSparks

    @TaylorSparks

    4 жыл бұрын

    @@olgameshch372 sorry! I'm unsure how to help with this. If you find a good resource post it here!

  • @olgameshch372

    @olgameshch372

    4 жыл бұрын

    No worries 👍 thanks

  • @samanthafranco4538
    @samanthafranco45383 жыл бұрын

    Is characteristic strength the same as characteristic life when doing a weibull using failure to time?

  • @TaylorSparks

    @TaylorSparks

    3 жыл бұрын

    Yes

  • @sjkpia
    @sjkpia5 жыл бұрын

    Thanks

  • @haasoc2716
    @haasoc27166 ай бұрын

    could you please show me how could I show different group's Weibull in a single graphs.

  • @blitzhunter93
    @blitzhunter934 жыл бұрын

    Is this the cumulative distribution function?

  • @TaylorSparks

    @TaylorSparks

    4 жыл бұрын

    Plotting failure probability, F vs stress will give you that cumulative distribution.

  • @3006spikespiegel
    @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

    @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

    @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

    @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

    @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

    @TaylorSparks

    5 жыл бұрын

    @@3006spikespiegel glad it was helpful!

  • @blitzhunter93
    @blitzhunter934 жыл бұрын

    How to determine the shape parameter and scale parameter using excel?

  • @TaylorSparks

    @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-cn2gj
    @Hanna-cn2gj5 жыл бұрын

    How about the effect of volume?

  • @TaylorSparks

    @TaylorSparks

    5 жыл бұрын

    kzread.info/dash/bejne/gn2M0dGMnLzKYNI.html

  • @mariafernandadornelleshowe3322
    @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

    @TaylorSparks

    4 жыл бұрын

    Sure thing. I've worked on geoploymers before. Sparks@eng.utah.edu

  • @ketakikamath9339
    @ketakikamath93393 жыл бұрын

    hi. how do we apply this for 5 sample groups?

  • @TaylorSparks

    @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

    @ketakikamath9339

    3 жыл бұрын

    @@TaylorSparks ahh. I am getting the #NUM! error after the y axis column gave 3 values.

  • @gaurangthanki
    @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

    @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

    @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-bz7nc6ep4o
    @user-bz7nc6ep4o4 жыл бұрын

    merci infinement ,plz comment on va trouver les parametres de wiebell sur excel,et merci d'avance j'attends votre reponse

  • @ayoubainouz7187

    @ayoubainouz7187

    4 жыл бұрын

    je suis interesse aussi

  • @user-bz7nc6ep4o

    @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

    @ayoubainouz7187

    4 жыл бұрын

    بسمة العلمي merci beaucoup basma ,j’ai arriver a determiner les parametre de Weibull .

  • @user-bz7nc6ep4o

    @user-bz7nc6ep4o

    4 жыл бұрын

    @@ayoubainouz7187 Je vous en prie

  • @TkTronixYt
    @TkTronixYt Жыл бұрын

    Why is there an Airplane starting in the Background?

  • @TaylorSparks

    @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 :)

  • @anisnezzar5238
    @anisnezzar52383 жыл бұрын

    You are les ZHOMMES Habibi!

  • @TaylorSparks

    @TaylorSparks

    3 жыл бұрын

    👊🏻💪🏻👍🏻

  • @arifurmollah4386
    @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! 🙂

  • @TaylorSparks

    @TaylorSparks

    6 ай бұрын

    Ceramics, processing statistics, possibly fracture mechanics?