The Excel Trendline tool provides a conveninet method for determining the best-fitting functional relationship for Linear functions.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

sCopy and paste the following data into Excel. Create a scatterplot of the data and use the scatterplot to determine if the data would best be represented by a linear, quadratic, or exponential trendline.x y6.2 9.912.4 205.1 12.242.8 18.025.7 11.327.4 7.054.2 15.315.7 11.553.4 16.84Group of answer choicesLinearQuadraticExponentialThere is no discernable trend.

The mathematical basis for the best-fitting regression line is called least-squares regression.Group of answer choicesTrueFalse

The following data has a linear relationship. Copy and paste the data into Excel. Use Excel to find the equation of the linear trendline.x y1 67 2111 313 1113 369 267 215 1619 51Group of answer choices𝑦=5.3437𝑥0.7289𝑦=8.1789𝑒0.1113𝑥𝑦=−9𝐸−16𝑥2+2.5𝑥+3.5𝑦=2.5𝑥+3.5

In Microsoft Excel the functionality of fitting a straight line to data points is known as adding a:Question 3Select one:a.Chartb.Straight linec.Least squares fitd.Trendlinee.Line of best fit