Variance and Standard Deviation With Microsoft Excel - Descriptive Statistics
HTML-код
- Опубликовано: 21 авг 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.
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...
_________________________________________
RUclips Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tuto...
Final Exams and Video Playlists:
www.video-tuto...
Full-Length Math & Science Videos:
/ collections
Next Video: ruclips.net/video/deIQeQzPK08/видео.html
Final Exams and Video Playlists: www.video-tutor.net/
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.
Praying for you..after many trials to understand statistics finally I found you. Manyyyyy thanks
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
you are simply the best. i follow you and you dont lose me. thanks for your teachings, i have learnt a lot.
Thanks a ton. I am scared of it but I love it. You are saving my day
you have given me reasons to study more for my exams with maximum understanding sir.
am grateful
All here, we respect you teacher we respect u❤️❤️😊
You are my favorite tutor!
I love how you explain😍 so relaxed!!!
4 years ago but still helping thanks a lot and have a good day
Great class, Thanks a lot!! Salutations from Brazil. 👍☺
thanks so much sir, you are indeed a teacher. God bless you
after this video I think it is really interesting mathematical thing to solve with tables.
Always happy to watch your videos
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
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.
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?
What a very informative video.I have been following the steps ,im very impressed.
Great. Really well explained. Thanks
thanks for very informative and clear video. It helps a lot.
Great. I'll definitely be watching your videos on pre calculus.
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
Thank you very much for this video !
thank you sir for sharing your knowledge
You are brilliant 👏
Can you do a Calculus BC review.
I'll complete all tutorials
thanks
Thanks a million
I need a pros and cons list of the 2
nice one
Love ❤️ you
THANK YOU SO MUCHHHH
What do you call to this table
Classic interval | f | x | (x-mean) | (x-mean)² | rf | cf< | cf> | rcf |
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
Thanks sir
Tnk u very much sir
Thank you..
n-1 is for sample, n is for population
Why did you use n-1 ( unbiased )and n at the same . Please could you advice on it?
3:19 Sir, i want to ask, is the deviation with standard deviation different?
great!
U R = SMART
Why is there a variance sample? How many variance do we have?
I love you
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.
I'm confused why we subtract 1 fron n tell me why?!
sir why we calculate frequency in it bcz without frequency the answer is also same
✨🙏
What Programm do you use as drawing Programm?
Thank you Soo much! This morning completed exercises and worn your examples!! Your toturial are awesome! How to send you an email?
Please why are we using n-1
423
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?
what app are you using for writing that?
*r/iamverysmart*
Also thanks this data crap got my head tangled for weeks 🙏