Standard Deviation in Excel (NEW VERSION IN DESCRIPTION)

NEW VERSION - Standard Deviation of a Data Set in Excel
• Standard Deviation of ...
This video shows Dr. Evan Matthews explaining how to calculate a standard deviation in Excel. The sample data in this video represents the 1 repetition maximum (1RM) of the biceps curl for women and men.
Standard Error in Excel
• Standard Error of the ...
Link to video of how to calculate an average in Excel.
• Calculating Averages i...
Excel Skills Playlist
• Excel Microsoft Office
-Correction-
The data headers in the excel file state that the units are pounds. They are actually kilograms that were converted from pounds. This is the reason for the decimal values seen in the spreadsheet.
Link to Dr. Evan Matthews website.
sites.google.c...

[@thelmasantos4841]

Thank you for the very clear demonstration of calculating the standard deviation using Excel May I share this with my students. Your work will be acknowledged.

[@VivoPhys]

Of course.

[@SadlySorrowful]

My statistics professor doesn't explain how to do this and you clearly made it easier for me to know how to find the standard deviation of a sample, thank you.

[@VivoPhys]

I'm glad it helped.

[@dakotaduffina811]

I literally tried doing this by hand. No wonder I hate this class. My professor should’ve just taught us this. Thank you.

[@gregoryfriske]

Ahahah lol

[@VivoPhys]

That is common in statistics courses because they want you to understand how the software works and what it means. In practice, no one is hand calculating this anymore.

[@rigodiego2753]

Learned more in under 5 mins than in a 2 hour lecture

[@VivoPhys]

I'm glad it helped.

[@blip_bob_bobert6274]

You are a lifesaver. I tried doing this by hand and constantly kept getting the wrong answer. Thank you.

[@VivoPhys]

You are welcome.

[@Marta-to1mf]

Im taking statistics lass and I wanted to thank yiu very much. Your video is a life saver !

[@VivoPhys]

Good luck with the class!

[@bellaendale2765]

Where were you when I took statistics? Hm hm hm.. I would have enjoyed and loved it so much more. I never realized it was this easy. Many thanks for calmy and clearly explaining this concept.

[@VivoPhys]

You are very welcome.

[@waiollie2249]

多謝！

[@VivoPhys]

You are very welcome!

[@BitsAsLiga]

thank you so much, you've save us so much time for our school project

[@VivoPhys]

Good luck!

[@martinsorenson3087]

Very helpful for my M.Sc assignment. Gotta finish it In 4 days so this is terrific

[@VivoPhys]

I'm glad it helped.

[@therankingworld7627]

SIMPLE AND STRAIGHT TO THE POINT LOVELY TUTORIAL

[@VivoPhys]

I'm glad you like it.

[@ozboz888]

Amazing and concise explanation!

[@VivoPhys]

Thank you!

[@himelu]

Thank you!!! You are an awesome person. My life just got a lot easier.

[@VivoPhys]

Thank you. I'm glad this helped.

[@bianca3201]

super clear and easy to understand! thanks wish i would've found you last semester!

[@VivoPhys]

I'm glad it helped.

[@ABROGARRUTHC]

Thank you very much, Mr. Matthews!

[@VivoPhys]

You are welcome.

[@islandeeliacin_]

This video save my life😊 Thank you

[@VivoPhys]

You are welcome.

[@contentfaithrecords]

Very Simplex! Thanks!

[@VivoPhys]

You are welcome.

[@aronkay5274]

Great Video Vivo Phys!! Keep up the great work!

[@VivoPhys]

Thank you!

[@sirbrad2336]

Thank you so much for the great tutorial! Merci Beaucoup!

[@VivoPhys]

You are welcome!

[@hannahs4766]

This was an excellent demonstration thank you so much

[@VivoPhys]

You are welcome.

[@CMeds]

THANK YOU SO MUCH, SIR! YOU MADE IT EASIER FOR EVERYONE TO SOLVE THIS!

[@VivoPhys]

I'm happy it helped.

[@joyceeverpantulia8980]

Thank you so much! It helps me big time. 😊

[@VivoPhys]

Happy to help!

[@Music_Lane-y7b]

its was a great video! Thank you !

[@VivoPhys]

You are welcome.

[@umeshchandramakwana806]

Vwery nice explaination!

