Question

You hypothesize that there is a relationship between lack of regular exercise and illness. To research this theory, you have compiled a sample set of data that contains numbers of days in which an hour or more of exercise is completed as well as numbers of days sick within a calendar year. What tools in Excel could you use to investigate the relationships between the data

Answer 1

Answer:

CORREL

Explanation:

Correlation tool in excel informs us of the relationship that exists between two strong variables.

CORREL function in excel is used to determine the coefficient of correlation between two variables. When the coefficient of correlation is +1, it shows perfect positive correlation, when it is - 1, it shows a perfect negative correlation. When the coefficient of correlation is close to 0 it shows no correlation.