Sorry - I know this isn't strictly Python, and i'm more asking for a formula than code!
Usually Excel functions show how they are calculated but i can't find anything on this one!
So given a set of data, predict what the next value will be based on the previous values
Thanks
spe_eddy
0
Newbie Poster
Recommended Answers
Jump to PostExcel statistical functions: TREND
The TREND(known_y's, known_x's, new_x's, constant) function is used to perform Linear Regression. A least squares criterion is used and TREND tries to find the best fit under that …
Jump to PostNo. It uses linear regression which (waving my hands broadly) amounts to finding the 'best possible' line through a set of points, and, given N-1 coordinates for a new point, guessing that the …
All 6 Replies
nezachem
616
Practically a Posting Shark
spe_eddy
0
Newbie Poster
griswolf
304
Veteran Poster
spe_eddy
0
Newbie Poster
griswolf
304
Veteran Poster
spe_eddy
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.