Wishlisted Wishlist

Learn Correlation Technique Using Excel

An Application Oriented Course
3.2 (11 ratings)
628 students enrolled
Last updated 3/2016
English
Free
Includes:
• 1 hour on-demand video
• 6 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
Description

Learn Correlation Techniques using Excel course offers an opportunity to learn the concept of relationship between any two variables. You will come to know about techniques like scatter plot, Karl Pearson Coefficient of correlation, Spearmans' Rank order correlation. The course also talk about types of correlation viz. postitve, negative and no correlation. This course includes 9 video lectures with downloadable excel files for practice in MS Excel. This course may take around one week time to make you learn these technques. The course is structured as follows: introduction and types of correlation, scatter plot, scatter plot using excel, Karl Pearson Coefficient of correlation (r), Spearmans' Rank Order correlation, and probable error.

I am sure this course will help you to understand the concept of correlation in clear cut manner. By the end of the course you will learn to find Karl Pearson coefficient of correlation and Spearmans Rank order correlation using excel and you will also come to know the difference between them.

Who is the target audience?
• Students who are looking to have foundations in statistics
• Students of BBA and MBA
Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn meaning of correlation
Learn Types of correlation
Know what is scatter plot
Learn Karl Pearson Coefficient of Correlation
Understand Spearmans Rank Order Correlation
Learn concept of probable error
View Curriculum
Requirements
• Knowledge of MS excel is desirable
• Knowledge of basic statistics is also desirable
Curriculum For This Course
Expand All 8 Lectures Collapse All 8 Lectures 01:00:36
+
Welcome Introductory Lecture
1 Lecture 03:12
Welcome Introductory Lecture
03:12
+
Correlation Analysis
7 Lectures 57:24
Introduction
04:41

Scatter Plot:Graphical Method of Studying Relation
06:26

Scatter Using Excel
03:10

Karl Pearson Coefficient of Correlation
10:56

Correlation Matrix
08:42

Spearmans' Rank Order Correlation
19:15

Probable Error
04:14