Bug 114092 - Confidence interval for regression coefficients
Summary: Confidence interval for regression coefficients
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
5.1 all versions
Hardware: All All
: medium enhancement
Assignee: Dennis Francis
Whiteboard: target:6.2.0
Depends on:
Blocks: Data-Statistics
  Show dependency treegraph
Reported: 2017-11-27 12:29 UTC by Harald Weedon-Fekjær
Modified: 2018-07-03 08:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Harald Weedon-Fekjær 2017-11-27 12:29:55 UTC
Nice to see linear regression in the open source Libreoffice menu. Linear regression in an office package is obviously a winner for teaching, but one key part is missing; Confidence intervals for the regression coefficients :-( In almost any data analysis quantification of the uncertainty is key, telling us if the findings might be only random noise. Microsoft has a confidence interval option in their Excel analysis toolpack - Is it possible to also add it in Libreoffice?

Best regards,
Harald Weedon-Fekjær, Researcher/biostatistician PhD

Actual Results:  
Regression coefficients without any confidence intervals 

Expected Results:
Regression coefficients with confidence intervals 

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 Kevin Suo 2017-11-28 06:02:08 UTC
Set as NEW as it is a valid feature request.
Comment 2 Dennis Francis 2018-07-03 08:23:44 UTC
The commit http://cgit.freedesktop.org/libreoffice/core/commit/id=b7a02f2bb66b990289eb7f4dc80069d1545179a4 in master adds support for multivariate regression. This also adds confidence intervals for each estimate (slopes and intercept). The confidence level is configurable (default is 95%). All these features are available in the latest dev builds and will appear in 6.2 release.