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.

Question

Quizplus · Accepted Answer

R-squared (R²) is a statistical measure that represents the proportion of the variance for a dependent variable that's explained by an independent variable or variables in a regression model. A higher R² value indicates a better fit between the line and the data. R² values range from 0 to 1, where 1 indicates a perfect fit.

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