To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112324 Issue #|112324 Summary|Incorrect LINEST calculation Component|Spreadsheet Version|OOo 3.2 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|aguelzow
------- Additional comments from [email protected] Fri Jun 11 23:47:26 +0000 2010 ------- I will be attaching a sample file with a LINEST calculation. Note that the 3rd argument is 0, ie. the regression line is known to pass through the origin. OpenOffice calculates a F value of 1023201.45304532 I believe this to be incorrect. According to R the F value ought to be 2.03e+06. See: > x <- c(1,2,3,4,5,6,7,8,9,10) > y <- c(6.666692,20.62386,52.86109,106.8126,188.8089,304.7688,461.6924,664.7059,917.1942,1230.271)> summary(lm(formula = y ~ 0 + x + I(x^2) + I(x^3))) Call: lm(formula = y ~ 0 + x + I(x^2) + I(x^3)) Residuals: Min 1Q Median 3Q Max -0.77402 -0.37157 -0.06219 0.20797 1.24294 Coefficients: Estimate Std. Error t value Pr(>|t|) x 2.301233 0.372093 6.185 0.000452 *** I(x^2) 2.128175 0.110687 19.227 2.56e-07 *** I(x^3) 0.994342 0.007846 126.732 5.02e-13 *** --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Residual standard error: 0.7195 on 7 degrees of freedom Multiple R-squared: 1, Adjusted R-squared: 1 F-statistic: 2.03e+06 on 3 and 7 DF, p-value: < 2.2e-16 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
