Review Excel

In this course, you are asked to create charts and calculate averages and standard deviations.  If you do not know how to do so, please use the following three tutorials to learn more.  To see the slides, you need Microsoft Power Point.  To listen to narrated slides you need Flash.  Download►

1. Introduction to worksheets, cells, formulas  Slides► Listen►
2. Excel basic functions, sum, average, count  Slides► Listen►
3. How to plot a control chart   Slides►  Listen►
4. How to use an IF function Listen► You Tube► SWF►

If you wish to use Excel to conduct statistical analysis of data, you have to add in data analysis feature of Excel. Video► SWF►

• Descriptive statistics Slides 1► Video 1► Slides 2►Video 2►
• Analysis of mean of a sample Slides► Video►
• Analysis of means of two samples Slides► Video►
• Analysis of variance Slides► Video►
• Correlation Slides ► Video►
• Single variable regression Slides► Video►
• Multiple regression analysis Slides► Video►

A number of other self-paced instruction on Excel are available online  More► Video►  List►