Statistics and Data Analysis for Business using MS Excel

Use statistics to solve business problemsHow to become a data analystHow to use statistics for business analysis and business intelligenceLearn practical statistics skillsLearn predictive modelling and inferential statisticsSolve real world problems using statisticsLearn hypothesis testing, anova, linear regression and logistic regressionLearn how to use Microsoft Excel to implement statisticsLearn descriptive statistics and data visualisationUse Microsoft Excel to visualise data using graphs and plots such as histograms and bar plotsLearn intuition behind statistical modelsLearn tricks and tools of the data analysis trade that help in solving practical problems using statisticsSolve a real world problem using real world dataStudents will learn statistical concepts and data analysis framework using Microsoft ExcelLearn which statistical tool can be applied whereShow moreShow lessStatistics 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 both beginners in statistics and also for people who have had previous exposure to statistics. The course covers basics to advanced 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:People who are interested in learning statistical conceptsPeople who want to learn how statistics can be used to solve business problemsPeople who want to learn how to analyse dataPeople who want to learn advanced statistical concepts such as logistic regressionPeople who want to become data analystsPeople who want to become business intelligence analystsPeople who want to become data scientists or statisticiansPeople who want to learn real world applications of statisticsPeople who want to learn how to use statistics to solve business problemsPeople interested in using statistics for business