Curriculum
Course:
Data Analysis with Microsoft Excel (Basi...
Login
Curriculum
Data Analysis with Microsoft Excel (Basic to Advance)
Module 1. Introduction
0/2
Data Analysis with Excel
Video lesson
Things you should know
Video lesson
Module 2. Foundational Concepts of Data Analysis
0/5
Calculate mean and median values
Video lesson
Preview
Analyze data using variance and standard deviation
Video lesson
Preview
Introducing the central limit theorem
Video lesson
Preview
Analyze a population using data samples
Video lesson
Preview
Identify and minimize sources of error
Video lesson
Preview
Module 3. Visualize Data
0/6
Group data using histograms
Video lesson
Preview
Identify relationships using XY scatter charts
Video lesson
Preview
Visualize data using logarithmic scales
Video lesson
Preview
Add trendlines to charts
Video lesson
Preview
Forecast future results
Video lesson
Preview
Calculate running averages
Video lesson
Preview
Module 4. Test a Hypothesis
0/3
Formulate a hypothesis
Video lesson
Preview
Interpret the results of your analysis
Video lesson
Preview
Consider the limits of hypothesis testing
Video lesson
Preview
Module 5. Utilize Data Distributions
0/5
Use the normal distribution
Video lesson
Preview
Use the exponential distribution
Video lesson
Preview
Use a uniform distribution
Video lesson
Preview
Use the binomial distribution
Video lesson
Preview
Use the poisson distribution
Video lesson
Preview
Module 6. Measure Covariance and Correlation
0/6
Visualize what covariance means
Video lesson
Calculate covariance between two columns of data
Video lesson
Calculate covariance among multiple pairs of columns
Video lesson
Visualize what correlation means
Video lesson
Calculate correlation between two columns of data
Video lesson
Calculate correlation among multiple pairs of columns
Video lesson
Module 7. Perform Bayesian Analysis
0/5
Introduce Bayesian analysis
Video lesson
Analyze a sample problem: Kahneman’s Cabs
Video lesson
Create a classification matrix
Video lesson
Calculate Bayesian probabilities in Excel
Video lesson
Update your Bayesian analysis
Video lesson
Video lesson
Use the exponential distribution
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
I want to sign up as instructor
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
No account?
Sign Up
Sign In
Lost Password?
←
Chat with Us