Learn Correlation Technique Using Excel

An Application Oriented Course
3.6 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
620 students enrolled
Free
Start Learning Now
  • Lectures 8
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

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.

About This Course

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

What 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.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Welcome Introductory Lecture
03:12
Section 1: Correlation Analysis
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dr. Ash Narayan Sah, Data Scientist

I am Ash Narayan Sah working as assistant professor in the area of Economics and Econometrics in Thapar University, Patiala. I am a doctorate in Economics. I started doing my specilization in the economics area after my 12th. I completed my graduation in economics with honours from Utkal University in 1997. I did my master in economics from Hyderabad Central University, Andhra Pradesh in 2000. I also did my M.Phil in Economics and after M.Phil, I enrolled for my PhD in Financial Economics in Hyderabad Central University. After completion of my PhD, I joined as an assistant professor in University of Petroleum and Energy Studies, Dehradun in January 2007. I worked for 5 years in University of Petroleum and Energy Studies and taught basic econometrics course and mangerial economics to MBA students. During my stay at University of petroleum and Energy Studies, I realized the need of data analysis book using MS Excel for students of business studies. And then I decided to author my first book titled 'data Analysis using MS Excel', which published in 2009. after that I published another book titled ' Statistics for Management using MS Excel', which got published in 2013. I am having eight years teaching experience. In addition, I have also published few research papers. My expertise also extends in doing econometric and statistical analysis using several softwares like SPSS, Eviews, and MS Excel.

Ready to start learning?
Start Learning Now