you hypothesize that there is a relationship between lack of regular exercise an

Question

you hypothesize that there is a relationship between lack of regular exercise and illness MEM336-12 n/Pegasus/Modules/Assessment Tool/Presentation/frmStudentPresentation.aspx?intAssetiD 40000016165670298imode clientFeedback&A; uiz Your Score 90.91% 6) You hypothesize that there is a relationship between lack of regular exercise and ilness. 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? SUMIFS VAR S PERCENTRANK INC CORREL Score: 1 out of2 Partially Correct LG

Explanation / Answer

PERCENTRANK.INC and CORREL can be used to investigate relationships between the data.

CORREL - Returns the correlation coefficient between two data sets. The correlation coefficient acn be used to determine the relationship between data or properties.

PERCENTRANK.INC - Returns the rank of a value in a data set as a percentage(0..1, inclusive) of the data set. This can be used to evaluate the relative standing of a value within the dataset.

Both of these functions can be used to investigate relationship between data.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.