[@VivoPhys]

Thank you!

[@kevinmitchell1011]

Thank you for this!

[@VivoPhys]

Glad it was helpful!

[@benlawes2138]

Understood it right away ur the man !

[@VivoPhys]

I'm glad it helped.

[@AMARAUDECHUKWU]

Very helpful

[@VivoPhys]

I'm glad it helped.

[@farazahmed7146]

Excellent lecture Sir! Thanks

[@VivoPhys]

I hope it was helpful.

[@freifreiheit1330]

thank you, VAN GOGH!!!

[@rowenageneralle7391]

Thank you so much...sir for a clear explaination.

[@VivoPhys]

I'm happy it helped.

[@ymarredondo1787]

super easy thank you

[@VivoPhys]

You are welcome!

[@Tim-French]

Thank you!

[@VivoPhys]

You are very welcome.

[@melissaevans2305]

thank you, thank you and thank you!!

[@VivoPhys]

You are very welcome.

[@aig111]

Amazing short video! Thanks!!!!!

[@VivoPhys]

Glad you liked it!

[@cricball6460]

Excellent

[@VivoPhys]

Thank you.

[@azizalharbi7412]

one word: Lifesaver

[@VivoPhys]

I'm glad it helped.

[@DBAKE111]

YOU’RE GOATED

[@carmenb9691]

THANK YOU!😇

[@andrewlukkuz369]

Thanks for the help, nice video

[@VivoPhys]

I'm glad it helped.

[@tp1160]

Excellent video thanks. How would you calculate std dev excluding zeros?

[@VivoPhys]

I'm not sure of a way to do this automatically from a formula. Sorry.

[@Anits1989]

Thank you! This is helping so much with biostatistic drug studies :D

[@VivoPhys]

Glad to hear it. Good luck.

[@VivoPhys]

Check out my newest videos. I am making a playlist on how to organize and handle large spreadsheets. I hope it helps too.

[@jboy1757]

What if I want STDev for both men & women, and do not want to alter the columns; what does the formula look like?

[@VivoPhys]

You would need to highlight both groups of data. It might let you highlight one group, put a comma, then highlight the second group. I'm not positive though.

[@ethanmccaleb3492]

Ive been given data on gdp. My data is between 1950-2019 would i use the population function for this?

[@steggcivil680]

thanks mate.

[@VivoPhys]

I'm happy it helped.

[@BrokenRecord-i7q]

this means that they are 2.x to the right and to the left of the mean?

[@safa9564]

Thanks for the video. How would you calculate 3 standard deviations above the mean?

[@VivoPhys]

Take the average and add 3xSD. I have a video coming out soon doing this.

[@safa9564]

@@VivoPhys thank you!

[@thelion9489]

THANKS

[@VivoPhys]

You are welcome.

[@mahammadoutunkara8958]

thank you

[@VivoPhys]

You are welcome!

[@khmlhadjer4679]

Thanks please what is the version of this excell??

[@VivoPhys]

I believe this was the 2019 version.

[@khmlhadjer4679]

@@VivoPhys well thanks sorry :if have a sample analyzed in 3 position every position have 3 replicate so I get 9 values of this sample how I calculate the standard deviation for each measurement &sample?? Could you answer me

[@MPK_K1NG]

Good video

[@VivoPhys]

Thank you!

[@nata_profe]

Thanks a million! :-)

[@VivoPhys]

You are welcome.

[@sssshhhh990]

thanks

[@VivoPhys]

You are welcome.

[@mrsusan5672]

Is there a difference between Standard Deviation for a sample and the whole population?

[@VivoPhys]

There is a slight difference in the equation.

[@mrsusan5672]

@@VivoPhys Thank you

[@golinasi]

thank you !

[@VivoPhys]

I'm happy it helped.

[@nadamahmoud2509]

Thanks alot

[@VivoPhys]

You are welcome!

[@anselally4408]

Thank you, Succinct and to the point.

[@VivoPhys]

I'm happy it helped.

[@francescamassaro5473]

Akqqkkqpokq

[@chrisevans6716]

Thanks

[@VivoPhys]

Happy to help.

[@johnjohnson3390]

nice but what does the 2 and 4 mean?

[@VivoPhys]

