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 tests8. Analysis of variance.9. Linear Regression and regression techniques.10. Logistic Regression11. 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