Data is rarely so uniform and predictable that plotting data points creates a perfectly linear arrangement. Scatter charts might have wildly varying plots that create a seemingly random correlation ...
In addition to basic calculation functions, Excel also provides data analysis tools that allow you to find the R2 of two lines with an Excel formula. R2, or R-squared, is the relationship between two ...