How to use Excel to Calculate Confidence Interval

Tutorial on using Microsoft Excel to determine confidence internals, margin of error, range, max, min and margin of error

Playlist on Confidence Intervals

Related Videos:
How to Read A Normalized Table (for z scores).

David Longstreet Professor of the Universe

MyBookSucks.Com

[TheodoreDesipris]

after looking at like 50 videos, someone finally explains this without all the jargon. Thank you!

[statisticsfun]

You are welcome and it is always good to hear that my videos are helpful.

[statisticsfun]

Mariah, great to hear my videos are helping with your research course. Let me know if there are any topics that I should add to my channel.

[statisticsfun]

@injumah That is a great question! I will create a video for you and explain it. In the mean time, the confidence coefficient used is 1.96 which is a z score. This is the z score for a two tail test with 2.5% in the two tails. 2.5 x 2 = 5%. I have a bunch of videos (playlist) on z scores and normalized tables too.

[theresawoods]

Do not stop what you are doing!!  You are awesome!  Easy to follow, correct pace, and easy to understand.

[statisticsfun]

Great to hear that I saved you hours.

Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos and avoid hours of frustration too.

[statisticsfun]

You are very welcome. Great to know my videos made in Kansas City, USA are being viewed in Singapore.

[notdonebaking]

This makes so much more sense than how it's explained in my psycholing class. Thank you so much, you have saved me hours of frustration!

[statisticsfun]

Good question David.. the 1.96 represents a 95% confidence level. This number comes from the normalized table (probably in the back of your statistics books. I just added a link to a video on that in this videos description. Youtube does not allow me to add links in the comments.

[Ultimatebioweapon]

Thanks for this. I always find myself forgetting how to do simple statistics and videos like this make it simple to remember them. Keep up the good work!

[ingridosborn]

This was excellent (my lecturer just skimmed over this using pivot tables - and an older version of excel). Now it makes sense. Thanks

[DoctorXProducer]

Thank you very much, sir...my statistician flaked out on me, so you just taught me how to do it all on Excel myself. Thanks again for your solid video!

[statisticsfun]

Students teaching themselves using Youtube and Google is the wave of the future.

[statisticsfun]

You are very welcome David and good luck in your classes to.

[statisticsfun]

Great to hear! It is exciting to see that my videos are making it all the way to New Zealand. I have never been to New Zealand, but it looks like a beautiful place (great wine too).

Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos.

[statisticsfun]

STV.P is for population and STV.S is for samples. If you are working with samples use STV.S and STV.P if you are working with a population.

[mariacamargo]

Wow, you have simplified calculating confidence intervals on excel, very helpful video. Thank you!

[ajbdtc]

That's no joke. This is my second stats course that's going to end up being taught by google + youtube more than my school. Thanks!

[elizabethcanali]

This video was GREAT! Thank you, I had a paper that was due and this saved my paper. You explain very clearly and your voice is easy to follow.

[statisticsfun]

Not necessarily, you can calculate a confidence interval using a sample and then estimate the population average from that confidence interval. In other words, you take a sample calculate the confidence interval and conclude with 95% level of confidence the population average is within that confidence interval.