How to Make an Individuals Control in MS Excel 2007

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ต.ค. 2024

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

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

    after 13-ish years later, this video is still helpful, thank you very much!! our professor told us to do this task without teaching us how to do it, and came across this video with the exact same format. thank you again for this VERY helpful video.

  • @jacquevaughn5640
    @jacquevaughn5640 10 ปีที่แล้ว +1

    This helped a lot easy to follow and explained very well. Thank you and I hope to view other sessions of yours in the future.

  • @theaterhelp
    @theaterhelp 13 ปีที่แล้ว

    Thank you, my assignment looked so much better because of this video.

  • @alexquinones3570
    @alexquinones3570 5 ปีที่แล้ว +5

    Hello, how do you know the 2.66 value, i know there are some constant value charts, but, the chart finish at 25 observations, so how do you take that 2.66 value, do you have any function?? if you have it, can you please pass it , please.

  • @carpediem861
    @carpediem861 12 ปีที่แล้ว

    This was very helpful for the Healthcare quality class! Thank you soo much!

  • @il2zen
    @il2zen 12 ปีที่แล้ว +5

    Please correct me if this is wrong. "UCL = CL + 2.66*Moving range", why should we “2.66” here, since we are looking for 3 sigma isn’t that we should use UCL as “CL + 3 *Moving range “. Though it doesn't make much difference here, however when we compute/analyze large data there may be a difference.

    • @famco.7492
      @famco.7492 7 ปีที่แล้ว

      from where i get the 2.66? is it assumption? forecast? or what exactly??

    • @agusluqman7278
      @agusluqman7278 6 ปีที่แล้ว +1

      Kesava Raju factually, the function of UCL = CL + 3*sigma / square root n
      Where sigma is MR bar / d2
      So, UCL = CL + 3 MR bar/(d2*square root n)
      d2 is a constant in a spc table
      d2 is 1,128 ( we use n=2 because n=1 is not exist)
      And you will find number 2,66
      If you want to ask more you can call me at +6285712289529 by wa only

    • @citramarliyanti9826
      @citramarliyanti9826 4 ปีที่แล้ว

      @@agusluqman7278 kenapa pakai subgroup 2? kenapa ga 3 ,4 atau yg lainnya?

  • @shammykapoor1782
    @shammykapoor1782 4 ปีที่แล้ว

    Great video and well explained

  • @8sharkey8
    @8sharkey8 9 ปีที่แล้ว

    Great job with this. Very useful.

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

    Thank you so much your vidio helping soo much

  • @herrgarbage7290
    @herrgarbage7290 7 ปีที่แล้ว

    Awesome video - thank you so much

  • @ProfTDub
    @ProfTDub  12 ปีที่แล้ว +1

    Since the average moving range is not a standard deviation, we use 2.66*the average moving range to estimate 3 standard deviations.

    • @hankgrimes1806
      @hankgrimes1806 4 ปีที่แล้ว

      Great video! I was wondering what factors would be used to estimate 1 and 2 standard deviations. I'd like to construct a color-coded banded chart using these values. Also, would it make sense to use this approach to track weight gain/loss and daily blood sugar readings? Thanks for the lesson.

  • @Indureiner
    @Indureiner 14 ปีที่แล้ว

    Great video. Thank you mate!

  • @jofieraymond6528
    @jofieraymond6528 10 ปีที่แล้ว

    Thank you so much!

  • @nroyer23
    @nroyer23 6 ปีที่แล้ว

    How would i plot only the most recent (last 30 days) of data?

  • @cyn9801
    @cyn9801 12 ปีที่แล้ว

    need help with creating and IChart using time (hh:mm)

  • @ddrest1
    @ddrest1 13 ปีที่แล้ว

    thank you

  • @buddhikasomasiri5247
    @buddhikasomasiri5247 11 ปีที่แล้ว

    Thanks

  • @raymondvinyo5125
    @raymondvinyo5125 11 ปีที่แล้ว

    its really helpful,thanks

  • @siniappu7087
    @siniappu7087 11 ปีที่แล้ว

    Thanks..

  • @joaxe09
    @joaxe09 13 ปีที่แล้ว

    thanks . .