MS Excel: Statistics and Data Analysis

Perform Statistical analysis beginning from descriptives to hypothesis testing using MS-Excel Analysis Toolpak

Ratings: 3.98 / 5.00




Description

Present day organizations are data driven. Starting from Start-ups to Conglomerates every organization is relying on data for decision making. Organizations are flooded with data from multiple facets (websites, social network sites, third party data sources, daily operational data etc). Skimming this data to get meaningful information has become daunting task for organizations. They are looking for skilled manpower who can convert this gigantic data into sleek information for decision making. This course is for the beginners who wish to test the water in Data Analytics.

This course fuses Statistical Analysis with MS Excel because of which you would be able to churn legions of data into meaningful information within no time. Excel has hundreds of built-in functions and Data Analysis Toolpak (Excel Add-in) with which you can run descriptive statistics to predictive analysis with ease. In this course I created videos that help you understand statistical concepts and solve complex equations using Excel. Excel Workbooks are provided to you for practice and master the concepts.


What You Will Learn!

  • Design, Develop and administer questionnaires, Collect data from different sources, Enhance ability to analyze data, and Derive inferences to take successful decisions. Data Analysis speed and accuracy will enhance 10x.
  • Statistical Analysis with Pivot Table
  • Data Science with Excel Analysis Toolpak
  • Parametric and Non Parametric Tests

Who Should Attend!

  • Students who want to pursue career as Data Analyst, Data Scientist, Research Associates
  • Social Science students who want to do empirical research report/ Project Assignment / Thesis
  • Business Management Students (all streams)
  • Research Scholars / Research Students of Social Sciences and Business Management
  • All professionals who want to turn data into information
  • Entrepreneurs who wants to leverage of Data