Class 5: Practical examples in Excel

Systems Biology

Andrés Aravena, PhD

October 15, 2021

Start with a drawing

What we measure

What we measure

What we measure

Measured = Real ⊕ Diversity ⊕ Instrument ⊕ Noise

  • Normalization and calibration get rid of Instrument
  • Technical replicas control noise
  • We get Individual Weight
  • Biological replicas control diversity

The complete picture

Linear models using Excel

Key ideas

  • One row for each replica
  • One column for each variable
  • One and only one value in each cell
    • No ranges
  • Do not use color or style to represent information
  • Sheet for analysis ≠ sheet for presentation
    • presentation data should be made automatically from from analysis data