Quote:
Originally Posted by BroadwayJoe
You knowing Solver and also regression analysis is immense...
|
Sorry to hijack this a little, but when I was doing a test on a computer generated Class rating using Access I used my intuition for the weights for a number of factors and then tweaked it using trial and error testing backwards and forwards over a couple of years.
When I tried to use Excel to do a regression and improve my weights further, it could never get as good a result as I did using intuition, let alone the tweaks I made later.
I can't explain that, but it always fell a little short.