!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 through the known x-values and y-values!is the dependent set of observations or data and can be numbers or names, arrays, or references that contain numbers!is the independent set of observations or data and can be numbers or names, arrays, or references that contain numbers!
is in the |1 file format. Do you want to convert this workbook to the latest format? The new file name will have a new extension. ...
is not a shared workbook. Reviewers' changes can't be merged into it. You'll need to manually incorporate reviewers' changes. ...
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 ...