Reply to topic

Trend line query

bat
Registered Member
Posts
14
Karma
0

Trend line query

Wed Oct 21, 2015 1:47 am
In Calligra Sheets I sort-of worked-out how to use the Trend function which the handbook says does linear regression. However, the resulting points are not in a straight line so I was wondering if I have misunderstood this function or done something wrong.
bat
Registered Member
Posts
14
Karma
0

Re: Trend line query

Wed Oct 21, 2015 2:22 pm
I realised after posting that setting the 'allow offset' parameter to False might sort this out, but if I try that, the results do not make any sense at all.

I am very impressed with some parts of this program like Sort, Filter/Auto-filter, Insert external data, the range of chart styles, etc, and I would love to help make this program even better but my programming skills and experience are not great. I have sent a bunch of bug reports (some more to come) and would happily be proactive in testing the suite.
bat
Registered Member
Posts
14
Karma
0

Re: Trend line query

Mon Oct 26, 2015 7:46 pm
Is anyone there?
bat
Registered Member
Posts
14
Karma
0

Re: Trend line query  Topic is solved

Sun Nov 01, 2015 9:57 pm
I managed in the end - the answer is (as per my other post) to use 'Ctrl+Alt+Enter' instead of just 'Enter' because the result of this function is an array. The trend line now looks fine. Sorry for being a pain.

 
Reply to topic

Bookmarks



Who is online

Registered users: alainroger, Baidu [Spider], Bing [Bot], boudewijn, ChompTheTrike, chrisogilvie, Exabot [Bot], Google [Bot], johssw, jsola, louis94, Majestic-12 [Bot], Sogou [Bot], Yahoo [Bot], Zxy