Introduction to Statistics with Excel

In this course students will learn not only the important statistical notions and methods, but they will also learn powerful techniques to perform the necessary numerical calculations or figure constructions to analyze statistical problems.

During the course, we will use the graphical abilities and the built in statistical functions of the user friendly Microsoft Excel program to make figures about and calculations with data arising from real life problems or simulations as well. (The lectures will be held in a computer laboratory. Having some experience with Excel is an advantage but not a prerequisite for the course.)

We will take the first basic 6 chapters of the text-book in this course. We plan to offer a course on the consecutive chapters, which deal with more specific statistical problems like estimation, hypothesis testing, regression, etc., in the winter term.

Course details

Level: Beginner / Intermediate
Instructor: Andras Vetier
Max. no. of participants: 20
Computer Lab: #1
Duration: 12 days
Requirements for pass: minimum attendance: 8 days
When the course is offered: see the list of courses for the current semester and/or the University Information System

Course outline

• Descriptive statistics: graphical and numerical methods for describing data.
• Notion of probability and conditional probability.
• Discrete random variables. Binomial and Poisson distributions.
• Continuous random variables. Uniform, normal, and exponential distributions
• Central limit theorem

Further Reading

• James T. McClave - Frank H. Dietrich, II: Statistics, 5th ed.

NOTE: all links open in new windows.