Welcome Guest
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
New Mexico
United States
Member #86099
January 29, 2010
11167 Posts
Offline
 Posted: December 28, 2012, 6:55 pm - IP Logged

Anything for Hotlotto?

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
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,

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.

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

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

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.

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

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.

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.

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

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.

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

Im from brazil

we have a lottery called megasena

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

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.

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.

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

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

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.

Thank you!!!

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.

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

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.

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

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.