This course is designed for individuals seeking to harness the power of Microsoft Excel for data analysis and decision-making. Participants will delve into essential Excel functions, tools, and techniques to manipulate, visualize, and analyze data effectively. From basic data cleaning to advanced statistical analysis, this course provides a comprehensive guide to unlocking the full potential of Excel for data-driven insights.
Module 1. Introduction
Module 2. Foundational Concepts of Data Analysis
-
3
Calculate mean and median valuesCalculate mean and median values
-
4
Analyze data using variance and standard deviation
Analyze data using variance and standard deviation
-
5
Introducing the central limit theorem
Introducing the central limit theorem
-
6
Analyze a population using data samples
Analyze a population using data samples
-
7
Identify and minimize sources of error
Identify and minimize sources of error
Module 3. Visualize Data
-
8
Group data using histograms
Group data using histograms
-
9
Identify relationships using XY scatter charts
Identify relationships using XY scatter charts
-
10
Visualize data using logarithmic scales
Visualize data using logarithmic scales
-
11
Add trendlines to charts
Add trendlines to charts
-
12
Forecast future results
Forecast future results
-
13
Calculate running averages
Calculate running averages
Module 4. Test a Hypothesis
Module 5. Utilize Data Distributions
-
17
Use the normal distribution
Use the normal distribution
-
18
Use the exponential distribution
Use the exponential distribution
-
19
Use a uniform distribution
Use a uniform distribution
-
20
Use the binomial distribution
Use the binomial distribution
-
21
Use the poisson distribution
Use the binomial distribution
Module 6. Measure Covariance and Correlation
-
22
Visualize what covariance means
Visualize what covariance means
-
23
Calculate covariance between two columns of data
Calculate covariance between two columns of data
-
24
Calculate covariance among multiple pairs of columns
Calculate covariance among multiple pairs of columns
-
25
Visualize what correlation means
Visualize what correlation means
-
26
Calculate correlation between two columns of data
Calculate correlation between two columns of data
-
27
Calculate correlation among multiple pairs of columns
Calculate correlation among multiple pairs of columns
Module 7. Perform Bayesian Analysis
-
28
Introduce Bayesian analysis
Introduce Bayesian analysis
-
29
Analyze a sample problem: Kahneman’s Cabs
Analyze a sample problem: Kahneman’s Cabs
-
30
Create a classification matrix
Create a classification matrix
-
31
Calculate Bayesian probabilities in Excel
Calculate Bayesian probabilities in Excel
-
32
Update your Bayesian analysis
Update your Bayesian analysis