Excel Solver

%3CLINGO-SUB%20id%3D%22lingo-sub-1801350%22%20slang%3D%22en-US%22%3EExcel%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801350%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20use%20Excel%20Solver%20to%20find%20find%20the%20weights%2C%20standard%20deviation%2C%20and%20variance%20at%20a%20specific%20return%25.%20When%20I%20go%20and%20use%20solver%20and%20click%20solve%20the%20parts%20in%20yellow%20beside%20the%20target%20return%20%25%20does%20not%20change.%20Can%20anyone%20help%20me%20fix%20it%3F%26nbsp%3B%20I%20need%20it%20for%20a%20homework%20assignment%20to%20work.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1801350%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801412%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801412%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839774%22%20target%3D%22_blank%22%3E%40madpak2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20must%20be%20something%20missing%20-%20all%20other%20weights%20are%20set%20to%200%2C%20so%20all%20weighted%20calculations%20will%20return%200%20regardless%20of%20the%20values%20in%20Q3%3AZ3.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801461%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801461%22%20slang%3D%22en-US%22%3EI%20went%20and%20changed%20the%20weights%20in%20q3%3Az3%20to%20having%20nothing%20in%20them%20and%20I%20am%20still%20not%20able%20to%20have%20any%20of%20the%20information%20changed.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801548%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801548%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839774%22%20target%3D%22_blank%22%3E%40madpak2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOf%20course%20not%20-%20all%20results%20will%20still%20be%200.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am wanting to use Excel Solver to find find the weights, standard deviation, and variance at a specific return%. When I go and use solver and click solve the parts in yellow beside the target return % does not change. Can anyone help me fix it?  I need it for a homework assignment to work. 

5 Replies
Highlighted

@madpak2 

There must be something missing - all other weights are set to 0, so all weighted calculations will return 0 regardless of the values in Q3:Z3.

Highlighted
I went and changed the weights in q3:z3 to having nothing in them and I am still not able to have any of the information changed.
Highlighted

@madpak2 

Of course not - all results will still be 0.

Highlighted
Then how do I get it to solve for the weights, standard deviation, and variance at a specific return%? I got it to work on another document with just 4 stocks.
Highlighted

@madpak2 

I have no idea.