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
Also see the online guide :) toptipbio.com/confidence-intervals-excel/
You've helped me more in 4 minutes than my professor has in 3 hours. Thank you so much!
@adithyachiranjeevi2122
2 жыл бұрын
😂😂
@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
10 ай бұрын
@@queenlulu5161 meet me in my office on Monday🤣🤣🤣
The only video on KZread that explains clearly and completely how to find confidence interval using excel. Thanks a lot.
Fantastically clear and easy to understand video. I have been wanting to know how to do this for so long. Thank you!
I have to agree with everyone, you actually explain what to do and dont waste time! Thank You
Thanks for the refresher. Haven't dealt with stats in a while but this helped me accomplish what I needed to.
Fantastic. What a great way to explain, clear and right to the point. Splendid. Best from Texas.
@StevenBradburn
2 ай бұрын
Cheers Jack
Super helpful, exactly what I needed. Thank you!
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!
It’s really helpful!!! Thanks to you! Keep safe & God bless!!!
This is super useful and will probably save me for the rest of this semester. You are a Godsend. Thank you.
Amazing man you earned yourself a sub and a like for making this guide very simple and understandable, thanks a lot man!
Thank you so much for sharing the Toolpak and Solver add-ins!
Straight to the point. I appreciate that. Cheers mate.
This is a great tutorial. I am so thankful for your help.
Thankyou. Succinctly explained without any confusing extraneous information. The downloaded tool-pack is magic.
Thank you, thank you! You made it SO simple that I was able to complete my quiz within less than 20 minutes!
OMG !! this was super easy , and straight to the point. you are a savior Man. keep posting plz
Thank you so much! This is a HUGE help for my research!!
@StevenBradburn
3 жыл бұрын
Very welcome Elijah. Good luck with your research
amazing help. Keep the great work. Respectfully
You are my guardian excel angel...
Thank you! This helped a lot for my business stats class!
Thank you for the helpful video!
VERY HELPFUL: INFORMATIVE AND TO THE POINT! Thank you for sharing this tip :) You are making lives of academics easier :)
@StevenBradburn
4 жыл бұрын
Glad it was helpful!
LIFESAVER!!! 😩 THANK YOU!!! 👏🏾
This was amazingly helpful, thank you so much!
@StevenBradburn
3 жыл бұрын
Glad it was helpful!
Thank you bro you are a life savior 🙏🏻🙏🏻
Thank you very much!
Easy to understand and follow along!
@StevenBradburn
3 жыл бұрын
Thanks Logan
the most useful 4 minutes in my life
Thank you sooooooo much it was so helpful!
I really appreciate! you helped me a lot
Thank you very much sir for the clear explanation.
thanks a lot its really helpful
Thank You kindly sir great explenation!
Thank you my friend, you saved me from a huge fail on the midterm.
Thank you so much it was very helpful.
@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?
Great! thank you so much
Thank you so much!!
This was so helpful!! Saved me hours
@StevenBradburn
3 жыл бұрын
Glad it helped!
wow thats so helpful
Life saver thank you
You hero, you just saved me hours of agonising over the greek alphabet!
thanks a lot!! really helped
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?
Awesome, thanks
THANK YOU
Great great video man
thank you ❤
thanks a lot, you helped with my homework :)
Lifesaver!!!!
you just saved my life wow
great vid brother
thank you
excellent presentation
lifesaver!
amazing
Thank you
Thank you so much
@StevenBradburn
Жыл бұрын
You're most welcome
perfect
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
what if we need to do a range of values on an x y graph?
You just saved me from failing in my assignment. Thanks to you♥️
@StevenBradburn
3 жыл бұрын
Very welcome. Good luck!
Great presentation but for me, I was looking for how to get the confidence interval for a simple linear regression dataset
thanks a lot, however when im plotting my curve using normal dist.. my %area falling only in between 75%
Will the upper limit and lower limit excel answer be different from manual calculation?
Wow, thank you so much
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
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?
The confidence interval row does not show up on my new worksheet but i see everything else, what am i doing wrong?
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
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
sheeeeeeeeeshhhhhh
My data is spread out over many colums and rows, how do I fix this
how can I calculate uncertainty in excel?
YOU ARE THE FUCKING BEST ON KZread
What is this confidence interval based on? A t-test?
How do you find the confidence level if it’s not given to you?
@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
3 жыл бұрын
@@StevenBradburn thank you
i fucking love u
watched 2023.9.24