Yea, here's what I did.
I constructed the "slope" based on prior data. Then, I added the difference between the last data point in the list and the data point not in the list. Therefore, it'll include the increase in data, without affecting the slope.
This specific application is quite simple. We're calculating data storage on our network, to project how much storage we need to purchase for our company. Our data samples are from the backup routine that runs once a week. Well, for the past two weeks, we consolidated a massive amount of data...
Yes, but again, I need to exclude data from the slope, but include it into the final results.
Here's an example:
Let's say every week, I'm increasing exponentially by 1. So it goes as such:
1,2,4,8,16,32,etc...
But two weeks, it's off by a lot:
1,2,4,8,16,58,65, etc...
How can I figure out...
Here's the situation: We're trying to project growth over a few years using our past data for reference. Simple exponential trendline, right? The problem is that in the last two weeks, we saw a massive jump which was out of average and will likely not happen again.
If I was using a linear...