Start loving data and making sense of it. Leverage the power of MS Excel to make it easy!
Learn statistics, and apply these concepts in your work place using Microsoft Excel.
This course is about Statistics and Data Analysis. The course will teach you the basic concepts related to Statistics and Data Analysis, and help you in applying these concept. Various examples and data-sets are used to explain the application.
I will explain the basic theory first, and then I will show you how to use Microsoft Excel to perform these calculations.
Following areas of statistics are covered:
Descriptive Statistics - Mean, Mode, Median, Quartile, Range, Inter Quartile Range, Standard Deviation
Data Visualization - 3 commonly used charts: Histogram, Box and Whisker Plot and Scatter Plot
Probability - Basic Concepts, Permutations, Combinations
Population and Sampling
Probability Distributions - Normal, Binomial and Poisson Distributions
Hypothesis Testing - One Sample and Two Samples - z Test, t Test, p Test, F Test, Chi Square Test
ANOVA - Perform Analysis of Variance (ANOVA) step by step doing manual calculation and by MS Excel.
PMI-PMP, IRCA Registered Lead Auditor, ASQ - CSSBB, CQA, CQE, CMQ/OE, IIA - CIA
Sandeep Kumar has around 30 years of Project Quality Management (Engineering, Procurement and Construction) experience in power, oil/ gas, and mining industry. He has worked as Quality Manager on a number of projects including Power, Oil and Gas and Infrastructure projects.
Currently, he is working as Project Quality Director on multiple projects in Alberta, Canada.
His areas of specializations include Quality Assurance, ISO 9001:2008, ISO 9001:2015, Six Sigma, QMS Audits, Supplier Quality Surveillance, Supplier Pre-qualification, Construction Quality, Welding, NDT, Mechanical Inspection and Quality Training.
He has authored and presented a number of Quality Management courses for organizations he has worked for.
His professional qualification/certifications include: IRCA registered Lead Auditor (QMS), ASQ-CSSBB, Certified Six Sigma Black Belt (CSSBB), ASQ-CSSGB, Certified Six Sigma Black Belt (CSSBB), ASQ-Certified Quality Auditor (CQA), ASQ-Certified Quality Engineer (CQE) and ASQ-Certified Manager of Quality/Organizational Excellence (CMQ/OE), Certified Project Management Professional (PMP) and Certified Internal Auditor - IIA (CIA).