The Naked Scientists
  • Login
  • Register
  • Podcasts
      • The Naked Scientists
      • eLife
      • Naked Genetics
      • Naked Astronomy
      • In short
      • Naked Neuroscience
      • Ask! The Naked Scientists
      • Question of the Week
      • Archive
      • Video
      • SUBSCRIBE to our Podcasts
  • Articles
      • Science News
      • Features
      • Interviews
      • Answers to Science Questions
  • Get Naked
      • Donate
      • Do an Experiment
      • Science Forum
      • Ask a Question
  • About
      • Meet the team
      • Our Sponsors
      • Site Map
      • Contact us

User menu

  • Login
  • Register
  • Home
  • Help
  • Search
  • Tags
  • Recent Topics
  • Login
  • Register
  1. Naked Science Forum
  2. General Science
  3. General Science
  4. How can I determine the relationship between two variables?
« previous next »
  • Print
Pages: [1]   Go Down

How can I determine the relationship between two variables?

  • 3 Replies
  • 2024 Views
  • 0 Tags

0 Members and 1 Guest are viewing this topic.

Offline scientizscht (OP)

  • Naked Science Forum King!
  • ******
  • 1006
  • Activity:
    0%
  • Thanked: 3 times
  • Naked Science Forum
How can I determine the relationship between two variables?
« on: 02/10/2020 22:06:49 »
Hello

I have data of a y,x1,x2 where x1 and x2 are independent variables.

How can I assess if the x1 or x2 are related to y and how strongly?

Also, is it possible to determine if there is a causation or simply correlation?

Thanks!
Logged
 



Offline alancalverd

  • Global Moderator
  • Naked Science Forum GOD!
  • ********
  • 21147
  • Activity:
    71%
  • Thanked: 60 times
  • Life is too short for instant coffee
Re: How can I determine the relationship between two variables?
« Reply #1 on: 02/10/2020 22:48:59 »
https://www.educba.com/3d-scatter-plot-in-excel  will give you a quick insight into a 3-dimensional correlation, using the spreadsheet you probably already have (or can buy very cheaply).

Proof of causation requires that you hold x1 or x2 constant and see how y changes when you vary the other.
Logged
Helping stem the tide of ignorance
 

Offline evan_au

  • Global Moderator
  • Naked Science Forum GOD!
  • ********
  • 11033
  • Activity:
    8%
  • Thanked: 1486 times
Re: How can I determine the relationship between two variables?
« Reply #2 on: 02/10/2020 22:55:36 »
You can use a correlation function on the two variables separately, to see which has the greater correlation.

There are also multi-variable correlation functions.

But these work best if there is a linear relationship (or it can be transformed into a linear relationship).
Logged
 

Offline Bored chemist

  • Naked Science Forum GOD!
  • *******
  • 31101
  • Activity:
    13%
  • Thanked: 1291 times
Re: How can I determine the relationship between two variables?
« Reply #3 on: 02/10/2020 23:44:10 »
Quote from: scientizscht on 02/10/2020 22:06:49
Also, is it possible to determine if there is a causation or simply correlation?
Mathematically, no.
Logged
Please disregard all previous signatures.
 



  • Print
Pages: [1]   Go Up
« previous next »
Tags:
 
There was an error while thanking
Thanking...
  • SMF 2.0.15 | SMF © 2017, Simple Machines
    Privacy Policy
    SMFAds for Free Forums
  • Naked Science Forum ©

Page created in 0.937 seconds with 38 queries.

  • Podcasts
  • Articles
  • Get Naked
  • About
  • Contact us
  • Advertise
  • Privacy Policy
  • Subscribe to newsletter
  • We love feedback

Follow us

cambridge_logo_footer.png

©The Naked Scientists® 2000–2017 | The Naked Scientists® and Naked Science® are registered trademarks created by Dr Chris Smith. Information presented on this website is the opinion of the individual contributors and does not reflect the general views of the administrators, editors, moderators, sponsors, Cambridge University or the public at large.