103 reputation
2
bio website velocitydatasolutions.com
location
age
visits member for 3 years, 11 months
seen Jan 14 at 12:20

Jan
4
comment How do you derive a function that describes a series?
Well, the sample I have is a year (365 data points) and is pretty clearly exponential along those points. But it's modeling online community population growth, which clearly can't be expected to be exponential for all time, I just dont' have any data outside that year.
Jan
3
awarded  Scholar
Jan
3
awarded  Supporter
Jan
3
comment How do you derive a function that describes a series?
OK, based on your advice, I did some more googling, decided from examples that my data is exponential and did a best fit curve equation that works pretty well after going through all the recommended analysis. Thanks!
Jan
3
accepted How do you derive a function that describes a series?
Jan
3
comment How do you derive a function that describes a series?
Maybe I missed it; the Excel examples I found were all using linear regression, and since this is modeling a growth curve (potentially viral), it seemed a poor fit for linear regression (the only of the types you mentioned thatI recognize by sight. How do you know "by the look" what regression method to use?
Jan
3
comment How do you derive a function that describes a series?
No, sorry, headspace and timing error. It's one data point per day.
Jan
2
asked How do you derive a function that describes a series?