What I would like at this time is some validation that I understand some functions and analysis concepts.
Background. I understand the logic of programming and can and will find the "syntax" required for VBA. Already have and done. Not on a time limit. It's the garbage in/garbage out thang. =forecast(thisnum,y's,x's)
one. given an array of x values that comprise, lets say actual stock price on a given day, and y values that are a plus or minus from paid/cost, avg, stdev, whatever.
On a scatter plot, x,y values are sometimes the same, so that point at 1,1 may have happened multiple times, just as any other point. could, don't know that i don't need to count the times that scenario happens.
With a forecast function I start with a desired value, resulting in a value that is a point on a linear line that exists from the absolute average (combo?) lowest x,y value to the average highest x,y value.
which I assume it is a avg of some sort when that desired num shows up. maybe?
What does that value tell me.
A linear line goes from point a to point b.
Can I look at, lets say 5 year, historical data, understanding that it is in no way a absolute, but on this linear line, when my current x,y value is "this" then I have a higher probability, withing some range, of "that" happening ?
Is it a time frame? that at this point it is x days till that same x,y value (no absolutes) should occur?
hope someone can help and i'm not being a idiot.
thank you.
Marvin