Re: Description of the LINEST function in Excel 2003
The value TRUE is assigned the last argument if you want to get additional statistics (various sums of squares, R squared, F-statistics or standard errors of regression coefficients, for example). In this case, LINEST must be entered as an array formula. The last argument is optional, if omitted, its value is interpreted as FALSE. The dimensions of the table are five lines by a number of columns equals the number of independent variables plus one if the third argument set to TRUE (if the third argument is not TRUE, the number of columns is equal the number of independent variables). When FALSE is assigned to the third argument in Microsoft Excel 2002 and in earlier versions of Excel, a workaround is necessary.
Dimension 1100 (FMY032J) mini-tower
2.53ghz Intel Pentium 4
80 gig nfts HDD
512 RAM
Main circuit board: Dell 0CF458
BIOS: Dell A00
Display: Intel(R) 82865G Graphics Controller [Display adaptor]
Multimedia: Sound MAX Integrated Digital Audio
Windows XP Home SP2
Bookmarks