How to use Excel to Calculate Confidence Interval

[@statisticsfun]

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

[@TheodoreDesipris]

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

[@theresawoods7546]

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

[@statisticsfun]

Theresa Woods Thanks for that Theresa. I don't have any plans to stop. I checked out your channel and you sing my type of music. You are awesome!! Hopefully my videos can help you "sing more and study less" Hopefully you will like, share, subscribe, If you get a chance could you please like our FB page. www.FaceBook.Com/PartyMoreStudyLess It will help others find the videos. Good luck in your studies too.

[@theresawoods7546]

Sure! Consider it done! Glad you like my music.

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

[@statisticsfun]

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

[@haroldmartis5754]

hey you weren't wrong 10 years later and all we do is use KZbin and google (thanks for the vid btw)

[@eligoldman9200]

turns out the only reason we are teaching ourselves is because our teachers are inept.

[@gavin2391]

like a psychic

[@muadiib7562]

@@eligoldman9200 YES!!!

[@bobfrstcty]

🔥

[@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. KZbin does not allow me to add links in the comments.

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

[@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!

[@statisticsfun]

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

[@bonnierosenblatt6553]

The symbol sigma stands for population standard deviation, but sample standard deviation was computed. The critical value of 1.96 is used when you have a normal distribution and the population standard deviation, sigma, is known. There is a discrepancy here.

[@OmarBela12]

after three years I still agree with you :)

[@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]

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.

[@ingridosborn]

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

[@elizabethcanali5987]

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.

[@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]

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

[@mariacamargo5488]

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

[@statisticsfun]

Happy to hear that my videos are helping you learn. Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos.

[@statisticsfun]

Great to hear and appreciate the feedback. Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos.

[@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]

Z scores and t scores are very similar. Watch my video "How to calculate t distributions" In fact as sample sizes get large the table are identical. t scores are used when you don't know the population standard deviation. If you look at the 95% confidence level with a sample size of 120 or more and then the z score table (normalized table) the value is 1.96 for both tables.

[@statisticsfun]

You are very welcome, indeed! Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos.

[@statisticsfun]

Thanks for the compliment. It is much appreciated. If you not done so yet, make sure you like MyBookSucks on Facebook (see link in video description). This will help others find the educational videos.

[@Khabirah90]

Thank you so much for sharing this video!!!!! I really needed the help

[@statisticsfun]

Thank you for the compliment it is much appreciated. Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos.

[@statisticsfun]

Joanna, raising a number to the 1/2 or .5 is the same as taking the square root.

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

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

[@nstudrgnl6416]

this is such a big help! thanks! but I would like to ask that how to know the formulas and solutions?

[@statisticsfun]

Great to hear and thanks for your feedback.

[@brayancampos-salazar7751]

Thanks for dedicating your time to make this video possible! Really helpful and easy to catch the idea!

[@statisticsfun]

+Antony Brayan Campos Salazar You are very welcome! Good luck in your studies too.

[@SPLiixD]

Thank you so much. I had anxiety about not being able to complete my lab report in time but this helped so much, thank you!

[@statisticsfun]

+SPLiixD You are very welcome! I always appreciate hearing that my videos are helping. Good luck in your studies.

[@weetbixgirl]

Thanks heaps, Ive got a stage 2 psych lab report due in 3hrs and have left the graph to the last minute lol....very clear and concise! Great stuff ;)

[@khadidjabakhti7036]

hello, please how you get the graph?

[@ajbdtc826]

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!

[@statisticsfun]

Good to hear! Make sure you like MyBookSucks on FaceBook (see link in the video description).

[@statisticsfun]

what was your margin of error and what was your confidence coefficient?

[@lauralush23]

Thank you so much for making this tutorial! Very simple and easy to understand! Awesome :)

[@lakrishiw]

Oh my goodness, you helped me out so much. Thank you so much. This makes everything so much easier.

[@statisticsfun]

