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.

[@rigodiego2753]

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

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

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

[@martinsorenson3087]

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

[@VivoPhys]

I'm glad it helped.

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

[@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!

[@himelu]

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

[@VivoPhys]

Thank you. I'm glad this helped.

[@BitsAsLiga]

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

[@VivoPhys]

Good luck!

[@bianca3201]

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

[@VivoPhys]

I'm glad it helped.

[@ozboz888]

Amazing and concise explanation!

[@VivoPhys]

Thank you!

[@therankingworld7627]

SIMPLE AND STRAIGHT TO THE POINT LOVELY TUTORIAL

[@VivoPhys]

I'm glad you like it.

[@aronkay5274]

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

[@VivoPhys]

Thank you!

[@ABROGARRUTHC]

Thank you very much, Mr. Matthews!

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

[@islandeeliacin_]

This video save my life😊
Thank you

[@VivoPhys]

You are welcome.

[@contentfaithrecords]

Very Simplex! Thanks!

[@VivoPhys]

You are welcome.

[@hannahs4766]

This was an excellent demonstration thank you so much

[@VivoPhys]

You are welcome.

[@sirbrad2336]

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

[@VivoPhys]

You are welcome!

[@Rosh-n1m]

its was a great video! Thank you !

[@VivoPhys]

You are welcome.

[@joyceeverpantulia8980]

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

[@VivoPhys]

Happy to help!

[@umeshchandramakwana806]

Vwery nice explaination!

[@VivoPhys]

Thank you!

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

[@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!

[@waiollie2249]

多謝！

[@VivoPhys]

You are very welcome!

[@kevinmitchell1011]

Thank you for this!

[@VivoPhys]

Glad it was helpful!

[@ethanmccaleb3492]

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

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

[@benlawes2138]

Understood it right away ur the man !

[@VivoPhys]

I'm glad it helped.

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

[@aig111]

Amazing short video! Thanks!!!!!

[@VivoPhys]

Glad you liked it!

[@farazahmed7146]

Excellent lecture Sir! Thanks

[@VivoPhys]

I hope it was helpful.

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

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

[@AMARAUDECHUKWU]

Very helpful

[@VivoPhys]

I'm glad it helped.

[@freifreiheit1330]

thank you, VAN GOGH!!!

[@DBAKE111]

YOU’RE GOATED

[@rowenageneralle7391]

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

[@VivoPhys]

I'm happy it helped.

[@andrewlukkuz369]

Thanks for the help, nice video

[@VivoPhys]

I'm glad it helped.

[@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?

[@ymarredondo1787]

super easy thank you

[@VivoPhys]

You are welcome!

[@melissaevans2305]

thank you, thank you and thank you!!

[@VivoPhys]

You are very welcome.

[@BrokenRecord-i7q]

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

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

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

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

[@Tim-French]

Thank you!

[@VivoPhys]

You are very welcome.

[@Magajathivlogs_Ranjith953]

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

[@VivoPhys]

It depends on the CI needed.

[@raindropsofsky]

Is it easy more or less?

[@VivoPhys]

Yes

[@carmenb9691]

THANK YOU!😇

[@gdmrhotshot3731]

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

[@VivoPhys]

I hope this was helpful.

[@cricball6460]

Excellent

[@VivoPhys]

Thank you.

[@ashleyiscute6547]

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.

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

[@nata_profe]

Thanks a million! :-)

[@VivoPhys]

You are welcome.

[@alexanderalonso5452]

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

[@azizalharbi7412]

one word: Lifesaver

[@VivoPhys]

I'm glad it helped.

[@MPK_K1NG]

Good video

[@VivoPhys]

Thank you!

[@steggcivil680]

thanks mate.

[@VivoPhys]

I'm happy it helped.

[@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?

[@anselally4408]

Thank you, Succinct and to the point.

[@VivoPhys]

I'm happy it helped.

[@francescamassaro5473]

Akqqkkqpokq

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

[@ayakhamiti709]

Thank you so relevant and straight forward

[@VivoPhys]

I'm happy it helped.

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

[@itsjustgoli]

thank you !

[@VivoPhys]

I'm happy it helped.

[@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)

[@mahammadoutunkara8958]

thank you

[@VivoPhys]

You are welcome!

[@nadamahmoud2509]

Thanks alot

[@VivoPhys]

You are welcome!

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

[@thelion9489]

THANKS

[@VivoPhys]

You are welcome.

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

[@LoveRadishes]

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

[@VivoPhys]

Hi VideoName. Thank you!

[@sssshhhh990]

thanks

[@VivoPhys]

You are welcome.

[@chrisevans6716]

Thanks

[@VivoPhys]

Happy to help.

[@itzali6676]

Thanks man 👍

[@VivoPhys]

Glad it helped.

[@harmankardon478]

Didn't work

[@jules4927]

thx

[@hardiksharda9673]

Thank You!!

[@VivoPhys]

I hope it helped.

[@alext1277]

Thank you

[@VivoPhys]

You are welcome.

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

[@graceramsey410]

thank you!

[@VivoPhys]

You are welcome.

[@AbdulRahman-lr5fz]

thank you

[@VivoPhys]

You are welcome.

[@jonniecash92]

Thank you!

[@VivoPhys]

You are welcome.