Excel Basics #6: Names Cell Ranges and Functions

[@excelisfun]

Standard Deviation (SD) is a numerical measure that does these things: 1)Tells you the average deviation each data point is from the mean (AVERAGE function) 2)Is a measure of variation or dispersion 3)Tells you how clustered the data points are around the mean 4)Helps you to decide if the mean fairly represents the data points. more...

[@excelisfun]

5)For comparison purposes if one data set has a small SD and another has a large SD, then the mean with the smaller SD more fairly represents its data points. 6)In loose terms, SD tells you how good your mean is. 7)In our example if the distribution of car prices is bell shaped, we could add and subtract the SD to the mean and then say that 68% of values should lie within this range. More

[@excelisfun]

I am glad that you liked it!

[@excelisfun]

Dear snocamo154, I am glad that the videos are informative! The program I use is called Camtasia. It is an easy program. Of course, it even comes with videos that show you how to use the program. --excelisfun

[@excelisfun]

Dear cidfidoutube, I'll keep posting, if you keep watching! --excelisfun

[@excelisfun]

I am glad that you like it!

[@excelisfun]

You are welcome. To see how to best use the excelisfun channel, be sure to watch the video that auto-plays at the excelisfun channel.

[@excelisfun]

I am glad that the videos are helpful!!

[@excelisfun]

You are welcome!

[@excelisfun]

If explanation of SD is what you want, the complete story is in these videos: Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread) Excel & Statistics 40: Range & Interquartile Range (Variability) Excel & Statistics 41: Sample Standard Deviation (Variability) Excel & Statistics 42: Coefficient of Variation Excel & Statistics 45: Z-Score (# Standard Deviations From Mean) Excel & Statistics 47: Empirical Rule (Bell Shaped Curve)

[@excelisfun]

You are welcome!!

[@bradmorgan911]

Great video series. You go fast enough to keeps things interesting but not so fast that I can't follow what you are doing on the screen. Extremely informative and you have a great teaching style. I'm working my way through the 1st two playlists and then will go from there. I use a PC at work but a Mac at home so I'm learning Numbers 09 at the same time which gives me a headache sometimes. Thanks for your postings! Makes my life much easier.

[@excelisfun]

Dear Sabryluvish, If you treat your students with love and care, let them ask any question and when you don't know the answer you say "I don't know, but I'll figure it out and get back to you", and you learn new things every day, then you are as good as me!!! Let me know if you have questions (even ones that I do not know the answer to)!! --excelisfun

[@excelisfun]

Thanks for the 5 star rating!!

[@excelisfun]

I am glad that the videos help!

[@excelisfun]

Glad you like the series!

[@excelisfun]

Thanks for the stars! You are welcome for the video!

[@jeahhh]

Couldn't thank this man enough for the help!

[@excelisfun]

Dear jack40russel , Watch the Excel Basics Series and then The Highline Excel Class Series. That will keep you busy for a long time and it covers most Excel topics. --excelisfun

[@excelisfun]

Dear astighey, If it is not fun, don't listen! Remember: This is Free! --excelisfun

[@excelisfun]

Thank you!

[@excelisfun]

That order is correct. However, if you make it through the 1st two, you have almost everything you need (the Highline one has soooo much in it!).

[@excelisfun]

search for excelisfun, then go to the channel and watch the video that auto plays - it shows how to do everything.

[@excelisfun]

@b00gied0n , it was all the sales for the month, so all - population.

[@WalterTonetto]

Light and Blessings to you for such fun and informative stuff!! :)

[@excelisfun]

Unfortunately, between the Stats class videos and the two books I am writing this year, I am booked up. I do plan do a huge Finance series, but it is not for another year...

[@excelisfun]

Pound signs mean the column is not wide enough, or you created a time math formula backwards 9Beg time - end time).

[@excelisfun]

See below comments:

[@jamesperry3837]

Thank u Mike. That was simply EXCELLENT & interesting.

[@excelisfun]

Dear rizmy25 , You are welcome! --excelisfun

[@skullkey123]

thank you for this information i really needed it for my ict test a day from now thanks again

[@dreddph]

Excellent video again. Thanks!

[@andrynantenainaranaivojaon4569]

Thank u very much!

[@excelisfun]

You are welcome!

[@excelisfun]

@ummmomen , try this playlist of videos about Dynamic Ranges: youtube [dot] com/user/ExcelIsFun#grid/user/F6A29BD9E1CD5E6A

[@snocamo154]

What software program do you use to copy the screen as you work on the Excel program? I use something similar called Fraps to create an .avi file while gameplaying, but Fraps won't work with Excel. Thank you for posting your Excel knowledge. I find it very informative.

[@jack40russel]

In what sequence should you follow your different classes to reap the best results (ie. a thorough understanding and expert application of Excel)?

[@excelisfun]

Dear dreddph, You are welcome! Did you mean EXCELlent? --excelisfun

[@excelisfun]

I don't know Open Office. Sorry.

[@3brigada4]

Great video and keep up the good work. Would you know why would cell L15 give me pound signs instead of the result. i cant figure it out but the other number do show up

[@ummmomen]

Hi, thanks for the video. I have a question here. we gave a name to the range to be easy when getting the min & max etc. how can i give a name for an open range. means i enter everyday more rows but i need the min & max to change according to the data i entered.

[@ShedMySkin888]

I'm working in Open Office SS (similar to Excel) and entering dates which go from 2009 to 2010. However, when I get to Jan 4 which is the first Monday in 2010, the text reverts to 2009. I've been searching for the format of that cell and trying to force 2010 into it so that it automatically inputs the day and date but it keeps reverting to the day of 2009 and the date. Any suggestions? I know there's a cell format but can't find it.

[@ummmomen]

@ExcelIsFun Thanks, sure I will.

[@ummmomen]

Hi, I have tried something and it works. I have only 6 columns , so i highlighted the head then ctrl shift down arrow then I named the open range as I know I increase only the rows. so when ever i enter more data the min & the max changes. send me if i did right. once again thanks for your video

[@darkwizzard70]

Love it

[@sergioereis]

Ok. And how can I undo names from my lists selections?

[@vesee]

In our case what does the number 12152.89 tells me? (stdevp)

[@darrencornell1]

this is so much fun

[@vesee]

can't post

[@GoldsmithJohn]

hilarious

[@excelisfun]

I am glad that you like it!

[@excelisfun]

You are welcome!

[@excelisfun]

@ummmomen , try this playlist of videos about Dynamic Ranges: youtube [dot] com/user/ExcelIsFun#grid/user/F6A29BD9E1CD5E6A