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

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

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

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

  • @reneemendez4287
    @reneemendez4287 8 лет назад +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.

  • @thecorgisquad9861
    @thecorgisquad9861 8 лет назад +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 8 лет назад

      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

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

  • @stevieporter3399
    @stevieporter3399 8 лет назад +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.

  • @jacklinskibicki6098
    @jacklinskibicki6098 8 лет назад +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 7 лет назад

    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.

  • @amandachaffin6636
    @amandachaffin6636 8 лет назад

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

      +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.

  • @CandyKaneLane
    @CandyKaneLane 8 лет назад

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

      +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.

  • @michellerobinson968
    @michellerobinson968 8 лет назад

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

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

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

  • @sarahburrous7374
    @sarahburrous7374 8 лет назад

    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.

  • @heather7927
    @heather7927 7 лет назад

    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.

  • @brittanyvodzak9198
    @brittanyvodzak9198 8 лет назад

    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.

  • @rachelfoster5463
    @rachelfoster5463 8 лет назад +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 8 лет назад

      +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.

  • @aliciazahn1718
    @aliciazahn1718 8 лет назад

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

      +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

  • @rosasutton8472
    @rosasutton8472 7 лет назад

    Thoroughly explained and easy to follow and understand.

  • @mandabear52289
    @mandabear52289 8 лет назад

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

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

      +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.

  • @jpincinjr
    @jpincinjr 8 лет назад

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

    • @tammywitzke6642
      @tammywitzke6642 7 лет назад

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

  • @cassieperoulis4881
    @cassieperoulis4881 8 лет назад

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

  • @michelemunday261
    @michelemunday261 7 лет назад

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

  • @danielleduboski151
    @danielleduboski151 7 лет назад

    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.

  • @Mjthfdj
    @Mjthfdj 8 лет назад

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

  • @runner000777
    @runner000777 8 лет назад

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

    • @bethanyelstrom3566
      @bethanyelstrom3566 8 лет назад

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

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

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

  • @aprilbrooks8672
    @aprilbrooks8672 8 лет назад +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 8 лет назад

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

  • @carolkirby5869
    @carolkirby5869 7 лет назад

    Thank you for making this so easy to understand.

  • @scottmartin7764
    @scottmartin7764 7 лет назад

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

  • @kimberlykelly386
    @kimberlykelly386 8 лет назад

    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.

  • @muhammadzeeshan1752
    @muhammadzeeshan1752 Год назад

    Very knowledgeable

  • @cardinalgrad11
    @cardinalgrad11 8 лет назад

    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.

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

    Thanks for this video, very helpful!

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

  • @bethanyelstrom3566
    @bethanyelstrom3566 8 лет назад

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

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

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

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

    Thank you very much.

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

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

  • @1924Badmonkey
    @1924Badmonkey 5 лет назад

    Thank you again, sir!

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

    Thanks you so much for this video!

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

    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%.

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

    Thank you!

  • @edv2411
    @edv2411 8 лет назад

    thanks this helped.

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

    You lost me at the 68% part.

  • @weixiong2374
    @weixiong2374 8 лет назад

    Thanks, this really helpful. :)

    • @DrGrande
      @DrGrande  7 лет назад

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