|
| Posted by: R9
- Leader [02624472] Fri, Mar 04, 2005, 20:53
Say I have two columns, one for say, 10 pitcher's ERA's, and the other for their Innings Pitched. What I'm looking to do is come up with an average ERA, but based on their IP's of course. What formula would I use to do that? |
| | | 1 | Trip
Sustainer
ID: 13961611
Fri, Mar 04, 2005, 21:17
|
| | | | | | | Pitcher | IP | ERA | RUNS | | | Pitcher 1 | 30 | 3 | 10 | | | Pitcher 2 | 40 | 4 | 17.77777778 | | | Pitcher 3 | 50 | 5 | 27.77777778 | | | Pitcher 4 | 50 | 5 | 27.77777778 | | | Pitcher 5 | 40 | 4 | 17.77777778 | | | Pitcher 6 | 30 | 3 | 10 | | | Pitcher 7 | 30 | 3 | 10 | | | Pitcher 8 | 40 | 4 | 17.77777778 | | | Pitcher 9 | 50 | 5 | 27.77777778 | | | Pitcher 10 | 60 | 6 | 40 | Total ERA | | | 420 | | 206.6666667 | 4.428571429 | | | | | | | | Pitcher | IP | ERA | RUNS | | | Pitcher 1 | 30 | 3 | =(B15/9)*C15 | | | Pitcher 2 | 40 | 4 | =(B16/9)*C16 | | | Pitcher 3 | 50 | 5 | =(B17/9)*C17 | | | Pitcher 4 | 50 | 5 | =(B18/9)*C18 | | | Pitcher 5 | 40 | 4 | =(B19/9)*C19 | | | Pitcher 6 | 30 | 3 | =(B20/9)*C20 | | | Pitcher 7 | 30 | 3 | =(B21/9)*C21 | | | Pitcher 8 | 40 | 4 | =(B22/9)*C22 | | | Pitcher 9 | 50 | 5 | =(B23/9)*C23 | | | Pitcher 10 | 60 | 6 | =(B24/9)*C24 | Total ERA | | | 420 | | =SUM(D15:D24) | =(D25/B25)*9 | | | | | |
|
|
| | | 3 | Guru
ID: 330592710
Fri, Mar 04, 2005, 22:21
|
You can also just take the weighted average of the ERAs, using IP as the weights.
In the example above, the formula for the average ERA is =SUMPRODUCT(B3:B12,C3:C12)/sum(B3:B12)
|
|
| | | 4 | R9
Leader
ID: 02624472
Sat, Mar 05, 2005, 00:35
|
Just what I was looking for. Thanks guys!
R9
|
|
|
|