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 trialMichael Erotokritou
2,399 PointsSecond 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
6,184 PointsUsing $ 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.