How to use Excel to Calculate Confidence Interval

  Рет қаралды 803,276

statisticsfun

statisticsfun

Күн бұрын

Пікірлер: 186
@statisticsfun
@statisticsfun 11 жыл бұрын
You are welcome and it is always good to hear that my videos are helpful.
@TheodoreDesipris
@TheodoreDesipris 7 ай бұрын
after looking at like 50 videos, someone finally explains this without all the jargon. Thank you!
@theresawoods7546
@theresawoods7546 9 жыл бұрын
Do not stop what you are doing!! You are awesome! Easy to follow, correct pace, and easy to understand.
@statisticsfun
@statisticsfun 9 жыл бұрын
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
@theresawoods7546 9 жыл бұрын
Sure! Consider it done! Glad you like my music.
@statisticsfun
@statisticsfun 13 жыл бұрын
@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
@statisticsfun 11 жыл бұрын
Students teaching themselves using KZbin and Google is the wave of the future.
@haroldmartis5754
@haroldmartis5754 3 жыл бұрын
hey you weren't wrong 10 years later and all we do is use KZbin and google (thanks for the vid btw)
@eligoldman9200
@eligoldman9200 3 жыл бұрын
turns out the only reason we are teaching ourselves is because our teachers are inept.
@gavin2391
@gavin2391 3 жыл бұрын
like a psychic
@muadiib7562
@muadiib7562 3 жыл бұрын
@@eligoldman9200 YES!!!
@bobfrstcty
@bobfrstcty 3 жыл бұрын
🔥
@statisticsfun
@statisticsfun 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
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
@Ultimatebioweapon 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
You are very welcome. Great to know my videos made in Kansas City, USA are being viewed in Singapore.
@bonnierosenblatt6553
@bonnierosenblatt6553 8 жыл бұрын
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
@OmarBela12 5 жыл бұрын
after three years I still agree with you :)
@statisticsfun
@statisticsfun 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
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
@ingridosborn 11 жыл бұрын
This was excellent (my lecturer just skimmed over this using pivot tables - and an older version of excel). Now it makes sense. Thanks
@elizabethcanali5987
@elizabethcanali5987 8 жыл бұрын
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
@notdonebaking 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
You are very welcome David and good luck in your classes to.
@mariacamargo5488
@mariacamargo5488 5 жыл бұрын
Wow, you have simplified calculating confidence intervals on excel, very helpful video. Thank you!
@statisticsfun
@statisticsfun 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
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
@DoctorXProducer 13 жыл бұрын
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
@statisticsfun 12 жыл бұрын
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
@statisticsfun 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
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
@Khabirah90 Жыл бұрын
Thank you so much for sharing this video!!!!! I really needed the help
@statisticsfun
@statisticsfun 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
Joanna, raising a number to the 1/2 or .5 is the same as taking the square root.
@statisticsfun
@statisticsfun 11 жыл бұрын
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
@statisticsfun 11 жыл бұрын
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
@nstudrgnl6416 3 жыл бұрын
this is such a big help! thanks! but I would like to ask that how to know the formulas and solutions?
@statisticsfun
@statisticsfun 11 жыл бұрын
Great to hear and thanks for your feedback.
@brayancampos-salazar7751
@brayancampos-salazar7751 9 жыл бұрын
Thanks for dedicating your time to make this video possible! Really helpful and easy to catch the idea!
@statisticsfun
@statisticsfun 9 жыл бұрын
+Antony Brayan Campos Salazar You are very welcome! Good luck in your studies too.
@SPLiixD
@SPLiixD 9 жыл бұрын
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
@statisticsfun 9 жыл бұрын
+SPLiixD You are very welcome! I always appreciate hearing that my videos are helping. Good luck in your studies.
@weetbixgirl
@weetbixgirl 8 жыл бұрын
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
@khadidjabakhti7036 7 жыл бұрын
hello, please how you get the graph?
@ajbdtc826
@ajbdtc826 11 жыл бұрын
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
@statisticsfun 12 жыл бұрын
Good to hear! Make sure you like MyBookSucks on FaceBook (see link in the video description).
@statisticsfun
@statisticsfun 11 жыл бұрын
what was your margin of error and what was your confidence coefficient?
@lauralush23
@lauralush23 9 жыл бұрын
Thank you so much for making this tutorial! Very simple and easy to understand! Awesome :)
@lakrishiw
@lakrishiw 9 жыл бұрын
Oh my goodness, you helped me out so much. Thank you so much. This makes everything so much easier.
@statisticsfun
@statisticsfun 9 жыл бұрын
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
@GerardoYllescas-s4q Жыл бұрын
THANK YOU! YOU SAVED MY LIFE !!!!
@wallaceedmondson5638
@wallaceedmondson5638 10 жыл бұрын
Thank you!!!! I really needed that. Great easy to follow explanation(s). Easier than I thought!
@grimmer95rcbhs
@grimmer95rcbhs 8 жыл бұрын
Well done video! As a science student having these simple refresher videos is fantastic.
@blacuraRL
@blacuraRL 12 жыл бұрын
May you live forever my friend, you're THE BEST!
@spottydoggedy3933
@spottydoggedy3933 9 жыл бұрын
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
@statisticsfun 13 жыл бұрын
make sure you hit the = sign first. This indicates that you are going to type in a formula.
@steelefitness
@steelefitness 9 жыл бұрын
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
@statisticsfun 9 жыл бұрын
Eddie Steele Cool thanks
@SarahFroggatt
@SarahFroggatt 12 жыл бұрын
Thank you, excellent and so straight forward. You saved me a huge amount of time.
@StR3tBalKInG
@StR3tBalKInG 8 жыл бұрын
Thanks for the easy step-by-step explanation. Extremely helpful :)
@DavidDuggan2008
@DavidDuggan2008 11 жыл бұрын
A truly great video. This video has helped me massively thank you.
@FabioMafia1
@FabioMafia1 10 жыл бұрын
Thank You! very helpful and easy! :) saved me time trying to figure Excel out.
@statisticsfun
@statisticsfun 11 жыл бұрын
You are very welcome!
@aa695490
@aa695490 9 жыл бұрын
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
@statisticsfun 9 жыл бұрын
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
@statisticsfun 12 жыл бұрын
Thanks for the feedback always good to hear. Make sure to Like MyBookSucks on Facebook if your book sucks.
@gwendolynhoward1653
@gwendolynhoward1653 9 жыл бұрын
Thanks you made learning confidence level in excel SWEET! Got it!
@323Vball
@323Vball 10 жыл бұрын
This helped me a ton with my homework due for my chemistry lab, thank you for sharing!!
@neomaituraganivalu-ravitu555
@neomaituraganivalu-ravitu555 12 жыл бұрын
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
@andujarjj 8 жыл бұрын
thank you! you make it so easy
@grnidmnstr38
@grnidmnstr38 6 жыл бұрын
This seriously saved my life!! Thank you!!
@statisticsfun
@statisticsfun 11 жыл бұрын
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
@dillonredd9682 9 жыл бұрын
How do you find the confidence coefficient?
@TheEjaay
@TheEjaay 7 жыл бұрын
Google it, there's charts for that. Its not something people calculate. 1.96 is the coefficient for 95%.
@laxphones
@laxphones 7 жыл бұрын
you can use the inverse norm function to find it. eg: 95% confidence = invNorm(.025, 0,1) = 1.9599...
@tredbailey
@tredbailey 5 жыл бұрын
@@laxphones Fucking GOAT!!!!!
@toddgarcia9082
@toddgarcia9082 10 жыл бұрын
Do you have a video that shows statistical significance and confidence level in regards to A/B testing?
@rodkersh333
@rodkersh333 9 жыл бұрын
Amazing - words don't describe!!!
@statisticsfun
@statisticsfun 9 жыл бұрын
Rod Kersh Appreciate that. Hopefully you will get a chance to like, share and subscribe to the videos.
@TheLightningcrusader
@TheLightningcrusader 11 жыл бұрын
Omfg dude Im a freshmen from Singapore just wanna say you helped me a lot through this vid thanks man!
@statisticsfun
@statisticsfun 11 жыл бұрын
You could use NORMSINV(probability) and use .95 for probability. That should work.
@Gzus
@Gzus 9 жыл бұрын
How did you determine that the confidence coefficient was 1.96 for a 95% a confidence level?
@statisticsfun
@statisticsfun 9 жыл бұрын
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
@aurorabellful 11 жыл бұрын
Thank you! This really helped with my research data analysis.
@cannon0412
@cannon0412 4 жыл бұрын
how would you find the score from the appropriate probability table to construct a 90% confidence interval in excel?
@crowsmathclass
@crowsmathclass 7 жыл бұрын
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
@FullCircle11 9 жыл бұрын
i was expecting the confidence function tutorial...
@statisticsfun
@statisticsfun 9 жыл бұрын
+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
@eyu2427 9 жыл бұрын
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
@gekko890 8 жыл бұрын
Excellent tutorial - thank you.
@HayleyWilliams92
@HayleyWilliams92 11 жыл бұрын
really helpful! thank you!
@KevinBrewPhD
@KevinBrewPhD 7 жыл бұрын
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
@KPUgirl2 11 жыл бұрын
how did you get .5 for the square root in the margin of error formula at time stamp 3:07 in the video?
@gamermanforthewin007
@gamermanforthewin007 6 жыл бұрын
Honestly great video!
@nidiathies2468
@nidiathies2468 4 жыл бұрын
Thank you so much!! So helpful :)
@bowchicabowwow467
@bowchicabowwow467 7 жыл бұрын
Why did this teach me statistics so quickly LOL it all makes sense now haha
@stefankazakov62
@stefankazakov62 8 жыл бұрын
very nice explained
@firassami7399
@firassami7399 5 жыл бұрын
is there any method to finde confidence interval for ala data set not only the mean as you have done
@givingjane
@givingjane 13 жыл бұрын
Yeah, statistics! Love this stuff.
@lisagibbs2975
@lisagibbs2975 6 жыл бұрын
wow!!!! you make that look so easy
@TheKriss12345
@TheKriss12345 13 жыл бұрын
Simple explanation.. Perfect !!! Thank you :)
@bredleemurray904
@bredleemurray904 9 жыл бұрын
Is it possible to calculate the confidence interval for discrete data?
@valeriemullins9427
@valeriemullins9427 7 жыл бұрын
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
@phistina35 9 жыл бұрын
this was great! thank you! very helpful with my stats homework!
@AstronomicalTruzz
@AstronomicalTruzz 10 жыл бұрын
just an 8th grade kid tryin to get extra credit using margin of error and damn this is helpful!!
@themanager1980
@themanager1980 11 жыл бұрын
Man I respect you cuz you do it in a very simple way that even stupids can understand.
@hirschfeld90
@hirschfeld90 13 жыл бұрын
excellent video, thank you
@madonnacullinan8286
@madonnacullinan8286 10 жыл бұрын
Very helpful - thank you Mr Statatisticsfun from Brisbane Australia
@saritasi7819
@saritasi7819 9 жыл бұрын
thank you sir, you are a life saver
@statisticsfun
@statisticsfun 9 жыл бұрын
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
@vepris143 11 жыл бұрын
Thank you for video! Really helpfull.
@124leahgaines
@124leahgaines 10 жыл бұрын
Thanks really helped me out of a jam quick!
@IgorMeshcheriakov
@IgorMeshcheriakov 9 жыл бұрын
Really helpful, thank you very much!
@PhilFresh22
@PhilFresh22 12 жыл бұрын
wasted 2 days trying to teach myself this when i should of came here... thanks a bunch!
@statisticsfun
@statisticsfun 11 жыл бұрын
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
@reemninefour7978 11 жыл бұрын
what if you only have n and m and no samples? how do I get stdevA?
@davide290
@davide290 13 жыл бұрын
good, can you show how to graph the confidence interval ??
@MrTdoug57
@MrTdoug57 9 жыл бұрын
Can you please help me understand what confidence limit is? is that just both the upper and lower limits?
@statisticsfun
@statisticsfun 9 жыл бұрын
+Tevin Douglas I have several videos on confidence levels. In fact, I have an entire playlist. kzbin.info/aero/PL36B51DB57E3A3E8E
@yellowone1994
@yellowone1994 11 жыл бұрын
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
@sheepisfortheweak6164 7 жыл бұрын
How do I know wether I should use minus or plus in the formula?
@brooklinwhite3539
@brooklinwhite3539 6 жыл бұрын
This is awesome, thank you.
How to Calculate ANOVA with Excel (Analysis of Variance)
15:12
statisticsfun
Рет қаралды 464 М.
Family Love #funny #sigma
00:16
CRAZY GREAPA
Рет қаралды 16 МЛН
这是自救的好办法 #路飞#海贼王
00:43
路飞与唐舞桐
Рет қаралды 60 МЛН
Smart Sigma Kid #funny #sigma
00:14
CRAZY GREAPA
Рет қаралды 87 МЛН
How To Find The Z Score, Confidence Interval, and Margin of Error for a Population Mean
20:35
The Organic Chemistry Tutor
Рет қаралды 1,1 МЛН
How To...Calculate the Confidence Interval for a Sample
6:59
Eugene O'Loughlin
Рет қаралды 598 М.
Confidence Interval Estimation Using Excel's Data Analysis Tool
7:30
Learn Something
Рет қаралды 28 М.
How to calculate  margin of error and standard deviation
6:42
statisticsfun
Рет қаралды 37 М.
Excel Solver & Goal Seek Tutorial
23:34
Kevin Stratvert
Рет қаралды 173 М.
INDEX MATCH Excel Tutorial
15:29
Kevin Stratvert
Рет қаралды 425 М.
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 274 М.
Formulas in Excel | Excel Tutorials for Beginners
33:54
Alex The Analyst
Рет қаралды 383 М.
Family Love #funny #sigma
00:16
CRAZY GREAPA
Рет қаралды 16 МЛН