Standard Deviation in Excel (NEW VERSION IN DESCRIPTION)

Подписаться 32 тыс.

Просмотров 497 тыс.

50% 1

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

Наука

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 165

@dakotaduffina811 2 месяца назад

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

@rigodiego2753 10 месяцев назад

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

@VivoPhys 10 месяцев назад

I'm glad it helped.

@thelmasantos4841 4 года назад

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 4 года назад

Of course.

@SadlySorrowful 3 года назад

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 3 года назад

I'm glad it helped.

@martinsorenson3087 3 года назад

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

@VivoPhys 3 года назад

I'm glad it helped.

@blip_bob_bobert6274 23 дня назад

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

@VivoPhys 20 дней назад

You are welcome.

@himelu 3 года назад

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

@VivoPhys 3 года назад

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!

@Marta-to1mf 7 месяцев назад

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

@VivoPhys 7 месяцев назад

Good luck with the class!

@therankingworld7627 Год назад

SIMPLE AND STRAIGHT TO THE POINT LOVELY TUTORIAL

@VivoPhys Год назад

I'm glad you like it.

@bianca3201 2 года назад

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

@VivoPhys 2 года назад

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.

@freifreiheit1330 3 года назад

thank you, VAN GOGH!!!

@CMeds 2 года назад

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

@VivoPhys 2 года назад

I'm happy it helped.

@ABROGARRUTHC Год назад

Thank you very much, Mr. Matthews!

@VivoPhys Год назад

You are welcome.

@ozboz888 3 месяца назад

Amazing and concise explanation!

@VivoPhys 3 месяца назад

Thank you!

@hannahs4766 Год назад

This was an excellent demonstration thank you so much

@VivoPhys Год назад

You are welcome.

@islandeeliacin_ 10 месяцев назад

This video save my life😊 Thank you

@VivoPhys 10 месяцев назад

You are welcome.

@sirbrad2336 Год назад

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

@VivoPhys Год назад

You are welcome!

@umeshchandramakwana806 Год назад

Vwery nice explaination!

@VivoPhys Год назад

Thank you!

@joyceeverpantulia8980 11 месяцев назад

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

@VivoPhys 11 месяцев назад

Happy to help!

@benlawes2138 3 года назад

Understood it right away ur the man !

@VivoPhys 3 года назад

I'm glad it helped.

@rowenageneralle7391 3 года назад

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

@VivoPhys 3 года назад

I'm happy it helped.

@aronkay5274 3 года назад

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

@VivoPhys 3 года назад

Thank you!

@melissaevans2305 7 месяцев назад

thank you, thank you and thank you!!

@VivoPhys 7 месяцев назад

You are very welcome.

@jonniecash92 4 дня назад

Thank you!

@VivoPhys 4 дня назад

You are welcome.

@AMARAUDECHUKWU Год назад

Very helpful

@VivoPhys Год назад

I'm glad it helped.

@farazahmed7146 2 года назад

Excellent lecture Sir! Thanks

@VivoPhys 2 года назад

I hope it was helpful.

@Rosh-n1m Год назад

its was a great video! Thank you !

@VivoPhys Год назад

You are welcome.

@kevinmitchell1011 Год назад

Thank you for this!

@VivoPhys Год назад

Glad it was helpful!

@DBAKE111 2 года назад

YOU’RE GOATED

@ymarredondo1787 2 года назад

super easy thank you

@VivoPhys 2 года назад

You are welcome!

@aig111 3 года назад

Amazing short video! Thanks!!!!!

@VivoPhys 3 года назад

Glad you liked it!

@alext1277 3 года назад

Thank you

@VivoPhys 3 года назад

You are welcome.

@Anits1989 2 года назад

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

@VivoPhys 2 года назад

Glad to hear it. Good luck.

@VivoPhys 2 года назад

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

@hardiksharda9673 2 года назад

Thank You!!

@VivoPhys 2 года назад

I hope it helped.

@azizalharbi7412 3 года назад

one word: Lifesaver

@VivoPhys 3 года назад

I'm glad it helped.

@andrewlukkuz369 3 года назад

Thanks for the help, nice video

@VivoPhys 3 года назад

I'm glad it helped.

@graceramsey410 3 года назад

thank you!

@VivoPhys 3 года назад

You are welcome.

@carmenb9691 Год назад

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.

@thelion9489 2 года назад

THANKS

@VivoPhys 2 года назад

You are welcome.

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

@nata_profe 3 года назад

Thanks a million! :-)

@VivoPhys 3 года назад

You are welcome.

@steggcivil680 3 года назад

thanks mate.

@VivoPhys 3 года назад

I'm happy it helped.

@safa9564 2 года назад

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

@VivoPhys 2 года назад

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

@safa9564 2 года назад

@@VivoPhys thank you!

@waiollie2249 9 месяцев назад

多謝！

@VivoPhys 9 месяцев назад

You are very welcome!

@ayakhamiti709 2 года назад

Thank you so relevant and straight forward

@VivoPhys 2 года назад

I'm happy it helped.

@BrokenRecord-i7q 2 года назад

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

@elfinanciero_ed6027 3 года назад

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

@VivoPhys 3 года назад

Cannon t5i

@elfinanciero_ed6027 3 года назад

@@VivoPhys Thank you!

@marygracecastolo2454 3 года назад

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 3 года назад

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.

@anselally4408 4 года назад

Thank you, Succinct and to the point.

@VivoPhys 4 года назад

I'm happy it helped.

@francescamassaro5473 3 года назад

Akqqkkqpokq

@nadamahmoud2509 3 года назад

Thanks alot

@VivoPhys 3 года назад

You are welcome!

@sssshhhh990 2 года назад

thanks

@VivoPhys 2 года назад

You are welcome.

@MPK_K1NG 3 года назад

Good video

@VivoPhys 3 года назад

Thank you!

@christianmalvar6990 2 года назад

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?

@chrisevans6716 3 года назад

Thanks

@VivoPhys 3 года назад

Happy to help.

@adhoccerswings 2 года назад

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)

@mrsusan5672 3 года назад

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

@VivoPhys 3 года назад

There is a slight difference in the equation.

@mrsusan5672 3 года назад

@@VivoPhys Thank you

@khmlhadjer4679 2 года назад

Thanks please what is the version of this excell??

@VivoPhys 2 года назад

I believe this was the 2019 version.

@khmlhadjer4679 2 года назад

@@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 3 года назад

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

@VivoPhys 3 года назад

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

@LoveRadishes 3 года назад

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

@VivoPhys 3 года назад

Hi VideoName. Thank you!

@gdmrhotshot3731 5 месяцев назад

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

@VivoPhys 5 месяцев назад

I hope this was helpful.

@johnjohnson3390 3 года назад

nice but what does the 2 and 4 mean?

@VivoPhys 3 года назад

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.

@alexanderalonso5452 4 года назад

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

@Magajathivlogs_Ranjith953 3 года назад

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

@VivoPhys 3 года назад

It depends on the CI needed.

@raindropsofsky 3 года назад

Is it easy more or less?

@VivoPhys 3 года назад

Yes

@samusaran4799 3 года назад

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 3 года назад

Sorry. It's hard to say.

@jules4927 3 года назад

thx

@Magajathivlogs_Ranjith953 3 года назад

How to find standard deviation to % data

@VivoPhys 3 года назад

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

@itzali6676 3 года назад

Thanks man 👍

@VivoPhys 3 года назад

Glad it helped.

@nata_profe 3 года назад

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

@VivoPhys 3 года назад

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

@scholars.home999 4 года назад

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 4 года назад

Following the instructions in this video should work.

@beansm152 3 года назад

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?