I have 5 values of X and 5 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.
Ex: X Y Z= (n*sigma (XY)-(sigma X) (sigma Y)/[root of (n sigma X*X -(sigma X)*(sigma X)) * root of (n* sigma Y*Y - (sigma Y)* (sigma Y))]
Please help.
Maximize Z by changing what?
Posting a workbook is more likely to attract useful assistance.
Entia non sunt multiplicanda sine necessitate
Sir, 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 i have Z value = 0.852, i have to set value of X and Y such that Z is maximum but less than 1.
please help.
.
Here is your file.
Nice job, yurttas.
Thanks, shg.Originally Posted by shg
I know it is a month old, but last Friday's thread caused me to notice that the given formula is simply the Pearson correlation coefficient (https://en.wikipedia.org/wiki/Pearso...on_coefficient ). Thus, yurttas's excellent formula could be rewritten as =PEARSON(B2:B5,C2:C5)
Good observation, MrS. Or
=CORREL(B2:B5, C2:C5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks