Bug 114092

Summary:	Confidence interval for regression coefficients
Product:	LibreOffice	Reporter:	Harald Weedon-Fekjær <harald.weedon-fekjar>
Component:	Calc	Assignee:	Dennis Francis <dennisfrancis.in>
Status:	RESOLVED FIXED
Severity:	enhancement	CC:	suokunlong
Priority:	medium
Version:	5.1 all versions
Hardware:	All
OS:	All
Whiteboard:	target:6.2.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	111310

Description Harald Weedon-Fekjær 2017-11-27 12:29:55 UTC

Description:
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.