ExcelBanter - How can I average 2 curves? y=10x+3 and y=11x-2

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I average 2 curves? y=10x+3 and y=11x-2 (https://www.excelbanter.com/excel-worksheet-functions/127515-how-can-i-average-2-curves-y%3D10x-3-y%3D11x-2-a.html)

SuziequeQQ

How can I average 2 curves? y=10x+3 and y=11x-2

I have about 10 to average and I have no idea how to do it. Thanks!!

Bernie Deitrick

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!!

All times are GMT +1. The time now is 11:50 PM.