Skip to content
← Your Voice Matters

I suggest you ...

Your Voice Matters: Document Editors

Categories

(thinking…)

Trend lines in spreadsheets

In the spreadsheets, I would like to have the possibility to display the trend lines as the right equation of an affine function y=mx+p
(with m=cov(X;Y)/var(X) and p=MEAN(y)-a*MEAN(x))

2 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Mah Ray shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Mah Ray commented  ·   ·  Report

    Hello.
    Firstly, I want the compatibilty with Microsoft format
    Secondly, I want to create the trend line (1st degree and 2nd) with ONLY OFFICE. The display also generate the equation of the function. For example, since ONLY OFFICE, I can display and show y=2x+2 with x=0;1;2 and y=2;4;6. It is very usually used in science for high school and university.

  • AdminAlexandre (Admin, ONLYOFFICE) commented  ·   ·  Report

    Hello!
    Please clarify if you want to display the trend lines using the correct equation of an affine function created in another editor, or if you want to create and display it in the ONLYOFFICE editor.