https://bugs.documentfoundation.org/show_bug.cgi?id=173171
Bug ID: 173171
Summary: EDITING: No function for weighted correlation
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Calc currently lacks a built-in function for weighted Pearson correlation. In
election / demographic analysis, county- or precinct-level data should often be
weighted by population or total votes so that larger units influence the
correlation more strongly. The same need arises in scientific data where
observations have different reliability (inverse-variance weighting).
Calculating such correlations currently requires entering complex mathematical
formulas into multiple cells, inconveniencing users and creating potential for
error. Proposed syntax: WCORREL(DataY; DataX; Weights). As I understand Excel
also lacks such a built-in function, this would offer an advantage for
statistical users.
Actual Results:
have to fill in junk
Expected Results:
had the function
Reproducible: Always
User Profile Reset: Yes
Additional Info:
-
--
You are receiving this mail because:
You are the assignee for the bug.
