DoE in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 ก.ย. 2024

ความคิดเห็น • 30

  • @agoogleuser312
    @agoogleuser312 3 ปีที่แล้ว

    Thank you so much for your simple explanation I’ve been struggling with this for a week now

  • @atbolt
    @atbolt 4 วันที่ผ่านมา

    Fantastic!!!

    • @spurvevej42
      @spurvevej42  4 วันที่ผ่านมา

      Thanks! Remember to subscribe for more 😊

  • @firmacomedy
    @firmacomedy 2 ปีที่แล้ว

    14 factors resultater in a large design matrix, and you might want to conduct a fractional factoring design. That being said, you can find free software (small python scripts) that will automatically generate the design matrix based on the number of factors.

    • @forvidsamol3758
      @forvidsamol3758 ปีที่แล้ว

      can you tell me what is script for generating full factorial design? I Have 68 factors, 4 runs and 2 levels, orders are randomised by the results itself.

  • @MsJaguarundi
    @MsJaguarundi หลายเดือนก่อน

    Thank you so much for this! I wonder if it can be applied the same for 3 factors with five levels.

    • @spurvevej42
      @spurvevej42  หลายเดือนก่อน

      Thanks, much appreciated. Yes, this also works for more than two levels and three factors. A primary example is the central composite design. Remember to subscribe 😊

  • @plutusxii5585
    @plutusxii5585 2 ปีที่แล้ว

    hey, here you manually entered the high/low levels for each factor but in cases where you are dealing with more than three factors (i.e. I have 14 factors with two levels), how can one assign high/lows for each run? i.e. while still ensuring orthogonality?

  • @danielreyesmartinez6361
    @danielreyesmartinez6361 4 หลายเดือนก่อน

    Best video ever

    • @spurvevej42
      @spurvevej42  4 หลายเดือนก่อน

      Thanks Daniel, glad you found it useful. Remember to subscribe 😊

  • @josechvaicer7328
    @josechvaicer7328 2 ปีที่แล้ว +1

    Excelent and simple= easy to understand.
    Would you have an example for 3 factor 3 level fractional and full factorial?

    • @firmacomedy
      @firmacomedy 2 ปีที่แล้ว

      Thanks! Remember to subscribe 👍 I will look into 3 factor/3 lever designs, in the meantime you might want to refer to "Engineering Statistics" by Montgomery.

    • @josechvaicer7328
      @josechvaicer7328 2 ปีที่แล้ว

      @@firmacomedy Hi, I did subscribed and am looking forward for the 3^3 fractional a and full factorial example. Thank you

  • @mehdibenyahia7539
    @mehdibenyahia7539 ปีที่แล้ว

    which method are you using for the calculations. is this the factorial plan 2^k with k the number of factors ?

  • @amirmirou8037
    @amirmirou8037 3 ปีที่แล้ว +1

    If I have 6 factors; so I need to write 64 lines with the two corresponding levels?

    • @spurvevej42
      @spurvevej42  3 ปีที่แล้ว

      yes, the number of treatment combinations in a full factorial design is p^k where p=number of levels, k=number of factors. If you have n runs of each combination (i.e. n-1 replications) the total number of runs is n*p^k

  • @teelit7655
    @teelit7655 2 ปีที่แล้ว +1

    How do l optimise the model say exact temperature or pH or concentration to give the maximum yield?

    • @teelit7655
      @teelit7655 2 ปีที่แล้ว +1

      My plan is to use solver in excel. If thats tge case for x1, x2 etc do l use -1 and 1s, or actual figures for my factors?

    • @chandrashekharb.7708
      @chandrashekharb.7708 9 หลายเดือนก่อน

      @@teelit7655 I have the same question, can you help if you found it out?

  • @aatikahaabdul3306
    @aatikahaabdul3306 3 ปีที่แล้ว

    What if we have 5 levels for each factor? How do I arrange the (-2,-1,0,1,2)?

    • @spurvevej42
      @spurvevej42  3 ปีที่แล้ว +1

      yes that's one way of doing it. Check "Central Composite Design" - that might be relevant to you

  • @miguelarmenta347
    @miguelarmenta347 2 ปีที่แล้ว

    Which book do you refer to in this video?

    • @spurvevej42
      @spurvevej42  2 ปีที่แล้ว

      Engineering Statistics, Montgomery et al.

  • @teelit7655
    @teelit7655 2 ปีที่แล้ว

    How would you determine low and high levels

    • @spurvevej42
      @spurvevej42  2 ปีที่แล้ว

      Can you elaborate on that?

  • @burhanuddinsamiwala5859
    @burhanuddinsamiwala5859 3 ปีที่แล้ว

    I am getting a NUM! error in my p value for some reason

  • @Physicist999
    @Physicist999 3 ปีที่แล้ว

    Thankss

  • @mehmethalitozturk1720
    @mehmethalitozturk1720 3 ปีที่แล้ว

    Thank you

  • @tuhoctiengnhatvaanhchuyenn1727
    @tuhoctiengnhatvaanhchuyenn1727 ปีที่แล้ว

    You have an excel file about Design of Experimpents (DoE) for Injection Molding.
    Please give me that file.
    Thank you very much for your help.