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

[@vloch]

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]

You're welcome!

[@reneemendez4287]

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]

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

[@stevieporter3399]

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

[@jpincinjr]

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

[@thecorgisquad9861]

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]

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

[@jacklinskibicki6098]

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.

[@amandachaffin6636]

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]

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

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]

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

[@jazzynovy5400]

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

[@kyarapanula1002]

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.

[@jazzynovy5400]

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.

[@michellerobinson968]

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]

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

[@sarahburrous7374]

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.

[@rosasutton8472]

Thoroughly explained and easy to follow and understand.

[@cassieperoulis4881]

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

[@brittanyvodzak9198]

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.

[@mandabear52289]

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]

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

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

[@rachelfoster5463]

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]

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

[@heather7927]

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.

[@jpincinjr]

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

[@tammywitzke6642]

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

[@michelemunday261]

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

[@danielleduboski151]

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.

[@chelseareeve36]

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

[@Mjthfdj]

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

[@aliciazahn1718]

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]

+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

[@runner000777]

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

[@bethanyelstrom3566]

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

[@carolkirby5869]

Thank you for making this so easy to understand.

[@scottmartin7764]

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

[@muhammadzeeshan1752]

Very knowledgeable

[@adamholt6898]

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.

[@aprilbrooks8672]

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]

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

[@kimberlykelly386]

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.

[@cardinalgrad11]

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.

[@AnandGanesann]

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

[@samxdavidson]

Thank you very much.

[@josievibar3454]

Thanks for this video, very helpful!

[@bethanyelstrom3566]

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]

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

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

[@1924Badmonkey]

Thank you again, sir!

[@benjamindavidson5760]

Thanks you so much for this video!

[@DrGrande]

You're welcome!

[@MSKTLIZ]

Thank you!

[@edv2411]

thanks this helped.

[@DrGrande]

You're welcome.

[@fahmylina123]

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]

You lost me at the 68% part.

[@weixiong2374]

Thanks, this really helpful. :)

[@DrGrande]

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