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. Foundational Concepts of Data Analysis
-
1
Calculate mean and median valuesCalculate mean and median values
-
2
Analyze data using variance and standard deviation
Analyze data using variance and standard deviation
-
3
Introducing the central limit theorem
Introducing the central limit theorem
-
4
Analyze a population using data samples
Analyze a population using data samples
-
5
Identify and minimize sources of error
Identify and minimize sources of error
Module 2. Visualize Data
-
6
Group data using histograms
Group data using histograms
-
7
Identify relationships using XY scatter charts
Identify relationships using XY scatter charts
-
8
Visualize data using logarithmic scales
Visualize data using logarithmic scales
-
9
Add trendlines to charts
Add trendlines to charts
-
10
Forecast future results
Forecast future results
-
11
Calculate running averages
Calculate running averages
Module 3. Test a Hypothesis
Module 4. Utilize Data Distributions
-
15
Use the normal distribution
Use the normal distribution
-
16
Use the exponential distribution
Use the exponential distribution
-
17
Use a uniform distribution
Use a uniform distribution
-
18
Use the binomial distribution
Use the binomial distribution
-
19
Use the poisson distribution
Use the binomial distribution
Module 5. Measure Covariance and Correlation
-
20
Visualize what covariance means
Visualize what covariance means
-
21
Calculate covariance between two columns of data
Calculate covariance between two columns of data
-
22
Calculate covariance among multiple pairs of columns
Calculate covariance among multiple pairs of columns
-
23
Visualize what correlation means
Visualize what correlation means
-
24
Calculate correlation between two columns of data
Calculate correlation between two columns of data
-
25
Calculate correlation among multiple pairs of columns
Calculate correlation among multiple pairs of columns
Module 6. Perform Bayesian Analysis
-
26
Introduce Bayesian analysis
Introduce Bayesian analysis
-
27
Analyze a sample problem: Kahneman’s Cabs
Analyze a sample problem: Kahneman’s Cabs
-
28
Create a classification matrix
Create a classification matrix
-
29
Calculate Bayesian probabilities in Excel
Calculate Bayesian probabilities in Excel
-
30
Update your Bayesian analysis
Update your Bayesian analysis