Welcome Guest
Log In | Register )
You last visited January 23, 2017, 5:52 pm
All times shown are
Eastern Time (GMT-5:00)

The Wave Matrix - Excel 2007 Addin

Topic closed. 253 replies. Last post 3 years ago by MillionsWanted.

Page 8 of 17
510
PrintE-mailLink
lakerben's avatar - Lottery-061.jpg
New Mexico
United States
Member #86099
January 29, 2010
11167 Posts
Offline
Posted: December 28, 2012, 6:55 pm - IP Logged

Anything for Hotlotto?

US Flag

    Avatar
    bgonçalves
    Brasil
    Member #92564
    June 9, 2010
    2137 Posts
    Offline
    Posted: January 8, 2013, 7:37 pm - IP Logged
    Considering the main issues of regression models in econometric analysis,
    in practice, the researcher is often confronted with a situation in which received the regression is a "bad", that is, t statistics, most estimates are small, reflecting the insignificance of relevant independent variables. At the same time, the F statistic can be quite large, which indicates the importance of the overall regression. A possible reason for this phenomenon is known as multicolinearity and occurs when there is a high correlation between the factors.
    One of the conditions of classical regression model is the assumption of linear independence of the explanatory variables. When this condition, that is, when one of the variables is a linear combination of the others, is called a complete collinearity. In this situation, you cannot use Ordinary least squares (MQO). In practice, the complete collinearity occurs very rarely. More often faced with a situation that among the factors that there is a high correlation. Then indicate the presence of multicolinearity. In this case, the least squares estimate (method of least squares) formally exists, but has a "bad" properties.
    Multicolinearity can occur due to various reasons. For example, several of the independent variables may have a tendency of ordinary time, which undergo small oscillations. In particular, this can happen when the value of an independent variable values are dated to the other.
    only some of the most characteristic signs of multicolinearity.
    1. a small change in the source data (such as adding new observations) leads to a significant change in estimates of the model.
    2. estimates have large standard errors, low value, while the overall model is significant (high coefficient of determination R2 and F-statistics).
    3. estimates of the coefficients are incorrect from the viewpoint of the theory of signs, or overly large.
    What do you do when all the signs that multicolinearity? The answer to this question is no, and econometristas have different opinions about it. When confronted with the multicolinearity problem can be a natural desire to drop the "extras" independent variables, that can serve as your cause. However, be aware that it can cause new problems. First, it is not always clear which variables are redundant in this sense. Multicolinearity just means a relationship about linear factors, but not always allocate the "extra" variables. Secondly, in many cases, the removal of all independent variables can have a significant impact on the essence of the model. Finally, the rejection of the so-called essential variables, i.e. independent variables that really affect the dependent variable studied, results in a change of model. In practice, usually when a multicolinearity clean factor at least important to the analysis and then repeat the calculations
      JADELottery's avatar - YingYangYong 01.PNG
      The Quantum Master
      West Concord, MN
      United States
      Member #21
      December 7, 2001
      3685 Posts
      Offline
      Posted: January 9, 2013, 8:55 pm - IP Logged

      xaab, dr san, lakerben,

      I'm sorry about the delay.

      Been busy as heck this month and will be going a lot of traveling.

      I like to respond, but we've also been doing some research on some C# programming for the Excel AddIn.

      I'll get back to those replies at a later date.

      Presented 'AS IS' and for Entertainment Purposes Only.
      Any gain or loss is your responsibility.
      Use at your own risk.

      Order is a Subset of Chaos
      Knowledge is Beyond Belief
      Wisdom is Not Censored
      Douglas Paul Smallish
      Jehocifer

        JADELottery's avatar - YingYangYong 01.PNG
        The Quantum Master
        West Concord, MN
        United States
        Member #21
        December 7, 2001
        3685 Posts
        Offline
        Posted: January 9, 2013, 8:58 pm - IP Logged

        we've made a few updates.

        you can download the same files for both a new install and to update your existing install.

        the current version is 1.0.1.40

        Presented 'AS IS' and for Entertainment Purposes Only.
        Any gain or loss is your responsibility.
        Use at your own risk.

        Order is a Subset of Chaos
        Knowledge is Beyond Belief
        Wisdom is Not Censored
        Douglas Paul Smallish
        Jehocifer

          Avatar
          bgonçalves
          Brasil
          Member #92564
          June 9, 2010
          2137 Posts
          Offline
          Posted: January 10, 2013, 5:33 am - IP Logged

          Comparison to probability

          Fuzzy logic and probability are different ways of expressing uncertainty. While both fuzzy logic and probability theory can be used to represent subjective belief, fuzzy set theory uses the concept of fuzzy set membership (i.e., how much a variable is in a set), and probability theory uses the concept of subjective probability (i.e., how probable do I think that a variable is in a set). While this distinction is mostly philosophical, the fuzzy-logic-derived possibility measure is inherently different from the probability measure, hence they are not directly equivalent. However, many statisticians are persuaded by the work of Bruno de Finetti that only one kind of mathematical uncertainty is needed and thus fuzzy logic is unnecessary. On the other hand, Bart Kosko argues[citation needed] that probability is a subtheory of fuzzy logic, as probability only handles one kind of uncertainty. He also claims[citation needed] to have proven a derivation of Bayes' theorem from the concept of fuzzy subsethood. Lotfi Zadeh argues that fuzzy logic is different in character from probability, and is not a replacement for it. He fuzzified probability to fuzzy probability and also generalized it to what is called possibility theory. (cf.[7]) More generally, fuzzy logic is one of many different proposed extensions to classical logic, known as probabilistic logics, intended to deal with issues of uncertainty in classical logic, the inapplicability of probability theory in many domains, and the paradoxes of Dempster-Shafer theory.

            JADELottery's avatar - YingYangYong 01.PNG
            The Quantum Master
            West Concord, MN
            United States
            Member #21
            December 7, 2001
            3685 Posts
            Offline
            Posted: February 6, 2013, 12:09 pm - IP Logged

            float this a little long till we get back home.

            Presented 'AS IS' and for Entertainment Purposes Only.
            Any gain or loss is your responsibility.
            Use at your own risk.

            Order is a Subset of Chaos
            Knowledge is Beyond Belief
            Wisdom is Not Censored
            Douglas Paul Smallish
            Jehocifer

              lakerben's avatar - Lottery-061.jpg
              New Mexico
              United States
              Member #86099
              January 29, 2010
              11167 Posts
              Offline
              Posted: February 6, 2013, 10:02 pm - IP Logged

              float this a little long till we get back home.

              Thumbs Up

              US Flag

                Avatar
                Rio de Janeiro
                Brazil
                Member #136360
                December 9, 2012
                56 Posts
                Offline
                Posted: February 8, 2013, 4:07 pm - IP Logged

                hello jade 

                Im from brazil

                we have a lottery called megasena

                  Avatar
                  Rio de Janeiro
                  Brazil
                  Member #136360
                  December 9, 2012
                  56 Posts
                  Offline
                  Posted: February 8, 2013, 4:13 pm - IP Logged

                  float this a little long till we get back home.

                  how to develop study Megasena, applying his method

                  6/60

                    SergeM's avatar - slow icon.png
                    Economy class
                    Belgium
                    Member #123700
                    February 27, 2012
                    4035 Posts
                    Offline
                    Posted: February 9, 2013, 4:18 pm - IP Logged

                    I am partly stepping over from Excel VBA to one of the C languages. It feels like stepping over from an excellent bicycle to a Bugatti Veyron.

                      JADELottery's avatar - YingYangYong 01.PNG
                      The Quantum Master
                      West Concord, MN
                      United States
                      Member #21
                      December 7, 2001
                      3685 Posts
                      Offline
                      Posted: February 27, 2013, 9:58 am - IP Logged

                      float this a little long till we get back home.

                      still running blind.

                      hopefully we get our main system back today.

                      we're cloning our system hard drive.

                      if it's worth doing once, it's twice as good doing it again.

                      Presented 'AS IS' and for Entertainment Purposes Only.
                      Any gain or loss is your responsibility.
                      Use at your own risk.

                      Order is a Subset of Chaos
                      Knowledge is Beyond Belief
                      Wisdom is Not Censored
                      Douglas Paul Smallish
                      Jehocifer

                        Avatar
                        Rio de Janeiro
                        Brazil
                        Member #136360
                        December 9, 2012
                        56 Posts
                        Offline
                        Posted: February 28, 2013, 7:07 pm - IP Logged

                        Hi  Jade

                        Okay with you

                        I installed the Matrix Wave in EXCEL 2007, I've been testing the Matrix Wave in some of the Lotteries here in Brazil.

                        But I am not able to interpret the data.

                        Jade PLEASE could you teach me how to interpret these data.

                        Sorry Jade I'm using Google translator!

                        Thank you!!!

                          JADELottery's avatar - YingYangYong 01.PNG
                          The Quantum Master
                          West Concord, MN
                          United States
                          Member #21
                          December 7, 2001
                          3685 Posts
                          Offline
                          Posted: February 28, 2013, 7:14 pm - IP Logged

                          Hi all,

                          We're getting back to programming and working on some of the questions asked here after our trip and system backup.

                          Please keep in mind we do have a real job that pays real bills besides this internet hobby we are doing.

                          We are testing this on lottery related stuff as well as other types of data: ie. stock quotes, temp data, so on.

                          We'll get to these in order as soon as we can.

                          Thank you.

                          Presented 'AS IS' and for Entertainment Purposes Only.
                          Any gain or loss is your responsibility.
                          Use at your own risk.

                          Order is a Subset of Chaos
                          Knowledge is Beyond Belief
                          Wisdom is Not Censored
                          Douglas Paul Smallish
                          Jehocifer

                            JADELottery's avatar - YingYangYong 01.PNG
                            The Quantum Master
                            West Concord, MN
                            United States
                            Member #21
                            December 7, 2001
                            3685 Posts
                            Offline
                            Posted: March 1, 2013, 6:46 pm - IP Logged

                            Alright, now that we have some time to do home work.

                            We'd like to point out a few things.

                            First, we will only work on the Excel Addin and how it works.

                            Second, if you have a really great idea, formula, scheme, method, derivation, sample, observation, or any other way of looking at numbers, you'll have to work those on your own.

                            Third, we will work through a few more examples and what the output is generating and how to use it as it relates to your data being analyzed, not the way your data was created or sampled.

                            There are just way too many types, version, or ways of looking at data to consider in transformation, derivation, and computation.

                            We'll work with a Pick 3 example in a few forms, one of the individual columns of A, B, or C; the whole number value like 316, and the draw index of an individual number in a column A, B, or C.

                            Next we will work on a Pick 5 example in a few forms, one of the individual columns of A, B, C, D or E; the combinatorial index of a combination, and the draw index of an individual number like 01.

                            continues....

                            Presented 'AS IS' and for Entertainment Purposes Only.
                            Any gain or loss is your responsibility.
                            Use at your own risk.

                            Order is a Subset of Chaos
                            Knowledge is Beyond Belief
                            Wisdom is Not Censored
                            Douglas Paul Smallish
                            Jehocifer

                              JADELottery's avatar - YingYangYong 01.PNG
                              The Quantum Master
                              West Concord, MN
                              United States
                              Member #21
                              December 7, 2001
                              3685 Posts
                              Offline
                              Posted: March 1, 2013, 7:00 pm - IP Logged

                              Also, if you don't get it, you don't get it.

                              We ask you to stop using the Addin immediately before you accidentally injure yourself in a mathematical mishap.

                              We don't want to hear about how someone's brain started smoking and oozing out someone's ear because it was too much for them to handle.

                              Please protect yourself with a working knowledge of mathematics and its applications.

                              Thank you.

                              continues...

                              Presented 'AS IS' and for Entertainment Purposes Only.
                              Any gain or loss is your responsibility.
                              Use at your own risk.

                              Order is a Subset of Chaos
                              Knowledge is Beyond Belief
                              Wisdom is Not Censored
                              Douglas Paul Smallish
                              Jehocifer

                                 
                                Page 8 of 17