September 1, 2017 at 8:34 am
I am only using SQL Express (2014), so no SSAS unfortunately.
I have a table tracking sales by column by month (current day -1, -2,-3) etc. I would like to be able to run a regression for sales for inventory forecasting purposes. Now, i was never very good with regressions even when i was doing them in high school... so... trying to work it all out by hand has been giving me a bit of a headache. Pretty easy in a TI83 or excel, though... I tried to do it in column with grouping and windows but that was a total failure... At least right now if all else fails i have a weighted moving average to work with.
The table set up is:
Item Code | current month | cm-1 | cm-2 | ..... | average | moving average
thanks
dan
September 20, 2017 at 2:54 pm
Regression analysis is not exactly well known math. I can't even tell you exactly what it's supposed to be able to help you figure out, or even why someone would use it. However, you can either explain your objective in non regression terms or explain exactly what regression concept you need in technical detail, and I might then be able to find a way to help you reproduce it.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply