Variance and Standard Deviation With Microsoft Excel - Descriptive Statistics
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...
_________________________________________
KZread Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tutor.net/algebra-f...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections
Пікірлер: 66
Next Video: kzread.info/dash/bejne/lpl9s8eKqrOxYJs.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
Thanks a ton. I am scared of it but I love it. You are saving my day
You are my favorite tutor! I love how you explain😍 so relaxed!!!
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.
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. 👍☺
Great. I'll definitely be watching your videos on pre calculus.
What a very informative video.I have been following the steps ,im very impressed.
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?
thanks for very informative and clear video. It helps a lot.
thanks so much sir, you are indeed a teacher. God bless you
All here, we respect you teacher we respect u❤️❤️😊
Great. Really well explained. Thanks
4 years ago but still helping thanks a lot and have a good day
after this video I think it is really interesting mathematical thing to solve with tables.
Always happy to watch your videos
thank you sir for sharing your knowledge
Thank you very much for this video !
Can you do a Calculus BC review.
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?
What do you call to this table Classic interval | f | x | (x-mean) | (x-mean)² | rf | cf | rcf |
What Programm do you use as drawing Programm?
You are brilliant 👏
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 Soo much! This morning completed exercises and worn your examples!! Your toturial are awesome! How to send you an email?
I'll complete all tutorials
I need a pros and cons list of the 2
Thanks a million
THANK YOU SO MUCHHHH
sir why we calculate frequency in it bcz without frequency the answer is also same
Thank you..
Thanks sir
thanks
Tnk u very much sir
Why n-1 instead of n?
@_femme_force
Жыл бұрын
the n is for population and n-1 is for sample
@lyka1237
Жыл бұрын
@@_femme_force why n-1 instead of n
@_femme_force
Жыл бұрын
@@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
@funfeces3450
Жыл бұрын
@@_femme_force he’s asking why minus 1 ? like why wouldn’t you minus 2 or 50 ?
@Random_Art822
11 ай бұрын
@@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
nice one
Please why are we using n-1
great!
Is it divided by 'n' OR is it 'n-1'? Think its n. Not sure about the reasoning behind n-1.
@mariamasannymohammed16
4 жыл бұрын
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
Love ❤️ you
4:41 Why is 1 subtracted from n?
@spinach7205
4 жыл бұрын
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.
U R = SMART
I love you
what app are you using for writing that?
n-1 is for sample, n is for population
✨🙏
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?
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
423
*r/iamverysmart* Also thanks this data crap got my head tangled for weeks 🙏