(327) Standard Deviation

Introduction to Standard Deviation

Standard deviation is an important statistic when collecting data in science labs.
Alongside average, it helps to understand the variation in data samples.
This video covers the concept, manual calculation, and spreadsheet calculation of standard deviation.

Normal Distribution: Represented by a bell-shaped curve.
- Example: Average height of men in the U.S. is 5 foot 9 (mean).
- Most data points are clustered around the mean, but some vary above and below.
Standard Deviation: Measures the spread or variation of data around the mean.
- Approximately 68% of individuals fall within 1 standard deviation from the mean.
- About 95% fall within 2 standard deviations.
- Around 99% fall within 3 standard deviations.
Different datasets can have different standard deviations:
- A tighter curve indicates a smaller standard deviation.
- A wider curve indicates a larger standard deviation.

Formula: [ \sigma = \sqrt{\frac{\Sigma (x - \bar{x})^2}{n-1}} ]
Steps to calculate:
1. Identify Data Set: Example data: 1, 2, 3, 4, 5.
2. Calculate Mean (\bar{x}): ( (1 + 2 + 3 + 4 + 5) / 5 = 3 )
3. Calculate Each (x - \bar{x}) and Square It:
  - For 1: ( (1 - 3)^2 = 4 )
  - For 2: ( (2 - 3)^2 = 1 )
  - For 3: ( (3 - 3)^2 = 0 )
  - For 4: ( (4 - 3)^2 = 1 )
  - For 5: ( (5 - 3)^2 = 4 )
4. Add Up Squared Differences: ( 4 + 1 + 0 + 1 + 4 = 10 )
5. Divide by Degrees of Freedom (n - 1): ( 10 / (5 - 1) = 2.5 )
6. Take Square Root: ( \sqrt{2.5} \approx 1.58 )

Example dataset in Excel: 0, 2, 4, 5, 7.
Steps to Calculate:
1. Enter data into cells.
2. Calculate Mean: Use the command =average(range).
3. Calculate Standard Deviation: Use the command =stdev(range).
4. Result from spreadsheet for standard deviation of example data equals 2.7.

Understanding and calculating standard deviation helps analyze data more effectively.
Both manual calculations and spreadsheet methods are useful for determining standard deviation.