Back to homepage Contact us  
List of training courses View trainer's profile

Course Details

 
 
 
 
 
 
 
 
BUSINESS STATISTICS FOR MANAGERS
(Made Easy with Microsoft® Excel)
   
iNTRODUCTION :
 
“This course revolutionalized the teaching of business statistics by integrating the use of MS Excel as a statistical tool for analysis and interpretation to make sound business decisions fast and simple !.”
 

Business managers in the 21st century have access to large amounts of information. A major issue is how to use the available information to make better decisions. Sorting, organizing and analyzing data becomes mere activities unless one is able to gain insights into what the data is revealing and accurately make use of the information for further actions. This training program teaches the basic principles and concepts of the use of statistics for decision-making and demonstrates the power of proven techniques used by highly successful managers in many functional areas of business such as accounting, finance, management, operation, and marketing. Statistics business scenarios are used extensively throughout the course to provide an applied context for the workings of statistics.

Unlike traditional Statistical courses that emphasize on meticulous calculations and deriving formula, this training program smartly utilizes common computer spreadsheet techniques (such as. MS Excel) to simplify tedious tasks such as calculations, graphing and searching of statistical tables.


Our emphasis, therefore, is to focus more on value-added learnings such as fast data analysis, interpreting results, taking actions to improve operational controls and making sound business decisions. Combining various teaching methods such as group discussions and real business case studies, this program also includes computer simulations with an emphasis on participation throughout. This training program is a must for modern managers, executives and engineers whose jobs require handling lot of data and making business and operational decisions.

COURSE OBJECTIVES:

At the end of the course, participants will..

  • Understand the overall concepts, principles and methods using Statistics for making sound business decisions.
  • Utilize the computer to quickly analyze data, transform it into valuable business information, and make business presentations.
  • Utilize the computer to quickly construct powerful tools for problem solving and operational controls.
  • Know how to efficiently draw conclusions about large populations based only on information obtained from samples
  • Perform hypothesis testings and Analysis of Variance (ANOVA) techniques.
  • Acquire working knowledge of process control and quality improvement techniques.
course contents:


Introduction:

  • Why use MS Excel as a statistical tool?
  • Easy charting and tabling techniques for better decision-making.
  • Easy graphing for business presentations.

Presenting Data & Describing Information

  • Collecting and organizing data
  • Accelerated method to construct problem solving tools (charts & tables)
  • Get new perspectives on data with pivot table.
  • Descriptive Statistics

Drawing Conclusions from populations, Based on Sample Information

  • Basic Probability & Discrete Probability Distributions
  • Normal Distribution & Sampling Distribution
  • Confidence Interval Estimation

Fundamentals of Hypothesis Testings:

  • What is and why do Hypothesis Testing?
  • One sample testing - - t-test, Z-test
  • Two-sample testing - - Z-test, F-test

Analysis of Variance (ANOVA)

  • What is and why do ANOVA?
  • One-way ANOVA
  • Two-way ANOVA

Simple Linear Regression Model and Correlation

  • Types of regression models
  • The Least-Squares method
  • Correlation coefficient
  • Interpret the effects of Price & Advertisements on Sales

Statistical applications in quality improvements

  • Prioritizing action plans with Pareto Diagram, separating the “Vital Fews” from the “Trivial Many”.
  • o Analyzing data with Histogram & Probability Plots
  • Basic principle of Statistical Process Control (SPC)
  • What is a control chart?
  • Using control charts to gauge and control process improvements

Exercises:

  • Real Business scenarios & Case studies
  • Decision-modeling
  • Individual & group exercises

**SPECIAL NOTE ** :

In order to achieve the accelerated learning objectives of this course, it is necessary that participants should already know how to use basic computer spreadsheet program (such as Microsoft ® Excel: using formula, edit graphs, printing, etc).

If the participant would like to have prior training on Microsoft® Excel basics before attending this course, please click here to find out more.

who should attend:
  • Managers, Engineers, Executives – all those who need to make business and operational decisions using statistical methods in their work.
administrative details :
Duration : 2 days
Time : 9.00am - 5.00pm
Venue : In-house or public program
Language medium : English
 
 
Trainer :
Nelson Kok (please click here to see trainer's profile)
 
 
 
 

Click on the above banner to find out more about other Accelerated Learning Courses
Back to Top
 
Home | Courses | Trainer Profile | Contact Us
Train for Personal Effectiveness and Organizational Growth
© 2006 MyTrainingProvider.com, All Rights Reserved.