Data Analysis Using Excel
Data Analysis Using Excel

E-mail this product to a friend E-mail this product to a friend


Previous  Up  Next" 

ON-DEMAND WEBINAR
Access Anytime!

Access the recorded version of this webinar anytime from any computer. Attend when it's most convenient for you. You can access the webinar as often as you like from any location for ONE FULL YEAR from the date of registration. You will also be able to download a PDF of the course materials.

 
LENGTH
3 Hours
 
 
PRICE
$299
 
 
SUMMARY
Most everyone in business has Microsoft’s spreadsheet, Excel. Although Excel has proven to be one of the most widespread applications, few people make use of more than a few of its capabilities. This course is intended to help quality professionals understand a few basic statistical concepts that help in data analysis. This workshop will use demonstrations and a step-by-step handout to show how Excel’s statistical functions work. At the end of the course, participants can opt to receive a template spreadsheet via email for their own use.

In this course, Excel demonstrations will show the content. To help take notes, participants receive a handout for note-taking prior to the class. You will also receive an Excel template at the end of the class.


 
KEY COURSE OBJECTIVES
  • Understand some primary statistical concepts
  • Learn to use many of Excel’s statistical functions
  • Learn some of Excel’s powerful but less-known features

KEY TOPICS
  • Choosing sample sizes
  • Generating a custom random number table
  • Calculating measures of central tendency and variability
  • Figuring process capability (Cp and Cpk)
  • Making charts quickly for clear display of quantitative information
  • Drawing a frequency histogram in Excel
  • Making scatter plots, correlations and for data analysis
  • Performing linear regression for data analysis
  • Using a simple Gantt chart to manage small projects
  • Learning tips for the effective use of Excel
 
PRESENTER

 

Douglas C. Wood is the principal in DC Wood Consulting, LLC. The firm focuses on quality control consulting, business information planning, data analysis and related areas. He has more 30 years' experience in industrial engineering and quality. He has saved millions of dollars at client firms and employers through his practical approach to measurement implementation.

He is the author of 
The Executive Guide to Understanding and Implementing Quality Cost Programs, published by ASQ Quality Press.

Wood is active in ASQ, serving in the past as Kansas City section chair, education chair, site committee chair for the 2003 Annual Quality Congress, and Quality Management Division (QMD) Cost of Quality technical committee chair. A senior member of ASQ, he holds two ASQ Certifications: CQE and Certified Manager of Quality/Organizational Excellence.

He has been an examiner with the Kansas state quality award and the Missouri state quality award, and a lead examiner with the Kansas award in 2002. He is currently serving on an interdisciplinary task force providing strategic direction on a new multiyear research initiative exploring the economics of a wasteful society.
 
HOW DOES THIS ALL WORK?
After you register for the webinar, you will receive a confirmation e-mail. It will contain a link to access the recorded webinar through your Web browser. The e-mail will also contain a link to the course materials. You can access the recorded webinar for one full year from the date of your registration. You will need the link that will be e-mailed to you each time you wish to access the webinar.

PLEASE NOTE: The link to access the webinar will be e-mailed to you immediately after you register. If you do not receive the link, please check your spam or junk mail folder.


Price: $299.00 


Quantity:   

Data Analysis Using Excel
Data Analysis Using Excel
A Basic Approach to Root Cause Analysis
A Basic Approach to Root Cause Analysis
Introduction to Root Cause Analysis Video
Introduction to Root Cause Analysis Video
Developing an Effective Corrective Action Plan
Developing an Effective Corrective Action Plan