Column-----> A------- B-------C-------D---------E(adsbygoogle = window.adsbygoogle || []).push({});

Beds------> 21.0-- 181125 - 0.0001 - 95600 -- 11.08405797

Balls------> 180 --- 39255 -- 0.0046 - 17715 -- 81.23041651

Results----> 201---220380 - 0.0009 - 113315 - 103.3501906

sum sum X/Y sum CxD

I have the above problem on a program I am writing and need the mathmatical solution to get the right results row. This program is used in the SAP BW Warehouse software. The program deliveries the above result. It calculates the the result row by the formula below the results row. What I want to get to is for column E to sum to 92.31447 and not 103.350. The program for programmable reasons cannot sum the two rows so I need to derive a formula with the figures above to get to the desired result of 92.31447

Any help will be appreciated. I am just about off my head!!

Cannot get the formating correcthence the ---. Basically I have 5 columns A-E.

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Weighted Averages

Loading...

Similar Threads - Weighted Averages | Date |
---|---|

Weighted average question | Dec 1, 2013 |

Weighted averages in groups with common range | Jul 26, 2012 |

Why a weighted average? | Nov 21, 2011 |

Calculating the Weighted Average of Two Graphs | Nov 14, 2011 |

Weighted average of weights themselves | Oct 7, 2010 |

**Physics Forums - The Fusion of Science and Community**