+ Reply to Thread
Results 1 to 10 of 10

Solver & Population size, any data analysts mathematicians that can point me?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2003
    Posts
    125

    Re: Solver & Population size, any data analysts mathematicians that can point me?

    Next question: when you take out one variable at a time from the model, do the results change significantly? Not at all?

    My background, in short: engineering major turned into an economics major (graduated) and finished the first level of the chartered financial analyst designation. I enjoy analysis and have a burning desire for it.
    B.Econ, CFA

  2. #2
    Forum Contributor
    Join Date
    12-01-2010
    Location
    Southampton, England
    MS-Off Ver
    Excel 2007
    Posts
    303

    Re: Solver & Population size, any data analysts mathematicians that can point me?

    They do not change a huge amount each regression of data has been added to improve the strike rate of the result, although i would say this is dependent on the statistic. The method mentioned at the start of this thread is aiming to apply the exact correct weighting of each statistic in order to provide the maximal strike rate. This method has enabled me to greatly increase the strike rate of the data. However with such a complex model and 50,000 rows of data, i always wonder what percentage of the picture Solver is managing to get through!? I have it solving at the moment and it will only exit if it gets stuck for 25 hours. Id love to know if it is possible to analyse this data more accurately than i am at the moment. Do you have any experience with neural networks? Do they prove as clever as they sound?

    Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1