95% Confidence Interval in Excel using CONFIDENCE.NORM and Standard Error of the Mean

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

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

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

    I've been watching your regular videos for the past couple of years. Imagine my suprise when this video showed up in a playlist for a college course that I'm currently taking. 😂

  • @thecorgisquad9861
    @thecorgisquad9861 9 ปีที่แล้ว +1

    Very straightforward and easy to follow along with. Being able to follow the calculations step by step, from the mean, SD, and sample, all the way to the confidence.norm function and z-scores was visually appealing and reasonable to comprehend.

    • @mandabear52289
      @mandabear52289 9 ปีที่แล้ว

      I agree! I think that this video was wasy to follow and understnad. I think that it was color coded in a way that made it easy to visualize as well. Great explantions of the concepts by Dr. Grande

  • @reneemendez4287
    @reneemendez4287 9 ปีที่แล้ว +1

    This video was easier for me to follow than some of the other video. I appreciated how Dr. Grande explained the formulas step-by-step because it made it a lot easier to understand.

  • @katherinebeck593
    @katherinebeck593 8 ปีที่แล้ว +1

    This video was easier to follow, but I did not realize how many steps were involved. This was a good video.

  • @vloch
    @vloch 7 ปีที่แล้ว +3

    This was great I watched a couple other vides on confidence intervals but none of them truly made me understand why we were doing the functions. Thank you

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

      You're welcome!

  • @stevieporter3399
    @stevieporter3399 9 ปีที่แล้ว +2

    This video is especially discriptive and easy to follow, and it's nice to see two methods to arrive at the same result.

    • @jpincinjr
      @jpincinjr 8 ปีที่แล้ว

      +Stevie Rall I agree, very nice to know how to use Excel better.

  • @amandachaffin6636
    @amandachaffin6636 9 ปีที่แล้ว

    I liked that the confidence interval sets up the function for you and you just enter in data. That seems pretty simple. It was also nice to see a refresher of how to calculate the other functions.

    • @1515Desiree
      @1515Desiree 9 ปีที่แล้ว

      +Amanda Sutton I liked how easy it is too! It is nice that it is already set up, and we can just plug in the data.

  • @jacklinskibicki6098
    @jacklinskibicki6098 9 ปีที่แล้ว +2

    This video was helpful in understanding how to calculate the confidence interval using each of these functions. I was previously unfamiliar with the concept of upper and lower limits, but this video did a nice job in explaining the concepts and functions involved with each method.

  • @kyarapanula1002
    @kyarapanula1002 8 ปีที่แล้ว

    This is the first time I've seen the Standard Error of the Mean calculated, as part of the CONFIDENCE.NORM function. I now know this is important because the SEM takes into account the sample size, Standard Deviation, and the true mean. All in all, always good to have someone run through these stat functions, and then return to use the lesson as a visual aid.

  • @CandyKaneLane
    @CandyKaneLane 9 ปีที่แล้ว

    This video was easy to follow with step by step instructions, I felt that I was able to confidently grasp and understand how to calculate the 95% confidence interval using both given methods. The color coding also made it easy to visualize and follow along with the different steps and process.

    • @jacklinskibicki6098
      @jacklinskibicki6098 9 ปีที่แล้ว

      +Candace Fernandez I also felt this video was somewhat easier to follow than earlier videos and found it helpful in understanding confidence intervals.

    • @jazzynovy5400
      @jazzynovy5400 8 ปีที่แล้ว

      +Candace Fernandez I liked the color coding too! It made it easier to follow and organizing the calculations.

  • @brittanyvodzak9198
    @brittanyvodzak9198 9 ปีที่แล้ว

    I liked how there was more than one way that you can calculate the 95% Confidence Interval. Even though I thought there were more steps in this video than pervious ones it was still easy to understand.

  • @rosasutton8472
    @rosasutton8472 8 ปีที่แล้ว

    Thoroughly explained and easy to follow and understand.

  • @jazzynovy5400
    @jazzynovy5400 8 ปีที่แล้ว

    Although it seemed as though there was a lot of steps, it was pretty easy to follow. I liked that each of the calculations had it's own color to follow the methods to calculating the confidence interval.

  • @heather7927
    @heather7927 8 ปีที่แล้ว

    I can see where this information is important and can be helpful in research. This information was a little confusing for me to understand. I liked how there is 2 methods of calculating the confidence interval and that the standard error of mean and z score matching 95% alpha is important since any confidence interval can be figured out. I found this helpful.

  • @michelemunday261
    @michelemunday261 8 ปีที่แล้ว

    Great video! Statistics are not my cup of tea, but great to know all this info is here. Thanks Dr. Grande!

  • @sarahburrous7374
    @sarahburrous7374 9 ปีที่แล้ว

    Although there were more steps, I found the first calculation example easier to follow than the second. Both examples make sense and helped me understand this concept.

  • @mandabear52289
    @mandabear52289 9 ปีที่แล้ว

    i think seeing both way of calculating the confidence intervals was helpful in understanding the concepts of confidence intervals. I also thought this video was wasy to follow and understand. I feel confident that i could do this on my own. Great video.

    • @rachelfoster5463
      @rachelfoster5463 9 ปีที่แล้ว

      +Mandy Moore I felt confident with this video as well. It is helpful when Dr. Grande shows us more than one way of doing things.

    • @CandyKaneLane
      @CandyKaneLane 9 ปีที่แล้ว

      +Mandy Moore I agree, having more than one option to calculate the 95% confidence interval was great, it was easy to follow with his instructions, I feel confident in being able to practice this on my own if needed.

  • @cassieperoulis4881
    @cassieperoulis4881 9 ปีที่แล้ว

    This video seemed like another that was easier to grasp. The confidence.norm seems to make the most sense to me and come easiest.

  • @jpincinjr
    @jpincinjr 8 ปีที่แล้ว

    I understood it, but he makes it look so easy... Definitely very thorough, helpful, and useful!

    • @tammywitzke6642
      @tammywitzke6642 8 ปีที่แล้ว

      I agree he does make it look easy, I appreciate the way he breaks down each step making it easy to follow

  • @runner000777
    @runner000777 9 ปีที่แล้ว

    Great video and very easy to follow along. It demonstrated the confidence interval very nicely!

    • @bethanyelstrom3566
      @bethanyelstrom3566 9 ปีที่แล้ว

      +Toniette Morda Agreed! I could use a cheat sheet with all the formulas on it because I know I will never remember them all.

  • @Mjthfdj
    @Mjthfdj 8 ปีที่แล้ว

    This video was descriptive and easy to follow. I enjoyed it.

  • @michellerobinson968
    @michellerobinson968 9 ปีที่แล้ว

    This was easy to follow but there were a lot of steps, formulas, to get to the 95% confidence interval. I liked the different methods shown; CONFIDENCE.NORM and standard error of mean.

    • @brittanyvodzak9198
      @brittanyvodzak9198 9 ปีที่แล้ว

      +Michelle Robinson I agree there were a lot of steps, but it was still easy to follow.

  • @chelseareeve36
    @chelseareeve36 5 ปีที่แล้ว

    Thank you for this video, again, this is easy to digest and explains confidence intervals with relationship to data and calculation.

  • @scottmartin7764
    @scottmartin7764 8 ปีที่แล้ว

    Very easy to follow and understand, thanks for a great video

  • @rachelfoster5463
    @rachelfoster5463 9 ปีที่แล้ว +1

    This video was pretty easy to follow. I felt that I understood what was happening. The only part that seemed difficult would be knowing what formula to use for each one.

    • @kimberlykelly386
      @kimberlykelly386 9 ปีที่แล้ว

      +Rachel Foster I agree, Rachel! I get excited when I grasp what's going on in the video yet far from getting the hang of these formulas and feeling like I could do this on my own.

  • @danielleduboski151
    @danielleduboski151 8 ปีที่แล้ว

    Both methods arrived at the same result, and it will be interesting to see if I prefer one or the other when I need to use them.

  • @carolkirby5869
    @carolkirby5869 8 ปีที่แล้ว

    Thank you for making this so easy to understand.

  • @aliciazahn1718
    @aliciazahn1718 9 ปีที่แล้ว

    I watched the first part of the video trying to recall what the purpose of finding the confidence interval would be. So it's good Dr. Grande explained that we would have 95% confidence of the range the true mean would fall in. Both methods seem to take about the same amount of time and effort so I suppose preference would just depends.

    • @reneemendez4287
      @reneemendez4287 9 ปีที่แล้ว

      +Alicia Zahn I liked the small refresher coupled with new information that Dr. Grande has been using in this playlist. It makes me more confident in learning the new material

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

    Overall good video. BUT why would you include 'extra' terms and data that you don't need, we don't need and only clouds the whole picture? You even said you didn't need some of this. Just a thought.

  • @josievibar3454
    @josievibar3454 5 ปีที่แล้ว

    Thanks for this video, very helpful!

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

    Very knowledgeable

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

    Can you share technique to calculate 5-sigma value of a distribution and how to determine it's confidence level/interval?

  • @cardinalgrad11
    @cardinalgrad11 9 ปีที่แล้ว

    Despite the multiple steps to calculate the confidence.norm and standard error or mean, I feel I have the basic idea. I will have to reference this video in the future.

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

    Thank you very much.

  • @1924Badmonkey
    @1924Badmonkey 6 ปีที่แล้ว

    Thank you again, sir!

  • @aprilbrooks8672
    @aprilbrooks8672 9 ปีที่แล้ว +1

    I prefer the confidence.norm method and after knowing our confidence percent we can set alpha. We can be confident our interval falls between upper and lower limit. It was again east to follow. thanks

    • @katiependergast4145
      @katiependergast4145 9 ปีที่แล้ว

      +April Brooks, I had the same thoughts. Easy to follow, and I'll definitely be using the confidence.norm function if I need to.

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

    Thanks you so much for this video!

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

      You're welcome!

  • @kimberlykelly386
    @kimberlykelly386 9 ปีที่แล้ว

    The standard error of the mean is the SD of the sampling distribution of the mean and it's always smaller than the SD. Formula is SD/square root of the sample.

  • @bethanyelstrom3566
    @bethanyelstrom3566 9 ปีที่แล้ว

    This was a simple process to follow but I would find it more helpful to have a key with the formulas wrote out for reference. Since this is not a standard practice for me as a student, I need something that I can refer back to for reference.

    • @thecorgisquad9861
      @thecorgisquad9861 9 ปีที่แล้ว

      +Bethany Elstrom I, too, would've liked to have a handy reference page with all of the formulas on. It would have helped to solidify these concepts, using this video as a walk-through of them.

    • @michellerobinson968
      @michellerobinson968 9 ปีที่แล้ว

      +Bethany Elstrom I agree a "cheat sheet" or reference sheet would prove helpful. There are many formulas to know.

  • @weixiong2374
    @weixiong2374 8 ปีที่แล้ว

    Thanks, this really helpful. :)

    • @DrGrande
      @DrGrande  8 ปีที่แล้ว

      I'm glad you found the video useful. Thanks for watching.

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

    Thank you!

  • @edv2411
    @edv2411 8 ปีที่แล้ว

    thanks this helped.

    • @DrGrande
      @DrGrande  8 ปีที่แล้ว

      You're welcome.

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

    This is good since the confidence calculated in Excel descriptive statistics is always wrong (larger than the correct by about 15.42% for unknown reasons). You may verify what I claim using the CONFIDENCE(alpha,std_dev,size) function and by 1.95996398454005 times the standard error when alpha = 0.05 i.e. for 95%.

  • @winnieb3324
    @winnieb3324 5 ปีที่แล้ว

    You lost me at the 68% part.