Statistical Future values FORECAST(value, data_Y, data_X) Extrapolates future values based on existing x and y values. Value is the x value, for which the y value of the linear regression is to be returned. Data_Y is the array or range of known y's. Data_X is the array or range of known x's. Does not work for exponential functions.
Statistical Slope SLOPE(data_Y, data_X) Returns the slope of the linear regression line. Data_Y is the array or matrix of Y data. Data_X is the array or matrix of X data. On Tue, Sep 9, 2008 at 7:31 PM, Robert Citek <[EMAIL PROTECTED]> wrote: > > Hello all, > > I'm trying to see if I can do linear regression with Google > Spreadsheets. I've shared it up so anyone can edit it if anyone would > like to give a go at it: > > http://spreadsheets.google.com/ccc?key=pcV2OCtmINkfpK6g_zJYZcQ&hl=en > > Regards, > - Robert > > > > --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
