The R2 value for a trendline indicates how well the trendline equation fits our data with a value of 1 indicating a perfect fit.Group of answer choicesTrueFalse

Which of the following is true of the R-squared (R2) value in Excel's Trendline function? Group of answer choicesA value of 1.0 for R2 indicates maximum deviation of the data from the line.If the value of R2 is above 1.0, the line will be at a perfect fit for the data.The value of R2 will always be between -1 and 1.As the value of R2 gets higher, the line will be a better fit for the data.

In Excel's Trendline tool, the value of the________ gives the measure of fit of the line to the data.Group of answer choiceslinear functionR-squaredmoving averageset intercept

When do you need to add a trendline on a plot ?Group of answer choicesTo find the error level on dataTo see if data is closely matchedTo see how close data is to a special fitTo see if data is following a correct trend

In regression analysis, r2 is the ___.Group of answer choicescoefficient of determinationsum of the squaredestimated regression analysiscoefficient of correlation

The regression R2 is: a. possible to decrease when an additional explanatory variable is added. b. R S S divided by T S S. c. a measure of the goodness of fit of your regression line. d. a measure of the causal effect of X on Y.