If There Is Perfect Negative Correlation Between Two Sets of Numbers

question 39

Multiple Choice

If there is perfect negative correlation between two sets of numbers, then _______.

• A)r = 0
• B)r = -1
• C)r = +1
• D)SSE=1
• E)MSE = 1

---

Definitions:

AutoSum Button

A feature in spreadsheet programs that automatically calculates the sum of a selected row or column with a single click.

Function

A named section of a program that performs a specific task and can return a value.

Absolute Cell Reference

In spreadsheet applications, a cell reference that remains constant even if the formula containing it is copied to another cell.

Relative Cell Reference

In spreadsheet applications, a cell reference that changes when it is copied or moved to another cell, adjusting its position relative to the new location.