Excel Statistics

Learn how to do t test,standard deviation,regression analysis,anova,z test,descriptive statistics,rank,percentile.

Created byParallel Learning

Last updated 2/2016

English

What you'll learn

Perform statistical calculations in Excel

Course content

1 section • 14 lectures • 1h 19m total length

Mean7:04
Median and Mode3:28
Variance7:31
Variance and standard deviation7:19
Z test6:05
T test3:54
F test3:15
Frequency distribution3:57
Descriptive statistics4:34
Rank3:57
Random numbers7:12
Rank and Percentile9:04
Regression basic4:34
Regression7:17

Requirements

Basic excel

Description

Welcome to the course on Excel statistical, in this course we will learn how to find mean, median and mode using excel functions, how to find variance and standard deviations, learn how to find Z test, T test and F text, how to find frequency distribution, descriptive statistics, learn about generating random numbers in excel, learn about rank and percentile, regression basic and anova analysis.

Who this course is for:

Anyone who is interested in doing statistical calculations in excel