USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It is dark red
|
|
|
it is slightly above the data
|
|
|
it is slightly below the data
|
|
|
the R2 value is closest to 1
|
Detailed explanation-1: -Trendline equation is a formula that finds a line that best fits the data points. R-squared value measures the trendline reliability-the nearer R2 is to 1, the better the trendline fits the data.
Detailed explanation-2: -A linear trendline is a best-fit straight line that is used with simple linear data sets. Your data is linear if the pattern in its data points resembles a line. A linear trendline usually shows that something is increasing or decreasing at a steady rate.
Detailed explanation-3: -If you are not sure which trendline type to use, try each type to see which one best fits most of your data points. For example, a linear trendline will not fit most points on a scatter chart with widely spread data points. Trendlines do not support color transparency.