Statistics for Data Analysis Using Excel (Accredited)

Statistics for Data Analysis Using Excel (Accredited), available at $109.99, has an average rating of 4.59, with 115 lectures, 13 quizzes, based on 5878 reviews, and has 24613 subscribers.

You will learn about Master the essentials of descriptive and inferential statistics through straightforward and practical examples, making complex concepts easy to grasp. Harness the power of Microsoft Excel to perform a wide range of statistical calculations, eliminating the need to remember long and complex formulas. Gain a solid foundation in statistics, from basic principles to advanced applications, enabling you to solve business problems efficiently using Excel. Transform vast amounts of data into meaningful insights, empowering you to make informed, fact-based decisions that drive business success. Develop proficiency in Excel, to perform and streamline your data analysis tasks without the need for advanced software like Minitab, R, or Python. Visualize your data effectively by creating and interpreting histograms, box plots, and scatter plots, to communicate your findings clearly and effectively. Enhance your career prospects by gaining practical skills in data analysis using Excel, a highly valued competence in today's data-driven business environment. Boost your confidence in handling statistical analysis, making you a valuable asset to your organization and opening up opportunities for professional growth. This course is ideal for individuals who are Business managers and data analysts who are trying make decision based on data and facts or Six Sigma Green and Black Belt professionals using MS Excel to conduct statistical analysis It is particularly useful for Business managers and data analysts who are trying make decision based on data and facts or Six Sigma Green and Black Belt professionals using MS Excel to conduct statistical analysis.

Enroll now: Statistics for Data Analysis Using Excel (Accredited)

Summary

Title: Statistics for Data Analysis Using Excel (Accredited)

Price: $109.99

Average Rating: 4.59

Number of Lectures: 115

Number of Quizzes: 13

Number of Published Lectures: 115

Number of Published Quizzes: 13

Number of Curriculum Items: 128

Number of Published Curriculum Objects: 128

Original Price: $74.99

Quality Status: approved

Status: Live

What You Will Learn

Master the essentials of descriptive and inferential statistics through straightforward and practical examples, making complex concepts easy to grasp.
Harness the power of Microsoft Excel to perform a wide range of statistical calculations, eliminating the need to remember long and complex formulas.
Gain a solid foundation in statistics, from basic principles to advanced applications, enabling you to solve business problems efficiently using Excel.
Transform vast amounts of data into meaningful insights, empowering you to make informed, fact-based decisions that drive business success.
Develop proficiency in Excel, to perform and streamline your data analysis tasks without the need for advanced software like Minitab, R, or Python.
Visualize your data effectively by creating and interpreting histograms, box plots, and scatter plots, to communicate your findings clearly and effectively.
Enhance your career prospects by gaining practical skills in data analysis using Excel, a highly valued competence in today's data-driven business environment.
Boost your confidence in handling statistical analysis, making you a valuable asset to your organization and opening up opportunities for professional growth.

Who Should Attend

Business managers and data analysts who are trying make decision based on data and facts
Six Sigma Green and Black Belt professionals using MS Excel to conduct statistical analysis

Target Audiences

Business managers and data analysts who are trying make decision based on data and facts
Six Sigma Green and Black Belt professionals using MS Excel to conduct statistical analysis