Standard deviation is basically the average difference of the values in your sample from your sample average. I'm sure a statistician would not like my answer and would have a better one though.

[@chinnymo]

how does it know the expected value needed in the formula?

[@VivoPhys]

The standard deviation formula used is programed into Excel. So I cannot say exactly how it works.

[@raindropsofsky]

Is it easy more or less?

[@VivoPhys]

Yes

[@ayakhamiti709]

Thank you so relevant and straight forward

[@VivoPhys]

I'm happy it helped.

[@Magajathivlogs_Ranjith953]

Sir, it is possible to find SD for men and women number...

[@VivoPhys]

Please see the video. I show that in the video.

[@marygracecastolo2454]

can i ask, sir? what if i applied a probability sampling to my population and i already isolated the samples, should i still use the =stdev.s?

[@VivoPhys]

I am not a statistician. I would imagine you would assuming you are still using a sample of a larger population. However, I'd recommend asking someone familiar with what you are doing.

[@christianmalvar6990]

In Mean =sum(G363)/25(sample Is it the same with the STDV S(G262) Do i need to divide on how many sample i have?

[@LoveRadishes]

TE AMO!! I LOVE YOU!!! FOR REAL THANK YOU!! T_T!!!!!!!!!

[@VivoPhys]

Hi VideoName. Thank you!

[@samusaran4799]

i have a sample size that ranges from 20,000 to 30,000 and my variance formula shows up as a value of over 1.8 million... is that right like ??

[@VivoPhys]

Sorry. It's hard to say.

[@adhoccerswings]

the Vietnamese translation kicks ass :D but why the heck do I have Vietnamese captions on in the first place? (I usually watch most tutorials 2x speed with captions, a lot faster lol)

[@Magajathivlogs_Ranjith953]

How to find standard deviation to % data

[@VivoPhys]

It is the same process. The units will be the same as the numbers analyzed.

[@alexanderalonso5452]

What about sig fig? How many sig figs would it have if the sig figs rules were applied

[@Magajathivlogs_Ranjith953]

Sir while doing CI, we have to take how much value

[@VivoPhys]

It depends on the CI needed.

[@itzali6676]

Thanks man 👍

[@VivoPhys]

Glad it helped.

[@jules4927]

thx

[@gdmrhotshot3731]

me casually looking up all the excel commands not needing to learn what my teacher shows us

[@VivoPhys]

I hope this was helpful.

[@nata_profe]

Если кто-то считает это в русскоязычном экселе, то sample standard deviation будет СТАНДОТКЛОН.В, а СТАНДОТКЛОН.Г - population standard deviation.

[@VivoPhys]

Hi Natalia Aguiar. Thanks for contributing this information. Hopefully it helps some Russian speaking viewers out their.

[@Nickdude6]

Did you add reverb to you voice?

[@VivoPhys]

No, but I use the denoise function in Adobe Audition. Perhaps it's adding some artifact that you are hearing.

[@francescamassaro5473]

@@VivoPhys 2kwiw

[@francescamassaro5473]

Ll2

[@francescamassaro5473]

222

[@scholars.home999]

Hi Evan. I am trying to calculate standard deviation for a variable in my data over a three-year period. Is it possible to do it using excel? Any help will be much appreciated. Thanks in advance!

[@VivoPhys]

Following the instructions in this video should work.

[@beansm152]

Hello i just have a question, I am conducting a portfolio analysis for my assignment, so i worked out the standard deviation for stocks in FTSE 100. most of the standard deviations where above 2 but i do not know how to interpret it like what do i say? what is the meaning of it being 2? like has it got to do with volatility?

[@harmankardon478]

Didn't work

[@alext1277]

Thank you

[@VivoPhys]

You are welcome.

[@hardiksharda9673]

Thank You!!

[@VivoPhys]

I hope it helped.

[@berto_osorio_fl]

thank you!

[@VivoPhys]

You are welcome.

[@fatima15270]

Thank you so much

[@VivoPhys]

You are welcome.

[@ryanmekkes5239]

Thank you!

[@VivoPhys]

You are welcome.

[@AbdulRahman-lr5fz]

thank you

[@VivoPhys]

You are welcome.

[@graceramsey410]

thank you!

[@VivoPhys]

You are welcome.

[@jonniecash92]

Thank you!

[@VivoPhys]

You are welcome.