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" 

What Quality Professionals Need to Know to Get the Most from Excel
 
DATES & TIMES
February 16, 2012, at 1:00 p.m. EST | 10:00 a.m. PST
Please check your time zone for the correct local time.
 
 
LENGTH
Three 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

BONUS!
  • Unlimited viewing of the recorded version of this webinar for 14 days. So even if you forget to attend or can't make the live version, you can still get the information you need.
  • Certificate of attendance for each PAID participant
  • Get your specific questions answered in a live Q&A session during the webinar
  • Our money-back guarantee
 
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 Web link to access the visual portion of the event through your Web browser. It will also contain an a phone number and access code that you will use to hear the audio portion of the event. 
 
 
PRICING
We are so confident that you will find this webinar valuable that we offer a 100% money back guarantee, making this a risk-free investment. If you are dissatisfied with the webinar, just let us know by phone or e-mail within 24 hours of the conclusion of the webinar, and we will issue you a full refund.


PLEASE NOTE: Participation in this webinar is just $299 per site and allows access to one Internet connection and one phone line.



Price: $299.00 


This product qualifies for quantity discount pricing.

(what's this?)


Quantity:  

Enter number of participants above and the name and e-mail of each PAID participant below:

 

A Basic Approach to Root Cause Analysis
A Basic Approach to Root Cause Analysis
Introduction to Cost of Quality
Introduction to Cost of Quality
Procedure Writing
Procedure Writing
Calibration: What Auditors Look for in a Controlled Process
Calibration: What Auditors Look for in a Controlled Process