In the sample excel file(extract from .zip file) I have explained the calculation of contribution and R-Square.
I need to solve 2 problems by adjusting the Multiplication factor or Coeff.
I need to make sure actual contribution of current year and Previous year will be within expected Current...
Re: How to solve this rquation
Sorry it is linear equation only, But when i convert all the variables are coming as zero. Plz advice what i am doing wrong.
I consider Any as zero. So I am ignoring the same from the above equation.
If I simply the equation I will get following result...
329x / (329x + 276y + 340z + 332Any) =0.5
276y / (329x + 276y + 340z + 332Any) =0.1
340z / (329x + 276y + 340z + 332Any) =0.2
We need to figure x,y,z and Any value. "Any" don't have any equation, so it can be any value.
Anyone can help me how to solve the above problem?
Thanks