Statistical Data Analysis in Excel
LuciLinx-2011 Workshop
31-10-2011, Luxembourg

Based on Lecture Course for MISB students of Luxembourg University
9-06-2011, Luxembourg

by Petr NAZAROV
Microarray Center, CRP-Sante

MATERIALS
  • 1.Introduction
  • 2.Interval estimations
  • 3.Testing hypotheses
  • 4.ANOVA
  • 5.Linear regression
  • 6.Advanced topics
  • Function Reference Card
  • Practical Tasks

  • DATA STORAGE

    LINKS
  • UniLu: University of Luxembourg
  • LuciLinX: Luxembourg Bioinformatics Network
  • CRP-Sante: Centre de Recherce Public - Sante
  • 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: LiciLinx, CRP-Sante, University of Luxembourg
    When: 31 October 2011, 9:00 - 17:00
    Where: University of Luxembourg, Batiment des Sciences, BS 0.11 (map)
    Duration: 10-hour course
    Note: we have 16 PC available and >20 participants. Please, take your laptops with you or be prepared to share computer with your colleague.



    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 interval estimations
    • Sampling and sampling distribution
    • Central limit theorem and its practical outcomes
    • Interval estimation for the means and proportions
          Section III. Testing hypotheses for means
    • Hypotheses about mean and proportion
    • Unpaired and paired t-test
          Section IV. ANOVA
    • 1-way ANOVA
    • 2-way ANOVA
          Section V. Linear regression
    • Simple linear regression
    • Statistical significance
          Section IV. Advanced topics
    • Multiple hypothesis testing
    • Chi-square test of independence
    • 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




    Contact:


          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 9-06-2011