Quality Dynamics Consultancy Sdn Bhd presents

Jan 23 - 24, 2018 (9am - 5pm) at Holiday Inn Kuala Lumpur Glenmarie

Excel for Statistical Data Analysis

(by Mr. Mohd Pathir Gopalakrishnan )

objectives

This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.

This course describes how to use the Analysis Tool Pack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation  are and how to overcome them.

program content

1.  Aggregating Data in Excel
        •  Statistical Functions
        •  Types of Data
        •  Six Sigma 6???DPU,DPMO, PPM, RTY, Cp, Cpk, Pp, Ppk in Excel

2.  Data Relation Analysis
        •  Normal Distribution and Normality Test.
        •  Descriptive Statistics
        •  Histogram, Pareto Charts, Checklist tool,
        •  Flow Chart
        •  Linear Correlation
        •  Regression Analysis

3.  Analyzing Data in Time
        •  Trends/Regression line
        •  Linear, Logarithmic, Poly-nominal, Power, Exponential,
           Moving Average Smoothing
        •  Seasonal fluctuations analysis

4.  Comparing Populations
        •  Confidence Interval for the Mean
        •  Test of Hypothesis Concerning the Population Mean
        •  Difference Between Mean of Two Populations
        •  ANOVA: Analysis of Variances
        •  Goodness-of-Fit Test for Discrete Random Variables
        •  Test of Independence: Contingency Tables
        •  Test Hypothesis Concerning the Variance of Two Populations
        •  Statistical Test for Non Parametrics.

5.  Control Charts in Excel
        •  Xbar-R Chart, Xbar-S Chart, IMR Chart, EWMA and Cusum Chart
        •  P-Chart, NP-Chart, C-Chart and U-Chart
        •  Cp, Cpk, Pp, Ppk ,Zbench.
        •  Short Run SPC

methodology

Lecture, Workshop Activities, Discussion & Questions and Answers.

who must attend

Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel.

(Participants are strongly encouraged to bring their lap-top)

investment fee / early bird by 10/01/2018

Standard: RM 1,595.00 nett / RM1,495.00 nett per participant

Group discount: RM1,495.00 nett / RM 1,395.00 nett per participant for a minimum of 2 participants from the same company

(Fee inclusive of Refreshment, Buffet Lunch, Training Bag, Handouts,  & Certificate of Completion)

registration & payment


PROGRAMS ARE CLAIMABLE UNDER SBL SCHEME

Please register online through www.qdc.com.my or call 03-78054587 / 03-78044196. Our phone line operation hours are from 8:30am to 6:00pm from Monday to Friday.

All registration MUST be accompanied with PAYMENT.

Completed registration form with CHEQUES should be made in favor of "Quality Dynamics Consultancy Sdn Bhd" and sent to:

(FEE PAID IS NOT REFUNDABLE but replacement may be made at no additional cost. Quality Dynamics Consultancy Sdn Bhd reserves the right to cancel or reschedule the above course and shall inform participants of the changes)

COURSE FACILITATOR - MR. MOHD PATHIR GOPALAKRISHNAN

Mr. Pathir is a Certified Lean 6-Sigma Black Belt Trainer                        

•  B.Sc (Hons) in Science & Technology (Mathematics)
   – University Malaya, Malaysia.

•  Certified Lean 6-Sigma Black Belt ,Certified Six Sigma Green Belt /
    Project Manager - General Electric (USA) Malaysian Appliance Control.

Mr. Pathir was trained in USA and Singapore in Six-Sigma Methodology and Tools (Black Belt) and upon his return to Malaysia, he was sent to China to train the Engineers in Nidec Corporation situated in Dalian.,  manufacturer of Spindle Motors, Mini Fan Motors and other types of motors  on Six Sigma Methodology and Tools.

After graduation Mr. Pathir then joined Thong Fook Plastics (M) Sdn. Bhd.  as a QA Executive heading the QA Dept manufacturing all kind of plastic bags through extrusion process, and later promoted to Technical Executive in-charge of Plastics Injection Moulding Division. He earned Certificate in Plastics Materials and Injection Moulding Process issued by CIAST, Ministry Of Labour. He was trained 6 months in Plastics Injection Moulding at Minolta Precision (M) Sdn Bhd.

His next assignment was Production Manager for Nidec-Copal, a Japanese MNC which is an Optomechatronics company producing Stepper Motors, Trimmer Potentiometer, Clik Motor, PCB Assembly, Fan Motors, Injection Moulding and Metal Stamping. He has led this company to achieve ISO9000 as a Management Representative. He has been trained as a Lead Assessor by QMS and Internal Quality Audit by SIRIM. Pathir was a Production Manager for eight years before joining an American MNC (General Electric USA Malaysian Appliance Components) as Materials & Customer Service Manager.

Pathir’s five years as a Materials & Customer Service Manager have improved productivity of more than US$1,800,000.00 through Six-Sigma activities. He has been certified Green Belt in 2001 but has been a trained Black Belt since 1999. He also received the Phillippe Award 2000 for Distinguished Community Leadership and also completed the Advance Manager’s Course in 2001 conducted by GE.

He is knowledgeable in other areas such as EHS, Ergonomics, ISO 9001:2000. He owns the Chemical Management Framework while in GE. He has been the Chairman of Health and Safety committee for 2 years.

His next portfolio was as a Technical Advisor for the Plastics Division and a Training Consultant for Six Sigma Methodology and Tools for NCPC, an Japanese MNC in the Philippines. He completed many improvements in the Plastics Division through DOE applications for parameters characterization and Optimization. He also trained all Engineers and Managers in NCPC from various departments like Plating, Motors, LED/SMD, Plastics, Metal Stamping, HR and Materials on Six -Sigma Tools (DMAIC).

He also trained NCPC’s customers on DOE application using Minitab 14 Statistical Software and have also taught other customers (Vishay Semiconductor) in Manila (Philippines), Melaka (Malaysia) and in Shanghai (China).

His last assignment was with Exas Philippines Inc. in Cebu and Aikawa Philippines Inc. in Batangas, Philippines as Technical Advisor to the Plastics Dept and a 6-Sigma Training Consultant. His contract expired March 2007 and since then has returned back to Malaysia.

Training and Coaching for Engineers and Managers in Indonesia -  Perawang, Pekan Baru, Jambi, Surabaya and Jakarta in 6-Sigma Green Belt level since May 2008 to end August 2008. These are Pulp and Paper mills in Indonesia.

Pathir also conducted 6-Sigma and other related programs for Proton, Perodua, Petronas, Samsung, NSK Bearing, Konica-Minolta, Nitto Denko, Tesco etc in Malaysia.

He has the capability of identifying improvement opportunities in any manufacturing operations and also possesses problem-solving capabilities. He has conducted many training for both In-House and Public Courses in Kuala Lumpur, Penang and Johor. Other than 6-Sigma Modules, he also teaches Effective Materials Management, Production Planning & Inventory Control, Statistical Forecasting, How to be an Effective QA, The New 7 Seven QC Tools, Cost Reduction Techniques for Manufacturing, 3Q6S, 6-sigma tools for improvements, Pengurusan Stor & Inventori Secara Berkesan, FMEA, MSA, Sampling Techniques, Regression models, DOE,RSM, QCC & 7 QC Tools, SPC, Enviromental Spills (Hazardous Toxic Substances), Simple, Multiple & Logistic Regression, COPQ, 6-Sigma Black Belt, 6-Sigma Green belt, etc.

He also provides excel-based tools for all applications in their respective subjects/topics. This tools works as good as other licensed softwares.

He is fluent in both English and Bahasa Malaysia.