lakrishiw You are very welcome. You are very welcome. Hopefully, you will get a chance to like and share the videos and like the MyBookSucks FB page (www.FaceBook.Com/PartyMoreStudyLess). This will help others find the videos. Good luck in your classes too.

[@GerardoYllescas-s4q]

THANK YOU! YOU SAVED MY LIFE !!!!

[@wallaceedmondson5638]

Thank you!!!! I really needed that. Great easy to follow explanation(s). Easier than I thought!

[@grimmer95rcbhs]

Well done video! As a science student having these simple refresher videos is fantastic.

[@blacuraRL]

May you live forever my friend, you're THE BEST!

[@spottydoggedy3933]

Thanks so much. Can improve the method by using the Name Manager to name the data range= DATA, then no way to make an error in the functions and new data is easily inserted into the data set as needed.

[@statisticsfun]

make sure you hit the = sign first. This indicates that you are going to type in a formula.

[@steelefitness]

You are amazing. Thank you for taking the time to posthaste videos and I will like you on Facebook asap. Please keep them coming.

[@statisticsfun]

Eddie Steele Cool thanks

[@SarahFroggatt]

Thank you, excellent and so straight forward. You saved me a huge amount of time.

[@StR3tBalKInG]

Thanks for the easy step-by-step explanation. Extremely helpful :)

[@DavidDuggan2008]

A truly great video. This video has helped me massively thank you.

[@FabioMafia1]

Thank You! very helpful and easy! :) saved me time trying to figure Excel out.

[@statisticsfun]

You are very welcome!

[@aa695490]

Thanks , it is very helpful. Could you help with a similar one on how to calculate confidence intervals for the geometric mean? Excel has a function for GM , but I need to have the confidence interval. Thanks in advance for your support.

[@statisticsfun]

Ahmed Adeel Good suggestion. I will do my best to add a video on geometric mean. It may be useful to compare and contrast the geometric mean with the arithmetic mean.

[@statisticsfun]

Thanks for the feedback always good to hear. Make sure to Like MyBookSucks on Facebook if your book sucks.

[@gwendolynhoward1653]

Thanks you made learning confidence level in excel SWEET! Got it!

[@323Vball]

This helped me a ton with my homework due for my chemistry lab, thank you for sharing!!

[@neomaituraganivalu-ravitu555]

Thank you statisticsfun! One minor question is the Confidence Coefficient also referred to as T-critical value from T-tables?(whereby we find our degree of freedom first and with the confidence level say 95% we find this on the table?)

[@andujarjj]

thank you! you make it so easy

[@grnidmnstr38]

This seriously saved my life!! Thank you!!

[@statisticsfun]

It looks like the solution is using 2.53 as it's confidence coefficient which would make this 98.8 or just about 99% confidence.

[@dillonredd9682]

How do you find the confidence coefficient?

[@TheEjaay]

Google it, there's charts for that. Its not something people calculate. 1.96 is the coefficient for 95%.

[@laxphones]

you can use the inverse norm function to find it. eg: 95% confidence = invNorm(.025, 0,1) = 1.9599...

[@tredbailey]

@@laxphones Fucking GOAT!!!!!

[@toddgarcia9082]

Do you have a video that shows statistical significance and confidence level in regards to A/B testing?

[@rodkersh333]

Amazing - words don't describe!!!

[@statisticsfun]

Rod Kersh Appreciate that. Hopefully you will get a chance to like, share and subscribe to the videos.

[@TheLightningcrusader]

Omfg dude Im a freshmen from Singapore just wanna say you helped me a lot through this vid thanks man!

[@statisticsfun]

You could use NORMSINV(probability) and use .95 for probability. That should work.

[@Gzus]

How did you determine that the confidence coefficient was 1.96 for a 95% a confidence level?

[@statisticsfun]

Gzus That is the standard coefficient for 95% confidence level. You can see a video on the topic (normalized table) where I explain how 1.96 is determined. kzbin.info/www/bejne/mojYYX6Cjdp4pqM

[@aurorabellful]

Thank you! This really helped with my research data analysis.

[@cannon0412]

