Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Data Analysis Basics Getting to Know Your Data Is Our Data Normal?

Posted by Michael Erotokritou
Michael Erotokritou
2,399 Points

Second and Third standard deviation

Hello. I am working through the video named 'is our data normal?' Im at the stage where i have found the percentage of runners within one standard deviation of the mean. From there you go onto using this to get the second and third standard deviation. At this stage you make the formulae absolute by adding '$' signs? I'm confused as there is no previous discussion about making this absolute or what you're doing. I don't know what is happening here and would like some help if possible please?

Kind Regards

1 Answer

spencer tintorri
spencer tintorri
6,184 Points
spencer tintorri
spencer tintorri
6,184 Points

Using $ to make cell references "absolute" will prevent the cell references from changing when dragging the formula down to the new cells. Without the $, the cell references would change, and the formula wouldn't work as intended.