Identifying the correlation coefficient using LibreOffice Calc


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)

pearson correlation coefficient interpretation (c)

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

correlation 7


4 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

  4. Thanks for sharing – I was going to turn to Octave for my analysis, but your blog helped me figure out how to use LibreOffice instead. 🙂

Leave a Reply

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

You are commenting using your 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