Statistics and Data Analysis for Business using MS Excel

No coding, real world problems, and an in depth review of statistical concepts and techniques used in business scenarios

What you'll learn
Use statistics to solve business problems
Learn the data analysis process
Learn statistical theory and statistical tools that can be used to solve business problems
Learn practical statistics skills
Learn predictive modelling and inferential statistics
Solve real world problems using statistics
Learn hypothesis testing, anova, linear regression and logistic regression
Learn how to use Microsoft Excel to implement statistics
Learn descriptive statistics and data visualisation
Use Microsoft Excel to visualise data using graphs and plots such as histograms and bar plots
Learn which statistical model to use when
Learn tricks and tools of the data analysis trade that help in solving practical problems using statistics
Solve a real world problem using real world data
Students will learn statistical concepts and data analysis framework using Microsoft Excel

Requirements
No programming required
No foundation in statistics required
Understanding of basic maths
No background in statistics required

Description
Statistics and Data Analysis for Business using MS Excel tries to expose students to the statistical concepts that are used to solve business problems. In this course students will learn statistical concepts and techniques through a mix of lectures on theoretical concepts and intuitions behind statistical techniques, and practical application of statistical methods in solving real world business problems. The course is meant for beginners to statistics and also for people who have had previous exposure to statistics. The course covers basics to advanced level concepts, and allows students to learn both concepts and applications. After finishing this course students will learn how to use data to solve business problems, how to study trends in data and use these trends to infer about the business setting they are studying. The course will also allow students to gain a better understanding of key concepts and the nuances in statistical methods. The course covers the following topics:

1. Descriptive Statistics.

2. Data Visualisation.

3. Different types of data and variables.

4. Sampling strategies and how to infer from samples.

5. Inferential Statistics.

6. Hypothesis Testing.

7. T tests

8. Analysis of variance.

9. Linear Regression and regression techniques.

10. Logistic Regression

11. Non linear regression and distributions.

12. Practical Application of statistics.

13. Data Analysis method and process.

14. Microsoft Excel for Data Analysis.

Who this course is for:
Beginners in statistics who want to learn statistical concepts
Beginners in statistics who want to gain data analysis skills
People with intermediate knowledge of statistics who want to refresh concepts and learn business statistics
People who want to learn the concepts and tools that are used in solving most business problems
Business Managers who want to learn implementation of statistics for solving business problems
People who want to learn statistics and data analysis to solve business problems
People who want to learn how to identify trends in data and use data to answer business problems