Statistical Data Analysis in Excel
LuciLinx-2010 Workshop
14-06-2010, Luxembourg

by Petr NAZAROV
Microarray Center, CRP-Sante

MATERIALS
  • Lecture (part 1)
  • Lecture (part 2)
  • Function Reference Card
  • Practical Tasks

  • DATA
  • all_data.xls 18M
  • beer.xls 23K
  • bloodpressure.xls 13K
  • cells.xls 13K
  • chemline.xls 14K
  • depression.xls 14K
  • mice.xls 152K
  • pancreatitis.xls 41K

  • LINKS
  • LuciLinX: Luxembourg Bioinformatics Network
  • CRP-Sante: Centre de Recherce Public - Sante
  • UniLu: University of Luxembourg
  • SABLab: Systems Analysis in Biology webpage

  • CC-BY-ND P.V.Nazarov
    You are free to use the information presented here for your own education or non-profit activity. Please cite the source.

    The course gives an overview of applied statistical data analysis in Excel. It is oriented at researchers, engineers and students, who having no advanced knowledge in statistics, use or would like to use its methods in their practice. Practical examples (conducted in Excel) are integrated into the workshop, allowing immediate application of the obtained knowledge.

    Offered by: LuciLinX and the Microarray Center of CRP-Sante
    When: 14 June 2010, 9:00 - 16:00
    Where: University of Luxembourg, Batiment des Sciences, BS0.12
    Duration: 6-hour course, divided into 4 sections of 1.5 hours each (equivalent to 8 academical hours)



    We would like to thank University of Luxembourg, especialy professors Thomas Sauter and Carsten Carlberg for the support of the lectures.



    The lectures covers the following topics:

        Section I. Introduction to statistics
    • Descriptive statistics: numerical measures and graphical presentation
    • Detection of outliers using z-score. Chebyshev's theorem
    • Discrete probability distributions
    • Continuous probability distributions
          Section II. Sampling statistics and hypothesis testing
    • Sampling and sampling distribution
    • Central limit theorem and its practical outcomes
    • Interval estimation for the means and proportions
    • Unpaired and paired t-test
          Section III. Linear modeling: ANOVA and Linear Regression
    • ANOVA
    • Linear regression
          Section IV. Advanced topics
    • Chi-square test of independence
    • Multiple hypothesis testing
    • Simulation-based analysis

    Literature
    1. Anderson D.R., Sweeney D.J., Williams T.A. Statistics Business and Economics, 9th ed.
    2. Glover T., Mitchel K., An Introduction to Biostatistics, 2nd ed.
    3. van Belle G. Statistical Rules of Thumb, 2008, John Wiley & Sons, Inc. Hoboken, NJ




    Contacts:
          Luxembourg Bioinformatics Network LuciLinx: www.lucilinx.lu
          Dr. Petr NAZAROV
             Microarray Center, CRP-Sante, Luxembourg
             petr.nazarov(at)crp-sante.lu

    In the case of mistakes or possible copyright violations, please, contact the webmaster. Last update 15-06-2010