How can we get eigenvector of matrix by excel?

[soleimani1967]

Consider below simultaneous equations:

x – y = 0
y – x = 0

The answer is: x = y = c and “c” is a constant value.
How can we get this constant value by excel? In fact, I am willing to know how we can calculate eigenvector of matrix by using excel, if we have eigenvalue of matrix?
Is there any VB code to obtain eigenvector of matrix?

[MrShorty]

Is there any VB code to obtain eigenvector of matrix?

In the spirit of "let me google that for you" I put "eigenvector VBA" into my favorite search engine and found several pages including:
http://www.wilmott.com/messageview.c...threadid=73707
http://www.real-statistics.com/linea...-eigenvectors/
and many others. If you are looking for someone else's code for performing this task, I would suggest that you put something similar into your favorite internet search engine and pick your favorite proposed solution.

If you are looking for the educational experience of learning to program these routines yourself, let us know where you are stuck and we'll help you as best we can.

[shg]

Consider below simultaneous equations:

x – y = 0
y – x = 0

The answer is: x = y = c and “c” is a constant value.

There is no c in those equations, and the solution is x=y=0.

If the equations were

x – y = c
y – x = c

... then the solution is x=y=c=0

[soleimani1967]

I have not really problem to generate eigenvalue of a matrix and I do not only follow a VB code. In fact, I am wiling to find any easy method by excel to get eigenvector of a matrix when we have its eigenvalue. I think that your links are usefull. Thanks.

[Crooza]

......and the solution is x=y=0.

@shg I agree x=y but isn't x=y =0 just one of an infinite number of solutions?

Infact the above simultaneous equations have two unknowns but as we have only one equation (written different ways) this can't be solved.

[shg]

Yes, sorry -- there is only one independent equation in the first set. The second is a negated restatement of the first.

And the constant c in the second set of equations can only be zero, so it reduces to the same underdefined system as the first.