USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
FV
|
|
|
R2
|
|
|
V2
|
|
|
PV
|
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: -Double-click on the trendline, choose the Options tab in the Format Trendlines dialogue box, and check the Display r-squared value on chart box.
Detailed explanation-3: -Trendline reliability A trendline is most reliable when its R-squared value is at or near 1. When you fit a trendline to your data, Graph automatically calculates its R-squared value. If you want, you can display this value on your chart.
Detailed explanation-4: -R-squared, or the coefficient of determination, is a statistical measure that uses the variance of one variable to explain the variance of another.