CQAS Seminars

 

Using 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.

Cost

 

$895. This cost includes a continental breakfast and lunch each day.

Meet your instructor

 

Peter Bajorski, Ph.D., is a CQAS faculty member. Prior to joining RIT, he was performing statistical consulting for a wide range of clients in engineering, finance, and management at the New York State Department of Transportation. He also served as a principal investigator of several applied-research projects. He taught and conducted research at Cornell University, the University of British Columbia, and the Technical University of Wroclaw (Poland).