Data Analysis and Problem Solving with Excel

At-a-Glance

Data is everywhere, but how should you organize it, visualize it, and utilize it to solve problems and make data-driven decisions?  This three-day hands-on workshop will show you how to use Microsoft® Excel for making sense of data. You will enhance your data analysis skills and learn how to interpret Excel output. All basic statistical techniques are explained as well as how to design spreadsheets that allow you to see the consequences of your statistical analyses and get immediate feedback. The workshop will also demonstrate 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.

Course Topics

• 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 with a basic knowledge of Microsoft® Excel, who would like to learn more about Excel’s powerful capabilities for data collection, manipulation, problem solving, and decision making.