https://issues.apache.org/ooo/show_bug.cgi?id=123523
Bug ID: 123523
Issue Type: DEFECT
Summary: 504 error when using more than 6 data_x columns with
LINEST function
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
When adding a 7th column to the known X columns, LINEST returns error 504.
Price Sq.Ft. Lot Beds Baths Fireplace Sprinkler Fence
$/ft.
Mom's 329,460 3068 0.37 3 2.0 0 1 0 107.39
Comp 1 330,000 2516 0.50 5 3.0 1 0 1 131.16
Comp 2 268,000 3196 0.34 4 2.5 1 0 1 83.85
Comp 3 366,000 3206 0.28 4 3.5 1 0 0 114.16
Comp 4 400,000 3524 0.27 4 3.0 1 1 0 113.51
Comp 5 415,000 3083 0.39 4 2.5 1 0 0 134.61
Comp 6 330,000 2789 0.20 3 2.5 1 0 1 118.32
LINEST(B2:B8;C2:I8;1;1) returns 504 error
LINEST(B2:B8;C2:H8;1;1) returns the array
183493.56 590790.08 283637.18 -526802.04 3106210.42 73.54
-215834.41
0 0 0 0 0 0 0
1.00 0 #N/A #N/A #N/A #N/A #N/A
#N/A 0 #N/A #N/A #N/A #N/A #N/A
14907883622.4346 0 #N/A #N/A #N/A #N/A #N/A
(side note: R squared is probably not 1.00 as the model suggests)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
