Excel Basics #7: Range 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 the videos are hepful!

[@excelisfun]

Dear blupears, You are welcome! I am glad that it helped! --excelisfun

[@excelisfun]

No they are different, but the numbers from both a range and a named range will go into the function, like SUM. A range and a named range are both dynamic in the sense that if you insert a row between the two end cells, they will both update.

[@excelisfun]

EXCELlent!!!! Thanks for the 5 star rating!!

[@excelisfun]

I am glad thaey help - and there is no doubt, if you are good with Excel, employers love you!

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

[@TheMsKarena]

Kudos to you for sharing your love of learning and making it fun. You are helping me prep for my next job!

[@excelisfun]

You are welcome!

[@Darienbeagle]

I think your tutorials and workbooks are very well organized. Thanks so much; I really appreciate everything.

[@excelisfun]

You can either delete the name in Name Manager (Formulas Ribbon), or if you want to keep the name, just type the cell references into the formula.

[@jamesperry3837]

Many thanks Mike. There's so much to learn in Excel and i sure have a L-O-N-G way to go. I am always learning from a Excel guru.

[@excelisfun]

Dear adi2689, I am glad that you liked it! --excelisfun

[@excelisfun]

You are welcome! -Just a guy having fun with Excel.

[@excelisfun]

Dear LadyDboz, You are welcome! --excelisfun

[@excelisfun]

I just added a whole playlist with videos about keyboard shortcuts. Do you know how to find the Playlists?

[@excelisfun]

I am not sure what you mean? What are you referring to?

[@excelisfun]

EXCELlent!!!

[@STARNAVNEET]

Very good tutorial to learn about Excel. Thank to the uploader..

[@misfit2022]

I am sure you have a work around to this but I do occasionally use individual additions. Let's say I pivot data to find out my admin fees for the year are £1m and I will have other items in that pivot so that will not change as that £1m are the costs. New costs will be in a new year. If I then want to split down further say R&D, Office, Marketing. Sometimes it is easier just to do quick calcs at the bottom and add individually. Yes I could copy the data and do index and match to another schedule but sometimes it is just quicker. I think if your data is not going to change then it is fine but I take your point and it would be no good for areas where changes could occur such as a prepayment schedule. Good videos.

[@7caspeus]

Thanks for the awesome videos. Quick question: Once you name a specified range, for instance "sd," can you un-name the range and let the cells be their original names?

[@benblue2012]

Dear ExcellsFun, I would like to ask you that do u hv Excel basic for 2010 version?

[@LadyDboz]

wow i love this, thanks so much

[@vesee]

In our case Excel Basics #6 what does the number 12152.89 tells me? (stdevp)

[@adi2689]

AWSOME

[@BobbyLazh]

Wooow He used Internet Explorer :OOO