Excel Basics #7: Range Functions

[Darienbeagle]

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

[ExcelIsFun]

You are welcome!

[ctotheJdogg07]

Is naming the cells the same as selecting a range? (Is the naming of cells dynamic, like selecting a range?)

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

[vesee]

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

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

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]

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

[fahadsaeed50]

best video

[ExcelIsFun]

EXCELlent!!!!

Thanks for the 5 star rating!!

[adellutza]

what happend with your voice ? :(  untill now it was great now it's not so great

[ExcelIsFun]

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

[gastonytHQ]

yeah u sound sick

[ExcelIsFun]

I am glad that the videos are hepful!

[thirthyest]

i love keyboard shorcuts!

[ExcelIsFun]

I just added a whole playlist with videos about keyboard shortcuts.

Do you know how to find the Playlists?

[thirthyest]

yes i know how to find playlists

i'll take look :))

[ExcelIsFun]

EXCELlent!!!

[LadyDboz]

wow i love this, thanks so much

[ExcelIsFun]

Dear LadyDboz,

You are welcome!

--excelisfun

[adi2689]

AWSOME

[ExcelIsFun]

Dear adi2689,

I am glad that you liked it!

--excelisfun

[blupears]

i learn a lot. thnx

[ExcelIsFun]

Dear blupears,

You are welcome! I am glad that it helped!

--excelisfun