BIOLOGY FOR LIFE
  • Syllabus
    • Core >
      • 1: Cell Biology >
        • 1.1: Introduction to Cells
        • 1.2: Ultrastructure of Cells
        • 1.3: Membrane Structure
        • 1.4: Membrane Transport
        • 1.5: The Origin of Cells
        • 1.6: Cell Division
      • 2: Molecular Biology >
        • 2.1: Molecules to Metabolism
        • 2.2: Water
        • 2.3: Carbohydrates and Lipids
        • 2.4: Proteins
        • 2.5: Enzymes
        • 2.6: DNA and RNA
        • 2.7: DNA Replication, Transcription and Translation
        • 2.8: Cell Respiration
        • 2.9: Photosynthesis
      • 3: Genetics >
        • 3.1: Genes
        • 3.2: Chromosomes
        • 3.3: Meiosis
        • 3.4: Inheritance
        • 3.5: Genetic Modification and Biotechnology
      • 4: Ecology >
        • 4.1: Species, Communities and Ecosystems
        • 4.2: Energy Flow
        • 4.3: Carbon Cycling
        • 4.4: Climate Change
      • 5: Evolution and Biodiversity >
        • 5.1: Evidence for Evolution
        • 5.2: Natural Selection
        • 5.3: Classification and Biodiversity
        • 5.4: Cladistics
      • 6: Human Physiology >
        • 6.1: Digestion and Absorption
        • 6.2: The Blood System
        • 6.3: Defense Against Infectious Disease
        • 6.4: Gas Exchange
        • 6.5: Neurons and Synapses
        • 6.6: Hormones, Homeostasis and Reproduction
    • Higher Level >
      • 7: Nucleic Acids >
        • 7.1: DNA Structure and Replication
        • 7.2: Transcription and Gene Expression
        • 7.3: Translation
      • 8: Metabolism, Cell Respiration & Photosynthesis >
        • 8.1: Metabolism
        • 8.2: Cell Respiration
        • 8.3: Photosynthesis
      • 9: Plant Biology >
        • 9.1: Transport in the Xylem of Plants
        • 9.2: Transport in the Phloem of Plants
        • 9.3: Growth in Plants
        • 9.4: Reproduction in Plants
      • 10: Genetics and Evolution >
        • 10.1: Meiosis
        • 10.2: Inheritance
        • 10.3: Gene Pools and Speciation
      • 11: Animal Physiology >
        • 11.1: Antibody Production and Vaccination
        • 11.2: Movement
        • 11.3: Kidney and Osmoregulation
        • 11.4: Sexual Reproduction
    • Options >
      • D: Human Physiology >
        • D.1: Human Nutrition
        • D.2: Digestion
        • D.3: Functions of the Liver
        • D.4: The Heart
        • D.5: Hormones and Metabolism
        • D.6: Transport of Respiratory Gases
  • IB Requirements
    • Learner Profile
    • Group 4 Project
    • External Exam
    • Internal Assessment >
      • Personal Engagement
      • Exploration
      • Analysis
      • Evaluation
      • Communication
    • Extended Essay
  • Investigation Skills
    • Lab Safety
    • Microscopy
    • Lab Drawings
    • Data Tables
    • Measurement
    • Statistics >
      • Descriptive Statistics >
        • Skew
        • Measures of Central Tendancy
        • Measures of Spread
        • Pearson Correlation
      • Inferential Statistics >
        • T-Test
        • ANOVA
        • Kruskal-Wallis
        • X2 Test for Independence
        • X2 Goodness of Fit
    • Graphing >
      • Graphing with Excel
      • Interpreting Error Bars
    • Error Analysis
  • Course Info
    • Above & Beyond >
      • Biology Club
      • Pumpkin Carving
      • Scavenger Hunt
      • Science News
      • IB Bio Dance
      • Wood Duck Project
      • Invasive Crayfish Project
    • Assessment >
      • Class Grading IB Bio I
      • Class Grading IB Bio II
      • Daily Quizzes
      • Lab Practicals
    • Class Photos
    • Recommendations
    • Supplemental Reading
  • Contact
  • About
    • Philosophy
    • Resume
    • Reflection
    • Site Feedback
    • Favorite Quotes
    • AEF Blog
  • Expeditions
    • Bahamas (2009)
    • Trinidad (2010)
    • Trinidad (2011)
    • Ecuador (2012)
    • Trinidad (2013)
    • Peru (2014)
    • Bahamas (2015)
    • Peru (2016)
    • Costa Rica (2017)
    • Costa Rica (2018)
    • Arizona (2022)
    • Florida (2023)
  • Summer Ecology Research

Measures of Spread

Measures of spread are ways of summarizing a group of data by describing how spread out the values are. If the spread of values in the data set is large, the mean is not as representative of the data as if the spread of data is small. This is because a large spread indicates that there are probably large differences between individual data points.

