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.com/site/evanmat...

[@dakotaduffina811]

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

[@rigodiego2753]

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

[@VivoPhys]

I'm glad it helped.

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

[@bianca3201]

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

[@VivoPhys]

I'm glad it helped.

[@himelu]

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

[@VivoPhys]

Thank you. I'm glad this helped.

[@ozboz888]

Amazing and concise explanation!

[@VivoPhys]

Thank you!

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

[@penguinminari3309]

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

[@VivoPhys]

Good luck!

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

[@user-sn9wm4uk5n]

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.

[@hannahs4766]

This was an excellent demonstration thank you so much

[@VivoPhys]

You are welcome.

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

[@aronkay5274]

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

[@VivoPhys]

Thank you!

[@freifreiheit1330]

thank you, VAN GOGH!!!

[@umeshchandramakwana806]

Vwery nice explaination!

[@VivoPhys]

Thank you!

[@rowenageneralle7391]

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

[@VivoPhys]

I'm happy it helped.

[@farazahmed7146]

Excellent lecture Sir! Thanks

[@VivoPhys]

I hope it was helpful.

[@benlawes2138]

Understood it right away ur the man !

[@VivoPhys]

I'm glad it helped.

[@sirbrad2336]

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

[@VivoPhys]

You are welcome!

[@joyceeverpantulia8980]

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

[@VivoPhys]

Happy to help!

[@andrewlukkuz369]

Thanks for the help, nice video

[@VivoPhys]

I'm glad it helped.

[@kevinmitchell1011]

Thank you for this!

[@VivoPhys]

Glad it was helpful!

[@fatima15270]

Thank you so much

[@VivoPhys]

You are welcome.

[@_mind_relaxing]

its was a great video! Thank you !

[@VivoPhys]

You are welcome.

[@melissaevans2305]

thank you, thank you and thank you!!

[@VivoPhys]

You are very welcome.

[@carmenb9691]

THANK YOU!😇

[@user-zr8li5eq9c]

Very helpful

[@VivoPhys]

I'm glad it helped.

[@islandeeliacin_]

This video save my life😊 Thank you

[@VivoPhys]

You are welcome.

[@anselally4408]

Thank you, Succinct and to the point.

[@VivoPhys]

I'm happy it helped.

[@francescamassaro5473]

Akqqkkqpokq

[@aig111]

Amazing short video! Thanks!!!!!

[@VivoPhys]

Glad you liked it!

[@ryanmekkes5239]

Thank you!

[@VivoPhys]

You are welcome.

[@ymarredondo1787]

super easy thank you

[@VivoPhys]

You are welcome!

[@hardiksharda9673]

Thank You!!

[@VivoPhys]

I hope it helped.

[@AbdulRahman-lr5fz]

thank you

[@VivoPhys]

You are welcome.

[@golrokhnasihatkon1878]

thank you !

[@VivoPhys]

I'm happy it helped.

[@DBAKE111]

YOU’RE GOATED

[@nata_profe]

Thanks a million! :-)

[@VivoPhys]

You are welcome.

[@alext1277]

Thank you

[@VivoPhys]

You are welcome.

[@thelion9489]

THANKS

[@VivoPhys]

You are welcome.

[@nadamahmoud2509]

Thanks alot

[@VivoPhys]

You are welcome!

[@steggcivil680]

thanks mate.

[@VivoPhys]

I'm happy it helped.

[@waiollie2249]

多謝！

[@VivoPhys]

You are very welcome!

[@azizalharbi7412]

one word: Lifesaver

[@VivoPhys]

I'm glad it helped.

[@MPK_K1NG]

Good video

[@VivoPhys]

Thank you!

[@sssshhhh990]

thanks

[@VivoPhys]

You are welcome.

[@ayakhamiti709]

Thank you so relevant and straight forward

[@VivoPhys]

I'm happy it helped.

[@chrisevans6716]

Thanks

[@VivoPhys]

Happy to help.

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

[@LoveRadishes]

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

[@VivoPhys]

Hi VideoName. Thank you!

[@elfinanciero_ed6027]

Hi Evan, Nice video man. What is the camera you are using to do those kinds of videos? Thanks

[@VivoPhys]

Cannon t5i

[@elfinanciero_ed6027]

@@VivoPhys Thank you!

[@jules4927]

thx

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

[@itzali6676]

Thanks man 👍

[@VivoPhys]

Glad 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?

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

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

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

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

[@alexanderalonso5452]

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

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

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

[@shivayshakti6575]

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

[@gdmrhotshot3731]

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

[@VivoPhys]

I hope this was helpful.

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

[@Magajathivlogs_Ranjith953]

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

[@VivoPhys]

It depends on the CI needed.

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

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

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

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

How to find standard deviation to % data

[@VivoPhys]

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

[@raindropsofsky]

Is it easy more or less?

[@VivoPhys]

Yes

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

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

[@harmankardon478]

Didn't work

[@Tim-French]

Thank you!

[@VivoPhys]

You are very welcome.

[@berto_osorio_fl]

thank you!

[@VivoPhys]

You are welcome.

[@mahammadoutunkara8958]

thank you

[@VivoPhys]

You are welcome!

[@graceramsey410]

thank you!

[@VivoPhys]

You are welcome.