|
Title: Statistics for Data Analysis - Descriptive Statistics and Graphs
Date: November 15, 2010
Time: 8:30am - 4:30pm
Instructor: Bruce E. Truitt
Location: One Highland Center, 314 E. Highland Mall Blvd., Suite 403, Austin, TX 78752
Price: $225
Early Bird Discount: $199 if you register by October 15, 2010.
Who Should Attend: Auditors, investigators, and evaluators
Laptop Requirement for Course: Each attendee must bring a laptop to class with a licensed version of Microsoft Excel and Word. The Data Analysis Add-Ins "Analysis ToolPak" and "Analysis ToolPak-VBA" must be installed on the computer before you get to class. Ideally your laptop will have a CD drive.
Course Description:
This one-day informative course provides step-by-step instructions for using Excel to thoroughly describe and display any data set. Providing real-world audit applications, this course will provide tools and methods actually used to describe and display data. Our instructor effectively and interestingly ties automation, statistical theory, evaluation methodology, and applied statistics together into a single, easy-to-use package.
Upon completion of this course, participants will be able to:
Define the terms, concepts, parameters, and objectives of using descriptive statistics and graphs to characterize any data set.
Use Microsoft Excel to generate descriptive statistics and graphs.
Identify the differences between and uses of nominal, ordinal, and interval data.
Calculate, interpret, and explain the mean, median, mode, variance, standard deviation, standard error, minimum, maximum, range, skew, and kurtosis of a data set.
Use descriptive statistics to determine the normality of a data set.
Assess the impact of non-normality on data utility.
Identify and use basic strategies for improving the utility of non-normal data.
Design and calculate the parameters of frequency distributions.
Use frequency distributions to summarize data sets and construct graphs.
Determine which graphic displays best suit different types of data.
Change graphic displays of data sets from one type to another.
Insert graphs into word-processed documents.
Identify and compensate for the inappropriate manipulation of quantitative data and graphic displays.
Establish the advantages and limitations of descriptive statistics and graphic techniques and ensure that descriptive data analysis stays within such limitations
Instructor Bio: Bruce E. Truitt
Bruce Truitt has 25+ years experience in applied statistics and government auditing, with particular focus on quantitative methods and reporting in health and human services fraud, waste, and abuse. His tools and methods are used by public and private sector entities in all 50 states and 33 foreign countries and have been recognized by the National State Auditors Association for Excellence in Accountability.
He also teaches the US Government Auditor’s Training Institute’s "Practical Statistical Sampling for Auditors" course, is on the National Medicaid Integrity Institute’ faculty, and taught Quantitative Methods in Saint Edward's University's Graduate School of Business.
Bruce holds a Master of Public Affairs from the LBJ School of Public Affairs, as well as Masters Degrees in Foreign Language Education and Russian and East European Studies from The University of Texas at Austin.
CPE: 8 hours
TX Board of Public Accountancy Sponsor Number: 009317
Cancellation Information: Cancellation Date: October 25, 2010
To cancel your registration from this course, please call or email the course
contact listed below. If a cancellation is received after the cancellation
date, the registrant will be charged $125 for course materials.
If you are making travel plans to come to the training, please make "refundable" air and hotel reservations or wait until 14 days before the class to actually book your reservations. Courses are occasionally canceled or rescheduled due to low enrollment. We determine whether a course has enough participants approximately 16 days prior to the course date. If we cancel or reschedule, we will email the participant no later than 14 days before the original class date. Solutions Training will not pay for cancellation/change fees associated with travel and hotel arrangement changes.
Class participants will
be billed after the class. Payment should be made to SOLUTIONS TRAINING GROUP,
Federal Tax ID: 20-2732184 and mailed to 2701 Maria Anna Rd, Austin, TX 78703.
If you have any questions, please contact Shannon Bieberdorf at (512) 914-5557
shannon@solutionstraininggroup.com. For
additional information about this class, please contact Laurie Garrant at laurie@solutionstraininggroup.com,
(512) 914-5567.
|