lizardjuice
Programmer
Can someone point out how I can take a known set of x-values and a known set of y-values and return a linear trend? Excel provides a TREND() function but I need to do this on a server-side object, preferably in VB.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to calculate a linear trend
- Thread starter lizardjuice
- Start date
- Status
qbasicking
Programmer
Go through each point and find the equation for the line that connects them.
Then you could simply average them out.
Then you could simply average them out.
- Thread starter
- #3
lizardjuice
Programmer
hmm - I'm not sure that's what I'm looking for. The function needs to suggest a future trend based on the known values from the past.
Most books on Statistics will show how to calculate the line equation for linear trend (or regression) in the form 'y = mx + c'. Extrapolation of that data just needs you to supply the appropriate x value to the equation.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
- Thread starter
- #5
lizardjuice
Programmer
Thank you johnwm - I'll start from there.
- Status
Similar threads
- Locked
- Question