Which of the Following Is True of the R-Squared (R2)

question 46

Multiple Choice

Which of the following is true of the R-squared (R2) value in Excel's Trendline function?

• A) A value of 1.0 for R2 indicates maximum deviation of the data from the line.
• B) If the value of R2 is above 1.0, the line will be at a perfect fit for the data.
• C) The value of R2 will always be between -1 and 1.
• D) As the value of R2 gets higher, the line will be a better fit for the data.

---

Definitions:

Other Expenses

Expenditures that are not directly related to the production of goods or services, such as administrative and selling expenses.

Wells Serviced

The number of oil, gas, or water wells that have undergone maintenance, repair, or any other service by a company during a given period.

Corporate Function

Essential activities or roles within an organization that support its core business operations, such as human resources, finance, and IT.

Flexible Budget

A budget that adjusts or varies with changes in volume or activity, allowing for more accurate costing and financial planning.