The spread of the values can be measured for quantitative data, as the variables are numeric and can be arranged into a logical order with a low end value and a high end value. Measures of spread are used in conjunction with a measure of central tendency, such as the mean or median, to provide an overall description of a set of data. To describe spread, a number of statistics are available, including the range, quartiles and standard deviation. Which you use will depend on how much and the type of data you collected.​
What Measure of Central Tendency Did you Calculate?
Mean with 5 or more trials per level of manipulation
Standard Deviation
Mean with 4 or less trials per level of manipulation
Range
Median with 5 or more trials per level of manipulation
Quartile
Median with 4 or less trials per level of manipulation
Range

Standard Deviation

Averages do not tell us everything about a sample.  Samples can be very uniform with the data all bunched around the mean (Figure 1) or they can be spread out a long way from the mean (Figure 2). The statistic that measures this spread for normally distributed data is called the standard deviation. The wider the spread of scores, the larger the standard deviation. 
Picture
For data that has a normal distribution, 68% of the data lies within one standard deviation of the mean.
Picture

How to Calculate the Standard Deviation:  ​

Picture
  1. Calculate the mean (x̅) of a set of data​
  2. Subtract the mean from each point of data to determine (x-x̅).  You'll do this for each data point, so you'll have multiple (x-x̅). 
  3. Square each of the resulting numbers to determine (x-x̅)^2.  As in step 2, you'll do this for each data point, so you'll have multiple (x-x̅)^2. 
  4. Add the values from the previous step together to get ∑(x-x̅)^2.  Now you should be working with a single value.  
  5. Calculate (n-1) by subtracting 1 from your sample size.  Your sample size is the total number of data points you collected. 
  6. Divide the answer from step 4 by the answer from step 5
  7. Calculate the square root of your previous answer to determine the standard deviation.
  8. Be sure your standard deviation has the same number of units as your raw data, so you may need to round your answer.  
  9. The standard deviation should have the same unit as the raw data you collected.  For example, SD = +/- 0.5 cm.  

Calculating the Standard Deviation in Sheets

  • ​In our class, the formula we'll want to  use is  =STDEV(A1:A100).  Replace A1:A100 with your data by highlighting the cells with data you want to include in the standard deviation calculation.
  • Calculating the Standard Deviation in Google Sheets (website)
  • Finding the Standard Deviation in Google Sheets (video)
  • Changing the number of digits displayed in your Google Sheet (website)

Using Excel to Calculate the Standard Deviation 

  • Use Excel to calculate the mean of your data.
  • Click on the box in which you want the Standard Deviation to be placed  
  • Click the "Formulas" tab at the top of the screen
  • Select the “Insert Function button”​​
  • Search to find the STDEV option, click OK​​
  • Highlight the data of which you want the SD to be calculated, click OK.  Be sure not to select the mean as one of  your data points for calculating standard deviation.  This is a common mistake. 
  • Once you have the mean and standard deviation, you need to make sure that you set the values to the correct number of digits.  EXCEL will default to giving you too many numbers after the decimal place.  Your mean and standard deviation must have the same precision (number of digits after the decimal) as your data points.  To do this, click the box which is displaying the standard deviation and on the "Home" tab click the decrease decimal button until you have the correct number of digits showing.

Quartiles

Quartiles  divide an ordered dataset into four equal parts, and refer to the values of the point between the quarters. Quartiles are a useful measure of spread because they are much less affected by outliers or a skewed data set than the standard deviation. For this reason, quartiles are often reported along with the median as the best choice of measure of spread and central tendency, respectively, when dealing with skewed and/or data with outliers. 

A common way of expressing quartiles is as an interquartile range. The interquartile range (IQR) describes the difference between the third quartile (Q3) and the first quartile (Q1), telling us about the range of the middle half of the scores in the distribution.  The IQR is often seen as a better measure of spread than the range as it is not affected by outliers
Picture
  • Online calculators, such as https://www.calculatorsoup.com/calculators/statistics/quartile-calculator.php 
  • Excel or Google Sheets =QUARTILE(highlight data cells,quart)
    • quart - The quartile value to return.  1 is the first quartile, 2 is the medium, 3 is the third quartile.
    • Example =QUARTILE(A1:A20,3)

Range

Range is the difference between the smallest value and the largest value in a dataset.  Range is used if there are less than 5 trials that are being used to calculate a measure of central tendency.. 
Picture
  • Online calculators, such as http://www.alcula.com/calculators/statistics/range/ 
  • ​Excel or Google Sheets =MAX(highlight data cells)-MIN(highlight data cells)
I give many of my IB Biology resources away, for the benefit of students and teachers around the world. 
If you've found the materials helpful, please consider making a contribution of any amount
to 
this Earthwatch Expedition Fund. 

​Did I forget something?  Know of a mistake? Have a suggestion?  Let me know by emailing me here.

