In Excel's Trendline tool, the value of the gives the measure of fit of the line to the data.
A) linear function
B) R-squared
C) moving average
D) set intercept

Question

Quizplus · Accepted Answer

R-squared is the 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, thus indicating the fit of the model.

In Excel's Trendline Tool, the Value of the Gives the Measure