how would you find the score from the appropriate probability table to construct a 90% confidence interval in excel?

[@crowsmathclass]

This is incorrect. You calculated the sample standard deviation. So sigma is unknown. Therefore, you should calculate your confidence coefficient using the Student's t-distribution, not the standard normal distribution.

[@FullCircle11]

i was expecting the confidence function tutorial...

[@statisticsfun]

+Space Cadet 1211 Here is a link to a playlist on confidence intervals. Hope this helps you get the video you are looking for. kzbin.info/aero/PL36B51DB57E3A3E8E

[@eyu2427]

do you have a problem for two set of numbers? what if ask 95% confidence interval for mean of the change in between two set of number?

[@gekko890]

Excellent tutorial - thank you.

[@HayleyWilliams92]

really helpful! thank you!

[@KevinBrewPhD]

According to the T-distribution (en.wikipedia.org/wiki/Student's_t-distribution), you only have 8 samples; would not one use 2.365 for the confidence coefficient because you have 7 degrees of freedom (n-1)?

[@KPUgirl2]

how did you get .5 for the square root in the margin of error formula at time stamp 3:07 in the video?

[@gamermanforthewin007]

Honestly great video!

[@nidiathies2468]

Thank you so much!! So helpful :)

[@bowchicabowwow467]

Why did this teach me statistics so quickly LOL it all makes sense now haha

[@stefankazakov62]

very nice explained

[@firassami7399]

is there any method to finde confidence interval for ala data set not only the mean as you have done

[@givingjane]

Yeah, statistics! Love this stuff.

[@lisagibbs2975]

wow!!!! you make that look so easy

[@TheKriss12345]

Simple explanation.. Perfect !!! Thank you :)

[@bredleemurray904]

Is it possible to calculate the confidence interval for discrete data?

[@valeriemullins9427]

you are given a sample consisting of 83 data points with a sample mean of 37 and a sample standard deviation of 21. Construct a 90% confidence interval for the true mean.

[@phistina35]

this was great! thank you! very helpful with my stats homework!

[@AstronomicalTruzz]

just an 8th grade kid tryin to get extra credit using margin of error and damn this is helpful!!

[@themanager1980]

Man I respect you cuz you do it in a very simple way that even stupids can understand.

[@hirschfeld90]

excellent video, thank you

[@madonnacullinan8286]

Very helpful - thank you Mr Statatisticsfun from Brisbane Australia

[@saritasi7819]

thank you sir, you are a life saver

[@statisticsfun]

fatina 미나 Happy to save your life :) good luck in your studies. Hopefully, you will like, share and subscribe. It will help others find the videos.

[@vepris143]

Thank you for video! Really helpfull.

[@124leahgaines]

Thanks really helped me out of a jam quick!

[@IgorMeshcheriakov]

Really helpful, thank you very much!

[@PhilFresh22]

wasted 2 days trying to teach myself this when i should of came here... thanks a bunch!

[@statisticsfun]

Don't sell yourself short. Statistics is typically taught poorly and the book sucks too -- hence, MyBookSucks Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos.

[@reemninefour7978]

what if you only have n and m and no samples? how do I get stdevA?

[@davide290]

good, can you show how to graph the confidence interval ??

[@MrTdoug57]

Can you please help me understand what confidence limit is? is that just both the upper and lower limits?

[@statisticsfun]

+Tevin Douglas I have several videos on confidence levels. In fact, I have an entire playlist. kzbin.info/aero/PL36B51DB57E3A3E8E

[@yellowone1994]

Thanks for this. I am using an online homework tool for my class and this is the problem mean=110 s=10 CI=98% n=22 I came up with: Lower Bound =105 Upper Bound = 114.9 However, I got these wrong when I entered these answers. The "correct answers" are: Lower Bound =104.6 Upper Bound =115.4 Do you have any idea how to get these answers? Thanks so much.

[@sheepisfortheweak6164]

How do I know wether I should use minus or plus in the formula?

[@brooklinwhite3539]

This is awesome, thank you.