Statistical Data Analysis With Excel

data analysis

Introduction

Microsoft Excel is a critical apparatus to perform factual information investigation.

This course gives an outline of the basics of Excel, from common calculations to directing Bayesian analysis with Excel.

Start with the foundational concepts, including an introduction to the central limit theorem, and then shows how to visualize data, relationships, and future results with Excel’s histograms, graphs, and charts.

Also learn how to test hypotheses, model different data distributions, and calculate the covariance and correlation between data sets.

Outline

  1. Introduction
  2. Basic Statistics With Excel
  3. Testing Hypotheses With Excel
  4. ANOVA Test (Analysis of Variance)
  5. Regression Testing
  6. Correlation Testing
  7. Time Series and Forecasting
  8. Simulations in Excel