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.
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...
_________________________________________
KZbin Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tuto...
Final Exams and Video Playlists:
www.video-tuto...
Full-Length Math & Science Videos:
/ collections

[@TheOrganicChemistryTutor]

Statistics Formula Sheet: bit.ly/47zjTVT Final Exams and Video Playlists: www.video-tutor.net/ Next Video: kzbin.info/www/bejne/mpasgpiHr7V-Zpo

[@steveaustine3269]

My love for your channel is like a copied assignment... I can't explain!💓

[@PromisetoselfPodcast]

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.

[@lyka1237]

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]

​@@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

[@sowmyag5142]

Thanks a ton. I am scared of it but I love it. You are saving my day

[@whatismyname8626]

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

[@adiflorense1477]

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?

[@josephwebston]

Great class, Thanks a lot!! Salutations from Brazil. 👍☺

[@obaaaphya4344]

you have given me reasons to study more for my exams with maximum understanding sir. am grateful

[@moatazmasoud]

Praying for you..after many trials to understand statistics finally I found you. Manyyyyy thanks

[@NamitalaJoan-q7s]

Why do some times they use n-1 and even EF wen calculating Variance 10:27am

[@iamgenevive]

You are my favorite tutor! I love how you explain😍 so relaxed!!!

[@BillyBob-tr5cv]

Can you do a Calculus BC review.

[@RABBITENA]

I'm confused why we subtract 1 fron n tell me why?!

[@anniemukube5011]

you are simply the best. i follow you and you dont lose me. thanks for your teachings, i have learnt a lot.

[@patriciatare8128]

Why is there a variance sample? How many variance do we have?

[@zennmasterr]

Is it divided by 'n' OR is it 'n-1'? Think its n. Not sure about the reasoning behind n-1.

[@mariamasannymohammed16]

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

[@goldennanayaakonadu7984]

thanks so much sir, you are indeed a teacher. God bless you

[@Ezabellk]

All here, we respect you teacher we respect u❤️❤️😊

[@bellebullecer5925]

thanks for very informative and clear video. It helps a lot.

[@stephenfrimpong5450]

Love ❤️ you

[@TheClam66]

Great. Really well explained. Thanks

[@Adrian-cn5rk]

I need a pros and cons list of the 2

[@janetoss]

423

[@languageandmana9255]

✨🙏

[@punjabrealestate]

sir why we calculate frequency in it bcz without frequency the answer is also same

[@abelfeligu5185]

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

[@kinenbilchol2659]

thanks

[@mannbanga1920]

after this video I think it is really interesting mathematical thing to solve with tables.

[@JohnS-px2ti]

nice one

[@jayroaustria6204]

What do you call to this table Classic interval | f | x | (x-mean) | (x-mean)² | rf | cf< | cf> | rcf |

[@bby6298]

4 years ago but still helping thanks a lot and have a good day

[@emmanuelrennie2607]

What a very informative video.I have been following the steps ,im very impressed.

[@dimitriysevryukov1629]

Thank you very much for this video !

[@ViolinistJeff]

4:41 Why is 1 subtracted from n?

[@spinach7205]

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.

[@philipgodoe8751]

Always happy to watch your videos

[@collinskwadwoboateng5603]

Why did you use n-1 ( unbiased )and n at the same . Please could you advice on it?

[@fathia9582]

Please why are we using n-1

[@altheababysit887]

n-1 is for sample, n is for population

[@ma.sagrariopareno7102]

thank you sir for sharing your knowledge

[@Fr3nkyLp]

What Programm do you use as drawing Programm?

[@stanleylew1125]

Great. I'll definitely be watching your videos on pre calculus.

[@Gabo30000]

I love you

[@oseibonsu6190]

Tnk u very much sir

[@GG-cm4uh]

great!

[@ሳምሪ-ቸ7ኈ]

You are brilliant 👏

[@adiflorense1477]

3:19 Sir, i want to ask, is the deviation with standard deviation different?

[@TikTok-ze8ge]

Thanks a million

[@cometoknow647]

I'll complete all tutorials

[@sahidali2121]

Thanks sir

[@prismathicc1569]

THANK YOU SO MUCHHHH

[@portable4716]

U R = SMART

[@SudipSaha-nv9zb]

Thank you..

[@nononsensegalnononsensegal4967]

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.

[@vassphire8522]

*r/iamverysmart* Also thanks this data crap got my head tangled for weeks 🙏

[@mariamasannymohammed16]

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

[@Amafaranga300]

Thank you Soo much! This morning completed exercises and worn your examples!! Your toturial are awesome! How to send you an email?

[@hlengiwengutha7844]

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?

[@QtMMU]

what app are you using for writing that?