Variance and Standard Deviation With Microsoft Excel - Descriptive Statistics
Вставка
- Опубліковано 2 жов 2024
- This descriptive statistics video tutorial explains how to calculate the sample variance and sample standard deviation using a table and using microsoft excel. It also explains how to calculate variance and standard deviation using frequency given a list of repetitive data values.
Statistics Formula Sheet:
bit.ly/47zjTVT
Excel Tutorial For Beginners:
• Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
Excel - Statistics - Mean, Median, Mode:
• Statistics - Excel
Excel Scatter Charts:
• How To Make a X Y Scat...
Excel - Finding Slope & Y-Intercept:
• Excel Basics - Linear ...
Solving Polynomial Equations - Goal Seek:
• Solving Polynomial Equ...
__________________________________________
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
_________________________________________
UA-cam Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tuto...
Final Exams and Video Playlists:
www.video-tuto...
Full-Length Math & Science Videos:
/ collections
Statistics Formula Sheet: bit.ly/47zjTVT
Final Exams and Video Playlists: www.video-tutor.net/
Next Video: ua-cam.com/video/deIQeQzPK08/v-deo.html
My love for your channel is like a copied assignment... I can't explain!💓
You're so passionate about this. you sound relaxed and patient and your classes/videos helped and are still helping me understand stats. Be blessed and thank you so much.
Why n-1 instead of n?
the n is for population and n-1 is for sample
@@_femme_force why n-1 instead of n
@@lyka1237I already answered that for you, in statistics when you are in a profession like data science you deal with population and samples when n is used it is a large group of population and n-1 is when you dealing with a smaller range population (sample).if you still don't get it ask Google
@@_femme_force he’s asking why minus 1 ? like why wouldn’t you minus 2 or 50 ?
@@funfeces3450 it's just the formula for it's called bessel formula. It's like asking why is the formula for mean used for finding the mean. It's just how it is
Thanks a ton. I am scared of it but I love it. You are saving my day
Wow, thanks so muchhh
Ny brain feel wayyyy better than when i'm in class for 2 hours
God bless you, i love you sir
5:06 Sir, is the sample variance different from the population variance? I want to ask whether in machine learning to calculate variance and standard deviation on a dataset using sample variance and standard deviation?
you have given me reasons to study more for my exams with maximum understanding sir.
am grateful
Great class, Thanks a lot!! Salutations from Brazil. 👍☺
Praying for you..after many trials to understand statistics finally I found you. Manyyyyy thanks
you are simply the best. i follow you and you dont lose me. thanks for your teachings, i have learnt a lot.
You are my favorite tutor!
I love how you explain😍 so relaxed!!!
Why do some times they use n-1 and even EF wen calculating Variance 10:27am
Is it divided by 'n' OR is it 'n-1'? Think its n. Not sure about the reasoning behind n-1.
This becos when n is less 30 u will substrate by one and if n is greater or equal to 30 u will maintain it .note it's only apply for ungrounded data
Can you do a Calculus BC review.
thanks so much sir, you are indeed a teacher. God bless you
thanks for very informative and clear video. It helps a lot.
I'm confused why we subtract 1 fron n tell me why?!
1 A meteorologist interested in the consistency of temperatures in three cities during a given week collected the following data.the temperatures for the five days of week in three cities were
sir why we calculate frequency in it bcz without frequency the answer is also same
Why is there a variance sample? How many variance do we have?
I need a pros and cons list of the 2
What do you call to this table
Classic interval | f | x | (x-mean) | (x-mean)² | rf | cf< | cf> | rcf |
after this video I think it is really interesting mathematical thing to solve with tables.
All here, we respect you teacher we respect u❤️❤️😊
Great. Really well explained. Thanks
What a very informative video.I have been following the steps ,im very impressed.
Why did you use n-1 ( unbiased )and n at the same . Please could you advice on it?
Love ❤️ you
4 years ago but still helping thanks a lot and have a good day
Thank you very much for this video !
4:41 Why is 1 subtracted from n?
In calculating population standard deviation, you divide by N but for calculating sample standard deviation, you divide N-1 , the 1 is subtracted as our analysis is based on samples, this is done to avoid any biased nature of the collected samples.
Always happy to watch your videos
What Programm do you use as drawing Programm?
thank you sir for sharing your knowledge
3:19 Sir, i want to ask, is the deviation with standard deviation different?
n-1 is for sample, n is for population
Great. I'll definitely be watching your videos on pre calculus.
Thank u for this video it's been such a great help to me since I started college. You break everything down and show every step and I appreciate it.
nice one
Please why are we using n-1
thanks
✨🙏
423
Tnk u very much sir
You are brilliant 👏
I love you
Thanks a million
I'll complete all tutorials
great!
Thanks sir
THANK YOU SO MUCHHHH
U R = SMART
Thank you..
Confusion ooh but as for the ungrouped data u are correct but when u are solving for the grouped data u make a mistake,wen the total frequency is less than 30 u will maintain but if it's greater or equal 30 u will substrate by one. Plz it's applied for grouped data only
Help please.
A retailer observes that the demand for a popular board game averages 40 per week with the standard deviation of 13. If the seller wishes to have adequate stock 99% of the time, at least how many games must she keep on hand?
Thank you Soo much! This morning completed exercises and worn your examples!! Your toturial are awesome! How to send you an email?
*r/iamverysmart*
Also thanks this data crap got my head tangled for weeks 🙏
what app are you using for writing that?