CQAS Webinars

 

Understanding Data with Graphs in Excel

 

We know that a picture is worth a thousand words. It is especially relevant when analyzing large data sets, or making presentations. In this webinar, you will learn how to describe your data in a concise and informative way by using bar charts, line charts, and scatter plots. You will also learn how to use moving averages and exponential smoothing for analyzing time depended data. This webinar consists of two 3-hour sessions scheduled on two different days. The participants will work through a combination of online instructions, demonstrations, and hands-on computer practice.

 

Topics include:

• Pie charts and bar charts
• Representation of time depended data by using line charts
• Moving averages and exponential moving averages for analyzing time depended data
• Scatter plots for investigation of correlations and trends

 

You will benefit by:

• Efficient representation of your data with graphs
• Improving your understanding of large data sets by using graphs
• Learning how to smooth time depended data with moving averages and exponential smoothing

 

Who should attend

 

All users of Excel. Some prior experience with Excel is recommended (which can be fulfilled by taking our webinar on Using Functions and Formulas in Excel).

 

Cost

 

$295.

Meet your instructor

 

Peter Bajorski, Ph.D., is an Associate Professor at CQAS. He has 28 years of experience in teaching and consulting. He teaches academic courses in statistics as well as short courses for corporate clients in data analysis and Lean Six Sigma. Peter also performs statistical consulting in engineering, finance, and management applications. Prior to joining RIT, he held positions at Cornell University, the University of British Columbia, Simon Fraser University, and the New York State Department of Transportation.