Quality Dynamics Consultancy Sdn Bhd presents
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 12/09/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:
QUALITY DYNAMICS CONSULTANCY SDN BHD
No. 343, Block A, Kelana Centre Point, No.3 Jalan SS7/19,
Kelana Jaya, 47301 Petaling Jaya,
Selangor, Malaysia.
Tel : 03-78054587 / 03-78044196
Fax: 03-78054514
E-mail:
training@qdc.com.my
(
Wani/ Thang )
PSMB Reg: 620717-P
(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
• 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.
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.