Forum Discussion

timl's avatar
timl
Regular Visitor
8 years ago
Solved

Ratio Line

 

I'm trying to understand the new features Ratio Line and Symmetry Shading. I think I understand that the latter is a way to adjust for differences in scale between the X and Y axes. But I don't understand the Ratio Line and how it differs from the Trend Line.

 

Can Ratio Line be expressed in a formula - as a function of x and y?

  • timl's avatar
    timl
    8 years ago

    Okay, I think I understand. It's the line that goes thru the origin and the point equal to Sum(Y)/Sum(X). So it allows you to compare individual data point ratios with the overall average ratio.

2 Replies

  • timl's avatar
    timl
    Regular Visitor
    8 years ago

    Okay, I think I understand. It's the line that goes thru the origin and the point equal to Sum(Y)/Sum(X). So it allows you to compare individual data point ratios with the overall average ratio.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi timl, 

      You're right, ratio if ratio line is equals to SUM(Y)/SUM(X). Please mark the right reply or help reply as answer, so that more people will benefit from here.

      Best Regards,
      Angelia