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