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

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor Жыл бұрын

    Next Video: kzread.info/dash/bejne/lpl9s8eKqrOxYJs.html Final Exams and Video Playlists: www.video-tutor.net/

  • @steveaustine3269
    @steveaustine32693 жыл бұрын

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

  • @PromisetoselfPodcast
    @PromisetoselfPodcast3 жыл бұрын

    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.

  • @moatazmasoud
    @moatazmasoud5 жыл бұрын

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

  • @sowmyag5142
    @sowmyag51425 жыл бұрын

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

  • @iamgenevive
    @iamgenevive3 жыл бұрын

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

  • @whatismyname8626
    @whatismyname86265 жыл бұрын

    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

  • @anniemukube5011
    @anniemukube5011 Жыл бұрын

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

  • @obaaaphya4344
    @obaaaphya43442 жыл бұрын

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

  • @josephwebston
    @josephwebston5 жыл бұрын

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

  • @stanleylew1125
    @stanleylew11254 жыл бұрын

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

  • @emmanuelrennie2607
    @emmanuelrennie2607 Жыл бұрын

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

  • @nononsensegalnononsensegal4967
    @nononsensegalnononsensegal49674 жыл бұрын

    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.

  • @adiflorense1477
    @adiflorense14773 жыл бұрын

    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?

  • @bellebullecer5925
    @bellebullecer59253 жыл бұрын

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

  • @goldennanayaakonadu7984
    @goldennanayaakonadu79842 жыл бұрын

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

  • @user-rh3dp5ci7w
    @user-rh3dp5ci7w28 күн бұрын

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

  • @TheClam66
    @TheClam662 жыл бұрын

    Great. Really well explained. Thanks

  • @bby6298
    @bby62988 ай бұрын

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

  • @mannbanga1920
    @mannbanga19209 ай бұрын

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

  • @philipgodoe8751
    @philipgodoe8751 Жыл бұрын

    Always happy to watch your videos

  • @ma.sagrariopareno7102
    @ma.sagrariopareno71023 жыл бұрын

    thank you sir for sharing your knowledge

  • @dimitriysevryukov1629
    @dimitriysevryukov1629 Жыл бұрын

    Thank you very much for this video !

  • @BillyBob-tr5cv
    @BillyBob-tr5cv5 жыл бұрын

    Can you do a Calculus BC review.

  • @collinskwadwoboateng5603
    @collinskwadwoboateng56034 жыл бұрын

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

  • @adiflorense1477
    @adiflorense14773 жыл бұрын

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

  • @jayroaustria6204
    @jayroaustria62044 жыл бұрын

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

  • @Fr3nkyLp
    @Fr3nkyLp5 жыл бұрын

    What Programm do you use as drawing Programm?

  • @user-oj3wf3gd9n
    @user-oj3wf3gd9n3 жыл бұрын

    You are brilliant 👏

  • @abelfeligu5185
    @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

  • @Amafaranga300
    @Amafaranga3004 жыл бұрын

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

  • @cometoknow647
    @cometoknow6475 жыл бұрын

    I'll complete all tutorials

  • @Adrian-cn5rk
    @Adrian-cn5rk3 жыл бұрын

    I need a pros and cons list of the 2

  • @TikTok-ze8ge
    @TikTok-ze8ge4 жыл бұрын

    Thanks a million

  • @prismathicc1569
    @prismathicc15694 жыл бұрын

    THANK YOU SO MUCHHHH

  • @punjabrealestate
    @punjabrealestate2 жыл бұрын

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

  • @SudipSaha-nv9zb
    @SudipSaha-nv9zb5 жыл бұрын

    Thank you..

  • @sahidali2121
    @sahidali21214 жыл бұрын

    Thanks sir

  • @kinenbilchol2659
    @kinenbilchol2659 Жыл бұрын

    thanks

  • @oseibonsu6190
    @oseibonsu61903 жыл бұрын

    Tnk u very much sir

  • @lyka1237
    @lyka12374 жыл бұрын

    Why n-1 instead of n?

  • @_femme_force

    @_femme_force

    Жыл бұрын

    the n is for population and n-1 is for sample

  • @lyka1237

    @lyka1237

    Жыл бұрын

    @@_femme_force why n-1 instead of n

  • @_femme_force

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

    @funfeces3450

    Жыл бұрын

    @@_femme_force he’s asking why minus 1 ? like why wouldn’t you minus 2 or 50 ?

  • @Random_Art822

    @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

  • @JohnS-px2ti
    @JohnS-px2ti10 ай бұрын

    nice one

  • @fathia9582
    @fathia95822 жыл бұрын

    Please why are we using n-1

  • @GG-cm4uh
    @GG-cm4uh2 жыл бұрын

    great!

  • @zennmasterr
    @zennmasterr5 жыл бұрын

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

  • @mariamasannymohammed16

    @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

  • @stephenfrimpong5450
    @stephenfrimpong54502 жыл бұрын

    Love ❤️ you

  • @ViolinistJeff
    @ViolinistJeff4 жыл бұрын

    4:41 Why is 1 subtracted from n?

  • @spinach7205

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

  • @portable4716
    @portable47165 жыл бұрын

    U R = SMART

  • @Gabo30000
    @Gabo300002 жыл бұрын

    I love you

  • @QtMMU
    @QtMMU3 жыл бұрын

    what app are you using for writing that?

  • @altheababysit887
    @altheababysit8873 жыл бұрын

    n-1 is for sample, n is for population

  • @languageandmana9255
    @languageandmana92555 ай бұрын

    ✨🙏

  • @hlengiwengutha7844
    @hlengiwengutha78443 жыл бұрын

    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?

  • @mariamasannymohammed16
    @mariamasannymohammed164 жыл бұрын

    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

  • @janetoss
    @janetoss3 ай бұрын

    423

  • @vassphire8522
    @vassphire85225 жыл бұрын

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