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
Mah Ray
shared this idea
Thank you for your idea, we need some time to review it.
-
AdminAlexandre
(Admin, ONLYOFFICE)
commented
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.