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

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

Copy 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 Y3.9 4.234.8 4.522.4 6.655.1 5.254.2 4.072.8 5.654.5 4.353.4 4.465.4 6.13Group of answer choicesExponentialLinearQuadraticThere is no discernable trend.

Choose the correct statement about best-fit lines. Group of answer choicesA best-fit line describes the exact coordinates of each point in the data set.A best-fit line is close to most of the data points.A best-fit line must go through at least two of the data points.A best-fit line always has a positive slope.

We want to find the line 𝑦=𝑚𝑥+𝑐y=mx+c that best fits these data points in the least squares sense, where 𝑚m is the slope and 𝑐c is the y-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