Essential Statistics for Data Analysis using Excel. MPP Data Science

Este curso pertenece al Microsoft Professional Program for Data Science

 

Índice

Introduction

  • Online Courses from Microsoft
  • Welcome
  • Course Syllabus
  • Course Schedule and Grading
  • Statistics and Probability Primer
  • Set up Excel
  • Download Course Files
  • Pre-Course Survey
  • Pre-Test

      Module 1 : Descriptive Statistics

      • Defining Data
      • Histograms and Skewness
      • Descriptive Statistics with Analysis ToolPak
      • Boxplots
      • Categorical Data, PivotTables, and PivotCharts
      • Summarizing Hierarchical Data
      • 80-20 Rule and Pareto Charts
      • Module 1 Discussion
      • Module 1 Quiz

      Module 2 : Basic Probability

      • Introduction to Probability
      • Law of Complements
      • Mutually Exclusive and Independent Events
      • Conditional Probability
      • Law of Total Probability and Bayes Rule
      • Additional Reading and Review
      • Module 2 Discussion
      • Module 2 Quiz

      Module 3 : Random Variables

      • Random Variable Definitions
      • Mean, Variance, and Standard Deviation of a Random Variable
      • Mean, Variance, and Standard Deviation for Sum of Random Variables
      • Binomial Random Variable
      • Poisson Random Variable
      • Normal Random Variable
      • Central Limit Theorem
      • Z Scores
      • Module 3 Discussion
      • Module 3 Quiz

      Module 4 : Sampling and Confidence Intervals

      • Populations and Samples
      • Point Estimation of a Population Mean and Proportion
      • The Standard Normal
      • Confidence Interval Estimation
      • Sample Size Determination
      • The Finite Correction Factor
      • Additional Reading
      • Module 4 Discussion
      • Module 4 Quiz

      Module 5: Hypothesis Testing

      • Defining Hypotheses
      • Type I and Type II Error
      • One Sample Z-Test
      • One Sample T-Test
      • Single Sample Test for Population Proportion
      • Testing Equality of Variances
      • Testing the Difference Between Two Population Means
      • Chi-Squared Test for Independence
      • Additional Reading
      • Module 5 Discussion
      • Module 5 Quiz

      Final

      • Final Exam
      • Post-Course Survey

       

      Soporte

      Curso con soporte individualizado según se indica en https://nanfor.com/pages/soporte-2-0 

       

      * Todas las tarifas son bonificables menos el examen solo.

        €295.00