How can I average 2 curves? y=10x+3 and y=11x-2
SuziequeQQ,
Add them:
y=10x+3
+ y=11x-2
__________
2y = 21x+1
Then divide by 2:
2y = 21x+1
__ _____
2 2
And get your answer:
y = 10.5x + .5
The same applies for as many formulas as you have, except you would divide by the count of the
formulas.
HTH,
Bernie
MS Excel MVP
"SuziequeQQ" wrote in message
...
I have about 10 to average and I have no idea how to do it. Thanks!!
|