Before using any of the files available on this site,
​please familiarize yourself with the 
Creative Commons Attribution License. 
​​​It prohibits the use of any material on this site for commercial  purposes of any kind.  ​


"When we try to pick out anything by itself, we find it hitched to everything else in the Universe." 
 John Muir,   1911
  • Syllabus
    • Core >
      • 1: Cell Biology >
        • 1.1: Introduction to Cells
        • 1.2: Ultrastructure of Cells
        • 1.3: Membrane Structure
        • 1.4: Membrane Transport
        • 1.5: The Origin of Cells
        • 1.6: Cell Division
      • 2: Molecular Biology >
        • 2.1: Molecules to Metabolism
        • 2.2: Water
        • 2.3: Carbohydrates and Lipids
        • 2.4: Proteins
        • 2.5: Enzymes
        • 2.6: DNA and RNA
        • 2.7: DNA Replication, Transcription and Translation
        • 2.8: Cell Respiration
        • 2.9: Photosynthesis
      • 3: Genetics >
        • 3.1: Genes
        • 3.2: Chromosomes
        • 3.3: Meiosis
        • 3.4: Inheritance
        • 3.5: Genetic Modification and Biotechnology
      • 4: Ecology >
        • 4.1: Species, Communities and Ecosystems
        • 4.2: Energy Flow
        • 4.3: Carbon Cycling
        • 4.4: Climate Change
      • 5: Evolution and Biodiversity >
        • 5.1: Evidence for Evolution
        • 5.2: Natural Selection
        • 5.3: Classification and Biodiversity
        • 5.4: Cladistics
      • 6: Human Physiology >
        • 6.1: Digestion and Absorption
        • 6.2: The Blood System
        • 6.3: Defense Against Infectious Disease
        • 6.4: Gas Exchange
        • 6.5: Neurons and Synapses
        • 6.6: Hormones, Homeostasis and Reproduction
    • Higher Level >
      • 7: Nucleic Acids >
        • 7.1: DNA Structure and Replication
        • 7.2: Transcription and Gene Expression
        • 7.3: Translation
      • 8: Metabolism, Cell Respiration & Photosynthesis >
        • 8.1: Metabolism
        • 8.2: Cell Respiration
        • 8.3: Photosynthesis
      • 9: Plant Biology >
        • 9.1: Transport in the Xylem of Plants
        • 9.2: Transport in the Phloem of Plants
        • 9.3: Growth in Plants
        • 9.4: Reproduction in Plants
      • 10: Genetics and Evolution >
        • 10.1: Meiosis
        • 10.2: Inheritance
        • 10.3: Gene Pools and Speciation
      • 11: Animal Physiology >
        • 11.1: Antibody Production and Vaccination
        • 11.2: Movement
        • 11.3: Kidney and Osmoregulation
        • 11.4: Sexual Reproduction
    • Options >
      • D: Human Physiology >
        • D.1: Human Nutrition
        • D.2: Digestion
        • D.3: Functions of the Liver
        • D.4: The Heart
        • D.5: Hormones and Metabolism
        • D.6: Transport of Respiratory Gases
  • IB Requirements
    • Learner Profile
    • Group 4 Project
    • External Exam
    • Internal Assessment >
      • Personal Engagement
      • Exploration
      • Analysis
      • Evaluation
      • Communication
    • Extended Essay
  • Investigation Skills
    • Lab Safety
    • Microscopy
    • Lab Drawings
    • Data Tables
    • Measurement
    • Statistics >
      • Descriptive Statistics >
        • Skew
        • Measures of Central Tendancy
        • Measures of Spread
        • Pearson Correlation
      • Inferential Statistics >
        • T-Test
        • ANOVA
        • Kruskal-Wallis
        • X2 Test for Independence
        • X2 Goodness of Fit
    • Graphing >
      • Graphing with Excel
      • Interpreting Error Bars
    • Error Analysis
  • Course Info
    • Above & Beyond >
      • Biology Club
      • Pumpkin Carving
      • Scavenger Hunt
      • Science News
      • IB Bio Dance
      • Wood Duck Project
      • Invasive Crayfish Project
    • Assessment >
      • Class Grading IB Bio I
      • Class Grading IB Bio II
      • Daily Quizzes
      • Lab Practicals
    • Class Photos
    • Recommendations
    • Supplemental Reading
  • Contact
  • About
    • Philosophy
    • Resume
    • Reflection
    • Site Feedback
    • Favorite Quotes
    • AEF Blog
  • Expeditions
    • Bahamas (2009)
    • Trinidad (2010)
    • Trinidad (2011)
    • Ecuador (2012)
    • Trinidad (2013)
    • Peru (2014)
    • Bahamas (2015)
    • Peru (2016)
    • Costa Rica (2017)
    • Costa Rica (2018)
    • Arizona (2022)
    • Florida (2023)
  • Summer Ecology Research