Tutorial for determining Weibull modulus in excel

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • short 6 minute step by step tutorial for using excel to determine weibull modulus for test data.

Комментарии • 82

  • @Pandamex187
    @Pandamex187 6 месяцев назад

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

  • @ernestkonadu-yiadom1923
    @ernestkonadu-yiadom1923 7 месяцев назад +1

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

  • @leahoscar1
    @leahoscar1 4 года назад +1

    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 года назад +1

      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

  • @TheSiimh
    @TheSiimh 6 лет назад +1

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

  • @samettelstein5649
    @samettelstein5649 Год назад +1

    This saved me for my ceramics final thank you!

  • @corinnishimoto8380
    @corinnishimoto8380 6 лет назад +7

    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?

  • @raydelcampo
    @raydelcampo 4 года назад +1

    Excellent video nice explained

    • @TaylorSparks
      @TaylorSparks  4 года назад

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

  • @Dasha-ct8ru
    @Dasha-ct8ru 3 года назад

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

  • @sight_ent
    @sight_ent 2 года назад +1

    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.

  • @anaidas676
    @anaidas676 3 года назад +1

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

  • @balajisriram6363
    @balajisriram6363 5 лет назад +2

    very helpful thanks!!!!

  • @gerhardcoetzee5008
    @gerhardcoetzee5008 3 года назад

    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

  • @HamzaNajahOfficial
    @HamzaNajahOfficial 4 года назад

    Well explained, Thanks so much.

  • @alaaisraa9459
    @alaaisraa9459 3 года назад

    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

  • @Softskincare.bolivia
    @Softskincare.bolivia 2 года назад

    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

  • @haasoc2716
    @haasoc2716 7 месяцев назад

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

  • @alioaaeekk8792
    @alioaaeekk8792 5 лет назад +2

    thank you

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

  • @tajammulhusainm1385
    @tajammulhusainm1385 3 года назад

    Thank you so much sir

  • @shubhamambekar8066
    @shubhamambekar8066 3 года назад

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

  • @amrounesalah8706
    @amrounesalah8706 2 года назад

    Thanks a lot

  • @MrMec09
    @MrMec09 4 года назад

    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 года назад +2

      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!

  • @olgameshch372
    @olgameshch372 5 лет назад

    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  5 лет назад

      sorry, what's a "t test"?

    • @olgameshch372
      @olgameshch372 5 лет назад

      I need a two tailed t-test with p

    • @TaylorSparks
      @TaylorSparks  5 лет назад

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

    • @olgameshch372
      @olgameshch372 5 лет назад

      No worries 👍 thanks

  • @TkTronixYt
    @TkTronixYt Год назад +1

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

  • @ajaypal-xo2ce
    @ajaypal-xo2ce 3 года назад

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

  • @samanthafranco4538
    @samanthafranco4538 3 года назад

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

  • @mikej2338
    @mikej2338 6 лет назад

    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.

  • @georgekarafyllias7018
    @georgekarafyllias7018 6 лет назад

    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  6 лет назад

      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 6 лет назад +1

      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!

  • @mariafernandadornelleshowe3322
    @mariafernandadornelleshowe3322 4 года назад +1

    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 года назад +1

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

  • @MrKidcurry13
    @MrKidcurry13 6 лет назад

    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  6 лет назад +1

      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

  • @3006spikespiegel
    @3006spikespiegel 6 лет назад +1

    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  6 лет назад +1

      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 6 лет назад

      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  6 лет назад +1

      @@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 6 лет назад +1

      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  6 лет назад

      @@3006spikespiegel glad it was helpful!

  • @gaurangthanki
    @gaurangthanki 2 года назад

    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 года назад +1

      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

  • @blitzhunter93
    @blitzhunter93 5 лет назад

    Is this the cumulative distribution function?

    • @TaylorSparks
      @TaylorSparks  5 лет назад +1

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

  • @sjkpia
    @sjkpia 5 лет назад

    Thanks

  • @blitzhunter93
    @blitzhunter93 5 лет назад

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

    • @TaylorSparks
      @TaylorSparks  5 лет назад +1

      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.

  • @ketakikamath9339
    @ketakikamath9339 3 года назад

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

    • @TaylorSparks
      @TaylorSparks  3 года назад +1

      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.

  • @Hanna-cn2gj
    @Hanna-cn2gj 5 лет назад

    How about the effect of volume?

    • @TaylorSparks
      @TaylorSparks  5 лет назад

      ruclips.net/video/PIXooSlYd0o/видео.html

  • @user-bz7nc6ep4o
    @user-bz7nc6ep4o 4 года назад

    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 года назад +1

      @@ayoubainouz7187
      Cette vidéo explique comment on peut les trouver:voilà le lien de vidéo
      ruclips.net/video/fdfrUTNazrM/видео.html

    • @ayoubainouz7187
      @ayoubainouz7187 4 года назад

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

    • @user-bz7nc6ep4o
      @user-bz7nc6ep4o 4 года назад +1

      @@ayoubainouz7187
      Je vous en prie

  • @anisnezzar5238
    @anisnezzar5238 3 года назад +1

    You are les ZHOMMES Habibi!

  • @arifurmollah4386
    @arifurmollah4386 7 месяцев назад

    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  7 месяцев назад

      Ceramics, processing statistics, possibly fracture mechanics?