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