i have an excel file containing 2 graphs [R & V], and their x & y coordinates in 4 separate lists [the X coordinates of R, the X coordinates of V, the Y coordinates of R, the Y coordinates of V](adsbygoogle = window.adsbygoogle || []).push({});

i need to calculate the X & Y coordinates of a 3rd graph through a weighted formula that takes 55% of the R coordinates into account + 45% of the V coordinates into account

the tricky part is that R & V start and end at different X coordinates...

for example R starts at x=0 and ends at x=10

while V starts at x=5 and ends at x=15

can anyone help define a better formula for this?

here is what i have so far:

X = (Xr+Xv)/2

Y = (Yr)*0.55 + (Yv)*0.45

the problem with these equations is they dont take into account the different start and end positions of the two graphs

thank you for any help in advance! best regards!

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

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

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

# Calculating the Weighted Average of Two Graphs

**Physics Forums | Science Articles, Homework Help, Discussion**