Excel Basics #7: Range Functions

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#7 Video topics:
1)See how a range function is more efficient than a formula without a range function
2)=SUM(A13:A18) is better than =A13+A14+A16+A17+A18+A19
3)Insert a row and the range function will automatically update

Category:

Science & Technology

Tags:

• Excel
• range
• function
• SUM
• formula
• cell
• references
• insert
• row
• Mike
• Gel
• Girvin
• Highline
• Community
• College

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

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]

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]

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]

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

[TheMsKarena]

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