Excel: Statistical Analysis
Duration15'
No. of mini-lessons5
ResourcesTranscript
Duration 15'
No. of mini-lessons 5
Resources Transcript
Course overview
Working with data can be tedious and involve long-winded calculations, especially when there’s a lot of it. But with Excel, your employees can do more than just record and store data—they can perform statistical analyses on it. This will give them a much better understanding of the data they’re working with. And it’s often a quick process, taking no more than a couple of minutes.
This course will help your employees use Excel to make the most of their data by carrying out statistical tests. It’ll focus on descriptive statistics, regression, and variance to help them gain greater insights. Each video will cover a specific test, so they can choose exactly what they want to learn at a pace that suits them.
What's covered
Descriptive statistics including Average, Median, Standard Deviation, and COUNTIF functions
Regression analysis including LINEEST and CORREL functions
Variance analysis using the VAR function
Hypothesis testing using the T.TEST function
Why your teams need this course
Performing statistical tests in Excel can help your employees uncover valuable insights with ease. This course is ideal for anyone who’s familiar with Excel and wants to use it to get more out of their data. To get the best out of this course, they’ll need access to a computer and Microsoft Excel.
