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:

excel-workbook

 

 

 

You may also like...

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

Şu HTML etiketlerini ve özelliklerini kullanabilirsiniz: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>