Solver Problem
Solver Problem
I have 4 values of X and 4 values of Y, using these values of X and Y, single value Z has been calculated in Column C with the help of formula. Now I want to maximize Z value in column C using solver. How to select for multiple column?
I have attached excel file and there is an image of formula for calculating Z or r, as I am unable to write that formula in excel. We have to maximize Z value by changing X and Y value. currently Ihave Z value = 0.852, I have to set value of X and Y such that Z is maximum but less than 1.
Please help.
Answer:
The Formula should be like this:
=(COUNT(A2:A5)*SUMPRODUCT((B2:B5)*(C2:C5))-SUM(B2:B5)*SUM(C2:C5))/SQRT((COUNT(A2:A5)*SUMSQ(B2:B5)-SUM(B2:B5)^2)*(COUNT(A2:A5)*SUMSQ(C2:C5)-SUM(C2:C5)^2))
Please have a look at enclosed file:
Son Yorumlar