Topic: Make Smart Decisions Using Statistics and Excel
Date: Monday and Tuesday, August 20 and 21, 2007
Time:
8:00 am – 8:30 am (Registration/Continental Breakfast)
8:30 am – 5:00 pm (Workshop)
Location:
Lower Colorado River Authority Headquarters
3700 Lake Austin Boulevard
Austin, Texas 78703
Cost:
$775 – CTCBA Member
$825 – Non-Member
Cost includes extensive workshop textbook,
continental breakfast and lunch on both days
RSVP:
Register by 5 pm, Monday, August 6 to by emailing dtucker@ctcba.org or calling 512-233-2212. No cancellations after that date. No shows will be billed. Cash, checks, MasterCard, Visa or American Express accepted for payment.
Class size limited to first 12 participants.
Participants will have a unique and very helpful “how to” hands-on learning experience that combines statistical theory with practical applications. The workshop is led by John H. Davis, Ph.D., CCP, a nationally recognized consultant and teacher of statistics and compensation.
You will learn the actual techniques that John Davis has developed and uses in his practice.
Who Is This Workshop For
Any compensation professional who works with numbers, quantitative information, or qualitative data that can be translated into numbers with find this workshop of value. If your job entails understanding, describing, modeling, predicting, or presenting quantitative information and relationships, this workshop is for you.
What You Will Learn
This workshop blends statistical theory with application using Excel. A good portion of the content is learning various Excel “tricks.”
At the end of the workshop, participants will have gained an understanding of the most useful basic to statistics used by compensation professionals and an ability to apply those statistics using Excel. The major concepts presented are:
- Frequency distributions and histograms
- Measures of location – mode, median, means, percentiles
- Measures of variation – standard deviation, coefficient of variation, P90/P10
- Simple linear regression
- Nonlinear regression – power and exponential models
- The two major methods of salary survey analysis and pay structure development
- Multiple linear regression overview
This workshop will be held in a computer lab and all software necessary to complete the workshop will be provided. You will leave with an extensive textbook of information covered in the course. Prerequisites for this workshop are an eagerness to learn, an openness to working with new ideas and some familiarity with Excel (being a power user is not necessary). It will also be helpful if you have some familiarity with basic descriptive statistics and your job entails working with and understanding quantitative information.
What participants are saying about this course:
Thank you for providing a class that was both theoretical and practical. I am certain I will use what I’ve learned every day!
This is the most valuable training I’ve taken in the past 5 years!
Great course. Very applicable and practical. The textbook will be a great reference tool.
This exceeded all my expectations. Thank you for this amazing class!
As always, John is a wonderful instructor.
About The Presenter
John H. Davis, Ph.D., CCP, is President of Davis Consulting and is a nationally recognized consultant and teacher of reward systems and compensation strategy. With over 25 years of compensation practitioner and consulting experience, he brings a strong analytical background to help his clients with their compensation programs. He has consulted with many Fortune 500 Companies on surveys, statistics, base pay programs, incentive programs, and performance management programs.
John serves on the faculty of the WorldatWork certification program and has helped develop their two quantitative analysis courses for them. He has taught graduate-level courses in compensation, and is a popular speaker and workshop leader for compensation and human resources associations across the country.
John is the author of Salary Surveys and Antitrust: An Overview for the HR Professional and Sound Compensation Practices: A Theoretical Foundation, a reviewer for the WorldatWork Journal, and the author of various articles in both the WorldatWork Journal and Compensation & Benefits Review.
John holds a Ph.D. in Statistics from Ohio State University, and is recognized by the WorldatWork as a Certified Compensation Professional.
Attendees do not need to bring a laptop to this course!
CTCBA Members Click Here:
Non-CTCBA Members Click Here:
