# Learn Correlation Technique Using Excel

An Application Oriented Course
3.5 (11 ratings) 623 students enrolled
Instructed by Dr. Ash Narayan Sah
Free
• Lectures 8
• Length 1 hour
• Skill Level All Levels
• Languages English
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion
Wishlisted Wishlist

### Discover

Find online courses made by experts from around the world.

### Learn

Take your courses with you and learn anywhere, anytime.

### Master

Learn and practice real-world skills and achieve your goals.

Published 3/2016 English

### Course 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.

### What are the requirements?

• Knowledge of MS excel is desirable
• Knowledge of basic statistics is also desirable

### What am I going to get from this course?

• 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

### Who is the target audience?

• Students who are looking to have foundations in statistics
• Students of BBA and MBA

### What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

# Curriculum

 Section 1: Correlation Analysis Lecture 1 Welcome Introductory Lecture 03:12 Lecture 2 Introduction 04:41 Lecture 3 Scatter Plot:Graphical Method of Studying Relation 06:26 Lecture 4 Scatter Using Excel 03:10 Lecture 5 Karl Pearson Coefficient of Correlation 10:56 Lecture 6 Correlation Matrix 08:42 Lecture 7 Spearmans' Rank Order Correlation 19:15 Lecture 8 Probable Error 04:14