Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coefficients of an equation
I am trying to write a VBA code to figure out the coefficients of an equation.
Y = A + B*X1 + C*X2 + D*X3 So if I have an equation of this form Y = 2 + 3*X1 + 4*X2 + 5*X3 (values of X1, X2, X3 are known and so Y can be calculated) I want to know that A = 2, B = 3, C = 4 and D = 5 I can obtain the coefficient A by putting X1, X2, X3 = 0 and this would give Y = 2 which is the value of A. I don't know how to find the other coefficients. If it is not possible to find the coefficients, how can I take the square of each term in the equation. Y = (2)^2 + (3*X1)^2 + (4*X2)^2 + (5*X3)^2 Just to sum up, 1) I want the user to enter a function in the form of Y = A + B*X1 + C*X2 + D*X3 2) then the user will enter the values of X1, X2, X3 and this would enable us to calculate Y 3) then we want to calculate Y1 = (B*X1)^2 + (C*X2) ^2 + (D*X3) ^2 PLEASE HELP IF YOU CAN€¦. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Trendline Coefficients | Excel Discussion (Misc queries) | |||
coefficients of polynomial | Excel Discussion (Misc queries) | |||
Trend Line Equation Coefficients | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Trendline coefficients | Charts and Charting in Excel |