RSquared

Syntax

RSquared(Year1, Value1, Year2, Value2,... YearN, ValueN) or
RSquared(ExcelFile, ExcelRange)
RSquared(Branch:Variable)

See also: Using Time-Series Functions and Specifying Excel File and Range Parameters.

Summary

Reports the R-Squared value for a time-series.  R-squared is a statistical measure of how well a regression approximates real data points.  An r-squared of 1.0 indicates a perfect fit.

The formula for r is:

r(X,Y)   =   [ Cov(X,Y) ] / [ StdDev(X) x StdDev(Y) ]

Example

RSquared(1980, 2,   1982, 2, 1985, 4 , 1990, 6, 1993, 8, 1995, 8, 2000, 10, 2005, 12, 2010, 18)  = 0.,958