Center for Quality and Applied Statistics
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.
- 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.
COST: Contact Greg Evershed, Director of Business, at 585-475-5442 or firstname.lastname@example.org. Continental breakfast and lunch is included each day of the seminar.