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.

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

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

R-SquaredThe strength of a linear regression line is determined by the value of the R-squared. If this value is found to be 0, what does it imply?The fitted line explains all the variance in the data.The fitted line explains most of the variance in the data.The fitted line does not explain any variance in the data.The value of the R-squared cannot be zero.

In the regression below, what is the value of the R-Squared?

The following data has a quadratic relationship. Copy and paste the data into Excel. Use Excel to find the equation of the quadratic trendline. Remember a quadratic trendline is called polynomial with order 2 in Excel. x y1 697.6737 1,666.93319 381.7035 1,342.5232 825.711310 1,650.8931 531.3738 1,482.4836 1,193.443Which is the correct equation of the quadratic trendline?Group of answer choices𝑦=−13.399𝑥2+345.11𝑥+360.56𝑦=−13.399𝑥2+256.21𝑥+360.56𝑦=−15.777𝑥2+256.21𝑥+360.56𝑦=−15.777𝑥2+345.11𝑥+360.56