!known_y's,known_x's!!Returns the square of the Pearson product moment correlation coefficient through the given data points!is an array or range of data points and can be numbers or names, arrays, or references that contain numbers!is an array or range of data points and can be numbers or names, arrays, or references that contain numbers!
issue,first_interest,settlement,rate,par,frequency,basis,calc_method!Returns the accrued interest for a security that pays ...
issue,settlement,rate,par,basis!Returns the accrued interest for a security that pays interest at maturity!is the security's ...
known_y's,known_x's!Calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted ...
known_y's,known_x's!Returns the slope of the linear regression line through the given data points!is an array or cell range ...
known_y's,known_x's!Returns the square of the Pearson product moment correlation coefficient through the given data points!is ...
known_y's,known_x's!Returns the standard error of the predicted y-value for each x in a regression!is an array or range of ...
known_y's,known_x's,const,stats!Returns statistics that describe a linear trend matching known data points, by fitting a ...
known_y's,known_x's,const,stats!Returns statistics that describe an exponential curve matching known data points!is the set ...
known_y's,known_x's,new_x's,const!Returns numbers in a linear trend matching known data points, using the least squares method!is ...