Identifying the correlation coefficient using LibreOffice Calc

Hi,

I have written about correlation in my previous post Correlation and Pearson’s correlation coefficient. I also worked out a small data set to identify the correlation coefficient. In this post, let’s see how quickly we shall generate the same using LibreOffice Calc (FOSS Equivalent of Microsoft Excel).

Here is the data set. We have two variables x and y. We have 7 samples for each.

correlation 1

Select Data>Statistics>Correlation

correlation 2

Choose all data set we have (values of x and y given above)

correlation 3

Click the Results to: button to decide where LibreOffice to write the output. I have chosen the cell D2.

correlation 4

Finally, following is my inputs. Click Ok.

correlation 5

Here is the output.

correlation 6

Column2 and column 1 is 0.95.

What does this indicate? Check the below given picture. Out correlation coefficient is 0.95 in the scale of -1 to +1. So x and y are highly positively correlated.

pearson correlation coefficient interpretation (c) http://www.mathcaptain.com/statistics/pearson-correlation-coefficient.html

pearson correlation coefficient interpretation (c) http://www.mathcaptain.com/statistics/pearson-correlation-coefficient.html

If this is true, the graphical representation should show a raising line, shouldn’t it? Let’s try.

correlation 7

Obviously!

Advertisements

3 thoughts on “Identifying the correlation coefficient using LibreOffice Calc

  1. Pingback: Linear Regression | JavaShine

  2. Pingback: Testing of Independence – Chi Square test – Manual, LibreOffice, R | JavaShine

  3. Pingback: Regression testing in R | JavaShine

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s