| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookings for optimal coefficient
I have a set of numbers A1:A10.
I have a formula A1:A10 ~ x*B1:B10 + y*C1:C10 + z*D1:D10 How do I find the optimal set of x,y,z to give the result closest to A1:A10 for every B1:B10,C1:C10,D1:D10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trendline coefficient accuracy | Excel Discussion (Misc queries) | |||
| spearman correlation coefficient | Excel Discussion (Misc queries) | |||
| Coefficient of variance | Excel Worksheet Functions | |||
| formula for "coefficient of variation" | Excel Worksheet Functions | |||
| Correlation Coefficient Issue | Excel Worksheet Functions | |||
Threaded Mode
