Excel for Data Analysis and Decision Making

This three-day hands-on course shows you how to use Microsoft® Excel for making sense of data. You will enhance your data analysis skills and learn how to interpret the Excel output. All basic statistical techniques are explained, as well as how to design spreadsheets that allow you to see consequences of your statistical analyses and get immediate feedback. The seminar also demonstrates how to plan your data collection process so that meaningful information can be extracted with the minimum cost and effort, and how you can produce reports with defendable statistical analyses. 2.1 CEUs.

Topics include:

• Data collection process
• Types of data
• Graphical methods
• Summary statistics
• Sampling distributions
• Survey sampling and design
• Hypothesis testing
• Confidence intervals
• Analysis of variance
• Correlation and regression
• Time dependent data

Who should attend?

Individuals who already use Microsoft® Excel for data collection and manipulation. Only basic knowledge of Excel is expected.

In addition, we offer custom workshops on many other topics related to quality systems, data analysis and process improvement including SPC, Survey Design, Data Mining,  and Process Mapping.