How To Calculate Confidence Intervals In Excel

Тәжірибелік нұсқаулар және стиль

In this video, I will show you how to calculate the lower and upper confidence intervals (CIs) by using Microsoft Excel.
In this example, I will show you how to calculate the 95% CI of some data by using the Data Analysis add-in.
THE ONLINE GUIDE
toptipbio.com/confidence-inte...
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Laptop amzn.to/38bB7JG
Microphone amzn.to/2OFn1sd
Screen recorder & editor techsmith.z6rjha.net/BQQkL
KZread SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Top Tip Bio is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com. We will earn a commission from Amazon if a purchase is made through the affiliate links.

Пікірлер: 96

  • @StevenBradburn
    @StevenBradburn4 жыл бұрын

    Also see the online guide :) toptipbio.com/confidence-intervals-excel/

  • @catherinehall7347
    @catherinehall73474 жыл бұрын

    You've helped me more in 4 minutes than my professor has in 3 hours. Thank you so much!

  • @adithyachiranjeevi2122

    @adithyachiranjeevi2122

    2 жыл бұрын

    😂😂

  • @queenlulu5161

    @queenlulu5161

    Жыл бұрын

    you are not lying about that Catherine. This is exactly how I am feeling right now with my professor no help what so ever.

  • @RockWhisperer577

    @RockWhisperer577

    10 ай бұрын

    @@queenlulu5161 meet me in my office on Monday🤣🤣🤣

  • @NewAmericanLegend
    @NewAmericanLegend3 жыл бұрын

    The only video on KZread that explains clearly and completely how to find confidence interval using excel. Thanks a lot.

  • @davidwill5347
    @davidwill53473 жыл бұрын

    Fantastically clear and easy to understand video. I have been wanting to know how to do this for so long. Thank you!

  • @woeiswilliam1442
    @woeiswilliam14422 жыл бұрын

    I have to agree with everyone, you actually explain what to do and dont waste time! Thank You

  • @cefilmer
    @cefilmer2 жыл бұрын

    Thanks for the refresher. Haven't dealt with stats in a while but this helped me accomplish what I needed to.

  • @jackj.4304
    @jackj.43042 ай бұрын

    Fantastic. What a great way to explain, clear and right to the point. Splendid. Best from Texas.

  • @StevenBradburn

    @StevenBradburn

    2 ай бұрын

    Cheers Jack

  • @user-cv2uf1yy1f
    @user-cv2uf1yy1f2 жыл бұрын

    Super helpful, exactly what I needed. Thank you!

  • @ericarchuleta2124
    @ericarchuleta21243 жыл бұрын

    I want you to know you saved me today with this information what was taking me 2 hrs trying to figure out took only minutes of your explanation thank you!

  • @montillabambooy.4385
    @montillabambooy.43853 жыл бұрын

    It’s really helpful!!! Thanks to you! Keep safe & God bless!!!

  • @theparagon1464
    @theparagon14649 ай бұрын

    This is super useful and will probably save me for the rest of this semester. You are a Godsend. Thank you.

  • @sd4prodigy967
    @sd4prodigy9673 жыл бұрын

    Amazing man you earned yourself a sub and a like for making this guide very simple and understandable, thanks a lot man!

  • @SilviaTapia-iq2qf
    @SilviaTapia-iq2qf Жыл бұрын

    Thank you so much for sharing the Toolpak and Solver add-ins!

  • @srujan00
    @srujan00 Жыл бұрын

    Straight to the point. I appreciate that. Cheers mate.

  • @ismarienidperezvelez1940
    @ismarienidperezvelez19403 жыл бұрын

    This is a great tutorial. I am so thankful for your help.

  • @stevenroberts426
    @stevenroberts4262 жыл бұрын

    Thankyou. Succinctly explained without any confusing extraneous information. The downloaded tool-pack is magic.

  • @evelynvargas2954
    @evelynvargas2954 Жыл бұрын

    Thank you, thank you! You made it SO simple that I was able to complete my quiz within less than 20 minutes!

  • @rush2940
    @rush2940 Жыл бұрын

    OMG !! this was super easy , and straight to the point. you are a savior Man. keep posting plz

  • @elijuwon4121
    @elijuwon41213 жыл бұрын

    Thank you so much! This is a HUGE help for my research!!

  • @StevenBradburn

    @StevenBradburn

    3 жыл бұрын

    Very welcome Elijah. Good luck with your research

  • @alexvasilev1834
    @alexvasilev18344 жыл бұрын

    amazing help. Keep the great work. Respectfully

  • @mervetrkylmz
    @mervetrkylmz3 жыл бұрын

    You are my guardian excel angel...

  • @laurenkelly9811
    @laurenkelly98117 ай бұрын

    Thank you! This helped a lot for my business stats class!

  • @jessicaneamtu9053
    @jessicaneamtu90534 ай бұрын

    Thank you for the helpful video!

  • @haithamshoman5758
    @haithamshoman57584 жыл бұрын

    VERY HELPFUL: INFORMATIVE AND TO THE POINT! Thank you for sharing this tip :) You are making lives of academics easier :)

  • @StevenBradburn

    @StevenBradburn

    4 жыл бұрын

    Glad it was helpful!

  • @shawntam.3988
    @shawntam.39883 жыл бұрын

    LIFESAVER!!! 😩 THANK YOU!!! 👏🏾

  • @nononoemma
    @nononoemma3 жыл бұрын

    This was amazingly helpful, thank you so much!

  • @StevenBradburn

    @StevenBradburn

    3 жыл бұрын

    Glad it was helpful!

  • @deepanshukataria8892
    @deepanshukataria8892 Жыл бұрын

    Thank you bro you are a life savior 🙏🏻🙏🏻

  • @amenaza2798
    @amenaza2798 Жыл бұрын

    Thank you very much!

  • @loganthomas7564
    @loganthomas75643 жыл бұрын

    Easy to understand and follow along!

  • @StevenBradburn

    @StevenBradburn

    3 жыл бұрын

    Thanks Logan

  • @aongocnganha2246
    @aongocnganha22462 жыл бұрын

    the most useful 4 minutes in my life

  • @cinkod
    @cinkod2 жыл бұрын

    Thank you sooooooo much it was so helpful!

  • @rodrigoramone7526
    @rodrigoramone75262 жыл бұрын

    I really appreciate! you helped me a lot

  • @MsKeerthik
    @MsKeerthik Жыл бұрын

    Thank you very much sir for the clear explanation.

  • @kalyaniskitchen7366
    @kalyaniskitchen7366 Жыл бұрын

    thanks a lot its really helpful

  • @annapecuch1141
    @annapecuch11413 жыл бұрын

    Thank You kindly sir great explenation!

  • @adamkuripla4741
    @adamkuripla47412 жыл бұрын

    Thank you my friend, you saved me from a huge fail on the midterm.

  • @thetrustedteamutah822
    @thetrustedteamutah8224 жыл бұрын

    Thank you so much it was very helpful.

  • @MenesesSophia

    @MenesesSophia

    4 жыл бұрын

    I can't to to excel and go to ‘File>Options‘ and select the ‘Add-ins‘ option in the menu. Is it because I have to upgrade?

  • @laurenurban5247
    @laurenurban52473 жыл бұрын

    Great! thank you so much

  • @roshaneshannon9308
    @roshaneshannon93082 жыл бұрын

    Thank you so much!!

  • @rileymaitland5022
    @rileymaitland50223 жыл бұрын

    This was so helpful!! Saved me hours

  • @StevenBradburn

    @StevenBradburn

    3 жыл бұрын

    Glad it helped!

  • @via8345
    @via8345Ай бұрын

    wow thats so helpful

  • @NamNguyen-ud3jh
    @NamNguyen-ud3jh Жыл бұрын

    Life saver thank you

  • @gingerwelshone
    @gingerwelshone3 жыл бұрын

    You hero, you just saved me hours of agonising over the greek alphabet!

  • @katmango954
    @katmango9542 жыл бұрын

    thanks a lot!! really helped

  • @itpan8903
    @itpan89033 жыл бұрын

    hi thank you very much for this useful video. by the way I have a questions, the ordinate is the mean value of samples or the total value of sample data if I want to add 95% confidence interval to the graph?

  • @teociberneticul7803
    @teociberneticul78032 жыл бұрын

    Awesome, thanks

  • @daniellad7478
    @daniellad747810 ай бұрын

    THANK YOU

  • @motherland_folklores
    @motherland_folklores3 жыл бұрын

    Great great video man

  • @nurseish882
    @nurseish88210 ай бұрын

    thank you ❤

  • @stefanantonic253
    @stefanantonic253 Жыл бұрын

    thanks a lot, you helped with my homework :)

  • @dmozay8355
    @dmozay8355 Жыл бұрын

    Lifesaver!!!!

  • @LieutenantWafflesX
    @LieutenantWafflesX3 жыл бұрын

    you just saved my life wow

  • @tylertorsiello8450
    @tylertorsiello84502 жыл бұрын

    great vid brother

  • @ophthojooeileyecirclehisha4917
    @ophthojooeileyecirclehisha4917 Жыл бұрын

    thank you

  • @salahalshayeb534
    @salahalshayeb5343 жыл бұрын

    excellent presentation

  • @unnamedexodus3902
    @unnamedexodus39022 жыл бұрын

    lifesaver!

  • @chaeryeong1194
    @chaeryeong11942 ай бұрын

    amazing

  • @tomstieve
    @tomstieve2 жыл бұрын

    Thank you

  • @ophthojooeileyecirclehisha4917
    @ophthojooeileyecirclehisha4917 Жыл бұрын

    Thank you so much

  • @StevenBradburn

    @StevenBradburn

    Жыл бұрын

    You're most welcome

  • @nasermohammadzadeh9848
    @nasermohammadzadeh9848 Жыл бұрын

    perfect

  • @WallStWarLord
    @WallStWarLord2 жыл бұрын

    May I please inquire as to whether you can provide the step-by-step directions and instructions as to how to create this same live Confidence Intervals in Excel...and more specifically with the use of Microsoft Excel RTD/Real-Time Edition...and whereas I am seeking to establish a realtime stock market DDE/dynamic link and whereby an array of stock market exchange tick-by-tick trades are constantly and instantly updated autonomically/automatically these Confidence Interval Calculations @ ultra high-frequency....Thank you

  • @phillcom3
    @phillcom32 жыл бұрын

    what if we need to do a range of values on an x y graph?

  • @Srishti061
    @Srishti0613 жыл бұрын

    You just saved me from failing in my assignment. Thanks to you♥️

  • @StevenBradburn

    @StevenBradburn

    3 жыл бұрын

    Very welcome. Good luck!

  • @davidkariuki3967
    @davidkariuki39672 жыл бұрын

    Great presentation but for me, I was looking for how to get the confidence interval for a simple linear regression dataset

  • @abetguerzon1939
    @abetguerzon1939 Жыл бұрын

    thanks a lot, however when im plotting my curve using normal dist.. my %area falling only in between 75%

  • @chanyanyu2298
    @chanyanyu22982 жыл бұрын

    Will the upper limit and lower limit excel answer be different from manual calculation?

  • @Koby35
    @Koby353 жыл бұрын

    Wow, thank you so much

  • @hollyhermann-sorensen5974
    @hollyhermann-sorensen59744 жыл бұрын

    Hello, thank you for this video. I have not taken a math class in many years and am attempting to find the 95% CI for an equation of a line. The line is a power function, in the form of Y=aX^b. I am really unsure how to do this. I understand what you've done in this video but am wondering whether I need to obtain the CI for the x-values or the y-values. If you could provide any help I would greatly appreciate it!

  • @StevenBradburn

    @StevenBradburn

    4 жыл бұрын

    Hi Holly. I have never done this before, so I am probably not the best person to advise. But I did find this resource: stattrek.com/regression/slope-confidence-interval.aspx That may help?

  • @jaslinjose8172
    @jaslinjose8172 Жыл бұрын

    The confidence interval row does not show up on my new worksheet but i see everything else, what am i doing wrong?

  • @zeeshanqasim8925
    @zeeshanqasim89253 жыл бұрын

    Hy sir, in research studies, some tables have values like this, 19± 0.02, 13± 0.03, so how we get these values. can you please explain? thank you

  • @StevenBradburn

    @StevenBradburn

    3 жыл бұрын

    Hi Zeeshan, So that looks like they are either standard deviation (SD) or standard error of the mean (SEM) values. You can check out my other tutorial to see how to do this in Excel: kzread.info/dash/bejne/ZW1-prBucrGrepM.html Thanks! Steven

  • @tadehhaghverdyan2832
    @tadehhaghverdyan28323 жыл бұрын

    sheeeeeeeeeshhhhhh

  • @christianpage2990
    @christianpage29902 жыл бұрын

    My data is spread out over many colums and rows, how do I fix this

  • @nasermohammadzadeh9848
    @nasermohammadzadeh98487 ай бұрын

    how can I calculate uncertainty in excel?

  • @FTOD23
    @FTOD232 жыл бұрын

    YOU ARE THE FUCKING BEST ON KZread

  • @LuisSantiago-xo4fm
    @LuisSantiago-xo4fm8 ай бұрын

    What is this confidence interval based on? A t-test?

  • @Gmoney00718
    @Gmoney007183 жыл бұрын

    How do you find the confidence level if it’s not given to you?

  • @StevenBradburn

    @StevenBradburn

    3 жыл бұрын

    Most of the time this is 95% when the alpha level is 0.05. So, people will use a P value of 0.05 to indicate significance

  • @Gmoney00718

    @Gmoney00718

    3 жыл бұрын

    @@StevenBradburn thank you

  • @bigger3968
    @bigger39683 жыл бұрын

    i fucking love u

  • @user-zj7cr2pg7c
    @user-zj7cr2pg7c10 ай бұрын

    watched 2023.9.24

Келесі