Matthew ...
I am in need of your mad mathematical skills. Actually, this is probably a very dull exercise for your most excellent cranium, but I am in need none the less.
Assume that I have a graph with six data points. I am needing to plot a "line of best fit" for those six points and calculate its slope so that we can extrapolate data into the future.
This will be an ongoing need, so I don't simply need the "solution" to my current data. I need to know how to do what I need to do.
Can you help? And if so, how soon can you send this info my way? Thanks brother.
I am in need of your mad mathematical skills. Actually, this is probably a very dull exercise for your most excellent cranium, but I am in need none the less.
Assume that I have a graph with six data points. I am needing to plot a "line of best fit" for those six points and calculate its slope so that we can extrapolate data into the future.
This will be an ongoing need, so I don't simply need the "solution" to my current data. I need to know how to do what I need to do.
Can you help? And if so, how soon can you send this info my way? Thanks brother.
posted by Just a Few Things about Scott ... | 11:57 AM
4 Comments:
Sweet.
If you have access to (and a little facility with) MS Excel, it's a piece of cake.
If not, we can still get you there, it will just take a little more work.
Shoot me an e-mail or something; I'll hook you up.
(For any curious Excel users out there, look up the FORECAST function.)
Excel is one of the most under-used programs out there... I've got a buddy that uses it to make FFTs, and other such things.
(There's also a speaker building program--that uses 4th order butterworth networks et al...)
Dude--when I was at Wheaton, the only thing resembling computer programming I knew how to do was in Excel. And that's without macros or Visual Basic or anything.
You can get pretty inventive when your resources are limited; I can relate to your "buddy".
Post a Comment
<< Home