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