Note: Students who complete this course can apply for the certification exam by Quality Gurus Inc. and achieve the Verified Certification from Quality Gurus Inc. It is optional, and there is no separate fee for it. Quality Gurus Inc. is the Authorized Training Partner (ATP # 6034) of the Project Management Institute (PMI®) and the official Recertification Partner of the Society for Human Resource Management (SHRM®)

The verified certification from Quality Gurus Inc. provides you with 14.0 pre-approved PMI PDUs and 14.0 SHRM PDCs at no additional cost to you.

This course is accredited by The CPD Group (UK). You are eligible to claim 14.0 CPDs for this course (Accreditation# 1016204)

Welcome to “Statistics for Data Analysis Using Microsoft Excel,” a comprehensive course designed to teach you both descriptive and inferential statistics through simple yet practical examples. This course will show you how to harness the power of Microsoft Excel to perform statistical calculations effortlessly, eliminating the need to memorize long formulas and equations. By the end of this course, you will be able to use statistics to solve business problems and make fact-based decisions.

What You’ll Learn:

Descriptive and Inferential Statistics: Understand and apply statistical concepts from basic to advanced levels.
Microsoft Excel Proficiency: Use Excel to perform statistical calculations, making data analysis straightforward and efficient.
Data Interpretation: Make sense of vast amounts of data to make informed decisions based on factual analysis.
Data Visualization: Learn to create and interpret histograms, box and whisker plots, and scatter plots to visualize data effectively.

Course Structure: This course includes video lectures, practical exercises, and examples to help you understand and apply statistical concepts using Microsoft Excel.

Detailed Topics Covered:

Section 1: Introduction to Statistics and Data Analysis

Basic Concepts: Learn the foundational concepts of statistics and data analysis.
Excel for Data Analysis: Get introduced to using Excel for statistical calculations and data analysis.

Section 2: Descriptive Statistics

Measures of Central Tendency: Calculate and interpret mean, mode, and median.
Measures of Spread: Understand and compute quartiles, range, interquartile range, and standard deviation.

Section 3: Data Visualization

Histograms: Create and interpret histograms to understand data distribution.
Box and Whisker Plots: Use box plots to visualize data spread and identify outliers.
Scatter Plots: Analyze relationships between variables using scatter plots.

Section 4: Probability

Basic Probability Concepts: Understand permutations, combinations, and basic probability.
Probability Distributions: Explore normal, binomial, and Poisson distributions and their applications.

Section 5: Population and Sampling

Understanding Populations and Samples: Learn the difference between populations and samples.
Sampling Techniques: Discover various sampling methods and their importance in statistics.

Section 6: Hypothesis Testing

One Sample Tests: Conduct one-sample z-tests, t-tests, and p-tests.
Two Sample Tests: Perform two-sample z-tests, t-tests, and p-tests.
F Test and Chi-Square Test: Understand and apply these tests for hypothesis testing.

Section 7: Analysis of Variance (ANOVA)

ANOVA Basics: Learn to perform Analysis of Variance (ANOVA) step by step.
Manual Calculations and Excel: Conduct ANOVA calculations manually and using Excel to understand the process thoroughly.

What are other students saying about this course?

He’s better than all my university lecturers, very clear, concise and seamless progression of the evolution of concepts in a systematic way that makes it easy to understand…Bravo!! (5 stars byAyanda Peter)
A well-planned curriculum, fantastic resources for downloads, professionally presented slides, very easy to understand, truly the best course for every financial analyst. (5 stars byArumugam K Chandrasekar)
I am fan of his teachings. it is recommended to every other person who is not confident in Statistics and want to be a pro. (5 stars byApnatav Bhatia)
Its more than my expectations, absolutely wonderful since it start with basics. (5 stars byBoikaego Raditlatla)
Great course for learning business statistics or statistics in general. (5 stars bySudesh Pandey)
Brilliant course. Takes the difficult, sometimes even boring Statistics model and breaks them into easy bite size portions. Explains the theory behind it and then the Excel way of doing it. (5 stars byKarthikeyan Stalin)
The self study step by step and the excel examples are very great. I can follow the course and practice on my computer alongside. Thank you for putting this whole thing together. Not a very exciting subject to teach so I appreciate being able to put this long course together to make it easy for people like us to utilize and study. (5 stars byDr Stanley Adjabeng)

Continuous Professional Development (CPD) Units:

For the ASQ® Recertification Units (RUs), we suggest 1.40 RUs under the Professional Development > Continuing Education category.
For PMI®, 14.0 pre-approved PDUs can be provided after completing our optional/free certification exam. The detailed steps for taking Quality Gurus Inc. certification with preapproved PDUs are provided in the courses.

What are you waiting for?

This course comes with Udemy’s 30 days money-back guarantee. If you are not satisfied with the course, get your money back.

I hope to see you on the course.

Course Curriculum

Chapter 1: Statistics Introduction and Definitions

Lecture 1: Introduction and Welcome

Lecture 2: Quality Gurus Inc Certificate, Digital Badge, PMI PDUs, SHRM PDCs (Optional)

Lecture 3: Statistics Defined

Chapter 2: Basics of Statistics and Microsoft Excel

Lecture 1: Section Introduction – Basics of Statistics and Excel

Lecture 2: Excel Interface (Excel)

Lecture 3: Types of Data in Excel – Text, Numbers, Date/Time, Logical (Excel)

Lecture 4: Qualitative vs Quantitative Data / Continuous vs Discrete (Theory)

Lecture 5: Measurement Scales – Nominal, Ordinal, Interval & Ratio (Theory)

Lecture 6: Basic Statistical Terms – Population and Sample (Theory)

Lecture 7: Understanding Data Types in mtcars Dataset (Excel)

Lecture 8: Understanding Formulas and Functions (Excel)

Lecture 9: Applying Formula to Convert Car Weights from lb to kg (Excel)

Lecture 10: Relative vs Absolute Reference (Excel)

Lecture 11: Basic Formulas, Functions and Named Ranges (Excel)

Lecture 12: More Functions (Excel)

Chapter 3: Descriptive Statistics

Lecture 1: Section Introduction – Descriptive Statistics

Lecture 2: Descriptive Statistics (Theory)

Lecture 3: Descriptive Statistics – Central Tendency (Theory)

Lecture 4: Descriptive Statistics – Variation (Theory)

Lecture 5: Installing Data Analysis Pack and Calculating Descriptive Statistics (Excel)

Lecture 6: Descriptive Statistics – Central Tendency (Excel)

Lecture 7: Descriptive Statistics – Variation (Excel)

Lecture 8: Descriptive Statistics – Shapes (Theory and Excel)

Lecture 9: Arrays (Excel)

Chapter 4: Data Visualization

Lecture 1: Section Introduction – Three commonly used Charts

Lecture 2: Histogram (Theory)

Lecture 3: Create Histogram (Excel)

Lecture 4: Histogram Shapes (Theory)

Lecture 5: Box and Whisker Chart (Theory)

Lecture 6: Create Box and Whisker Plot (Excel)

Lecture 7: Scatter Diagram (Theory)

Lecture 8: Create Scatter Plot using Excel

Chapter 5: Basic Probability Concepts

Lecture 1: Section Introduction – Basics Probability Concepts

Lecture 2: Basic Probability Concepts – Part 1 (Theory)

Lecture 3: Basic Probability Concepts – Part 2 (Theory)

Lecture 4: Basic Probability Concepts – Part 3 (Theory)

Lecture 5: Basic Probability Concepts – Part 4 (Theory)

Lecture 6: Calculate Factorial, Permutations and Combinations (Excel)

Chapter 6: Probability Distributions

Lecture 1: Section Introduction – Probability Distributions

Lecture 2: Central Limit Theorem (Theory)

Lecture 3: Central Limit Theorem Demonstration (Excel)

Lecture 4: Normal Probability Distribution (Theory)

Lecture 5: Normal Probability Distribution (Excel)

Lecture 6: Binomial Probability Distribution (Theory)

Lecture 7: Binomial Probability Distribution (Excel) – 1

Lecture 8: Binomial Probability Distribution (Excel) – 2

Lecture 9: Other Distributions Related to Binomial Distribution (Theory)

Lecture 10: Other Distributions Related to Binomial Distribution (Excel)

Lecture 11: Poisson Distribution (Theory)

Lecture 12: Poisson Distribution (Excel)

Chapter 7: Hypothesis Testing

Lecture 1: Section Introduction – Hypothesis Testing

Lecture 2: Hypothesis Testing – Types of Errors

Lecture 3: Hypothesis Testing Explained

Lecture 4: Tests for Mean, Variance and Proportions – Introduction

Lecture 5: One Sample z Test (Theory)

Lecture 6: One Sample z Test – Introduction (Excel)

Lecture 7: One Sample z Test – Two Tail Example (Excel)

Lecture 8: One Sample z Test – One Tail Example (Excel)

Lecture 9: Understanding the p Value (Theory)

Lecture 10: One Sample t Test (Theory)

Lecture 11: One Sample t Test – Introduction to T Functions (Excel)

Lecture 12: One Sample t Test – Example (Excel)

Lecture 13: One Sample p Test (Theory)

Lecture 14: One Sample p Test (Excel)

Lecture 15: Two Sample z Test (Theory)

Lecture 16: Two Sample z Test (Excel)

Lecture 17: Two Sample t Test (Theory)

Lecture 18: Two Sample t Test – Equal Variance (Theory)

Lecture 19: Two Sample t Test – Equal Variance (Excel)

Lecture 20: Two Sample t Test – Unequal Variance (Theory)

Lecture 21: Two Sample t Test – Unequal Variance (Excel)

Lecture 22: Two Sample t Test – Paired t Test (Theory)

Lecture 23: Two Sample t Test – Paired t Test (Excel)

Lecture 24: Two Sample p Test – Introduction (Theory)

Lecture 25: Two Sample p Test – Example (Excel)

Lecture 26: Tests for Variance (F and Chi Square) – Introduction

Lecture 27: F Test to Compare Variances

Lecture 28: Plotting F Distribution in Excel

Lecture 29: F Distribution Related Functions in Excel

Lecture 30: F.TEST Function in Excel

Lecture 31: F Test Using Data Aanalysis Pack

Lecture 32: Chi Square Test for Variance

Lecture 33: Plotting Chi Square Distribution in Excel

Lecture 34: Chi Square Distribution Related Functions in Excel

Instructors

Sandeep Kumar, Quality Gurus Inc.
Experienced Quality Director • Six Sigma Coach • Consultant

Rating Distribution

1 stars: 38 votes
2 stars: 77 votes
3 stars: 534 votes
4 stars: 2088 votes
5 stars: 3141 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu