Oct 20 2020 01:49 PM
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.
Oct 20 2020 02:06 PM
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.
Oct 20 2020 02:28 PM
Oct 20 2020 03:19 PM